Graphed LogoGraphed
Graphed LogoGraphed
How It WorksAgentsIntegrationsPricing

How to Create an AR Aging Report in Tableau with AI

Cody Schneider••8 min read

Building an Accounts Receivable (AR) aging report is a financial staple for a reason - it shows you who owes you money and how overdue they are, which is critical for managing cash flow. Traditionally, this means pulling data into a spreadsheet and manually sorting it, but a tool like Tableau can create a dynamic, visual report. This guide will walk you through building an AR aging report in Tableau step-by-step and show you how AI is making this entire process even simpler.

GraphedGraphed

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.

Watch Graphed demo video

What is an AR Aging Report Anyway?

An Accounts Receivable aging report, sometimes called an AR aging summary, is a simple but powerful table that categorizes all outstanding customer invoices based on how long they’ve been overdue. It groups them into time buckets, giving you a clear snapshot of your receivables' health. Standard buckets usually include:

  • Current: Invoices that aren’t due yet.
  • 1 - 30 Days Past Due: Invoices overdue by one to thirty days.
  • 31 - 60 Days Past Due: Invoices overdue by one to two months.
  • 61 - 90 Days Past Due: Invoices overdue by two to three months.
  • 91+ Days Past Due: Invoices significantly overdue.

This report is more than just a list of late payers. It’s a strategic tool. Regular analysis helps you pinpoint cash flow bottlenecks, identify customers who consistently pay late, and decide when it's time to adjust credit terms or send an account to collections. For service businesses, it helps forecast cash flow more accurately, and for e-commerce stores, it’s critical for managing wholesale or B2B accounts.

Before You Begin: Prepping Your Data

Like any report, the quality of your AR aging report depends on the quality of your data. Before you even open Tableau, you need to gather the right information. Your report will be built from a list of all unpaid invoices, which you can typically export from your accounting software (like QuickBooks, Xero, or FreshBooks) or your company’s ERP system.

Make sure your data export contains these essential columns:

  • Customer Name: To know who owes you.
  • Invoice ID/Number: A unique identifier for each invoice.
  • Invoice Date: The day the invoice was issued.
  • Due Date: The day payment was expected.
  • Invoice Total Amount: The total value of the invoice.
  • Amount Paid: How much, if any, of the invoice has been paid.
  • Outstanding Balance: The remaining amount due. This will be the main value we work with.

Export this data as a CSV or Excel file, or prepare to connect Tableau directly to the database where this information lives.

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.

How to Build Your AR Aging Report in Tableau: A Step-by-Step Guide

Once your data is ready, you can start building in Tableau. The magic happens with a calculated field that determines the age of each invoice and assigns it to the correct bucket.

Step 1: Connect to Your Data Source

Open Tableau, and in the "Connect" pane on the left, choose the appropriate connector. If you have a spreadsheet, select Microsoft Excel or Text File (for CSVs). Navigate to your file and open it. Tableau will display a preview of your data source. Verify that all the columns look correct.

Step 2: Create a Calculated Field for Invoice Age

The core logic of this report relies on calculating the difference between today’s date and the invoice's due date. We’ll do this using a calculated field.

  1. Go to the top menu and select Analysis > Create Calculated Field.
  2. Name your new field something clear, like "Days Overdue."
  3. In the formula box, you'll use the DATEDIFF function. This function calculates the difference between two dates. We’ll compare the 'Due Date' field to today's date, which Tableau can get using the TODAY() function.

Enter the following formula:

DATEDIFF('day', [Due Date], TODAY())

This formula tells Tableau: "Show me the difference in 'days' between the 'Due Date' column and whatever 'TODAY's' date is." Click OK. You’ll now see "Days Overdue" in your list of measures.

Step 3: Create the Aging Buckets with Another Calculated Field

Now that you have the number of days each invoice is overdue, you need to group them into the aging buckets (0-30 days, 31-60 days, etc.). We'll use another calculated field for this with an IF/THEN statement.

  1. Go to Analysis > Create Calculated Field again.
  2. Name this field "Aging Bucket."
  3. Enter the following formula, which uses your newly created "Days Overdue" field:
