Receipts from Home Depot etc..

How you file receipts is really a personal or company choice

For me, especially since todays thermal receipts fade over time (which could make an audit years from now awkward), I scan them and title the scan with, using this case as an example, "home depot 3-17-18", and I store the scan in a folder named for the vendor if I use that source a lot, for occasion purchases I just store the named pdf in the parent receipts folder.

Our company uses the revolving charge card from Home Depot and I've found two different ways of handling the receipts; one is enter them (along with their invoice number and po #) when you receive them because this will match the statement and will save you from having to do it when you go back to reconcile or you can simply store the receipts and import the transactions using software such as transaction pro which is the best all around importer that's ever worked with Quickbooks, hands down (I've used it with Sage, Order Pointe, Statements, CSV Files, XLS Files....the list goes on and on!) Honestly, I've just started scanning/filing the receipts and typing in the transactions because I type faster than the import process. Good Luck!  

I'm still a bit confused how the Home Depot Purchase Account works.  When I import the purchases the items all show up in a split transaction in a Home Depot-Quickbooks Purchases Credit Card Account with a zero balance.  The Class for each transaction is Uncategorized Expense. Should I be allocating each item to an Expense account or Capitalized Expense Account? I only use my Home Depot Commercial Credit Card for all my purchases at Home Depot. Should I also have a Credit Card Account  for Home Depot. 

I would also like to know how to take the transactions from this 0 balance account and turn them into expenses.

I'd like to direct to the right support today, @ebradbury.

You'll want to contact our Customer Care Support. They have special tools that can assist you with importing and converting transactions.

Here's how to reach out:

1. In your QuickBooks, click Help and then QuickBooks Desktop Help.
2. Scroll down and select Contact Us.
3. Type a brief description of your case and then Continue.
4. Choose Get a callback or Start messaging.

I'm also attaching our page about Apps for additional resources.

Stay in touch if you have other questions. I'll be around to help. Thanks for posting and have a wonderful weekend ahead.

Does anyone know the answer to this? I also am confused with the zero balance.

Let's work together to get rid of that zero balance, @midstateppts.

To help you out, I’d like to clarify which specific page or part you’re able to observe a zero balance on. Is it the bank balance or QuickBooks? Are you referring to a zero balance during reconciliation?

I’d also appreciate it if you include a screenshot so I can address your concern on time. This will also help me get more information to get on the same page as you.

You can tell us the details of your concern by leaving a reply on this thread. My team and other QuickBooks users in the community are willing to assist you too.

Please let me know if there's anything else that I could do for you. If you have other questions, I’ll be around to answer them for you.

The second screenshot is a better depiction of what I'm referring to.  You can see the 0.00 entry, then the individual items that were purchased and then an offsetting entry to balance the transaction/account to a zero balance.

Hello midstateppts!

I reviewed your screenshot and here's what I noticed.

It seems that this is a credit card account. Please note that a credit card account is a liability type by nature. Based on your screenshot, you made a payment to your credit card company for $74.29 and that is the amount showing under the Charge column. Since it is a payment, it'll offset the balance.

For the $0 transaction, you'll want to double-click it to open it. From there, you can verify the details to make sure everything is correct. You'll want to make some changes if necessary.

I added this link if you need more help on how to use and manage your credit card accounts: Set up, use, and pay credit card accounts. This includes steps on how to reconcile it.

If you have any other questions about tracking your transactions, please let me know. Do you need a hand in QuickBooks Desktop? Just say the word and I'd be glad to help you out. 

The issue the above user is discussing has nothing to do with payments. When you import an IIF file from the Home Depot Pro Xtra website, the IIF file automatically includes a charge and a linked "payment", or credit, corresponding to that exact charge. There hasn't been any payment made. This is how the file imports. So if you go to record a credit card payment from your bank account, it will show a credit for the entire balance due on the card in your credit card account register. Further, you cannot delete the mirrored credit so that the payment you made on the statement will balance. It just deletes both sides of the transaction. 

As far as I can tell, the IIF file import is designed to make reconciliation easier by breaking apart the individual charges as credits. It just means that you cannot record a payment from your checking account or it will throw the account out of balance. Or perhaps you create a zero payment (if it will allow you to do so). 

I don't like it and I cannot find a work around for it, nor can I find anyone at Home Depot account services who can even explain this import file structure.

Please let me know if you find a work around.   I am facing the same challenge.   Also the costs assigned to specific jobs aren't showing in reports.  

The charges being offset somehow.  When I open the credit in the chart of accounts it just takes me back to the same credit card transaction, which shows me the cost but not the credit.  

You are right that charges are being offset, but they aren't being offset with a payment.   I am facing a similar problem and I have literally made 0 payments.  

I'd love to help you with your issue, @rjones123456, so the costs assigned to specific jobs show in reports.

To provide the best resolution, can you please provide additional information about the assistance you need? This is for me to get a better picture of what's happening and ensure we are on the same page. 

You can also send screenshots here in the Community, but make sure to black out sensitive information to protect the account.

I'll be looking forward to hearing back from you. Just tap the Reply button below. I'll do whatever it takes to ensure your concerns are addressed. Have a great day.

 I have found two work arounds.  

#1 Push the clear splits button.  If you want to bill  specific items to a job, do this first.  When you clear the splits it will remove all this detail.  Its so its better to capture the detail before you clear the splits. 

#2 you can modify the IFF in Excel before importing it into QB.   

Isn't is possible to enter your qbodocs email address to each job purchase at the time of the purchase in home depot and the receipt will automatically email to receipts in QBO?

Providing the best experience with the product is what we aim for, lrzcom18.

I know how beneficial it is to your business to enter your QBODOCS email address to each job purchase in home depot and the receipt will automatically be emailed to receipts in QuickBooks Online. However, this option is unavailable in QuickBooks Online (QBO). With this said, I'd recommend sending this request straight to our product engineers through feedback. Sharing features and options that you would like implemented is how our engineers look for new product updates. Here's how: 

1. Go to the Gear icon at the top.
2. Select Feedback.
3. Enter your comments or product suggestions.
4. Then select Next to submit feedback.

You'll want to check for a third-party application that can help you with this one. You can check out the apps that are compatible with QuickBooks at this link: https://quickbooks.intuit.com/app/apps/home/. We can also do it in QBO by following the steps below:

1. Go to Apps on the left side menu.
2. Search for the app in the Find apps to streamline your work field.
3. Look for the app that supports the Batch Invoicing feature.

Any questions about integrating the app into your Online account are best handled by the third-party app provider. For more tips and other resources, you may visit our page in managing your business in QuickBooks: QBO Self-help articles.

I'll be right here to continue helping if you have any other concerns or questions about QuickBooks. Assistance is just a post away. You have a good one. 

I downloaded my credit card qbo file and it lists all the home depot charges. I then went into my Home Depot Pro Exta Account and downloaded the detailed information with the Quick Books Button in that website that produced a QuickBooks Import/Export File (.iif) file which imported all the data into the "Credit Card Purchases/Charge" section in Quickbooks and at the top for credit card it says "Home Depot-QuickBooks Purchases" and not the bank debit card I have associated. How do I combine these so that payments downloaded from my debit card QBO contain the line item detailed information from this iif file. 

Hi David!

I suggest working on the IIF file transactions as it has more details. You can then match them to your uploaded credit card transactions in the Bank Feeds section. You cannot link if the transactions from both the QBO and the IIF files are uploaded to the Bank Feeds section. You can refer to this article: Add and match Bank Feed transactions in QuickBooks Desktop.

Feel free to visit us again if you have any follow-up questions.

Thanks for responding. The trouble is that I cannot added this to the bank feed. Home Depot is not a bank so it doesn't show up in the bank search field. Also, I am not using a home depot credit card. I used my regular bank debit card or my credit card which are all set up in the Bank feeds and download all of the transactions. On the home depot site it has all my transaction and a quick books button to download. That generates an iff file which instantly imported. However, I don't know how to match them to the same bank transactions that are already accepted. These home depot detailed transaction only show up in the "enter credit card charges" section, which I have never previously used.   

Hello David193G, thanks for getting back to us.

For the accepted bank transactions, we can exclude or ignore them if we must do it. We can consult your accountant, so we'll know the best approach in this scenario. This way, we'll have an accurate record of the transactions coming from another website. Here's how:

1. From the Banking menu, select Banking Feeds.
2. Select Bank Feeds Center.
3. On the left pane, select a specific bank account. 
4. Click the Transaction List button.
5. On the Transactions List window, mark all transactions you need to undo.
6. Click the Batch Actions drop-down and select Ignore.

The following article contains more information about this: Add and match Bank Feed transactions. Also, please know that QuickBooks only depends on Home depot and other sites on what transactions they will bring to us. QuickBooks has its own way of handling them from the bank feed.

Since those home depot transactions only show up in the Enter Credit Card Charges section, we can seek additional advice from your accountant to ensure we'll manage them appropriately.

The Community is always around if you have more concerns about handling bank transactions and anything related to QuickBooks. Take care.