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.
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.
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
- 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.
- 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.
- 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.
- 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.
Practice
A sample business, not your real books. Mistakes here cost nothing, so try things.
- 03/01ACH PINEVIEW PROPERTIESMarch rent for the shopSpent-$2,400.00
- 03/02MOBILE DEPOSITYou already recorded a $650 payment from Lopez on invoice 1031.Received+$650.00
- 03/03PETEDGE SUPPLYShampoo, clippers, and towelsSpent-$312.48
- 03/05TRANSFER TO SAVINGS x4412Spent-$1,000.00
- 03/06ONLINE PMT CHASE CARDPaying the business credit cardSpent-$845.20
- 03/08SRP ELECTRICSpent-$186.33
- 03/09NETFLIX.COMPersonal subscription charged to the business accountSpent-$15.49
- 03/11GOOGLE ADSSpent-$120.00
- 03/12MOBILE DEPOSITOwner moved money from personal savings to cover rentReceived+$500.00
- 03/14MONTHLY SERVICE FEESpent-$15.00
- 03/14PETEDGE SUPPLYShows a second time in the feed. The bank statement shows only one charge.Spent-$312.48
- 03/15GINGR SOFTWAREBooking software subscriptionSpent-$99.00
Answer every row to check your work.
Now do it in your books
- 1Open your For review tab and sort by date, oldest first.
- 2Before you click anything on a deposit, check whether you already recorded that payment. If you did, match it.
- 3Find any payments to your own credit cards or transfers to savings, and make sure they're recorded as transfers.
- 4Look for personal charges. Record them as owner's draw (or shareholder distribution for an S corporation), not excluded.
- 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.
