Free tool
Monthly financial report template, filled in from your own numbers
Pick your industry and check seven numbers. You get the core of a monthly financial report: a profit and loss month by month for the next 12 months, a balance sheet, a cash-flow statement and a 13-week cash flow forecast, plus an Excel file with live formulas you can update. No signup, no email.
Updated
Build your report
1Your industry
2Your numbers
Prefilled with the figures of Halverson & Delacroix LLP, the example professional practice in our sample report. Replace each number with yours. Reset to the example
How it is calculated
- Twelve months, starting on the 1st of next month, from the cash you have today. Sales run at the pace of the last 12 months; for SaaS they grow by your monthly rate, for hospitality they follow your seasonal swing with the peak in July.
- Profit and loss. Cost of sales = revenue × (100% − gross margin). Operating costs stay at the monthly figure you typed. Operating profit = gross profit − operating costs.
- Balance sheet. Receivables = a month’s sales × days customers take to pay ÷ 30. Supplier payables = a month’s cost of sales × days you take to pay ÷ 30. Stock = a month’s cost of sales × stock days ÷ 30. Retainage = the share held back on the last six months of bills. Equity grows by each month’s operating profit.
- Cash-flow statement. Operating profit, less the increase in receivables, retainage and stock, plus the increase in supplier payables. Cash at the end of each month is the balance-sheet cash.
- 13-week forecast. The first three months of the cash-flow statement, spread over weekdays: customer receipts and supplier payments evenly, operating costs 40% on the first weekday of the month and 30% each on the 15th and the last weekday (payroll). Week 13 ends on the last day of month three, on the same balance.
- Not in your inputs, so not in the report: loans, equipment purchases, depreciation, income tax and owner draws. Add them in the Excel file.
Every figure is whole dollars, rounded once, and every total adds up the rounded lines — so the balance sheet balances to the dollar, the cash flow ends on the balance-sheet cash and week 13 ends on month three’s cash. The page checks all three under the report.
What goes in a monthly financial report
The statements are the core: a profit and loss for the month and the year to date, a balance sheet at the month end and a cash-flow statement. Around them, a useful monthly report compares each line with the prior month, the same month last year and the budget, and says in a sentence what moved and why. The monthly management report template lays out every section, and what management reporting is explains who reads which page.
This template gives you the statements and a forward look from your own numbers. The comparisons and the explanations need your actual books: last month, last year and the budget are in your ledger, not in seven numbers.
Questions
What goes in a monthly financial report?
At least a profit and loss for the month and the year to date, a balance sheet at the month end and a cash-flow statement that shows why cash moved. Many owners add a short cash forecast, so the report says what happens next as well as what happened.
How do I use this template every month?
Open the Excel file and change the inputs: the statements and the 13 weeks recalculate. It stays an estimate from those inputs; a report from your actual ledger needs your books, which is what Ataski's Financial Analyst reads when you connect your accounting system.
Is this my company's real financial report?
No. It is an estimate built from the numbers you type, with the rules listed under How it is calculated. Your real statements come from your books: connect your accounting system and Ataski's Financial Analyst builds them from your ledger every month.
Do you save the numbers I type?
No. There is no signup and no email field. The numbers are sent to our server only to build the page and the Excel file; they are not written to a database or a log, and they never appear in a web address. We count that a report was built and for which industry, never the figures.
What is in the Excel file?
The same statements month by month and the 13-week forecast, built with formulas from an Inputs sheet: change an input and every statement recalculates. A Checks sheet shows that the balance sheet balances, the direct and indirect cash flows agree and week 13 ends on the same cash as month three.
Why does the balance sheet show only cash, receivables, stock and payables?
Those are the balances your inputs describe. Equipment, loans, taxes and owner draws are not in the form, so they are not in the estimate; add them in the Excel file.