What is GL Cash Mapping?
Definition
GL Cash Mapping is the finance activity of linking general ledger cash accounts, bank accounts, transaction codes, and reporting categories to the right cash flow lines. It helps finance teams classify cash activity accurately for reporting, reconciliation, forecasting, and management analysis.
Strong GL cash mapping supports the Cash Flow Statement (ASC 230 / IAS 7) by ensuring cash balances and movements are assigned to operating, investing, financing, intercompany, or treasury categories consistently.
How GL Cash Mapping Works
The activity starts with the chart of accounts, bank master data, ERP posting rules, cash accounts, subledger postings, and reporting templates. Finance teams define which GL accounts flow into each cash flow category and how specific transaction types should be treated.
This is closely related to Chart of Accounts Mapping (Reconciliation) because both activities make sure ledger balances connect correctly to reporting schedules, bank records, and financial statements.
Core Components
Cash GL accounts: Bank accounts, petty cash, restricted cash, treasury accounts, and cash equivalents.
Mapping rules: Logic that assigns accounts and transactions to operating, investing, or financing activity.
Bank linkage: Connection between ERP cash accounts and actual bank accounts.
Reporting hierarchy: Grouping rules for entity, currency, region, business unit, and cash flow category.
Review controls: Checks that mapping changes are approved, documented, and tested before reporting.
Calculation and Example
A practical tie-out formula is: Mapped Cash Balance = Sum of GL Cash Accounts Included in Cash Mapping. This mapped balance should agree with the reported cash balance after approved adjustments.
Example: A company maps three GL cash accounts: operating bank $800,000, payroll bank $150,000, and restricted cash $50,000. Mapped Cash Balance = $800,000 + $150,000 + $50,000 = $1,000,000. If the balance sheet reports $1,000,000 of cash, the mapping ties out correctly.
Reporting and Analysis Role
GL cash mapping supports Cash Flow Analysis (Management View) by making cash activity easier to explain by source and purpose. For example, supplier payments should not be grouped with debt repayments, and capital expenditure should not be mixed with routine operating expenses.
It also supports Cash Flow Forecast (Collections View) because clean mapping gives treasury teams a reliable base for actual receipts, payments, balances, and expected liquidity movement.
Liquidity and Planning Use
Mapped cash data helps finance teams calculate liquidity measures such as the Cash to Current Liabilities Ratio and monitor operating cash timing through the Cash Conversion Cycle (Treasury View). These views are useful for payment planning, collections focus, funding decisions, and cash reserve management.
GL cash mapping can also support valuation work by providing cleaner cash flow inputs for a Discounted Cash Flow (DCF) Model, Free Cash Flow to Firm (FCFF) Model, and Free Cash Flow to Equity (FCFE) Model.
Best Practices
Maintain a clear mapping table for every cash GL account, bank account, entity, and reporting category.
Review new accounts, bank accounts, and ERP posting rules before they affect reporting.
Reconcile mapped cash balances to bank records, trial balance, and the balance sheet.
Document mapping changes with owner, date, reason, approval, and testing evidence.
Use an EBITDA to Free Cash Flow Bridge where mapping supports cash conversion analysis.
Compare mapped cash results with Free Cash Flow to Firm (FCFF) and Free Cash Flow to Equity outputs when used for valuation reporting.
Summary
GL Cash Mapping connects general ledger cash accounts and transaction activity to the right reporting categories. It improves cash flow accuracy, reconciliation quality, liquidity visibility, forecasting, valuation inputs, and business performance decisions by making cash data structured, traceable, and report-ready.
