What are Unreconciled Balances?

Table of Content
  1. No sections available

Definition

Unreconciled Balances are account balances or transaction differences that have not yet been matched, explained, supported, adjusted, or approved during reconciliation. They may appear in cash accounts, bank accounts, clearing accounts, suspense accounts, receivables, payables, intercompany accounts, accruals, or other balance sheet accounts.

An Unreconciled Balance means the recorded amount does not yet fully agree with supporting records such as bank statements, subledger reports, invoices, payment files, settlement reports, or approved journal entries. Finance teams review these balances to confirm whether they are valid timing differences, missing postings, classification issues, or items requiring adjustment.

How Unreconciled Balances Arise

Unreconciled balances usually appear when the general ledger balance and supporting evidence do not agree at a reporting date. For example, a bank debit may appear on the bank statement but not in the ledger, a customer receipt may be recorded without remittance detail, or a clearing account may contain a payment that has not yet moved to the final account.

Core Components

A complete unreconciled balance review should include the account name, account number, reporting period, general ledger balance, supported balance, unreconciled amount, transaction details, aging, owner, explanation, evidence status, and expected resolution date. This detail helps finance teams understand whether the balance is temporary, recurring, material, or ready for adjustment.

Unreconciled balances are often reviewed as part of account reconciliation and balance sheet reconciliation. For cash-related accounts, they may also connect to bank account reconciliation where bank statement balances are compared with ledger cash balances.

Calculation and Worked Example

A useful calculation is unreconciled balance = general ledger balance - supported balance.

Assume the general ledger balance for a cash clearing account is $82,000. The supporting settlement report shows cleared and verified items of $76,500.

Unreconciled balance = $82,000 - $76,500 = $5,500.

This means $5,500 still requires review. Finance may find that the difference relates to a missing bank settlement, unapplied receipt, duplicate payment, timing item, or journal entry not yet supported. Once valid support or an approved adjustment is recorded, the unreconciled balance should reduce to $0 or to an explained approved amount.

Interpretation and Reporting Impact

A high unreconciled balance may indicate that account support, transaction matching, posting accuracy, or documentation needs review before close approval. A low unreconciled balance usually shows that ledger balances and supporting records are aligned. However, finance teams should review both amount and age because a small aged item can still require attention if it affects a material account.

Unreconciled balances affect financial reporting because unsupported amounts can reduce confidence in reported assets, liabilities, expenses, revenue, or cash. They also influence audit readiness because reviewers and auditors need clear evidence for balances included in the financial statements.

Common Use Cases

Unreconciled balances are common during month-end close, daily cash reconciliation, intercompany review, vendor statement review, customer receipt matching, payment settlement review, and account substantiation. They are especially important in accounts that should clear quickly, such as cash clearing, payroll clearing, payment clearing, and suspense accounts.

For working capital accounts, unreconciled balances may affect accounts receivable reconciliation, accounts payable reconciliation, and accrual review. For intercompany accounts, open differences may require entity-level follow-up and supporting evidence before consolidation.

Best Practices

  • Track unreconciled balances by account, entity, owner, value, age, and root cause.

  • Prioritize material, aged, recurring, and close-sensitive balances first.

  • Maintain supporting evidence for timing items, adjustments, and reviewer approvals.

  • Use consistent aging buckets such as 0-30 days, 31-60 days, 61-90 days, and over 90 days.

  • Connect unresolved items with reconciliation controls and close review procedures.

  • Review recurring causes to improve posting accuracy, account ownership, and reporting reliability.

Key Metrics to Track

Useful metrics include total unreconciled balance value, number of unreconciled items, average age of open balances, percentage of balances resolved before close, high-value open item count, post-close adjustment value, and reviewer rejection rate. These metrics help finance teams measure reconciliation quality and close readiness.

If total unreconciled balances decline over time, it usually indicates stronger account support, cleaner transaction matching, and better close discipline. If unreconciled balances rise, finance teams should review the affected accounts, owners, source systems, and transaction categories before relying on the final reporting package.

Summary

Unreconciled Balances are account differences that still need matching, support, explanation, approval, or adjustment. They are important for reconciliation quality, financial reporting accuracy, cash flow visibility, audit readiness, and management confidence in reported balances.

Build Custom Finance Workflows with 200+ Prebuilt AI APIs

Get Access to your Private F&A Chatbot

Ask questions in natural language & get instant insights

Ask questions in natural language & get instant insights