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

Customer Open Balance report for prior month

How do I print a customer open balance report for prior month, however the payments should reflect upto today or current dated. 

4 Comments 4
Angelyn_T
QuickBooks Team

Customer Open Balance report for prior month

Hello, @anusoma.

 

You can create a statement for your customer then print it so you'll be able to see the open balance of your customer for the previous period. Just ensure that the payments are recorded on the current date or month.

 

To create and print a statement:

 

  1. Tap on Customers Statement from the Customers menu.
  2. Under the Create Statements window, select a statement date, statement period, and customers.
  3. Click on the Print button beside E-mail.
  4. Choose Print under the Print Statement(s) window.

 

Also, you can run the Customer Balance Detail report to see the invoice and payment date.

 

  1. Select Customers and Receivables from the Reports menu, then Customer Balance Detail.
  2. Customize the report's period and make the necessary customization you want by clicking on the Customize Report button.
  3. You can now view the invoice date and its balance as well as the date of the payment. If you wish to print the report, tap on the Print button beside Memorize.

For additional reference about running and customizing reports in QuickBooks Desktop, you can read this article: Understand reports.

 

As always, feel free to read out help articles in case you need tips and related links in the future.

 

Let me know if you have any other questions and if there's anything you need assistance with. I'm always here to help. Have a good day!

anusoma
Level 1

Customer Open Balance report for prior month

Hi,

Iam sorry I should have been more precise. I wanted to print a Customer open balance report for Dec 31,2019 and I want the payment made up to January 31 of 2020 to reflect on the report. 

All I did was I took the customer open balance report up to Jan 31,2020 and exported to EXCEL and I manually DELETED the Invoice posted for January 2020 for all clients, and left only December and prior month invoice left in the report and presented to my boss. Its just that my boss wants to see how many clients are owing from December and prior month, and doesn't want to see January invoice reflect on it. 

You may ask me to print the report upto December instead, but the report will not show the payment made in January for December and prior Invoices and that is the reason I want January payment to reflect on my Customer open balance report. Make sense!

anusoma
Level 1

Customer Open Balance report for prior month

Hi

 

Thanks, 

However I need to print a customer open balance report upto Dec 31 and I want the payments made for any invoices pertaining to December or prior month to reflect on the report.

There must be a way to do this. However, I did export Customer open balance report upto Jan31st and exported to EXCEL and manually delete all invoices for January and left December and prior invoice. I need to print upto Jan in order to show the payments made for Dec invoices in Jan. 

 

Kayla H
QuickBooks Team

Customer Open Balance report for prior month

Hello, @anusoma.

 

I can see what you're needing is a report to reflect the open invoices for December, but you also need to see the payments in January made on that invoice as well. Please correct me if I'm wrong.

 

In this case, I suggest creating a Transaction Detail Report in QuickBooks Desktop. This report you can build from the ground up and include all the information you're needing. I have gone through to create this report in my test file — this report demonstrates the required options in this report.

 

 

The images above are just examples to get this report started. Check out Customize reports in QuickBooks Desktop for further instructions on customizing this report.

 

If there's anything else I can assist with, let me know. I'm here to help you at any time.

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

Need to get in touch?

Contact us