Skip to main content
T
tmoney5252
February 25, 2023
Solved

Reconciling Credit Card Refunds

  • February 25, 2023
  • 1 reply
  • 0 views

Hello!

 

We use a separate credit card processing terminal to manage payments. Typically when we issue a refund, the refunded amount comes out of our next batch deposit. For instance, if we ran $1000 worth of charges but also refunded a customer $100, our deposit the following day would be $900. 

 

I'm finding this process is making it challenging for me to properly reconcile a customer's original payment and subsequent refund when I'm matching deposits in the business overview/bank account section. For instance, I received a credit card batch deposit on 1/03 which included the customer's original payment - I am able to match that payment without issue. On 1/05 I received another credit card batch deposit, but it is for $600 less than the charges ran the previous day because of the $600 refund. I can't match this deposit to the charges it was for because it is less than what those charges add up to.

 

I'm not sure if I'm explaining this clearly enough...hopefully someone can still help me though!!

Best answer by GebelAlainaM

I appreciate your effort in adding a detailed scenario with your concern, @tmoney5252. Let's work together to make things right so you find a match for the batch deposit in QuickBooks Online (QBO).

 

To fix this, you'll need to undo first the transaction from the Categorized tab to void the resolve difference and the transaction goes back to the For Review tab. After that, we can follow the process to settle this issue and you'll be able to find a match for the deposit payment.

 

Firstly, you'll want to Receive payment directly since you've already created an invoice that amounted to $ 1,650. Then, deposit the Undeposited funds or Payments to the deposit account.


 



After that, create a Bank Deposit for the invoice payment. On the Add Funds to this deposit section, enters the expense refund for Customer B with an amount of -600. For the accounts to use, I recommend reaching out to your accountant or a QuickBooks Certified ProAdvisor. That way, they can guide you with the appropriate process and ensure the accuracy of your books. Then click Save and close. After this, you can now find a match for the deposit transaction on the For Review tab.


 

I'll be adding these articles for future reference:
 

If you need more help matching your bank transactions in QuickBooks Online. I'll be around. Take care!

1 reply

S
SarahannC
February 25, 2023

Hello there, tmoney5252.

 

I appreciate you for providing more details about your concern. Based on your scenario, we can utilise the Find match button and enter an adjustment to resolve the difference  to match the deposit to the charges. Here's how:

 

  1. Go to the Banking menu.
  2. Within the Banking tab, find the deposit you want to match.
  3. Select Find match.
  4. Select all the invoices/transactions.
  5. Once you select the transaction, scroll to the bottom of the table and click Resolve difference on the right.
  6. Complete the fields in the table to add the adjustment.
  7. Click Save.

 

Let's keep your bank data accurate from time to time. With that, we have to review and reconcile your accounts in QuickBooks. The articles below will serve as your guide.

 

 

If you have more concerns about connecting accounts and handling transactions, please know that I'm here to help you. Take care and stay safe.

T
tmoney5252Author
February 25, 2023

Hi - Thanks so much for your response!

 

I think I am making some progress with your suggestion, but still not quite fully there yet. Perhaps if I give you the exact details, it will help.

 

I have a batch deposit of $1,050 that I am trying to match. This consists of two charges: a $1,650 payment from customer A, and a refund of $600 to customer B. When I select find match, the $1,650 payment does not show up in the list of invoices/transactions - I believe this is because it is greater than the $1,050 deposit amount and is getting filtered out (I see it when I look at other larger deposits). Is there a way to make the $1,650 payment appear? (if so, I believe that would resolve the final issue I mention at the end).

 

I clicked resolve difference and was able to add a $600 refund for customer B (I entered -600) and then also manually entered the $1,650 payment from customer A. This added up to $1,050 and I was able to save it.

 

The refund appears as an expense in customer B's home page (where I can see all their invoices/payments) - the only issue with this is that it's not linked to a credit memo, so it appears that there's an open balance. 

 

The other issue is that the $1,650 payment that I manually entered for customer A is not linked to the payment I already had for them (back when I created the invoice and clicked "receive payment"). How can I resolve this issue?

 

Thank you so much!!

G
GebelAlainaMAnswer
February 25, 2023

I appreciate your effort in adding a detailed scenario with your concern, @tmoney5252. Let's work together to make things right so you find a match for the batch deposit in QuickBooks Online (QBO).

 

To fix this, you'll need to undo first the transaction from the Categorized tab to void the resolve difference and the transaction goes back to the For Review tab. After that, we can follow the process to settle this issue and you'll be able to find a match for the deposit payment.

 

Firstly, you'll want to Receive payment directly since you've already created an invoice that amounted to $ 1,650. Then, deposit the Undeposited funds or Payments to the deposit account.


 



After that, create a Bank Deposit for the invoice payment. On the Add Funds to this deposit section, enters the expense refund for Customer B with an amount of -600. For the accounts to use, I recommend reaching out to your accountant or a QuickBooks Certified ProAdvisor. That way, they can guide you with the appropriate process and ensure the accuracy of your books. Then click Save and close. After this, you can now find a match for the deposit transaction on the For Review tab.


 

I'll be adding these articles for future reference:
 

If you need more help matching your bank transactions in QuickBooks Online. I'll be around. Take care!

Terms & ConditionsAccessibility statement