I need to run a report showing ALL invoices for my clients, including future invoices since we bill 2 weeks in advance. I can do this in QB's Desktop but none of the reports I've tried online will show me open balances past today's date. Any idea on what report to run?
I want to help you run the report you need to show open balances past today's date.
I've replicated this on my end, and I was able to show the open balances of the future invoices. You'll need to make sure the reporting period is selected correctly to include the invoices you want to show in the report.
You can either choose the Custom or All Dates option under Report period to ensure the invoices will show. Let's run the Customer Balance Detail report and make sure the Report period and Aging method are correct.
On the left navigation bar, click Reports.
Run the Customer Balance Detail report.
Select the correct Report period and Aging method.
Go to Rows/Columns, select Change columns.
Add Open Balance.
Click Run report.
If you're still unable to show the open balance for future invoices, please let me know. I encourage you to add a screenshot of your sample invoice (future) and the report.
I'll be waiting for your response about the report you need. You can reach out to me by clicking the Reply button below.