How to Create a Monthly Expense Report in Tableau with AI

Creating an interactive monthly expense report in Tableau can completely change how you understand your company's spending. This guide walks you through the step-by-step process of building a detailed dashboard and explains how new AI tools are making this task faster and easier than ever before.

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

First, Why Build an Expense Report in Tableau?

You might be wondering why you’d go through the trouble of using Tableau when a simple Excel spreadsheet seems to do the job. While spreadsheets are great for logging data, they’re not great for finding insights. A static table of numbers just doesn't reveal the story behind your spending.

By building your report in Tableau, you gain a few huge advantages:

• Visual Insights: It’s much easier to spot a spike in travel costs on a line chart than by scrolling through hundreds of rows in a spreadsheet. Visualizations bring trends and outliers to the forefront instantly.
• Interactivity: Tableau dashboards allow you to filter and drill down into your data on the fly. Want to see how much the sales team spent on software last quarter? Just a couple of clicks, and you have your answer.
• Accessibility: You can publish your dashboard online and share a link with stakeholders, ensuring everyone is looking at the same up-to-date information. No more emailing around outdated spreadsheet versions.

A Tableau dashboard turns your raw expense data into a dynamic tool for making smarter financial decisions.

Step 1: Get Your Expense Data Ready

Before you even open Tableau, the most critical step is preparing your data. A beautiful dashboard is useless if the underlying data is a mess. Your goal is to have a simple, clean, and structured table of your expenses.

Ideally, your expense report data should be organized in a spreadsheet (like Excel or Google Sheets) with clear columns. Here are the essential fields you’ll need:

• Date: The date the expense occurred. Make sure this is in a consistent format (e.g., MM/DD/YYYY).
• Category: The type of expense. This is key for analysis. Be consistent with your naming - use “Software” every time, not “Software,” “SaaS,” and “Software Subscriptions.”
• Vendor/Description: The name of the vendor or a brief description of the expense (e.g., "Uber," "Delta Airlines," "Starbucks").
• Amount: The monetary value of the expense. Ensure this column only contains numbers.

You might also include other helpful columns, like:

• Employee Name: Who incurred the expense.
• Department: The department associated with the spend (e.g., Marketing, Sales, Engineering).
• Payment Method: How the expense was paid (e.g., "Corporate Card," "Reimbursement").

Take a few minutes to clean your data. Remove any empty rows, fix typos, and standardize your categories. This small time investment will save you major headaches later.

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

Step 2: Connect Your Data to Tableau

With your clean dataset ready, it’s time to bring it into Tableau. Tableau can connect to dozens of different data sources, but for expense reports, you'll most likely be connecting to an Excel or CSV file.

1. Open Tableau Desktop.
2. In the "Connect" pane on the left, select the type of file you're using. For a spreadsheet saved on your computer, click Microsoft Excel.
3. Navigate to your saved expense report file and click Open.
4. Tableau will now show you a preview of your data. You can confirm that all your rows and columns look correct. If everything looks good, click on "Sheet 1" at the bottom left to move to the main workspace.

Your data is now connected, and you should see your column headers (like Date, Category, and Amount) listed in the "Data" pane on the left side of the screen.

Step 3: Build Your Core Visualizations

This is where the magic happens. We’ll build a few different worksheets, each with a unique chart or table. Later, we'll combine them into a single interactive dashboard.

Chart 1: Total Spend Over Time (Line Chart)

A line chart is perfect for showing trends. Let's build one to see how your spending fluctuates from month to month.

1. From the "Data" pane, drag the Date field and drop it onto the Columns shelf at the top of the screen.
2. Tableau will probably default this to "YEAR(Date)." Right-click on it, and select "Month" (the second one, which will look like "May 2023").
3. Now, drag the Amount field from the "Data" pane and drop it onto the Rows shelf.

Just like that, you have a line chart showing your total expenses for each month. This immediately allows you to see seasonality or any months with unusually high spending.

Chart 2: Spend by Category (Bar Chart)

Next, let's see where your money is going. A bar chart is the best way to compare spending across different categories.

1. Create a new worksheet by clicking the "New Worksheet" icon at the bottom.
2. Drag the Category field to the Rows shelf.
3. Drag the Amount field to the Columns shelf.
4. Click the "Sort Descending" icon in the toolbar (it looks like a few bars getting smaller) to order your categories from highest spend to lowest.

