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

Quickbooks Pro 2018 match downloaded deposit to invoice

Apologies if this already been answered, I did some searching but couldn't find the exact situation...

 

At the start of the month I manually download QBO files to import bank data for the past month. I go through the deposits and add them in to the register from the bank feeds center. I am trying to match up the downloaded deposits to some invoices to mark them as payments on those invoices. I understand this isn't the typical workflow of receive payments to undeposited funds and then make the deposit, but I'm hoping there's a way to match it up?

 

Thank you!

Solved
Best answer February 12, 2019

Best Answers
Highlighted
QuickBooks Team

Quickbooks Pro 2018 match downloaded deposit to invoice

Hi there, @KevinM207.

 

I'm here to help match up the downloaded deposits to some invoices in QuickBooks Dekstop (QBDT).

 

You can use the Add More Details option in your Bank Feeds.

 

  1. Go to Banking at the top menu bar.
  2. Select Bank Feeds and go to the Bank Feeds Center.
  3. Select your bank under Bank Accounts.
  4. Click on Transaction List.
  5. Select the deposit and go to the Action column.
  6. Click on Add More Details.
  7. In the Add More Details page, click on Open invoices. Apply the deposit to the open invoices by selecting the box beside the open invoice.

You can also change or edit the deposit by choosing the appropriate customer name.

 

  1. Find the account where you deposited the amount.
  2. Select the appropriate customer under the Receive From column.
  3. Under From Account select Accounts Receivable.
  4. Click Save & Close.
  5. Go to the Customer Center and select the customer's name.
  6. Click on the customer's open invoice.
  7. In the Invoice page, click on Receive Payments.
  8. In the Customer Payment page, click Apply Credit above Save and Close.
  9. Select the deposit.
  10. Click Done.

That should do it. If you need further assistance with the process, you may get in touch with our QuickBooks Dekstop Support Team. For the support's contact information:

 

  1. Go to: https://help.quickbooks.intuit.com/en_US/contact.
  2. Choose your QuickBooks Product.
  3. Select your QuickBooks version.
  4. On the Contact Us page, click a topic.
  5. Click on the Get Phone Number button to see the support number.

Let me know directly if you have any other concerns about matching up deposits to invoices. I'll be right here to help you!

View solution in original post

9 Comments
Highlighted
QuickBooks Team

Quickbooks Pro 2018 match downloaded deposit to invoice

Hi there, @KevinM207.

 

I'm here to help match up the downloaded deposits to some invoices in QuickBooks Dekstop (QBDT).

 

You can use the Add More Details option in your Bank Feeds.

 

  1. Go to Banking at the top menu bar.
  2. Select Bank Feeds and go to the Bank Feeds Center.
  3. Select your bank under Bank Accounts.
  4. Click on Transaction List.
  5. Select the deposit and go to the Action column.
  6. Click on Add More Details.
  7. In the Add More Details page, click on Open invoices. Apply the deposit to the open invoices by selecting the box beside the open invoice.

You can also change or edit the deposit by choosing the appropriate customer name.

 

  1. Find the account where you deposited the amount.
  2. Select the appropriate customer under the Receive From column.
  3. Under From Account select Accounts Receivable.
  4. Click Save & Close.
  5. Go to the Customer Center and select the customer's name.
  6. Click on the customer's open invoice.
  7. In the Invoice page, click on Receive Payments.
  8. In the Customer Payment page, click Apply Credit above Save and Close.
  9. Select the deposit.
  10. Click Done.

That should do it. If you need further assistance with the process, you may get in touch with our QuickBooks Dekstop Support Team. For the support's contact information:

 

  1. Go to: https://help.quickbooks.intuit.com/en_US/contact.
  2. Choose your QuickBooks Product.
  3. Select your QuickBooks version.
  4. On the Contact Us page, click a topic.
  5. Click on the Get Phone Number button to see the support number.

Let me know directly if you have any other concerns about matching up deposits to invoices. I'll be right here to help you!

View solution in original post

Highlighted
Level 1

Quickbooks Pro 2018 match downloaded deposit to invoice

Thanks!!

Now, here's my next problem :)

I have a deposit which consists of two different payments and when I try to set them both as Accounts Receivable it gives me an error that "You cannot use more than one A/R or A.p account in the same transaction."

Do I need to break that deposit in to two separate transactions, even though that would mean the amount of the deposit wouldn't match the bank?

Highlighted
QuickBooks Team

Quickbooks Pro 2018 match downloaded deposit to invoice

I've got you covered, KevinM207.

 

I'm by no means an accounting professional, but allow me to step in for a moment and provide the clarification that you're looking for.

 

I wouldn't recommend splitting the deposit. While it will allow you to set them to Accounts Receivable (A/R), it wouldn't match the transaction on your bank statement which may lead to a discrepancy during the reconciliation.

 

