Things
to note on the attached spreadsheet: (the following is summarized on
the notes page of the spread sheet
When
you open the workbook save it to a directory on your computer (File
Save As) and name it so that you can find it again. You must do
this in order to control the printing of the spreadsheet.
The
workbook contains 11 worksheets - one with notes and the others
are in sets of Revenue and Expenses - you must use them in the sets
(i.e Expense with Revenue, Expense2 with Revenue2, etc.). The names
of the worksheets are on the tabs at the bottom of the spreadsheet
The
green cells contain formulas and are protected - you will not be
allowed to type in them.
The
protected cells formulas will allow the following to happen:
automatically
total under the Bank Cheques column as you make entries in expense
columns
automatically total entries made on Revenue sheet under Bank
Deposits column on the Expense sheet
automatically
calculate the Running Balance and put it in all cells to the
bottom of the page with each entry on the Expense and Revenue
pages
all
cells will automatically format with 2 decimal points and will
show negatives with the negative (-) sign
When
entering revenue you must be on the same line number on the Revenue
Page as the first empty line number on the Expense sheet.
If
you remove the opening balance you must do it with a 0 or by typing
over - do not use delete
The total of all the pages will total at the bottom of the fifth
spread sheet set. If you use more than 5 pages you will have to
manually total the two sets.
Running
Balance should equal your reconciled bank balance.
If
you require more than 5 pages open a new workbook and start again
with Expense and Revenue pages
All
electronic records must be backed up in case you have a system failure
You
must be able to print the files for your annual review
The
spreadsheets are set up to print on legal paper at 65% of original
size - 2 pages for expenses and 1 page for revenue and all pages
will be required for your review
