cancel
Showing results for 
Search instead for 
Did you mean: 
Parker28
Level 1

Received payments report that shows the open balance that was paid?

Hello,

I use Quickbooks Online and was wondering if there is a way to create a report for my needs.

The "Invoices and Received Payments" report is close to what I need, but when I add the "Open Balance" column to the report, it shows me 0$ because it is reporting the remaining balance of the invoice AFTER the payment.   I am needing the report to show me the open balance right before the payment was received and applied. I have invoices that are paid in segments, so this would be very helpful.

1 Comment 1
MariaSoledadG
QuickBooks Team

Received payments report that shows the open balance that was paid?

Let me provide a few of information about the report that shows the open balance before payment is made, Parker28.

 

The Invoices and Received Payments report will always show a zero open balance since the report is designed to show that payment was already applied to the invoice amount. You'll want to manually locate the invoice under the Transaction Type column if you want to determine the amount of the invoice before payment was made.

invoices and receive payments.PNG

At the same time, you can also run the Invoice List report, then customize it to show the Open Balance and A/R Paid column to show all the status of your invoices. I've added a screenshot for your reference.

 

  1. On the Invoice List report, click Customize.
  2. Click Change columns and tick the Open Balance and A/R Paid box.
  3. Click Run report.
    invoice list.PNG

 

Furthermore, QuickBooks Online provides you the flexibility to generate reports to know the aspects of your business. Learn how to export them in case you'll want to consolidate two reports at the same time. You can read this article for more details: Export Your Reports To Excel From QuickBooks Online.

 

Drop your reply below if you have further questions about running reports in QuickBooks The Community is always right here to assist you 24/7.

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us