Skip to content
Enjoy complimentary data migration when switching from your existing bookkeeper or CPA to Institution.

Bookkeeping & finance

Agree what belongs in the quick ratio before comparing reports

Reconcile a cash-and-receivables definition with a current-assets-less-inventory shortcut, and show how prepaid assets can explain different results.

By Institution5 minute readPublished View sources
In this guide

Find the definition behind each reported ratio

Two reports can display different quick ratios from the same balance sheet because they define the numerator differently. One may add cash, short-term investments and receivables; another may subtract only inventory from current assets. If prepaid expenses or other current assets remain, the formulas do not produce the same amount.

OpenStax's liquidity-ratio discussion presents the narrower cash, investments and receivables formula and excludes inventory and prepaid expenses. Its working-capital discussion also shows a current-assets-less-inventory shortcut. These formulations make the need for an explicit definition visible: the label alone is insufficient when the asset mix differs.

Before comparing results, ask for the actual formula and account mapping used by each report. Record whether the measure is an internal analysis, a peer statistic or a contractual calculation. A lender's agreed definition must be assessed on its own terms rather than replaced with a preferred textbook shortcut.

References: OpenStax: Current, quick and cash ratios; OpenStax: Working capital measures and their limitations

Reconcile a balance sheet with prepaid expenses

Consider a fictional company with $40,000 of cash, $20,000 of short-term investments, $70,000 of net trade receivables, $80,000 of inventory and $20,000 of prepaid expenses. Those categories total $230,000 of current assets. Current liabilities are $100,000, producing a current ratio of 2.3.

The narrower quick-asset numerator is $40,000 plus $20,000 plus $70,000, or $130,000. Its quick ratio is 1.3. Subtracting only inventory from current assets instead leaves $150,000 and produces 1.5. The entire 0.2 difference comes from the $20,000 of prepaid expenses.

Nothing in this comparison requires changing the ledger. The balance sheet can be correct while the analytical formulas differ. The review needs a definition bridge, followed by a decision about which measure is appropriate for the intended report.

To test the mapping, suppose the company then pays another $10,000 in advance for a service and records a prepaid asset. Cash falls to $30,000 while prepayments rise to $30,000. Total current assets remain $230,000, but narrower quick assets fall to $120,000 and the quick ratio becomes 1.2. The shortcut that subtracts only inventory still returns 1.5. This transaction exposes exactly which formula responds to the transfer of cash into prepayments.

Reconcile a balance sheet with prepaid expenses
Illustrative asset categoryAmountIncluded in narrower quick assets
Cash$40,000Yes
Short-term investments$20,000Yes, under the stated definition
Net trade receivables$70,000Yes
Inventory$80,000No
Prepaid expenses$20,000No
Total current assets$230,000$130,000 included

Map the general ledger deliberately

Create an account-level mapping from the reported current assets to included quick assets, excluded assets and items requiring a decision. Record the rationale for each material category. This is more reliable than using a subtotal whose contents can change when new accounts are introduced.

Check how receivables are measured. The example explicitly uses net trade receivables, so adding the related allowance back elsewhere would change the basis. Retain a reconciliation to the financial reporting balance and document any separately defined analytical adjustment.

Other current assets may include deposits, recoverable taxes or amounts due from related parties. Their appearance under a current-assets heading does not automatically settle whether they belong in the chosen quick-ratio definition. Resolve the treatment from the report's purpose and documented policy.

Assign an owner for new or renamed accounts. A reporting mapping that was correct last quarter can drift when the chart of accounts changes. Include unmapped balances in an exception report so they do not disappear from the numerator or enter it silently.

Assess availability and timing beside the ratio

The narrower formula still combines balances with different practical characteristics. A receivable included in quick assets may not be collected before a specific payroll date. An investment included under the stated definition may have settlement timing or restrictions that need separate review for cash planning.

Keep those operational questions visible without rewriting the reported formula informally. Show restrictions, collection uncertainty and timing assumptions in supporting schedules. If management uses an adjusted liquidity view, label it separately and reconcile it to the standard internal ratio.

For example, suppose $30,000 of the fictional $70,000 receivable balance is not expected to arrive until the following month. The recorded quick ratio remains 1.3 under the stated definition. A next-week payment forecast should use the supported receipt dates, which may show a different practical funding position.

This separation also helps explain why a ratio threshold is not a universal payment authorization. The ability to meet a dated obligation depends on the funds available by that date and the other commitments competing for them. Keep the ratio and the cash schedule connected but clearly defined.

Make comparisons on a common basis

When comparing two periods, first confirm that the definition and account mapping stayed the same. A newly excluded prepaid balance can lower the ratio even if the underlying operations did not change. Show the effect of a definition change separately from the movement in the business.

For peer comparisons, inspect the source methodology before ranking companies. A ratio calculated as current assets less inventory is not automatically comparable with one that also excludes prepayments and other current assets. Where the necessary detail is unavailable, state the comparability limit instead of manufacturing a precise adjustment.

Avoid treating an illustrative ratio of 1.3 or 1.5 as a universal target. The example demonstrates a definition difference. Appropriate operating analysis depends on the business's obligations, asset mix, collection pattern and the purpose of the review.

Publish the formula with the reconciliation

A compact report can show total current assets, inventory excluded, prepayments and other exclusions, resulting quick assets, and current liabilities. Put the exact numerator definition beside the final ratio. A reviewer should be able to reproduce the result without opening a separate undocumented workbook.

Retain the approved mapping and calculation for each reporting date. If a later account reclassification changes the historical figure, explain the revision rather than silently replacing it. Consistent definitions make trend analysis more useful than a polished chart built from shifting inputs.

In the fictional comparison, 1.3 and 1.5 describe different numerators. The useful resolution is to identify the $20,000 prepaid balance, agree the intended definition and apply it consistently. That answers the discrepancy while leaving the underlying financial records intact.

Sources

Requirements and product details can change. Check the linked guidance for the facts that apply to your situation.

Related reading

Need help with this work?

General information, not personalized accounting, tax, legal, or investment advice. Have the appropriate qualified professional review decisions that depend on your circumstances.