12 Working Capital KPIs, Built Into QuickBooks Online Reporting

DSO, DPO, Cash Conversion Cycle, Inventory Turnover, and eight more — computed live off your synced QuickBooks data, every formula and input number visible, updating the moment you change the period.

Most companies track working capital in a spreadsheet somebody rebuilds every month — pull the AR Aging report, pull the AP Aging report, pull the Balance Sheet, stitch together DSO and DPO by hand, and hope nobody fat-fingers a formula between close and the board deck. It works, until it doesn't: a stale tab, a copy-paste error, a ratio quietly computed off last quarter's balances because nobody remembered to refresh the pull.

We built these ratios directly into DrillFi instead, computed from the same live QuickBooks sync that already powers your Budget vs. Actual reporting — no separate pull, no separate spreadsheet, no separate place for the numbers to drift out of sync with the books.

The 12 metrics, grouped by the question they actually answer

Working capital isn't one number — it's four different questions a controller or board member asks at different moments. We group the tiles the same way:

Liquidity — can we cover what we owe right now?

• Working Capital — Current Assets minus Current Liabilities, in dollars.
• Current Ratio — the same comparison, as a ratio.
• Quick Ratio — Cash plus AR only, divided by Current Liabilities. Deliberately excludes inventory (and any other current assets) rather than the textbook "Current Assets minus Inventory" version — a more conservative number, since inventory isn't the same thing as cash in hand.

Collections & Payables — how fast is cash actually moving?

• Days Sales Outstanding (DSO) and Days Payable Outstanding (DPO) — trailing 3-month averages, not full-year, so a seasonal spike doesn't distort the read.
• Overdue AR and Overdue AP — not an average at all, a point-in-time snapshot: of what's owed right now, how much has actually aged past due.
• Cash Conversion Cycle — DSO plus Days Inventory Outstanding minus DPO. The single number that answers "how many days of cash is tied up in our operating cycle."

Inventory — how efficiently is stock turning?

• Inventory Turnover — annualized COGS over inventory balance.
• Days Inventory Outstanding — the same ratio, reframed as days on hand instead of times per year. Same underlying number; whichever framing matches how your team already thinks about it.

Cash — where do we actually stand?

• Net Change in Cash — labeled deliberately, not "Cash Burn": this is the net change in Cash-type account balances between snapshots, not a true operating cash flow figure. A loan draw shows up here as "generating cash" even if the business is burning heavily operationally — the tile says so, rather than overclaiming precision it doesn't have.
• Cash Runway — current cash divided by the net change rate. Reads N/A when cash is flat or growing, which is correct, not broken — a runway number only means something when there's actually a burn to measure against.

Every tile shows its work

A KPI a board member can't audit isn't trustworthy, it's just a number someone asserted. Every tile has a "Show calculation" toggle — the exact formula and every input dollar figure that produced it, not a black box you have to take on faith.

Built in, but nothing about a period you can't move

Toggle the "As Of" month anywhere else in the app and these ratios move with it — DSO for March looks at March's snapshot and a trailing window ending in March, not whatever the most recent sync happened to pull. A ratio that can't be pinned to a specific month is a ratio you can't actually defend in a board meeting when someone asks "as of when?"

Turn any of them off, per company

Not every one of the 12 is relevant to every business. A services company with no inventory has no use for Inventory Turnover or Days Inventory Outstanding. Each tile can be switched off independently, per company, from Config — the KPI tab shows exactly the ratios that matter for that client, nothing else cluttering the view.

Frequently asked questions

How do you calculate DSO from QuickBooks data?

AR balance divided by net revenue, times the days in the period. DrillFi uses a trailing three-month window rather than a full year, so a seasonal spike doesn't distort the number.

How is the cash conversion cycle calculated?

DSO plus days inventory outstanding, minus DPO. It's the single number that answers how many days of cash are tied up in your operating cycle.

What is the quick ratio in DrillFi?

Cash plus AR, divided by current liabilities. It deliberately excludes inventory and any other current assets, which makes it more conservative than the textbook current-assets-minus-inventory version.

How do you calculate inventory turnover and days inventory outstanding?

Inventory turnover is annualized COGS divided by the inventory balance. Days inventory outstanding is 365 divided by inventory turnover, the same ratio expressed as days on hand.

Why does cash runway show N/A?

Runway is current cash divided by the net change in cash, so it reads N/A when cash is flat or growing. That's correct, not broken: a runway only means something when there's a burn to measure.

Can I turn off KPIs that don't apply to my business?

Yes. Each tile can be switched off per company from Config, so a services business with no inventory can hide inventory turnover and days inventory outstanding.