Archive of ‘Business’ category

What to Do When a Client is Late Paying Your Invoice

| Business, Small Business

What to Do When a Client is Late Paying Your Invoice

You were so excited to work with a new client, but after two weeks of radio silence and an overdue invoice, the rose-tinted glasses are starting to fade to black.

So, how do you politely ask for a client to pay her overdue invoice without damaging the relationship? And, more importantly, how do you communicate that you’re not okay with this kind of behavior in the future?

To be clear, this is different than a client refusing to pay an invoice. This is for clients who may have looked at the invoice but made a mental note to pay it later, had a credit card decline and hasn’t solved the issue, or hasn’t been in contact with you at all.

Here are three scenarios you might encounter with sample emails to help you get paid without burning any bridges.

Scenario 1: Your client has an overdue invoice.

If one of your clients has an overdue invoice, it’s likely that they’ve just forgotten about it. So consider that before you get upset or start to feel underappreciated.

When this happens, send a short email over to your client. If you sent yourself a copy of the invoice, find that email and forward it with a message like this:

Subject line: Did this fall through the cracks?

Hey, Julie!

I hope you’re having a wonderful Wednesday. I’m forwarding this invoice along as I suspect it may have fallen through the cracks of your email inbox.

If you have any questions about it, just let me know.



I prefer this method over using the standard “send a reminder” feature in most cloud-based bookkeeping software for service providers because it adds an extra warm touch.

Scenario 2: Your client’s credit card was declined.

Telling a client that his credit card was declined can be a pretty embarrassing exchange for both parties. However, you can lower the amount of awkwardness by using the right language. Here’s an example.

Subject line: Quick question about this month’s payment

Hey, Julie!

I hope you’re having a great day. 🙂 I’m writing because I just attempted to process your monthly payment and your credit card was declined.

Could it be because it’s expired, or have you had any fraud alerts recently that I should know about?

Let me know how you’d like to move forward.



In this example, you’re removing any judgment, suggesting the blame on the credit card as opposed to her, and you’re showing concern.

Scenario 3: You haven’t heard at all from the client.

It sucks, but sometimes clients and contractors alike go radio silent on you. When that happens, I find it’s best to decide how many times I’ll follow up before I consider the debt as uncollectible.

For me, the magic number is three.

Here’s an example.

Subject line: Checking in on you

Hey, Julie!

I haven’t heard from you in a couple of weeks. You haven’t responded to my emails about the invoice payment or any of our project correspondence, so I just wanted to check in and make sure things are okay with you. I’ll admit that I’m worried since you’re usually so quick to respond.

If you need more time to pay or need to push pause on our work together, all you have to do is let me know and we can figure something out.

I’m here for you. 🙂



Decide Your Policies in Advance

A lot of the time, these kinds of awkward situations can be avoided if you decide on your late payment policies in advance and then get written approval that your client has read them.

An example of a late payment policy is something like:

If you haven’t paid your invoice within a 7-day period, I’ll have to push pause on our work together until payment has been collected. Before that happens, though, I’ll send a gentle reminder via email to complete payment. If, after another 7-day period, I don’t hear anything from you or payment isn’t completed, I’ll send another email letting you know that I’m pausing our project. I do this so I can create the best work possible for all of my clients and so we both feel like we’re in a mutually beneficial client / contractor relationship.

This clear communication in advance will let clients know where you stand and increase the likelihood that you’ll get paid on time.

Have other questions about how to handle tricky client correspondences like this? Leave a comment below!

Comments Off on What to Do When a Client is Late Paying Your Invoice

Quick – did you reconcile your bank account this month?

| Bookkeeping, Business, Business Basics, Small Business

Quick - did you reconcile your bank account this month?

Before I jump into the nitty-gritty of bank reconciliation, I want to tell you that it’s helpful to think of reconciling your bank account like a game.

Your goal is to make sure all of the transactions that happened in your bank account are also shown in your bookkeeping software, like Xero or WaveApps.

