QuickBooks HelpQuickBooksHelpIntuit

Discrepancies between your Balance Sheet and Accounts Payable Aging report

SOLVEDby QuickBooks6Updated 1 month ago

A discrepancy between your Balance Sheet and your Accounts payable aging report could be the result of future payments made against current bills.

The Accounts payable aging report, like other Accounts payable detail reports, doesn't include bills with a status of Paid, so, while they may seem to disagree, both the Balance Sheet and the Accounts payable aging detail reports are correct because the bill is no longer open.

If necessary, you can generate a Supplier Balance report that agrees with the Balance Sheet. To do this, customize the Supplier Balance report to run as of the date on the Balance Sheet, and change its Aging method to Report date.

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.

For more information: Follow these steps to match mismatched Aging Reports in QuickBooks Online.

Was this helpful?

You must sign in to vote, reply, or post

Sign in for the best experience

Ask questions, get answers, and join our large community of QuickBooks users.