Where I live I have a state sales tax of 6.875% (yes .875). I also have a local sales tax of .50% for a total of 7.375%. Nearly all our sales include Sales Tax (7.375%) in the price, only a few sales do we add Sales Tax to the order.
I’m trying to create a report that will figure the pre-sales tax amounts, on the totals, that I can use to enter in our accounting software. I’ve notice that SambaPOS won’t calculate division on non-whole numbers.
[Sales Tax Defaut Numbers:4, 2, 2, 2, 1, 1]
>>Item|Qty|Ttl $|Tax|Calc
{REPORT ORDER DETAILS:O.MenuItemName,O.Quantity.Sum,O.ExactTotal.Sum.desc,O.Tax.Sum,=[O.ExactTotal.Sum]-[O.Tax.Sum]:(MG=Admissions)}
[Sales Divided by 2:4, 2, 2, 2, 1, 1]
>>Item|Qty|Ttl $|Tax|Calc
{REPORT ORDER DETAILS:O.MenuItemName,O.Quantity.Sum,O.ExactTotal.Sum.desc,O.Tax.Sum,=[T.TotalAmount.Sum]/2:(MG=Admissions)}
[Sales Divided by 2.9:4, 2, 2, 2, 1, 1]
>>Item|Qty|Ttl $|Tax|Calc
{REPORT ORDER DETAILS:O.MenuItemName,O.Quantity.Sum,O.ExactTotal.Sum.desc,O.Tax.Sum,=[T.TotalAmount.Sum]/2.9:(MG=Admissions)}
[Sale Tax Divided by 1.07375:4, 2, 2, 2, 1, 1]
>>Item|Qty|Ttl $|Tax|Calc
{REPORT ORDER DETAILS:O.MenuItemName,O.Quantity.Sum,O.ExactTotal.Sum.desc,O.Tax.Sum,=[T.TotalAmount.Sum]/1.07375:(MG=Admissions)}
As you can see in this sample report, if I divide by 2, it displays the correct amount. If I divide by 2.9 it displays the results as if it was 2.
My desired results is to get the Total and divide by 1.07375 (to get price before Sales Tax). I’m not sure if I have the syntax wrong, that maybe the issue???
I know part of the problem is SambaPOS Sales tax only allows for 2 decimal places. I’ve done a forum search to allow 3 decimal places in the Sales Tax. But everything I try, reverts back to 2 decimal places in the Tax Template. Even if I could get the decimal places to 3 places, rounding the Sales Tax in each individual sale by be off by .01. Multiply that how many are sold, it may through throw my numbers off. Getting the Pre-Sales Tax Total Amount, in Reports and then letting the accounting software figure out the sales tax portion would be, what I think, would be the easiest for me.
Unless, someone smarter has a better idea.