In short, you want everything to match, or balance, like your bookkeeper or accountant might say.


Because expenses and income that don’t show up can’t be claimed, or in other words, can’t be used for deductions.

That would throw off your taxes and potentially force you to pay for more than you owe. Not okay.

To avoid this, we reconcile our bank accounts. We make sure that no transaction falls through the cracks. And if something does? We become the Sherlock Holmes of bank transactions. (I know, cheesy. I couldn’t help myself.)

If everything is connected — your bank account, PayPal, Etsy, invoice software, and bookkeeping software — why might a transaction not show up? Good question.

Here are a few common reasons that your bank balance might not match your bookkeeping software records.

Common Reasons for Inaccurate Bookkeeping Records

1. Tech isn’t perfect, so sometimes transactions don’t show up when your banking website is down.

2. You’re getting double transactions from Etsy.

3. You’re getting double transactions from PayPal.

4. You’re getting double transactions from the deposit from your invoice and the invoice software.

Now, if you haven’t been reconciling your bank account, what are you supposed to do now?

First thing’s first: every software has a different way of reconciling a bank account.

In WaveApps, for example, it’s called Verify. In Xero, it’s called “reconciling” and you simply push a button that says “OK”.

I recommend doing this reconciliation process once a month to keep your books up to date and organized. If you wait any longer, you risk losing track of receipt or forgetting what a specific expense was. You’ll also have a better chance of getting paid sooner if you’re able to catch what invoices are still outstanding.

If you’re not sure what to do to keep your bookkeeping organized on a regular basis, I recommend downloading this FREE checklist: Weekly Bookkeeping Checklist for Bosses. It’s perfect for the DIY business owner who wants to keep her business healthy and make the most of her money. Click here to download it.

All of the above, though, might make sense in theory, but I’m sure you’re still wondering how you actually do it.

That’s why, in the next couple of posts, I’m going to show you step-by-step tutorials of how to reconcile your bank accounts using Xero and WaveApps. 🙂

Have questions for now or want me to do a tutorial using your bookkeeping software? Leave them in the comments below!

Comments Off on Quick – did you reconcile your bank account this month?

Should You Use Hubdoc to Organize Your Receipts?

| Business, Small Business, Taxes

Should You Use Hubdoc to Organize Your Receipts?

You’re looking for a way to keep your receipts organized and the tools that I mentioned in this post (Shoeboxed, Receipt Bank, Evernote) just aren’t enough.

You need something more robust that will keep track of ALL of your documents. So what do you do?

I recommend using Hubdoc.

Like all software and tools, it’s not perfect, but after using the most popular tools on the market with my bookkeeping clients, this one has the majority of what I need.

My clients send everything to the software, it inputs all of the numbers for me and I just check for category and accuracy.

Here’s what I love about it:

  • iPhone and Android mobile app – Like the other tools, Hubdoc has its own mobile app so you can take pictures of physical receipts.
  • Alternative methods of sending receipts – You can also email digital receipts and scan documents to upload them to the site.
  • Integration – It connects to all of your bank accounts, credit cards, PayPal, etc. You don’t have to do anything because everything connects and is accounted for. Plus, it works easily with my favorite bookkeeping software Xero. You can also connect it with QuickBooks Online,, and box.
  • Automatic syncing – Once you have all of the categories you want set up, your receipts will be automatically synced to the correct one. Yay for ease.

Here’s what I think could be better:

  • Inaccurate recognition – Sometimes the software doesn’t know what the receipt says, so it will send that receipt to a “failed” list. When that happens, it won’t automatically sync into the correct category.
  • Currency confusion – For some reason, it can’t understand the differences in currencies. My Australian client’s receipts always get defaulted to the American dollar, which is super annoying because I have to go in and constantly correct it.


  • Founded in: 2011
  • Free trial: Yes! 14 days.
  • Price: $20 (USD) per month

Overall, I’m really happy with how much time it saves me, the ease of using the software for me and my clients, and the price.

Have other questions about Hubdoc? Leave them in the comments below!

