I'm having problems with the unpaid bills report in Quickbooks, for some reason its not excluding the credit notes from the report when I'm offsetting these against the invoices, therefore the supplier balance on the unpaid bill detail report is wrong and different to the balance on the supplier account.
I just wondered if anyone else had come across this problem and what they did to resolve it?
Hi Elaine
I dont use quickbooks (other than for a local Scout group!), but when you say offsetting against invoices - do you actually apply the credit note to an invoice as this in most software (I think) needs to be done to lose them from the list. When I say 'apply' the software may use different terminology so it might be pay/apply/allocate or some such.
Hoping that might help.
Failing that - a shout out to Stuart or Amanda who are regular users of QBs.
__________________
Joanne
Winner of Bookkeeper of the Year 2015, 2016 & 2017
Thoughts are my own/not to be regarded as official advice,which should be sought from a suitably qualified Accountant.
You should check out answers with reference to the legal position
Hi, I haven't come across this before, like Joanne says I apply them to invoices which clears them off from being outstanding/unallocated. Unless there is a background setting maybe? I'm not sure.
It is really odd, as I am applying the invoice's to the credit notes, but for some reason this results in the invoice being removed from the unpaid bills report, but not the credit note.
So if a supplier gives us two invoice's for £500.00 and then a credit note for £500.00 which I offset against one of the invoices the supplier balance will show as £500.00 but the unpaid bills report will show a balance of zero as it'll show the remaining invoice and the credit note !!
I am contemplating re-installing the software to see if that resolves it as I'm sure it's probably a problem with the software, but only wanted to do this is that was my only option.
Not being a Quickbooks user, I'm wondering how customisable the reports are - if it's anything like Sage in that respect, the answer is 'very' and you can apply all sorts of filters and conditions to individual items on the report.
It might therefore be that the report is set up such that invoices are filtered out when paid/allocated/matched off (or whatever term Quickbooks uses). This makes sense, since it's an unpaid bills report - and perhaps that setting hasn't been applied to credits on the report.
That would explain the behaviour you're seeing (though it's always possible there's another cause). However, if that's the cause, how you'd change it is another matter.
__________________
Vince M Hudd - Soft Rock Software
(I only came here looking for fellow apiarists...)
