Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Is there a report to show the original invoice amount and the payments applied to that invoice by the invoice number for a particular customer?
Solved! Go to Solution.
Yes! There is. @accountingnwt. I can show you the report you need to pull up in QuickBooks Online.
Reports show you the best picture of your company. It shows your data on your sales and expenses.
Since the data you need to view consists of the invoice number, invoice, payment applied, and the customer name, I recommend pulling up the Invoice and Received Payments. This way, it will let the data show on your screen. We'll have to customize the file a bit.
See the result below:
Pick this article for additional insight into personalizing your report in QuickBooks Online.
Visit this article for further information on how to keep track of your client's account growth: QuickBooks Help Articles. It includes topics about account management, banking, and expenses and vendors, to name a few. You can click the + More topics button to view other selections.
Please feel free to remark with your response. I'm excited to provide more information on importing and exporting-related matters. Have a great day.
Yes! There is. @accountingnwt. I can show you the report you need to pull up in QuickBooks Online.
Reports show you the best picture of your company. It shows your data on your sales and expenses.
Since the data you need to view consists of the invoice number, invoice, payment applied, and the customer name, I recommend pulling up the Invoice and Received Payments. This way, it will let the data show on your screen. We'll have to customize the file a bit.
See the result below:
Pick this article for additional insight into personalizing your report in QuickBooks Online.
Visit this article for further information on how to keep track of your client's account growth: QuickBooks Help Articles. It includes topics about account management, banking, and expenses and vendors, to name a few. You can click the + More topics button to view other selections.
Please feel free to remark with your response. I'm excited to provide more information on importing and exporting-related matters. Have a great day.
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.
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:
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:
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!
Hi there,
This report is kind of what I need, but if I have a payment that I partially apply across multiple invoices, I cannot retrieve that data. It will tell me the total payment number and the invoice portions show to invoice amount, not the amount of the payment applied against that invoice.
For example
2024-04-18 Payment 371006 86.00 Store Sales
2024-04-17 Invoice 1256 400.00 Store Sales
2024-04-16 Invoice 1254 410.00 Store Sales
In this example, there is no way to know how the $86 was allocated without drilling down into each payment.
I would like to get a non-grouped list of payments that have been put against each invoice number. Or even change this report to show the allocation rather than the invoice total.
Here is what I would ideally like to see:
2024-04-18 Payment 371006 43.00 Store Sales 1256 Visa
2024-04-18 Payment 371006 43.00 Store Sales 1254 Visa
Hi there,
This report is kind of what I need, but if I have a payment that I partially apply across multiple invoices, I cannot retrieve that data. It will tell me the total payment number and the invoice portions show to invoice amount, not the amount of the payment applied against that invoice.
For example
2024-04-18 Payment 371006 86.00 Store Sales
2024-04-17 Invoice 1256 400.00 Store Sales
2024-04-16 Invoice 1254 410.00 Store Sales
In this example, there is no way to know how the $86 was allocated without drilling down into each payment.
I would like to get a non-grouped list of payments that have been put against each invoice number. Or even change this report to show the allocation rather than the invoice total.
Here is what I would ideally like to see:
2024-04-18 Payment 371006 43.00 Store Sales 1256 Visa
2024-04-18 Payment 371006 43.00 Store Sales 1254 Visa
Hi there,
This report is kind of what I need, but if I have a payment that I partially apply across multiple invoices, I cannot retrieve that data. It will tell me the total payment number and the invoice portions show to invoice amount, not the amount of the payment applied against that invoice.
For example
2024-04-18 Payment 371006 86.00 Store Sales
2024-04-17 Invoice 1256 400.00 Store Sales
2024-04-16 Invoice 1254 410.00 Store Sales
In this example, there is no way to know how the $86 was allocated without drilling down into each payment.
I would like to get a non-grouped list of payments that have been put against each invoice number. Or even change this report to show the allocation rather than the invoice total.
Here is what I would ideally like to see:
2024-04-18 Payment 371006 43.00 Store Sales 1256 Visa
2024-04-18 Payment 371006 43.00 Store Sales 1254 Visa
Thanks for elaborating on your concern regarding your invoice report, DW-000000.
When running an Invoice and Receive Payment report in QuickBooks Online (QBO), it won't show the ungrouped list of payments allocated to the two invoices. As a workaround, you can check in the Customer tab to see the amount due to each invoice. I'm here to guide you.
Moreover, to make the most out of your reports, I suggest checking out these informative guides:
Should you have an additional concern regarding your invoices in QBO, please post them here in the Community.
Hi, My main issue is not the grouping, but rather that it does not show what was paid on each invoice. This is a real example:
For example
2024-04-18 Payment 371006 86.00 Store Sales
2024-04-17 Invoice 1256 400.00 Store Sales
2024-04-16 Invoice 1254 410.00 Store Sales
The payment was $86, but the invoices show the total invoice amount, not the amount that was paid on each invoice. So I cannot see how the $86 was split across the two invoices. It might have been 50%-50%, or it could have been 30%/70%. When you drill into the payment screen it shows the detail about the amount on each invoice. I want that data in a report, but I cannot find it anywhere.
Here is what I would ideally like to see, where the amount is the amount split across the invoices.
2024-04-18 Payment 371006 23.00 Store Sales 1256 Visa
2024-04-18 Payment 371006 63.00 Store Sales 1254 Visa
Also, I'm sorry about the triplicate post. The fact that there were strange errors and then my post did not show up immediately had me doing it over and over
I know a way for you to see the payments applied to your invoices, DW-000000.
Before we proceed to our next steps, please know that if you select multiple invoices as you record the invoice payments, it will combine the payment amount when you run the report. As an alternative, you can export your report and manually break down the details in your Excel. For future transactions, please make sure to record the invoice payments individually.
If you want to see the payment entry and the invoice that includes it, you can consider pulling out an Invoice and Received Payments report. On the other hand, if you only wish to view the payment transactions, we can run a Transaction List with Splits report.
Here's how:
You can click the Payment word under the Transaction Type column to see the full details of the transaction.
For more information about customizing your reports, kindly refer to these materials:
You can also refer to this article if you'd like to print, export, or email your reports and use them outside QuickBooks: Run reports in QuickBooks Online.
Feel free to tag and share your questions with us, DW-000000. We'll gladly help you find and provide a resolution to your concern.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here