Tax Invoice

[Rao Ratan Singh]

Hi All,
I am preparing a Tax Invoice for our Hotel. But problem is
some items are Tax free and some are Taxable. How i can detect
exempted and taxable item from List.

my invoice Format is like

S.No. Item Name Qty Rate Total
01 Food & Beverage 2 500.00 1000.00
02 Alchoholic Bvrg 2 300.00 600.00
03 Room Charges 1 5000 5000.00


SubTotal

Vat

Total


VAT should be calculate only items which are taxable.

Room Charges - Exempte
Food & Bvrg - 14% Taxable
Alcholic Bvrg - 20% Taxable

Help from anyone will be appreciated

Regards
RRS

 

[muddan madhu]

Col A - Sl.No.
Col B - Item Name
Col C - Qty
Col D - Rate
Col E - Total
Col F - Helping Column ( New column for calculation )
Cell D5 - Subtotal
Cell D6 - VAT
Cell D7 - Total

in Cell F2 put this formula and drag it down
=INDEX({0,0.14,0.2},MATCH(B2,{"Room Charges";"Food & bev";"alcoholic"},
0))

in Cell F6 put this formula
=SUMIF(F2:F4,"<>"&0,E2:E4)*SUM(F2:F4)