Front Sheet

This is the “front page” of the workbook. It is only used when the tool is set up for the first time.

Outgoings Sheet

In this sheet you type in the following information – for each outgoing:-

• The date the money left your bank
• The type of expenditure – these are selected from the drop downs. By clicking in the box, you will see a list of all the possible categories – if you want to add more categories then this can be done via the categories tab.
• Description – enter some text giving more information about the expense
• Amount – the amount of the expense

Type the information only in the pink cells. The information in the blue cells is an example.

Invoice details

This tab stores all the information relating to invoices raised and received. For each invoice that is raised the following information is required :-

• Invoice No. – the number on the invoice
• Client Name – the name of the client that has been invoiced
• Invoice Description – a description of the invoice
• Invoice Amount – the gross amount of the invoice including any sales tax
• Date Raised – the date that the invoice was raised
• Date paid – the date that the invoice was paid

Again use the pink cells, the blue cells are an example
 

Cashflow

This shows your monthly incomings and outgoings for each month – by category. The sheet is protected so the formulae cannot be overwritten.

Cashflow graph

This graph shows the closing cashflow position at the end of each month.

Expense Analysis

This tab shows a pie chart showing the breakdown of all the expenses incurred.