Tax-included prices: 3 steps to back out sales tax

To back sales tax out of a tax-included price, divide by one plus the tax rate, then subtract that result from the total.

Key takeaways

Confirm the applicable tax rate before calculating.
Group tax-included sales by rate.
Keep tax-free and tax-added sales separate.
Check that pre-tax sales and tax add back to the total.

If your shop puts sales tax inside the price tag, you already know the end-of-day problem. The till shows one number for each sale: the amount the customer paid. Your tax paperwork needs two numbers instead: the part of that money that was your sale, and the part that was tax you collected for the state. The tag does not show that split, so you have to work it out yourself.

This post walks through the arithmetic in three steps. You do not need an accounting background or special software. A calculator, the day's tally, and the tax rate that applies to your items are enough. After a few days of practice, the work takes less time than reading this introduction did.

One note before we start. This post is about the math. Which items are taxable, which rate applies to a sale, and how to fill out your return are questions for your state's tax agency. When you are unsure, ask them or ask your accountant. The examples below show how the numbers work. They do not tell you what your own return should say.

Why the tax is already in the price

When a shop marks a price as tax included, the number on the tag is the total the customer pays. Nothing gets added at the register. Inside that total are two pieces: the price of the item itself, and the tax on it. Your end-of-day job is to pull those pieces apart.

The Texas Comptroller uses a simple example in its publication Sales Tax Holiday. The example store sold ten $50 shirts, for $500, and ten $150 suits, for $1,500 with tax included. The suits are the part that needs splitting. The shirts are tax-free in that example, so they need no adjustment.

Why does this matter? The register only records what the customer handed over. If you report the full $1,500 as your sales, you have counted the tax as your own money. That tax was collected for the state, even though it passed through your till. That is why the split has to happen every time you have tax-included sales.

The good news is that the split is predictable. Once you know the rate, every dollar of tax-included sales breaks into the same two parts.

Step 1: Turn the tax rate into a multiplier

Start with the tax rate that applies to the items you are splitting. Confirm it with your tax agency. Do not rely on a number you remember from last year, and do not assume that one rate covers every item in the store. For help setting up the register, review these sales tax rate inputs.

Next, turn the rate into a multiplier. Express the rate as a fraction of the pre-tax price, then add one. For an 8.25 percent rate, the result is 1.0825. The Comptroller's example works the same way. In the Sales Tax Holiday publication, the store advertises that "8.25 percent sales tax is included in the price of clothing over $100," so the multiplier for that example is 1.0825.

Write the multiplier on a sticky note near the register, and keep it where you can see it on the day you split totals. If your rate changes, write the new multiplier, date it, and stop using the old one for new sales.

Two mistakes to avoid in this step.

Do not divide by the rate itself. The rate is a percentage that you add on top of the pre-tax price, so it is used with one added, not by itself.

Do not multiply the tax-included total by the rate. The rate applies to the price before tax, not to a total that already includes the tax. Multiplying the total gives a tax figure that is too large for the sale, so the arithmetic has to run in the other direction. That is why step two divides instead.

Step 2: Divide the tax-included total by the multiplier

Now take the total of the sales rung up with tax included, and divide it by your multiplier. The result is what those sales would have totaled before tax. That number is your taxable sales figure for those transactions.

The Comptroller's publication spells out this calculation. It takes the total amount of sales in which tax was included, $1,500, and divides it by one plus the tax rate. The publication gives the result as $1,385.68. Check the division with a calculator yourself rather than trusting a number from memory.

A practical way to run this step is to group the day's tax-included sales by rate. If all of them use the same rate, add them up once and divide that single total. You do not need to divide each sale on its own. One division is faster, and it leaves you with one result to check.

Rounding needs a decision. Round to the nearest cent, and be aware that rounding each sale separately can give a slightly different total from rounding the group total once. Pick one method, write it on your worksheet, and use it every day so your records match from one day to the next. If you are unsure which method your tax agency expects, ask.

Only tax-included sales go through this step. Exclude tax-free and tax-added sales; divide different-rate sales separately:

Items that are tax-free, such as the shirts in the Texas example. Their dollar amount is not divided. It is added to your totals later.
Sales where tax was added at the register on top of the posted price. The posted price already excludes the tax, so there is nothing to back out.
Sales at a different rate from your main group. Keep those in their own group and run them through step one with their own multiplier.

In the Texas example, the pre-tax suit figure is combined with the tax-free shirts only after both are handled. The publication says the taxable suit amount must be included in total Texas sales and added to the $500 for the tax-free shirts, for a total of $1,885.68. The two kinds of sales are calculated separately first, and only then added together.

Step 3: Subtract to find the tax, then split the totals

The last step is subtraction. The tax is the tax-included total minus the pre-tax amount you just calculated. In the example, the difference between the $1,500 and the $1,385.68 is the tax of $114.32 included in the charge to the customer, as the Sales Tax Holiday publication explains.

Now put the day's totals together. For a day like the Texas example, you have three pieces:

Taxable sales before tax: $1,385.68
Tax-free sales: $500
Tax collected: $114.32

