cancel
Showing results for 
Search instead for 
Did you mean: 
gatoraquatics
Level 3

Customers pay invoices online. QB now deposits in batches. Can't "unbatch" deposits to apply payments to each customer, Unable to "match" because amount is a lump sum?

 
4 Comments 4
MaryLandT
Moderator

Customers pay invoices online. QB now deposits in batches. Can't "unbatch" deposits to apply payments to each customer, Unable to "match" because amount is a lump sum?

I can provide the steps on how to match invoices to the deposit, gatoraquatics.

 

Each day, QuickBooks Payments combines all of your customer payments (both sales receipts and paid invoices) for the day into a single record.

 

You need to use the Receive payments function to receive amounts for each invoice and deposit them to the Undeposited Funds account.

 

Then, use the Make Deposit feature and check off payments. Make sure to select the bank account you deposited to and the amount should match the actual deposit.

 

After that, go to the Banking page and match the deposit with the batch payment. Learn how to review downloaded transactions and put them in the correct accounts through this link: Categorize and match online bank transactions in QuickBooks Online.

 

In addition to your bank deposits, you can browse these links for future references:

 

 

Let me know if you need more help with matching payments to invoices. I'm always right here to provide the information that you need.

gatoraquatics
Level 3

Customers pay invoices online. QB now deposits in batches. Can't "unbatch" deposits to apply payments to each customer, Unable to "match" because amount is a lump sum?

I am very confused by your response?

When I email you an invoice, it has a "pay now" button. When you click on it, you can set up your bank account to pay your invoice. (I invoice the same customers the same amount every month).

The payment is then rec'd thru a QB merchant account, and batched together with other deposits, then deposited into my bank account in one lump sum. Then QB applies the payments to the invoices automatically.

When I go to do my recordkeeping, I have to do some detective work, because my customers invoice number is not noted, only the $ amount and name on the bank account (I invoice using my customers address, so name does not help me, and some do not always pay with the same bank), and I also have multiple customers who are $100, so when I get my bank statement, it shows a $700 deposit, but that could be 7 customers. Unless I know the name on their bank account, I do not know who it is. 

Then, when I try to reconcile my bank account in QB to match my bank statement, I try to "match" the $700 deposit to a customer, but I don't have a $700 customer, I have seven $100 customers. So now I need to find the correct $100 open invoice and try to apply $100 of the $700, but QB only suggests certain invoices to match with, and won't always let me force any open invoice. Even when I can,  the QB program does not know what to do with the remaining $600 deposit.

 

JenoP
Moderator

Customers pay invoices online. QB now deposits in batches. Can't "unbatch" deposits to apply payments to each customer, Unable to "match" because amount is a lump sum?

Thanks for sharing additional details about the batch deposits, toraquatics.

 

There's an option to match a single downloaded payment to multiple invoices. However, this is only applicable if the payment or deposit is made by the same customer. 

 

Since the batch deposit is for multiple customers, you can exclude the downloaded transaction so it will not stay in the For Review tab. Here's how:

 

  1. Go back to the Banking menu or Transactions menu, then proceed to the Banking tab.
  2. Look for the transaction in the For Review tab.
  3. Select the checkbox of the transactions to exclude.
  4. Click Exclude.

 

Here's an article about this process for more details: Exclude a Bank Transaction You Downloaded into QuickBooks Online.

 

I'd also encourage you to send feedback or a feature request about being able to separate batch deposits. You can send it directly from QBO where it's forwarded directly to our engineers. Here's how:

 

  1. Go to the Gear icon at the top, then select Feedback.
  2. Type in your feedback or product suggestions.
  3. Click Next to submit feedback.

 

Your valuable feedback will be forwarded and reviewed by our Product Development team to help improve your experience while using the program. You can track feature requests through the QuickBooks Online Feature Requests website.

 

Feel free to check out these articles with you for additional guidance and reference as well: 

 

 

Please know that you can always reply or reach out to us again if you have other questions. We'll make sure that everything is sorted out. 

CLC
Level 1

Customers pay invoices online. QB now deposits in batches. Can't "unbatch" deposits to apply payments to each customer, Unable to "match" because amount is a lump sum?

When I have a deposit whose total does not match a specific customer, I know I have to go out to QB Payments and find the corresponding batch for the deposit date.  From there, I can open up the batch and see how many payments are in the deposit.  It still can be a puzzle trying to match names with companies, but at least I have the actual per customer payment amount.

Need to get in touch?

Contact us