cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
3110
Level 1

What is the best way to record home office rental/mortgage and few business expenses charged on my personal account? For sole proprietorship. Thanks

 
19 Comments 19
Rochelley
Level 8

What is the best way to record home office rental/mortgage and few business expenses charged on my personal account? For sole proprietorship. Thanks

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!

 

 

CQE
Level 2

What is the best way to record home office rental/mortgage and few business expenses charged on my personal account? For sole proprietorship. Thanks

I too have this question - this is very helpful. Would I be able to access the spreadsheet you suggest? Thank you

AmourEd
Level 1

What is the best way to record home office rental/mortgage and few business expenses charged on my personal account? For sole proprietorship. Thanks

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

EV68
Level 1

What is the best way to record home office rental/mortgage and few business expenses charged on my personal account? For sole proprietorship. Thanks

Hello Rochelly, would you mind sharing your spreadsheet with me too?

Thanks

 

Rochelley
Level 8

What is the best way to record home office rental/mortgage and few business expenses charged on my personal account? For sole proprietorship. 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

Rochelley
Level 8

What is the best way to record home office rental/mortgage and few business expenses charged on my personal account? For sole proprietorship. Thanks

Hello @EV68 ,

 

Please PM me your email address and I will be happy to send you what I use.

 

Regards,

Rochelley

EV68
Level 1

What is the best way to record home office rental/mortgage and few business expenses charged on my personal account? For sole proprietorship. Thanks

Thanks Rochelly - my email is:

[email address removed]

JamesM
QuickBooks Team

What is the best way to record home office rental/mortgage and few business expenses charged on my personal account? For sole proprietorship. Thanks

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. 

guardian123
Level 1

What is the best way to record home office rental/mortgage and few business expenses charged on my personal account? For sole proprietorship. Thanks

hi,

 

Can you please send your spreadsheet?

[email address removed]

CQE
Level 2

What is the best way to record home office rental/mortgage and few business expenses charged on my personal account? For sole proprietorship. Thanks

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. 

Rochelley
Level 8

What is the best way to record home office rental/mortgage and few business expenses charged on my personal account? For sole proprietorship. Thanks

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.

Skylinetreebc
Level 1

What is the best way to record home office rental/mortgage and few business expenses charged on my personal account? For sole proprietorship. Thanks

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?

Skylinetreebc
Level 1

What is the best way to record home office rental/mortgage and few business expenses charged on my personal account? For sole proprietorship. Thanks

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 

KenWheeler
Level 1

What is the best way to record home office rental/mortgage and few business expenses charged on my personal account? For sole proprietorship. Thanks

Hi,

 

I was wondering if you can send me the spreadsheet you use.  I would be grateful!

CQE
Level 2

What is the best way to record home office rental/mortgage and few business expenses charged on my personal account? For sole proprietorship. Thanks

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. 

robb-brandy
Level 1

What is the best way to record home office rental/mortgage and few business expenses charged on my personal account? For sole proprietorship. Thanks

Hi, I found your post very helpful, would you be able to share your spreadsheet with me?

Thank you,

CQE
Level 2

What is the best way to record home office rental/mortgage and few business expenses charged on my personal account? For sole proprietorship. Thanks

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

SandyDale
Level 1

What is the best way to record home office rental/mortgage and few business expenses charged on my personal account? For sole proprietorship. Thanks

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.

 

CQE
Level 2

What is the best way to record home office rental/mortgage and few business expenses charged on my personal account? For sole proprietorship. Thanks

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. 

Need to get in touch?

Contact us