Good day, paulcolcombe.
I can share to you about Accounts Payable Summary report and Balance Sheet report in QuickBooks Online (QBO).
The AR Aging Report and the Balance Sheet don't normally match. This is because the A/R Aging Report defaults to Current. Alternatively, you can customize the Accounts Payable Aging report to the As of Report Date.
The report will then agree with the Balance Sheet as long as the Balance Sheet follows the accrual reporting method for the same date range.
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 matches.
- 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 amount for Accounts Payable.
You also can open a Journal Entry, this might be the cause of the discrepancy, and make changes if necessary.
I also have some additional articles about managing a wide range of reports in QBO:
Get back to me if you need further questions while managing reports. I'll be around and ready to help. Enjoy the rest of the day!
