VT Final Accounts

An Excel workbook is saved in a single file on your hard disk. A workbook consists of a series of worksheets. A worksheet consists of cells in a grid. One or more cells is a range.

Workbooks

A single workbook is used to contain all the presentational data for a set of final/statutory accounts for a business.

The easiest way to create a new workbook based on one of the templates is to click on the New Accounts Workbook button on the VT toolbar.

When you create a new workbook it will be given a default name such as Manstat1. When you save it you should change it to a more appropriate name.

Worksheets

Individual worksheets can be selected by clicking on the tabs at the bottom of the Excel window. You can also select sheets by clicking on the arrow buttons at the bottom left of the screen with the right mouse button and then by selecting a sheet name from the pop-up menu.

There are three types of sheets in a statutory/final accounts workbook:

In order to make printing and previewing more straight forward, there are special print and preview buttons on the VT Toobar which enable all the sheets making up the normal or abbreviated accounts to be printed in one go. This also numbers the pages correctly. If you want to print out a data input or workings sheet, select the sheet and use the standard Excel print button.

Ranges

A range is one or more cells on a worksheet. In VT Final Accounts documentation a range is sometimes referred to as an area. Many buttons and menu commands in Excel apply to the currently selected range on the currently selected sheet.

An entire row or column is also a range. To select an entire row, click on the row number. To select an entire column, click on the column letter.

Ranges can be given defined names. Many features of VT Final Accounts are implemented behind the scenes using defined names.