How to Create an Accounts Receivable Dashboard in Tableau

Building a valuable Accounts Receivable (AR) dashboard in Tableau is one of the best ways to get a firm handle on your company's cash flow. Forget sifting through spreadsheets, we’re going to build a visual command center for your finances. This guide will walk you through creating a clear, actionable AR dashboard from scratch, transforming raw invoice data into critical business insights.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Why Is An Accounts Receivable Dashboard So Important?

An AR dashboard does much more than just show you who owes you money. It acts as a health check for your business, providing instant visibility into your cash position and customer payment habits. When done right, it helps you move from reactive collections to proactive financial management.

Here are a few key benefits:

• Improved Cash Flow: At a glance, you'll see exactly how much cash is tied up in unpaid invoices. This helps you forecast more accurately and understand when to put more energy into collections.
• Early Warning System: Spotting which customers are consistently paying late allows you to address the issue before it escalates. You can identify at-risk accounts and adjust credit terms if needed.
• Efficient Collections: Instead of guessing, your team can prioritize their focus on the largest and oldest outstanding invoices, making their efforts far more effective.
• Key Performance Tracking: Metrics like Days Sales Outstanding (DSO) become easy to monitor. You can track whether your collection efforts are improving over time and how you stack up against industry averages.

For founders, this dashboard offers a bird's-eye view of your company’s financial stability. For sales and marketing teams, it can even reveal which types of customers are the most reliable and profitable in the long run.

Step 1: Get Your AR Data Ready

Before you can build anything in Tableau, you need solid, clean data. This is often the most time-consuming part of the process, but getting it right will save you countless headaches later. Your data might live in your accounting software (like QuickBooks or Xero), your CRM (like Salesforce), or even a series of detailed spreadsheets.

Regardless of the source, your goal is to create a single table or 'flat file' with the following essential columns:

• Invoice ID: A unique identifier for each invoice.
• Customer Name: The name of the client.
• Invoice Date: The date the invoice was issued.
• Due Date: The date payment is contractually due.
• Invoice Amount: The total amount of the invoice.
• Amount Paid: How much has been paid against the invoice (can be $0 or a partial amount).
• Payment Date: The date the final payment was made. For open invoices, this cell will be blank or NULL.

When preparing your data, check for common issues like inconsistent date formats (e.g., 1/15/2024 vs. 15-Jan-2024), misspelled customer names, and an incorrect data type (e.g., an invoice amount formatted as text instead of a number). Clean and consistent data is the foundation of a reliable dashboard.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Step 2: Connect Your Data to Tableau

Once your data is cleaned and consolidated (likely into a CSV or Excel file), it's time to bring it into Tableau. Tableau has built-in connectors for dozens of file types and databases, making this process straightforward.

Follow these quick steps:

