How to Make Small Business Bookkeeping Easy and Avoid Mistakes

Small Business Bookkeeping Made Easy

On a list of top 1000 things that you want to be doing in your business, bookkeeping is probably not there. Bookkeeping seems like necessary claptrap and administrative burden. But it doesn’t have to be this way! Doing your own bookkeeping can give you valuable insights into your small business. With a few tips, I will show you that bookkeeping can be made easy and mistake free.

It’s a skill that can help you bootstrap your business.  When you are ready to hire someone else to do it for you, you’ll be armed with good knowledge about what’s involved so you’ll know if it’s being done correctly.

Software is Your Friend

Bookkeeping is often maligned because of the data entry involved. However, today’s cloud-based accounting software takes most of the humdrum out of bookkeeping. If fact, when we do the bookkeeping for small businesses, we spend most of our time following up with clients to make sure we have all the necessary information.

Choosing a software is easier than it sounds. In this world, you get what you pay for, so if you are starting or running a business that you intend to grow, you should be looking at paid software such as Xero or Quickbooks Online. They will have most of the bells and whistles that you need and you can integrate a bunch more software to tailor a solution to your needs. This software becomes the central platform where all your financial data gathers.

If you are a freelancer or solopreneur and are not into balance sheets, integrations and stuff like that, a free or low-cost alternative might be more up your alley. Check out Wave (free) or Freshbooks (if you need integrated time-tracking). These can be great solutions if your needs are a bit simpler. Just be aware that you may need to do a bit more manual entry and you may find the reporting lacklustre for anything outside the box.

THE POINT: Choose a software based on what kind of business you are building. Don’t be cheap. Choosing a well-known piece of software will be just fine, so don’t kill yourself over selecting the perfect one. None are perfect, you’ll just have to learn it’s quirks.

Set-up is everything


Yes, the software is amazing, but spending the requisite time in setting it up properly is critical. It can get off the rails really quickly. An ounce of prevention, begin with the end in mind: pick your cliche of choice. They are cliches for a reason: setting things up properly will be well worth the time.

Separate business bank account

This is a mantra around here. Separate bank account. Separate bank account. It will be on my tombstone, I think. It’s going to make your bookkeeping life so much easier. I will explain why in the next section, but suffice it to say that if you do only one thing, do this. Leave your personal transactions personal and start treating your business like a different entity than you. Keep it healthy and cashed up.

Start fresh

When you start doing your bookkeeping, it’s best to start fresh. Go back to a date that you know your data is solid. This is will be the “conversion date” and could be the last time you filed a tax return or, better yet, when you started your business and everything was zeros. This will allow you to bring the data into your software.

Do the training

Whatever software you have chosen will have some training or information on how to get started. Spending the time here is going to pay off for a long time, so it’s a good investment.

Bring in the (clean) data

If you set up a separate bank account and credit card from the beginning, you are a step ahead. You can export your transactions from your bank and import them into the software.

If you didn’t have a separate card, all is not lost. You will need to go through your transactions (in excel or GSheets) and delete out any personal transactions. You can import these transactions under a separate account called “due to owner” because I know after reading the first paragraph of this section, you rushed down to the bank and opened your separate bank account!

The nice part about most accounting software is that they have direct bank feeds so you can categorize your transactions as they come in, so you will likely only have to do this import once. You can connect your bank feed, which helps decrease the amount of data entry you will need to do.

Catch it Up

Now that your data is in there, you can start to categorize transactions into accounts. Again, most software has you covered here with an out-of-the-box chart of accounts (a listing of accounts that you can use for categorization). You are now going to take all of these transactions you imported and put them into buckets. Don’t get too fussy - mainly you are trying to separate revenue and expenses into buckets that make sense.

THE POINT: Spend some time setting up your software properly. Do the training so that you pull in solid data and know how to deal with it. Then just do it.

Your Bank Balance is Your Rock

giphy-downsized (2).gif

In the world of bookkeeping, your balance balance is your North Star. If you don’t know your bank balance, you are living in a topsy-turvy world, my friend. Before you do any bookkeeping, you have to make sure the balance that is showing in your software is the same as your bank is showing.

Why is this important? If the balance in your software doesn’t equal your bank statement, you could be missing transactions or have duplicates. Either way, you are dealing with information that’s wrong, which means your books are wrong. Wrong is bad.

Need an example that’s a bit more real? Imagine: You send out some invoices, collect some payments, match those payments to your invoices in the software. Wait a second! Vandelay Industries hasn’t paid their invoice! You send out a reminder to pay and Vandelay tells you curtly that they have paid it and the payment went through. You double check your bank and the transaction was missed in your software. Whoops! It happens, that’s why we always check the bank balance.

THE POINT: Your bank balance is your totem (inception reference, anyone?). It’s going to anchor you to reality, so make sure it’s right before doing anything else.

Doing the bookkeeping

giphy-downsized (3).gif

It’s go time. Now that you have caught everything up, you have a solid business-only bank balance and credit card, you have completed the training and your data is flowing into your accounting system auto-magically, it’s time to do your bookkeeping.

Set a Cadence

This is going to be different for everyone, but monthly is about the minimum you’ll want to do it as it gets to be a bigger job and you’ll delay it indefinitely after that point. When I did our books, I did it daily. I liked knowing what was going through the bank every day. It only took a few minutes and kept me understanding what the cash flow of the business was. Weekly seems to work for lots of people too. The key is to find a timing that works for you and stick to it.

Check Your Bank Balance

Step one is to refresh your bank feed and make sure it matches your bank. If so, you’re ready to go. That’s all I have to say about that, but I am going to write another sentence here because I didn’t want to have a whole heading with just two short sentences. That’s better.

Categorize/Match Your Transactions

You now have some new transactions and you will categorize these into the appropriate bucket and reconcile them. For money coming in, you are going to want to either match the payment to an invoice you have created or post it to revenue depending on what kind of business you have.

If you want to up your bookkeeping game and become audit-proof, you should look into the in-built functionality of Xero and Quickbooks to upload your receipts.

You can take this a level further by investing in a solution like Receipt Bank or Hubdoc to capture receipts using optical character recognition functionality. It will pull out data like GST/HST for you to limit data entry even further. If going this route, you will first work in the receipts app, then publish to your accounting system for matching to your bank transactions.

Reward Thyself

Keep it fun and lively. Reward your hard work and next-level adulting. I like 85% chocolate and beer (not at the same time).

THE POINT: Get a bookkeeping routine and make it fun. Your early planning and training is going to pay off now. Put on some tunes, grab some beef jerky and slay those books!

The Next Level

giphy-downsized (4).gif

I hope this article is helpful to de-mystify bookkeeping for you and gives you the confidence to do it yourself. We’re good at this stuff, so if you need some help getting started, want a bit more guidance and training or just can’t be bothered to do it yourself (you probably have a few other things to work on too), reach out. We live for it.

If you are looking for an accountant, we also help make sense of the good information that’s now at your fingertips. We love working with small business owners like you building the business of your dreams.