How do I import Home Depot purchase receipts in QuickBooks?
I do remolding and help real estate investors buy almost every other day at Home Depot. Then we go back to the office and hire someone part time to enter each receipt with the client's property name. He makes so many mistakes and I have to spend time checking the work. Anyway, then we bill them for the material. I was looking into getting QuickBooks online. So I am looking for something that can bring or import receipts.
Expert Answers
Sort by Date
Sort by Votes
Mar 23, 2020
Use Home Depot Pro Xtra and its perks
- Register for a free Home Depot Pro Xtra membership. Does not matter how you make a payment
- Link all your payment methods to the account
- Link your phone number too!
- Anytime you make a purchase use the card or give them your phone number if you pay in cash
- There are so many other perks
- Now see the magic ...
Taking care of the receipts: Doing so - Home Depot will keep the receipts for 24 months and email them to you. No need to scan, snap or upload to a document management software.
Entering into QuickBooks: So your question is how to enter and note the terms. Well if you paid by cash use a petty cash bank account to enter as check; paid by debit use the bank account enter as check; paid by credit card enter a credit card charge. It is very simple.
Statements: As a Home Depot Pro member you can download the statements. Watch the video below to understand the difference between two statements.
Hope this helps you.
Regards,
Akshay
QuickBooks Cloud Hosting Solutions Consultant
Sep 17, 2018
Hello Marie,
I had a similar problem until I started using HammerZen for my QuickBooks online (desktop version is also available). My receipts would pile up, and we had to hand key them into QuickBooks resulting in multiple errors and just too much time spent on manual work. Now I can batch import all my receipts (statements from my Home Depot Pro account) into QuickBooks in only 2-3 minutes eliminating mistakes; you can also mark your items billable and do the mapping. Highly recommend.
You can see all the information here: https://hammerzen.com/
Feb 28, 2018
I would suggest using Hubdoc. They are reasonably priced and you can set it up to automatically sync with QuickBooks Online. They also have a great phone app to make it easy to upload receipts from anywhere.
You can find more information at www.hubdoc.com
Lauretta Taylor
TALL Orders Canadian Bookkeeping Services
Feb 28, 2018
Using Expensify you can export your credit cards or/and bank account receipts to QBO, already categorized by project and GL account with the receipts scanned and attached into your accounting software. Contact us for further assistance (info@cpasoutsource.com)
CPAsOutsourceLLC