DIY Bookkeeper Spreadsheets


A simple income statement spreadsheet, the perfect bookkeeping tool for a sole proprietor.

Be your own bookkeeper! It enables you to capture all of your business related income and expenses, allocate it to universal categories used by creative entrepreneurs and populate a profit and loss statement based on the information you have entered.

Populate a simple balance sheet by entering the balances at year end.

Use a simple home office deduction calculator.

Calculate your wear and tear on assets in order to write off depreciation on your assets.

A budget tracker is included should you wish to use it.

A client invoice schedule to keep track of your sales revenue.

This is an Excel file that works on any computer that has MS Excel installed. You will receive the spreadsheet enabled to add your transactions and your business name while the set of categories are locked and only the universal list supplied. With the excel file you will receive a PDF instruction file.

Any business owner needs to keep track of their income and expenses to know what profit they are making. This tool will help you do that in the simplest form and is perfect for those entrepreneurs not ready to move over to online accounting software.

These purchased files are intended for an entrepreneur’s personal use, it is not to be uploaded or shared on public forums.

It is not suitable for businesses that are VAT registered.

To have this file customised in any way, contact Hanneke Barlow at who will gladly assist at an additional fee.