Comments Off on Should You Use Hubdoc to Organize Your Receipts?

Weekly Bookkeeping Checklist for Bosses

| Bookkeeping, Business, Small Business

Weekly Bookkeeping Checklist for Bosses

Bookkeeping is not the most glamorous component of running a business. I know, BIG surprise. Typically, it’s way more interesting to learn about sales, marketing, or money mindset.

And then I read statistics like “1 in 4 businesses don’t make it past their first year,” and it stops me right in my tracks.

If there’s so much information available on how to run and grow a business, why are 25% of them not making it to month 13?

Research has shown that it’s because of money. And not just money on its own but how the business owner manages the money.

When I talk to entrepreneurs about doing their own bookkeeping, the first thing they’ll tell me is that they don’t know what to do. They’re already so slammed with things to do that figuring out bookkeeping — especially when it’s not urgent — falls to the bottom of their priority lists.

But, every single of them, remembers how important it is to keep track of your money riiiight around tax season.

So the problem is NOT that they don’t want to manage their money responsibly — it’s that they don’t know how to.

That’s why I created this one-page resource for you called: Weekly Bookkeeping Checklist for Bosses.

You can check off these tasks once a week and it should take you no more than 30 minutes to do so once you get into the routine.

Download it here to stop worrying about being ready for tax season or if you’re doing what you need to with your money.

You can use it both if you handle your own bookkeeping or if you work with an accountant / bookkeeper already.

Happy Bookkeeping!

If you have questions about how to use it, comment below or send me a message.

Comments Off on Weekly Bookkeeping Checklist for Bosses

How She Invests: An Interview with Rebecca Tracey

| Business, Interviews, Small Business

With all of the options online for training programs and tools, it can be difficult to discern which are best for your business. That’s why I created the How She Invests in Her Business series. My hope is that the insights you read from these smart & savvy women help you decide how to make smarter financial decisions so you can stay in business for a looooong time.

Today’s Interview: Rebecca Tracey

This interview is with Rebecca Tracey, head/only honcho of The Uncaged Life, where she works with coaches, healers, and consultants from all over the world who want to have the freedom of working from anywhere by running their own online business. She helps people get clear on their brand message, create packages that sell, and learn what it actually takes to get and keep clients online. She started her business while living in a van, loves rock climbing and riding her bike around Toronto, and rappelling off cliffs with her dog, Rhubarb, on her back.

Like the other ladies who I’ve interviewed for this series, she’s a practical, no-nonsense business owner that you DEFINITELY want to have in your corner. Over to Rebecca!


How She Invests: An Interview with Rebecca Tracey

What investment has made the most impact on your business? What was the impact it made?

Investing in proper website design made a HUGE difference when I was new to my business. Once I got clear on what I was doing, who my clients were, and what I was selling, I paid a designer to help me amp up my site.

I FINALLY felt excited to tell people about it and it gave me the confidence to actually feel like I was a real legit business.

What’s one investment you’re thinking of making right now?

Someone to run ads specifically for my next launch. And I just hired out a whole new website and brand design – eep!

Before you decide to invest in something for your business, what do you do?

I often just go with my gut – I tend not to shop around. When I have someone in mind, I have my mind made up. I only invest in specific things when I need to, but it seems there is always something on the go that needs money, lol.

I’m not someone who signs up for courses and then doesn’t do them. I tend to just go right to the source and hire people one on one to make sure I get the help I need.

What has been your experience with hiring your first team member / contractor?How She Invests: An Interview with Rebecca Tracey

I actually hired my first contractor before I had a business – a copywriter! I would NOT recommend this.

You definitely need to be clear on what you do, who you serve, and what you sell before you have someone write your copy. I ended up changing most of the copy within the first 3 months.

But I forked over $1000 and hired someone right off the bat. In retrospect, not the best investment, BUT I don’t regret it because it helped me get started and lit a fire under my ass – now I needed a website to actually put that copy on!

