customising the Excel invoice

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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(taxcode=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 (e-mail address removed)> wrote in message
news:[email protected]...
 
Back
Top