Book Keeping for Small Businesses

You are in Home | Business Essentials | Book Keeping

Keep your own book keeping records on a spreadsheet and save money on accountants' fees. Even if you use an accountant for your year end accounts and tax returns, your fees should be less if you keep good records of your expenses and income.


Downlaod this free book keeping template includes the formulas which keep a running total of your bank balance. This enables you to have better control over your cash flow, as you can see at a glance what your bank balance is on a daily basis.


Create a column for each type of expense and a column for the business income. Total the columns to show the income and expenses for each financial year. The opening balance is the amount on your bank statement at 31 March, or for a new business, the day before starting the business. Create a new sheet for each financial year, starting 1 April.


If you do not have any spreadsheet software, a free version can be downloaded at


An alternative method of book keeping is to use accounts software such as Quickbooks.



Book Keeping Spreadsheets

book-keeping spreadsheet


Learn Excel 2007 with the Smart Method

This book is a self-study guide which will equip you with excellent Excel skills which are common in the work place. It is suitable for beginners to intermediate level users, with easy to follow lessons set out on two pages.

The book can be used as a stand-alone product, and is useful to have open on your desk as you practice on the computer. It can also be used with the DVD training course for a powerful learning experience.

DVD Video Training Course: Learn Excel 2007 Essential Skills with the Smart Method

This video has a running time of eight and a half hours, and helps you to quickly master Excel 2007. Learn how to create sophisticated worksheets that incorporate all of Excel 2007's most useful features. Everything is explained clearly, slowly and simply, from the very beginning.