What is Daily Cash Reconciliation?
Definition
Daily Cash Reconciliation is the finance activity of matching each day’s cash inflows, cash outflows, bank balances, ledger postings, and supporting records to confirm that cash activity is complete and accurate. It gives treasury, accounting, and finance teams a daily view of available cash before month-end reporting begins.
It is a frequent form of Cash Reconciliation that focuses on same-day or next-day validation of deposits, payments, transfers, bank fees, interest, and cash ledger entries. The objective is to identify differences early, keep the general ledger cash account current, and support reliable cash flow visibility.
How Daily Cash Reconciliation Works
The process starts by collecting daily bank statement activity, cash ledger records, payment files, collection reports, deposit details, and cash journal entries. Finance then matches each bank line with the corresponding internal record. Matched transactions are cleared, while unmatched items are reviewed, classified, and resolved.
Customer collections are matched with deposits and cash application records.
Supplier payments are matched with payment runs, bank debits, and disbursement files.
Account transfers are validated between sending and receiving bank accounts.
Bank fees, interest, and charges are recorded through cash adjustment entries.
Open items are reviewed through daily reconciliation controls.
Core Components
A complete daily cash reconciliation includes the opening cash position, daily bank activity, cash receipts, cash payments, transfers, ledger postings, reconciling items, adjustment entries, and reviewer approval. For companies with multiple bank accounts, currencies, or entities, daily reconciliation also confirms that activity is posted to the correct legal entity and ledger code.
This is where Chart of Accounts Mapping (Reconciliation) becomes important. Correct mapping helps ensure that valid cash activity is not recorded in the wrong account. It also links daily cash validation with Cash Flow Analysis (Management View) and financial reporting.
Reconciliation Method and Example
A practical daily reconciliation compares adjusted bank cash with adjusted book cash. Adjusted bank cash = bank statement balance + deposits in transit - outstanding payments. Adjusted book cash = ledger cash balance + bank credits not recorded - bank debits not recorded.
Assume the bank statement balance at the end of the day is $92,000 and the ledger cash balance is $88,300. The finance team identifies $6,500 of customer deposits in transit, $2,400 of outstanding payments, $300 of bank fees not yet posted, and $600 of interest income not yet recorded.
Adjusted bank cash = $92,000 + $6,500 - $2,400 = $96,100.
Adjusted book cash = $88,300 - $300 + $600 = $88,600.
The remaining difference is $7,500. This means the daily reconciliation is not complete. The team should investigate whether a receipt, payment, transfer, or ledger posting is missing. Once the missing item is recorded or explained, adjusted bank cash and adjusted book cash should agree.
Business and Treasury Impact
Daily cash reconciliation helps finance teams make better short-term cash decisions. When cash records are validated every day, treasury can understand whether enough cash is available for payroll, supplier payments, debt service, and operating needs.
It also improves the quality of the Cash Flow Forecast (Collections View) because actual cash movement is checked against expected receipts and payments. Daily reconciled data supports the Cash Flow Statement (ASC 230 / IAS 7) by keeping operating, investing, and financing cash movements organized throughout the period rather than only at month end.
Best Practices
Reconcile high-volume and high-value bank accounts every business day.
Review unmatched items by age, value, bank account, entity, and transaction type.
Separate preparer and reviewer responsibilities for stronger approval discipline.
Maintain supporting evidence for collections, payments, transfers, and journal entries.
Use daily reconciliation outputs to monitor Cash Conversion Cycle (Treasury View) trends.
Compare available liquidity with indicators such as Cash to Current Liabilities Ratio.
Key Metrics to Track
Useful metrics include daily unreconciled cash value, number of open cash items, average age of unmatched transactions, percentage of bank accounts reconciled on time, number of daily cash adjustments, and cash forecast variance. These metrics show whether daily cash records are reliable for operational and financial decisions.
A high unreconciled cash value may indicate that receipts, payments, or bank-originated items need same-day review. A low unreconciled cash value usually shows that cash activity is being recorded, matched, approved, and monitored consistently.
Summary
Daily Cash Reconciliation confirms that each day’s cash activity agrees with bank records, ledger postings, and approved adjustments. It improves cash flow visibility, supports treasury decisions, strengthens financial reporting, and helps finance teams maintain accurate cash records throughout the accounting period.
