It's important that your Aging accounts match and I'd be glad to help. QuickBooks Online offers powerful reports which help you streamline your business and get ahead with your work.
If your Balance Sheet, Trial Balance, and Accounts Receivable Aging Reports don’t match up, it’s usually because the Aging Report defaults to Current.
Here's how to change the aging method to report the date:
Open the A/R Aging report.
Select Customize.
Select Aging.
Under Aging Method, choose Report Date.
Select Run report.
After finishing this process, your report will balance to the Balance Sheet/Trial Balance.
Tip: Be sure that the Balance Sheet/ Trial Balance is run using Accrual as the reporting method.
If you're still having problems, consider the following items:
If a bill has been paid today it won’t show.
Make sure the date range on the reports match.
Be sure you're comparing the correct numbers.
On your A/R Aging report you want to match the Open Balance to your Balance Sheet / Trial Balance amount for Accounts Receivable.
Give this a try and if you have questions, please contact our support team using this link. Let me know if you have other questions by leaving a comment below. I'll be on standby.
Need QuickBooks guidance?
Log in to access expert advice and community support instantly.