Free Financial Statement Templates for Small Business
Financial statement templates are ready-made Excel sheets for the three reports lenders and investors ask for: profit and loss, balance sheet and cash flow. These three are free to download and built to work together.
Three free Excel templates
- Profit and loss template Owners who need a clean monthly P&L before a lender, investor or accountant asks for one 12 months · Excel · free download →
- Balance sheet template Owners who need to show what the business owns and owes, month by month 12 months · Excel · free download →
- Cash flow forecast template Owners who need to see in advance which month the bank balance gets tight 12 months · Excel · free download →
What are financial statements?
Financial statements are the standard reports that show how a business is doing in money terms. There are three: the profit and loss statement, the balance sheet and the cash flow statement.
Each answers a different question, which is why a lender asks for all three. This page explains what they do, which to start with and where to download a free Excel template for each.
What does each financial statement show?
Each statement shows one side of the business, and none can stand in for the others.
- Profit and loss: whether you made money over a period.
- Balance sheet: what you own and owe on one date.
- Cash flow: how much cash you will have at the end of each month.
A business can be profitable and short of cash at once. It can also hold plenty of cash and still owe more than it owns. You only see that by reading all three.
Which financial statement should you build first?
Build the cash flow forecast first if you have not started trading, and the profit and loss first if you already have sales. The reasoning is simple. Before launch, the question that decides things is whether you can fund the first months. After launch, the question is whether the business earns a margin.
We think most new owners start with the P&L because it feels familiar, and we would push back on that. The forecast is the one that tells you when to arrange funding. Build the balance sheet last, once the other two exist, because it draws on both.
Which template fits what you need?
Pick by the question you are trying to answer.
| Template | Question it answers | Layout | Best for |
|---|---|---|---|
| Profit and loss | Did we make money? | 12 months plus a Year total, revenue to net profit | Trading businesses and anyone reporting results |
| Balance sheet | What do we own and owe? | Opening balance plus 12 month-ends, with a check row and three ratios | Lender packs and year-end reviews |
| Cash flow forecast | Will we have enough cash? | 12 months, direct method, minimum cash buffer flag | Startups, seasonal businesses and loan applications |
Every file has a How to use sheet and an Example sheet. The Example uses one made-up café, so the three examples tell a single story. Its figures are invented and are not benchmarks.
How do the three statements fit together?
Net profit from the P&L adds to equity on the balance sheet, and closing cash from the forecast sits in the balance sheet’s cash line. That is why the three agree when they are built right.
The profit and loss records sales when earned. The cash flow forecast moves them to the day the money lands and adds loans, tax and equipment. The balance sheet then freezes the result at each month-end. If the balance sheet’s check row will not clear, one of the other two is usually the culprit.
What do lenders and investors look for across the statements?
They look for consistency. The same sales figure, loan and cash balance should appear in all three, and the assumptions behind them should be written down.
A reader who finds the P&L profitable, the forecast showing a funding gap and no explanation will stop trusting the rest. Our guide to what SBA lenders look for in a business plan explains how a lender reads a financial package, and our business plan template shows where the statements sit in the plan itself.
We would rather you showed a realistic tight month than a flawless set of numbers. Statements that never wobble look built to impress, and most readers have seen enough of those. No template can promise a loan or an investment. What yours can do is survive questions.
Should you use these templates or a full financial model?
Use these three for a single year of statements, and a financial model template when you need five years of monthly projections built from assumptions. The statement templates are the simplest way to get a clean set of numbers in front of a lender or an accountant.
If your figures are going into a funding request, our financial forecasts service builds them for you. For the one-off costs that feed your first month of cash flow, try the startup costs worksheet, and browse the rest of the resources hub for other free tools.
Need more than one year?
These templates cover one year, month by month. For a five-year forecast where all three statements are built from one set of assumptions, use a free financial model template. For the written plan, get the free business plan template, or see every free resource.
Financial statement templates: common questions
What are the three financial statements?
The profit and loss statement, the balance sheet and the cash flow statement. Together they show what you earned, what you own and owe, and where your cash went.
Which financial statement should I build first?
For a business with no history, start with the cash flow forecast. For a business already trading, start with the profit and loss statement.
Are the financial statement templates free?
Yes. Enter your details and download the Excel file for each one. There is no trial and no card.
Do the three templates link to each other?
They are separate files that follow the same logic. Net profit from the P&L feeds the balance sheet, and closing cash from the forecast should match the balance sheet cash line.
Do I need an accountant to use them?
No. Each file has a How to use sheet and a worked example. An accountant can still check the result before it goes to a lender.