Paid Invoices on Deposit Detail Report

by Machel
(Oregon)

Hi, how can I get the invoice that has been paid to show up on the check deposit detail report? I know it can be done.

Jennifer replies:

I spent quite a bit of time fiddling with different reports, and fiddling with completely customized reports, to try to get this detail for you. If it can be done I am at a loss as to how. So I don't think it can be done, and I have a theory as to why.

My theory is that a certain customer payment can be for any amount. It can be for the exact amount of the invoice, or more, or less. Or it can be for no invoice at all - a prepayment, if you will. Customer payments recorded in the Receive Payments screen are credits to accounts receivable, regardless of whether there is an invoice to apply them against or not.

Again this is just my theory. But it seems to me that this credit to A/R is then, under the surface, applied against a particular invoice, if there is one to apply it against. This seems to be a separate internal process in QB, although I will be the first to admit that it does not appear that way when recording it.

We can definitely see the credit to A/R in the Deposit Detail report. It's located in the Split column. But to pull the detail behind that credit...

This is where my theory comes into play. Since the payment could be for a particular invoice...

Could be for the full amount of that invoice...

Could be a partial payment for that invoice...

Could be for more than one invoice...

Or could be for no invoice at all....

Well perhaps this is why we cannot see the detail behind the A/R credit located in the Split column on the Deposit Detail report.

Sorry that I couldn't answer your question directly. But I'm glad you asked, so thanks.



Click here to post comments

Return to QuickBooks Q&A.