Skip to main content
B
billing87
September 15, 2021
Solved

Can I match a deposit in the bank feed with a higher payment and a refund?

  • September 15, 2021
  • 2 replies
  • 0 views
I have a customer that paid their invoice with a credit card and another that we refunded to their credit card. The credit card processor will deposit the net amount and I'm wondering how to record all this and match properly. For illustration, Customer A paid 4,000 and Customer B got refunded 500, so the net amount of the deposit that we received in the bank is 3,500 and I need to match that deposit with the 4,000 payment and a 500 refund. I tried finding the 4,000 payment in the list of transactions to match but it doesn't appear there as it is higher than the deposit (3,500) that I'm trying to match. Entered the refund manually and it also does not appear in the list of transactions to match. Any ideas on how to resolve this? Maybe there is a workaround
Best answer by DivinaMercy_N

Thanks for being detailed about your concern, @billing87. I'm here to ensure you can match the deposit with a payment and a refund in QuickBooks.

 

Before we begin, let's first ensure that the payment ($4,000) of Customer A is deposited to the Undeposited Funds account. Here's how:

 

  1. Sign in to your QuickBooks Online (QBO) account and select the +New button.
  2. Choose Receive Payment.
  3. From the Deposit to field, select Undeposited Funds.
  4. Click Customer A on the Customer drop-down and check the invoice ($4,000) in the Outstanding Transactions section.
  5. Then, click Save and close.

 

Next, create a bank deposit and add the refund for Customer B. Let me guide you how:

 

  1. Go to the +New option and select Bank Deposit.
  2. Choose the account where you want to deposit the payment in the Account drop-down.
  3. Under the Select the payments included in this deposit section, mark the payment ($4,000) from Customer A.
  4. Next, add the refund for Customer B in the Add funds to this deposit field.
  5. Choose Customer B, in the Received From column.
  6. Then, select income account or Accounts Receivable in the Account field.
  7. From the Amount column, enter negative 500 (-$500).

 

After that, the total amount will be $3,500. Once done, you can now match the transactions on the Banking page. 

 

In QBO, it's easy to get a list of your customers’ outstanding balances to determine how much is still due and how long they’re past due are. You simply need to run the accounts receivable aging report to have this data. 

 

If you need additional assistance matching the deposit with a payment and a refund, feel free to get back here. I want to ensure your success. Have a good one. 

2 replies

DivinaMercy_N
DivinaMercy_NAnswer
September 15, 2021

Thanks for being detailed about your concern, @billing87. I'm here to ensure you can match the deposit with a payment and a refund in QuickBooks.

 

Before we begin, let's first ensure that the payment ($4,000) of Customer A is deposited to the Undeposited Funds account. Here's how:

 

  1. Sign in to your QuickBooks Online (QBO) account and select the +New button.
  2. Choose Receive Payment.
  3. From the Deposit to field, select Undeposited Funds.
  4. Click Customer A on the Customer drop-down and check the invoice ($4,000) in the Outstanding Transactions section.
  5. Then, click Save and close.

 

Next, create a bank deposit and add the refund for Customer B. Let me guide you how:

 

  1. Go to the +New option and select Bank Deposit.
  2. Choose the account where you want to deposit the payment in the Account drop-down.
  3. Under the Select the payments included in this deposit section, mark the payment ($4,000) from Customer A.
  4. Next, add the refund for Customer B in the Add funds to this deposit field.
  5. Choose Customer B, in the Received From column.
  6. Then, select income account or Accounts Receivable in the Account field.
  7. From the Amount column, enter negative 500 (-$500).

 

After that, the total amount will be $3,500. Once done, you can now match the transactions on the Banking page. 

 

In QBO, it's easy to get a list of your customers’ outstanding balances to determine how much is still due and how long they’re past due are. You simply need to run the accounts receivable aging report to have this data. 

 

If you need additional assistance matching the deposit with a payment and a refund, feel free to get back here. I want to ensure your success. Have a good one. 

    B
    billing87Author
    September 15, 2021

    It worked! Thank you so much for your help! :-)

    R
    rbcnew
    September 24, 2024

    Is there an update to this?  In my workflow it may not be practical or convenient to get related refunds and deposits into a single manual deposit transaction, since refunds are not deposits to begin with.

     

    Anyway, my request to Intuit would  be to expand the Matching function so that we could pull up any and all transactions to match the correct ones without further manipulation.

     

    Thanks

     

     

    H
    Heide DC
    September 24, 2024

    We highly value your feedback regarding the current matching functionality in QuickBooks Online (QBO), rbcnew.

     

    Currently, QBO still requires manual processing for refunds and deposits. However, you can directly share your ideas with our product developers to request improvements to the matching function. This will allow our development team to gather ideas for future updates.

     

    Here’s how you can do that:

     

    1. Select the Gear icon, then choose Feedback.
    2. Enter your request or product suggestions.
    3. Select Next to submit.

     

    Submitting your feedback will allow our development to gather some ideas they can include for future updates. 

     

    You can also visit this helpful article on matching your transactions after connecting your bank in QuickBooks: Categorize online bank transactions.

     

    Additionally, I've added an article to learn about matching your QuickBooks transactions with your actual bank statement: Reconcile workflow in QuickBooks.

     

    Please know that the Community space is always open if you have other questions about matching transactions in QuickBooks. We'll be sure to help you as soon as possible.

    Terms & ConditionsAccessibility statement