Wells Fargo is using a technology called Web Connect. This technology automatically launches QuickBooks, downloads account data into your check register, and automatically matches any transaction you have already entered into your register. Show
Then follow the directions below based on your software type. For information on supported and retired versions of software, please refer to our retirement guide. Windows:
Mac:
Connecting your bank account to QuickBooks Online allows you to access and record banking and credit card transactions in your check register feature in QuickBooks. The days of manually entering every transaction into your accounting software are over. Bank feeds allow your banking and credit card transactions to be reconciled and reported in a more efficient manner. What is the QuickBooks Online bank feed?The QuickBooks Online bank feed allows you to track and manage your receipts and expenses without having to manually input every bank transaction. You can use the QuickBooks Online bank feed to sync your banking transactions to QuickBooks Online. With this one-way channel of communication, records in QuickBooks Online will not be exported to your bank or credit card processing company. Whether you have cash deposits or withdrawals, online payments, debit card charges, transfers, or loan payments, all banking transactions can be imported in the QuickBooks Online bank feed. While you access your online bank statement transactions and online credit card transactions, QuickBooks Online bank feed helps record, report and analyze the same transactions without manual entry. This feature saves time and money, as bank feeds are automated. Make sure your bank accounts, including your merchant accounts, are connected to a version of QuickBooks, and the Banking feature becomes a helpful tool in your recordkeeping and reporting. Importance of managing bank feedsSince bank feeds allow inflow and outflow transactions from your bank to be downloaded and imported directly into accounting software, bank reconciliation has become less time-consuming. Bank reconciliation is an important process in accounting – it allows transactions to be checked for accuracy and be recorded within the appropriate accounting period. Business owners can use bank feeds to efficiently reconcile their bank and credit card transactions, leaving more time for other business duties and responsibilities. Managing bank feeds is important to ensure your transactions are accurate. Aim to ensure the financial integrity of your business. How to manage QuickBooks Online bank feedsQuickBooks Online bank feeds provide an intuitive sort-and-store function for your business’s financial management. Here is how easy it is to manage QuickBooks Online bank feeds. Once you’re in the Banking tab in QuickBooks Online, access and select your connected bank account or credit card. Once that’s done, your page should look similar to the illustration below. When you’re in the banking page, you’ll see a list of transactions at the bottom that need your attention. Here is how to manage your bank feeds: 1. Access the For Review tab.Within the For Review feature, transactions have been imported from your bank feeds, but have yet to be matched, added or excluded from QuickBooks transactions. You will want to review all transactions for accuracy – dates, amounts, vendors – and Match, Add or Exclude them as noted in step 2. 2. Match, Add or Exclude all transactions.Matching a transaction means you already have a record of that transaction in QuickBooks. Simply match the import from your bank or credit card to your QuickBooks register. QuickBooks Online populates suggested matches. Double-check the information, and if the data is accurate, simply click Match. Adding a transaction means you have not created a record of the transaction in QuickBooks. Click Add to include the new transaction in the QuickBooks Online check register. The only requirement to add a new transaction is to select the appropriate category from your existing chart of accounts. [Read related article: Small Business Accounting Checklist] When youexcludea transaction, it simply means the information will not be included in your check register under QuickBooks. Generally, the need to exclude a transaction is unlikely if you keep your business transactions separate from your personal transactions. However, you might use the Exclude function if you have a transaction that corrects a previous error in reporting. How to create bank rules for QuickBooks feedsIt’s no secret QuickBooks is the best accounting software. QuickBooks Online makes accounting and financial management far more efficient for small business owners and accountants. An advanced feature of bank feeds makes recording or excluding expenses more streamlined. Bank rules allow you to categorize recurring transactions, whether the recurring transaction is the same amount or not. Here is how you can create bank rules in QuickBooks Online: 1. Click on the Banking tab. 2. Once you’re in Banking, select Rules. 4. In the “What do you want to call this rule?” field, include a description, such as Cell Phone Bill – US Cellular. 6. After you have selected “Money out” or “Money in,” the next dropdown will prompt you to choose “All bank accounts” or “Cash” to which you will apply the rule. (Your accounts will be tied to this prompt, as illustrated in the second screenshot below.) 7. In the next field, select whether the transaction meets all or any of the following three conditions. If you select All, the transaction must match all of the items in the following functions. If you select Any, the transaction must match one of the three items in the following functions. 8. You can create a rule based on the description, bank text or amount. Select one of the three options. 9. The next function is to select Contains, Doesn’t Contain or Is Exactly. You are not limited to one condition. The following photo shows what it would look like if you wanted to add an additional condition to your bank rule. 10. The next step is to Assign or Exclude. Generally, if you’re creating a rule, you’ll assign the rule for specific transactions. You could also automatically exclude specific transactions from your bank feeds moving forward. 11. Next, specify the transaction type as expense, transfer or check. 12. Select a category. The Category dropdown features dozens of popular business options. You can always add an option if the populated list does not contain what you’re looking for. 13. Add your payee if it is not already showing on the list. If you would like to tag the transactions, you can complete any tags in the final prompt. Prioritizing multiple QuickBooks Online bank rulesOnce you become familiar with creating QuickBooks Online bank rules, you will want to prioritize them. Under Banking and Rules, you will see a list of the bank rules you created. Since QuickBooks Online can only apply one rule per transaction, you will need to prioritize your bank rules by moving the most important bank rule to the top, followed by the second most important rule. Where can I access downloaded transactions bank feed in QuickBooks Online?Go to Bookkeeping then Transactions then select Banking (Take me there), or go to Bank transactions (Take me there). Go to the Banking tab. Select tile for the bank or credit card account you downloaded the transaction from.
How can you view all downloaded Banking transactions for which QBO thinks it has found a potential match?To view or accept the match, select Banking from the left menu. If QuickBooks has found a possible match for the bank transaction, QuickBooks displays an outlined green box under the Category or Match column that says 1 record found message to the matching transaction.
Where can I find bank transactions in QuickBooks Online?Search for transactions using the magnifying glass. Select the Magnifying Glass.. Enter the date, amount, or transaction number you're looking for, then select the desired transaction.. If the transaction you're looking for does not appear on the results list, select Advanced Search.. Can you download transactions in QuickBooks Online?When you connect a bank account to online banking, QuickBooks Online automatically downloads transactions every night. If you don't want to wait for the scheduled download, you can refresh the connection to get the latest available transactions.
|