Skip to main content
P
PolvarthMatt
January 10, 2024
Question

Customer overpayment to credit

  • January 10, 2024
  • 1 reply
  • 0 views

A customer deliberately overpaid us - they are happy for the rest to be kept to apply to future invoices - and I don't know what to do with the bank transaction in the "for review" tab, nor how to apply some of the payment to the outstanding invoice.

 

With other incoming transactions from the linked bank account I've been able to match them to invoices, but that isn't an option for me now, I don't really understand why not.

 

Ideally I would like to be able to allocate some of this payment to the outstanding invoice, and leave the balance as a credit on the customer's account ready to apply for future invoices.

 

How can I achieve any of this?

1 reply

JenoP
JenoP
January 11, 2024

I'm glad you joined us here and asked this banking-related question in the forum, PolvarthMatt. I have experienced resolving situations where downloaded transactions do not match invoices, so I know what's likely causing the issue here.

 

Not to worry - I'll share the troubleshooting steps to ensure the downloaded payment gets matched up properly with the pending invoice.

 

To begin, please know that the system will look for a transaction with the same amount when looking for a match. 

 

This is why you're unable to match the downloaded payment to the pending invoice because QBO searches for a transaction with the identical amount when trying to find a match. Since the imported payment amount exceeds the invoice balance, it does not recognize them as a match.

 

However, you can use the Resolve Difference function to manually associate the payment with the invoice. Then, select the Accounts Receivable or Debtors account in the Add resolving transactions section so it will be recorded as a credit and can be applied to future invoices.

 

Follow these steps on how to do this:

 

  1. Go back to the For review tab and click the downloaded payment.
  2. Select the Find match radio button.
  3. Look for the invoice and check the box before it.
  4. Proceed to the Resolve section and slide the bar to the right. Then, scroll down a little bit.
  5. In the Add resolving transactions section, select the Accounts Receivable or Debtors account under the Category column so the overpayment is recorded as a credit.
  6. Enter all other details and click Save.

 

Using Resolve Difference allows you to manually match the payment to the invoice, despite the amount differences.

 

Keep in mind that it will also create a credit in your customer's account. You can use this article as a guide on how to apply the credit to future invoices: Handle A Customer Credit Or Overpayment In QuickBooks Online.

 

Just in case you need more guidance when working with your baking transactions, I'd also like to share these articles with you:

 

 

Please don't hesitate to come back to the QuickBooks Community in the future if you need any help with bank feeds, downloaded transactions, or anything else related to managing your business finances. There are community experts available 24/7 to provide assistance and guidance whenever you have questions for us, PolvarthMatt. 

P
PolvarthMattAuthor
January 11, 2024

Thank-you jenop2, that's great, it almost resolves it for me....

 

The one issue being that there is no "Accounts Receivable" option under category for "Add resolving transaction". Presumably I should "Add new" and create this, possibly as a Current Liability? Will that work? Or is there an equivalent option built in?

 

Matt

S
SirielJeaB
January 11, 2024

Hi there, Matt. Allow me to help you determine why you're unable to see the accounts receivable.

 

The Accounts Receivable in the system may have been renamed in the past. Before proceeding with my colleague's recommended process, let's first confirm the current name of the accounts receivable by searching for it in the Chart of Accounts. Here's how:

 

  1. Click on the Gear icon, then select Chart of Accounts.
  2. Look for an account with an Account type of Income and Detail Type of Sales and Product.
  3. Once found, that's your Accounts Receivable in the system that you'll use as the Category for Add resolving transaction. 

 

Please see the screenshot for visual reference:

 

Another option, aside from resolving the difference, is to receive the payment for the exact amount received and then match the bank transaction with the payment.

 

You can also reconcile your accounts so they always match your bank and credit card statements.

 

Fill me in if you have more queries about handling your customer payments. I'd be pleased to help you further. Take care.

Terms & ConditionsAccessibility statement