A/R or A/P Ageing Summary Report totals do not match the Balance Sheet

Legacy KB ID: 4612

Why don’t the totals in the Ageing Summary Reports for Accounts Receivable and Accounts Payable match the balances in the Balance Sheet?

There are a number of reasons this difference may happen:

1. Balance Sheet is reporting on a Cash Basis; Ageing Summary Reports always report on an Accrual Basis;

2. Date ranges are different.

Care: All Dates setting will show transactions that are dated forward of the current date;

3. Corruption in the company file.

Solutions

Set the Balance Sheet to report on an Accrual basis:

1. Open the Balance Sheet Report;

2. Modify > Report Basis > Accrual > OK

Check that the date range is the same on both reports.

If there are transactions for a future date, examine the transaction for accuracy.

Rebuild and verify the company file:

1. File > Utilities > Rebuild

2. File > Utilities > Verify

3. If an error is found, examine the QBwin.log file:

a. Ctrl+1 > Ctrl+2 > Open File > double click on QBwin.log

b. Scroll to the bottom of the file.

c. Examine errors and make necessary corrections.

4. File > Utilities > Verify to confirm that no errors remain in the file.

Need more help?