Payments applied to invoices

Christine,

Thanks for the information. It helps me to match invoices with payments. It groups the payments near the invoices.

Jo Ann

Thanks for getting back with the Community, accountingnwt.

I'm happy to hear ChristineJoieR was able to help you find a report that shows your original invoices amounts and which payments are applied to invoices by invoice numbers.

I've also included a detailed resource about working with reports which may come in handy moving forward: Reports included in your subscription

Please feel welcome to send a reply here or create a new thread if there's ever any questions. The Community's always here to help. Have an awesome day!

As of today, there is no Invoices & Received Payments report in qbo.  They have removed the only report where you can track the application of your payment to a corresponding invoice.

Very frustrating as their "patch" report instructions do not work.  I've tried the "Cash Receipts" journal instructions as well as the "Customer Balance Detail" report.  Which, by the way, does not offer selection of transaction types in the filter.  As a Quickbook Pro, I'm astonished at the nonsense reports versus the needed reports.

Please get someone in your tech department that actually uses QB's and knows what reports we, as accountants, need.

@ablasco 

I have QBO Advanced & just ran that report.  It's located under the "Who Owes You"  section

@ablasco 

I have QBO Advanced & just ran that report.  It's located under the "Who Owes You"  section.

Hopefully, this report is what you are looking for!

Every time i try to access Invoice and Received payment

Hello there, @Kfagan41. Let's do some troubleshooting steps for you to access the invoice and receive the payment report. 

First, let's ensure you're connected to a strong connection. If the issue continues, let's open your QuickBooks account in a private window to rule out browser-related issues. Here are the keyboard shortcuts:

• Google Chrome and Microsoft Edge: Ctrl+ Shift + N
• Mozilla Firefox: Ctrl + Shift + P
• Safari: Command + Option + P

If you can successfully access the report, return to your regular browser and clear your cache. Occasionally, the accumulated cache and cookies in the system can become outdated or corrupted, leading to unexpected behaviors. You can also switch to other installed supported browsers, which is a good alternative.

After generating the Invoices and Received Payments report, you can customize and save the customization process by memorizing it.

I'm here available to help you, @Kfagan41. Please do not hesitate to return here if you require further assistance generating reports in QuickBooks Online. 

This is great information, thank you.  Is there a way to run this report but have it also list the unpaid invoices as well with a running account balance?  Basically like an account transaction statement, but it pairs the payment to the invoice.

I understand that you need assistance in running reports for account transaction statements that include unpaid invoices, @nhopper.

To achieve this, I recommend running two separate reports and then exporting them to an Excel file. After that, you can combine the two transactions to get the desired result. To ensure that the unpaid invoices show up on the reports, you just need to follow the steps below:

1. Go to the Report tab, and find the Invoice and Received payment in the Search bar.
2. Sort the dates and other details. 
3. Press the Customize button in the upper left to change the column.
4. Then, navigate to the Rows/Columns dropdown and put a checkmark on the Customer checkbox and A/R Paid to show the unpaid invoices.
5. Hit Run Report once done.

For future reference, here's an article on how to reconcile in QuickBooks Online: How to reconcile your accounts.

I would love to hear from you! Feel free to leave a comment below if you have any questions about running your reports. Have a fantastic day!