Skip to main content
A
anandmahey
March 20, 2025
Question

Refund Receipt processing shows a credit balance in the customer's account. Funds have been refunded the credit balance should not be there. How do i reconcile this?

  • March 20, 2025
  • 1 reply
  • 1 view

I added a Customer payment of $200 but had to refund $150. $50 was paid to another valid invoice. I processed a refund receipt manually (Refund Receipt) but there is a Credit Balance of $150. How do reconcile this? The funds have been sent back to the customer.

1 reply

J
Jayson_E
March 20, 2025

Let's work together to resolve the credit balance discrepancy in your QuickBooks Online (QBO) account, anandmahey. To help us get started, could you provide more details on how you recorded the customer's payment and the refund receipt?

 

Providing us with this information will be invaluable in identifying the best steps to reconcile your account.

 

Please note that the data displayed in your customer's profile balance depends on the transaction you've created in QuickBooks Online.

 

If you recorded a $200 invoice payment without generating an invoice, then created a $150 refund receipt, and applied $50 to another invoice, there would be a $300 credit remaining. However, since you mentioned a credit balance of $150, it's possible that there could be other transactions affecting the balance.

 

However, if you applied the payment to an invoice and used the "Receive Payments" feature to link the transactions, including applying the $50 to another invoice, you can effectively zero out the remaining balance.

 

You can also check out this article to for more details on recording a customer refund in QBO: Record a customer refund in QuickBooks Online.

 

Regarding how you can reconcile your account, make sure to match your data in QuickBooks Online to your actual bank statements. You can also seek assistance from your accountant in reconciling your account. This way, they can review your books and make any necessary corrections if needed.

 

If you don't have an accountant, we can help you find one. You can visit this link to find an accountant or bookkeeper near you with QuickBooks ProAdvisor: Find an Accountant or Bookkeeper with Quickbooks ProAdvisor.

 

Additionally, you can refer to this article for a guide on how to close your books and prevent changes to your past transactions in QBO: Close your books in QuickBooks Online

 

Please don't hesitate to revisit us if you need more assistance with recording customer refund and reconciling your account in QBO. We'll be here to help and look forward to your response. Stay safe!

A
anandmaheyAuthor
March 20, 2025

Allow me to elaborate.

 

The customer paid a lump sum payment of $200 for 2 invoices, Invoice A and Invoice B.

 

However, he accidentally paid an invoice A which was already paid sometime back. Invoice A is $150.

 

He was not supposed to pay $200.

 

He was only supposed to pay $50 (Invoice B).

 

Invoice B is $50

 

i received $200 in the bank account and

 

1. created a Received Payment transaction first.

2. applied the payment to Invoice B

3. attempted to record a refund of $150.

 

but it shows a credit of $150 as well.

 

i’m looking at being able to upload my bank transactions later to categorise and eventually reconcile my transactions.

 

I thought this process might help in categorisation, rather than deleting the excess $150

 

Quickbooks does not connect to my bank.

 

in the above case how do i perform a refund and not show a credit balance in the customer’s account?

 

Thank you

 

 

N
NicoleAscencionS
March 20, 2025

To properly record a refund, you can create a cheque or expense and link that to the customer's credit, anandmahey. Let me elaborate more on the steps below.

 

Using Cheque or Expense to record the refund reduces your bank's balance and offsets the customer's open credit, overpayment, or prepayment.

 

Here's how to do this:

 

  1. Go to + New and select Expense or Cheque.
  2. Under the Payee dropdown, choose the customer you want to refund.
  3. From the Payment Account or Bank Account dropdown, select the bank account where the overpayment is posted.
  4. In the Category column, select Accounts Receivable.
  5. Enter how much you want to refund in the Amount field.
  6. Fill out the other fields as you see fit, then hit Save and close.

 

Once done, let's link the refund to the customer's credit or overpayment. Follow the steps below:

 

  1. Navigate to + New.
  2. Select Receive payment.
  3. Choose the same customer.
  4. In the Outstanding Transaction section, tick the checkbox for the Expense or Cheque you created when recording the refund.
  5. Make sure the payment is equal to the open balance, then click Save and close.

 

Additionally, I'd like to share some articles that will help you in categorising your transactions and reconciling your account in the future:

 

 

By following these steps, you can effectively manage your refunds and keep your financial records accurate. If you find yourself needing more help in handling your other customer transactions, please don't hesitate to reach out.

Terms & ConditionsAccessibility statement