Simple financial statements template

TRIAL BALANCE — this year and last year (balances before closing)
Yellow cells = you type · blue cells = calculated (do not overwrite) · example rows are fictional — replace them.
Company	Example Foods Corp. (sample)		Year end	2026-12-31	Currency	USD

Code	Account	Statement line	Debit — this year	Credit — this year	Debit — last year	Credit — last year
1000	Cash and bank	Cash	161,900.00		120,800.00
1100	Trade receivables	Receivables	236,500.00		198,200.00
1200	Inventory	Inventory	154,800.00		141,000.00
1300	Prepayments	Other current assets	18,200.00		15,600.00
1500	Equipment, net of depreciation	Property & equipment (net)	512,000.00		468,000.00
2000	Trade payables	Payables		132,600.00		118,900.00
2100	Accrued expenses and taxes	Other current liabilities		41,300.00		36,700.00
2200	Bank loan — current portion	Short-term debt		60,000.00		60,000.00
2500	Bank loan — long term	Long-term debt		240,000.00		300,000.00
3000	Share capital	Share capital		300,000.00		250,000.00
3100	Retained earnings (opening)	Retained earnings		178,000.00		61,000.00
3200	Dividends paid	Retained earnings	20,000.00
4000	Sales	Revenue		1,486,000.00		1,302,000.00
5000	Cost of goods sold	Cost of sales	921,300.00		820,300.00
6000	Salaries and admin	Operating expenses	288,700.00		251,600.00
6100	Depreciation	Depreciation	64,000.00		58,000.00
7000	Interest on bank loan	Interest expense	21,500.00		24,600.00
7100	Other income	Other income		4,800.00		3,500.00
8000	Income tax	Income tax	43,800.00		34,000.00









































TOTAL			2,442,700.00	2,442,700.00	2,132,100.00	2,132,100.00
Trial balance is balanced

© Layers (layers.md) · CC BY 4.0 · Free template. Check figures against your own rules and advisers.

Cash
Receivables
Inventory
Other current assets
Property & equipment (net)
Other non-current assets
Payables
Other current liabilities
Short-term debt
Long-term debt
Share capital
Retained earnings
Revenue
Cost of sales
Operating expenses
Depreciation
Interest expense
Other income
Income tax

INCOME STATEMENT
Example Foods Corp. (sample) · year ended 31 December 2026 · USD

	This year	Last year	Change
Revenue	1,486,000.00	1,302,000.00	14.1%
Cost of sales	921,300.00	820,300.00	12.3%
GROSS PROFIT	564,700.00	481,700.00	17.2%
Operating expenses	288,700.00	251,600.00	14.7%
Depreciation	64,000.00	58,000.00	10.3%
OPERATING PROFIT	212,000.00	172,100.00	23.2%
Interest expense	21,500.00	24,600.00	-12.6%
Other income	4,800.00	3,500.00	37.1%
PROFIT BEFORE TAX	195,300.00	151,000.00	29.3%
Income tax	43,800.00	34,000.00	28.8%
NET PROFIT	151,500.00	117,000.00	29.5%

Gross margin	38.0%	37.0%
Net margin	10.2%	9.0%

© Layers (layers.md) · CC BY 4.0 · Free template. Check figures against your own rules and advisers.

BALANCE SHEET
Example Foods Corp. (sample) · as at 31 December 2026

	This year	Last year
Cash	161,900.00	120,800.00
Receivables	236,500.00	198,200.00
Inventory	154,800.00	141,000.00
Other current assets	18,200.00	15,600.00
TOTAL CURRENT ASSETS	571,400.00	475,600.00
Property & equipment (net)	512,000.00	468,000.00
Other non-current assets	-	-
TOTAL ASSETS	1,083,400.00	943,600.00
Payables	132,600.00	118,900.00
Other current liabilities	41,300.00	36,700.00
Short-term debt	60,000.00	60,000.00
TOTAL CURRENT LIABILITIES	233,900.00	215,600.00
Long-term debt	240,000.00	300,000.00
TOTAL LIABILITIES	473,900.00	515,600.00
Share capital	300,000.00	250,000.00
Retained earnings (opening, less dividends)	158,000.00	61,000.00
Net profit for the year	151,500.00	117,000.00
TOTAL EQUITY	609,500.00	428,000.00
TOTAL LIABILITIES AND EQUITY	1,083,400.00	943,600.00
Check: assets − liabilities − equity	-	-






© Layers (layers.md) · CC BY 4.0 · Free template. Check figures against your own rules and advisers.

CASH FLOW STATEMENT (indirect method)
Example Foods Corp. (sample) · year ended 31 December 2026

	This year
Net profit	151,500.00
Add back: depreciation	64,000.00
(Increase) / decrease in receivables	-38,300.00
(Increase) / decrease in inventory	-13,800.00
(Increase) / decrease in other current assets	-2,600.00
Increase / (decrease) in payables	13,700.00
Increase / (decrease) in other current liabilities	4,600.00
CASH FROM OPERATING ACTIVITIES	179,100.00
Purchase of property & equipment (net)	-108,000.00
Other non-current assets	-
CASH FROM INVESTING ACTIVITIES	-108,000.00
Borrowings / (repayments) of debt	-60,000.00
Share capital issued	50,000.00
Dividends and other equity movements	-20,000.00
CASH FROM FINANCING ACTIVITIES	-30,000.00
NET CHANGE IN CASH	41,100.00
Cash at beginning of year	120,800.00
Cash at end of year	161,900.00
Check: equals cash on the balance sheet	-

Built from the change between the two balance sheets: if the balance sheet balances, the cash flow reconciles to cash.
© Layers (layers.md) · CC BY 4.0 · Free template. Check figures against your own rules and advisers.

CHECKS AND KEY RATIOS
Yellow cells = you type · blue cells = calculated (do not overwrite) · example rows are fictional — replace them.

	This year	Last year
Trial balance balanced	OK	OK
Balance sheet balances	OK	OK
Cash flow reconciles to cash	OK
Accounts without a statement line	0
Current ratio	2.44x	2.21x
Debt to equity	0.49x	0.84x
Return on equity	24.9%	27.3%
Revenue growth	14.1%


Before investors or an IPO the statements must be prepared under the applicable framework (IFRS, PFRS, US GAAP) and audited. This template is a first draft to see the numbers in one place.
© Layers (layers.md) · CC BY 4.0 · Free template. Check figures against your own rules and advisers.