Skip to main content
D
Dixon FDS
December 4, 2023
Question

How to match a net debit balance of an invoice payment and credit card refund in the bank feed under QBO?

  • December 4, 2023
  • 1 reply
  • 0 views

Dear QBO Expert,

 

I encounter a quite difficult question. There is a net debit balance of $100 relating to a customer's credit card payment ($30) and a credit card refund of $130 for another customer in the bank feed under QBO.  When I try to match the net debit balance of $100, only drop down menu (Open Bills, Checks, Bill Payments, Expenses, Journal Entries, Transfer, Credit Card Payments and Refund receipts) for "Spent" are shown as it is a debit balance.  How to link the refund receipt and Open Invoices Payment together in the bank feed?   Thank you for  your help.

1 reply

Candice C
Candice C
December 4, 2023

Hey there, @Dixon FDS. 

 

It's great to see you back in the Community! Let's work together to get this problem handled. 

 

To clarify some additional details, can you provide us with screenshots of the issue? This will help us determine the best solution for your business. 

 

In the meantime, you can review this guide about matching transactions. 

 

I'll be waiting for your response! 

    D
    Dixon FDSAuthor
    December 5, 2023

    Hi Candice,

    Please find the screen shots.

     

     

    Please note that the actual net debit balance of $1042.60 including (1) customer's invoice payment of $751.40 and (2) credit card refund of $1,794.00 relating to a duplicate credit card payment.

    M
    MirriamM
    December 5, 2023

    Thanks for getting back to us and providing additional information, Dixon FDS.

     

    Let me share details of how matching transactions works in QuickBooks Online (QBO).

     

    Matching transactions depends on the data showing on your banking feeds. Since you're referring to a credit card payment and showing it as spent in the banking feeds, you can only match it to money-out transactions, such as Open Bills, Bill Payments, Checks, and other money-out transactions.

     

    For more details on handling your bank transactions, I recommend checking these articles:

     

     

    For future reference, here's an article you can check for the best practices when reconciling your account: Learn the reconcile workflow in QuickBooks. It also provides information on what to do when encountering challenges during the reconciliation process.

     

    Please let me know if you have any other questions or concerns about matching your transactions. I'm always here to assist you. Have a great day!

      Terms & ConditionsAccessibility statement