Skip to main content
    SplashBI
    Finance Analytics

    General Ledger Reconciliation: Process, Checklist, and Oracle Examples

    Learn how Controllers reconcile general-ledger accounts to subledgers and supporting records, investigate differences, and maintain reviewable evidence.

    SplashBI Editorial
    SplashBI Editorial
    Product Intelligence Team
    ·October 6, 2026·10 min read·
    Corporate Controller reviewing Oracle general ledger reconciliations by account owner, risk, unresolved value, and aging.
    Finance Analytics

    General ledger reconciliation is the process of proving that each GL account balance agrees with an independent source, such as a subledger, bank statement, fixed-asset register, or supporting calculation. Finance teams investigate differences, post approved corrections, document unresolved items, and retain evidence and reviewer sign-off before closing the reporting period.

    Matching totals is only the beginning. A complete reconciliation must explain what makes up the balance, why differences exist, who owns each unresolved item, and when it will be cleared.

    What Is General Ledger Reconciliation?

    General ledger reconciliation verifies that the balances recorded in the GL are complete, accurate, appropriately classified, and supported.

    For each material account, the reconciler should be able to answer four questions:

    1. What makes up the ending GL balance?

    2. What independent record supports that balance?

    3. Why does any difference exist?

    4. What correction or future action is required?

    For example, an accounts payable control account should agree with the total liability supported by the AP subledger. A cash account should reconcile with bank and Cash Management records. A prepaid-expense account should agree with a roll-forward schedule showing its opening balance, additions, amortization, and ending balance.

    A reconciliation is not complete merely because the workpaper contains the GL balance. The support must independently substantiate that balance or explain every material difference.

    This is also what separates reconciliation from general ledger reporting. Reporting shows what has been recorded. Reconciliation tests whether that record agrees with the underlying financial activity.

    General Ledger Reconciliation vs. Trial Balance vs. Account Reconciliation

    These processes use related accounting data but establish different things.

    Process or Output What It Establishes What It Does Not Establish
    Trial balance Total debits equal total credits That individual accounts are correct or supported
    GL report Shows account balances, journals, and recorded activity That the activity agrees with an independent source
    Account reconciliation Proves one account balance using supporting evidence That every GL account has been reviewed
    Subledger-to-GL reconciliation Confirms a subledger agrees with its GL control account That unrelated accounts and manual journals are appropriate
    General ledger reconciliation Coordinates the substantiation and review of relevant GL accounts That every financial risk has been eliminated
    Balance-sheet reconciliation Substantiates balance-sheet accounts That all income-statement activity has been analyzed

    A balanced trial balance proves arithmetic equality. It cannot detect a duplicate entry with equal debits and credits, a misclassification between accounts, an entry posted to the wrong period, or an unsupported balance.

    General ledger reconciliation normally gives priority to balance-sheet accounts because their balances carry forward from period to period. Revenue and expense accounts may be reviewed through reconciliations, variance analysis, journal testing, or other analytical controls, depending on their risk and the organization’s accounting policy.

    Which General Ledger Accounts Need Reconciliation?

    Every material GL account should be covered by a defined reconciliation or analytical-review policy. The supporting source depends on the nature of the account.

    GL Account Area Independent or Supporting Source Common Differences
    Cash Bank statements and Cash Management records Outstanding payments, deposits in transit, bank fees, unmatched statement lines
    Accounts payable AP subledger, invoice register, payment register, and aging Unaccounted invoices, unposted activity, manual journals, and cut-off differences
    Accounts receivable AR subledger, receipts, credit memos, and aging Unapplied receipts, backdated transactions, write-offs, and manual journals
    Fixed assets Asset register and depreciation schedules Unposted additions, retirements, depreciation, or construction-in-progress transfers
    Inventory Inventory valuation, costing, and physical counts Cost updates, in-transit inventory, quantity differences, and obsolete stock
    Payroll Payroll register and payroll accounting output Benefit accruals, off-cycle payroll, timing, and mapping differences
    Intercompany Counterparty records and matching entity balances Timing, currency, account mapping, and unmatched partner entries
    Prepaids and accruals Roll-forward schedules and supporting calculations Missed amortization, incorrect reversals, stale estimates, and incomplete support
    Clearing and suspense Transaction-level clearing detail Unmatched transactions, missing references, and aged balances
    Tax accounts Tax returns, calculations, and payment records Timing, jurisdiction, deferred items, and classification differences

    Not every account needs the same reconciliation frequency.

    High-risk accounts such as cash, intercompany, tax, clearing, and major subledger-control accounts may require daily, weekly, or monthly attention. Stable, low-value accounts may be reviewed less frequently if the policy, risk assessment, and control environment support that decision.

    Frequency should reflect materiality, transaction volume, volatility, fraud exposure, estimation uncertainty, and potential financial-statement impact.

    How Do You Reconcile the General Ledger?

    A controlled general ledger reconciliation follows the same basic sequence for every account, even when the supporting evidence differs.

    1. Define the reconciliation scope

    Identify the ledger, entity, accounting period, currency, account combination, and reporting basis. Confirm whether the reconciliation covers a single account, an account range, a subledger control account, or multiple ledgers.

    2. Roll forward the previous reconciliation

    Confirm that the current opening balance agrees with the previous period’s approved ending balance. Carry forward unresolved items with their original dates, explanations, owners, and target resolution dates.

    3. Verify posting completeness

    Before comparing balances, confirm that required transactions have been accounted, transferred, and posted. Review interface failures, unposted journals, incomplete subledger processes, and activity recorded after the reporting cut-off.

    4. Extract the GL balance and activity

    Run the GL balance and transaction detail using controlled parameters. Save the ledger, entity, period, account, currency, and posting-status selections with the reconciliation.

    5. Obtain independent support

    Retrieve the subledger total, bank statement, asset register, inventory valuation, payroll register, contract, calculation, or roll-forward schedule that supports the GL account.

    6. Compare the records

    Calculate the difference between the GL and the supporting balance. For high-volume control accounts, begin with the total difference before moving into transaction-level investigation.

    7. Classify every reconciling item

    Common categories include:

    • Timing differences

    • Unaccounted transactions

    • Transactions not transferred or posted

    • Missing or duplicate entries

    • Incorrect accounts, entities, periods, or currencies

    • Manual journals to control accounts

    • Intercompany mismatches

    • Foreign-exchange differences

    • Unsupported or stale balances

    8. Correct or assign the difference

    Post an approved adjustment or correcting journal when the accounting record is wrong. Do not post a plug merely to force the reconciliation to zero.

    Legitimate timing items should remain visible with an explanation, owner, expected clearing date, and aging status.

    9. Review, approve, and retain evidence

    An independent reviewer should confirm the source reports, calculations, material items, adjustments, unresolved differences, and evidence. Retain the completed workpaper and approval according to the organization’s record-retention policy.

    How Does General Ledger Reconciliation Work in Oracle?

    Oracle GL reconciliation begins with complete accounting and posting, then uses specialized reconciliation reports to compare General Ledger with its source modules.

    Oracle recommends verifying that all relevant subledger transactions have been imported, and journals posted before running reconciliation reports. Its predefined reports support cash, payables, receivables, journals, account analysis, and other reconciliation requirements. Oracle General Ledger Reconciliation Reports

    Oracle Area Accounting Objects Primary Reports What to Investigate
    General Ledger Balances, journals, account combinations, and periods Trial Balance, Account Analysis, journal reports Unposted journals, manual entries, incorrect periods or accounts
    Subledger Accounting Accounting events, journal entries, and transfer status Subledger Accounting reports Unaccounted, untransferred, rejected, or summarized entries
    Payables Invoices, payments, liability distributions, and SLA entries Payables to Ledger Reconciliation, Payables Trial Balance Manual GL postings, accounting status, invoice and payment timing
    Receivables Transactions, receipts, adjustments, and SLA entries Receivables to Ledger Reconciliation Unapplied receipts, backdated transactions, and accounting differences
    Cash Management Bank accounts, statement lines, receipts, and payments Cash to General Ledger Reconciliation Unmatched bank activity and book-to-bank timing
    Fixed Assets Asset books, additions, transfers, retirements, and depreciation Asset and GL reports Unposted depreciation, additions, transfers, and retirements
    Clearing accounts Journal lines and reconciliation references Reconciled Transactions Report Open clearing items and missing references

    The Payables to Ledger Reconciliation report shows summarized and detailed reconciling data, including beginning balances, period activity, ending balances, and differences. Reviewers can drill from a difference to the underlying detail. Oracle Payables-to-Ledger guidance

    The Receivables to Ledger Reconciliation report provides a similar comparison between receivables and accounting balances. It can expose differences involving transactions, receipts, adjustments, and how that activity was accounted. Oracle Receivables-to-GL guidance

    Where practical, restrict postings to AP and AR control accounts to their designated subledger sources. Oracle recommends avoiding non-Payables sources posting to Payables accounts because unrelated manual journals create additional reconciliation differences.

    An accounts payable aging report can support the AP review, but aging and reconciliation answer different questions. Aging explains how long invoices have remained outstanding. Reconciliation determines whether the subledger and GL agree.

    What Should a GL Reconciliation Control Tower Show?

    A GL reconciliation control tower should show which accounts are complete, where material differences remain, how long they have been open, and who owns the next action.

    The following is an illustrative design:

    Account Owner Risk GL Balance Supporting Balance Difference Oldest Item Status Reviewer
    Cash clearing Treasury Accounting High $4.82M $4.80M $20K 4 days In review Controller
    AP control AP Accounting High $12.40M $12.32M $80K 12 days Exception Accounting Manager
    AR control AR Accounting High $8.75M $8.75M $0 0 days Complete Controller
    Intercompany Corporate Accounting High $2.10M $1.89M $210K 35 days Overdue Group Controller
    Prepaids General Accounting Medium $640K $630K $10K 61 days Action required Accounting Manager

    Useful control-tower metrics include:

    • Percentage of accounts prepared and approved

    • Unreconciled value by risk tier

    • High-risk accounts past due

    • Items older than 30, 60, and 90 days

    • Manual journals posted to control accounts

    • Unaccounted, untransferred, or unposted Oracle transactions

    • Reconciliations awaiting review

    • Accounts without current evidence

    • Recurring differences by source and root cause

    Completion percentage alone can create false confidence. A close with 98% of accounts complete may still carry material risk if the remaining accounts include cash, intercompany, tax, or high-value subledger controls.

    What Are the Best Practices for General Ledger Reconciliation?

    Strong reconciliation controls make ownership, differences, evidence, and review visible.

    Best Practice Risk Reduced Evidence the Control Is Working
    Maintain an account inventory Accounts omitted from the close Every material account has an owner, reviewer, and cadence
    Assign frequency by risk High-risk accounts reviewed too late Risk tiers and documented review frequency
    Standardize report parameters Inconsistent balances and periods Saved ledger, period, entity, currency, and status selections
    Reconcile subledger controls first Detail reviewed before totals agree AP, AR, cash, assets, and inventory tied to their GL controls
    Restrict manual control-account journals Unexplained subledger-to-GL differences Approved journal sources and exception monitoring
    Age every difference Old items repeatedly carried forward Original date, owner, explanation, and resolution target
    Separate errors from timing Incorrect or premature adjustments Documented reconciling-item categories
    Prohibit unsupported plugs Balances forced to agree without evidence Adjustments linked to approved support
    Separate preparation and approval Self-review weakens the control Independent reviewer sign-off
    Preserve complete evidence Audit support reconstructed later Source reports, calculations, journals, notes, and approvals retained
    Analyze recurring differences The same process failures repeat Root-cause reporting and corrective actions

    Dedicated account reconciliation software may automate matching, certification, workflow, and exception routing. Connected GL software supports a different but complementary requirement: getting governed balances and transaction detail into the reconciliation process without rebuilding the data path every month.

    BlackLine’s reconciliation guidance emphasizes retaining supporting documentation, while segregation of duties requires the preparer and approver to be different people.

    How Does GL Connect Support Oracle GL Reconciliation?

    GL Connect supports Oracle reconciliation by making GL balances, journal activity, and subledger details easier to refresh, investigate, document, and review inside Excel.

    Reconciliation Friction How GL Connect Helps
    Static Oracle exports become outdated Reports can be refreshed from connected Oracle data
    A GL balance lacks supporting context Users can drill from balances to journal and subledger detail
    EBS, Fusion, and EPM reporting are separated One reporting environment supports hybrid Oracle estates
    Reviewers need supporting evidence Users can manage attachments and route approvals
    Reports are rebuilt every period Templates can be reused, refreshed, scheduled, and shared
    Multi-ledger review requires separate workbooks GL Connect supports reporting across ledgers
    Finance depends on IT for report changes Finance users can build and refresh reports within Excel

    GL Connect provides real-time reporting for Oracle EBS and direct, near real-time reporting for Oracle Fusion Cloud. It also connects to Oracle Cloud EPM for reporting across actuals, budgets, and forecasts.

    Its drilldown lets users move from a GL balance to balance detail, journal entries, and subledger transactions. That traceability helps the reconciler identify what created a difference and gives the reviewer a clearer evidence path. GL Connect also supports attachments, approval routing, report distribution, and reporting across ledgers.

    GL Connect supports reconciliation through access, traceability, evidence gathering, and review. It should not be described as automatically matching every transaction or certifying every account. Accounting ownership, exception resolution, adjustment approval, and independent review remain part of the control process.

    Learn more about modernizing Oracle reporting without replacing the ERP systems and accounting controls already in place.

    Make Your General Ledger Reconciliation Explainable

    General ledger reconciliation is not a month-end exercise in making two cells equal. It is the controlled process of proving what each balance contains, identifying why differences exist, resolving errors, aging legitimate open items, and preserving the evidence behind the conclusion.

    When Oracle data is difficult to extract and investigate, GL Connect can give finance teams a faster, more traceable path from GL balance to journal and subledger detail.

    Tags
    General LedgerGL ReconciliationFinance AnalyticsOracleMonth-End CloseGL Connect
    SplashBI Editorial
    SplashBI Editorial
    Product Intelligence Team

    The SplashBI Editorial team covers enterprise analytics, AI-driven decision-making, and the future of Finance and HR intelligence.

    Frequently Asked Questions

    What is general ledger reconciliation?

    General ledger reconciliation compares each relevant GL account balance with an independent supporting source, such as a subledger, bank statement, asset register, or calculation. Differences are investigated, corrected or documented, reviewed, approved, and retained as evidence supporting the period-end balance.

    How often should general ledger accounts be reconciled?

    Frequency should reflect risk, materiality, transaction volume, volatility, and company policy. High-risk accounts may require daily, weekly, or monthly reconciliation. Stable, low-risk accounts may be reviewed quarterly. Material balance-sheet and subledger-control accounts are normally reconciled during every financial close.

    What is the difference between a trial balance and GL reconciliation?

    A trial balance lists account balances and confirms that total debits equal total credits. GL reconciliation tests whether individual balances agree with independent supporting records. A trial balance can balance even when transactions are duplicated, misclassified, posted to the wrong period, or unsupported.

    What causes differences between a subledger and the general ledger?

    Common causes include unaccounted transactions, entries not transferred or posted, manual journals to control accounts, timing and cut-off differences, incorrect account mappings, duplicate activity, backdated transactions, currency differences, and incomplete subledger processes.

    Can general ledger reconciliation be automated?

    Parts of the process can be automated, including data extraction, report refresh, transaction matching, exception identification, workflow, and aging. Automation does not replace accounting judgment, supporting evidence, adjustment approval, or independent review. The available automation depends on the ERP, reporting layer, and reconciliation software.

    What should a GL reconciliation workpaper include?

    A complete workpaper should include the account, period, entity, currency, GL balance, supporting balance, difference, reconciling items, explanations, aging, owners, expected resolution dates, adjustments, source reports, supporting evidence, preparer, reviewer, approval dates, and unresolved-item roll-forward.

    More from the SplashBI blog

    Stop waiting for reports. Just ask