That said, you could delete this instead and follow the usual A/R workflow by receiving payment for the invoices to the Undeposited Funds account. Then, make the deposit to the right bank account that includes both payments. The steps below will guide you through the entire process:

 

Delete a deposit in QuickBooks

  1. From the Lists menu, choose Chart of Accounts.
  2. Double-click the bank account to open the register.
  3. Find and double-click the deposit.
  4. From the Edit menu, select Delete Deposit. You can also press Ctrl + D.
  5. Click OK.

To receive payment for invoices

  1. From the Customers menu, select Receive Payments.
  2. Choose the correct customer from the Received From drop-down menu.
  3. Select the Invoice.
  4. From the Deposit To drop-down menu, make sure to pick the correct bank account.
    - If you don't see this menu, go to the Edit menu first, then choose Preferences. Select Payments in the left navigation panel, go to the Company Preferences tab and uncheck the Use Undeposited Funds as a default deposit to account checkbox.
  5. Click Save & New, and repeat these steps for the other payment.

Deposit payments from the Undeposited Funds account

  1. From the Banking menu, click Record Deposits/Make Deposits.
  2. On the Payments to Deposit window, select the payments you want to deposit then click OK.
  3. In the Make Deposits window, click the Deposit To drop-down then choose the bank account where the payment will be deposited to.
  4. Enter the Date.
  5. Click Save & Close.

For additional insight about this, you can check out these articles:

That should get you going in the right direction. Please don't hesitate to reach out to me again if there's anything else I can help you with. Have a good one!

Highlighted
Anonymous
Not applicable

Quickbooks Pro 2018 match downloaded deposit to invoice

I have a question that was not answered in your reply.  I am using quickbooks premier retail edition 2018.  I received back my first few months.  However, I did not match the deposits to the invoices prior to integration.  How can I now connect them from the registry?

 

Highlighted
Moderator

Quickbooks Pro 2018 match downloaded deposit to invoice

Hello there, Judytw.

 

Thanks for checking in with us. Allow me to help you match downloaded deposit to an existing invoice in QuickBooks Desktop.

 

You'll need to manually match your downloaded deposit transactions with your invoices. Let me walk you through the steps on how to do it:

  1. Go to Banking.
  2. Click Bank Feeds.
  3. Click Bank Feeds Center.
  4. Choose the bank account.
  5. Click Transaction list  button
  6. Choose the deposit transaction.
  7. Under Action column, choose Add more details from the drop-down.
  8. Select the invoice you want to match.
  9. Click Add to QuickBooks.
  10. Click Ok.

To know more about matching downloaded transactions, you can check out this article: Add and match Bank Feed transactions.

 

If there's anything else I can do to help you with matching downloaded transactions, just let me know and I'd be happy to assist.

Highlighted
Level 1

Quickbooks Pro 2018 match downloaded deposit to invoice

my name is maria  I need to install my disc program in my computer but it do not working 

my phone number is [removed]

Highlighted
QuickBooks Team

Quickbooks Pro 2018 match downloaded deposit to invoice

Hi Maria,

 

If your installation disc for QuickBooks Desktop is no longer working, you have the option to download the app itself. 

 

You can visit this page: Download QuickBooks Desktop. Simply select your registered country, product, and version, then hit Search.

 

Additional details on how to download QuickBooks Desktop can be found in this article: Download QuickBooks Desktop.

 

Leave a comment below if you have other questions in mind. I'll be sure to get back to you.

Highlighted
Level 1

Quickbooks Pro 2018 match downloaded deposit to invoice

I've already downloaded deposit transactions from my bank. Now I am using Record Deposits to clear undeposited funds. Is there a way to match the deposit using Record Deposits to the already downloaded existing deposit in my account so I don't have to go delete and re-reconcile?

Highlighted
QuickBooks Team

Quickbooks Pro 2018 match downloaded deposit to invoice

Hello there, @markusallen2020.

 

Yes. You can match your recorded deposits to the existing deposit in your QuickBooks Desktop. Let me walk you through the steps.

 

  1. Go to the Banking menu, then select Bank Feeds and choose Bank Feeds Center.
  2. Select the appropriate bank account from the list, then click the Transaction List.
  3. From the Transactions List window, select the deposit with the Record Deposit account.
  4. Select the Match to Existing Transaction from the Action column.
  5. Find the existing deposit from the list, then click Confirm Match.

Here's an article you can read for more details: Add and match Bank Feed transactions in QuickBooks Desktop.

 

You might also want to check out this article to learn how to create rules for bank feeds: Use renaming rules for Bank Feeds.

 

Please touch base with me here for all of your QuickBooks needs, I'm always happy to help. Have a great day and be safe.

Need to get in touch?

Contact us