Cash flow dashboards

Cash flow dashboard and accounts receivable examples

Five dashboards on cash: what will come in over the next few weeks, who owes money and how overdue it is, profit beside cash, spending against budget, and where the money goes out. Open any of them to see it in full, then use it as a template for your own data.

Collections & AR Aging dashboard: Open Balance, Days Overdue, Invoice Amount and Days To Pay tiles.

Financial Performance dashboard: Revenue, Gross Profit, Operating Income and Gross margin tiles, above Revenue over time.

Cash Collection Forecast dashboard: Open Balance, Invoice Amount, Paid Amount and Days To Pay tiles.

Three of the five examples. All figures are sample data.

Browse the examples Try free

The examples

Five cash flow dashboard examples and templates

Click a board to see all of it. Click Use template to start your own copy in Mammoth. All figures are sample data.

Sample data
Cash flow forecast dashboard
How much cash will come in over the next few weeks?
- KPIOpen balance
- KPIInvoice amount
- KPIPaid amount
- KPIDays to pay
- Open balance
- Invoice amount
- Paid amount
- Days to pay
Use template
Sample data
Accounts receivable dashboard
Who owes us money, and how overdue is it?
- Open balance
- Days overdue
- Invoice amount
- Days to pay
Use template
Sample data
Profit and cash dashboard
Is the business making money, and where is margin coming from?
- Revenue
- Gross profit
- Operating income
- Gross margin
Use template
Sample data
Budget and cash dashboard
Where is spending running ahead of plan?
- Revenue
- Budget revenue
- Variance to plan
Use template
Sample data
Cash outflow and spend dashboard
Where is the cash going out, and to whom?
- Invoice amount
- Budgeted spend
- Variance to budget
- Days to pay
Use template

Definition

What a cash flow dashboard is

A cash flow dashboard is one screen that shows money coming into and going out of a business: what customers owe and when they are likely to pay, what is being spent and with whom, and how both compare with plan. An accounts receivable dashboard is the incoming half of it: open balance by age, days overdue and the customers carrying the most.

Cash in and out
Collections on one side, spend on the other.
Forecast from habits
When customers really pay, not the due date.
Oldest debt first
Aging buckets lead, so the call list writes itself.

The metrics

The metrics a cash flow dashboard is built from

Eight numbers. Most depend on which date you count from, so agree that before the chart.

Cash expected in
How much will customers pay over the next few weeks?
What the data needs
Open invoices with due dates, adjusted by how late each customer or segment usually pays. Due dates alone overstate the next few weeks.
Days sales outstanding
How long does it take to turn a sale into cash?
What the data needs
Receivables and revenue for the same period. Compare like with like, because a month with a large invoice on its last day reads high.
Overdue balance
How much is past its due date?
What the data needs
Open balance by aging bucket. Read the oldest buckets first, because they are the least likely to be paid.
Collection rate
What share of what we billed have we collected?
What the data needs
Billed and collected amounts for the same invoices. Matching payments to invoices matters: a payment on account is not a paid invoice.
Days to pay
How long does each customer or segment take?
What the data needs
Invoice date and paid date per invoice. Show the spread, because one slow customer can hide in a good average.
Spend against budget
Is cash going out faster than planned?
What the data needs
Actual spend and budget by month and category. Timing differences look like overspend, so read it over a quarter as well as a month.
Variance to plan
How far off the plan are we, and where?
What the data needs
Budget and actual at the same level of detail. A budget set by quarter cannot be compared with actuals by month without splitting it first.
Supplier concentration
How much spend goes to a few suppliers?
What the data needs
Spend per supplier over twelve months, with suppliers de-duplicated. The same supplier under three names hides how dependent you are.

How to build one

How to build your own cash flow dashboard

From one of the examples above to a live dashboard on your own data.

1
Pick a template
Start from any of the five boards above.
2
Add your data
Upload a spreadsheet, or connect one of 100+ tested connectors.
3
Clean it once
Fix and combine your data once. Mammoth repeats those steps for you.
4
Set it to refresh
The dashboard updates on a schedule and flags data that fails a check.
5
Share the link
Public, password-protected or sign-in only, on every plan.

Start with a template

14-day Pro trial · No credit card

FAQ

Cash flow dashboard questions

Last reviewed 14 November 2026 against the template catalogue.

What should a cash flow dashboard include?

Cash expected in by week, open receivables by age, spend by month against budget, and the largest suppliers. The five above cover one side each, so start with the one your next cash meeting is about.

What should an accounts receivable dashboard include?

Open balance by aging bucket, days sales outstanding, days overdue by customer, the largest balances, and disputed or part-paid invoices. The Collections & AR Aging board above shows those, with the collector against each age band.

What KPIs should a cash flow dashboard track?

Cash expected in, days sales outstanding, overdue balance, collection rate, days to pay, spend against budget, variance to plan and supplier concentration. The list below shows each one with the data it needs.

How do I build a cash flow dashboard?

Start with the question the finance lead asks every week. Then follow five steps.

Export open invoices and payments from the accounting system, with invoice date, due date and paid date.
Work out how many days each customer or segment usually takes past the due date.
Add spend by supplier and the budget for the same months.
Check the open balance against the ledger before anyone relies on the board.
Refresh weekly, and share the link with whoever chases payments.

What is the difference between cash flow and profit?

Timing. Profit counts revenue when it is earned and costs when they are incurred. Cash counts money when it moves. A profitable month can still drain cash if customers pay late or spending comes early, which is why the profit board sits beside the collection ones here. Financial dashboard examples

Can the whole finance team and the CEO see it?

Yes. Dashboard viewers are unlimited and free on every Mammoth plan, including the free one, so collectors, the controller and the leadership team can all open it. Only the people building the dashboards count as platform users.