Skip to main content
October 7, 2020
Question

How do I match a payment to an invoice if the amounts are different? We had a customer send a check for more than they owe. Also, do I create a credit memo for remainder?

  • October 7, 2020
  • 1 reply
  • 0 views
QBO will not let me match the payment because it doesn't match. I tried creating a payment under the Customers profile and then in our bank account in QBO, I just added the payment and put the customers name but that didn't do what I needed it to do.

1 reply

Rustler
October 7, 2020

Delete what you did

use receive payments in QB, enter the actual amount paid for that invoice, when you save QB will ask if you want to refund or keep as a credit.  Then use deposit funds and put the received payment in the bank

 

download banking and match

 

the work flow is and has always been, enter transactions, download banking, match

sarah17Author
October 7, 2020

I received payment and put in the amount of the check and QBO did not ask me what I wanted to do with the difference. So do I create a credit memo?

MarsStephanieL
October 7, 2020

Hi there, @sarah17.

 

You might have entered the payment along with the invoice transaction, that's why it was not recorded as a Credit memo. I can show you the way to correct this. First, you'll have to delete the payment transaction. Then, re-create it and enter the total amount paid in the Amount received box. I'll also include how you can match this transaction on the Banking page. That way, we can ensure that the transaction is cleared.

 

Here's how to re-create the payment:

  1. Go to the +New button and choose Receive payment.
  2. Enter the customer's name and tick the box beside the invoice transaction.
  3. Enter the total amount paid in the Amount received field. Note: After entering the amount, you'll see in the sub-total field that there's an Amount to credit, that is the excess payment of the customer.
  4. From the Deposit to field, click the drop-down button, and choose Undeposited Funds.


     
  5. Select Save and close.

 

Once done, you can deposit the customer's payment. I'll show you the steps below.

  1. Navigate to the +New button and select Bank deposit.
  2. Select the account you want to deposit the payment.
  3. Tick the box beside the customer's payment.
  4. Select Save and close. This is how it looks like:

 

Then, you can match this if the payment transaction is already downloaded on the Banking page. You can refer to the steps below.

  1. Go to the Banking menu and select the bank where your customer's payment has been deposited.
  2. Find the transaction with the correct details. QuickBooks will automatically detect the transactions that matched with the downloaded ones from the bank. A green mark will show on the transaction.

  3. Click the transaction and verify the details.
  4. Select the Match button.

You can also review the process in this article: Categorize and match online bank transactions in QuickBooks Online.

 

When you're ready to assess your business financials, you may consider checking out this article: Reconcile an account in QuickBooks Online. This contains a video tutorial and tips on how to fix any issues during the reconciliation process.

 

Please don't hesitate to tag my name in the comment section below if you need further assistance. I'd be happy to help you succeed. Take care and have a blessed day!