Regardless of the nature of your business, whether you are a wedding planner or a general contractor, connecting your business bank and credit card accounts to QuickBooks Online is a valuable resource for recording business income and expenses. Having a direct connection between QuickBooks Online and your business bank and credit card accounts can save you several hours of manual data entry time each week. This wonderful feature pulls in charges, payments, transfers, and deposits into your QuickBooks Online bank feeds so that you can routinely categorize and add them to your account registers. Having a connection ensures that you never miss recording a transaction in your books.

Bank Feed

Lend A Hand Accounting makes it easy for you to tell us about certain purchases and expenses. We use advanced, proprietary technology to connect to your QuickBooks Online account, which helps you to quickly categorize expense transactions.

Check out the video to the right to learn more about how we help categorize your expenses in QuickBooks Online!



Save Time Reconciling Your Accounts and Preparing Your Financial Reports in QuickBooks Online

Most of the time you save with connected bank feeds is in reconciling accounts and preparing financial reports. The QuickBooks Online bank feeds allows you to match every withdrawal and every deposit that is referenced on your account statement before you reconcile. You will have already matched your customer invoices payments, sales receipts, and vendor bill payments. You will have categorized your bank and credit card expenses and recorded your balance sheet account transactions.


Create Sales Receipts to Match Bank Feed Deposits in QuickBooks Online

You will need to create “matching” entries in QuickBooks Online for Sales Receipt deposits that come into your bank feed. If you create multiple sales receipts per day, you will want to deposit them to the “Undeposited Funds” first. The example below went directly to the bank account because it was the only sales receipt created that day.

Match Sales Receipt
Sales Receipt Example

Create Invoices and Payments to Match Bank Feed Deposits in QuickBooks Online

You will need to create “matching” entries in QuickBooks Online for invoices and Payments when the deposit comes into your bank feed. If you receive multiple invoice payments per day you will want to deposit them to the “Undeposited Funds” first. The example below went directly to the bank account because it was the only invoice payment received that day.

Invoice Match
Invoice Payment Example

Create Bank Deposits to Match Bank Feed Deposits in QuickBooks Online

Remember that if you have more than one sales receipt or more than one invoice payment per day, they are to be received to the “Undeposited Funds” first. Think of this as your “Virtual Deposit Envelope”. You create a “Bank Deposit” from your “Received Payments” to “Match” each deposit amount that comes into your bank feed.


Create Bank Deposit



Create Bills and Bill Payments to Match Bank Feed Expenditures in QuickBooks Online

Note that bill payments can be automatically matched in your bank feed. This is an automation feature that can be turned on within your Advanced Company Settings. You will need to create “matching” entries in QuickBooks Online for vendor bills and bill payments to auto-match to expenditures that come into your bank feeds.

Account Settings Advanced
Bill in bank feed
Bill sample
Bill payment

Create Purchase Orders to Match Product/Service Purchases in QuickBooks Online

If you have created a Purchase Order for an item on your products and services list, it cannot be pulled directly into your bank feed. You create a purchase order for the products and services that you purchase and then “Copy to Bill” so that it can be “matched” to the charge when it comes into your bank feed. If you create a bill payment in addition to a bill, this bill payment will be matched to the charge that comes into your bank feed. You will need to turn on “Use Purchase Orders”. Note that you can also simply create a “Bill” or enter an “Expense” that includes the “Item” that you purchased and bypass the step of creating a Purchase Order.


Purchase Order
Convert PO to Bill


Add Your Business Operating Expenses Directly within Your Bank Feeds in QuickBooks Online

There are many basic expenses that are considered “Overhead Expenses” (Operating Expenses) that will come through your bank feeds. These are expenses that are NOTDirect Labor” or “Direct Materials”. Some examples of these are accounting fees, advertising, phone, insurance, interest, legal fees, rent, repairs, gas, supplies, taxes, utilities and travel. You can assign a vendor and an expense account for these transactions directly within your bank feed, then add them to the account register. You can leave the vendor blank or add the vendor if you frequently use them and want to see a transaction history for them, or you can create a generic Payee like “Hotel” or “Car Wash”.


