GL Reconciliation Detail Report
In Caselle Asset Management, a GL Reconciliation Detail Report is a detailed report that compares individual asset-related transactions and balances in the Asset Management system to corresponding entries in the General Ledger (GL). While the GL Reconciliation Summary Report provides high-level totals and variances, the Detail Report drills down into the specific records and transactions behind those totals.
The report typically includes:
- Asset IDs and descriptions
- GL account numbers
- Transaction dates
- Transaction types
- Posting amounts
- Depreciation entries
- Journal or batch references
- Differences between Asset Management and GL postings
Example:
| Date | Asset ID | Transaction Type | Asset Mgmt/Amount | GL Amount | Difference |
| 07/15/2025 | EQ-1023 | Addition | $12,500 | $12,500 | $0 |
| 07/31/2025 | EQ-1023 | Depreciation | ($208) | ($200) | ($8) |
| 08/10/2025 | VH-0045 | Disposal | ($6,000) | ($6,000) | $0 |
Organizations use the GL Reconciliation Detail Report to:
- Investigate reconciliation differences
- Trace discrepancies to specific transactions
- Verify depreciation postings
- Confirm account mappings
- Support audit requests
- Validate month-end and year-end closing activity
Common issues identified with this report include:
- Missing journal entries
- Incorrect GL account assignments
- Timing differences between systems
- Duplicate or omitted postings
- Manual GL adjustments not reflected in Asset Management
Compared to related reports:
- GL Reconciliation Summary Report High-level reconciliation totals
- GL Reconciliation Detail Report Transaction-level reconciliation detail
- Transaction Register All asset transactions regardless of GL impact
- Schedule of Changes in Assets Overall asset balance changes
In simple terms:
The GL Reconciliation Detail Report shows the exact transactions used to reconcile Asset Management records to the General Ledger.
Printing a GL Reconciliation Detail Report
1. Open Connect Asset Management > Reports > GL Reconciliation Detail Report.
2. Select a report title.
3. Enter the Date Range.
The date range selects the transactions that will be included.
Do you want to use the current date range?
-
Yes, I want to use the current date range. Continue to the next step.
-
No, I want to use a different date range. Change the From and To dates.
4. Set up the option to Include Report-Only Transactions.
A report only transaction is recorded and will be updated to the General Ledger as a report only transaction.
Do you want include report only transactions?
-
Yes, I want to include report only transactions. Select the Include Report-Only Transactions checkbox.
-
No, I do not want to include report only transactions. Deselect the Include Report-Only Transactions checkbox.
5. Click Print (CTRL+P).
The report prints.
Related Articles
GL Reconciliation Detail Report
In Caselle Asset Management, a GL Reconciliation Detail Report is a detailed report that compares individual asset-related transactions and balances in the Asset Management system to corresponding entries in the General Ledger (GL). While the GL ...
GL Reconciliation Report - Detail
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 ...
GL Reconciliation Report - Detail
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 ...
GL Reconciliation Report
Use this report to reconcile amounts paid in Business Tax Collection with the totals posted to the general ledger from the Business Tax Collection app. The report will list each GL account followed by any transactions that will be posted to the GL ...
GL Reconciliation Report
Use this report to reconcile amounts paid in Business Tax Collection with the totals posted to the general ledger from the Business Tax Collection app. The report will list each GL account followed by any transactions that will be posted to the GL ...