Skip to main content
P
panda0210
October 11, 2021
Question

Overpayment shows as open to the customer even refund is issued

  • October 11, 2021
  • 1 reply
  • 0 views

Hi,

There was an overpayment from the customer which I already refunded and also I entered in the Quickbooks and reconciled. But now I am entering new invoices, the overpayment amount is showing as open and the new invoices are credited to that amount.

Please help.


Thank you

1 reply

M
MirriamM
October 12, 2021

Hello there, @panda0210.

 

I'm here to share information with you about recording customer refunds.

 

To be able to zero out your customer's balance and Accounts Receivables, you'll need to create an expense transaction for the overpayment. Then, create a payment and select the expense recorded and the existing credits.

 

To do this, here's how:

  1. In the left menu, click the + New button.
  2. Select Check or Expense.
  3. Choose the name of the customer.
  4. Select the same bank account used in processing the refund.
  5. In the Category Details section, choose Accounts Receivables in the Category column.
  6. Enter the complete expense details.
  7. Click Save and Close. 

 

After that, link the expense and the unapplied amount.

  1. Open your customer's transaction list.
  2. Click on the drop-down arrow under New transaction and choose Payment. 
  3. On the Receive Payment window, select the check under the Outstanding Transactions section and the Unapplied Payment under the Credits.
  4. Click Save and close.

 

For more information about this process, see this article: Record a customer refund or supplier refund in QuickBooks Online.

 

If there's anything else I can do for you, please let me know. I'll be around to help you.

P
panda0210Author
October 13, 2021

Hi Mirriam,

Thank you for your prompt response. 

This will work even I already created a refund in QuickBooks and reconciled it as the bank feeds in QB?

This won't affect the reconciliation done? 


Thanks,
Panda0210

 
 
 
MariaSoledadG
MariaSoledadG
October 13, 2021

Making sure to offset your refund is our top priority, panda0210.

 

Recording a refund is based on various scenarios and this won't affect your reconciliation. You'll just have to make sure that the affected account used is Accounts Receivable (A/R) associated with your customer transaction. To ensure that you have correctly recorded the transaction, follow the steps below: 

 

To enter the check:

  1. Open your QBO account, then select Check from the New (+) icon.
  2. Pick the customer's name under the Payee section.
  3. Under Category select Accounts Receivable, then enter the overpaid amount.
  4. Save the check.

 

Then, follow these steps to link the check and the unapplied amount.

  1. Open your customer's transaction list.
  2. Click on the drop-down arrow under New transaction and choose Payment. 
  3. On the Receive Payment window, select the check under the Outstanding Transactions section and the Unapplied Payment under the Credits.
  4. Hit Save and close.

 

Once done, open a Transaction Journal so you can check the accounts. 

  1. Go to the Expenses tab on the right menu.
  2. Locate and open for the check.
  3. Click More on the lower part, select Transaction journal.

 

Moreover, QuickBooks automatically downloads the latest transaction. For more information on how to match the transactions, check out this article for your guide: Categorise And Match Online Bank Transactions In QuickBooks Online. 

 

Let me know if you have any other concerns about refunds and reconciliation. I'll be here to help.

Terms & ConditionsAccessibility statement