Bank Feed Matching

Good to see you here, Squeegeepuller.

I can help you match your bank downloaded transactions.

If transactions don'ts show in the list posted in your Match transactions window, ensure that the date range you set is within the invoice date. Under the Show drop-down, you can also select the type of transaction you want to match the amount to.

If the transactions you'll need to match don't have the same amount, you can resolve the difference and categorize it. If you're trying to match $1,344.38 with $893.88, you'll have to resolve the $450.5 difference. Here's how to do that: 

1. Go to the Banking or Transactions menu.
2. Select the bank and click on the transaction to match. Then, Find match.
3. Enter the date range and select the sales receipt to match.
4. Toggle the Resolve Difference option and then enter the details in the Add resolving transactions. 
5. Once done, click Save.

Some banks add service charges and processing fees. If the bank transaction was already deducted by the charges, you can make bank deposits and include bank or processing fees.

I'm attaching the How to Reconcile an Account in QuickBooks Online article for detailed instructions on the process that you can use in the future.

Please know the Community has your back. I’ll be right here to assist further. Take care!

Hi,

You can see in the image that the date range is set properly.  Also both are set to show all.  So it seems like there is no reason for this not to show up.

As for the difference there is another transaction that we will be matching that we can see.  But can't do anything unless we can match the $1,344.38.  So the difference will be made up.

Hello @Squeegeepuller,

I appreciate you for getting back to us here in the Community. Allow me to step in and provide some information that will help you with matching bank transactions in QuickBooks.

The Find Match tool can only show sales receipts not greater than the deposit amount. That's the reason why you're unable to match it with the transaction amounting to $893.88 in bank feeds.

I recommend excluding the downloaded bank data to avoid duplicates in QuickBooks. You usually use the Exclude option if there are two transactions involve or payments have been reconciled.

In case you need the steps, here's how:

1. On the left navigation bar, click Banking.
2. Select an account.
3. Go to the For review tab.
4. Put a checkmark on the transactions you want to exclude.
5. Hit Exclude. 

Also, here are the other reasons why our system is unable to recognize the match in QuickBooks:

• The transaction is older than 180 days
• The dollar amount in QuickBooks is different than what cleared the bank.
• The transaction type is different in QuickBooks than at the bank. QuickBooks wants to match a check with a check and an expense with an ACH or debit/credit card swipe.
• The transaction was recorded in a different bank account (see Tip #4)
• The transaction from the bank is a payment/ deposit of two or more open transactions in QuickBooks.

For additional reference, you can use this link to learn more about how to review multiple matches in bank feeds: Categorize and match online bank transactions in QuickBooks Online.

Feel free to hit that Reply button if you need more help handling downloaded banking data in QuickBooks. Have a great day ahead.