Thread: Tax Invoice
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Rao Ratan Singh[_2_] Rao Ratan Singh[_2_] is offline
external usenet poster
 
Posts: 1
Default Tax Invoice

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