How to Create a Burn Rate Report with AI: A Full Guide
A burn rate report shows how much cash the business consumes per month and how many months of runway that leaves. Build it by picking one basis and stating it, separating recurring spend from one-off spend, and reporting gross and net burn side by side. The number is easy. The three judgment calls behind it are where reports go wrong.
What a burn rate report actually shows
Burn rate is one of the few numbers a founder, a board member, and a new engineer all think they understand the same way. They usually do not.
A useful report answers four questions on one page:
- Gross figure. Total cash out per month, before any revenue is netted against it.
- Net figure. Cash out minus cash in. This is the number runway is built on.
- Runway. Cash on hand divided by net burn, expressed in months.
- What changed. Which category moved, and whether the move repeats next month.
Reporting only the net line hides a real risk. A company with heavy gross spend and matching revenue looks calm until one customer churns. Showing both is the difference between a report and a reassurance.
The three judgment calls
None of these are arithmetic. All three change the answer.
1. Cash basis or accrual basis
This is the first fork, and it is worth naming explicitly on the page.
The IRS describes the two methods plainly in Publication 538. Under the cash method, you report income "in the tax year you receive it", and deduct expenses in the year you pay them. The accrual method differs. There you report income "in the tax year you earn it, regardless of when payment is received". Expenses are deducted in the year incurred rather than paid.
For this report, cash basis is usually the right choice, because runway is a bank-balance question. Accrual gives you a truer picture of the period's economics. The publication states that the purpose of accrual is to "match income and expenses in the correct year."
Pick one, write it in the report header, and do not switch mid-series.
Scope note: Publication 538 is a tax guide on accounting periods and methods, revised January 2022. It is not a management-reporting standard, and an internal cash report is not a tax filing. What travels across is the definition of the two bases, which is what makes the choice explicit instead of accidental.
2. Run-rate or actual
A single annual insurance payment lands in one month. Reported as-is, that month looks broken.
Two defensible treatments exist. Report actuals and annotate the spike, or amortise known annual items across twelve months and label the page as run-rate. Both are fine. Mixing them silently is not.
3. What counts as cash out
Payroll, contractors, software, hosting, rent, and marketing are uncontroversial. These four are not: capitalised equipment, loan principal repayments, tax payments, and deposits held on your behalf. Decide, document, apply to every month.
What belongs on the page
One table carries the whole report. Everything else is commentary.
| Column | What goes in it | Why it matters |
|---|---|---|
| Month | The period, on one stated basis | A series is only comparable if the basis holds |
| Cash out by category | Payroll, contractors, software, hosting, rent, marketing | Category is what a decision acts on |
| Cash in | Collections actually received that month | Netting is what runway depends on |
| Net figure | Cash out minus cash in | The line the board reads first |
| Rolling 3-month average | The same net figure, smoothed | A single month is noise |
| One-off flag | Any line over 10% of monthly spend that appears once | The most common source of a wrong runway |
| Runway | Balance divided by the average, in months | Needs the balance as-of date beside it |
The one-off flag is the column people leave out. Without it, an annual insurance payment reads as a permanent step change in spending.
What you need before you start
Three inputs, and they usually already exist:
- A bank or ledger export covering at least six months, with date, amount, and category or memo per line.
- The current cash balance, as of a stated date.
- A revenue or deposits export, if inflows are not already in the same file.
Six months is the practical minimum. Three months of data cannot distinguish a trend from a quarter-end.
How to build the report manually
Option 1: Sum the bank statement by month. Fast, and it gives you the gross figure only. Useful as a sanity check, not as a report, because uncategorised outflows tell you nothing about what to do.
Option 2: Pivot the ledger by category and month. This is the correct shape. You categorise every line, pivot by month, and compute the net line and runway underneath. Then the problems start. Categories drift as people rename them, one-off items sit unmarked, and the same vendor appears under three spellings.
Option 3: Build a rolling three-month average alongside the monthly figure. The accurate version, and the slowest. A single month is noisy, so runway computed on one month swings wildly. The average is what a board should see, and maintaining both columns doubles the reconciliation work.
The output is fine in all three cases. The upkeep is the cost, and it recurs every month forever.
How to create a burn rate report with AI
Step 1: Upload your ledger and revenue files
Drop the bank or ledger export, the revenue file, and a note of the current cash balance into Powerdrill Bloom together. Excel, CSV, and PDF are all accepted, and the columns do not need to match beforehand.
Step 2: Describe the report in natural language
Say what you want rather than how to compute it. For example: "Categorise outflows by month on a cash basis. Give me the gross figure, the net figure, and a rolling three-month average. Compute runway from a balance of X as of this date, and flag any line above 10% of monthly spend that appears only once."
That last clause is the one-off detector, and it is the clause people forget. Unflagged one-offs are the most common reason a runway figure is wrong.
Step 3: Review the categorisation, then export
Read the uncategorised and single-occurrence lines first — that is where the number bends. Then export as a sheet, an Office document, or slides. Set a scheduled task so next month rebuilds itself from a fresh export.
Common mistakes
Reporting a single month as the rate. One month is a data point. Show the rolling average next to it, and let the board see both.
Computing runway on the gross figure. It overstates the problem when revenue is real. Net is the runway input; gross is the risk disclosure.
Letting the cash balance date drift. A runway figure is meaningless without the as-of date of the balance it divides. Put the date in the header.
Treating a hiring plan as if it were current spend. Planned headcount is a forecast, not a rate. If the report includes it, that is a separate column with a separate label.
Switching basis between periods. A series that starts on cash and moves to accrual shows a trend that did not happen. Pick one and hold it.
For the profitability view of the same ledger, see creating a gross margin report and a budget versus actual report. For tooling options, our roundup of AI tools for financial analysis covers the wider category.
Conclusion
A burn rate report is not hard arithmetic. It is three judgment calls wrapped in a pivot table: which basis, run-rate or actual, and what counts as cash out. Every disputed figure traces back to one of those three going unstated.
Hand the categorising and the pivoting to an agent. Spend your time on the three decisions and on the lines it could not classify.
Build your first burn rate report free from the export you already have. For recurring finance work, the AI report generator and the Excel AI assistant handle the same files.
IRS material quoted here is from Publication 538 as published on irs.gov, retrieved September 3, 2026.
Frequently asked questions
What is a burn rate report?
It is a monthly report showing the gross figure, the net figure, and the resulting runway, with spend broken out by category. It states the accounting basis used and separates recurring spend from one-off items.
How do you calculate runway from burn rate?
Divide cash on hand by the monthly net figure. Use a rolling three-month average rather than a single month, and state the as-of date of the cash balance in the report header.
What is the difference between gross burn and net burn?
Gross is total cash out per month. Net subtracts cash in. Runway is computed from the net line, while gross shows how exposed you are if revenue stops.
Should a burn rate report use cash or accrual basis?
Cash basis is usually the better fit, because runway is a question about the bank balance. Accrual matches expenses to the period that caused them. Either works as long as the report names which one it uses.
Can AI build a burn rate report from a bank export?
Yes. Upload the ledger or bank export with a revenue file and the current cash balance, then describe the report in natural language. The categorisation, the monthly pivot, the rolling average, and the flagged one-off lines come out of one run.