Bookkeeping is non-negotiable if you’re a business owner. But how do you actually do it?
Should you fire up a new, blank spreadsheet and try to remember those old Excel formulas you learned in high school? Or should you hire a professional bookkeeper?
Honestly, the right answer depends on YOU and where you’re at in business. That’s why I’m about to break down when a spreadsheet is best, when it’s not, and when you might want to recruit professional bookkeeping help.
First, let’s talk about what bookkeeping is. Yup, I’m going back to the basics. Bookkeeping is the process of recording your financial transactions and categorizing them on a weekly basis.
Now, I know some of you are like… wait what? Did you say WEEKLY?
But the more on top of your bookkeeping you are — aka monitoring your income and expenses and account balances — the more financially healthy your business will be.
Now, one of my favorite ways to do bookkeeping is with a spreadsheet. Don’t get it twisted. It doesn’t have to be a massive spreadsheet with a billion tabs and complex formulas.
For the most part, you can keep track of your business books in a spreadsheet by including a column for:
Now, there are a couple of instances where this is not enough, but I’ll cover those in just a bit.
But is spreadsheet bookkeeping the right strategy for you? Let’s find out.
For creatives and online business owners, the idea of paying for one more tool and learning one more system sounds exhausting. I get it, I feel the same.
This is when I usually recommend that you just start with a simple bookkeeping spreadsheet.
If you’re a brand and website designer, and you’re just starting out with some freelance work for friends and family, you’re probably wanting to simply keep track of what you’ve made and what (if anything) you’ve spent. You’re also hoping to save a bit of money and you’re OK with the learning curve that comes from using a spreadsheet.
Is that you? Then, great! A spreadsheet would work perfectly for this stage of your business.
If you want to read more about the differences between spreadsheets and bookkeeping software, click here.
If you’re pretty sure a bookkeeping spreadsheet is all you need, great. My friend and client, Elizabeth McCravy, used her own spreadsheet to do her bookkeeping before we started working together. Then she turned it into a template so other business owners could use it!
I love Elizabeth’s bookkeeping template so much that I recommend it to pretty much everyone! This Google Sheet template is simple, easy-to-use and even comes with a video tutorial! It helps track:
You can grab that template RIGHT HERE.
Now, for all of you who are thinking that a spreadsheet — or even a tool like Xero — isn’t going to work for you, let’s talk about hiring a bookkeeper.
Disclaimer: Yes, I am a professional bookkeeper, so I may be a little partial. But I really do think that bookkeeping services can be such a great investment and can even help you grow your business.
Now, let’s talk about whether or not a bookkeeper is the right investment for YOUR business, right NOW.
One of the biggest reasons to hire a bookkeeper? You never want to touch your business books but you know you need someone who will.
Some business owners know, from Day One, that they don’t want to think about their books. They don’t want to think about what’s coming in or going out, or do calculations to find out how much to save for taxes or future business purchases.
If that’s you, kudos. It’s great that you know yourself. And you should probably hire a bookkeeper sooner rather than later.
Why? Because if you know you’re not looking at your numbers, things can get out of hand real fast.
We all know the struggle. We say we’re going to do something, whether it’s going to the gym more, eating better, or actually doing our bookkeeping…but then things get busy.
You put it off and it never gets done.
Well, when it comes to your bookkeeping, I really want to caution you against this. Because if you don’t have someone looking at your numbers and really tracking transactions, you can end up in the hole really quickly.
The last reason you might want to consider hiring a bookkeeper sooner rather than later? If you have a high volume of transactions.
Most service-based businesses have invoices that are paid before or after a service is provided. While they can have a pretty high number of clients, there aren’t too many transactions happening each month.
If you start selling templates, courses, or other offers with a higher volume of sales, you will have a LOT more transactions to sort through.
That’s when a bookkeeper can help because it can take a lot of time off your plate and ensure that your cash flow and profit margins are where they need to be.
Alright, that’s it for today. We talked about whether or not you can DIY your bookkeeping with a spreadsheet (or even a software tool like Xero), and when to hire a professional.
I’d love to hear where YOU are at in the comments below.
I’d also love to hear how I did and what sort of bookkeeping info you’d like me to share in the future!
If you check out my YouTube channel, don’t be shy — hit that subscribe button and stay tuned for future videos.