Call QuickBooks Support and know how to add match Bank Feed Transactions in QuickBooks

In this article you will learn how to add and match bank feed transactions in QuickBooks. To know more, contact QuickBooks Support.

In QuickBooks Desktop, two Bank Feeds modes are available. Each mode displays and handles transactions differently.

Read the article further to know more about switching between banking modes in QuickBooks Desktop.

How to add and match bank feeds using Express Mode?

Step 1: Getting the downloaded transactions

• Firstly, go to the Banking menu.
• Click on Bank Feeds and then select Bank Feeds Center.
• Now you will review how QuickBooks categorized the transactions, to review follow the steps given below:
• (Your review required) Unmatched: In the related account in QuickBooks, the downloaded transactions don’t match any transaction.
• (Changed made in Rules) Renamed: A new transaction using renaming rules is created in QuickBooks. Any transaction in the related account in QuickBooks doesn’t match the downloaded transaction.
• (Auto) Matched: A match is found by QuickBooks between the downloaded transaction and the other transaction that is already in the related account.

Step 2: Matching the downloaded transactions

Any entries that are already in the related account, QuickBooks tries to match them to the downloaded transactions. QuickBooks tries to create a new transaction for you automatically if it can’t find a match. You need to review the matches before adding them to the register.

When QuickBooks tries to match it looks at the following:

Check numbers: whether the numbers match or not.

Amounts: Whether amounts are the same or not.

Date of recording the transaction in QuickBooks within a few days of the downloaded transaction clearing the bank.

Payees: It checks whether the payees are the same. If not, the payee in the downloaded transaction is identified by a renaming rule.

Make sure you make the connection if you know there’s a matching transaction in QuickBooks. Else, your bank won’t have a match the downloaded transaction and will remain pending. Even if the payment has been processed by your bank you will need to make the match.

You don’t need to do anything else to the transaction if you agree with the match QuickBooks made. When you select Finish Later, the matches will be made and added to the account register.

Unmatch the transactions if you don’t agree with the match. When you do this, the status of the downloaded transaction will change to Unmatched.

When you are unable to find a match

Here’s what to do when QuickBooks can’t find a matching transaction for one downloaded from your bank:

You may not have entered them into QuickBooks yet if transactions are too new. Enter the transactions into QuickBooks if this is the case. By doing this you may change the status of the downloaded transaction to Matched.

QuickBooks won’t match them if a downloaded transaction matches an already reconciled transaction. In the CLR column, there is a reconciled transaction having a checkmark.

There are occasions, though they are rare but may occur when QuickBooks downloads duplicate statements or transactions. The transactions won’t be matched again if transactions were downloaded to QuickBooks and have a lightning bolt in the CLR column. QuickBooks won’t match them even if the transaction number, amount, date and payee name are the same.

How to add and match bank feeds using the Classic Mode?

You need to match the transactions to the ones in QuickBooks after you download your electronic bank statement. This way, you can specify what transactions your financial institution has processed and the ones which haven’t cleared the bank yet. Read further to know how.

Step 1: Getting the downloaded transactions

• In the Banking menu, select Bank Feeds and then Bank Feeds Center.
• Open the Match Transactions window.
• Make sure the correct bank account is showing from the Financial Institution dropdown
• Click on View.
• Download the electronic statement.
• Make sure the Show Register checkbox is selected from the Match Transactions window.
• You’ll see the results once QuickBooks finishes matching your transactions.
• To close the window, click on OK.
• QuickBooks has assigned each statement a status, review it and decide what to do.

Step 2: Matching the downloaded transactions:

• The transaction in the electronic statement needs to be matched with the ones you’ve entered in QuickBooks.
• There’s nothing you need to do if you agree with the match.
• Unmatch the transactions if you don’t agree with the match.
• In case of Unmatched transactions, the transaction in the electronic statement doesn’t match to the transaction in the account for QuickBooks. This can happen due to a few reasons:
• You’ll need to add the transaction to QuickBooks if the transaction hasn’t been entered in QuickBooks yet.
• A typo or was entered into the wrong account but the transaction has been entered.
• Correct the transaction in QuickBooks in case this happens, so that it matches the one in the electronic statement.
• Create an alias for the name in the electronic statement to a name if they don’t match because of the payee.
• You can match the transactions manually also.
• If the transaction in the statement is wrong and the financial institution made a mistake.
• The statement is deleted from the Items Received section of the Bank Feeds Center when all the transactions in the electronic statement have been matched or added to QuickBooks
• Match the transactions in electronic statements to ones In QuickBooks manually.
• In an electronic statement with the transaction in QuickBooks sometimes QuickBooks may not match a transaction. You can manually match the two if this happens. Here’s how you can do the same.
• In the Banking menu, select Bank Feeds and then Bank Feeds Center.
• Open the Match Transactions window. Make sure the correct bank account is showing from the Financial Institution dropdown
• Click on View.
• Download the electronic statement.
• Make sure the Show Register checkbox is selected in the Match Transactions window.
• You need to match to a transaction in the register, select the transaction in the statement.
• In the register to match to, select the transaction. Make sure that your amounts match.
• Click on Match.

 Understanding the status of symbols

