| 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 |
| 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) | |||
![Rao Ratan Singh[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
