Skip to main content
R
Rafiq11
March 26, 2020
Solved

Customer sent 2 Bank payments for 10 invoices

  • March 26, 2020
  • 1 reply
  • 0 views

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?

Best answer by JoesemM

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.

1 reply

G
GeorgiaC
March 26, 2020

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 

R
Rafiq11Author
March 27, 2020

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.

JoesemM
JoesemMAnswer
March 27, 2020

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.

    Terms & ConditionsAccessibility statement