How to Add and Match Bank Feed Transactions in QuickBooks Desktop (Windows & MAC)

September 16, 2024

Any firm that wants to succeed must have effective financial management. With its Bank Feeds function, which enables users to import bank transactions straight into the program, QuickBooks Desktop streamlines this procedure. Once imported, adding new entries or matching these transactions to records already in existence will be a breeze. You may add and match Bank Feed transactions in QuickBooks Desktop on both Windows and Mac platforms by following the instructions in this article.

The Advantages of Matching Transactions

Businesses may reap several advantages from matching transactions in accounting, particularly when employing software such as QuickBooks. The following is a breakdown of the primary advantages:

1. Enhanced Accuracy

Reduce Mistakes: You may reduce the possibility of manual input mistakes and make sure that your books accurately reflect your genuine financial situation by cross-referencing transactions with bank information.

Avoid Duplicates: By preventing duplicate transactions from being entered, matching helps to clarify and skew your financial results.

2. Saves Time

Automated Matching: Accounting programs such as QuickBooks frequently automatically match transactions, save you the time-consuming task of manually reconciling each transaction.

Streamlined Workflow: You may concentrate on more important activities since once a transaction is matched; there is no need for additional review or input.

3. Better Cash Flow Management

Real-Time Insight: You may obtain the most recent picture of your cash flow by routinely matching transactions. You have complete visibility over the inflow and outflow from your accounts.

Find Missing Transactions: Matching can assist you in promptly locating any missing payments or deposits from your data.

4. Makes Bank Reconciliation Easier

Quicker Month-End Close: By aligning transactions, you may expedite the monthly reconciliation process and cut down on the time it takes to close your books.

Clear Audit Trail: Matching transactions facilitates audits and reviews by making it simpler to trace the origin and history of payments.

5. Reduction of Fraud Risk

Early Discrepancy Detection: By routinely comparing your transactions, you may lower the chance of fraud or theft by rapidly identifying any unauthorized transactions or anomalies.

Improved Oversight: It’s simpler to identify odd or suspicious conduct when transactions are compared to your bank records.

6. Better Data Reporting

Accurate Reporting: Your profit and loss accounts and balance sheets, among other financial reports, are more accurate and dependable when transactions match.

Current Information: You may create financial reports with confidence at any time since matching guarantees that your records represent facts as of right now.

7. Improved Connections with Vendors and Customers

Precise Invoicing and Payments: Matching helps to reduce inaccuracies in invoicing and payment by guaranteeing that payments are accurately tallied with invoices. By preventing disagreements over payments, this improves relationships with suppliers and clients.

Effective Invoice Processing: Quick invoice closure is guaranteed by an automatic system that compares bank deposits to client payments.

8. Complying with Tax Laws and Being Ready

Ease of Filing: Preparing taxes is made easier by matched transactions, which produce an accurate and transparent financial history. Maintaining precise documentation lowers the possibility of mistakes during tax filing.

Compliance Ready: It’s simpler to abide by tax laws and get ready for any audits when you have accurate, matching data.

9. Encourages Expansion and Reduction in Size

Effective Operations: Handling transactions by hand is too much for growing organizations. By streamlining procedures, matching transactions enables companies to grow without being constrained by ineffective bookkeeping.

Perceptive Analytics: Precise documentation originating from corresponding transactions facilitates enhanced financial evaluation, assisting companies in making well-informed choices regarding growth and capital expenditures.

The Process to Add and Match Bank Feed transactions in QuickBooks Desktop (Windows)

There are three different Bank Feed choices in QuickBooks Desktop. Every one manages and presents transactions in a unique way. QuickBooks compares the check numbers, amount, date, and payer to see whether there is a match. This post is a part of a series on QuickBooks for Windows Bank Feeds. You must first set up Bank Feeds in QuickBooks Desktop before you can add and match transactions.

1. Steps to Configure Bank Feeds on Windows

You may link your bank and credit card accounts to online banking in QuickBooks Desktop by using Bank Feeds. To create an account, there are two methods. Direct Connect and Web Connect are two options for connecting. What your bank offers will determine how you connect.

Use Direct Connect to Establish a Connection.

To utilize this approach, you will need your bank’s PIN or password. You may download your electronic statements to your bank feeds once the account is set up. QuickBooks creates a Bank Feeds account automatically the first time you download transactions. Check with your bank to see whether there is a cost or if the service is free before proceeding.

  • Navigate to Bank Feeds from Banking.
  • For an account, choose Set up Bank Feeds.
  • Enter and choose your bank in the Enter the name of your bank section.

Choose the Enrolment Site link if this is your first time enrolling. You might have to submit a Direct Connect application. Get in touch with your bank if they need to accept your application. Enquire if you require any unique login credentials.