1. Open Tableau Desktop.
2. On the main start page, under the "Connect" pane on the left, select the appropriate data source. For this example, we'll choose Microsoft Excel.
3. Navigate to your saved AR data file and click "Open."
4. Tableau will now show you the 'Data Source' tab. You'll see an overview of your data columns and the first few rows. This is your chance for a final review.
5. Check that Tableau has correctly identified the data types for each column (e.g., "Invoice Date" should have a calendar icon, "Invoice Amount" should have a # sign). If anything is incorrect, you can click the icon and change it.

With your data loaded, you're ready to start building. Click on the first sheet tab (labeled 'Sheet 1') at the bottom left to enter the Tableau workspace.

Step 3: Create Essential Calculated Fields

This is where the magic happens. Calculated fields allow you to create new data from your existing data source. For an AR dashboard, a few specific calculations are critical for breaking down your invoices by their status and age.

In the 'Data' pane on the left, click the small dropdown arrow at the top and select "Create Calculated Field." We’ll create three core calculations.

1. Invoice Status

First, we need to categorize each invoice as "Paid," "Overdue," or "Current." This simple IF statement looks at the due date and payment status to do the job.

IF NOT ISNULL([Payment Date]) THEN 'Paid'
ELSEIF [Due Date] < TODAY() THEN 'Overdue'
ELSE 'Current'
END

Name this field 'Invoice Status' and click OK. Now you can easily filter your entire dataset to see only overdue invoices.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

2. Days Overdue

Next, let's calculate exactly how late the overdue invoices are. This helps with prioritization.

IF [Invoice Status] = 'Overdue' THEN DATEDIFF('day', [Due Date], TODAY())
ELSE 0
END

Name this field 'Days Overdue' and click OK. The DATEDIFF function calculates the difference in days between the invoice's due date and today's date, but only for invoices we've already marked as "Overdue."

3. AR Aging Buckets

This is the classic AR aging report chart. Here, we'll group the overdue invoices into time-based buckets. This quickly shows you where your collection risk is concentrated.

IF [Invoice Status] = 'Overdue' THEN
    IF [Days Overdue] > 0 AND [Days Overdue] <= 30 THEN '1-30 Days'
    ELSEIF [Days Overdue] > 30 AND [Days Overdue] <= 60 THEN '31-60 Days'
    ELSEIF [Days Overdue] > 60 AND [Days Overdue] <= 90 THEN '61-90 Days'
    ELSE '90+ Days'
END

Name this field 'AR Aging Bucket'. Now you have a powerful dimension to slice and dice your overdue receivables.

Step 4: Visualize Your Data in Tableau Sheets

With our calculated fields ready, we can start building the individual charts (which Tableau calls 'Sheets') for our dashboard.

Visualization 1: KPI Cards for At-a-Glance Metrics

Dashboards need high-level summary numbers. Let's create one for 'Total Outstanding AR'.

1. Create a new sheet.
2. Filter out paid invoices: Drag your 'Invoice Status' field to the 'Filters' card and deselect 'Paid'.
3. Drag the 'Invoice Amount' field to the 'Text' mark on the 'Marks' card.
4. Click on the 'Text' mark, then the '...' button to edit the label. Make the font larger, center it, and add a title like "Total Outstanding AR."

Repeat this process in new sheets for "Total Overdue Amount" (by adding another filter for Invoice Status = 'Overdue') and "Average Days Overdue" (by dragging 'Days Overdue' to text and changing its aggregation measure from 'Sum' to 'Average').

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Visualization 2: AR Aging Bar Chart

This chart is the heart of the dashboard. It instantly shows you how much money is sitting in each overdue bucket.

1. Create a new sheet.
2. Drag 'AR Aging Bucket' to the 'Columns' shelf.
3. Drag 'Invoice Amount' to the 'Rows' shelf. This will automatically create a bar chart.
4. To add more detail, drag 'Invoice Amount' again, this time to the 'Label' mark on the 'Marks' card. Now you can see the exact total for each bar.
5. Drag 'AR Aging Bucket' to the 'Color' mark to give each bar a distinct color for better readability.

Visualization 3: Top Delinquent Customers Table

Knowing who owes you money is just as important as knowing how much.

1. Create a new sheet.
2. Drag 'Invoice Status' to the 'Filters' card and select only 'Overdue'.
3. Drag 'Customer Name' to the 'Rows' shelf.
4. Drag 'Invoice Amount' to the 'Text' mark.
5. To sort this list, right-click on the 'Customer Name' pill in the 'Rows' shelf and choose 'Sort'. Sort descending by the 'Invoice Amount' field.
6. To limit this to just the top offenders, drag 'Customer Name' again to the 'Filters' card, go to the 'Top' tab, and configure it to show the 'Top 10 by Invoice Amount, Sum'.

Step 5: Assemble and Polish Your Dashboard

Now, let's combine these separate visuals into a single, cohesive dashboard.

1. Click the 'New Dashboard' icon at the bottom of the screen (it looks like a grid).
2. From the 'Sheets' list on the left, drag and drop each of your chart sheets onto the canvas. Arrange them logically - KPI cards at the top, the aging chart prominently in the center.
3. Add a dashboard title by dragging a 'Text' object to the top.
4. Use filters to make the dashboard interactive. Click on one of your charts (like the AR Aging chart), click the small dropdown arrow on its border, and select 'Use as Filter'. Now, clicking on the '90+ Days' bar will dynamically filter the rest of the dashboard to show you only the data related to that segment. How cool is that?

Refine your formatting with clean fonts, consistent colors, and clear labels until your dashboard is easy to understand in under 30 seconds.

Final Thoughts

Building an Accounts Receivable dashboard in Tableau transforms your invoicing data from a static list of numbers into a dynamic tool for managing your business's financial health. You now have a framework for tracking outstanding payments, identifying collection priorities, and making better decisions about your cash flow.

While Tableau is an incredibly powerful tool, you've probably noticed it involves a lot of steps and a substantial learning curve to get right. We experienced this friction and it's why we built Graphed. We wanted to make data accessible to everyone, not just those with hours to spend learning technical software. You can connect sources like QuickBooks or Stripe, and simply ask in plain English, "create a dashboard showing my AR aging buckets by customer," and get an interactive, real-time dashboard built in seconds - not hours.