Home | Support | VT Final Accounts topics

Support topics - VT Final Accounts

Error message when importing a trial balance

When a trial balance is imported into a manual entry VT Final Accounts workbook in Excel, the source trial balance is reproduced line by line on a sheet called ImportedTB. Formulas are automatically created to link the cells in the VT trial balance to the ImportedTB sheet.

There is a limit to the length of a formula in Excel. This limit is exceeded if too many lines in the imported TB are assigned to the same heading in the VT TB. An error occurs and only the part of the TB before the error is completed.

The workaround is too summarise the TB before importing.