Following Enrolment:

  • Click “Continue.
  • Enter your password and user ID for online banking.
  • To link your QuickBooks to the server at your bank, select Connect.
    Choose the bank account that you wish to link to your QuickBooks account.
  • When the connection is complete, select Finish.

Using Web Connect (.QBO) Files to Connect

You can obtain a file (.QBO) containing your company’s transactions from your bank or credit card if your bank does not allow direct connect. You next import the file into QuickBooks in order to add those transactions to your accounts.

If your bank provides Web Connect:

  • Click on Bank Feeds from Banking, then click Import Web Connect Files.
  • After choosing the.QBO file you saved, click Open.
  • When prompted to choose a bank account: If the account into which you are importing transactions is already configured in QuickBooks, use that existing account.

If the account into which you are importing transactions is not yet in QuickBooks, create a new one.

  • Click “Continue.” A dialogue window indicating that the data has been successfully read into QuickBooks will appear. Click OK.
  • Visit the Bank Feeds Centre to examine the transactions you entered.

2. Steps to Download Bank Feed Transactions

You may begin downloading transactions from your banks once you’ve configured your accounts for bank feeds. Here are some points to remember:

  • Make a backup of your QuickBooks company file before starting the download.
  • Transactions cannot be downloaded more than once into a single QuickBooks Desktop company file.
  • To enable QuickBooks to download the transactions once more, your bank might be able to reopen the transactions on their end. Contact your bank for assistance if you require it.
  • Only.qbo files are compatible with Web Connect. Quicken files of other kinds, such as QFX and QIF, won’t function. A few third-party apps that are available on the Intuit Marketplace are capable of handling QIF.

One of two download options for transactions is provided by banks. Choose the download option to find out how to utilize them.

  • Direct Connect
  • Web Connect

Utilizing Direct Connect

Upon first connection, QuickBooks will automatically download the maximum number of transactions from your bank. This can provide you with a history of transactions going back up to a year, depending on the bank. Most banks only allow you to retrieve transactions from the last 90 days.

  • Proceed to the banking area.
  • After choosing Bank Feeds, choose Bank Feeds Centre.
  • Select the account you wish to link from the list of bank accounts. (Details optional) To change or cancel a payment, click the Online Checks link under the Send goods to your bank area.
  • Click on Download Transactions when you’re prepared to get your transactions.

Note: Choose Transaction List if you have already downloaded the transactions but not evaluated them.

  • Choose to Synchronize.
  • Choose Sync this account if you just want to download transactions for that particular account.
  • Choose Sync all for this Bank if you wish to download transactions for every account you have with that bank.
  • To connect to your bank, enter your password or PIN in the Access to window.
  • Click OK.

Note: Any leftover (already matched/added) transactions can be deleted. You are unable to retrieve your downloaded transactions again after you have deleted them. By doing this, duplicate entries are prevented.

Utilizing Web Connect

A few banks allow you to choose a download window. The first time you download, the maximum number of transactions available is automatically downloaded if your bank does not offer this choice. Depending on the bank, this might last for 30, 60, 90, or even longer.

Using Web Connect, there are two methods for importing transactions:

In case you use QuickBooks Desktop

  • Proceed to Banking.
  • After choosing Bank Feeds, choose Banking Centre.
  • Locate and choose to Download Transactions from your bank. This launches a web browser window to the website of your bank.
  • Download the Web Connect file by logging into the website of your bank.

If you’re not using QuickBooks Desktop

  • Go to the website of your bank by opening a web browser.
  • Utilising your standard procedure, log into your bank account.
  • Your transactions can be downloaded as a QuickBooks Web Connect (.qbo) file.

Note: Obtaining QuickBooks Web Connect files differs based on the bank. Check out the instructions on your bank’s website if you’re not sure how to proceed. Ask your bank for assistance if you are unable to locate any.

  • Once you get the Web Connect file, import it into QuickBooks Desktop by following the instructions.

3. Steps to Examine and Match the Transactions

You must compare the transactions on your electronic account statement to those in QuickBooks after downloading it. In this manner, you may determine which transactions have already passed the bank and which ones your financial institution has handled.

Based on data from your bank and QuickBooks, QuickBooks divides your transactions into three groups.

  • Navigate to the Banking section.
  • Choose Bank Feeds and then Bank Feeds Centre to examine each category’s transactions.

Match Transactions for the Mode that You Employ with Bank Feeds.

1. Express Mode

QuickBooks attempts to reconcile transactions from bank feeds with any existing entries in the associated account. QuickBooks generates a new transaction for you if there isn’t a match. Before entering the matches in the register, make sure they match.

