Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Hello @3110 ,
The recording of home office expenses claimed by a sole proprietor are strictly a tax activity, rather than an accounting activity, because you can only write off a percentage of all the allowable expenses. However, being a sole proprietor myself, I understand why you would want to make your accounting records actually match the T2125 (Statement of Business Activities) on your personal tax return.
I keep an annual spreadsheet where I calculate the total expenses for each different category, i.e. Utilities, Home Insurance, Security costs, Mortgage Interest, etc. I then calculate what percentage of these things I can claim on the T2125. This can be done one of two ways: 1. Divide the sq. ft. of your "home office" by the total sq. ft. of your home or 2. Divide the room you use for you "home office" (1) by the total number of rooms in your house. Use the calculation that gives you the greater percentage, but make sure it is reasonably accurate as it can become an audit issue.
Enter all of this into the T2125 of your income tax return. Whatever the allowable amounts are that you can claim, is what you would enter into your QBO file. The bottom line of your P & L for that tax year should then match the bottom line of the T2125 form you are filing for tax. I have created an Expense Account called 'Home Office Expenses'. The YE entry into QBO would look like this:
CR Owner's Capital (equity account type) (it is presumed that all of things you are claiming for Home
office were pd for personally)
DR Home Office Expenses
If you send me a private message, I would be willing to share my spreadsheet with you which you can then edit for your own use, if you think it would be helpful.
Good luck!
I too have this question - this is very helpful. Would I be able to access the spreadsheet you suggest? Thank you
Hello,
Thank you for your reply to another user regarding recording home office expenses. I am brand new to filing as self-employed.
Any other tips you could share would be greatly appreciated. e.g. how much of utilities, phone, internet can I claim?
Would you mind sharing your spreadsheet with me?
Thank you!
Sheri St. Amour
Amour Education
Hello Rochelly, would you mind sharing your spreadsheet with me too?
Thanks
Hello @AmourEd ,
I'm not sure if I ever sent this to you or not. If so, I apologize. Please PM me your email address and I will send it out. If I did it back in May, then no worries.
Regards,
Rochelley
Hello @EV68 ,
Please PM me your email address and I will be happy to send you what I use.
Regards,
Rochelley
Thanks Rochelly - my email is:
[email address removed]
Hi EV68. Thanks for taking the time to post in our Community. For your privacy, the email address you attached was removed. This keeps your email private and secure. I recommend sending @Rochelley your email address via private messaging here in the Community. Let me know if you have questions, I've got your back.
hi,
Can you please send your spreadsheet?
[email address removed]
Here is where I found a free small-business-bookkeeping-guide from Avalon. There is lots of great information for free on their site. https://www.avalonaccounting.ca/blog/small-business-bookkeeping-guide
Hope this helps.
Hello @guardian123 ,
I would be happy to share the spreadsheet. Please send me a PM as email addresses cannot be published in the public forum.
I would also like to see the spreadsheet. I’m sure how to pm here? Can you pm me and then I can give you my email?
Question: would I call the “supplier” for an expense Home Business Expenses? Or is there a different place I’m meant to enter this?
thank you
Hi,
I was wondering if you can send me the spreadsheet you use. I would be grateful!
Here is where I found a free small-business-bookkeeping-guide from Avalon. There is lots of great information for free on their site. https://www.avalonaccounting.ca/blog/small-business-bookkeeping-guide
Hope this helps.
Hi, I found your post very helpful, would you be able to share your spreadsheet with me?
Thank you,
I got the file from Avalon.... Avalonaccounting.ca. Search “free bookkeeping template”
There is lots of free information that comes with it.
Hope this helps
Although this post dates back some time, I'd also be interested in obtaining the spreadsheet for home office expenses. Is there still a way to obtain this? I don't know how to PM Rachel.
This is from my post on this over a year ago.
Here is where I found a free small-business-bookkeeping-guide from Avalon. There is lots of great information for free on their site. https://www.avalonaccounting.ca/blog/small-business-bookkeeping-guide
Hope this helps.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here