What position, if any, are you planning on hiring next? (CPA, bookkeeper, graphic designer, etc.) Why?

I don’t have any hires on the horizon! I work with a business manager and a VA right now, and then I hire out for specific stuff I need along the way. My new web designer is hard at work, so we’ll finish that project before diving into anything else!


Who do you think your program “Uncage Your Business” is a good investment for? Why?

How She Invests: An Interview with Rebecca TraceyUYB is amazing for new coaches, wellness providers, and consultants who are struggling to make their businesses work because they can barely articulate what their business IS. They have a lot of passion and ideas but sometimes, to their own detriment, get scattered and overwhelmed with trying to put it all together.

We work on getting super clear on:

  • your core business message
  • who you work with
  • market research into what they want and need
  • putting together service packages just for them
  • learning how to talk about what you do in a way that gets YES’s (and learning to drop industry jargon and fluffy language that can create a disconnect between you and your clients)

This stuff is SO important, and a lot of online business courses and training skips this step and teaches you how to market your business, but the reason so many people get stuck is because they don’t have their foundations yet. It’s hard to market when you can barely even explain what, exactly, you do.

I help with that.

How do you use what you teach in your own business / life?

I come back to my own teaching allll the time in my business! Anytime I create something new or want to go in a different direction or make a new course, I go back to my foundations – my message, my niche, what those people need, and how they are talking about it. That way I can effectively create and market something that will sell.


How do you give back to your in-person community?

I don’t do a lot in-person (that requires pants – ew!), but I do spend a lot of time in my free Facebook community (hop in here) answering questions, doing free trainings, and just generally trying to connect with other amazing business owners and share some of what I have learned along the way.

In what other ways would you like to give back?How She Invests: An interview with Rebecca Tracey

I’d like to be a part of helping kids learn more about entrepreneurship and uncaged living. I think our values and ideals start when we’re young and what we’re exposed to.

If kids learn more about all the endless options that are out there for them from an early age, then anything will seem possible. I think we’ll end up with a lot more happy people in the world who are doing work that matters and living lives that they give a shit about.

You used to offer many different digital products around creating packages and what to do when you start a business. Why did you decide to retire those courses?

It just got too messy and confusing… And the honest truth about online courses is that they don’t often make a lot of money. People think “Oh, passive income,” but that couldn’t be further from the truth.

It ends up being a business model question – do I want to spend a lot of hours and $$$ trying to get huge traffic to my site so that my $35 online courses make me some decent coin — or would I rather spend that time getting higher paying clients into my group program and doing deeper work with them?

For me, the latter is where my heart is at.


Rebecca runs a free online community of over 6000 solopreneurs in her Facebook group. You can also find her hanging out on her website and on Instagram below where you’ll see loads of cute pictures of her pup. If you join her email list, she’ll give you freebies like Your First Retreat Checklist or the first chapter of Hey, Nice Package!. Go say hi to her!







Comments Off on How She Invests: An Interview with Rebecca Tracey

Why You Need to Know the Difference Between Sales Tax & Income Tax

| Business, Business Basics, Small Business, Taxes

Why You Need to Know the Difference Between Sales Tax and Income Tax

As tax season approaches, I bet your list of questions has been growing. How much am I going to owe the government? What deductions can I take advantage of? WHY IS THERE SO MUCH TO DO?

I hear you. But let’s take it back a few steps because there are some things to know when it comes to taxes.

First, there are two major kinds to know about: sales and income. What are the differences between them, and why do you have to know them?

Before I jump into the nitty-gritty of what they are, knowing the difference between these two can help you make much better decisions for your business. That way, you charge enough for your products and services and you’re not surprised when tax time rolls around, forcing you to charge your credit cards to cover what you haven’t saved.

For the most part, this advice applies to Canada, but there are some resources for the United States. Okay, enough chatter. Let’s talk taxes.

What to Know About Sales Tax

Sales tax is the tax associated with goods and services.