IF [Days Overdue] <= 0 THEN "Current"
ELSEIF [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 "91+ Days"
END

This tells Tableau to check the "Days Overdue" for each invoice and assign it the correct text label based on its value. Click OK.

Pro Tip: To make sure your buckets appear in the correct order in your final table (Current, 1-30, 31-60…), right-click on your new "Aging Bucket" dimension, go to Default Properties > Sort, choose Manual sort, and arrange the buckets as you want them to appear.

GraphedGraphed

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.

Watch Graphed demo video

Step 4: Build the Report View

Now for the fun part: creating the actual report table.

  1. Drag your new Aging Bucket dimension from the "Data" pane to the Columns shelf.
  2. Drag Customer Name and then Invoice ID to the Rows shelf. This creates a nested list of all invoices grouped by customer.
  3. Drag your Outstanding Balance measure to the Text box on the Marks card.

You should now see a table emerge, with your aging buckets as columns, your customers and their invoices as rows, and the outstanding balance for each invoice filling in the cells.

Step 5: Add Totals and Polish the View

An AR aging report isn’t complete without totals. Tableau makes this easy.

  • Go to the Analysis menu at the top.
  • Select Totals.
  • Check both Show Row Grand Totals and Show Column Grand Totals.

You can also use color to quickly spot problem areas. Drag another copy of your Outstanding Balance measure to the Color box on the Marks card. By default, Tableau might use a gradient. To highlight risk, click on the Color box, edit the color scheme and choose a diverging palette like Red-Green, so that higher balances in the older buckets appear bright red.

And that’s it! You have a dynamic AR aging report that will update automatically every time you refresh your data source.

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.

Where AI Streamlines Financial Reporting

Building that report in Tableau isn't too complicated if you know how DATEDIFF and IF/THEN statements work. But what if you don't? What if you're a busy founder or finance manager who doesn't have time to spend half a day looking up formulas and troubleshooting Tableau joins? This is where the process gets stuck. Many teams default back to the "download a CSV on Monday, wrestle with it in Excel, finally present it on Tuesday, then answer follow-up questions on Wednesday" cycle. By the time you get an insight, half the week is gone.

AI-powered analytics tools are eliminating these hurdles. Instead of manually performing step-by-step actions, you can use natural language to tell an AI what you need.

Imagine simply typing a prompt like this:

“Show me an AR aging report of all outstanding invoices from QuickBooks, grouped by customer. Bucket them by 0-30, 31-60, 61-90, and 91+ days overdue.”

The AI handles the rest. It understands what an "AR aging report" is, connects to the data source, performs the date difference calculations, creates the buckets, and builds the final visualization for you in seconds. You don't need to learn any specific BI software or master complex syntax. If you can ask a question, you can get an answer.

This approach gives three huge advantages:

  • Speed: What takes a trained analyst 30 minutes in Tableau (and a non-technical person hours of searching YouTube tutorials) can be done in under a minute with AI.
  • Accessibility: It democratizes data. Your bookkeeping contractor, your finance manager, or your CEO can all get the same report without needing a data analyst to act as a go-between. This removes bottlenecks and lets people get answers in real time during a meeting, not two days later.
  • Exploration: The best part is asking follow-up questions. Once the report is built, you can't just stop. You can naturally drill down further: "Which of those customers are also our top 5 revenue generators?" or "Filter this report to only show invoices over $10,000" or "Turn this into a bar chart showing the total overdue amount in each bucket." Each question leads to a deeper insight without requiring you to rebuild anything manually.

Final Thoughts

Knowing how to build an Accounts Receivable aging report in a tool like Tableau is an incredibly valuable skill for anyone managing business finances. It shifts AR management from a reactive, spreadsheet-driven task to a proactive, visual one, letting you see cash flow problems before they escalate.

Here at Graphed, we’re focused on making these essential insights instantly accessible without the steep learning curve. We built our platform so you could skip the manual steps of DATEDIFF formulas and drag-and-drop interfaces entirely. By connecting your data sources like QuickBooks or Shopify, you use plain English to ask for the reports you need, getting live, interactive dashboards tailored to your exact questions in seconds. It allows you and your team to focus on what the data means, not on the drudgery of building the report.

Related Articles