Skip to main content

AI Budget Burn Rate and Runway Report

By the end of this recipe you'll get a clear monthly read on where the money is going — this month's burn, which categories are over or under budget, and how many months of runway you have left — written for you and posted straight to your finance channel. A burn-and-runway note is a read-and-narrate job: someone has to look across every spend board, add it up, compare it to plan, and write it in plain English. Because your budgets, expenses, and chat all live in one workspace, Copera AI can read the numbers and do that narration for you.

Readiness: Available now — ask Copera AI on demand, backed by over-budget automations that keep each category honest. A named teammate that reads your spend boards and posts the burn-and-runway note on its own monthly schedule is rolling out in early access.

What it does​

At the end of every month, finance and ops want the same three answers: What did we spend? Are we on plan? How long does the cash last? This recipe produces one channel post that answers all three, and it works in two layers:

  1. An always-on accuracy layer (automations). Small automations on your spend boards flag each category the moment it crosses its threshold — 90% of budget, or over — set a Watch status, and ping the owner. So your "over budget" view is always current and nothing quietly overruns in silence.
  2. A monthly narrated report (Ask Copera AI). On demand, Copera AI reads your spend boards, totals this month's burn against last month and against plan, calculates your net burn (spend minus income) and your runway (cash on hand ÷ net burn), calls out the biggest movers, and posts the summary to your finance channel — @mentioning the owner of anything over budget.

Splitting it this way is what keeps the report trustworthy: the automations keep the data honest category-by-category, and Copera AI turns that honest data into a narrative your team reads in ten seconds. Everything stays internal — it's a management read for your team, not a filing and not a substitute for your accounting system.

Build it yourself​

The monthly report itself is a read-and-narrate task, and the fastest way to produce it is to ask Copera AI (next section). What you build here is the accuracy layer — automations that keep each category's status honest and keep the month on a rhythm, so the report Copera AI writes is always right.

One-time setup​

Get your spend board ready

Open the board where you track spend and make sure each row has the columns a report needs to read: Category (a status or label), Budget (number), Spent (number), Date (date), and an Owner (people). Add two formula columns — Remaining (Budget − Spent) and % Used (Spent ÷ Budget) — so budget-vs-actual is computed for you and easy for both the automation and Copera AI to read. If you're not sure how columns fit together, see Boards Overview.

Give the runway math its inputs

Runway needs two numbers the spend rows don't hold: cash on hand and, if you have revenue, monthly income. Keep them somewhere Copera AI can read — a small Finance Summary row (cash on hand, this month's income) or a short document it can search. With those in place, the report can go beyond budget-vs-actual and actually answer "how many months of runway do we have?" If you're a pure cost center with no income, that's fine — the report focuses on burn pace and budget-vs-actual instead.

Automation 1 — the over-budget watchdog​

Trigger: Field changed

On the spend board, add an automation with a Field changed trigger watching the Spent column, so it re-checks a category every time its spend moves.

Condition: crossed the threshold

