How this instrument works
Total sales is the plainest number in a set of books: units moved multiplied by what each one sold for, counted the moment money changes hands. A shop owner reads it off the till at closing, a sales rep checks it against a monthly target, and a marketplace seller uses it to size up how a launch actually went — before a single cost, refund, or tax line touches the figure.
The formula holds one assumption steady: a single price applies to every unit in the batch. That is rarely how a real sales period unfolds — a first batch clears at full price, a clearance run sells at a markdown, and a wholesale order goes out at a third figure entirely — so this sheet is a fast estimate for a uniform price, not a ledger built from a mix of them. Run it once per price and add the results when the mix matters.
What total sales excludes matters as much as what it includes. It says nothing about sales tax collected on a state's behalf, nothing about a card processor's cut, nothing about goods that come back as returns, and nothing about what it cost to make or stock the units in the first place. Treat the figure as the top of a much longer column of arithmetic, not as cash in hand or as taxable profit.
- Enter Units sold for the batch, shift, or period you're tallying.
- Set Price per unit, $ to what each unit actually sold for.
- Read Total sales, $ for the raw total — units times price, nothing subtracted yet.
- Change either field to test a different volume or price before committing to it.
Worked example — 500 units at $29.99
A pop-up stall sells out a limited run of 500 units at $29.99 each. Enter 500 into Units sold and 29.99 into Price per unit, $, and Total sales, $ reads 500 × 29.99 = $14,995.00 — the exact amount that changed hands before card fees, returns, or a single expense comes off it.
Hold price steady and push Units sold to 1,000 and the figure doubles cleanly to $29,990 — a straight line, because one fixed price per unit has no curve built into it. A real sales day rarely holds that still: a clearance markdown on the last dozen units, a bulk order at a lower rate, or a mid-run price increase all mean the true total is really several of these calculations added together, one for each price the units actually moved at.
Questions
Is total sales the same thing as revenue?
Not quite. Total sales is the raw figure — units moved times the price charged, counted the moment the transaction happens. Revenue is an accounting term, recognized under rules that can shift the amount or the timing: a return processed next month, a discount applied after the sale, or a delivery that hasn't happened yet can all separate the two numbers. This sheet gives you the raw total; a bookkeeper's revenue line is that total after those adjustments land.
Does the total include sales tax?
No, deliberately. Price per unit, $ should be what you charge before any tax collected on behalf of a state or municipality — that money passes through a seller rather than belonging to them. Fold tax into the price here and Total sales, $ overstates what the business actually keeps by exactly the amount owed to the tax authority later.
What if I sold at more than one price?
Run the calculation once for each price and add the totals — the sheet assumes one fixed Price per unit across every unit entered. Real sales mix full-price, discounted, and bundled units in the same period, so a single blended figure here is a stand-in for a weighted average, not a substitute for a full order log broken out by price point.
Is this the number my sales commission gets paid on?
Sometimes, but check the plan before assuming so. Some commission agreements pay a percentage of gross sales like this one, while others pay against gross profit or net revenue after returns — bases that can differ by a wide margin on the same deal. This sheet reports the gross figure only; match it to whatever base the actual agreement names.
Why track total sales instead of just units sold?
Units alone hide the effect of price. Selling 1,000 units at a discounted $15 brings in less than the 500 units at $29.99 in the example above — $15,000 against $14,995 is close, and nudge the discount a little further and the higher-volume, lower-price period quietly loses. Total sales is the number that reflects volume and price moving together, which is why targets are usually set against it rather than against a unit count alone.
References
- U.S. Small Business Administration — plan and manage a business
- Internal Revenue Service — Publication 334, Tax Guide for Small Business
Read this first: This instrument shows arithmetic, not advice. Real offers add fees, taxes and terms that vary by lender and place — verify the figures against your actual paperwork before deciding anything.