Please enable JavaScript to view this site.

VT Final Accounts

Navigation: User interface

Buttons on the VT toolbar

Scroll Prev Top Next More

General

01 Style list

Style list

Apples a pre-defined style to the selected cells. For example, the VT Currency style formats negative amounts in brackets

02 New Accounts Workbook

New Accounts Workbook

Creates a new workbook based on an accounts template

03 Workbook Properties

Workbook Properties

Displays a dialog to set or change the company/business name, the dates of the financial year and other options

07 Copy Comps

Copy Comparatives From Current Year

Copies the current year data to the comparative columns. For use when accounts are prepared for a subsequent year

Linking

04 TB Analyser

Trial Balance Analyser

Displays a dialog that determines which reporting line in Excel each account in the associated VT Transaction+ or VT Cash Book file is included under. Applies to linked entry workbooks only

05 Get Balances

Get Balances From VT File

Updates the balances in the workbook with those in the associated VT Transaction+ or VT Cashbook file. Optionally applies to comparatives. Applies to linked entry workbooks only

06 Manual Enter Comps

Manually Enter Comparatives

Displays a dialog to enter the comparative balances independently of those in the VT Transaction+ or VT Cashbook file. Use of this feature is no longer normally recommended. Applies to linked entry workbooks only

Printing

08 Check Balance Tests

Check Balance Tests

If the accounts do not balance, displays a dialog that lists the pairs of cells that do not match. Also detects if the current year trial balance is inconsistent with the comparative year trial balance

09 Print Accounts

Print Accounts

Prints the sheets that make up the printable part of the accounts and correctly numbers the pages

10 Preview Accounts

Preview Accounts

Displays the sheets that make up the printable part of the accounts in the Excel Print Preview window

AutoHide

11 Policies

Policies And Paragraphs

Displays a dialog that determines which accounting policies are displayed

12 AutoHide

AutoHide On/Off

Turns on or off the automatic hiding of all lines and notes with nil balances

13 Reevaluate AH

Re-evaluate Hiding

Re-evaluates the automatic hiding of lines and notes with nil balances (for use when changes have been made when AutoHide is on)

Insertion

14 Insert TB Adj

Insert Trial Balance Adjustment Column

Inserts an adjustment column into the TB sheet. Converts the TB into an extended TB when first used. Applies to manual entry workbooks only. The Enter Journals buttons (see below) are usually easier to use

15 Insert Fin Row

Insert Financial Row

Manual entry workbooks: simultaneously inserts a new row into the printed part of the accounts and the TB sheet and links the two using a basic formula

Linked entry workbooks: inserts a new row into the printed part of the accounts and links the row to a new heading previously created in the Trial Balance Analyser dialog

16 Insert New Note

Insert New Note

Inserts a new note and correctly numbers it

17 Merge cells

Merge Cells And Wrap Text

Effectively combines the selected cells on a row into one and sets the formatting option to wrap text. By also increasing the row height, the merged area can be used for multiple paragraphs of text (double click on a merged area for a text editor)

18 Unmerge cells

Demerge Cells And Unwrap Text

Undoes the above

19 Remove All Page Breaks

Remove All Page Breaks

Removes all manual page breaks from a sheet

Bookkeeping

20 Open In VTT+

Open VT File In VT Transaction+

Opens the VT Transaction+ or VT Cash Book file that the workbook is associated with in the standalone version of VT Transaction+. Applies to linked entry workbooks only

21 Display TB

Display Trial Balance

Displays the trial balance in a dialog. Applies to both manual and linked entry workbooks

22 Display Transactions

Display Transactions/Adjustments

Displays a list of all transactions, journals and adjustments in a dialog. Applies to both manual and linked entry workbooks

23 Display Accounts

Display Accounts

Displays a list of all accounts and their balances on the left of a dialog. Any account can be selected to display the entries in the account on the right of the dialog. Applies to both manual and linked entry workbooks

24 Import TB

Import Trial Balance

Imports a trial balance from another accounts package, usually via a CSV file. Applies to both manual and linked entry workbooks

25 P And R

Enter Payments And Receipts

Enters any number of payments, cheque payments and receipts in the same dialog. Applies to linked entry workbooks only

26 JRN Classic

Enter Journals (Classic Style)

Enters journals and adjustments by selecting any combination of accounts from drop down lists. Applies to both manual and linked entry workbooks

27 JRN TB

Enter Journals (Trial Balance Style)

Enters journals and adjustments by entering an adjustment amount (or a closing balance) against a list of all accounts and their balances. Applies to both manual and linked entry workbooks

28 RJN Reversing

Enter Reversing Journals

Enters reversing journals and adjustments by selecting any combination of accounts from drop down lists. Applies to linked entry workbooks only

Miscellaneous

29 Template Instructions

Template Instructions

Displays instructions specific to the type of the current workbook