Add a Formula condition that continues only when the category is near or past its budget — for example Spent >= Budget * 0.9. (If you'd rather not write a formula, add a Compare two values condition on your % Used column with the greater or equal operator against 0.9.)

Action: set the Watch status

Add a Set field action to set a Status column to Watch (or Over budget when % Used is 1.0 or more). The category now surfaces in your over-budget view automatically.

Action: ping the owner

Add a Send direct message (or Send notification) action to the category's Owner — "Marketing just crossed 90% of its monthly budget." Now the person who owns the line hears about it the moment it happens, not only when the monthly report goes out.

Automation 2 — keep the month on a rhythm​

Trigger: Schedule

Add a second automation with a Schedule trigger set to the start of each month — for example the 1st at 8:00 AM.

Action: post the reminder

Add a Post channel message action to your #finance channel: "📊 New month — time for the burn & runway report. Ask Copera AI to read the spend boards and post it here." This keeps the report a habit instead of something that gets forgotten.

Optional action: open a fresh bucket

If you track budgets month by month, add a Create row action to open next month's budget row (and a Set date to now action to stamp when the period began), so each month has a clean row the report can read against.

tip

Want tiered alerts instead of a single threshold? Because % Used is a real number column, you can run the watchdog's Compare condition at more than one level — set Watch at 0.75, Warning at 0.9, and Over budget at 1.0 — and give each a different owner message. Same automation, a sharper signal as spend climbs.

Everything above uses documented Automation blocks — see the full list in Automations. What automations don't do on their own is read across all your spend boards and narrate one runway note — that's the read-heavy job Copera AI is built for, next.

Or just ask Copera AI​

This is the fastest path to the actual report, and the one we recommend. Open Ask Copera AI and ask for it in plain English:

"Read our Budget & Spend board and give me this month's burn and runway report. Show total spend this month versus last month and per category, flag every category over 90% of its budget, calculate our net monthly burn (spend minus income), and estimate our runway in months using the cash-on-hand figure on the Finance Summary board. List the three biggest spend increases since last month. Post it as a summary in the #finance channel and @mention the owner of any category that's over budget."

Ask Copera AI reads and searches your workspace data, so it opens the spend board, adds up spend by category, compares it to budget and to last month, and — using the cash and income figures it finds on your Finance Summary board or in a document it searches — divides cash on hand by net burn to estimate runway. Then it posts a channel message to #finance. With the default Ask before acting permission mode, it shows you the drafted summary on a review card before it posts — you read it, correct a number's context if you like, and approve. It only ever reads boards and posts to channels your own account can already reach. See the full capability list in What Copera AI Can Do.

A few useful variations of the same ask:

  • Keep it private first. Swap "Post it in #finance" for "DM it to me" to get a personal read before anything is shared with the team.
  • Span every cost. Add "…and include the Subscriptions and Payroll boards" so the burn total covers your whole spend, not just one board — Copera AI reads across each one.
  • Time the review. Add "…and check my calendar and suggest a slot this week to review this with leadership." Copera AI can read your schedule and factor it in.
  • Save the write-up. Add "…and also create a document called 'Burn & Runway — [month]' with the full breakdown" so you keep a dated record alongside the channel post.

To get this monthly, just ask at month-end (dictate it hands-free with Bankai voice if you're heads-down), or save the prompt somewhere handy and reuse it. For a version that runs entirely on its own, see the next section.

Make it a standing teammate​

Early access

AI teammates are rolling out gradually. If you don't see them in your workspace yet, they're on the way — everything in this guide can be built today as an Automation plus an on-demand ask to Copera AI.

When one is available, you can put a named teammate — a "Finance Analyst" — in charge of this whole report. On its own monthly schedule and under its own identity, it reads your spend boards, calculates burn and runway, and posts the note to your finance channel — no one has to ask. A teammate's read tools are always on and posting to channels is opt-in; it can't delete data or send anything outside your workspace, so the report stays a safe, internal briefing. Until then, the automations above plus the on-demand ask do the same job today. Learn more in AI Teammates.

Tips​

tip

Define "burn" once, in your columns. Decide what counts — which boards, which categories, whether payroll and subscriptions are in — and encode budget and spend as columns. Then your automations and your Ask Copera AI prompt read the same numbers every month, and the report stays consistent instead of drifting month to month.

tip

Keep the cash figure current. Runway is only as good as the cash-on-hand number you feed it. Update the Finance Summary figure whenever your balance changes (or point Copera AI at wherever you keep it), so "runway: 14 months" reflects reality rather than a stale snapshot.

tip

Ask for month-over-month, not just a total. A single spend total tells you little; "up 22% versus last month, driven by two new tools" tells you where to look. Tell Copera AI to compare against last month and name the biggest movers — it's reading the same board, so the comparison is grounded in your numbers.

tip

It's a management read, not your books. This report shows where money is going between closes; it isn't a statutory financial statement. Keep your accounting system as the system of record, and use this to stay ahead of the numbers day to day. Pair it with the invoice & AR chaser so cash coming in stays as current as the spend going out.

Frequently Asked Questions​

Can Copera AI calculate our burn rate and runway?​

Yes. Ask Copera AI reads your spend and budget boards, adds up this month's spend by category, works out your net monthly burn (spend minus income), and divides your cash on hand by that burn to estimate runway in months. It posts the summary to your finance channel, and by default shows you the message for approval before it posts.

How does Copera figure out our runway?​

Runway is your cash on hand divided by your average monthly net burn, where net burn is spend minus income. Ask Copera AI reads those figures from your boards — the spend rows for burn and a cash-on-hand number you keep on a finance board or in a document it can search — and does the arithmetic each time, applying the same rule so the number stays consistent.

Can I get the burn and runway report automatically each month?​

Today you get it on demand: ask Copera AI at month-end, or save the prompt and reuse it. A scheduled automation can post a reminder to run it and keep a fresh monthly bucket, while over-budget automations flag each category the moment it slips so the report is always accurate. A named AI teammate that reads your spend boards and posts the report on its own monthly schedule is rolling out in early access.

Does this replace our accounting software?​

No. This is a fast management read across the spend boards you already keep — burn pace, budget-vs-actual, and runway — not a substitute for your accounting system or statutory financials. Keep your books as the system of record; use this report to see where the money is going between closes.

Where does Copera get the spending numbers?​

From the boards you already track spend on — rows with an amount, a category, a date, and an owner — plus any figures you keep in a document, which Ask Copera AI can search. It only reads what your own account can access, so the report is scoped to boards and channels you can already reach.