Add the three pieces together and they should match what the till recorded for those sales: the $1,500 from the suits plus the $500 from the shirts. This check is the most important part of the whole process. If the pieces do not add back to the till total, something is wrong, and you should find the error before you close out the register.

Your tax return will have its own lines, labels, and column names. Match each piece to the right line on the form. Do not assume the names used in this post match the ones printed on your form. The Comptroller's publication also shows that taxable and tax-free amounts are entered in different places on the return, which is one more reason to read your own form carefully.

Finally, record the tax separately from your sales. Many shops keep a running total of tax collected, because that money is owed to the state even though the sales themselves are income. Keeping the two apart also makes it easier to see whether your numbers look right over a week or a month.

When a day has more than one rate

Some shops sell items with different tax rates, so one day can include more than one group of tax-included sales. The three steps still apply, but you run them once for each group. Forcing two rates through one multiplier is the fastest way to end up with totals that will not add back.

Here is how to handle a mixed day:

Sort the day's tax-included sales into groups by rate. Use the register's reports if they can separate the groups. If they cannot, sort by hand and keep a count of each group.
For each group, write down its rate and its multiplier.
Divide each group's tax-included total by its own multiplier. This gives that group's taxable sales.
Subtract each group's pre-tax result from its tax-included total. This gives that group's tax.
Add the pre-tax results from every group together, and add the tax results together.
Check the combined pieces against the full till total, with tax-free sales as their own piece.

Use one worksheet line for each rate, and label each line clearly. The labels matter most when someone else closes the till. If a staff member on the next shift cannot tell which sales belong to which group, the totals will not match the next morning.

Sorting is where mistakes usually start. If you are not sure which rate applies to an item, do not guess. Look up the rate with your tax agency, write down the answer, and keep a short list of which items fall into which group, so every shift sorts the same way.

Check your work before you close the till

Three quick checks help you review the day's calculations.

First, check that the pieces add back. Taxable sales before tax, plus tax collected, plus tax-free sales should equal the total the till recorded for those sales. If they are off by more than a few cents, go back through the steps.

Second, check that the tax matches the rate. Divide the tax by the pre-tax amount. In the Texas example, $114.32 divided by $1,385.68 comes out to about 8.25 percent. If your result is far from your rate, the division or subtraction went wrong.

Third, check that you used the same method as yesterday. If you rounded each sale last week and rounded the group total this week, your totals will drift in ways that are hard to explain later. Follow the rounding method your tax agency expects.

Keep a simple worksheet for each day. Write down the rate you used, the tax-included total you divided, the pre-tax result, the tax, and the tax-free total. Keep it with the day's till report. Ask your tax agency how long to keep these records, and follow its advice. For the wider close, use this guide to recording cash totals before closing.

Common mistakes to avoid

Most errors in this process come from a small set of habits.

Multiplying instead of dividing. If your tax seems too high compared with your sales, check whether you multiplied the tax-included total by the rate.

Trusting a rate from memory. Rates can change. Check the rate with your tax agency before you set up your multiplier, and check again when you hear about a change.

Mixing rates in one total. A single multiplier fits only one rate. Keep each group separate, calculate each with its own multiplier, and add the results at the end.

Mixing tax-included and tax-added sales. These look similar on the till but work differently. Check how your register records each type, and keep them in separate columns so you do not divide a sale that did not need it.

Forgetting the tax-free items. Your pieces should always add back to the full till total. That check reveals a missing tax-free amount right away.

Ignoring a small difference. Rounding can leave a small gap. If it exceeds a few cents, go back through the steps. Write down what caused it, and ask your accountant how to handle any unresolved difference. Then handle it the same way every time.

Skipping the check. It is tempting to close the register and move on, especially on a busy day. The checks take only a few minutes, and they are the difference between a clean record and a confusing one.

Illustrative example: Split a tax-included total

For an illustrative tax-included total of $110 at an illustrative 10 percent rate, divide $110 by one plus 10 percent to get $100 before tax. Subtract $100 from $110 to get $10 in tax. Check the split: $100 plus $10 equals $110. These figures illustrate the arithmetic, not the rate for your shop.

Try the steps with your own numbers

The best way to learn this process is to run it once with real figures. Pick one day from last month, total your tax-included sales, and work through the three steps using your own tax rate. Confirm that rate with your tax agency first. Write each result on paper as you go, so you can see how the numbers connect.

Then compare your answer with what your records already show. If the pieces add back to the till total and the tax matches your rate, you have the process right. If not, find the step where the numbers stopped matching and check that step alone. Most errors are easy to find once you know where to look.

After two or three rounds, the process becomes routine. You will know which sales need splitting, your multiplier will be ready, and the checks will fit into your end-of-day routine.

Common questions

What does the division result represent?

The result is the pre-tax sales amount for the tax-included transactions in that rate group.

Where does the tax-free amount go?

Keep it separate during the division, then include it when checking the full till total.

What should you do with an unexplained difference?

Check the grouping, division, subtraction, and rounding method before asking your accountant about any unresolved gap.