Debtor Days Ratio

What is the Debtor Days Ratio?

The Debtor Days ratio shows the average number of days your customers are taking to pay you. It is calculated by dividing debtors by average daily sales. It is sometimes referred to as days’ sales in accounts receivable.

What is the Formula for Debtor Days?

Debtor Days = Debtors / Average daily sales = Debtors / (Sales / 365)
  • Debtors is given in the Balance Sheet and is normally under the heading trade debtors.
  • Sales is found in the Profit and Loss Account.

How is Debtor Days Calculated in Practice?

Example 1

As 365 days (1 year) is used in the formula you must use the annual sales figure for sales.

Annual sales 200,000 and year end debtors 20,000 then
Debtors Days Ratio = 20,000 / (200,000 / 365) = 36.5 days
It takes the business on average 36.5 days to collect debts from customers.

Example 2

If you are using sales for a different period then replace the 365 with the number of days in the management accounting period.

If using monthly (30 days) management accounts
Monthly sales 18,000 and month end debtors 19,000 then
Debtors Days Ratio = 19,000 / (18,000 / 30) = 31.7 days

What does the Debtor Days Ratio Show?

If your debtor days are increasing beyond your normal trading terms it indicates that the business is not collecting debts from customers as efficiently as it should be, or perhaps terms are being extended to boost sales. For example if your normal terms are 30 days and your Debtor Days ratio is 60 days the business on average is taking twice as long to collect debts as it should do.

Any upward trend in the Debtor Days ratio means that an increasing amount of cash (possibly from overdrafts) is needed to finance the business, this can be a major problem for an expanding businesses.

Useful Tips for Using Debtor Days

  • The Debtor Days should be the same as your Terms of Trade with customers.
  • A cash business should have a much lower Debtor Days figure than a non-cash business.
  • Typical ranges for Debtor Days for a non-cash business would be 30-60 days.
Debtor Days Ratio November 6th, 2016Team

You May Also Like

Related pages

the aging of accounts receivable methodtrial balance is preparedroyalty accounting noteslength of operating cycle formulaworksheet of accountingpv of perpetuity calculatorhow to prepare a vertical analysisaccounting outstanding checksbookkeeping double entry examplesgoods receipt noteaccounts receivable accounting entriescapital lease entriesvariable overheadsadjusting entries for interestexamples of accrualsbank reconciliation statement solved problemsclosing entry for income summaryunder perpetual inventory systemaccounts payable credit or debitwhich of the following accounts belong in the general ledgerformula for gearingperiodic vs perpetualhorizontal analysis for income statementbad debts journal entrywhat is unearned revenue classified aspartnership profit sharing ratioreceivable turnover ratio exampledebit depreciation expenseutility expenses definitioncalculate turnover from balance sheetprintable ledger sheethow do you calculate contribution marginstraight line method depreciation examplelabour price variancestandard general ledger chart of accountsirr excellhow to calculate contribution margin percentagemultistep income statementformula for double declining balance depreciationmultistep income statementaccrued revenue in balance sheetformula of operating leveragecommon stock valuation calculatoradjusting entries merchandise inventoryfixed asset turn over ratiowhat is the purpose of preparing a bank reconciliationnormal balance of revenueprepaid expense assetpetty cash formulaexamples of intangiblessundry debtors definition accountingfob destination freight prepaid and alloweddeferred rent definitiondeclare cash dividend journal entryinterest revenue journal entrydepreciation debit or creditcredit sales in income statementledger in accounting examplepayback period excelformula for direct laborreceivable turnover ratedepreciation accounting entriesunderstanding accruals and prepaymentsannuity growth formulaproject payback period calculatordiscount amortization scheduleobjectivity principle accountingcalculating net present value in excelcalculating the present value of an annuityeffective interest method amortizationbasic accounting debit creditreturn on capital employed ratio formuladouble entry journal definitioncommon size income statementsinventories turnover days formulaaccounting equation excel templatewhat is roce ratioexample of general ledger entries