How to calculate sales tax in excel

Written by christy flora
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How to calculate sales tax in excel
Setting up sales tax in Excel (tax defined image by Christopher Walker from Fotolia.com)

Sales taxes are taxes added to the purchase of goods and services. In the United States, each individual state can determine the tax rate to be charged for goods and services. Sales taxes can differ depending on locality within a state, such as Wisconsin, which includes an additional county tax. Taxes can also depend on the type of good or service, such as Tennessee, which charges more tax on non-grocery items than on grocery items. With all of the variations on taxes, it is convenient to set up a spreadsheet in Excel to automatically calculate tax due on purchases.

Skill level:
Easy

Other People Are Reading

Instructions

  1. 1

    Locate sales tax information for your state and locale for the specific good or service that you provide. Each state has its sales tax information available online. The web address varies by state, but a simple search for "sales tax" and your state's name will locate the most current tax rates.

  2. 2

    Open the Excel program on your computer. Starting with Column A, row 1, label column headings: Item, Subtotal, Sales Tax, Sales Tax Calculation and Total.

  3. 3

    Set the formatting for the Subtotal, Sales Tax Calculation and Total columns to accounting. Select the entire column, by clicking on the column heading (B, D and E, individually). Right-click on the column heading. Select "Format Cells" from the drop-down menu. In the pop-up window, select the "Number" tab. In the "Category" listing, select "Currency." Select "OK." Set the formatting for the Sales Tax column to percentage. Select the entire column, by clicking on the column heading (C). Right-click on the column heading. Select "Format Cells" from the drop-down menu. In the pop-up window, select the "Number" tab. In the "Category" listing, select "Percentage." Select "OK."

  4. 4

    On the second row of the spreadsheet in the Item column, enter a description of the good or service purchased. In the Subtotal column, you will enter the cost of the goods or services that have been purchased. In the Sales Tax column enter the sales tax rate that you researched in step 1. In the Sales Tax Calculation column enter the following formula: =B2*C2. In the Total column enter the following formula: =B2+D2.

  5. 5

    If you are adding the calculation of sales tax to an existing Excel based invoice, ensure that the Sales Tax Calculation formula references the subtotal, or retail price, of the goods or services purchased and the sales tax rate. The Total formula should reference the subtotal, or retail price, of the goods or services purchased and the Sales Tax Calculation.

Tips and warnings

  • Sales tax rates may change over time and rates should be verified on an annual basis.

Don't Miss

Filter:
  • All types
  • Articles
  • Slideshows
  • Videos
Sort:
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the eHow.co.uk site, you consent to the use of cookies. For more information, please see our Cookie policy.