GL_Reconciliation_Detail_Report

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:
DateAsset IDTransaction TypeAsset Mgmt/AmountGL AmountDifference
07/15/2025EQ-1023Addition    $12,500    $12,500$0
07/31/2025EQ-1023Depreciation    ($208)($200)($8)
08/10/2025VH-0045Disposal    ($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

    • How do I review unupdated receipts? (Delete Payment Detail)

      When you run the Delete Payment Detail routine, Connect will search for receipts that have a receipt date that occurs prior to the date entered for payments that have not been updated to the General Ledger or updated to the related subsystem. ...

    • GL Reconciliation Report

      Use the GL Reconciliation Report to verify invoice and check amounts that effect the General Ledger. Compare this report with the Unpaid Invoice report, Aging report in Accounts Payable, and the Accounts Payable Liability balance in the General ...

    • GL Reconciliation Summary Report

      A GL Reconciliation Summary Report is a report used to compare and reconcile the balances in the Asset Management system with the balances in the General Ledger (GL). Its purpose is to help ensure that: capital asset balances, accumulated ...

    • How do I print a GL Reconciliation report?

      Use this report to view transaction totals by GL account for balancing entries posted to the General Ledger. A GL Reconciliation report is a financial report that compares cash receipt records with the corresponding entries in the general ledger (GL) ...

    • Requisition Budget Report by GL Account

      Use this report to print the budget for requisitions by GL account. Printing a Requisition Budget Report by GL Account 1. Open Connect Accounts Payable > Reports > Requisition Budget Report by GL Account. 2. Select a report title. 3. Set up the ...