Two Free Bookkeeping Spreadsheets

When you buy MyBookkeepingManager you get two free bookkeeping spreadsheets that are designed for use with an application such as Microsoft Excel or OpenOffice Calc.

These spreadsheets are intended to compliment MyBookkeepingManager and it is unlikely that you will need both of them. The reason we have included two spreadsheets rather than just one, is because one of them provides slightly more functionality than the other, so you can decide which (if any) you would like to use.

Note though that MyBookkeepingManager is a stand-alone application, so you are not obliged to use either of the spreadsheets if you dont want to. They are provided in the hope that they will be useful, but they do not form part of the MyBookkeepingManager software.

The reason we have not integrated the spreadsheets directly into the MyBookkeepingManager application is because we decided to keep bank account information separate from the bookkeeping application itself so that the information can be stored locally on your computer rather than online. Currently, MyBookkeepingManager does not require you to enter any financially sensitive information in order to do its job, and as the application does not use SSL encryption, we feel that from a security point-of-view this is a sensible approach to take.

When you register with the application, for example, you are free to use a dummy name and email address and are not required to enter any bank account details or company-specific details such as VAT registration details, etc. This way, your MyBookkeepingManager account is in effect an anonymous account and even if it was hacked, the perpetrator would just have access to a load of financial data that is of no use to them. In effect, you can view MyBookkeepingManager in the same way as you would view an online financial calculator.

Bookkeeping Spreadsheet 1 - Simple Bank Transaction Tracker

The first of the two spreadsheets is a very simple spreadsheet that lets you record bank transactions for each month in a financial year. The name of the spreadsheet file is financial-spreadsheet-simple.xls, and it is contained in the compressed file financial-spreadsheets.zip, which you have access to when you buy MyBookkeepingManager.

Bank Account Tracker Bookkeeping Spreadsheet

Bank Transaction Tracker Bookkeeping Spreadsheet - Data Entry

Bank Account Tracker Bookkeeping Spreadsheet

Bank Transaction Tracker Bookkeeping Spreadsheet - Data Analysis (partial view)

In combination with the reports generated by the MyBookkeepingManager software application, the bookkeeping spreadsheet will be useful for your accountant when it comes to, for example, producing your end of year company accounts.

Bookkeeping Spreadsheet 2 - Payments, Receipts, Sales Invoices & VAT Flat Rate Calculator

The second spreadsheet is a bit more sophisticated that the first and enables you to keep track of payments, receipts, sales invoices, and to calculuate VAT if your're working through the Flat Rate Scheme (FRS). The name of the spreadsheet file is financial-spreadsheet-complex.xls, and it is contained in the compressed file financial-spreadsheets.zip, which you have access to when you buy MyBookkeepingManager.

Payments, Receipts, Sales Invoices and VAT Spreadsheet

Payments, Receipts, Sales Invoices, and VAT Spreadsheet

Is a Basic Bookkeeping Spreadsheet Enough for My Business?

All businesses need to produce some accounts, even if this is just a list of financial transactions undertaken by the business. For most freelancers, sole traders, and IT contractors, producing more than the absolute minimum will be preferable, even if it is not a legal requirement. Not knowing what the financial state of affairs is of your business is a precarious position in which to put yourself, and is not recommended.

There are plenty of very powerful accounting and bookkeeping software applications on the market, with many of them packed with functionality. One of the problems you have as a small business person is trying to decide which one, if any, is right for you. Although they are all competitively priced, with the ball park figure in the region of £20 per month, you don't want to be spending money on functionality that you don't need. If, for example, you are a freelancer running a very simple business, you may find that all you do actually need is a means of recording financial transactions. In this case, a simple bookkeeping spreadsheet will probably suffice.

We have put together a few articles on this website that give you some background information with regard to accounting and bookkeeping for small businesses, as well as a review of some of the main software applications currently available on the market:

As always, our advice on this site is that you refer to an accountant if you are unsure of anything. Remember, you need to at least provide the minimum "legal" level of bookkeeping information for your business.

Go back to the main Features page