For example, tax added to groceries, all of your candles and jewelry from online shops like Etsy and Ebay, or services like getting the plumbing fixed. We pay extra for almost every purchase we make every day.

For most people, that’s where it ends.

However, once you begin a business, you’re also responsible for charging Sales tax and giving it back to the government. That’s why I mentioned in the post about how much to pay yourself that not all the money you receive in business is your money.

If you make over $30,000/year in Canada, then you must charge %5 GST (goods & services tax).  

Depending on your province, either PST (provincial sales tax) or HST (harmonized sales tax). I know, lots of acronyms. Stick with me here.

I live in Quebec, so I charge %5 GST and %9.975 PST.

You can check if your province has harmonized sales rates by clicking here.

If you live in the United States, check out this resource from the Tax Foundation.

What about digital products?

Because the number of people doing business online is expanding so quickly, many countries around the world are still catching up and haven’t created tax laws for digital goods yet.

If you sell digital products in Canada, then digital products are subject to tax and follow the same rules as if you were selling a tangible product. You can learn more about that here.

In the US, it depends on your state. For example, a state like Nevada considers digital goods tax-exempt while a state like Colorado considers the products taxable. Take a look at this list to check your state.

What to Know About Income Tax

Income tax is based on your total gross sales for the year, which are the sales before your expenses.

We pay those at the end of the year, and they’re determined by percentages set out by the government. Find your tax rate by clicking here.

In an employee situation, those income taxes are deducted right off your paycheck. You don’t really have to worry about it.

In your business, though, you are once again responsible for paying those taxes. (II know, it’s the price we pay for being able to work in pajamas and eat out of the Nutella jar whenever we feel like it.)

If you don’t pay it, the government will start charging you interest the day after taxes are due (April 30). That’s not a situation you want to find yourself in, so plan ahead.

If you operate a business in Canada, you can estimate how much taxes you will be owed here: Simple Tax Calculator

If you operate a business in the US, you can use this calculator: Self-Employment Tax Calculator

Now, here’s the most important piece of advice I can give you in this article.

Once you have an estimate, start saving portions of your income every month. That way you’ll be prepared at tax time. I recommend opening a separate bank account just for taxes. You can read more about that here: 3 Must-Have Financial Pieces to Run Your Online Business

If you want ideas on how to reduce your tax owing, check out the tax guide by signing up for the free bookkeeping resources library.

Comments Off on Why You Need to Know the Difference Between Sales Tax & Income Tax

How Much Should You Pay Yourself?

| Business, Business Basics, Small Business, Tutorial

How Much Should You Pay Yourself?

How much should you pay yourself?

So many entrepreneurs falter here and end up paying themselves less thinking that it’s better for the business or that they’re being greedy by taking too much.

The truth is that too many entrepreneurs are underpaying themselves. Here’s what I mean. If you’re paying yourself $2,000 a month and you really should be paying yourself $3000, you’re missing out on $12,000 a year. That’s a couple family vacations or a significant amount of savings!

Business owners are way over-complicating this. Here’s how you can think about this.

Paying yourself is not all that different from getting paid by an employer. When you get your paycheck, you distribute your income between bills, food, fun, and savings if there’s anything left over.

The main difference when you own a business? You have to pay your own taxes.

I know it’s tough to part with your hard-earned cash, so the first mindset shift I want you to take is that not all of your hard-earned cash belongs to you.

I know, I know. I don’t like it either. I’m only here to help guide you along.

Formula: How to Pay Yourself

To make this easy, I have a formula you can use to figure out how much to pay yourself. (If you want, you can download the worksheet I have for free here in my resource library.)

Take this example: You’re making $10,000 per month (congrats!).

In Canada, that means your marginal tax rate is %26. (You can reference this list for tax rates in America.) So, I would distribute income like this:

  • %1 profit – $100
  • %23 expenses – $2300
  • %26 tax – $2600
  • %50 payroll – $5000

To keep things organized, each of the lines above should have their own bank accounts. My favorite is (If you open an account before April 30, 2017 with a minimum of $100, you’ll earn $50. Just use my Orange Key {16898465S1}. Yay for free money!)

