Inventory Trial Balance Does Not Balance to General Ledger

Sage 100 includes several Inventory Management reports:

Inventory Valuation Report
Inventory Stock Status Report
Trial Balance Report
Detail Transaction Report

The Valuation and Stock Status Reports reflect current data only and aren’t date sensitive. You can’t use them to reconcile with General Ledger.

The Trial Balance and Detail Transaction Reports are date sensitive. They use the same posting date as General Ledger and act as the official reconciling reports.

Cause

Common reasons for out-of-balance conditions

Several conditions cause the Inventory Trial Balance Report to differ from the General Ledger:

The Trial Balance Report only runs correctly for the current period
Changing Inventory periods doesn’t update beginning balances on the report
Turning off General Ledger integration or clearing registers prevents proper posting
Incorrect account assignments in setup or transaction entry
Posting transactions directly to inventory accounts from other modules
Posting to closed periods while General Ledger remains open
Failure to close modules promptly
Mismatch between Inventory Stock Status and Inventory Valuation Reports
Rounding differences from unit cost precision settings
Use of the "Fix" button in older versions
Standard cost changes from Cost Rollup Registers
Incorrect configuration of product lines or miscellaneous items

Resolution

Reconcile the Inventory Trial Balance to General Ledger

Use the following steps to identify and correct differences:

Verify report usage

Run the Inventory Trial Balance Report only for the current period
Use the Detail Transaction Report for reconciliation with General Ledger

Review posting accounts

Confirm all inventory postings use the correct Inventory account
Check Product Line Maintenance for correct account assignments
Review Miscellaneous Item Maintenance for incorrect inventory account usage

Check for incorrect module postings

Review Accounts Payable invoice entries posted to Inventory accounts
Run the General Ledger Detail Report filtered by:
- Source Type = Module Registers
- Inventory account number

Validate register postings

Compare register hard copies with General Ledger postings
Confirm all Daily Transaction Register updates posted successfully

Analyze transaction activity

Run the Detail Transaction Report with:
- Blank start date
- Future end date
Compare totals with General Ledger activity for the same range

Reconcile by source

Use the G/L Detail by Source Report
Match each transaction to its originating register
Reverse incorrect entries and reenter them in the correct module

Check inventory data consistency

Compare Inventory Stock Status and Inventory Valuation Reports
Verify quantities on hand match across both reports
Run the Balance Quantity and Cost utility to detect imbalances

Test for future-dated transactions

Use the SVDATA utility to copy data into a test company
Close Inventory periods twice in the test environment
Compare Inventory Trial Balance against General Ledger
If balances align, future-dated transactions caused the issue

Review rounding and costing methods

Check unit cost precision settings
Evaluate average cost rounding impacts
Review Standard Cost items and recent Cost Rollup changes

Understand Trial Balance calculations

The Inventory Trial Balance uses the following logic:

Beginning Balance = value written during period end
Ending Balance = (current quantity on hand × current cost) minus future-dated transactions
Activity = Ending Balance minus Beginning Balance

CAUTION: