I am trying the fix a report that I need for tax returns with individual breakdown of sales under each tax type.
[Total Sales:1, 1, 1, 1]
>Type|Subtotal|Tax|Total
23%|{REPORT TICKET DETAILS:=[TXT.23% Vat.sum]/123*100,=[TXT.23% Vat.sum]/123*23,TXT.23% Vat.sum,:}
13.5%|{REPORT TICKET DETAILS:=[TXT.13.5% Vat.sum]/1135*1000,=[TXT.13.5% Vat.sum]/1135*135,TXT.13.5% Vat.sum,:}
>TOTAL|{REPORT TICKET DETAILS:=[TXT.23% Vat.sum]/123*100+[TXT.13.5% Vat.sum]/1135*1000,T.Tax.sum,=[TXT.23% Vat.sum]+[TXT.13.5% Vat.sum]:}
Gift Certs|{REPORT TICKET DETAILS:TA.GC Purchase Transaction.sum,TA.dummy.sum,TA.GC Purchase Transaction.sum:}
>TOTAL|{REPORT TICKET DETAILS:=[T.TotalAmount.sum]-[T.Tax.sum],T.Tax.sum,T.TotalAmount.sum:}
I originally used this report but there is always a slight discrepancy as i was using calculations to get the subtotal and tax totals. See actual subtotal at bottom 259.20 and calculated total is 259.18 a 2c discrepancy. Also if you add the Tax totals for both types there is also the 2c discrepancy 16.17+25.50 = 41.67 not the correct total of 41.65
Then as there was only 2 tax types I just used calculations for one 23% Vat
and then subtracted that from the total to get the 13.5%.
[Total Sales:1, 1, 1, 1]
>Type|Subtotal|Tax|Total
23%|{REPORT TICKET DETAILS:=[TXT.23% Vat.sum]/123*100,=[TXT.23% Vat.sum]/123*23,TXT.23% Vat.sum,:}
13.5%|{REPORT TICKET DETAILS:=[TXT.23% Vat.sum]+[TXT.13.5% Vat.sum]-[T.Tax.sum]-[TXT.23% Vat.sum]/123*100,=[T.Tax.sum]-[TXT.23% Vat.sum]/123*23,TXT.13.5% Vat.sum:}
>TOTAL|{REPORT TICKET DETAILS:=[TXT.23% Vat.sum]+[TXT.13.5% Vat.sum]-[T.Tax.sum],T.Tax.sum,=[TXT.23% Vat.sum]+[TXT.13.5% Vat.sum]:}
Gift Certs|{REPORT TICKET DETAILS:TA.GC Purchase Transaction.sum,TA.dummy.sum,TA.GC Purchase Transaction.sum:}
>TOTAL|{REPORT TICKET DETAILS:=[T.TotalAmount.sum]-[T.Tax.sum],T.Tax.sum,T.TotalAmount.sum:}
This is not correct but visually everything adds up even though technically the tax total wont always necessarily be exactly 23% or 13.5% of their respective totals.
The main problem I have now is I also need to add 9% VAT to this so I’m back to using calculations again.
I can get each tax type total using TXT.23% Vat.sum
Is it possible to add a new tag for just the actual tax total or even subtotal ex.tax?
Either of these can then be used to correctly calculate the other.