Accounts Receivable Turnover Calculator

The accounts receivable turnover, sometimes referred to as the receivables turnover ratio, is an activity ratio and measures the number of times the accounts receivable was collected during an accounting period or looked at another way, the number of times the accounts receivable was converted into cash.

The value of the accounts receivable turnover will depend on the industry the business operates in.

A low accounts receivable turnover can indicate inefficiency in collecting accounts receivable from customers, leading to bad debt write offs for the business.

accounts receivable turnover calculator v 1.0
Accounts Receivable Turnover Calculator Preview

The ratio calculation is carried out using the accounts receivable turnover formula by dividing the net credit sales by the average accounts receivable for the period.

Accounts receivable turnover = Net credit sales / Average accounts receivable

Net credit sales is found on the income statement and is used to eliminate cash sales which do not create accounts receivable.

Accounts receivable is found on the balance sheet of the business. The average of the opening and closing accounts receivable balances is used to avoid distorting the result.

Using the Accounts Receivable Turnover Calculator

The Excel receivables turnover ratio calculator, available for download below, is used to compute accounts receivable turnover by entering details relating to the net credit sales and the opening and closing accounts receivable balances. The calculator is used as follows:

  • The net credit sales is entered. Net credit sales is found on the income statement of the business.
  • The opening and closing accounts receivable balances are entered. The opening and closing accounts receivable are found on the balance sheet of the business. The accounts receivable turnover calculator calculates the average value of accounts receivable during the accounting period, and the accounts receivable turnover.

There is no correct value for the accounts receivable turnover as it depends on the industry in which the business operates. It is useful to compare the calculated figure with other businesses in your industry using figures available from published financial statements.

Accounts Receivable Turnover Calculator Download

The accounts receivable turnover spreadsheet is available for download in Excel format by following the link below.

Notes and major health warnings
Users use this accounts receivable turnover calculator at their own risk. We make no warranty or representation as to its accuracy and we are covered by the terms of our legal disclaimer, which you are deemed to have read. This is an example of an accounts receivables turnover accounting tool that you might use when considering how to calculate accounts receivable turnover. It is purely illustrative. This is not intended to reflect general standards or targets for any particular business, company or sector. If you do spot a mistake in this account receivable turnover calculator, please let us know and we will try to fix it.
Accounts Receivable Turnover Calculator November 6th, 2016Team

You May Also Like

Related pages

formula of total asset turnover ratiosimple expenses claim form templatecarriage inwards definitionamortization chart excelthe basic accounting equation cannot be restated asformula for calculating retained earningsdepreciation formula accountingwage expense journal entrydouble entry bookkeeping definitionprepaid rent on balance sheetunrealized gains and losses income statementunearned revenue is what type of an accountpv perpetuityifrs deferred revenueamortisation scheduletemplate for petty cashjournal entry of bad debtsdaily timesheet template exceldouble declining balance method depreciation calculatoraccrual to cash adjustment worksheetcash flow projections template excelbookkeeping process flowgrowing annuity formulajournal entry for credit salesaccrual double entryaging accounts receivable methodpmt functionhow to calculate variable cost per unitdebtors collection period definitionpayroll accrual examplegross profit multiplierdepreciation charges on fixed assetscosts of goods sold equationbond payable on balance sheetfob shipperhow to prepare an accounting worksheetadjusting entries for deferralsreconciling accounts payableaccounts payable double entry200 db depreciation tableexample of unearned revenueexamples of common stockunearned income in balance sheetaccrual and prepaymentdays sales in receivables ratio analysisendowment funds definitionperpetuities formulaliquidity ratio equationhow to record fixed assets in quickbooksremittance in accountinghow to calculate selling price based on marginfob in accountingamortizing bondhow to calculate markup percentcheque received from debtor journal entryunadjusted and adjusted trial balanceperpetuities formulabonds payable journal entrygeneral ledger excellessor accounting for operating leasecreditors ledgerdefine gear ratiocontingent liability journal entrypresent value of lump sum formulahow to calculate total variable costsending inventory formulahow to calculate present value annuitysales ledger account formatcurrent asset turnover ratio formulaaccounts journal entries basicsba ii plus growing annuityaccrual accounting examplesexample of a general ledgernotes receivable discountedperpetual inventory accountingpv growing perpetuitybasic accounting tutorialdirect materials formulagross profit percent formuladepreciation entries for fixed assetscredit debit balance sheet exceldepreciation calcthe purpose of closing entries is to transfer