How to Find a Variance Between a Trial Balance and a Listing Report

Modified on Tue, 08 Nov 2022 at 12:51 PM


Sometimes users will see balance differences when comparing a backdated listing such as a Customer Aging or Vendor Aging report to a trial balance account.  In most cases these differences are caused by data entry errors.  


How you find the differences is the same process for any accounts. What you may need to do to correct it may be different depending on the situation.


Tracking down the errors and correcting them requires some investigation and work, but is a necessary and important part of any period end process for companies.


How to Find the Differences


Step 1 - Establish a Starting Point


When were they last in balance?


  • Run a Trial Balance and an aged report (Customer or Vendor) and compare the balances until you can confirm the last date they were balanced. This is a good starting place.
  • You can run the backdated aging reports for any date, and compare to the Detailed Trial Balance totals for each day, to find the date the error occurred.


For example, if there is a difference between the Accounts Receivable Trial Balance total and the Aged Receivables report for a time period, note the amount of the variance.  Then, run the same set of reports for the period prior to verify that these accounts were in balance. If the variance was still there, then keep backdating the reports until you identify the last time these accounts were balanced.  This gives a solid starting point to track down the error(s) that have occurred.


Once you have a starting point established, you can then start to look for what is causing the discrepancy.


Step 2  Look Deeper, and Find What Happened?

  • Are there items posted to the G/L that were not entered on the detailed report listing? Wrong accounts used? Did a user override the defaults?
  • Are there items posted to the detailed report listing but not the G/L?
  • Can any mistakes be identified? 


There are only a few different reasons this situation can occur.


The most common reason we see are data entry errors.  Typically they are a general journal entry made to the actual GL account, which did not pass through the aging report.  


Most of the time it is due to dating issues.

  • Incorrect Dates/Timing differences
  • Unusual transactions
  • User error in entering/dating entries
  • Voided transactions (checks, payment applications) with the incorrect date


Sometimes it is due to transactions that don't belong.

  • Year end entries not reversed.
  • Wrong accounts used
  • General Journal entries made directly to an account (i.e. like Accounts Payable, Accounts Receivable)
  • any PE Debit (Credit inventory/ debit AP)
  • Are there any unusual transactions in that period?
  • Non-recurring entries? (higher risk of error)


TIP: It is best practice to NOT use the Inventory Control account as a default expense account.



Connected has a number of queries, filters, and report windows that can help track down issues and identify them.


Using Connected Query Windows


Accessing Connected Reports


Connected Ledger Windows


Connected Views for Ledger and Query Windows




Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select atleast one of the reasons

Feedback sent

We appreciate your effort and will try to fix the article