March 10, 2010 
Home Personal Taxes Corporate Taxes Residential & Commercial Property Tax Appeals 2008 Tax Returns Bulletins & Newsletters
Welcome to Taxperts  
Spreadsheets
 

The following spreadsheets have been created to make bookkeeping more manageable. Due to the change in GST from 7% to 6%, there is a new spreadsheet available for use to track expenses for 2006. The 2006 spreadsheet consists of separate tabs for each half of the year. If you have any questions, feel free to contact us.


Click here for downloading instructions

Click here for printing instructions



A. Real Estate

Click here for Discussion on Real Estate Expense Headings

  1. Spreadsheet for 2009 (5% GST)
  2. Spreadsheet for 2008 (5% GST)
  3. Spreadsheet for 2007 (6% GST)
  4. Consolidated spreadsheet for 2 six-month periods for 2006 on 7% GST basis to June 30, 2006; 6% GST after July 1, 2006.
    • Enter expenses in first worksheet for Jan 1 to June 30 with 7% GST
    • Enter expenses in second worksheet for July 1 to Dec 31 with 6% GST
    • Our spreadsheet does an automatic annual total
  5. Spreadsheet for 2005 or earlier tax years (7% GST)

B. Fees For Service Business

  1. Spreadsheet for 2009 (5% GST)
  2. Spreadsheet for 2008 (5% GST)
  3. Spreadsheet for 2007 (6% GST)
  4. Consolidated spreadsheet for 2 six-month periods for 2006 on 7% GST basis to June 30, 2006; 6% GST after July 1, 2006.
    • Enter expenses in first worksheet for Jan 1 to June 30 with 7% GST
    • Enter expenses in second worksheet for July 1 to Dec 31 with 6% GST
    • Our spreadsheet does an automatic annual total

  5. Spreadsheet for 2005 or earlier tax years (7% GST)
C. Performers/Models
  1. Spreadsheet for 2009 (5% GST)
  2. Spreadsheet for 2008 (5% GST)
  3. Spreadsheet for 2007 (6% GST)
  4. Consolidated spreadsheet for 2 six-month periods for 2006 on 7% GST basis to June 30, 2006; 6% GST after July 1, 2006.
    • Enter expenses in first worksheet for Jan 1 to June 30 with 7% GST
    • Enter expenses in second worksheet for July 1 to Dec 31 with 6% GST
    • Our spreadsheet does an automatic annual total

  5. Spreadsheet for 2005 or earlier tax years (7% GST)



Downloading Instructions:

Use the following procedure to download formatted excel templates: decide which spreadsheet applies to your situation; look below for appropriate "Spreadsheet 'x' " text; right click on this text; left click on "save target as"; name the file, select the location where you wish to save the file, and finally, left click on the "save" box.

 

Printing Instructions:

To get the best use of the spreadsheets below you must get them to print 8½" long by 11" wide. If you are printing directly from your browser you can accomplish this by making sure that you set it to print "Landscape". To do so in Internet Explorer, go to "File", then "Page Setup" and choose "Landscape" in the box for page orientation. If you have downloaded the file and are printing from Excel, choose "File", then "Page Setup" and then "Landscape". Once you have completed the page setup, do the following to complete your print job: right click on the appropriate "Spreadsheet 'x' ", then left click on "print target". 

 
 
Information on this website is not to be relied upon, as laws and regulations are constantly changed.  TAXPERTS PROPERTY SERVICES LTD. assumes no responsibility for the accuracy of this site's contents. E. & O.A.