The match categories are:

  • (Review needed) Unmatched: No associated QuickBooks account is matched by the download transactions.
  • (Modified By Regulations) Renamed: One of the renaming rules generates a new transaction that is prepared for adding to the register if there is no match.
  • (Auto) Matched: QuickBooks discovered a match between the transaction in the linked account and the one that was downloaded.

There is a checkbox next to QuickBooks matches. Choose Add/Approve or Approve from the Batch Actions or Actions option if you accept the match. If not, the transactions remain unfinished.

Choose Not a match if you disagree with the match. The transaction’s status is updated to Unmatched.

Follow these Steps if QuickBooks is Unable to Locate a Match.

  • Perhaps you haven’t entered it into QuickBooks yet. By doing this, the status ought to become matched.

The transaction may differ in terms of name, date, money, and transaction number. Locate the transaction in QuickBooks and adjust it in accordance with your bank documentation. The downloaded transaction’s status will change to Matched as a result of this. Make sure you’ve located the precise match in QuickBooks before proceeding.

  • QuickBooks will not match transactions if they are downloaded and already reconciled. In the CLR column, the reconciled transaction is marked with a checkmark.
  • QuickBooks may occasionally download duplicate transactions or statements, although this is unusual. Even if all the information is the identical, transactions with a lightning bolt ⚡ in the CLR column won’t match again.

2. Classic Mode

The match categories are:

Match Downloaded Transactions: The transaction you recorded in QuickBooks and the one found in the electronic statement match.

  • You are not required to take any action if you approve of the match.
  • Unmatched the transaction if the match doesn’t sit well with you.

Unmatched Transactions: There isn’t a single transaction in the QuickBooks account that corresponds with the transaction in the electronic statement. Several causes for this include:

  • Perhaps you haven’t entered it into QuickBooks yet. By doing this, the status ought to become matched.
  • There is a mistake or the transaction is in the incorrect account in QuickBooks.
    In QuickBooks, adjust the transaction so that it corresponds with the one shown on the electronic statement.
    Make an alias to a name in QuickBooks in the electronic statement if the name doesn’t match. Manual matching of the transaction is possible.
  • The transaction on the statement is incorrect due to a mistake made by the banking institution.

The statement is removed from the Bank Feeds Centre by the Items Received section once all transactions have been matched or entered to QuickBooks.

3. Advanced Mode

It consists of Acknowledgeable transactions, Transactions that are partially recognized and unacknowledged transactions:

Recognized transactions

The matching status of your transactions is as follows in the Recognized tab:

  • Transactions in QuickBooks that correspond with your bank transactions are known as auto-matched transactions.
  • Rules in Effect: Rules-matched transactions. You can notice the rule when you go over the transactions.
  • Auto-recognized Rule: QuickBooks matched because you have an account assigned for this vendor and the description or downloaded as exactly matched the name.

Examine every transaction, and then choose one of the following actions from the Action column:

  • Approve: This will add the transaction to your register if the transactions match.
  • View Details: present more details on the transaction.
  • Inconsistency: This informs QuickBooks that the transactions are incongruent. The mismatched transactions will revert to the “Need your review” area if there are no more potential matches.

To rapidly match actions to transactions, you can choose Batch Actions for numerous transactions. You may choose a transaction to check the information in QuickBooks if you’re unsure about it.

Partially recognized transactions

These can correspond to several transactions in your account. In QuickBooks, you may choose the most appropriate match from a pre-existing list of transactions.

  • Choose a transaction from the partially recognized tab, and QuickBooks will provide potential matches.
  • After choosing the best match, click Confirm match. Additionally, you can choose from:
  • Disregard: The transaction gets removed from your list as a result. Select the transactions you want to disregard from the Batch Actions dropdown menu after selecting each one individually.
  • Provide further information: By doing this, you may add a new transaction rather than relying on QuickBooks’ ones.
  • Complementary to further transactions: This allows you to choose a transaction to match manually.

Unrecognized transactions

These are the transactions that don’t correspond with any entries in your books or for which there are no applicable regulations.

Choose a transaction from the unrecognized tab, then edit the transaction information, or choose one of the following actions from the Action column:

  • Add: If you don’t need to enter any transaction data or monetary divides between accounts or jobs, this puts it to your register.
  • Provide Further Information: To divide a vendor payment over several customers: job/accounts or a deposit across accounts, you may specify extra data.
  • Complementary to Current Transactions: Track it down and compare it to a previous transaction in your records.
  • To remove a transaction from the list, select Ignore.
  • To add Name, Class, Account, Memo, or Customer: Job and make numerous modifications at once, pick Batch Actions if you have many transactions.

Keep track of credit card transactions.