Direct Add Expense in Bank Feed



Understand the “Rules Engine” and Automatic Rule Creation in QuickBooks Online Bank Feeds

Each time you process a transaction within your bank feed the rules engine technology remembers and automatically creates rules for the next “similar” transaction that comes through the bank feed, which is not always accurate. Note that when I categorized the below “A Rental” charge in the amount of $800.00 to “Office Supplies”, the rules engine technology automatically created and applied a rule to categorize the next “A Rental” charge in the amount of $1,200.00 to “Office Supplies” as well.

Remember, Green does NOT mean GO in QBO!”. The rules engine technology will try to match records that have the same amount, and it will assume you want to make a transfer “to” and “from” the same accounts that you transferred money “to” and “from” previously. You should create “Transfers” in QuickBooks Online to be matched.

rules engine matching
matching amounts in bank feed



Create Your Own Custom Bank Rules for Automation in Your QuickBooks Online Bank Feed

You can create your own custom “Bank Rules” and even choose to “Automatically add to my books”. This is an excellent time saver that I highly recommend doing. Note that QuickBooks Online will skip the bank feed and directly add the transaction to your account register with this feature. The sample “Bank Rule” below was created without the “Automatically add” feature turned on.

Bank Rule Creation
Create Custom Bank Rule
Bank Rule in Action


Our Top Ten “Do NOT Do” This in Your QuickBooks Online Bank Feeds List

  1. Do NOT direct “Add” Deposits in the “Bank Feed”
  2. Do NOT assume the auto-populated “Payee” is correct
  3. Do NOT assume the auto-populated “Transfer” is correct
  4. Do NOT assume the auto-populated “Record Found” is correct
  5. Do NOT “Add” transactions with the wrong “Payee”
  6. Do NOT “Add” transactions with the wrong “Account”
  7. Do NOT “Transfer” funds between the wrong “Bank Accounts”
  8. Do NOT “Add” transactions that are incorrectly or double matched
  9. Do NOT “Add” the “Interest Expense” to the “Principal Loan Balance”
  10. Do NOT direct “Add” COGS (Cost of Goods Sold) Expenses in the “Bank Feed”
Regina Pitts
Regina PittsChief Financial Officer
Member of the QuickBooks ProAdvisor Program

Your Personal Guide to Seamless Accounting: Advanced QuickBooks ProAdvisor at Your Service

Hey there! I’m Gina, and I’m the proud co-founder of Lend A Hand Accounting. Why did I start this? Well, I believe that everyone should have access to affordable, efficient, and flexible accounting and bookkeeping services. It’s all about making sure these essential services fit snugly into your budget without any fuss.

We’ve ditched the traditional hourly rate system and adopted a flat fee pricing. You might be wondering, “Why does this matter?” Well, this way, you know exactly what you’re paying for upfront and there are no unexpected surprises. You get to pick and choose the accounting services you need, like a customized menu. And the best part? You’re in complete control of when you start or stop using our services. We’re essentially just a call or a text away, no need for endless phone calls or draining trips to the accountant’s office.

I’m not just any accountant though. I’m an Advanced QuickBooks Online ProAdvisor. That means I’m equipped with advanced expertise and resources to help you leverage QuickBooks Online to its full potential. My goal is to make your accounting process smooth and efficient so you can focus on what you do best – running your business.

Ready to get started? Reach out to me directly at 360-637-4799. We can even kick things off immediately if you’re ready. Simply create a free account, and I can instantly take a look at your books and let you know where you stand.

At the end of the day, we’re here to serve you. We really appreciate the trust you place in us and we’re eager to meet all of your accounting and bookkeeping needs. Looking forward to being part of your team!

Take care,


The Content is for informational purposes only, you should not construe any such information or other material as legal, tax, investment, financial, or other advice.