Selling and administrative expense budget: a worked example

A selling and administrative expense budget combines fixed department costs with costs driven by sales or business activity. Build it by account and owner, then distinguish the amount charged to profit from the cash paid. That separation lets finance explain whether a higher total reflects more activity, higher rates or a new spending commitment.

Set the boundary before calculating

The schedule covers selling and administrative functions outside production. OpenStax's operating-budget chapter describes this budget as fixed and variable nonmanufacturing expenses, often assembled from smaller manager-owned budgets.

For a distributor, examples include sales salaries, commissions, finance payroll and office costs. Use the company's existing accounting policy to decide where customer delivery or order support belongs. If a cost already sits in cost of goods sold, do not repeat it here simply because another company calls it selling expense.

The business budget template places operating expenses within the annual plan. This schedule supplies the detailed selling and administrative component. The comprehensive budget connects it with revenue, cash and the balance sheet.

Gather the rows and select the drivers

Start with the department ledger export, payroll roster, commission terms, order register and recurring vendor commitments. Preserve the account, department, cost owner, period, transaction amount and payment date. Add a budget classification for fixed, variable, stepped or noncash costs.

Choose a driver that explains the obligation. A commission contract based on revenue needs revenue as its driver. A service fee charged for each order needs order count. A salaried finance team needs approved staffing and compensation assumptions, rather than an arbitrary percentage of sales.

For each payroll line, state whether wages, employer taxes and benefits are included. For subscriptions and insurance, distinguish the expense coverage period from the invoice payment date. Those details prevent apparently precise formulas from producing an incomplete budget.

A worked quarterly example

Consider an illustrative US distributor budgeting a quarter. It expects revenue of $1,200,000 across 4,000 orders. The commission agreement pays 3% of recognized revenue, and an outsourced sales-order support service charges $4 per order. All remaining lines below are approved fixed costs within the planned activity range.

Payroll amounts include employer taxes and benefits. All cash expenses are paid in the quarter incurred, with no opening or closing accruals or prepayments. These assumptions simplify the cash bridge; actual payment timing belongs in separate schedules.

Selling and administrative expense budget = Fixed expenses + Sum of planned activity × Applicable expense rate

The variable component is 36,000 + 16,000 = $52,000. Fixed expenses sum to 90,000 + 72,000 + 24,000 + 18,000 + 6,000 + 12,000 = $222,000. Together they reproduce the $274,000 expense budget.

If the table begins with headers in row 1, expense amounts in C2:C9 and noncash amounts in D2:D9, the summary formulas are:

Total expense: =SUM(C2:C9)
Noncash expense: =SUM(D2:D9)
Cash requirement: =SUM(C2:C9)-SUM(D2:D9)

Under the stated timing assumptions, the cash requirement is 274,000 - 12,000 = $262,000. The SEC's guide to financial statements explains depreciation as allocating an asset's cost over the periods of use. It reduces earnings without being a payment for that period.

Keep a purchase of new office equipment in the capital budget. Adding the purchase price to this expense schedule and also including depreciation would confuse investment cash with operating expense.

Change one input: higher revenue, unchanged order count

Now raise expected revenue by 10% through higher realized prices. Order volume, commission rate and every fixed cost remain unchanged. This isolates the revenue assumption; it is not a claim that prices can rise without affecting demand.

Revenue becomes 1,200,000 × 1.10 = $1,320,000. Commissions become 1,320,000 × 3% = $39,600, so expense and cash needs each increase by $3,600. Order support does not change because its driver did not change.

Expense as a share of revenue falls from 274,000 / 1,200,000 = 22.8% to 277,600 / 1,320,000 = 21.0%, rounded to one decimal place. The lower ratio does not mean the team cut costs: expense increased while revenue increased faster.

Review actual spending against the right explanation

After the quarter closes, match actual ledger accounts to these budget lines and reconcile the mapped total to the general ledger. Retain unassigned accounts as exceptions until a responsible person classifies them.

Compare actual commissions with actual eligible revenue and the approved rate. Compare order support with actual orders and its approved fee. Then review fixed-cost differences with their owners. This distinguishes activity changes from rate changes, timing differences and new commitments; variance analysis explains the broader reporting method.

Where it goes wrong

• One percentage for everything. Applying revenue growth to rent, payroll and order fees ignores their different drivers.
• Fixed beyond capacity. Staffing stays fixed in the workbook even when higher activity requires additional employees or shifts.
• Expense treated as payment. Annual insurance prepayments and delayed invoices disappear from the cash bridge.
• Duplicate cost ownership. A shared subscription or employee appears in both a central budget and a department submission.

Check your department schedule in Covirage

Bring your selling and administrative budget, activity workbook and actual ledger export to Covirage. Covirage maps the columns, and its tools compute and check the comparisons; the external AI model explains the differences with every figure traced to its rows. Create a free Covirage account, which takes about a minute, and bring a sample of your own data.

See FP&A reporting for the reporting context.