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

Customer sent 2 Bank payments for 10 invoices

Hi,

A customer has sent 2 bank payments to cover 10 invoices.  Neither of the payments match exactly to the invoices but together, they cover the entire balance.

My question is, how to do allocate these in banking?

Solved
Best answer March 27, 2020

Accepted Solutions
Highlighted
QuickBooks Team

Customer sent 2 Bank payments for 10 invoices

Thanks for getting back to us, Rafiq.

 

You can delete the payments to make sure that you'll be able to match the transaction in QuickBooks. Let me show you how: 

 

  1. Go to the Sales then click Customer.
  2. Choose the customer who sent payments.
  3. Open the transaction with the Paid status.
  4. Tap the one payment hyperlink to open the payment.
  5. Click the More button below then select Delete
  6. Hit Yes to confirm the action.

 

Once the payment is already deleted the invoice will open again. Then, we can go back to the For Review tab to match the transaction.

 

  1. Click Banking in the left menu.
  2. Select For Review tab.
  3. If QuickBooks has found a possible match for the bank transaction, it displays an outlined green box under the Category or Match column that says 1 record found message to the matching transaction.
  4. Click to expand the transaction to review its details.
  5. If it is the correct match, select Match under the Action column.

 

Also, you can read out this article on how to match your bank and credit card statements: Reconcile an account in QuickBooks Online.

 

Let me know if you need anything else. I'll be here to lend a hand. Take good care.

View solution in original post

7 REPLIES 7
Highlighted
QuickBooks Team

Customer sent 2 Bank payments for 10 invoices

Hello Rafiq, 

 

Click into the transaction in the for-review tab and select 'Find Match' - this will bring up all available matches on the following screen where you can select multiple transactions to apply to the one payment. 

 

Please note this will only work if the total amount of one payment equals the transactions selected. 

 

Thank you 

Highlighted
Level 3

Customer sent 2 Bank payments for 10 invoices

Hi,

That is the problem, the totals do not equal a set of invoices, but the total sum is equal to the total outstanding on the account.

Highlighted
QuickBooks Team

Customer sent 2 Bank payments for 10 invoices

Thanks for getting back to us, Rafiq.

 

You can delete the payments to make sure that you'll be able to match the transaction in QuickBooks. Let me show you how: 

 

  1. Go to the Sales then click Customer.
  2. Choose the customer who sent payments.
  3. Open the transaction with the Paid status.
  4. Tap the one payment hyperlink to open the payment.
  5. Click the More button below then select Delete
  6. Hit Yes to confirm the action.

 

Once the payment is already deleted the invoice will open again. Then, we can go back to the For Review tab to match the transaction.

 

  1. Click Banking in the left menu.
  2. Select For Review tab.
  3. If QuickBooks has found a possible match for the bank transaction, it displays an outlined green box under the Category or Match column that says 1 record found message to the matching transaction.
  4. Click to expand the transaction to review its details.
  5. If it is the correct match, select Match under the Action column.

 

Also, you can read out this article on how to match your bank and credit card statements: Reconcile an account in QuickBooks Online.

 

Let me know if you need anything else. I'll be here to lend a hand. Take good care.

View solution in original post

Highlighted
Level 3

Customer sent 2 Bank payments for 10 invoices

Hi,

I have not yet reconciled those 2 payments as individually, they do not equal a combination of the invoice totals, but together the 2 payments cover the whole balance.

 

Can I allocate a payment to the account and then clear the invoices?

 

I can't find a solution to this.  This is not about reconciling payment to invoice exactly as I know how to do that, this is reconciling payments larger or smaller than the invoice values.

 

Thanks

Highlighted
Level 3

Customer sent 2 Bank payments for 10 invoices

I should add, I followed the method suggested and went to find match and selected invoices, I selected several invoices, when getting close to the total I select the next invoice, it shows as equal but the total paid is now £100 less than the total on the invoices.

 

Does the extra balance carryover or stay on the account?  

Highlighted
Level 3

Customer sent 2 Bank payments for 10 invoices

Hi,

I followed the steps outlined previously and matched the invoices to the payment including going over the payment amount, it wasn't clear at all but the balance remains.  I then allocated the second payment to the same invoice with balance and the remaining invoices and it covered the whole amount.

 

It would be easier if there was an indication that there is balance left on an invoice - maybe I am not seeing it or looking in the right place.

Thanks

Highlighted
QuickBooks Team

Customer sent 2 Bank payments for 10 invoices

Brilliant, Pleased you have managed.

 

A way of seeing if there's a balance left on an invoice is, When on the invoice section if you have the balance showing it will show you the balance of the invoice. Thanks