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.

Click here to post comments

Join in and write your own page! It's easy to do. How? Simply click here to return to Self-Employed Bookkeepers.

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

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

Like this page? Please let Google
know by clicking the +1 button.

 Keep Your  eDocuments Safe And Secure… $7 USD

Your Learning Curve!

Buy Now

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

Click on image above to read the chat.

Purchasing These Products Through My Links Helps To Support This Site

Click on image above for my review.

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

Buy Now