Why Are Bank Reconciliations Important?

If you’ve ever seen someone tearing their hair over a reconciliation that just won’t balance, maybe you’ve wondered what the fuss is all about. Why are reconciliations, or “recs” or “recons” as you may have heard, so important?

For the purposes of this post, we’re going to focus specifically on Quickbooks Online.

Bank Transaction Imports

Let’s lead in with something very important that bears repeating. If you are the person who imports online banking transactions into your software, then:

Pay careful attention to what you’re doing during the bank transaction import.

The bank transaction import is the first step of your bank reconciliation. If you can ensure that everything goes to the right place on the way into your books, then the reconciliation will go much easier.

Here’s a tutorial on bank transaction imports for Quickbooks Online.

Abe Lincoln once said, “Give me six hours to chop down a tree and I will spend the first four sharpening the axe.” Doing a careful, proper bank transaction import is similar — if you’re cautious enough then you’ll often spend a lot more time on the transaction import than the reconciliation itself!


Watch Out For Uncategorized Income!

One of the most important things to look out for during a bank transaction import is to make sure that you’re not importing anything to “Uncategorized Income” unless you really mean to. Assigning items to Uncategorized Income often results in your QBO bank deposits not matching properly to the bank import.

If You Receive Checks, Use Undeposited Funds

As a bit of an aside, if you receive physical checks from customers then it’s best to receive them to Undeposited Funds in the Receive Payments screen. Then, deposit all of them together with a Bank Deposit from the “+” icon. You can think of Undeposited Funds as the virtual equivalent of your zip-up bank deposit baggie.

If you don’t do this, then your books and the bank might match in dollar amount but not in the number of transactions. For example, your Quickbooks might have three $100 deposits while your bank statement shows one $300 deposit.

The Reconciliation Itself

So you’ve spent a whole month carefully importing your online bank transactions (you do reconcile monthly, right?) and now it’s time to seal the deal. It’s time to click on that gear icon and begin your reconciliation! Here’s a tutorial on how to reconcile your bank account.

Finding the Leftovers

Reconciling is all about finding the leftovers. You start off by eliminating all the transactions that your QBO books and the bank agree on: this is probably the bulk of the month’s activity and would include most of your checks and deposits, and almost all of your electronic funds transfers.

But the real point of reconciling is to find the leftovers and examine them! What are the transactions that haven’t cleared, and why haven’t they cleared?

Common types of leftovers and examples:

Items that appear in your Quickbooks but won’t appear in the bank statement:

  • Checks recorded in QBO that haven’t cleared the bank
    • Example: You handed Employee Ned a check on the 5th of last month, but he left it in his glove compartment. Maybe it’s time to consider direct deposit, if only for his sake!
  • Deposits in-transit
    • Example: Your customer initiated an electronic funds transfer to you on the 31st and you booked it in Quickbooks, but it hadn’t hit the bank account by month-end.
  • Bank errors — in my experience this is rare, but it can happen
    • Example: The bank employee depositing a check transposed some numbers and accidentally deposited a $565 check as a $656 check.


Items that appear in the bank statement but that might not be in your books yet:

  • Errors on your company’s books — it happens to the best of us!
    • Example: Employee Ned asked for a payroll advance at the end of the day, so you pulled a check and hand-wrote it to him, but you forgot to book it in Quickbooks. Maybe he asked for the advance because he left that paycheck in his glovebox! (For the record, we recommend against handwriting checks unless that is your normal way of operating.)
  • Bank fees, penalties, service charges, etc.
    • However you like to call it, many banks like to nickle-and-dime you. Depending on how closely you’re watching your bank accounts, you might not notice these fees until you see the bank statement.

Examining the Leftovers

There are two parts to examining your leftovers:

  • First, think about the whys of this leftover. Why did it happen? It’s not always a bad thing to have a leftover, but sometimes it’s the result of an inefficiency that can cost you time or money.
  • Second, think about the hows — how will you get your books to match the bank statement? Unless there’s a bank error, you want your QBO bank account to be a mirror image of the bank statement.

Tying It All Together — Why Is It Important to Reconcile?

Okay, time to wrap all of this up. Why is it important to reconcile?

If your bank account is not reconciled, then it’s possible that your business has less cash than you think. When it comes to payroll or payables, you may end up committing to spending more money than you have available and landing in overdraft territory.

Reconciliation is one of many error-checking processes that you can use to make sure your books are squeaky-clean. An error discovered during a bank reconciliation can lead to finding other errors. For example, accidental duplicate invoices could mislead you into thinking that your business is more profitable than it actually is!

TL;DR: Yes, you need to be reconciling your books. If this isn’t your jam we can do it for you, or we can show you how in a training session.

When is Working from Home a Tax Deduction?

When is Working from Home a Tax Deduction?

The most recent changes to the tax laws stipulate that the home office deduction is no longer available for employees.

If you are self-employed or an independent contractor, you might qualify for the deduction if you can pass two tests:

  1. Regular and exclusive use: You must regularly use part of your home exclusively for your business.
  2. Principal place of your business: You must be able to show that you use your home as your principal place of business. If you have another location and you ALSO use your home to substantially and regularly conduct business, i.e. meet with clients, it may be deductible. If you have a separate free-standing structure that is used exclusively and regularly for your business, it does not need to be your principal place of business.

If the use of the home office is merely appropriate and helpful, you cannot deduct expenses for the business use of your home.

Examples: You have an office where you meet your clients for appointments, but you also use your home office to do admin work. Use of your home office would be considered only “appropriate and helpful” and, as a result, not be tax deductible.

TL;DR: If you pass the two tests, you should take the deduction – though it is hard to pass the tests if you are renting another office space.

When is Mileage a Tax Deduction

When is Mileage a Tax Deduction?

There are only three times when mileage qualifies you for a tax deduction.

Medical Mileage: 20 cents per mile

Miles driven for medical purposes are deductible on Schedule A. The miles you drive to the doctor’s office, pharmacy, and hospital count. However, you only qualify for this deduction if your medical expenses exceed 10% of your income in a given year.

Charitable Mileage: 14 cents per mile

Miles driven for charitable purposes, such as donating goods or while volunteering, are deductible on Schedule A. So if you are volunteering for a non-profit to pick up garbage, the miles you drove to the worksite are deductible.

Business Mileage: 58 cents per mile

Miles driven between worksites, to client meetings, or to pick up supplies are deductible. This does include traveling to/from continuing education and seminars. These are only deductible if you are self-employed or an independent contractor. If you are a W-2 employee these miles are no longer deductible.

Commuting Mileage: NOT DEDUCTIBLE

Commuting from your house to your office is not deductible.

How do I deduct mileage?

If you want to take the mileage deduction, you need to log all of your trips that you want to deduct. You log should include the date, destination, miles, and the reason for the travel. We ask for your total miles, your business miles, and your personal miles for your tax return. You should also write down your odometer on 12/31 or January 1st each year.

There are a variety of apps to keep track of your mileage but most tend to cost between $3 to $10 a month. Unless you are driving more than 20 miles a month, you won’t break even in software costs.

TL;DR: Keep a mileage log if you want to take the mileage deduction.