Blog · Board and management reporting · Finance and FP&A teams
Preparing financial statements starts with an adjusted trial balance and supporting reconciliations. Follow the account mapping, sign conventions, linked statement totals and cash checks before analyzing the completed reports.
Preparing financial statements starts with an adjusted trial balance, approved account reconciliations and a clear reporting basis. Map the balances into statements, carry net income into equity and prove the cash movement with supporting schedules. Accounting staff own the preparation and approval before anyone analyzes the completed reports.
Use the final adjusted trial balance for one entity and period. Confirm whether it is before or after closing revenue and expense accounts into retained earnings. This example uses an adjusted pre-closing export, so revenue, expenses and dividends remain separate, and retained earnings is the beginning balance.
Gather the prior approved balance sheet, bank reconciliation, receivables and inventory reconciliations, payable support, fixed-asset rollforward and debt schedule. Identify the exact version approved for reporting. Reconcile subsidiary balances and consolidation entries before using a consolidated export.
OpenStax's statement preparation chapter shows how the adjusted trial balance feeds income, retained earnings and the balance sheet. The monthly financial report template provides a recurring reporting layout; the task here is making its accounting inputs and statement connections reliable.
For a fictional US distributor, place account names in column A, report groups in B, debits in C and credits in D. The table starts on spreadsheet row 2 and ends on row 17. Zero means a confirmed zero balance on that side of the account.
| Account | Report group | Debit (USD) | Credit (USD) |
|---|---|---|---|
| Cash | Asset | 180,000 | 0 |
| Accounts receivable | Asset | 240,000 | 0 |
| Inventory | Asset | 180,000 | 0 |
| Equipment at cost | Asset | 400,000 | 0 |
| Accumulated depreciation | Asset | 0 | 120,000 |
| Accounts payable | Liability | 0 | 200,000 |
| Debt | Liability | 0 | 160,000 |
| Common stock | Capital | 0 | 300,000 |
| Beginning retained earnings | Retained | 0 | 120,000 |
| Dividends declared and paid | Distribution | 20,000 | 0 |
| Revenue | Revenue | 0 | 1,860,000 |
| Cost of goods sold | Expense | 1,200,000 | 0 |
| Other operating expenses | Expense | 420,000 | 0 |
| Depreciation expense | Expense | 40,000 | 0 |
| Interest expense | Expense | 20,000 | 0 |
| Income tax expense | Expense | 60,000 | 0 |
| Total | 2,760,000 | 2,760,000 |
Add a signed balance in E2 and fill through E17:
=C2-D2
The trial balance check must be zero:
=SUM(C2:C17)-SUM(D2:D17)
Keep accumulated depreciation negative within assets. Do not apply an absolute-value formula to every account: it would turn the contra-asset into an addition to equipment. Investigate an unexpected sign before changing the mapping.
Use these exact spreadsheet formulas, with H2 containing revenue, H3 total expenses and H4 net income:
H2: =-SUMIF(B2:B17,"Revenue",E2:E17)
H3: =SUMIF(B2:B17,"Expense",E2:E17)
H4: =H2-H3
Revenue is presented as a positive credit balance; expenses are positive debit balances. The income statement is:
| Statement line | Calculation | Amount (USD) |
|---|---|---|
| Revenue | Trial balance revenue | 1,860,000 |
| Cost of goods sold | Trial balance expense | 1,200,000 |
| Gross profit | 1,860,000 - 1,200,000 | 660,000 |
| Other operating expenses | Trial balance expense | 420,000 |
| Depreciation | Trial balance expense | 40,000 |
| Operating income | 660,000 - 420,000 - 40,000 | 200,000 |
| Interest expense | Trial balance expense | 20,000 |
| Pretax income | 200,000 - 20,000 | 180,000 |
| Income tax expense | Trial balance expense | 60,000 |
| Net income | 180,000 - 60,000 | 120,000 |
H3 sums to $1,740,000, and H4 returns $120,000. Link that same income cell into the retained earnings calculation in H5:
=-E10+H4-E11
Ending retained earnings is 120,000 + 120,000 - 20,000 = $220,000. Dividends reduce equity; they do not reduce net income. In a post-closing export, current profit and distributions have already been closed into equity, so this formula would double count them.
The SEC's financial statement guide explains the basic identity: assets equal liabilities plus shareholders' equity. Using the signed balances preserves that identity:
Assets: =SUMIF(B2:B17,"Asset",E2:E17)
Liabilities: =-SUMIF(B2:B17,"Liability",E2:E17)
Common stock: =-SUMIF(B2:B17,"Capital",E2:E17)
| Balance sheet check | Calculation | Amount (USD) |
|---|---|---|
| Assets | 180,000 + 240,000 + 180,000 + 400,000 - 120,000 | 880,000 |
| Liabilities | 200,000 + 160,000 | 360,000 |
| Equity | 300,000 + 220,000 | 520,000 |
| Liabilities plus equity | 360,000 + 520,000 | 880,000 |
| Difference | 880,000 - 880,000 | 0 |
The debt schedule determines the current and noncurrent split; an aggregated debt account does not supply that classification. Likewise, the supporting schedules determine presentation details and disclosures. A mathematical tie is a control, not evidence that every accounting judgment is correct.
A trial balance contains closing positions, not a complete explanation of cash receipts and payments. This simplified example has no acquisitions, disposals, noncash financing or other operating balance changes:
| Supporting balance | Opening (USD) | Closing (USD) | Increase / decrease (USD) |
|---|---|---|---|
| Cash | 160,000 | 180,000 | 20,000 |
| Receivables | 210,000 | 240,000 | 30,000 |
| Inventory | 160,000 | 180,000 | 20,000 |
| Accounts payable | 170,000 | 200,000 | 30,000 |
| Equipment cost | 320,000 | 400,000 | 80,000 |
| Accumulated depreciation | 80,000 | 120,000 | 40,000 |
| Debt | 180,000 | 160,000 | -20,000 |
Operating cash flow is 120,000 net income + 40,000 depreciation - 30,000 receivables - 20,000 inventory + 30,000 payables = $140,000. The fixed-asset schedule confirms that all equipment additions were paid in cash, producing investing cash flow of -$80,000. Financing cash flow is -20,000 debt repayment - 20,000 paid dividends = -$40,000; there were no share transactions.
The cash movement is 140,000 - 80,000 - 40,000 = $20,000. Opening cash of $160,000 plus that movement equals the $180,000 trial balance amount. For a deeper cash-specific walkthrough, see cash-flow statements from a trial balance.
Label the approved output with the entity, reporting basis, period and version. Interim financial statements need matching comparative periods; restated financial statements need explicit version comparisons when corrected reports are supplied.
Bring your finalized ledger export and prepared financial reports to Covirage, which maps the columns and uses its tools to compute and check totals and period movements. The external AI model explains those results with every figure traced to its rows. Create a free Covirage account and bring a sample of your own data.
See FP&A reporting with Covirage for the supporting reporting context.
A closing trial balance supplies account balances, but it does not explain every cash movement or disclosure. You also need opening balances and supporting schedules for items such as fixed assets, debt, equity transactions and noncash activity. Keep that evidence with the prepared reports.
The income statement establishes net income. That amount feeds the equity rollforward, whose closing balance feeds the balance sheet. The cash-flow statement then reconciles profit and balance movements using supporting schedules. Review the connections together before releasing the set.
No. Equal debits and credits show that the export balances mathematically. An omitted transaction, incorrect classification or equal error on both sides can still remain. Review account reconciliations, cutoff and approved adjustments before using the figures for financial reporting.