Matching bank transactions

matt1066webb · ‎December 11, 2018

I often send multiple invoices for the same amount in a given billing period. Some customers allow me to run ACH charges against their bank accounts, some allow me to run their credit cards, and others pay with their own credit cards.

When I download charges from Chase Bank, I often can't tell which cleared charge matches with which transaction in my Quickbooks register. I have looked at the Batch ID on the Quickbooks Merchant website and the reference numbers on the Chase website but nothing matches.

Can anyone help with this?

PreciousB · ‎December 11, 2018

Good day, matt1066webb.

Let me help match your bank transactions to the transactions in your QuickBooks Online (QBO) register.

If you created transactions (payments or deposits) before downloading transactions from your bank, QBO tries to match them with the downloaded transactions. If QBO can't find a match, you can double-check the transactions and make sure they have the same amount, payment method and transaction date.

You can also sign in to your Merchant Service Center account and search for transactions. You can then click the Transaction ID to display a detailed view of a transaction.

Here's how:

Sign in to the Merchant Service Center.
From the Activity & Reports menu, select Transactions.
Choose the Show advanced options, which allows you to do a more specific search using information like transaction ID and expiration date of the card.
Select Search.
Choose the Transaction ID to display a detailed view of a transaction (see screenshot below).

Check out this article for more details: Search for transactions in the Merchant Service Center.

The transaction details in the Merchant Service Center can help you match to the bank transactions from Chase.

Please reach out to me if there is anything else you need about QuickBooks Online. I'd be happy to help. Have a lovely day.

matt1066webb · ‎December 12, 2018

Thank you for the response but I don't think this solves my problem. The problem I am having is that the reference number provided on my Chase website bears no relation to the reference numbers that appear on the Quickbooks Merchant Service Center website. So I can't match the transactions, except by guessing based on the dates or transaction amounts, which unfortunately are often the same for difference invoices.

Charies_M · ‎December 12, 2018

Thanks for keeping us posted and clarifying things out, matt1066webb.

I want to make sure you'll be guided to the right support.

To match those bank transactions from your Chase bank with QuickBooks Merchant, we'll need to pull up your account in a secure environment. With this, I'd recommend contacting our QuickBooks Merchant Services Team. They have the proper tools to be able to assist you in matching those transactions from your Chase bank with QuickBooks Merchant.

You can reach our Merchant Services Team through this link: Merchant Support.

Keep in touch if you have any other questions with matching bank transactions. I'd be glad to answer them for you.

Topics

Training

Community

Resources

Matching bank transactions