Why did I write 1% towards profit?

Mike Michalowicz, author of the book Profit First, explains this best. He says, and I’m paraphrasing, that we’ve learned to pay ourselves first — before bills — so we can relate that lesson to the profit we earn in our businesses.

He says that most businesses don’t make a profit, but this percentage system ensure one because you’re taking your profit out before paying bills and payroll. By following this system, you always have a profit at the end of the year, which you’ll clearly see when you close your books.

While 50% towards payroll may seem very generous, it’s reasonable if you compare it to an average wage of middle-income earners in the US.

Then you’re looking at between 2,000 – 3,000 take home pay each month. If you have contractors. you’ll be looking at another 1,000 – 2,000 in expenses.

So, like so many things in life, how much you decide to pay yourself is subjective. My biggest piece of advice is to make sure you think about taxes all year long, instead of just at the end of the year. I know so many business owners who spend, spend, spend and wonder why they don’t have a profit or enough saved up for taxes.

To sum it all up: First, determine how much you’re spending on expenses (not including subcontractors), find your tax bracket, always put away 1% profit, and work up to take %50 for payroll.

Now, this may take awhile, so be patient with yourself. Learning how to manage your money as a business owner is definitely a journey, but you wouldn’t be here reading this if you weren’t up to the challenge. 🙂

Click here to get free access to my library of financial resources so you can download the worksheet that will help you figure out how much to pay yourself, too.

Have questions about a more specific case or business? Let me know in the comments below.

Comments Off on How Much Should You Pay Yourself?

How to Close Your Books: Trial Balances

| Bookkeeping, Business, Finances, Small Business, Tutorial

How to Close Your Books: Trial Balances

In this next post in the How to Close Your Books Series, we’re going to make sure all of your accounts balance. Once you know that, you can prepare your taxes or send the files to an accountant who can prepare your taxes for you.

Before we start, make sure all of your expenses and invoices are entered. See the corresponding tutorials and do that work before moving ahead. You’ll then need to have all of the bank reconciliations done and ensure that any missing transactions are added. Once you have all that complete, you can start your trial balance as you’ll need to reference the master spreadsheet to get these numbers.

Write down all the accounts in order

Write down all the accounts in order of

1) Assets

2) Expenses

3) Liabilities

4) Revenues

5) Equity

You’ll do this for each of your accounts (bank checking, PayPal, etc.), and it can be alphabetical if needed. Usually, these accounts are assigned numbers in accounting software. For example, Assets will have 1000-1999, Liabilities 2000-2999, Equity 3000-3999, Revenues 4000-4999, Expenses 6000-6999. You may want to implement a similar numbering system for your spreadsheet as it makes it easier to find an account if a new bookkeeper is looking things over.

What are assets, expenses, liabilities, revenues, and equity?

Assets are things of value that are owned by your company. For example, cash accounts, accounts receivables, any land, equipment, or inventory. Your expenses are the costs associated with doing business such as advertising, materials, fees, etc. Your liabilities are obligations to pay later. For example, credit cards, any bank loans, or personal loans.

Revenues are any fees earned from providing services and the amounts of merchandise sold. An example of this are sales of products or consulting/coaching revenue. Equity is the amount of ownership or profit in a company. For example, the owner’s equity in a Sole Proprietorship refers to the amount of profit at year end.

You should have these numbers from your totals throughout the year, as you’ve gone through and added your expenses, invoices and then reconciled your bank accounts. Take the totals of each account from the spreadsheet and add them in the proper column like in the example below, with debits on the left and credits on the right.

There is a rule of thumb, if every account is positive, then the balances will go in the respective debit or credit column. Assets and Expenses are in normal/positive DEBIT balance and Revenues, Liabilities and Equity are in normal/positive CREDIT Balance.

To make it easy, I have the spreadsheet calculate account Totals per month, per account, and then a Grand Total for the Year.

