Bookkeeping Spreadsheet Example for Small Business

Updated on April 28, 2017
Kaili Bisson profile image

Kaili is a small business owner who works from home. Her interests include business and finance, and retirement planning.

If You Own a Business, You Can't Ignore Bookkeeping

If you have your own small business, keeping good records is a must. In fact, it may even be a requirement for incorporation or licensing. You need to be able to see at any given point whether your business is profitable or not. At tax time, it is even more critical to have kept good business records throughout the year, or you could possibly end up in hot water with the tax authorities.

Set up simple spreadsheets for income records and expense records. If you get into the habit of entering items into the spreadsheets on the day they occur, you will soon find that you form a new habit, and will have good business records to boot. The discussion that follows is meant as a guideline, and the examples are based on someone who operates a small services business – in this case, writing and editing – from their home, and who has no employees.

Bookkeeping Tips and Best Practices for Small Businesses

What Records Do I Need to Keep?

Requirements vary from jurisdiction to jurisdiction, so it is always wise to check with your state or provincial government, as well as the Federal taxation agency, to make certain that you understand what you need to do in terms of bookkeeping.

Generally speaking, for a sole proprietorship, a yearly balance sheet is not required and keeping spreadsheets is sufficient. You will probably discover that, as the owner of a business, there are laws that compel you to keep your business records for a period of several years. You may also need to obtain a “business number” from the taxation agency for filing taxes applicable to the business.

In terms of keeping your records for tax purposes, you should always make sure that you retain proof to back up each and every entry in your spreadsheets. This is called an audit trail. This audit trail includes items like invoices for your services and receipts for purchases you make. If you use your car at all for your business, you need to record the mileage incurred for business use, the cost of gas, cost of a license, and repairs/maintenance. Phone and other utility bills, including your internet provider, should also be tracked. Simple spreadsheets that you can set up using software like Microsoft Excel can help you stay on top of it all.

Stop Stressing About Bookkeeping!

Source

Income Records

There are only a few simple steps needed to set up a spreadsheet to record the income generated by your small business. You can really get into a lot of detail if you wish, but simple is generally better and will keep you from seeing bookkeeping as a chore.

Basically, all you need to do is to record your sources of income. If the income is derived from an invoice you issued to a client for providing a service, note the specifics. Your audit trail or “proof” for these transactions could include PayPal statements, bank statements, and invoices you created for your clients.

The column headings can include whatever you like, but at a minimum should have the date of the transaction or invoice, the name of the client, a description of services you provided, your sales invoice number (so you can cross-reference and provide an audit trail), and any taxes applied.

You can also create formulas in different cells to keep running totals, or if you are very adept with spreadsheets, you can do things like link to other sheets. The sample below is provided as an illustration for simple income records.

Income From Clients Showing Invoice Number

Source

Expense Records

As with income records, keeping things simple on the expense side will really make this all relatively quick and easy. Record all of the legitimate expenses you incur in your business on the date they happen. Try to use descriptors or expense types like those used by the tax authorities, as this will really help you when it comes time to do your taxes. Some examples include:

  • Advertising
  • Business - use of home expenses
  • Supplies
  • Telephone and utilities

Again, the column headings can include whatever you like, but at a minimum, should have the date of the transaction, the transaction type, name of the supplier, amount spent, and any taxes applied. Keep all receipts and bills as proof. You can once again create formulas in cells to keep running totals of different types of expenses. A simple expense spreadsheet is shown below.

Expenses by Type With Taxes Incurred

Keep the Bookkeeping Spreadsheet Habit Going

Now, start getting into the habit of spending time on your bookkeeping spreadsheets every day. You will soon discover that it takes no time if you keep on top of it, and at tax time you will be so glad you did.

How Long Does it Take to Form a Habit?

It actually takes at least 2 months to develop a new habit. But don't despair! A few minutes a day is all it should take to add a few entries in your spreadsheet.

