Template · Aging · Opening soon

AP aging report template

See what you owe each supplier and how overdue it is, from your unpaid bills. Plan payment runs with the oldest bills first, refreshed with your data.

Book a demo

You bring

Unpaid bills45 rows

BillSupplierAmount dueDue date

Mammoth does the work

You get

One table10 rows

What you owe each supplier, split by how overdue it is.

SupplierNot due yet1-30 days31-60 days61-90 daysOver 90 daysTotalOpen billsOldest (days)

Not a spreadsheet to fill inIt is a ready-made workflow in Mammoth. You bring the files, and it does the work.
Your files, as they areUpload a file or connect a source. Your column names do not have to match.
Runs again by itselfWhen new data arrives, every step runs again and the result updates.

What you get back

The real result of this template, run on sample data.

AP aging: the resultSample data10 rows

112,005 in total12,314 over 90 days

Supplier	Not due yet	1-30 days	31-60 days	61-90 days	Over 90 days	Total	Open bills	Oldest (days)
Clean Team	4,730.68	10,279.09	0	1,217.41	2,441.83	18,669.01	7	95
AWS	9,482.52	5,115.26	3,489.65	0	0	18,087.43	4	33
British Gas	7,813.97	0	0	0	4,478.89	12,292.86	3	95
Staples	7,598.96	0	355.57	4,063.41	0	12,017.94	4	66
Brightline Telecom	3,145.37	1,335.86	5,140.81	323.88	308.03	10,253.95	5	95
PrintWorks	2,507.63	3,242.15	0	985.63	3,148.55	9,883.96	5	95
Office Space Co	3,292.37	1,698.54	3,764.79	0	1,083.82	9,839.52	4	95
Metro Water	0	866.19	3,961.74	4,565.80	0	9,393.73	3	66

10 rows in the result · made from 45 input rows · first 8 shown. Sample data: illustrative figures, not business results.

What is an AP aging report?

An accounts payable aging report groups unpaid supplier bills by how long they have been due, so you can plan cash and avoid late fees.

How it works

How to use the AP aging template

1Bring your dataConnect a source, or upload a file.
2Check the columnsMammoth matches each column the template needs and asks only when it is unsure.
3Choose where it goesA table, a sheet, or a dashboard. It rebuilds on every refresh.

See the exact columns and steps ›

What it needs

Unpaid bills: supplier, amount due, due date

Unpaid bills

Bill
Supplier
Amount dueWhat is still owed, not the original total.
Due date
Currency(optional)

The steps it runs

1Match columns
2Keep bills still owed
3Days overdue
4Total by supplier and age

Every step is an ordinary Mammoth step you can open and change.

AP aging: questions

Does it update by itself?

Yes. The template becomes an ordinary workflow in Mammoth. When your data refreshes, from a connector, a scheduled pull or a new file, every step runs again and the result table updates.

Can I change the steps?

Every step is an ordinary Mammoth step you can open and edit. Mammoth remembers which steps came from the template, so an update never overwrites your changes.

Do my column names have to match?

No. You point the template at your columns once. Mammoth suggests a match for each one and asks only when it is unsure.