Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
Talk to Sales: 877-683-3280
Hours
Mon - Fri, 5am - 6pm PST
Sat - Sun, 7am - 4pm PST
Product support & help
Need help signing in?
A
anusoma
February 5, 2020
Question

Customer Open Balance report for prior month

  • February 5, 2020
  • 1 reply
  • 10 views

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

1 reply

Angelyn_T
Angelyn_TModerator
Moderator
February 5, 2020

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!

A
anusomaAuthor
February 5, 2020

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!

Kayla H
Kayla H
February 5, 2020

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.

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.
Terms & ConditionsAccessibility statement