What is Treasury Cash Reconciliation?
Definition
Treasury Cash Reconciliation is the finance activity of matching treasury cash records with bank statements, general ledger balances, payment activity, collections, transfers, and approved cash adjustments. It confirms that treasury’s view of available cash agrees with actual bank activity and the accounting records used for reporting.
It is closely connected to Cash Reconciliation because both validate cash accuracy, but treasury cash reconciliation focuses more on liquidity visibility, cash positioning, bank movement, and short-term funding decisions. It helps treasury teams understand how much cash is available, where it sits, and whether it has been recorded correctly.
How Treasury Cash Reconciliation Works
The reconciliation starts by collecting bank statement data, treasury records, ERP cash postings, payment files, collection files, and journal entries for the period. The treasury team then matches cash inflows, cash outflows, account transfers, bank fees, interest, and foreign currency items to confirm that each movement is supported and classified correctly.
Bank balances are compared with treasury cash records and ledger balances.
Collections are matched with Cash Application (Treasury View) records and deposit activity.
Payments are matched with bank debits, payment runs, and approved disbursement files.
Transfers between bank accounts are validated to confirm complete posting.
Bank fees, interest, and adjustments are recorded through approved cash entries.
Core Components
A complete treasury cash reconciliation includes bank statement balances, treasury cash positions, general ledger cash balances, reconciling items, payment confirmations, collection details, bank fees, interest income, FX adjustments, and reviewer approval. For multi-entity groups, the reconciliation should also confirm the correct legal entity, currency, bank account, and ledger code.
This is why Treasury Management System (TMS) Integration and Chart of Accounts Mapping (Reconciliation) are important. When bank activity, treasury records, and accounting codes align, treasury can rely on cash data for liquidity planning and finance can rely on it for period-end reporting.
Reconciliation Method and Example
A practical reconciliation compares adjusted treasury cash with adjusted bank cash. Adjusted bank cash = bank statement balance + deposits in transit - outstanding payments. Adjusted treasury cash = treasury book balance + bank credits not recorded - bank debits not recorded.
Assume the bank statement balance is $1,250,000 and the treasury cash record shows $1,238,500. The team identifies $42,000 of incoming customer deposits not yet reflected in the bank balance, $31,000 of outstanding payments, $2,500 of bank fees not posted in treasury records, and $4,000 of interest income not yet recorded.
Adjusted bank cash = $1,250,000 + $42,000 - $31,000 = $1,261,000.
Adjusted treasury cash = $1,238,500 - $2,500 + $4,000 = $1,240,000.
The remaining difference is $21,000. This means the reconciliation is still open and the team should investigate whether a bank transfer, receipt, payment, or accounting entry is missing. Once the missing item is posted or explained, both adjusted balances should agree.
Financial Reporting and Treasury Impact
Treasury cash reconciliation supports accurate liquidity reporting because it connects daily cash movement with accounting records. A clean reconciliation helps treasury confirm cash availability for supplier payments, debt service, payroll, investments, and short-term funding needs.
It also supports the Cash Flow Statement (ASC 230 / IAS 7) by validating cash movements used in operating, investing, and financing sections. For management reporting, reconciled treasury data improves Cash Flow Forecast (Collections View) accuracy and strengthens cash positioning for financial decisions.
Best Practices
Reconcile material bank accounts before treasury reports are finalized.
Separate preparer and reviewer responsibilities for stronger reconciliation controls.
Review unmatched items by age, value, entity, currency, and bank account.
Confirm that intercompany transfers are recorded on both sides of the movement.
Link reconciled cash data with Cash Conversion Cycle (Treasury View) analysis.
Use reconciliation results to improve liquidity management and short-term funding plans.
Key Metrics to Track
Useful metrics include unreconciled cash value, number of open cash items, average age of reconciling items, percentage of bank accounts reconciled on time, number of post-close cash adjustments, and cash forecast variance. These metrics show whether treasury cash records are accurate enough for daily decision-making and period-end reporting.
A high unreconciled cash value may indicate that payments, collections, bank references, or transfers require further review. A low unreconciled cash value usually shows that bank activity, treasury records, and ledger postings are being matched consistently.
Summary
Treasury Cash Reconciliation confirms that treasury cash records agree with bank activity, ledger balances, and approved cash adjustments. It improves cash flow visibility, strengthens financial reporting, supports funding decisions, and gives treasury leaders a reliable view of available liquidity.
