Mastering Bank Feeds in QuickBooks Online: A Step-by-Step Guide
Managing bank feeds in QuickBooks Online (QBO) is essential for keeping accurate financial records, streamlining transaction categorization, and ensuring real-time financial visibility. In this guide, we’ll walk you through the key aspects of managing bank feeds, including how QuickBooks processes transactions, matching deposits, using bank rules, and handling receipts.
Understanding the Bank Feed Review Tab
The For Review tab in QuickBooks Online is where transactions imported from your bank appear before being recorded in your financials. Until these transactions are reviewed and categorized, they are not included in your company’s books. QuickBooks allows businesses to manage transactions daily, providing an up-to-date financial snapshot rather than waiting for month-end reconciliations.
How QuickBooks Analyzes Bank Feed Transactions
QuickBooks processes transactions in three primary ways:
- Matching Transactions: If a transaction from your bank matches an existing entry in QuickBooks, the system suggests a match. This helps prevent duplicate entries and ensures the accuracy of financial data.
- Applying Rules: If no exact match is found, QuickBooks checks for predefined rules to categorize transactions based on vendor name, amount, or other factors.
- Suggesting Categories: If neither a match nor a rule applies, QuickBooks suggests a category based on past transactions. However, always review and verify these suggestions before accepting them.
Trust but Verify
While QuickBooks provides automated suggestions, it’s crucial to verify each match or categorization to avoid misclassifications or errors.
Matching Deposits and Transactions
QuickBooks differentiates between exact matches and linked matches when reconciling transactions:
- Exact Matches: When a transaction recorded in QuickBooks (such as a payment or expense) perfectly aligns with a bank feed entry (same date, amount, and payee), QuickBooks automatically suggests a match. Accepting this match moves the transaction from the For Review tab to the Categorized tab without creating duplicates.
- Linked Matches: When a related but incomplete transaction exists (e.g., an unpaid bill that has now been paid), QuickBooks creates the necessary linked transaction (e.g., a bill payment) and connects it to the bank feed entry.
Processing Receipts in QuickBooks Online
Clients can upload receipts via the QuickBooks mobile app or email. QuickBooks attempts to match these receipts to existing transactions. If no match is found, users can create a new transaction using the uploaded receipt.
- Matching Receipts: QuickBooks first searches for an existing transaction that corresponds with the receipt.
- Adding New Transactions: If no match is found, a new expense transaction can be created using the details on the receipt.
- Managing Bulk Receipts: Clients can store their receipts digitally within QuickBooks, eliminating the need for physical storage and improving record-keeping.
Setting Up and Reviewing Bank Rules
Bank rules help automate transaction categorization. QuickBooks applies these rules in sequential order, meaning that rule #1 is checked first, then rule #2, and so on.
- Customizing Rules: Users can modify and rearrange rules to prioritize certain conditions.
- Filtering Transactions: You can filter transactions to display only those with rules applied, making it easier to review and approve them in bulk.
- Undoing Rule-Based Transactions: If a rule miscategorizes a transaction, users can undo it and reassign the correct category.
Pairing Transactions Between Accounts
When two connected accounts (e.g., a business checking account and a company credit card) interact, QuickBooks identifies and pairs related transactions, ensuring accurate bookkeeping. For instance:
- A payment from checking to pay a credit card balance is recorded as an expense in the checking account and a payment in the credit card account.
- QuickBooks detects both sides of the transaction and marks them as paired, simplifying reconciliation.
Managing Money-Out Transactions
Expenses and bill payments are often straightforward to categorize. Key considerations include:
- Filtering Recognized Transactions: Use filters to first handle transactions that have matches or rules applied before addressing uncategorized transactions.
- Date Range Adjustments: If a check was written weeks or months before clearing, expand the date range to find potential matches.
- Avoiding Duplicates: If a transaction appears duplicated, check whether it was entered in the wrong account before assuming a system error.
Adding Transactions Manually
For transactions not automatically recognized, users can manually enter details, ensuring accuracy by:
- Selecting the correct vendor.
- Assigning the appropriate category.
- Attaching supporting documentation, such as receipts or invoices.
Managing Money-In Transactions
Money-in transactions (deposits) are often linked to invoices, sales receipts, or undeposited funds. To ensure accurate reconciliation:
- Match Deposits Correctly: Ensure that deposits correspond to the correct invoices or sales receipts.
- Use Undeposited Funds: For grouped deposits (e.g., multiple checks deposited together), use the undeposited funds account to align individual payments with the lump sum deposit in the bank feed.
Final Thoughts
Effectively managing bank feeds in QuickBooks Online ensures up-to-date financial records, reduces manual errors, and improves financial oversight. Businesses can streamline their bookkeeping process by leveraging QuickBooks’ matching, categorization, and rule-based automation. However, always trust but verify to maintain accuracy and avoid potential issues.
Contact our expert team at VirtuCount Bookkeeping, Accounting, & Tax if you need further guidance on optimizing your QuickBooks Online setup.
Don't wait Another Minute
