Average Collection Period Calculator
Print Report| Receivables Turnover Ratio | 0.0x |
| Daily Credit Sales Average | $0 / day |
If your business allows customers to purchase goods on credit, your company’s survival relies entirely on your ability to actually collect that cash in a timely manner. If you issue an invoice but your client takes three months to pay it, your business is effectively acting as an interest-free bank, crippling your own cash flow and leaving you unable to pay your own staff.
Our free online Average Collection Period Calculator allows business owners, credit managers, and financial analysts to instantly measure their collection speed. By calculating exactly how many days it takes for credit sales to convert into actual cash, you can audit your credit policies, hunt down delinquent accounts, and guarantee you have enough liquidity on hand to survive.
How to Use the Average Collection Period Calculator
To accurately measure your collection efficiency, you need specific data points from your income statement and balance sheet. Here is exactly how to input your numbers for a flawless calculation:
- Step 1: Average Accounts Receivable. Enter the average amount of money your customers owe you during the time period. (Hint: Add your starting balance and ending balance together, then divide by 2).
- Step 2: Total Credit Sales. Enter the total value of sales made strictly on credit during this period. Do not include cash sales, as cash is collected instantly and does not affect your collection period.
- Step 3: Number of Days. Enter the length of the time period you are analyzing (e.g., 365 days for an annual audit, 90 days for a quarterly review).
The 3 Calculation Methods Explained
Depending on what data you currently have in front of you, there are three different ways to calculate your Average Collection Period (ACP).
| Calculation Method | The Formula | How it Works |
|---|---|---|
| 1. The Standard Formula | (Average AR × Days) ÷ Credit Sales | The most common method. You simply multiply your unpaid invoices by the number of days in the year, and divide by your total yearly sales. |
| 2. The Turnover Method | Days in Period ÷ Receivables Turnover Ratio | If you already know your Turnover Ratio (e.g., your AR turns over 4 times a year), simply divide 365 by that number (365 ÷ 4 = 91 days). |
| 3. The Daily Sales Method | Average AR ÷ (Credit Sales ÷ 365) | First, divide your yearly sales by 365 to find out exactly how much credit you issue per day. Then, divide your outstanding balance by that daily rate. |
Evaluating Your Score: The “Rule of Thirds”
Once you calculate your ACP, you must compare it against your official company payment terms. In corporate finance, a healthy business should follow the “Rule of Thirds”: Your collection period should never exceed your official credit terms by more than one-third (33%).
| Your Official Terms | The Danger Zone (Maximum ACP) | Financial Analysis |
|---|---|---|
| Net-30 (Clients have 30 days to pay) | 40 Days Max | Because 30 divided by 3 is 10, your maximum threshold is 40 days. If your ACP hits 45 days, your credit department is failing to enforce terms. |
| Net-60 (Clients have 60 days to pay) | 80 Days Max | Because 60 divided by 3 is 20, your maximum threshold is 80 days. If your score exceeds this, you risk a severe cash flow deficit. |
Real-World Cash Flow Example: The B2B Supplier
Let’s look at a practical management example. You own a wholesale supply business. Over the last 365 days, you achieved $100,000 in net credit sales.
By checking your starting and ending balances, you determine that your Average Accounts Receivable for the year was $25,000.
Using the standard formula: ($25,000 × 365 Days) ÷ $100,000.
Your Average Collection Period is exactly 91.25 Days. If your official invoice policy is “Net-60”, your maximum threshold (using the Rule of Thirds) is 80 days. Because you are sitting at 91 days, this is a massive red flag. Your business is holding too much bad debt, and you must tighten your collection calls immediately.
If you want to view this metric as a clean ratio rather than a day count, use our Receivables Turnover Ratio Calculator. If you are struggling with cash flow because of a high collection period, you may need outside capital. Estimate your funding gap using our AFN (Additional Funds Needed) Calculator.
Frequently Asked Questions (FAQ)
What is the difference between ACP and DSO?
The Average Collection Period (ACP) and Days Sales Outstanding (DSO) measure the exact same thing: how long it takes to get paid. However, ACP strictly uses the Average Accounts Receivable (smoothing out seasonal spikes), whereas standard DSO calculations often just use the ending Accounts Receivable balance.
Is a lower Average Collection Period always better?
Generally, yes. A lower number means you are collecting cash rapidly. However, if your ACP is incredibly low (like 10 or 15 days), it might mean your credit policies are so aggressively strict that you are actually turning away potential customers who require standard Net-30 payment terms to do business.
How can a business reduce its Average Collection Period?
If your ACP is dangerously high, management must take immediate action. You can reduce your collection period by offering early payment discounts (e.g., “2/10 Net 30”, giving clients a 2% discount if they pay within 10 days), running stricter background credit checks on new clients, and actively calling delinquent accounts instead of just sending automated emails.
Why do cash sales distort the formula?
You must strictly use “Net Credit Sales” in the formula, totally ignoring immediate cash or credit card purchases. Because cash sales are collected in zero days, mixing them into the equation will artificially drag your ACP number down, making your collections department look highly efficient when in reality, they are failing to collect on outstanding invoices.
Why do banks and financial institutions care about ACP?
When you apply for a business loan, banks look closely at your Average Collection Period. If your ACP is extremely high, the bank views you as a high-risk borrower because your cash is trapped in uncollected invoices, meaning you might struggle to make your monthly loan payments on time.
What happens if a customer never pays?
If a customer permanently defaults on their invoice, the company must eventually write off the balance as “Bad Debt Expense.” This removes the amount from Accounts Receivable and officially recognizes the money as permanently lost, directly lowering the company’s net income for the year.