Questions & Answers

    © 2012 Kaili Bisson

    Comments

      0 of 8192 characters used
      Post Comment

      • Kaili Bisson profile image
        Author

        Kaili Bisson 5 years ago from Canada

        Thank you stars. Not something any of us prefer to do, but it is so important to know where your money is going and to be ready for tax time!

      • stars439 profile image

        stars439 5 years ago from Louisiana, The Magnolia and Pelican State.

        Wonderful hub to keep up the budget. GBY

      • Kaili Bisson profile image
        Author

        Kaili Bisson 5 years ago from Canada

        Hi cashmere and thank you for the feedback. You are lucky about the taxes :-)

      • cashmere profile image

        cashmere 5 years ago from India

        Nice spreadsheet samples. I use something similar but since I'm not really working, there are no taxes to pay:) Have yet to earn enough to be taxed...

      • Kaili Bisson profile image
        Author

        Kaili Bisson 5 years ago from Canada

        Hi Susan and thank you. Yes, there are always things that need doing that are way more fun than bookkeeping. I find that if I don't enter things right away, it all just gets away on me.

      • Just Ask Susan profile image

        Susan Zutautas 5 years ago from Ontario, Canada

        I keep books for my husbands business and I hate it. What can I say. I tend to procrastinate and leave everything to the last minute. I know this is the worst thing to do.

        Your hub is really useful though.

      • Kaili Bisson profile image
        Author

        Kaili Bisson 5 years ago from Canada

        Thank you Simone...I say the easier the better when it comes to things I don't necessarily want to do :-)

      • Simone Smith profile image

        Simone Haruko Smith 5 years ago from San Francisco

        Boy, is this ever useful! I've never really been in a position to keep income records and expense reports for a business- it's good to know what the starting points are.

      • Kaili Bisson profile image
        Author

        Kaili Bisson 5 years ago from Canada

        Thanks greeneryday...yes, once we get at a task, it really isn't so bad :-)

      • greeneryday profile image

        greeneryday 5 years ago from Some tropical country

        This a habit that I should be start doing for a long time... thanks for reminding... spreadsheet is so simple... everyone can do it...

      • Kaili Bisson profile image
        Author

        Kaili Bisson 5 years ago from Canada

        Thank you Global-Chica. It isn't always easy to get into the habit of taking care of business everyday, but as you point out, it can get away on you if you don't.

      • Global-Chica profile image

        Anna 5 years ago from New York, NY

        You make an excellent point about getting in the habit of updating a budget spreadsheet daily. At one point I didn't do it on a daily basis and completely lost the bubble on the spreadsheet. I had to start a new one and now updating it has become a habit and I do every day so I know exactly where my money goes and where it comes from w/out any discrepancies. Voted up and useful!

      • Kaili Bisson profile image
        Author

        Kaili Bisson 5 years ago from Canada

        Hi Marlene, and thank you. Many folks don't like bookkeeping, so I can understand you're having hired someone - it is a choice that individuals need to make relative to giving up some profit, and well worth it if the situation is more complicated because the business has employees, owns capital assets, has inventory etc.

      • MarleneB profile image

        Marlene Bertrand 5 years ago from USA

        This is excellent information about bookkeeping. It's one of the tasks that I don't like doing. So, when my daughter was in high school, I hired her to do my bookkeeping. She did a great job. But, when she went away to college, it was left up to me to do. I did it for one week and then hired an accountant. The job had to be done, and it was worth giving up a little profit to have someone else do it for me.

      • Kaili Bisson profile image
        Author

        Kaili Bisson 5 years ago from Canada

        Thanks tobusiness...as long as somebody is doing it, that's all that matters :-)

      • tobusiness profile image

        Jo Alexis-Hagues 5 years ago from Lincolnshire, U.K

        I'm rather useless at record keeping but my husband is quiet good, just as well. a good informative hub. Voting up

      working

      This website uses cookies

      As a user in the EEA, your approval is needed on a few things. To provide a better website experience, hubpages.com uses cookies (and other similar technologies) and may collect, process, and share personal data. Please choose which areas of our service you consent to our doing so.

      For more information on managing or withdrawing consents and how we handle data, visit our Privacy Policy at: "https://toughnickel.com/privacy-policy#gdpr"

      Show Details
      Necessary
      HubPages Device IDThis is used to identify particular browsers or devices when the access the service, and is used for security reasons.
      LoginThis is necessary to sign in to the HubPages Service.
      Google RecaptchaThis is used to prevent bots and spam. (Privacy Policy)
      AkismetThis is used to detect comment spam. (Privacy Policy)
      HubPages Google AnalyticsThis is used to provide data on traffic to our website, all personally identifyable data is anonymized. (Privacy Policy)
      HubPages Traffic PixelThis is used to collect data on traffic to articles and other pages on our site. Unless you are signed in to a HubPages account, all personally identifiable information is anonymized.
      Amazon Web ServicesThis is used to collect data on traffic to articles and other pages on our site. Unless you are signed in to a HubPages account, all personally identifiable information is anonymized. (Privacy Policy)
      CloudflareThis is used to quickly and efficiently deliver files such as javascript, cascading style sheets, images, and videos. (Privacy Policy)
      Google Hosted LibrariesJavascript software libraries such as jQuery are loaded at endpoints on the googleapis.com or gstatic.com domains, for performance and efficiency reasons. (Privacy Policy)
      Facebook LoginYou can use this to streamline signing up for, or signing in to your Hubpages account. No data is shared with Facebook unless you engage with this feature. (Privacy Policy)
      PaypalThis is used for a registered author who enrolls in the HubPages Earnings program and requests to be paid via PayPal. No data is shared with Paypal unless you engage with this feature. (Privacy Policy)
      Google AdSense Host APIThis service allows you to sign up for or associate a Google AdSense account with HubPages, so that you can earn money from ads on your articles. No data is shared unless you engage with this feature. (Privacy Policy)
      Features
      Google Custom SearchThis is feature allows you to search the site. (Privacy Policy)
      Google MapsSome articles have Google Maps embedded in them. (Privacy Policy)
      Google ChartsThis is used to display charts and graphs on articles and the author center. (Privacy Policy)
      Google YouTubeSome articles have YouTube videos embedded in them. (Privacy Policy)
      VimeoSome articles have Vimeo videos embedded in them. (Privacy Policy)
      MavenThis supports the Maven widget and search functionality. (Privacy Policy)
      Marketing
      Google AdSenseThis is an ad network. (Privacy Policy)
      Google DoubleClickGoogle provides ad serving technology and runs an ad network. (Privacy Policy)
      Index ExchangeThis is an ad network. (Privacy Policy)
      SovrnThis is an ad network. (Privacy Policy)
      Facebook AdsThis is an ad network. (Privacy Policy)
      Amazon Unified Ad MarketplaceThis is an ad network. (Privacy Policy)
      AppNexusThis is an ad network. (Privacy Policy)
      OpenxThis is an ad network. (Privacy Policy)
      Rubicon ProjectThis is an ad network. (Privacy Policy)
      TripleLiftThis is an ad network. (Privacy Policy)
      Say MediaWe partner with Say Media to deliver ad campaigns on our sites. (Privacy Policy)
      Remarketing PixelsWe may use remarketing pixels from advertising networks such as Google AdWords, Bing Ads, and Facebook in order to advertise the HubPages Service to people that have visited our sites.
      Conversion Tracking PixelsWe may use conversion tracking pixels from advertising networks such as Google AdWords, Bing Ads, and Facebook in order to identify when an advertisements has successfully resulted in the desired action, such as signing up for the HubPages Service or publishing an article on the HubPages Service.
      Statistics
      Author Google AnalyticsThis is used to provide traffic data and reports to the authors of articles on the HubPages Service. (Privacy Policy)
      ComscoreComScore is a media measurement and analytics company providing marketing data and analytics to enterprises, media and advertising agencies, and publishers. Non-consent will result in ComScore only processing obfuscated personal data. (Privacy Policy)
      Amazon Tracking PixelSome articles display amazon products as part of the Amazon Affiliate program, this pixel provides traffic statistics for those products (Privacy Policy)