When you set up sales taxes, you select the appropriate tax calculation for the agency.
A number of state tax agencies have sales tax regulations requiring the use of a formula. Following is a list of such requirements, as well as the formulas needed to meet each requirement and the states that impose the requirement.
Maximum Dollar Sales Amount:States requiring the use of this tax calculation method include Arkansas, Florida, and Tennessee. The standard tax rate is applied to the sales amount, the amount being subject to a specific maximum dollar limit over which the rate applied is zero or a lower rate. For example, say the state sales tax is 1 percent of sales amounts up to a limit of $2,500. Any portion of the sales amount over $2,500 is not taxed.
To meet the tax requirement, do the following:
Minimum Dollar Sales Amount:Louisiana requires the use of this tax calculation method. The standard tax rate is applied only to sales amounts above a specific dollar limit. For example, say the state sales tax is 1 percent. The first $500 of the sales amount is exempt from tax.
To meet the tax requirement, you would do the following:
Maximum Dollar Tax Amount:States requiring the use of this tax calculation method include North Carolina, North Dakota, South Carolina, Tennessee, and Vermont. The standard tax rate is applied to the sales amount, the amount being subject to a specific maximum dollar limit. For example, say the state sales tax is 1 percent. This rate is applied to a sale only until the maximum tax amount of $25 is met.
To meet the tax requirement, you would do the following:
Maximum Percent Sales Amount:States requiring the use of this tax calculation method include Maryland, Minnesota, and South Carolina. The standard tax rate is applied to a specific maximum percentage (less than 100 percent) of the sales amount. An example of this type of calculation is a state sales tax of 1 percent applied to the first 65 percent of the sales amount.
To meet the tax requirement, you would do the following:
Whether you choose to base your sales tax formula on each taxable line item of a sale or the total sale amount, the tax calculation will be applied to the total invoice amount. However, the calculation will be performed differently and result in differing tax amounts.
Say you choose $5,000 as the dollar limit taxable at the first tax rate of 5 percent. You choose to tax any portion of the sales amount over and above this limit at the rate of 1 percent. The following tables show how the sales tax would be calculated if based on total taxable sales or on each taxable line item.
Total Taxable Sales
Invoice Line Item |
Amount |
Tax at 5% |
Tax at 1% |
|||
---|---|---|---|---|---|---|
1 |
$7,000 |
|||||
2 |
$3,000 |
|||||
3 |
$5,000 |
|||||
Total Invoice Amount |
$15,000 |
$5,000 |
$10,000 |
|||
Total Tax Amount |
$250 |
+ |
$100 |
= |
$350 |
Each Taxable Line Item
Invoice Line Item |
Amount |
Tax at 5% |
Tax at 1% |
|||
---|---|---|---|---|---|---|
1 |
$7,000 |
$5,000 |
$2,000 |
|||
2 |
$3,000 |
$3,000 |
$0 |
|||
3 |
$5,000 |
$5,000 |
$0 |
|||
Total Invoice Amount |
$15,000 |
$13,000 |
$2,000 |
|||
Total Tax Amount |
$650 |
+ |
$20 |
= |
$670 |
These differences would be reflected in the Taxable/Exempt Sales report for this sale transaction.