Use this report to compare summarized inventory balances and activity with General Ledger balances. The GL Reconciliation Summary Report provides a high-level view of reconciliation results, helping users verify inventory valuation, identify discrepancies, support financial reporting, and confirm that inventory and accounting records remain aligned. This report is commonly used during month-end, year-end, audit, and financial review processes.
Example
At the end of the month, the GL Reconciliation Summary Report shows:
Inventory System Balance: $250,000
General Ledger Balance: $250,000
Difference: $0
Because the balances agree, no additional reconciliation work may be necessary.
1. Open the Connect Materials Management > Reports > GL Reconciliation Report—Summary.
2. Select a report title.
3. Enter the Report Dates.
Report Dates is the report date range. The report will use the report date range to select transactions to print on the report.
Do you want to use the current month as the report date range?
Yes, I want to use the current month. This is the default setting.
No, I want to use a different date range. Change the Report Date, or click Advanced Options.
This option will include all GL accounts that have a Materials Management transaction posted to it. The beginning account balance will include transactions that occurred prior to the selected date range. When this option is not selected the report will include only GL account balances for the transactions that occur during the selected date range.
Do you want to include GL accounts with no activity?
Yes, I want to include GL accounts with no activity. Select the Include GL Accounts with No Activity for the Selected Dates checkbox.
No, I do not want to include GL accounts with no activity. Leave blank the Include GL Accounts with No Activity for the Selected Dates checkbox.
The report prints.