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

 

 

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 PittsPrincipal Accountant & Bookkeeper
Member of the QuickBooks ProAdvisor Program

Accounting and Bookkeeping Support by a QuickBooks ProAdvisor Program Member

I founded Lend A Hand Accounting because I believe accounting and bookkeeping services should be affordable, efficient, and flexible. We use flat fee pricing, which makes our accounting services a comfortable fit for any budget. At Lend A Hand Accounting, we’ve found a formula that really works! You select the accounting services you need, and control when you want to start or stop services. It is all in your hands! We’ve cut out the need for endless phone calls and long trips to the accountant’s office.

Feel free to call or text me now at 360-637-4799. We can also get started right away. Go ahead and create a free account and we can automatically look at your books and let you know where you stand.

We really appreciate your business and look forward to serving all of your accounting and bookkeeping needs. Thanks again!

Gina

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.