Want the tutorial of how to close your books in one easy-to-use PDF with free spreadsheet templates? Click here to access my Bookkeeping Resources library to get the entire How to Close Your Books series as a PDF.


Account Debit Credit
Bank Checking 0.0
Paypal 0.0
Accounts Receivable 0.0
Advertising 0.0
Delivery 0.0
Insurance 0.0
Purchases 0.0
Telephone 0.0
Rent 0.0
Utilities 0.0
Other Expense 0.0
Credit Card 0.0
Accounts Payable 0.0
Sales Tax 0.0
Sales 0.0
Owner Investment 0.0
Owner Withdrawals 0.0
Owner’s Equity 0.0


For online accounting software Once you have this done, you’ll use these numbers for your taxes, and if necessary, a Balance Sheet and Income Statement.

Trial Balances are all done automatically. Software is set up for double entry bookkeeping and makes the user enter amounts only once unless there is a manual journey but even then the system won’t let you save it until your Debits equal Credits.

For Xero

Go to Reports >> All Reports >> Detailed Reports >> click on Trial Balance. You can publish the report, which means that the report is saved with those particular numbers and can be printed or exported.

For Wave

Go to Reports >> Trial Balance. You can also export this to Excel, CSV or PDF.

If you want to get the full guide on How to Close Your Books for the year in one handy PDF, sign up below.


Comments Off on How to Close Your Books: Trial Balances

How to Close Your Books: Expenses

| Bookkeeping, Business, Finances, Small Business, Tutorial

How to Close Your Books: Expenses

In the introduction of how to close your books, I talked about the importance of closing out and reconciling your business accounts for the start of the new fiscal year and why you need to do so.

In this post, I’ll be discussing step by step how to document your expenses from the current fiscal year and how to prepare them for the end of year wrap up. Let’s get started.

Step 1: Gather your expenses

Gather your expenses from this current fiscal year. We’ll be starting at the beginning of the year with your expenses from January.

Step 2: Set up your spreadsheet

Since not everyone has accounting software or perhaps has not kept up to date with their software throughout the year, I’m going to show you how to do this by hand, or at least in an Excel spreadsheet.

Create a new spreadsheet and include the following columns:

Date | Description | Reference | Source | Bank Account Dr, Cr | Category | GST Paid (or Sales Tax Paid)

I’ve made a sample spreadsheet for you to use and customize for your expenses, which you can access for free by signing up to the Bookkeeping Resources library and downloading the full How to Close Your Books PDF.

Step 3: Enter your expenses

Take a receipt and fill in the columns with the information from the receipt, fill out all the columns:

  • Date – Enter the date of the receipt when the purchase occurred.
  • Description – Enter the name of the company you purchased from. For example, if you purchased Facebook ads, you’ll record it as “Facebook.”
  • Reference – Here you want to record a purchase order number or invoice number that the receipt references. If you don’t have one, it’s ok to leave this field blank.
  • Source –  For this field, record where the money came out of. Was it your bank account, checkbook, PayPal, etc?

You should have a reference or a source per expense. You don’t need both, but you do need one or the other.

  • Bank Account, Debit or Credit – Here you want to record the amount of money that was debited from your bank account and/or credited to another account. I explain the different between these two options in my two previous posts What The Heck Is A Debit Anyway? and Credit- Love It Or Hate It
  • Categories – Here you want to record the type of expense. Was it advertising, shipping, bank fees? There are many expense categories to choose from.
  • GST Paid – Here you want to enter the tax you paid on your expense. In Canada, there are two taxes, so you may want to have two columns one for GST and one for Provincial tax. In the U.S., you can record the sales tax you paid on the expense, if any.

Once you’ve filled out these columns for the first expense, you need to repeat the process for all of your receipts from the fiscal year until all of your receipts are accounted for. Everything from the year goes into the same spreadsheet. Take it slow and go one month at a time.

But what about online systems? How do you enter expenses?

The good news is, if you want to set up an accounting system or start using accounting software, you can still do so.

For an online system like Xero:

