How to Calculate Burn Rate in Tableau

Tracking your company's spending is a fundamental part of financial stability, and your burn rate is one of the most important metrics to keep an eye on. It tells you how quickly you're using up your cash reserves, which directly impacts your ability to operate and grow. This guide will walk you through exactly how to calculate and visualize your gross and net burn rate in Tableau, turning a scary number into an actionable management tool.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

What is Burn Rate (And Why Should You Care)?

In simple terms, burn rate is the speed at which your business is losing money. It's typically measured monthly. For startups and cash-flow sensitive businesses, it's not just a metric, it's a countdown clock that determines your financial runway - the number of months you can survive before your bank account hits zero.

But not all burn is the same. Understanding the two types gives you a more complete picture of your financial health.

Gross Burn vs. Net Burn

It's important to distinguish between gross and net burn, as they tell you two different stories about your company's finances.

• Gross Burn Rate: This is the total amount of money your company spends in a month on operating expenses alone. Think of it as your total cash output. This includes salaries, rent, software subscriptions, marketing costs, and other overhead. It shows you the total cost of running your business, regardless of revenue.
• Net Burn Rate: This is your company's true monthly loss. It's calculated by subtracting your monthly revenue from your monthly gross burn. If you spend $50,000 on expenses and bring in $30,000 in revenue, your net burn is $20,000. This is the figure that most directly affects your runway.

Tracking both is essential. A high gross burn isn't necessarily a problem if your net burn is low (or negative, meaning you're profitable!). However, if your net burn is consistently high, you know you either need to increase revenue or cut expenses to extend your company's lifespan.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Preparing Your Financial Data for Tableau

Before you can build anything in Tableau, you need clean, well-structured data. Great dashboards are built on a solid data foundation. You can usually export this data from your accounting software (like QuickBooks, Xero) or pull it from a dedicated financial spreadsheet.

Your data source should have at least these three columns:

• Date: A column with the specific date of each transaction (e.g., '01/15/2024'). Tableau needs this to analyze trends over time.
• Category: A column describing what the transaction was for (e.g., 'Salaries', 'Software,' 'Office Rent,' 'Sales Revenue'). This allows you to group expenses and revenue separately.
• Amount: The monetary value of the transaction.

Here's a simplified example of how your data should look:

Before connecting this data to Tableau, do a quick sanity check. Are the dates formatted consistently? Is the dollar amount stored as numbers? Clean, predictable data will save you headaches down the line.

Step-by-Step: Calculating Burn Rate in Tableau

With your data prepped, it's time to jump into Tableau. We'll use Calculated Fields to teach Tableau how to separate revenue from expenses and then calculate our burn rates.

Step 1: Connect to Your Data Source

Open Tableau and on the Connect pane, select your data source type. If your data is in a spreadsheet, choose Microsoft Excel or Google Sheets. Navigate to your file and connect to it. Tableau will show you a preview of your data on the Data Source tab. Make sure Tableau has correctly identified the data types for each column (e.g., Date for your Date column, not a Globe for geographical data, etc.).

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Step 2: Create Calculated Fields for Expenses and Revenue

Tableau doesn't automatically know which transactions are costs and which are income. We need to tell it. We'll do this using a couple of simple Calculated Fields.

1. Navigate to a worksheet (the tab at the bottom left that says 'Sheet 1').
2. Go to the top menu and select Analysis > Create Calculated Field.
3. Name the first field "Total Expenses". We'll use a simple IF statement to tell Tableau to only sum amounts that are not flagged as revenue. Assuming your revenue category is named 'Client Revenue' or something similar:

IF [Category] != 'Client Revenue' THEN [Amount] ELSE 0 END

This formula checks each row. If the 'Category' is anything other than 'Client Revenue,' it takes the 'Amount.' Otherwise, it assigns a zero. Click OK.

Now, let's do the same for revenue:

1. Create another Calculated Field and name it "Total Revenue".
2. Enter the following formula:

IF [Category] = 'Client Revenue' THEN [Amount] ELSE 0 END

This does the opposite - it isolates only the amounts associated with your revenue category. Click OK.

You now have two new measures in your Data pane: 'Total Expenses' and 'Total Revenue'.

Step 3: Create Calculated Fields for Gross and Net Burn

With our building blocks in place, calculating the burn rates is straightforward.

Your Gross Burn is simply your Total Expenses measure. You don't need a new calculation for it - you'll just put SUM([Total Expenses]) onto your chart.

For Net Burn, we need one more Calculated Field. This will subtract your revenue from your expenses.

1. Create a new Calculated Field named "Net Burn".
2. Enter this simple formula:

SUM([Total Expenses]) - SUM([Total Revenue])

A positive result for 'Net Burn' means you spent more than you earned that month (i.e., you are burning cash). A negative result means you were profitable.

Visualizing Your Burn Rate to Tell a Story

Now that the calculations are ready, you can build visualizations to analyze your burn rate trends quickly and intuitively.

Building a Monthly Burn Rate Chart

A bar chart showing your monthly net burn is a classic and effective way to see your financial performance at a glance.

1. Drag your Date dimension to the Columns shelf. Right-click on it and make sure it's set to Month (the option with a green calendar icon that ends in 'May 2015'). This will aggregate your data monthly.
2. Drag your Net Burn measure to the Rows shelf. Tableau will instantly generate a bar chart showing your net burn for each month.
3. Add color for instant clarity: Drag another copy of Net Burn from the Data pane onto the Color tile in the Marks card. By default, you'll get a blue gradient. Click the Color tile, choose 'Edit Colors', and select a diverging palette like 'Red-Green Diverging'. This will automatically color your profitable months green and your cash-burning months red, giving you a powerful visual cue.
4. Show the numbers: Drag Net Burn once more to the Label tile in the Marks card to display the exact amount on each bar.

Just like that, you have a dynamic chart showing your financial trajectory. You can easily spot trends, see the impact of a big new client, or notice when expenses are getting out of control.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Calculating and Visualizing Your Financial Runway

The next logical question after seeing your burn rate is, "How much time do we have left?" Let's add a Key Performance Indicator (KPI) to our dashboard to show our runway.

The formula is simple: Total Cash on Hand / Average Monthly Net Burn

Let's create this in Tableau.

1. Create a Cash on Hand Parameter: A parameter lets you input a value directly into the dashboard. Go to the little dropdown arrow in the top right of the data pane and select Create Parameter.
2. Calculate Recent Average Net Burn: A runway calculation is most useful when based on your recent spending. Open a new sheet and filter your data to show only the last 3-6 months. Then create a Calculated Field called "Average Monthly Burn":

([Net Burn] / 3)

*(Be sure to adjust the number (e.g., 3) to match the number of months in your filtered view).)

1. Build the Runway KPI: Finally, create the runway calculation as a new Calculated Field 'Runway (in Months)':

[Cash on Hand] / [Average Monthly Burn]

1. Visualize as Text KPI: Drag 'Runway (in Months)' onto the Text mark. Now you have a clear text-based KPI showing the remaining months that you can add to your final dashboard, which will dynamically change whether you have more or less cash in your bank accounts.

Final Thoughts

Monitoring your burn rate is a critical exercise for maintaining financial awareness and making strategic decisions. By moving this analysis from a static spreadsheet into an interactive Tableau dashboard, you gain a powerful lens through which you can understand your business's health, spot trends as they emerge, and accurately forecast your financial runway.

While building reports in Tableau is incredibly powerful, it can still feel time-consuming to set up and maintain a connection to all of your data sources. To help simplify this, we created Graphed, which automates much of this process. You connect financial or marketing sources like QuickBooks, Salesforce, and Google Analytics once, and from there you can just ask questions in plain English, like "show me our monthly net burn for the last 6 months." We instantly generate dashboards and charts that stay up-to-date in real-time, giving you back hours of your week and putting real answers at your fingertips.