Canuckbusiness

Start a business, Do your taxes, Save money

Free Downloads

Here are some downloads you may find useful for your business. Feel free to modify them to suit your business needs and share them with whomever you like. I just ask that you keep my copyright notice and links to my websites on the sheets.

Put these in a folder on your computer, and together with your shoebox full of receipts, presto!  You have a complete set of books that the Canada Revenue Agency (and I dare say any other country) would be very happy to see when they come knocking on your door for an audit.

If you find anything not working properly, please send me an email at jkswift (at) about (dot) me to let me know and I’ll fix it.

For Recording Revenue:

Note: Enter your business name and year on the “Summary” tab and it will flow through to the monthly tabs automatically.

Revenue Summary Template

Example of Hank’s 2004 Revenue Summary

For Recording Expenses:

I was going to just put up a single expense “template” but I got carried away and thought I might as well put up separate sheets for the most common expenses that 99% of businesses use. If you need a different category, you can make a copy of one of these, change the name on the front “summary” sheet, and it will flow through to the monthly sheets.

Advertising

Assets Costing More Than $400  (Capital assets–not true expenses but we need to keep track of them)

Business Fees & Licenses

Insurance

Interest & Bank Fees

Inventory Purchases  (For those of you who have COGS or don’t know what it is, read this post and this one too)

Legal & Accounting

Maintenance and Repairs

Meals & Entertainment

Not Sure Where it Goes  (Every business has one of these but usually uses a cooler name!)

Office Expenses

Rent

Supplies

Telephone, Internet and Utilities

Travel

6 Comments »

  1. Thank you so much! You are a pretty smart, organized cookie!

    Comment by Zena | April 13, 2013 | Reply

  2. This is great! I’ve been using this for 2 years now for my husband. But I cannot figure out how to put in both PST and GST again! I’ve tried and just wrecked it 😦 Any tips would be helpful!

    Comment by Kim | March 30, 2014 | Reply

    • Nevermind, I figured it out! Haha, PST is just included in the subtotal 🙂

      Comment by Kim | March 30, 2014 | Reply

      • Hi Kim,
        Glad you figured it out! Yes PST and the cost of the item without GST are added together and entered into the spreadsheet. If you are not a GST registrant, then you add PST, GST, and the cost of the item together and enter them all together in the amount column. And if you accidentally screw up the spreadsheet, just download a fresh one, even if it’s halfway through the year and you have a lot of stuff already entered. You can use two of them and add the totals together at year-end…no need to copy everything into one. That way lay madness!
        all the best,
        james

        Comment by jkswift | March 30, 2014

  3. What procedure do you recommend us to follow when we need more rows in one the tables in these spreadsheets, eg if I have more than 14 revenue items in January?

    Comment by Neil Mayhew | April 9, 2014 | Reply

    • Hi Neil,
      Place the cursor on the far left number of a row somewhere in the middle of the table, left click and drag it down however many rows you want to insert, and with all those rows highlighted, right-click and choose “Insert rows” (or use the Excel menu to insert rows).

      Now you will have some new rows in the middle of the table but you’ll notice that in the “Total Collected” column there will be no $ sign symbol. This is because the formula has not been copied into those new rows yet, so they won’t add anything up. To fix this, left click somewhere in the cell directly above your first new row (one that has a $ sign in it). Then left-click and drag the bottom right corner of this cell downwards so it highlights all your new cells. This drags (and copies) the formula into the new cells. That should work!

      Comment by jkswift | April 12, 2014 | Reply


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s