Chart of accounts mapping
Consistent financial definitions. A clear path back to the source.
Borrowers report the same financial concepts under different account names, codes and layouts. SpreadSpace brings supported income statements and balance sheets into your firm’s chart of accounts, with the original reported detail available for review.
A shared structure helps credit teams compare financial performance and explain their conclusions. For CECL and audit committee oversight, its value extends to the quality, consistency and traceability of the financial information used in the review.
Give every account a consistent meaning
Chart of accounts mapping connects the accounts or line items in a source document to a defined reporting structure. The destination account tells the reviewer what a figure represents and where it belongs in the analysis.
For example, “Legal and accounting” and “Professional fees” may belong in the same expense category when their underlying contents fit the firm’s definition. A consistent mapping lets analysts compare that category across periods without reconstructing the classification each time.
The definition matters as much as the name. A useful mapping keeps the original caption, the contributing amounts and the reporting context available so the reviewer can understand what was grouped together.
Make comparisons depend on shared definitions
KPMG’s Digital Accounting Manual describes a common finance language built from account definitions, reporting dimensions, accounting policies and KPI definitions. That combination matters: matching labels alone cannot resolve differences in accounting treatment or reporting scope.
Moody’s credit assessment materials similarly connect standardized analysis with financial spreading, including extracting, validating and mapping financial data from different sources. Standardization is part of making credit information usable across a workflow.
For a lending team, the practical implication is to define the categories once and apply them consistently. A movement in an expense ratio should be investigated as a business change, a reporting change or a mapping change, with enough evidence to tell the difference.
KPMG: Digital Accounting ManualMoody’s: Credit assessment solution
Preserve the distinctions behind the totals
Standardization should retain differences that affect the analysis. Trade receivables, loans receivable and amounts due from related parties can all be assets while carrying different collection considerations. Current debt maturities and long-term borrowings also need distinct treatment when assessing liquidity.
Consider a statement that reports gross receivables and a separate allowance for credit losses, while another reports receivables net of the allowance. Mapping both headline figures into the same row without preserving the gross or net basis can create a misleading comparison. The allowance balance and the period’s credit loss expense are different measures as well.
Keep the entity, period, currency, units and accounting basis with the figures. Book-basis financial statements and tax-basis returns require an explicit reconciliation before their differences can be treated as changes in business performance.
Give CECL consistent financial inputs
Current expected credit losses, or CECL, is an approach to estimating credit losses under FASB ASC Topic 326. FASB’s staff guidance explains that an estimate considers relevant historical experience, current conditions and reasonable and supportable forecasts. Management selects methods and information appropriate to the assets being evaluated.
Where borrower financial measures inform credit risk assessment, consistent account mapping helps make those measures comparable and traceable. It can help a reviewer distinguish a deterioration in the borrower’s finances from a change in how the figures were classified. This is a practical application of standardization to the input process, rather than a separate CECL requirement for a particular chart of accounts.
The loss estimate still needs the institution’s relevant exposure and loss information, assumptions, forecasts and estimation methodology. Mapping borrower statements alone does not calculate an allowance or establish CECL compliance.
Keep account mapping and risk pooling distinct
An account category describes a financial amount. A CECL pool groups financial assets with similar risk characteristics for collective evaluation. Putting two balances under the same account heading does not establish that their credit risks are similar.
The interagency policy statement on allowances for credit losses calls for collective evaluation when similar risk characteristics exist and individual evaluation when they do not. It also describes periodic reassessment of those characteristics.
Use a common chart to organize the financial information, then retain the additional detail needed for the institution’s methodology. Depending on the assets and method, that may include credit quality, contractual term, collateral, vintage, delinquency and historical loss experience.
Federal banking agencies: Allowances for credit losses policy statement
Make the mapping part of the control process
The federal banking agencies’ CECL FAQs highlight that information newly used for financial reporting may need controls it did not previously have. Their guidance addresses the relevance, reliability, completeness and accuracy of data and the controls surrounding its use.
Applied to account mapping, that means documenting the category definitions, assigning responsibility for changes and reconciling mapped totals to their sources. Unclassified items, ambiguous captions and manual adjustments need a review path. A common format is useful only when the transformation into that format can be explained.
When a mapping changes, assess the effect on comparative periods and downstream measures. Keep evidence of what changed, why it changed and who reviewed it. These are practices for the institution to establish within its control framework; a mapping tool is one part of that process.
Federal banking agencies: CECL FAQs, question 44 on data controls
Give the audit committee evidence it can question
AICPA’s overview of its Credit Losses audit and accounting guide highlights risk assessment, relevant controls, management estimates and evaluation of audit results. A standardized presentation supports that work when the underlying data and the judgments applied to it remain inspectable.
The Center for Audit Quality’s 2019 tool for audit committees raises questions about data gaps, data reliability, manual processes, control ownership and significant judgments. Applied to mapping, useful questions include: Who owns the account definitions? How are exceptions reviewed? What changed since the prior reporting period? Can a material figure be reconciled to its source?
A review package should make those answers available. Consistent categories let the committee follow the analysis; source detail, reconciliations and documented judgments let it challenge the explanation.
AICPA: Credit Losses guide overviewCenter for Audit Quality: A tool for audit committees, May 2019
Connect oversight to responsibility
The interagency policy statement assigns the board, or a committee of the board, oversight of management’s significant allowance judgments and estimates. Its expectations include reviewing policies, considering management’s support for reported allowances, requiring periodic validation and following up on audit findings.
Standardization helps organize the evidence for that oversight. Management remains responsible for the estimate and its controls, and auditors determine the procedures and evidence needed for their engagement. A consistent chart supports their work without deciding the accounting conclusion for them.
Federal banking agencies: Board and management responsibilities
Put your firm’s chart into practice
In SpreadSpace, authorized teams can configure the chart’s accounts and layouts, define caption rules and review saved chart versions. Apply a common presentation to supported income statements and balance sheets while keeping the reported statement detail available alongside the mapped view.
Start with representative statements and your firm’s account definitions. Review the classifications, examine the components behind totals and identify where a policy decision or additional source information is needed. Bring the resulting analysis into the spreadsheet and credit memo so the explanation stays connected to the financial review.
The external materials linked above inform the discussion of standardization and oversight. They do not constitute an endorsement or certification of SpreadSpace.
Bring your chart. Follow the evidence.
See how your account definitions translate into a consistent financial review. Bring a representative statement package and examine the mapped figures alongside the source detail.