How Expense Data Connects to Your Burn Rate
Understand the data flow from the AskBiz Expenses tab through to the burn rate calculation, and why keeping expenses up to date makes every CFO metric more reliable.
Key Takeaways
- The Daily Net Gain/Burn card reads directly from the expenses recorded in the Supabase database.
- Missing or incorrect expenses cause the burn rate to appear lower than reality, overstating runway.
- Logging expenses in real time — rather than in batches at month end — keeps burn rate metrics current.
The Data Flow From Expense to Metric
Every time you save an expense in AskBiz, the record is written to the cfo_expenses table in your Supabase database. The CFO dashboard reads from this table whenever it calculates the metric card values. The Daily Net Gain/Burn card queries the expenses table for all expenses with today's date (or the current period) and sums them. It then compares this outflow total against the revenue data from your point-of-sale system or manual revenue entries to compute the net figure. The result appears on the card within seconds of you saving a new expense.
How Burn Rate Is Calculated
The burn rate calculation in AskBiz uses a rolling average of your recent expense data rather than a single day's figure. This smooths out one-off large payments — a quarterly rent payment, for example — so the daily burn rate reflects your typical ongoing cost base rather than spiking on payment days. The rolling window is typically 30 days. Total expenses over the last 30 days are divided by 30 to produce a daily average burn figure. If the sum of your daily average revenue exceeds this daily average burn, the card shows a positive net gain. If burn exceeds revenue, it shows a net burn figure.
Free — no card needed
See this in action for your business
AskBiz tracks these metrics automatically — just connect your data and start asking questions.
Start for free →The Impact of Missing Expenses
If you forget to log expenses, the burn rate will appear lower than it actually is. For example, if your actual monthly expenses are 8,000 but you have only logged 5,000, the dashboard will calculate burn based on the 5,000 figure. This produces an overstated runway estimate. If your current cash balance is 40,000 and actual burn is 8,000 per month, real runway is 5 months. But if the dashboard sees only 5,000 in expenses, it calculates a 6,000 burn rate (mixing logged and configured costs) and shows 6.5 months of runway — a 30 percent overstatement. Financial decisions made on the basis of the 6.5-month figure could leave your business short of cash.
Expenses and the Cash Runway Card
The Cash Runway card takes the current cash balance and divides it by the average monthly burn rate to project how many months of operating cash remain. Since burn rate depends on expense data, a well-maintained Expenses tab translates directly into a reliable Runway card. Every time you scan a receipt or manually add an expense, you are improving the quality of your runway estimate. The more complete and timely your expense recording, the more trustworthy the runway number.
Building a Daily Expense Logging Habit
The most effective approach is to log expenses as they happen rather than batching them at the end of the week or month. For physical receipts, scan them immediately after receiving them using the floating camera button. For digital invoices and subscription charges, set a daily two-minute habit of checking your email for new receipts and logging them. Month-end batch logging means your burn rate data is stale for most of the month, which reduces the utility of the real-time CFO dashboard. Frequent small logging sessions take less total time than one large catch-up session and keep your metrics accurate all month.