Free, instant download
Excel financial report templates
A monthly profit and loss and cash flow for small businesses, with formulas built in. Enter your numbers and the totals and balances calculate themselves. Choose your templates, enter your email, and the files download straight away.
These templates are free to use for your own business. Your email is only recorded with the download, unless you tick Berkembang bersama Tumra.
What is inside
The two reports you will need most.
In this article
Monthly Profit and Loss template
One sheet for January to December. Enter revenue (product sales, service revenue, other income), cost of goods sold, and operating expenses. Gross profit, operating profit, net profit, and net margin calculate themselves for each month and the year.
Monthly Cash Flow template
Enter January's opening cash, then cash in and cash out each month. Each month's closing balance becomes the next month's opening balance. The last row shows how many months the cash would cover that month's outgoings.
How to use them
- Fill in the cream cells only; white cells hold formulas.
- Enter figures per month, in the same unit, such as full rupiah.
- Need another row? Insert it above the Total row in the same group and the formulas adjust.
- Record personal withdrawals in the cash flow as owner withdrawals, not as an expense in the profit and loss.
Profit and loss vs cash flow
The profit and loss tells you whether the business makes money. The cash flow tells you whether the money is there. A business can be profitable and still run out of cash, for example when customers pay late or stock piles up. That is why you need both.
FAQ
Questions about the templates
Are the templates really free?
Yes. No cost and no account needed. Enter your email and the files download straight away.
Do they work in Google Sheets?
Yes. Upload the .xlsx file to Google Drive and open it with Google Sheets; the formulas keep working.
I joined Berkembang bersama Tumra. How do I unsubscribe?
Every newsletter email has an unsubscribe link at the bottom. One click and you will not receive it again.
The files did not download. What should I do?
Click the template names that appear under the button; those links work for one hour. If your browser blocks the second download, allow multiple downloads for tumra.id.
From spreadsheets to reports that build themselves.
As your business grows, let Tumra build your profit and loss and cash flow from your transactions. Try it free for 30 days.