This simple bar chart instantly highlights your top expense categories, like Travel, Software, or Office Supplies. For a different visual take, you can go to the "Show Me" panel in the top right and select "Treemap."

Chart 3: Key Performance Indicators (KPIs)

Dashboards often feature big, prominent numbers at the top that show key metrics at a glance. Let’s create a few.

1. Create another new worksheet.
2. Drag the Amount field and drop it directly onto the Text mark on the "Marks" card. You will now just see a number.
3. Let's format it. Right-click on the "SUM(Amount)" pill in the Text mark, go to Format, select Pane, and under "Numbers," choose Currency (Custom) to add a dollar sign and appropriate formatting.
4. Let's title it "Total Spend." You can title your sheet this and just format the text on a dashboard later. Repeat this process on new sheets to create other KPIs, like a count of transactions or average expense amount.

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

Chart 4: Detailed Expense Table

While charts are great for a high-level view, sometimes you need to see the raw data. Let's create a table an administrator could use to look up specific transactions.

1. On a new worksheet, drag Date, Vendor, Category, and Amount to the Rows shelf.
2. Tableau may try to make a chart. To force it into a table, go to the "Show Me" panel and select the table icon.

This gives you a scrollable list of every single expense, perfect for detailed analysis when needed.

Step 4: Assemble Your Interactive Dashboard

Now that you have your individual charts, it's time to combine them into a single, cohesive dashboard.

1. Click the New Dashboard icon at the bottom of the window (the one with the four squares).
2. You'll see a blank canvas and a list of your sheets on the left. Simply drag and drop your sheets (line chart, bar chart, KPIs, table) onto the canvas. Arrange them in a way that makes sense, with KPIs at the top and more detailed charts below.
3. Make it interactive! This is the best part of Tableau. Click on your Spend by Category bar chart. In the top right corner of its container, you’ll see some small icons. Click the one that looks like a funnel – this is the "Use as Filter" button.

Now, if you click on the "Travel" bar in your category chart, the entire dashboard — the line chart and the detail table — will instantly filter to show you only data related to travel expenses. You've just created a powerful, interactive tool for exploring your company's financials.

How AI Drastically Simplifies This Entire Process

Following the steps above will get you a fantastic dashboard. But let's be honest: it still involves a learning curve. You have to understand Tableau's interface, the difference between dimensions and measures, and how to operate shelves and marks cards.

This is where AI is fundamentally changing the game. It shortcuts the tedious "how-to" so you can focus on the "what does it mean?"

Tableau’s Own AI Features

Tableau has incorporated some AI to speed up analysis. Features like "Ask Data" allow you to type a question in plain English, such as "what were the total sales last year by region," and Tableau will try to generate a visualization to answer it. Another feature, "Explain Data," attempts to automatically find potential explanations for unusual data points, saving you time on manual discovery.

These features are helpful for exploring data inside of an existing workbook, but they don't help with the initial heavy lifting of connecting sources and building the initial, multi-part dashboard.

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

The Next Wave: True Conversational AI Analytics

The real breakthrough comes from a new generation of analytics tools built around AI and natural language from the start. Instead of clicking, dragging, and dropping to build each individual chart, you can simply describe the dashboard you want.

You can give a prompt like:

“Build an interactive monthly expense dashboard. Show me total spending over time as a line chart, and a bar chart showing spend by category. Also include KPIs for total spend and number of transactions.”

An AI-powered platform can take that simple instruction, connect to your expense data, and generate the entire interactive dashboard — multiple charts, filters and all — in under a minute. It completely eliminates the manual build process. This democratizes data analysis, meaning anyone on your team, regardless of their technical skill, can get sophisticated reports without needing to spend dozens of hours learning a complex tool like Tableau.

Final Thoughts

Building a monthly expense report in Tableau is a powerful way to gain control over your business's finances. By visualizing your spending, you can spot trends, identify areas for savings, and make data-driven decisions. The traditional process requires some manual setup, but the insights are well worth the effort.

As AI becomes more integrated with data analysis, the barrier to entry is disappearing. At Graphed, we are focused on this exact future. We've built an AI data analyst that allows you to simply connect your data sources — whether from a spreadsheet or a live tool like QuickBooks — and create dashboards using natural language. This cuts out the complex setup so you can go from raw data to actionable insights in seconds, not hours.