Use this report to review detailed inventory transactions and compare inventory records with General Ledger balances. The GL Reconciliation Detail Report helps identify discrepancies, validate accounting entries, support financial reporting, and provide documentation for audits and reconciliation activities. Regular review of this report helps ensure inventory and accounting records remain accurate and aligned.

Example
At month-end, the inventory asset account in the General Ledger shows a balance of $125,000, while the inventory system shows $124,750. A GL Reconciliation Detail Report can be used to review the transactions contributing to the difference and identify any missing or incorrect entries.

Do this...

1. Open Connect Materials Management > Reports > GL Reconciliation Report—Detail.

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.

A transaction type is a group or category that defines the accounting behavior to record an exchange or transfer of goods, services, or funds.

Which transaction types do you want to include on the report?

• Select the corresponding checkbox, located in Include Transaction Types, to add a transaction type to the report. 

• Clear the checkbox to remove a transaction type from the report.

The report prints.