Blog · Finance metrics and formulas · Finance and FP&A teams
Finance directors need explanations for cash, margin and budget movements that lead to a decision. Work through a monthly review, the source files, the checks and the person responsible for each follow-up.
Finance director data analysis should explain where cash went, why margins moved and which budget gaps require a decision. Start with reports that reconcile, then turn each material movement into a specific question, supporting rows and an accountable owner. A longer management pack does not help if it leaves the next action unclear.
The Bureau of Labor Statistics describes financial managers as preparing reports, supervising budgeting, reviewing costs and helping management make financial decisions. For a director, those activities meet in the operating review: what needs attention, what evidence supports it and what someone will do next.
Use a consistent set of questions rather than starting from whichever spreadsheet arrived last.
| Director's question | Measure to review | Files behind it | Follow-up owner |
|---|---|---|---|
| Can we meet committed payments? | Closing cash and dated receipts less payments | Reconciled bank balances, collections schedule, payables and payroll commitments | Treasury manager |
| Why did profit miss budget? | Revenue, gross profit and operating expense variances | Closed ledger, approved budget and account map | FP&A lead |
| Is margin pressure concentrated? | Gross profit dollars and margin by product or customer | Invoice detail, credit memos and matched direct costs | Commercial and operations leads |
| Is reported growth becoming cash? | Receivables movement and overdue invoices | Invoice register, cash application and aging | Credit manager |
| Does the next plan need to change? | Recurring versus timing differences | Owner explanations, open orders and committed spending | Budget owners |
The SEC's guide to financial statements distinguishes a balance sheet at a point in time from income and cash flow statements covering a period. Keep that distinction in the pack: a closing cash balance and monthly profit answer different questions.
Use September 2026 for an illustrative US distributor, Lakeview Supply. Each source file records its reporting period, entity, currency and extraction date. The budget sheet retains the approved version; a later forecast belongs in a separate column.
The controller first ties the management P&L to the closed ledger, confirms bank reconciliations and ties the aging total to trade receivables. Keep account and customer identifiers in the detail so an explanation can return to its original rows. Label preliminary accruals and unresolved differences before the director reads the results.
For this review, start with the following P&L. Variance means actual minus budget; positive cost variances therefore mean overspending.
| September line | Budget (USD) | Actual (USD) | Variance (USD) |
|---|---|---|---|
| Net revenue | 1,900,000 | 2,000,000 | 100,000 |
| Cost of goods sold | 1,235,000 | 1,360,000 | 125,000 |
| Gross profit | 665,000 | 640,000 | -25,000 |
| Operating expenses | 500,000 | 510,000 | 10,000 |
| Operating profit | 165,000 | 130,000 | -35,000 |
The first director question is why higher revenue produced lower profit. The bridge proves the size of the problem: $165,000 + $100,000 - $125,000 - $10,000 = $130,000.
Every further explanation must fit within that movement.
Gross margin = (Net revenue - Cost of goods sold) / Net revenue
Operating profit = Gross profit - Operating expenses
Budget gross margin is $665,000 / $1,900,000 = 35.0%; actual is $640,000 / $2,000,000 = 32.0%. The decline is 3.0 percentage points. Operating profit missed budget by $35,000, or 21.2% of the $165,000 budget, with percentages rounded to one decimal place.
Ask the commercial lead to identify discounting and customer mix, and operations to identify purchase-cost or fulfillment changes. Do not label the entire gross profit gap a pricing problem before checking those rows. The gross profit margin method explains how to calculate and reconcile the underlying measure.
Next ask which part of the operating expense overspend repeats. An annual invoice posted entirely in September has a different planning consequence from a permanent staffing addition. Record the evidence and accounting treatment rather than accepting “timing” as a complete explanation. Keep the budget variance analysis focused on the approved baseline.
This company started September with $300,000 of cash. Its reconciled cash movements are:
| Cash bridge step | Movement (USD) | Running cash (USD) |
|---|---|---|
| Opening cash | 300,000 | 300,000 |
| Customer receipts | 1,800,000 | 2,100,000 |
| Supplier payments | -1,390,000 | 710,000 |
| Payroll and other operating payments | -410,000 | 300,000 |
| Equipment purchases | -60,000 | 240,000 |
| New borrowing | 100,000 | 340,000 |
Closing cash is $340,000, an increase of $40,000. Without the new borrowing it would have been $240,000. The director therefore needs the debt movement beside the cash headline; the increase alone does not demonstrate stronger operating collection. A cash flow bridge provides the fuller presentation.
All September revenue in this example is on credit. The receivables bridge has no write-offs or other adjustments:
| Receivables bridge step | Amount (USD) |
|---|---|
| Opening trade receivables | 600,000 |
| Credit sales | 2,000,000 |
| Applied customer receipts | -1,800,000 |
| Closing trade receivables | 800,000 |
The check is $600,000 + $2,000,000 - $1,800,000 = $800,000. The credit manager must explain the increase using invoices and due dates. It does not, by itself, prove customers paid late.
End the meeting with a short action register. For each issue, record the dollar exposure, supporting file and rows, proposed action, owner, due date and evidence needed to close it. Keep a distinction between an observed fact and an untested explanation.
The margin review might require the commercial lead to return with customer-level price and mix evidence. The cash review might require treasury to confirm the next debt payment against expected collections. Reopen an issue at the next review if its promised evidence never arrives. If a question requires estimating an effect from a subset of observations, inferential data analysis is a separate method from reconciling this management pack.
Bring a management workbook with ledger, budget, receivables and cash detail: Covirage maps the columns, its tools compute and check the figures, and the external AI model explains the movements with every figure traced to its rows. Create a free Covirage account, which takes about a minute, then set up your business and bring a sample of your own data.
See how this fits finance team reporting.
Begin with closing cash, near-term commitments, gross profit and operating profit against the approved budget. Use the receivables aging, bank reconciliation, ledger and budget version behind those figures. A report that does not reconcile needs correction before a performance explanation.
Titles vary between companies, but the operating questions overlap. A finance manager may prepare the reconciliations and investigate exceptions, while the director sets priorities and approves actions. The useful distinction is who prepares, who challenges and who owns the resulting decision.
Use agreed dollar thresholds and business significance to prioritize review. A small recurring error or an approaching cash commitment may deserve attention even below the threshold. Group related movements so several individually small items do not conceal a material combined problem.