You will be given the opportunity to record transfers for credit card accounts. This can be used to document a transfer of funds to your credit card from your savings or checking account.

  • Choose the transaction from the Recognized, Partially Recognized, or Unrecognized tab.
  • Then, from the dropdown menu, choose Record Transfer.
  • Choose the account that you sent money from.
  • Select Save and Add to register after completing the transfer details.

Examine the transactions in your register.

Transactions added to the register will show up under Added to register.

  • Select Bank Feeds from the Banking menu, followed by Bank Feeds Centre.
  • Pick the tab labeled “Added to register.
  • Double-click on a transaction to make it open.
  • Change this transaction in any way, including adding attachments.
  • After choosing Save, click close.

4. Manually Match Transactions

There are situations when a transaction in QuickBooks and an electronic statement don’t match. You can manually match it to open or posted transactions if this occurs.

Advanced Mode

You may manually match your transactions to the entries in your books by using the unrecognized tab.

  • Choose Match to existing transactions from the Action column dropdown menu after completing the transaction.
  • Locate and pick the corresponding transaction, then choose to add it to the register and save it.
  • Choose Resolve to split entries to balance the remaining amount if the amounts don’t match. Resolving split entries for payments and deposits can also be added to an already-posted transaction.
  • You can change the amount beneath the To Pay column to reflect a complete or partial payment if you’re matching a money-out transaction to a bill.
  • When you’re prepared, add the transaction to your books by choosing Save and add to register.

Express/Classic mode

  • Select Bank Feeds from the Banking menu, followed by Bank Feeds Centre.
  • Verify the right bank account is displayed in the Financial Institution choice when you open the Match Transactions pane.
  • Choose View.
  • View and download the statement in electronic format.
  • Please confirm that the Show Register checkbox is checked in the Match Transactions window.
  • To match a transaction in the register with a transaction in the statement, choose the relevant transaction.
  • Next, choose the register transaction that you want to match. Verify that the quantities correspond.
  • Choose Match.

The Procedure to Add and Match Bank Feed Transactions in QuickBooks Desktop (Mac)

Discover how to add and match transactions that you have downloaded using QuickBooks Desktop for Mac. Some of the transactions may already be in your register when you download them from your bank. You can locate both new and old transactions more easily with QuickBooks before adding them to your register.

QuickBooks attempts to correlate comparable entries in your register with the transactions you download. QuickBooks designates a transaction as matched if it discovers a match. If not, it’s unrivalled. Here’s how to make sure that every transaction you downloaded is accurately added to your register.

Combine and Align transactions

The check number, amount, date, and payee name must match those of the QuickBooks transaction in order for there to be a match. The transaction may be new, reconciled, or the information may not match if you are unable to find a match.

  • Navigate to Banking and click on Downloaded Transactions.
  • Choose an account in the QuickBooks Account window if you have several accounts.
  • Choose the transactions in the register that you want to match as well as the ones that aren’t matched.

Note: Transactions that are matched have an orange circle adjacent to them.

  • Choose “Match.”
  • Click Add One to add a new transaction, or Add Multiple to add multiple.
  • Moreover, you can establish payee renaming guidelines. If a payee from your downloaded transactions shares the same name as one of your vendors, this facilitates the matching of transactions.
  • After entering the necessary data, click Record.

Conclusion

QuickBooks Desktop, available for Mac and Windows, makes it incredibly easy for businesses to add and match Bank Feed transactions, which streamlines their financial management process. You may reduce mistakes and save time by entering and reconciling transactions more quickly by utilizing the Bank Feeds functionality. Your QuickBooks records will always be correct and up to date with constant administration, freeing you time to concentrate on other crucial facets of managing your company.

_______________________________________________________________________________

Frequently Asked Questions

What happens if a Transaction isn’t Automatically Matched by QuickBooks?

In the event that QuickBooks is unable to locate a record for the transaction, it will stay unmatched. By classifying and allocating the transaction to the appropriate account, you may either manually search for a match or add the transaction as a new record.

Is it Possible to Set Rules for Transactions to be Automatically Categorized?

Yes, rules for repeating transactions may be defined in QuickBooks Desktop (Windows and Mac). Based on parameters like the payee’s name, the kind of transaction, or the amount, these rules will automatically classify and match transactions.

If I make a mistake, can I Reverse a Matched Transaction?

In QuickBooks Desktop, a matched transaction can indeed be reversed. To unmatched a transaction, locate it in the Bank Feeds Centre, select Undo Match. You may then add it as a new transaction or fix the match.

Is it Possible to utilize numerous Bank Accounts in QuickBooks Desktop with Bank Feeds?

Yes, you may utilize Bank Feeds in QuickBooks Desktop to set up and manage numerous bank accounts. Every account will have a unique feed, and each transaction may be uploaded, matched, and examined independently.

 

close btn

Get Your Case Study

Call Now +1-800-596-0806
Top