Sole Proprietor Income & Expenses

by Peggy
(Alberta)

Creating a Synoptic Journal in an Excel worksheet

Creating a Synoptic Journal in an Excel worksheet

My client earned income as a sole proprietor for part of 2013 and also worked as an employee during 2013 so he will also have T4s.


I have been asked to prepare a spreadsheet of income and expenses. Do I need to separate the expenses being claimed while he worked as a sole proprietor from the expenses being claimed while he was an employee?

Does anyone have a sample Excel spreadsheet for this situation?



section divider




Hi Peggy,

Yes you have to separate the two sets of expenses.

Sole proprietor income and expenses go on form T2125 - Statement of Business or Professional Activities while employment expenses go on form T777 - Statement of Employment Expenses. Form T2200 - Declaration of Conditions of Employment needs to be completed by the employer before employment expenses can be claimed.

To setup your Excel worksheet, pull the T2125 and T777 forms off the CRA website, and categorize your information according the expenses that can be claimed. If there are any expenses that are not tax deductible, have a column to report those in.

What you are preparing is called a "Synoptic Journal". I chat about synoptic journals here.

I also discuss how to get your free copy of an accounting forms package developed using Excel ... you might find interesting and perhaps useful.

Hope this helps get you started.

Comments for Sole Proprietor Income & Expenses

Click here to add your own comments

Mar 08, 2017
Working from home for work
by: Adam from Ottawa

I received a T2200 from my employer saying I do up to 10% of work from home. Wondering where on my taxes I put the expenses for internet or other things I can claim?

Mar 08, 2017
T2200 Declaration of Conditions of Employment
by: Lake

Adam, your T2200 allows you to claim your employment expenses on Schedule T777 of your T1 tax forms.

Click here to add your own comments

Return to Self-Employed Bookkeepers.

 
 

Back to top