Salesforce and other SMB Solutions are coming soon. ×

# Two Tier Sales Tax

## Recommended Posts

I am using the Business Tracker. I have two levels of sales tax to calculate. The first is the General Sales Tax .0875. The other is a sales tax on clothing. The sales tax is .04 for the first \$110 and total clothes purchases over \$110 go to the general sales tax of

.0875. I have a combination of sales, some clothing and some general merchandise. How can I caluculate the clothing to say that if purchase is \$110 are .0875 and all other sales are taxed at.0875?

Thanks

##### Share on other sites

I am using the Business Tracker. I have two levels of sales tax to calculate. The first is the General Sales Tax .0875. The other is a sales tax on clothing. The sales tax is .04 for the first \$110 and total clothes purchases over \$110 go to the general sales tax of

.0875. I have a combination of sales, some clothing and some general merchandise. How can I caluculate the clothing to say that if purchase is \$110 are .0875 and all other sales are taxed at.0875?

Thanks

If ( clothing and

##### Share on other sites

If ( clothing and

Jack,

I tried that. It sums all of the tax in the portal. Here is a sample transaction.

Item Qty Price Tax Rate Ext Price

Clothing 1 \$60.00 4% \$60.00

Gen Merch 1 \$40.00 8.75% \$40.00

Sales Tax Clothing \$2.40

Sales Tax Gen Merch \$3.50

Note: If the total clothing amount was more that \$110, the total purchase would be taxed at 8.75%. But since the clothing amount is less than \$110, there is actually 2 sales tax calculations needed. I cannot get them to calculate separate in the portal. Does this help illustrate the set up?

##### Share on other sites

OK, for each item record add two fields, IsClothing and NotClothing (whatever...)

Portal Record:

Item

Price

Qty

Extended price

Calc Field XPrice (Is Clothing)

Calc Field XPrice(Is Not Clothing)

INVOICE Fields

Sum clothing

Sum Not Clothing

Now do your calc for tax

##### Share on other sites

OK, for each item record add two fields, IsClothing and NotClothing (whatever...)

Portal Record:

Item

Price

Qty

Extended price

Calc Field XPrice (Is Clothing)

Calc Field XPrice(Is Not Clothing)

INVOICE Fields

Sum clothing

Sum Not Clothing

Now do your calc for tax

Jack - I have attached a word document to illustrate. I tried what you gave me, but each portal was not totalling all of the "Clothing" items together. Perhaps the attachement will give more insight!

##### Share on other sites

OK, here's a quick demo that works. However, if you change the amount for an item the calcs are slow to update and need a commit. If you add items they work ok.

I didn't pretty it up, round numbers, etc.

##### Share on other sites

OK, here's a quick demo that works. However, if you change the amount for an item the calcs are slow to update and need a commit. If you add items they work ok.

I didn't pretty it up, round numbers, etc.

Jack

That works Great! Thanks for all your help!

Lou

• ### Images

• By Soliant Consulting,
• By Soliant Consulting,
• By Soliant Consulting,
• ### Forum Statistics

• Total Topics
33.7k
• Total Posts
141.6k
×
×
• Create New...