How to Create an AR Aging Report in Tableau

Tracking your outstanding invoices is essential for keeping your business’s cash flow healthy. An Accounts Receivable (AR) Aging Report is the perfect tool for this, giving you a clear snapshot of who owes you money and how long their payments are overdue. This article will walk you through, step by step, how to build your own dynamic and interactive AR Aging Report right inside Tableau.

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 an AR Aging Report?

An Accounts Receivable (AR) Aging Report is a critical financial document that categorizes unpaid customer invoices by how long they have been outstanding. It typically segments AR into 'buckets' such as:

• Current: Invoices that are not yet due.
• 1-30 Days Past Due: Invoices 1 to 30 days overdue.
• 31-60 Days Past Due: Invoices 31 to 60 days overdue.
• 61-90 Days Past Due: Invoices 61 to 90 days overdue.
• 90+ Days Past Due: Invoices more than 90 days overdue.

Why is this report so important? It helps you quickly identify late-paying customers, assess the effectiveness of your collections process, and forecast cash flow with greater accuracy. A well-maintained AR report is less of a report and more of a guide for your financial strategy, helping you see potential credit health risks.

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

Before You Begin: Preparing Your Data

Tableau is powerful, but it’s only as good as the data you give it. Before building your AR Aging Report, start by preparing a clean and structured dataset. Investing time upfront in preparing your data pays off by making the experience smoother going forward.

For your data source, each row should represent a single invoice and include the following information in separate columns:

• Customer Name or ID: To identify who owes the money.
• Invoice Number: A unique identifier for each invoice.
• Invoice Date: The date the invoice was issued.
• Invoice Amount: The total amount of the invoice.
• Outstanding Balance: The remaining amount due on the invoice.

You can organize this information in a simple Excel or Google Sheets file, or more advanced users may extract this data directly from a company database. For the purposes of this tutorial, a simple spreadsheet will work just fine.

Building Your AR Aging Report in Tableau: A Detailed Walkthrough

Once your data is prepared, it’s time to move into Tableau. We’ll build out the report step by step without becoming overwhelmed.

Step 1: Connect to Your Data Source

First, open Tableau and connect to your data. Find your spreadsheet or database under "Connect" on the left side of the start page. Select the appropriate connection option, locate the file you just created, and connect. Tableau will display your data source on the "Data Source" tab, and you are ready to go.

Step 2: Create a 'Report Date' Parameter

To make the report flexible, we'll create a date parameter. A parameter allows you to view the report for any selected day, such as last month or today, and all the relevant calculations will adjust automatically.

1. In the worksheet view, go to the Data pane (top left).
2. Click the small dropdown arrow next to the search bar and select "Create Parameter..."
3. Name your new parameter Report Date.
4. Set the Data type to Date.
5. For Allowable values, you can select "All" or specify a range. Hit "OK".

The 'Report Date' parameter will appear on the bottom pane. Show the parameter in the view by right-clicking on it and selecting "Show Parameter". Now you can change the date in the view for flexible reporting.

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 3: Calculate the 'Days Overdue'

Next, we need to calculate the days between the invoice date and the 'Report Date'. This will determine our aging buckets.

1. Go to the Data pane again and select "Create Calculated Field...".
2. Name the field Days Overdue.
3. In the formula box, enter the following:

DATEDIFF('day', [Invoice Date], [Report Date])

Explanation of the formula: The DATEDIFF function calculates the difference between two dates. Here, it calculates the number of days between Invoice Date and the Report Date.

Step 4: Create Your Aging Buckets

This is where the aging categories come into play. We'll use this calculated field to categorize invoices based on how many days past due since they were issued.

1. Right-click on any space in your data pane, and select "Create Calculated Field...".
2. Name the field Aging Buckets.
3. Use the following formula in the calculation box:

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

This formula categorizes your overdue accounts into these specific buckets, which are essential for effective reporting.

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 5: Visualizing the Data

Now that you have your aging buckets, we can start building the visual report. Start with a basic visualization and then refine it with additional details.

1. From the Data pane, drag the Aging Buckets dimension onto the Rows shelf.
2. From your measures, drag the Sum of Outstanding Balance onto Columns. This creates the basic view.

A bar chart will immediately generate, and you can use it to display outstanding balances in each aging bucket. This forms the foundation of your report visual.

Step 6: Add Grand Totals

To complete your report, adding grand totals and subtotals is a quick way to showcase the cumulative amounts in each aging bucket.

• Navigate to the Analytics pane, a menu on the top right corner.
• Select "Totals" and choose "Show Row Grand Totals" and "Show Column Grand Totals".

Tableau will automatically add these, resulting in a more comprehensive outstanding balance report.

Enhance Your AR Aging Report

As a final step, let's enhance your AR Aging Report with visual aids such as:

• Use Color: Changing the colors of categories like 90+ days buckets in shades like red helps to easily highlight the more critical amounts.
• Sorting or Filtering: Adjust the report to view specific customers or invoice dates that need more attention.
• Summary Information: Build a summary for your report that includes key metrics like total outstanding balances, % of balances overdue over 90 days, or Days Sales Outstanding (DSO). These metrics give valuable insights into your organization's receivables.
• Visualization Transformation: Instead of text, convert your report into bar charts or treemaps for a more comprehensive view of the outstanding buckets and key insights.

Final Thoughts

Building an AR Aging Report in Tableau transforms a standardized report into a dynamic and visually comprehensible tool. This enhances your ability to manage your receivables more effectively. While building reports like this may seem time-consuming, especially with multiple data sources, integrating, categorizing, and visualizing your data effectively is key to gaining insights and improving cash flow management.

If you're interested in streamlining tasks like data aggregation in the future, consider using tools like Graphed for consistent and organized reporting, making the process easier and more efficient.