Workflow · Finance close · Opening soon
Cash conversion cycle by month
Work out your cash conversion cycle each month from QuickBooks exports. Use month-end balances and monthly sales to calculate DSO, DIO, and DPO.
Someone typed
“work out our cash conversion cycle each month: DSO plus DIO minus DPO from the monthly balances and sales”
The agent read it as
Work out our cash conversion cycle each month: DSO plus DIO minus DPO from the monthly QuickBooks Balance Sheet by Month and QuickBooks Profit and Loss by Month, using month-end balances.
What the agent built
4 steps, each one an ordinary Mammoth step you can open and change.
File
QuickBooks Balance Sheet by Month
CSV export · 36 rows
File
QuickBooks Profit and Loss by Month
CSV export · 24 rows
Step
Total monthly sales and costs
Step 1
Step
Total month-end balances
Step 2
Join
Bring in monthly sales and costs
12 of 12 paired
Step
Calculate cash conversion cycle
Step 4
Result
Monthly Cash Cycle
12 rows
Schedule
Runs when you say
Proposed
- FileQuickBooks Balance Sheet by MonthCSV export · 36 rows
- FileQuickBooks Profit and Loss by MonthCSV export · 24 rows
- StepTotal month-end balancesStep 2
- StepTotal monthly sales and costsStep 1
- JoinBring in monthly sales and costs12 of 12 paired
- StepCalculate cash conversion cycleStep 4
- ResultMonthly Cash Cycle12 rows
- ScheduleRuns when you sayProposed
Checked on the sample files: every step ran, 12 rows came out, and the join paired 12 of 12 rows.
- Download QuickBooks Balance Sheet by Month sample (36 rows)QuickBooks: Reports > Balance Sheet > customize date range to monthly > Export to CSV
- Download QuickBooks Profit and Loss by Month sample (24 rows)QuickBooks: Reports > Profit and Loss > customize date range to monthly > Export to CSV
What you get back
The result of that run, the rows to look at first.
Monthly Cash CycleSample data12 rows
| Month | Cash conversion cycle (days) | DSO (days) | DIO (days) | DPO (days) | Days in month | Accounts receivable | Inventory | Accounts payable | Net sales | Cost of goods sold |
|---|---|---|---|---|---|---|---|---|---|---|
| 2025-12-31 | 18.7 | 14.7 | 15.8 | 11.8 | 31 | 625,000 | 430,000 | 322,000 | 1,315,000 | 845,000 |
| 2026-04-30 | 8.8 | 14.5 | 5.9 | 11.6 | 30 | 682,000 | 180,000 | 352,000 | 1,415,000 | 910,000 |
| 2026-07-31 | 18.4 | 15.1 | 15.3 | 12 | 31 | 730,000 | 475,000 | 372,000 | 1,500,000 | 965,000 |
| 2026-09-30 | 26.8 | 23.4 | 15.3 | 11.9 | 30 | 920,000 | 490,000 | 380,000 | 1,180,000 | 960,000 |
| 2026-10-31 | 18.6 | 15.2 | 15.5 | 12.1 | 31 | 760,000 | 498,000 | 388,000 | 1,550,000 | 995,000 |
| 2025-11-30 | 18.1 | 14.3 | 15.4 | 11.5 | 30 | 610,000 | 420,000 | 315,000 | 1,280,000 | 820,000 |
| 2026-01-31 | 18.7 | 14.8 | 15.8 | 11.9 | 31 | 640,000 | 438,000 | 330,000 | 1,340,000 | 860,000 |
| 2026-02-28 | 16.8 | 13.4 | 14.2 | 10.8 | 28 | 655,000 | 445,000 | 338,000 | 1,365,000 | 878,000 |
| 2026-03-31 | 18.7 | 14.9 | 15.7 | 12 | 31 | 670,000 | 452,000 | 345,000 | 1,390,000 | 892,000 |
| 2026-05-31 | 18.5 | 15.2 | 15.4 | 12 | 31 | 705,000 | 460,000 | 360,000 | 1,440,000 | 928,000 |
| 2026-06-30 | 17.8 | 14.6 | 14.8 | 11.6 | 30 | 718,000 | 468,000 | 366,000 | 1,475,000 | 948,000 |
| 2026-08-31 | 25.9 | 15.1 | 15.2 | 4.4 | 31 | 742,000 | 482,000 | 140,000 | 1,525,000 | 980,000 |
How do you work out cash conversion cycle by month?
Export your QuickBooks Balance Sheet by Month and Profit and Loss by Month. The workflow totals monthly sales and costs, pulls in month-end balances, then calculates DSO plus DIO minus DPO for each month.
How it works
How to use the Monthly Cash Cycle workflow
- 1Get early accessWe invite people in small batches, job by job. You'll land on this workflow, already built and checked on the sample files.
- 2Swap in your exportsUpload your own files as they come out of your tools. The agent checks the workflow on your rows.
- 3Change it in words, then turn it onSay what to change and see the new result before anything saves. Then choose when it runs.
Monthly Cash Cycle: questions
What export should you use?
Use the exports that contain the monthly figures you need, usually a balance sheet by month and a profit and loss by month. The workflow reads those files and uses the columns and rows that match your rules.
What happens to rows that do not match?
Rows that do not match the rules are left out of the calculation. You can choose whether unmatched rows are ignored, grouped, or flagged for review, depending on how you set the steps.
How do you change the rules?
You change the rules in words by editing the steps. For example, you can change which accounts to include, how to match month-end balances, or how to calculate DSO, DIO, and DPO.
Get early access to this workflow
It will open already built and checked on the sample files. Swap in your own exports and see your result.
Workflows like this
Consolidate entities, compare budget to actual, build a trial balance, review month-on-month moves and work out commission.
- Profit and loss by monthBuild a monthly profit and loss statement from a QuickBooks general ledger export, with revenue, COGS, gross profit, expenses, and net income.See the workflow Built by the agent
- Real estate commission splitWork out real estate commission on each closed sale and split it between the listing agent, buying agent and brokerage.See the workflow Built by the agent
- Loan amortization from statementsBuild a monthly loan amortization schedule from an Excel export, with interest, principal, and remaining balance for each loan.See the workflow Built by the agent
- Accrued expenses scheduleBuild an accrued expenses schedule from QuickBooks exports. Match purchase orders to vendor bills, calculate unbilled amounts, and flag items that need accrual.See the workflow Built by the agent
- Expense report from card transactionsTurn Amex card exports into an expense report per employee, with category totals and missing receipts flagged.See the workflow Built by the agent
- Vendor spend analysisEach supplier's spend over the last 12 months, its share, and the change on the 12 beforeSee the workflow Template