QBO user - I'm looking for a report that shows how I applied cash in a deposit. For example, if a customer sends $1,000 for 4 invoices, I'd like a report showing the payment, invoices applied to, and a total. I cannot seem to get the invoice number to populate on any reports. This seems so intuitive. Our auditors are asking for the payment detail (what invoices cash was applied to) on a couple of deposit selections. All I can do is "print screen" from editing the deposit, then clicking on the customer transactions inside the deposit, which shows the check marks selecting the invoices to pay. I can run a report showing the total crediting AR and bank account by customer, but there's no invoices paid detail. We'd also like this report internally for approval accounting controls. Any ideas, community? I'm stumped.
Thank you for reaching out to the Community. Your best bet is to look at the Transaction List by Customer. If you're looking to filter through these invoices and payments for each customer and the total.
This solution seems to include invoices created on my selected date, as well as payments. I'm strictly looking for payments. I think the "Invoices and Received Payments" report will show my payment detail; it's just missing a grand total which we could easily compare to the deposit total. Only filter avail is customer.
I appreciate the details and screenshot you've provided, Jvance1.
Since the option to show the deposit total in the Invoice and Receive Payments report is currently unavailable, as a workaround, you can pull up and run the Deposit Detail report, export them into Excel and combine the information from there.
Also, the NUM column on the Invoice and Receive Payments report is for Invoice no. You might want to open your transaction and verify its number.
I recommend customizing the report to get the specific details you need. You can also memorize it to save its current customization settings. It serves as your record and helps you quickly access it for future use.
You can always get back to me if you have any other concerns or have follow-up questions about QuickBooks. I want to make sure you're all set and got you covered. I'm here if you need further guidance. Have a nice day!