Create an account with Receipt Bank and send all of your receipts virtually. Most of our receipts these days come into our email and Receipt Bank allows you to forward your receipts to a unique email just for you. You can even take a picture of your receipt, if you have one from a cash purchase with an app (available on both Apple and Android), and it will send it to your account automatically.

Receipt Bank takes care of scanning the receipt and gets it ready to publish to Xero. Once you’ve checked your receipts for accuracy and they’re set to the right expense account, you can set the program to automatically send receipts to Xero. It will even allow you to export your expenses as an Excel Spreadsheet or to PDF.

For an online system like Wave:

Shoeboxed is another system that takes care of receipts. It will scan your receipts and get them ready for export into Wave. With a click of a few buttons, you can watch all of your receipts turn into transactions inside Wave. It will even allow you to export your expenses as an Excel Spreadsheet, CSV, or PDF.

Once all your expenses are in for the year pat yourself on the back and treat yourself to a glass of wine because that was a lot of work!

And now that you know how to record your expenses, maybe next year you’ll do it year round so you won’t have to do it all in one go.

In part three of how to close your books, I’ll go over how to enter your invoices from the year. So come prepared with at least your first three months of invoices. 

If you want to get the full guide on How to Close Your Books for the year in one handy PDF, sign up below.

Comments Off on How to Close Your Books: Expenses

How to Close Your Books: Introduction

| Bookkeeping, Business, Finances, Small Business, Tutorial

How to Close Your Books: Introduction

It’s almost time to ring in the new year but before we pop open the champagne, there’s a lot to do to close out your books for the year. There’s expenses, invoices and bank accounts to reconcile. So hold on to those champagne flutes and party hats. You’ll first need to get yourself organized.

If you start now, you won’t feel rushed or overwhelmed come the ringing in the new year. You’ll even save yourself the headache of scrambling to do the work at tax time.

Remember, tax filings in Canada are due June 15, though you have to pay your dues by April 30th. In the U.S., you’ll need to file by April 15th. And while those filing deadlines may seem like a long ways away, they always come sooner rather than later. I don’t want you to be stressed when they do! 

At the end of the fiscal year, you need to close out the business year to get ready for tax time as well as close out your accounts for the year. Most likely your fiscal year for your business follows the calendar year, so it’s best to start now before the year is over. All of your accounts have to be reconciled. You’ll want to know how much money you made and your expenses for the year. This information will all go into your tax returns, as well.

Want the tutorial of how to close your books in one easy-to-use PDF with free spreadsheet templates? Click here to access my Bookkeeping Resources library to get the entire How to Close Your Books series as a PDF.

You’ll also want to reconcile all of your “temporary” accounts (accounts like Sales, Expenses and Draws) so they are set to zero for the new fiscal year. When you close out and reconcile these accounts, it allows you to compare how much you made and spent during the year. This information is very helpful for year-to-year comparisons, too. It will help show you how financially stable your business is, how much you have to invest back into your business, or how much harder you have to work in the new year to grow your business. When you know this information, putting together a plan to get to that six-figure mark (or over it!) becomes a whole lot more tangible.

Over the next couple of weeks, I’ll show you how to close out your accounts for the year and help you get ready for tax time. I’ll discuss the specifics of expenses, invoices, and reconciliation of your accounts.

To get started, you’ll need to start gathering your expenses and invoices over the past year. You’ll also need to look at your business bank accounts including PayPal, Square, or the like. We’ll take it slow and I’ll show you how to go through one month at a time so you won’t be overwhelmed.

Next week we’ll start looking at your expenses. If you haven’t kept up with your bookkeeping throughout the year, or haven’t started, you’ll be just fine. Don’t fret. I’ll show you how you can get your finances in order. So to be prepared, gather your expenses for the first three months of the year. I’ll explain how to deal with them and get you started on the rest of the year’s expenses.

Get access to my Bookkeeping Resources library by signing up below.

Comments Off on How to Close Your Books: Introduction

1 2 3