LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
George James Handyman and Computer Geek
 
Posts: n/a
Default 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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 2 May 13th 23 11:46 AM
VBA for Excel 2000 file is corrupt nkamp Excel Discussion (Misc queries) 0 May 26th 05 03:37 PM
Invoice Templates in Excel Sue@Yes Excel Discussion (Misc queries) 7 April 5th 05 05:12 PM
Excel merge or data form (for invoice)..help!! LeeAnne Excel Worksheet Functions 1 February 1st 05 02:21 AM
Difference in number of Excel NewsGroups Hari Prasadh Excel Discussion (Misc queries) 1 January 25th 05 11:32 AM


All times are GMT +1. The time now is 10:57 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"