Sole Proprietor Income & Expenses

by Peggy

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.

Share this page:
Enjoy this page? Please pay it forward. Here's how...

Would you prefer to share this page with others by linking to it?

  1. Click on the HTML link code below.
  2. Copy and paste it, adding a note of your own, into your blog, a Web page, forums, a blog comment, your Facebook account, or anywhere that someone would find this page valuable.

Enjoy A Tea Break With
Me Today. Let's Chat!

Use the search feature to quickly find the
information you're looking for.

Your Learning Curve!


Warm up your tea cup and check out these chats ...

Click on image above to read the chat.

Join Me On Facebook

Help support this site by "liking" me! Here's where I post current information.

Listed Under Websites NOT Local Business.
This website is NOT associated with the business operating in Bonnyville AB.

A Handy Reference