vm0-ai Reconciliation Categories
General Ledger vs. Subledger
Verify that each control account in the GL agrees with the sum of its underlying detail ledger.
Accounts typically reconciled this way:
- Trade receivables (GL control vs. AR aging schedule)
- Trade payables (GL control vs. AP aging schedule)
- Property, plant & equipment (GL control vs. asset register)
- Inventory (GL control vs. stock valuation report)
- Prepaid assets (GL control vs. amortization schedule)
- Accrued liabilities (GL control vs. accrual supporting schedules)
Workflow:
- Extract the GL control account balance at the period cut-off
- Generate the subledger detail or trial balance as of the identical date
- Match the two totals — under real-time posting they should be identical
- Research any gap (manual GL postings, pending interface batches, failed data transfers, reclassifications without subledger mirror)
Typical root causes of discrepancy:
- Journal entries booked directly to the control account without a subledger transaction
- Subledger batches queued but not yet transmitted to the GL
- Lag between batch processing windows
- GL reclassifications with no subledger counterpart
- Integration failures or rejected interface records
Cash / Bank Reconciliation
Align the book cash balance with the financial institution's reported position.
Workflow:
- Obtain the institution's closing statement balance
- Pull the corresponding GL cash account balance at the same date
- List checks written but not yet presented for payment
- List deposits recorded in the books but not yet credited by the bank
- Identify bank-initiated entries (fees, interest, returned items) absent from the GL
- Derive an adjusted balance on each side; the two must agree
Presentation template:
Institution statement balance: $XX,XXX
Plus: Deposits not yet credited $X,XXX
Less: Unpresented checks ($X,XXX)
Plus/Less: Institution errors $X,XXX
Adjusted institution balance: $XX,XXX
Book (GL) balance: $XX,XXX
Plus: Interest & credits unrecorded $X,XXX
Less: Fees & charges unrecorded ($X,XXX)
Plus/Less: Book errors $X,XXX
Adjusted book balance: $XX,XXX
Remaining variance: $0.00
Intercompany Reconciliation
Confirm that receivables and payables between affiliated entities offset to zero for consolidation purposes.
Workflow:
- Collect intercompany receivable and payable balances for every entity pair
- Match Entity A's claim on Entity B against Entity B's corresponding obligation to Entity A
- Investigate and resolve discrepancies
- Verify that both sides have captured every intra-group transaction
- Validate that consolidation elimination entries will net these balances cleanly
Typical root causes of discrepancy:
- One entity recorded the transaction while the other has not yet done so
- Entities applied different foreign exchange rates on the same transaction
- Amounts classified as intercompany by one party but as third-party by the other
- Contested charges or unapplied cash receipts
- Differing period-end cut-off conventions across subsidiaries
Classifying Open Reconciling Items
Class 1 — Timing Lags
Items arising from normal processing sequences that will self-clear without intervention:
- Checks issued and booked but awaiting bank presentment
- Deposits journalized but pending bank value-date credit
- Transactions posted in one system awaiting batch interface to the other
- Items sitting in an approval queue prior to final posting
Expected outcome: Resolution within the standard processing window (generally 1-5 business days). No corrective entry required.
Class 2 — Corrective Action Needed
Items that demand a journal entry or other ledger adjustment:
- Bank-originated charges not yet reflected on the books (service fees, wire costs, NSF penalties)
- Interest income or expense recognized by the institution but absent from the GL
- Posting mistakes — wrong dollar amount, wrong account, or duplicate recording
- Transactions present in one system with no counterpart in the other
- Properly recorded amounts sitting in an incorrect GL account
Expected outcome: Prepare and post a correcting entry during the current or next available period.
Class 3 — Investigation Required
Items lacking a clear explanation:
- Variances with no identifiable source
- Amounts in dispute between internal parties or with external counterparties
- Stale items that have exceeded their expected clearance window
- Persistent differences of the same type reappearing period after period
Expected outcome: Perform root-cause analysis, document findings, and escalate when resolution is not straightforward.
Aging and Monitoring of Open Items
Track every unresolved reconciling item by age to surface those requiring management attention:
| Age Band | Classification | Required Response |
|---|---|---|
| 0-30 days | Current | Routine monitoring — within normal processing window |
| 31-60 days | Maturing | Active follow-up — determine why the item has not cleared |
| 61-90 days | Past due | Supervisor notification with documented investigation |
| Over 90 days | Stale | Management escalation — evaluate write-off or forced adjustment |
Item-Level Tracking Register
| Seq | Description | Amount | Origination Date | Days Open | Class | Resolution Status | Assigned To |
|---|---|---|---|---|---|---|---|
| 1 | [Detail] | $X,XXX | [Date] | XX | [Type] | [Status] | [Name] |
Trend Monitoring
Evaluate the reconciling-item population across periods to detect deterioration:
- Compare the aggregate dollar value of open items to the prior period
- Flag when total open items exceed the account's materiality benchmark
- Flag when the count of open items grows for two or more consecutive periods
- Investigate chronic items that appear in every reconciliation (signal of a systemic process gap)
Escalation Governance
Establish triggers proportional to organizational risk appetite:
| Condition | Illustrative Threshold | Escalation Path |
|---|---|---|
| Single-item dollar value | Above $10,000 | Supervisor review |
| Single-item dollar value | Above $50,000 | Controller review |
| Aggregate open items | Above $100,000 | Controller review |
| Item age | Over 60 days | Supervisor follow-up |
| Item age | Over 90 days | Controller / senior management review |
| Unresolved net difference | Any amount | Period cannot close — must resolve or formally document |
| Worsening trend | Three or more consecutive periods | Initiate process-improvement project |
Calibrate thresholds to match the entity's materiality level and control environment.
Operating Principles
- Cadence discipline: Finish every reconciliation within the close calendar window (commonly T+3 to T+5 after period end)
- Coverage: Reconcile every balance sheet account on a defined cycle — monthly for material balances, quarterly for immaterial ones
- Audit trail: Each reconciliation must identify the preparer, reviewer, completion date, and a narrative for every open item
- Separation of duties: The reconciler should not be the person who initiates or approves transactions in the same account
- Closure rigor: Carry open items forward only with active follow-up; never allow perpetual rollover without investigation
- Systemic fixes: When the same reconciling item type recurs, address the upstream process rather than repeatedly clearing symptoms
- Uniform format: Employ standardized templates and naming conventions across all accounts and business units
- Record keeping: Retain completed reconciliations and all supporting evidence in accordance with the organization's document-retention policy