Skip to content
GraviPointThe Centre of Productivity
  • AI AgentNew
  • Pricing
  • Community
Log inGet started free
TemplatesFinanceCash Flow ManagementWorking Capital and Cash Conversion Cycle

SpreadsheetCash Flow ManagementFree

Working Capital and Cash Conversion Cycle

Track DSO, DIO, DPO and the cash conversion cycle each month, and see how much cash each improvement would release.

Shown with sample data

Colour

Working Capital and Cash Conversion Cycle

Track DSO, DIO, DPO and the cash conversion cycle each month, and see how much cash each improvement would release.

Cash conversion cycle (latest)
66.2
Days
DSO (latest)
43.6
DIO (latest)
61.8
DPO (latest)
39.2
CCC change since first period
-17.2
Negative is better
Trade working capital (latest)
$1,819,000
Cash from the three tests
$510,601
Cash from hitting every target
$159,347
Cash conversion cycle by period
Jun 2026Nov 2026

Latest: 66.2

Cash released by lever
  • Collect from customers faster (cut DSO)$154,167
  • Hold less inventory (cut DIO)$209,667
  • Agree longer supplier terms (raise DPO)$146,767
  • Bring DIO to target$37,740
  • Bring DPO to target$121,607

How to use it

  1. 1On Settings, type the number of days in each period (30 for months, 91 for quarters) and your targets.
  2. 2Each period, enter revenue and cost of sales for the period and the closing receivables, inventory and payables balances.
  3. 3Read DSO, DIO, DPO and CCC for each period; Status compares CCC with your target.
  4. 4Use Cash levers to see how much cash a few days’ improvement releases, and the prize for hitting every target.
  5. 5Discuss the biggest lever with the owner of that process: credit control, purchasing or procurement.

In this workbook

  • About
  • What’s included
  • How to use
  • Questions
  • Related resources

About this template

Growing companies often run out of cash while profitable because money is tied up in receivables and stock. Enter revenue, cost of sales and month-end receivables, inventory and payables; the sheet calculates days sales outstanding, days inventory outstanding, days payables outstanding and the cash conversion cycle for each period, compares them with targets, and puts a dollar value on collecting faster, holding less stock or paying suppliers on longer terms.

Who it’s for

  • Monthly working capital reviews
  • Building a case for collections or inventory projects
  • Preparing for lender or investor questions on cash

What’s included

  • Periods sheet: Working capital days and the cash conversion cycle by period.
  • Cash levers sheet: Cash released by improving each part of the cycle, using the latest period.
  • Settings sheet: Period length and targets.

How to use it

  1. 1On Settings, type the number of days in each period (30 for months, 91 for quarters) and your targets.
  2. 2Each period, enter revenue and cost of sales for the period and the closing receivables, inventory and payables balances.
  3. 3Read DSO, DIO, DPO and CCC for each period; Status compares CCC with your target.
  4. 4Use Cash levers to see how much cash a few days’ improvement releases, and the prize for hitting every target.
  5. 5Discuss the biggest lever with the owner of that process: credit control, purchasing or procurement.

Tips

  • Use the same basis every period (period-end balances and period revenue) so the trend is meaningful.
  • Stretching suppliers too far damages relationships and can cost early-payment discounts; balance DPO against supplier health.
  • A falling CCC while revenue grows is one of the strongest signs of improving financial health.

Questions

What is the cash conversion cycle?

CCC = DSO + DIO − DPO. It is the number of days between paying suppliers and collecting cash from customers. Lower is better; some retailers run a negative CCC.

How do you calculate DSO, DIO and DPO?

DSO = receivables ÷ revenue × days. DIO = inventory ÷ cost of sales × days. DPO = payables ÷ cost of sales × days. The days are the days in the period you used for revenue and cost of sales.

What is a good DSO?

Compare it with your payment terms: with 30-day terms, a DSO of 35–40 is healthy. A DSO far above your terms means customers are paying late.

Related searchescash conversion cycle calculatorworking capital templatedso dio dpodays sales outstandingworking capital managementnet working capital

Details

Format
Spreadsheet
Category
Cash Flow Management
Sheets
3
Setup
10 min
Level
Intermediate
Price
Free

Download a copy

Downloads need a free account.

SpreadsheetCash Flow ManagementFree

Working Capital and Cash Conversion Cycle

Track DSO, DIO, DPO and the cash conversion cycle each month, and see how much cash each improvement would release.

A free account keeps your copy safe so you can come back to it. Have one? Log in

Download a copy

Downloads need a free account.

Details

Format
Spreadsheet
Category
Cash Flow Management
Sheets
3
Setup
10 min
Level
Intermediate
Price
Free

Your copy is private to you.

More cash flow management templates

View all
13-Week Cash Flow Forecast2 sheets

Cash today

$48,000

Cash in 13 weeks

$16,750

Lowest balance

$16,750

Net cash flow by week
$6,800
$5,900
$5,000
$3,700
$3,300
W12W10W6W8W2
SpreadsheetCash Flow Management

13-Week Cash Flow Forecast

Week-by-week cash in and out for the next quarter, with your lowest point, shortfalls and runway.

10 min setupPreview
12-Month Cash Flow Forecast2 sheets

Closing cash, December

$112,700

Lowest cash balance

$28,800

Months below minimum

0

Net cash flow by month
$11k
$12k
-$900
$9,900
$16k
JanFebMarAprMay
SpreadsheetCash Flow Management

12-Month Cash Flow Forecast

Monthly receipts and payments with opening and closing cash, the lowest point and how many months it covers.

10 min setupPreview
Daily Cash Position Report2 sheets

Total cash

$178,550

Available to spend

$168,450

Net movement today

-$45,090

Projected close by type
$120k
$53k
$32k
$9,050
-$35k
SavingsOperatingTax reserveMerchant / PayPalPayroll
SpreadsheetCash Flow & Treasury

Daily Cash Position Report

Balances across every account with today’s expected receipts and payments and the projected close.

10 min setupPreview

Practical guides and new resources, monthly.

One short email with new templates, calculators and how-tos. Unsubscribe any time.

GraviPointThe Centre of Productivity

Find the right resource. Make it work for you. Get things done with spreadsheets, documents, forms and calculators you can use right in your browser.

support@gravipoint.com
  • @gravipoint
  • @GraviPoint
  • GraviPoint
  • 𝕏@gravipoint

Templates

  • All templates
  • Budgets & expenses
  • Invoices & billing
  • Project management
  • HR & people
  • Inventory & stock
  • Sales & CRM
  • Financial calculators

Popular

  • Monthly budget
  • Invoice
  • Employee shift schedule
  • Weekly timesheet
  • Project plan & Gantt chart
  • Inventory tracker
  • Expense report
  • Mortgage calculator

Solutions

  • Individuals & households
  • Freelancers & consultants
  • Founders & startups
  • Small business owners
  • Teams & operations
  • Students & educators

Company

  • About
  • Features
  • Pricing
  • Community
  • Journal
  • Contact
© 2026 GraviPoint. All rights reserved.
  • Privacy
  • Terms
  • Help centre
  • FAQ