Percentage of Sales Method

The percentage of sales method turns last year’s ratios into next year’s numbers. See the two steps, the lines it cannot forecast, and the second meaning.

Written by AccountablyReviewed by Jugal Thacker, CPA6 minute readUpdated

The percentage of sales method is a forecasting technique that states each line that moves with revenue as a percentage of sales in a past period, then applies those percentages to a forecast sales figure to build the next period’s numbers. It rests on one assumption, that the relationship between sales and those lines holds, and everything the method gets right or wrong follows from whether that assumption survives contact with the business.

The phrase also names a second thing in accounting, an approach to estimating bad debts. Which one is meant is usually clear from the room: a planning conversation means the forecast, a close means the estimate. Both are covered below.

Why Sales Is the Driver

The method starts from sales because most of what a business spends is a consequence of what it sells.

A significant portion of a business’s costs are driven by how much it sells, so the sales forecast is the necessary first step in preparing a financial forecast, and common costs driven by sales include direct product costs, direct labor costs, and other key variable costs, meaning costs that vary proportionately to sales, such as sales commissions (OpenStax, Principles of Finance, 18.2 Forecasting Sales).

Read the qualifier in that sentence rather than the headline. It is the costs that vary proportionately with sales that the method is built for, and treating every line as one of them is where a percentage-of-sales forecast starts producing numbers nobody should act on.

The Two Steps

The mechanics are as simple as they look, which is both the appeal and the trap.

step 1   historical percentage  =  line item / sales, for a base period
step 2   forecast line item     =  historical percentage x forecast sales

Say a business closed a year on the figures below and expects sales to grow. The percentages come out of the base year, and the forecast column is those percentages applied to the new sales number.

                          base year        percent of sales     forecast year
sales                       1,000,000                              1,200,000
cost of goods sold            600,000              60.0%             720,000
sales commissions              50,000               5.0%              60,000
accounts receivable           125,000              12.5%             150,000

Nothing about that arithmetic makes the answer right. It makes the answer consistent with the base year, which is a different claim and a much weaker one.

What the Method Cannot Forecast

Three groups of lines break it, and knowing which is most of the skill.

Fixed costs. Rent, insurance and a salaried finance team do not rise with a good quarter. Running them through a sales percentage inflates the forecast expense and understates the forecast margin, and the error grows with the growth rate. The distinction the method depends on is set out in fixed expenses and variable expenses.

Step costs. A second warehouse, a new production line or a fifth reviewer arrives all at once at some level of volume and then stays flat. A percentage cannot express a step, so the forecast is smooth where the business is not.

Capital structure. Debt, equity and the interest that follows them are decisions rather than consequences of sales. A forecast that scales a loan balance by revenue growth has confused a plan with a projection.

There is a fourth caution that applies to the whole exercise. A base year with anything unusual in it, a one-off gain, a strike, a lost customer that has since been replaced, hands its distortion to every forecast year built from it, and the percentage will carry the anomaly forward silently.

The Other Percentage of Sales Method

In the close the same phrase names a way of estimating uncollectible receivables. The estimate is a percentage of the period’s credit sales, charged to expense, rather than a figure worked up from the receivables balance by age.

Two things about it are worth stating plainly. It is an income statement approach, so it sets the expense for the period directly and lets the allowance balance fall where it falls, which is the reverse of an aging analysis. And no accounting standard prescribes it. The methods the current standard leaves open, and what actually has to be true of an estimate, are set out in allowance for doubtful accounts, with the charge itself in bad debt expense.

The tax side does not follow either version. A book estimate produces no deduction, because the deduction turns on a specific debt becoming worthless, a split worked through in accounts receivable.

Where a US Firm Meets It

In advisory work more than in compliance, and the value is in the questions rather than in the spreadsheet.

Which lines were actually treated as variable, and on what evidence. A client model that ran every expense line through one percentage is the common case, and separating the fixed block out is usually the single change that improves the forecast most.

What the base period was, and whether it was normal. A twelve-month base picks up seasonality that a quarter cannot, and a base year with a one-off in it needs the one-off taken out before any percentage is computed.

Whether the output is being read as a forecast or as a target. The method produces a consistent set of numbers, not a prediction, and the difference matters when the output is going to a lender. Where the result becomes a formal set of statements built on assumed facts, the standards that govern it are in pro forma financial statements.

Common Questions

Divide the line item by sales for a base period to get its percentage, then multiply that percentage by forecast sales to get the forecast line. The whole method is those two steps applied to each line that varies with revenue.

It is consistent rather than accurate. It reproduces the base period’s relationships at a new sales level, so it is as good as that base period is representative and as good as the split between the lines that move with sales and the lines that do not. It has no way to signal that either assumption has failed.

They answer different questions with the same words. On a bad debt estimate, a percentage of credit sales sets the period’s expense directly, while an aging analysis works up the required allowance balance from how long each receivable has been outstanding and lets the expense fall out of the movement. The balance-sheet route and what it produces are covered in allowance for doubtful accounts.

Accountably places trained offshore accountants and tax preparers inside US CPA and EA firms under layered review, and a trial task lets a firm’s own reviewer grade a real block of close and reporting work before any client file depends on it.

Related Terms

View All Terms

See how to evaluate an offshore accounting partner before you sign. Download the free guide now.