Template · Aging · Opening soon
Days payable outstanding, worked out every month
Days payable outstanding for every month from your supplier bills: what you were billed, what was still unpaid at month end, and how many days of bills that is.
You bring
Bills180 rows
Bill dateAmountPaid date
Mammoth does the work
You get
One table7 rows
Days payable outstanding for every month, with bills received and what was unpaid at month end.
MonthBills receivedOwed at month endDPO (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.
DPO by month: the resultSample data7 rows
| Month | Bills received | Owed at month end | DPO (days) |
|---|---|---|---|
| 2026-04-01 | 48,700.80 | 48,700.80 | 30 |
| 2026-05-01 | 77,762 | 98,884.62 | 39.4 |
| 2026-06-01 | 53,949.22 | 97,143.71 | 54 |
| 2026-07-01 | 85,175.14 | 109,525.37 | 39.9 |
| 2026-08-01 | 67,900.09 | 89,362.10 | 40.8 |
| 2026-09-01 | 89,719.98 | 118,059.68 | 39.5 |
| 2026-10-01 | 53,547.70 | 115,284.46 | 66.7 |
How is days payable outstanding calculated?
DPO is accounts payable at the end of a period divided by what suppliers billed in that period, times the days in the period. A higher DPO means you hold cash longer before paying; too high and suppliers start to notice.
How it works
How to use the DPO by month 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
Supplier bills: bill date, amount and the date each was paid
Bills
- Bill date
- Amount
- Paid dateEmpty on unpaid bills.
The steps it runs
- 1Match columns
- 2DPO by month
Every step is an ordinary Mammoth step you can open and change.
DPO by month: questions
Many DPO formulas use cost of goods sold. Why bills?
Cost of goods sold leaves out overheads and anything not stock, while your bills are everything suppliers wait to be paid for. Bills are also what your accounting system already lists, paid date included.
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.
Get early access to this template
Bring your data, check the columns, and the result rebuilds on every refresh.
More aging report templates
Split what is owed by how overdue it is, and see how long customers take to pay.