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

Matching multiple bank deposits to one invoice

Hello,

I run a pet services business. I use a separate software package that allows me to do scheduling and at the end of the month I can invoice all of my customers with a single click based on the schedules for that month.

 

What am I trying to achieve? I would like to create a single summary invoice within Quickbooks at the end of each month and then match all of the separate clients individual payments to the one invoice. I can match them individually but wanted to know if I could select say 15 or 20 and match them in one go? Any ideas much appreciated.

Solved
Best answer 02-20-2018

Best Answers
Highlighted
Content Leader

Matching multiple bank deposits to one invoice

Hey there TopDog2018,

 

I appreciate you reaching out to us here in the Community. I'm glad to lend a hand with matching multiple deposits to one invoice.

 

This can be done by receiving payments on the invoice. Here's how to do it:

 

1. Select the Create icon (+) in the top right corner.

2. Click Receive Payment.

3. Find the customer's name.

4. Enter the date, payment method, and where to deposit to.

5. Check the invoice to apply the payment to under Outstanding Transactions.

6. Choose Save and close in the bottom right corner.

 

This article offers additional information on adding and matching downloaded transactions: https://community.intuit.com/articles/1164872-matching-downloaded-transactions-to-existing-quickbook....

 

This will get you back on track. Keep up the great work and please feel free to reach out to me if you have any other questions.

View solution in original post

3 Comments
Highlighted
Content Leader

Matching multiple bank deposits to one invoice

Hey there TopDog2018,

 

I appreciate you reaching out to us here in the Community. I'm glad to lend a hand with matching multiple deposits to one invoice.

 

This can be done by receiving payments on the invoice. Here's how to do it:

 

1. Select the Create icon (+) in the top right corner.

2. Click Receive Payment.

3. Find the customer's name.

4. Enter the date, payment method, and where to deposit to.

5. Check the invoice to apply the payment to under Outstanding Transactions.

6. Choose Save and close in the bottom right corner.

 

This article offers additional information on adding and matching downloaded transactions: https://community.intuit.com/articles/1164872-matching-downloaded-transactions-to-existing-quickbook....

 

This will get you back on track. Keep up the great work and please feel free to reach out to me if you have any other questions.

View solution in original post

Highlighted
Level 1

Matching multiple bank deposits to one invoice

I have the same scenario and I do what you have advised, but it applies to single transactions.  I create a blanket invoice, then assign multiple payments from my bank feed to the invoice payment, tedious with about 35 entries - one for every day.  I am looking for a way to do this in batch with selecting all relevant deposits and assign to the invoice payment at once.  ~5 minutes tops.  

 

I've seen some reference to bucketizing to unassigned payments and then moving in batch - I want to keep in sales and re-assign to the invoice at end of the month.

Highlighted
QuickBooks Team

Matching multiple bank deposits to one invoice

I have two options that we can do in linking an invoice to multiple deposits, tory-brogan.

 

First, we can exclude the multiple payments shown in the bank feeds and manually enter the full payment within QuickBooks.

 

Let me show you how to Exclude downloaded transactions by batch:

  1. Go to the Banking page and select the bank.
  2. Click the For Reviewed tab and select all payments for the invoice.
  3. From the Batch actions drop-down, click Exclude Selected.

Second, we can change the Category of each payment into Accounts Receivable and let’s make sure that the correct Payee is selected. Then, let’s add them by batch by selecting the payments that were already modified and from the Batch actions, click Accept Selected.  

 

Once done, we can open the Invoice and click the Receive Payment button. Select the invoice to be paid and at the Credits section, click all the possible Deposits.

 

Let me know if you need anything else. Thanks!

Need to get in touch?

Contact us