Revenue can grow while one customer quietly carries most of it, and no line on the P&L shows what happens to this year's number if that relationship changes. The cost of that dependence arrives later, as a lender's question, a buyer's discount or a quarter with one fewer customer, so the decision in front of you is whether to measure three things now: how much revenue rests on one customer, how much of it drifts back out as refunds and credits, and how much of what is owed is collectible on time.
A single customer at 40% of revenue is a fact a buyer, a lender or you should know explicitly. Some businesses are built that way on purpose, and what helps is having the number in hand before someone else asks for it. All three checks run from a revenue ledger, a customer history and an AR Aging report you already have.
Three Checks and the Levels Worth Watching
Total revenue answers how much. These three checks answer how spread out it is, how much of it sticks and how much of it is collectible.
| Check | What it measures | Level worth watching (typical) | Example in this page |
|---|---|---|---|
| Customer concentration | Each customer's share of total revenue | Flag at 25% or more, RED at 40% or more | One customer at 53% of $78,600 of gross sales |
| Refunds and credit memos | Credits as a share of gross sales | Flag at 3% or more of gross sales | $5,000 of credits is 6.4% |
| AR over 60 days | The share of open receivables past 60 days | Flag at 15% or more of open AR | $11,700 of $45,000 is 26% |
These levels are common working thresholds and vary by industry. Apply them as a pattern to your own numbers. If one customer is asking for longer terms or a discount for paying faster, what do these payment terms actually cost me prices the ask on that customer's real days-to-pay.
What to Pull First
The check is only as good as the three exports behind it, and most of the ways this goes wrong happen at the export step, before a single formula runs. You need one month of revenue-account ledger lines with the customer on every row, a short customer history, and an AR Aging summary dated the last day of that month.
| Platform | Revenue ledger | Setting to check |
|---|---|---|
| QuickBooks Online | General Ledger (Reports, Accountant reports) or Sales by Customer Detail (Reports, Sales and customers) | Filter Account type to Income, set the date range to the exact month and show the Name column. Credit memos and refund receipts must appear as negative lines. |
| QuickBooks Desktop | Sales by Customer Detail (Reports, Sales) | Set the date range to the exact month. If you use Jobs under customers, pick the customer level or the job level and keep to it. |
| Xero | Account Transactions (Accounting, Reports) | Select every revenue account and set the date range to the month. The Contact column carries the customer, and credit notes show as negatives. |
For the customer history, pull one row per customer billed this month with that customer's revenue in each of the three prior months. QuickBooks has this as Sales by Customer Summary with columns set to Months, and Xero has Income by Contact. Three blank months mean there is no prior revenue on file, and that blank is how the check recognizes a new customer. For the AR Aging, use the summary version with customer, total open balance and the four standard buckets (current or 0 to 30, 31 to 60, 61 to 90 and 90-plus). That is A/R Aging Summary in QuickBooks and Aged Receivables Summary in Xero. Run it as of the last day of the month you are reviewing, because a report dated three weeks later shows balances that have since been paid or aged into the next bucket.
How It Works: Four Places the Export Goes Wrong
- The customer column. Concentration and the presence pattern depend on it, so it has to be consistent. A repeating ID such as CUST-001 works. The same customer under two spellings splits their share in two.
- Sub-customers and jobs. QuickBooks Online sub-customers and QuickBooks Desktop jobs roll up to a parent customer. A check run at the job level can show a parent at 15% spread across five jobs, and a check run at the parent level can hide that one division of that customer is the whole story. Pick the level a buyer or lender would ask about, usually the parent, and keep to it in all three pastes.
- Refunds. A credit memo or refund receipt posts against the revenue account as a reduction. Leave the sign as exported: positive for a sale, negative for a credit. If your bookkeeper posts refunds to a separate Refunds expense account, the revenue ledger looks cleaner than it is and the refund share reads low, so include that account in the pull.
- Deposits and retainers. On an accrual basis, a customer deposit sits in a liability account until the work is done. A deposit booked straight to income makes this month's concentration overstate the customer who paid up front and next month's understate them. That is a books question before it is a revenue-quality question.
Before you paste anything in, compare two totals: the month's revenue ledger against the revenue line you already know, and the aging summary's open balance against the AR balance on the balance sheet for the same date. If either is off, the export has a problem, and correct concentration math on a wrong input still produces a confident-looking wrong answer.
The workbook also tags each customer by whether their revenue appears in each of the last three months, in none of them or in some. A customer who bills quarterly will look inconsistent even while the relationship is stable, so check their billing pattern before you read the tag.
Worked Example: One Customer at 53%
Take a month with $78,600 of gross sales, $5,000 of credits and refunds, and $45,000 of open receivables. One customer billed about $41,700 of the sales, and $11,700 of the open receivables is past 60 days.
| Check | Level worth watching | Example | What it says |
|---|---|---|---|
| Customer concentration | 25% of $78,600 is $19,650. 40% is $31,440. | $41,700 is 53% | One relationship is more than half of sales and above both levels. If it ended, the month's sales would be about $36,900. |
| Refunds and credit memos | 3% of $78,600 is $2,358. | $5,000 is 6.4% | The credits are more than twice the watch level. Find out whether they are a pattern (disputes, quality issues) or a one-time cluster. |
| AR over 60 days | 15% of $45,000 is $6,750. | $11,700 is 26% | The aged balance is $4,950 over the watch level, and that share is aging past the point where collection gets comfortable. |
Each finding is a fact about the ledger and the aging report that calls for a specific follow-up conversation, and none of the three is a verdict alone. Put your own month into the same table and start with the first row.
When This Is Not the Right Page
- You are unsure the books are accurate. Fix that first, because concentration and collections math on unreliable revenue postings misleads. The books-mess triage is the better start.
- The business is profitable on paper and the bank account is tight. Slow collections are one of seven possible cash drains, and profit on paper but no cash covers the whole set.
- The question is whether a specific job or project earns. That is job costing. A customer can be a large, healthy share of revenue and still be a bad job on margin grounds.
- A sale is in motion and a buyer's accountant is about to ask these questions formally. That is quality-of-earnings prep, which goes well beyond a monthly check.
- The concentration would be created by a contract you have not signed. Can I afford to deliver this contract tests whether the business survives that customer giving notice before the work can be replaced, alongside the cash the job ties up before it pays.
Frequently Asked Questions
What level of customer concentration is risky?
Common thresholds flag one customer above roughly 25% of revenue as worth watching and treat 40% or more as a real structural dependency. The right level depends on the business and on how stable the relationship is.
Does high customer concentration always need to be fixed?
No. Some businesses are built around a small number of large relationships on purpose. The aim is to know the figure explicitly before a buyer or lender raises it.
What does an AR aging report tell me?
It shows how much of what customers owe you is current and how much is 31 to 60, 61 to 90 or 90-plus days overdue. A rising share past 60 days is often an early sign that paper revenue and collectible cash are drifting apart.
Can this check tell me whether a customer is recurring revenue?
With low confidence. It shows whether a customer's revenue appeared in each of the last three months on file. A customer who bills quarterly can look inconsistent while the relationship is stable.
Should the check run at the customer level or the job level?
Run it at the level a buyer or lender would ask about, which is usually the parent customer, and use that level in all three exports. A job-level run can split one relationship across several lines, and a parent-level run can hide that one division carries the whole account.
Sources
- The $78,600 of gross sales, $5,000 of credits, $45,000 of open receivables, $11,700 past 60 days and the customer at about $41,700 are illustration figures.
- The 25%, 40%, 3% and 15% levels are common working thresholds that vary by industry. They are a pattern to apply to your own numbers.
Next Step
If you are heading into a lender conversation, a sale process or a year where you want fewer surprises, compute the three checks before estimating them. The Revenue Quality Analyzer is a $14.99 workbook that flags concentration, refund and credit-memo levels and aged receivables against thresholds you can see and adjust, and it discloses the presence-pattern limitation inside the workbook. If the deeper question is whether the books as a whole would hold up to a buyer's review, the books-ready-to-sell diagnostic is the better start, with the sale-ready books guide for the fuller breakdown.
This article is informational and does not constitute financial, legal, or tax advice. Consult a qualified professional for decisions specific to your situation.