customising the Excel invoice
 

I work as a Handy Man going to client sites and doing work for them on items
like install A/C units and toilets and other things they need done.

The problem I am having is with Taxation in Canada. The services I perform
are not taxable by Ontario Sales Tax, but are GST taxable. But any product I
need from the Retailer I work from are.

Is there a way to set up the invoice so It will allow another colum between
"Discription" and "Unit Price" to allow for a varible taxable status. IE
code 0 means Item is not taxable, code 1 means items is only GST, code 2
means item is only PST taxable and code 4 means item is both PST & GST
taxable. At this point I am having to enter the number manually after using
Calc to work out the amounts.

Suppose you enter your GST into a cell and hit Insert-Name-Define and call
it GST. Same with PST, etc.
Then suppose your tax code is in a cell you named taxcode and your invoice
total is in a cell you named total.
=if(taxcode=0,total,if(taxcode=1,total*GST,if(taxc ode=2,total*PST,if(taxcode
=3,total*(PST+GST),0))))
Something like that...
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"George James Handyman and Computer Geek" <George James Handyman and
Computer wrote in message
...
I work as a Handy Man going to client sites and doing work for them on
items
like install A/C units and toilets and other things they need done.

The problem I am having is with Taxation in Canada. The services I
perform
are not taxable by Ontario Sales Tax, but are GST taxable. But any
product I
need from the Retailer I work from are.

Is there a way to set up the invoice so It will allow another colum
between
"Discription" and "Unit Price" to allow for a varible taxable status. IE
code 0 means Item is not taxable, code 1 means items is only GST, code 2
means item is only PST taxable and code 4 means item is both PST & GST
taxable. At this point I am having to enter the number manually after
using
Calc to work out the amounts.