• To represent the three states of a transaction, QuickBooks uses three distinct symbols.

On-screen:

* Cleared, but not reconciled yet.

• You will see a checkmark when reconciled.
• You will see a Lightning bolt when matched to an online bank statement

In case of Printed Report:

• You will see a cleared, but not yet reconciled
• You will see a Letter X when Reconciled
• You will see a Letter M when matched to an online bank statement

Follow the steps to review downloaded transactions:

• Whether the transactions are already entered in QuickBooks?
• If No, assign the payee and appropriate account(s). To add to bank register in QuickBooks then save, add, or confirm.
• Payee is the name of the person or institution you paid.
• In the the Action dropdown, select Quick Add to add a single transaction.
• Now, in the Batch Action dropdown, select Add/Approve (if you want to work on multiple transactions and add them all at once.)

Please Note: The memo field auto-fills on your check even if you leave it blank when downloading and matching transactions from the bank. This is set by a bank as default and setup it in its system.

• Turn on the preference if you want to Pre-fill accounts based on your past entries or adding multiple transactions
• Select the Edit menu, from the Home screen.
• Click on Preferences.
• Click on the General tab.
• Select the My Preferences tab on the right pane.
• Click on the Automatically Remember account or transaction information checkbox.
• Click on OK.
• If Yes, then Continue.

How were the transactions entered?

• When you have entered a bill and a corresponding payment for the same in QuickBooks.
• The bill payment should match automatically. In the Transaction List window, you can choose from the following options.
• Select approve if you agree with the match. The transactions have the thunderbolt symbol when you view the transaction in the Register.
• If you don’t want to delete transactions select ignore.

Please Note: If the amount, date, or check numbers match an existing transaction in QuickBooks, Checks (CHK) and deposits (DEP) may also match.

• In QuickBooks, you have entered a bill but not the payment for it
• Then, select the transaction.
• Select Bills to Mark as Paid from the Action dropdown
• Select the vendor name and the date on the Transaction Details window
• Select the matching bill in the Open Bills for the selected vendor section. QuickBooks shows the Matched and the Difference remaining as 0.00 when you select the match.
• Select Add to QuickBooks when everything matches.

Please Note: This feature works with transactions that are downloaded from bank accounts only. From a downloaded credit card charge, you can’t create a bill payment.

• In QuickBooks, you have already entered a transaction (Check or Deposit)
• Choose the appropriate transaction (CHK/DPT). From the Action dropdown select one of the following:

Add More Details: In case you wish to add the Payee, Account, and other information like Customer Job if you are tracking billable expense.

Match to an existing transaction: With the check you know you previously entered in QuickBooks match the transaction that is downloaded.

When you have entered an invoice and received payment for it

Click on the appropriate transaction (DPT). Then choose any one of the following from the Action dropdown:

Add More Details: Select this option if you need to add more details. Go to the un-deposited Funds tab if you have received payment and want to link the transaction. Find the transaction that matches. Go to the Open Invoices tab if you need to look for the invoice that goes with the downloaded deposit. To show the invoice was paid, QuickBooks will link the invoice and the payment.

Match to an existing transaction: With the check you know you previously entered in QuickBooks match the transaction that is downloaded.

In case you have recurring transactions or multiple transactions with the same amount and date.

• If No, no action is needed.
• If yes, then you may need to match downloaded transactions on your online banking statement with transactions in QuickBooks Desktop manually.

In case you want to create Renaming Rules for commonly downloaded transactions.

• If No, no action is needed.
• If yes, you will have to create renaming rules from scratch:
• In the Bank Feeds Center, select the Rules icon.
• Click on the Manage Rules dropdown, and then choose New or Edit Rule.
• Give the rule a name and set the conditions on the Add Rules Details window.
• Add or remove conditions for descriptions in the When section.
• Rename payees and/or add categories for accounts in the Do this section.
• You can create renaming rules automatically also, follow the steps given below:
• In the Preferences tab, select the Checking tab.
• Click on Company Preferences tab. Choose Express Mode and then click on the checkbox besides, Create rules automatically and always ask before creating a rule checkboxes.
• Add a payee in the Banking Center from the transaction list and then add the account to register.
• You’ll receive a Rules Creation pop-up to ignore or Edit the rule if you have multiple transactions with the same criteria.

Please Note: Before matching or choosing Add/Approve from Batch transactions, always review transactions changed by rules.

In case you need to undo incorrectly renamed transactions.

• If No, no action is needed.
• If yes, you can restore a backup prior to the downloaded transactions being entered. You can also manually edit each transaction.

In case you need to delete unmatched transactions from your Bank Feeds.

• If No, no is action needed.
• If yes, you will have to delete the unmatched transactions in Express mode.
• Click on the appropriate transaction.
• Select Ignore from the Action drop-down. By doing this you can remove the single transaction from the Transaction list window.
• Select the checkbox for the transactions you want to remove to remove multiple transactions at once. Select Ignore, from the Batch Actions drop-down.

To know more on how to add and match bank feed transactions in QuickBooks desktop, call on our QuickBooks Support Number. You can also write to us at support@quickbooksupport.net . For more information visit – www.quickbooksupport.net.