accounts to the plant and machinery Excel headings. This is done in the Trial Balance
Analyser dialog. To display this dialog, click on the Trial Balance Analyser button on the
. For more help using the Trial Balance Analyser, click on the Help button in
Trial Balance Analyser button
AutoHide and fixed assets
See AutoHide and fixed assets
Notes and note numbers
A note is a set of rows and an associated note number. By convention, notes in VT Final
Accounts have two blank rows following the last used row. For AutoHide purposes, the
blank rows belong to the note above them.
The cell containing the number for a note (usually to the left of the note title) has a
special name which identifies it as a note number to VT Final Accounts. Whenever
AutoHide is re-evaluated or a new note inserted, revised numbers are automatically
placed in the note number cells.
There is a button on the VT toolbar
to insert and automatically number a new note. If for
some reason you insert and create a note using standard Excel techniques instead, there
is also a button on the VT Utility toolbar
for defining a cell as a note number cell.
A reference to a note number (on sheets such as the profit and loss account or balance
sheet) is achieved using a simple Excel formula pointing to the relevant note number cell
on the Notes sheet.
Inserting new notes
You only need to insert a new note if a template does not contain all the required notes.
This should be a rare event. Before inserting a new note, turn AutoHide off and make
sure the outline of a suitable note does not already exist.
You could insert a new note using standard Excel techniques, but using the Insert New
Note button is easier. It is also important that a new note is inserted starting at the
correct row, or else you may inadvertently expand an AutoHide area belonging to
another note. If you use the Insert New Note button, you will be warned if you chosen
an incorrect row.
The step by step instructions are as follows:
1. Select any cell in the top row of the note above which the new note is to appear. If
the new note is to be at the end, select a cell in the row three rows below the last
used row. For more information, see the New Note command
2. Click on the Insert New Note button on the VT toolbar
. A dialog will be displayed
asking you what type of note you want
Insert New Note button
3. Depending on the type of note you have created, you will be asked if you want the