Cash Flow and Working Capital

Accounts Receivable Days Calculator

Convert average trade receivables and credit sales into collection days for a selected reporting period.

Inputs4 editable fields
ScopeUser-entered business case
ModelCash Flow and Working Capital
Business calculator

Enter your numbers

Replace the sample values with figures from one consistent business period or proposal.

Calculations run in this browser and do not transmit your entries.

$
Your estimate will appear here

Change the sample inputs to match your records.

A narrow reading of the estimate

For this accounts receivable days case, the page answers a bounded measurement question: Convert average trade receivables and credit sales into collection days for a selected reporting period. Its output should travel with the underlying bank and forecast records.

With accounts receivable days defined, save the baseline before negotiating or forecasting a change. A dated baseline shows which commercial fact produced the movement.

Trace the arithmetic

Receivable days equals average receivables divided by credit sales, multiplied by days in the reporting period.

While examining accounts receivable days, arithmetic follows the stated rule—Receivable days equals average receivables divided by credit sales, multiplied by days in the reporting period. No unstated fee, rate, or adjustment is supplied by the page.

Establish the measurement base

Beginning trade receivables. In the accounts receivable days file, Opening eligible trade receivables. Retain references for both Beginning trade receivables and Ending trade receivables beside the output.

Ending trade receivables. As a accounts receivable days assumption, Closing eligible trade receivables. Compare Ending trade receivables with Credit sales inside the accounts receivable days boundary and its selected currency.

Credit sales. A separate accounts receivable days option needs another value because Credit sales during the period. Align the date attached to Credit sales with the timing assigned to Days in reporting period.

Days in reporting period. The accounts receivable days evidence defines it this way: Calendar or reporting days represented. Document whether Days in reporting period follows a different accounts receivable days allocation or rounding rule from Beginning trade receivables.

From a accounts receivable days standpoint, when accounts payable days affects the decision, compare this result with a fresh Accounts Payable Days Calculator run.

A second reader of accounts receivable days should note that for a separate view of cash conversion cycle, transfer the dated evidence to the Cash Conversion Cycle Calculator.

Worked check with sample figures

Numbers supplied for the check: Beginning trade receivables = $190,000; Ending trade receivables = $230,000; Credit sales = $1,450,000; Days in reporting period = 365 days.

From a accounts receivable days standpoint, use the sample to confirm the interface, not the business forecast. A later run should replace every illustrative amount that matters.

Check the denominator and timing

While examining accounts receivable days, compare the output with the original cash plan, not with an unlabeled benchmark. Different definitions often create larger differences than arithmetic.

Keep Beginning trade receivables tied to its original evidence while negotiating Days in reporting period. That separation avoids rewriting history to fit a proposal.

Use accounts receivable days to illuminate the connection between Beginning trade receivables and Days in reporting period, not to conceal a gap between their evidence or measurement dates.

After reviewing accounts receivable days, distinguish the numerical finding from the commercial response. Different teams may act on the same figure in different ways.

A second reader of accounts receivable days should note that a later review of free cash flow belongs in the Free Cash Flow Calculator; carry over only figures that share this page’s date and definition.

Limits of the arithmetic

From a accounts receivable days standpoint, several commercial questions remain external to the arithmetic. Aging, disputed invoices, bad-debt reserves, seasonality, and cutoff errors are not visible in the average.

A second reader of accounts receivable days should note that document any manual allocation or conversion outside the form; otherwise the result cannot be reconstructed reliably.

For this accounts receivable days case, use the Cash Runway Calculator for the downstream cash runway question and note the figure transferred from this case.

Notes for later review

Who should own the assumptions?

From a accounts receivable days standpoint, assign the case to the person responsible for the supporting bank and forecast records.

May default values remain in a saved case?

A second reader of accounts receivable days should note that only when they are actual documented values; otherwise replace or clearly label them illustrative.

Why inspect supporting rows?

For this accounts receivable days case, they show whether movement arose before the headline and often identify a data problem.