Analyzing balancing reports

Balancing reports can be viewed each day from a printed copy, by viewing the file on screen, or in GL Account Inquiry-Balance History. This last method may be a time saver. Select the Track Balancing History option in SA Administrator Options-Financials-Period Structure to allow for review of most balancing reports in GL Account Inquiry, as well as the GL Balancing History Report.

These reports create a record within the GL which can be reviewed in the inquiry or on the history report. The inquiry and history report provides information only if reports are run with some type of detail rather than choosing the Total format. For example, the Customer Trial Balance Report Detail option should be Invoice, Customer, or GL to allow for tracking within the General Ledger.

  • Vendor Trial Balance Report
  • Customer Trial Balance Report
  • Product Trial Balance of Stock Inventory Report
  • Product Trial Balance of Non-Stock Inventory Report
  • Product Trial Balance of Direct Orders Report
  • GL Balance Order Entry Report
  • GL Balance Transfers Report
  • GL Balance Purchase Order Report
  • GL Balance Matching Activity Report

These reports must be run and reviewed separately:

  • GL Trial Balance Report
  • Sales Cash Drawer Balance Report
  • VA WIP Trial Balance Report
  • CR Trial Balance Report

The GL Account Inquiry-Balance History function can be used for a quick review of all balancing reports run for the day. Modify the search criteria by leaving the GL Account # blank and specify a Start Date to display a list that should be sorted by Store As job name, GL Account #, and As of Date in descending order.

The GL Balance History Report can be run for any function over a period of time. Your system administrator can archive or delete balancing records over time.