Arthur Accounting
Lesson 3.1· 15 minFree preview

Working the bank feed

The bank feed is a to-do list, not finished bookkeeping. Four questions tell you what to do with every line.

1

Why it matters

When you connect your bank to QuickBooks, every transaction lands in a list waiting for you. It's tempting to click Add or Post down the whole list and call it done. That one habit causes more messy DIY books than anything else.

Each line needs a decision. Get it wrong and income gets counted twice, transfers show up as expenses, and personal spending makes your profit look smaller than it really is. Your tax return is built on these numbers.

2

How it works

Where to find it

Depending on your version of QuickBooks, go to Transactions > Bank transactions or Banking. Work the For review tab, one account at a time.

Ask four questions, in this order

  1. Did I already record this? If you created an invoice payment, a bill payment, or an expense for it, choose Match. Adding it again doubles it.
  2. Is money just moving between my own accounts? Checking to savings, or checking to pay your business credit card, is a transfer. It isn't income or an expense.
  3. Is this line not real? A duplicate download or a pending charge that dropped off gets Excluded. Exclude is only for lines that shouldn't exist in your books.
  4. Otherwise, categorize it. Pick the payee and the account that describes what the money was for.

The personal spending trap

A personal charge on a business account is still a real transaction, so don't exclude it. Record it as money you took out of the business: Owner's draw for most LLCs and sole proprietors. If your business is an S corporation, it's usually recorded as a shareholder distribution. Money you put into the business from personal funds is an Owner's contribution, not income.

3

Practice

A sample business, not your real books. Mistakes here cost nothing, so try things.

Practice
Bright Paws Grooming, business checking
Bright Paws is a single-owner LLC. Their business credit card is also connected to QuickBooks. Choose what to do with each line in the feed, then check your work.
  • 03/01
    ACH PINEVIEW PROPERTIES
    March rent for the shop
    Spent-$2,400.00
  • 03/02
    MOBILE DEPOSIT
    You already recorded a $650 payment from Lopez on invoice 1031.
    Received+$650.00
  • 03/03
    PETEDGE SUPPLY
    Shampoo, clippers, and towels
    Spent-$312.48
  • 03/05
    TRANSFER TO SAVINGS x4412
    Spent-$1,000.00
  • 03/06
    ONLINE PMT CHASE CARD
    Paying the business credit card
    Spent-$845.20
  • 03/08
    SRP ELECTRIC
    Spent-$186.33
  • 03/09
    NETFLIX.COM
    Personal subscription charged to the business account
    Spent-$15.49
  • 03/11
    GOOGLE ADS
    Spent-$120.00
  • 03/12
    MOBILE DEPOSIT
    Owner moved money from personal savings to cover rent
    Received+$500.00
  • 03/14
    MONTHLY SERVICE FEE
    Spent-$15.00
  • 03/14
    PETEDGE SUPPLY
    Shows a second time in the feed. The bank statement shows only one charge.
    Spent-$312.48
  • 03/15
    GINGR SOFTWARE
    Booking software subscription
    Spent-$99.00

Answer every row to check your work.

4

Now do it in your books

  1. 1Open your For review tab and sort by date, oldest first.
  2. 2Before you click anything on a deposit, check whether you already recorded that payment. If you did, match it.
  3. 3Find any payments to your own credit cards or transfers to savings, and make sure they're recorded as transfers.
  4. 4Look for personal charges. Record them as owner's draw (or shareholder distribution for an S corporation), not excluded.
  5. 5Set a recurring time each week to clear the list. Fifteen minutes weekly beats three hours at month-end.

Before you go

  • Match first, transfer second, exclude only lines that aren't real, then categorize.
  • Paying your own credit card or moving money to savings is a transfer, not an expense.
  • Personal spending on a business account gets recorded as a draw, never excluded.
  • Money you put into the business is a contribution, not income.
Tip: finish the practice first so it sticks.