Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Tax Invoice
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) On Nov 29, 3:22*pm, Rao Ratan Singh <Rao Ratan wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
invoice toolbar for invoice calcuation and assign number | Excel Discussion (Misc queries) | |||
How do I assign an invoice number using the invoice toolbar? | Excel Worksheet Functions | |||
missing invoice toolbar when save customised invoice | New Users to Excel | |||
Invoice templet Excel97 to 2003 invoice toolbar missing | Excel Discussion (Misc queries) | |||
How do I change the invoice number assigned in Invoice template... | Excel Discussion (Misc queries) |