Template · Aging · Opening soon

DSO calculation template, month by month

Days sales outstanding for every month from your invoice list: credit sales, what was still owed at month end, and how many days of sales that is.

Book a demo

You bring

Invoices220 rows

Invoice dateAmountPaid date

Mammoth does the work

You get

One table7 rows

Days sales outstanding for every month, with credit sales and what was owed at month end.

MonthCredit salesOwed at month endDSO (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.

DSO by month: the resultSample data7 rows

Month	Credit sales	Owed at month end	DSO (days)
2026-04-01	87,497.60	78,091.78	26.8
2026-05-01	124,406.66	146,670.35	36.5
2026-06-01	138,867.37	174,193.21	37.6
2026-07-01	135,068.48	185,230.21	42.5
2026-08-01	129,797.84	176,540.12	42.2
2026-09-01	119,730.20	189,783.47	47.6
2026-10-01	95,269.76	152,911.65	49.8

7 rows in the result · made from 220 input rows. Sample data: illustrative figures, not business results.

How is DSO calculated?

DSO is receivables at the end of a period divided by credit sales in that period, times the days in the period. A rising DSO means customers are paying slower.

How it works

How to use the DSO 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

Invoices: invoice date, amount and the date each was paid

Invoices

Invoice date
Amount
Paid dateEmpty on unpaid invoices.

The steps it runs

1Match columns
2DSO by month

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

DSO by month: 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.