Please enable JavaScript to view this site.

VT Transaction+

Navigation: Entering transactions (including opening balances)

Importing a journal

Scroll Prev Top Next More

A journal can be imported from a tab delimited text file, a CSV file or any spreadsheet. A tab delimited text file is a file where columns are separated by tab characters and rows by carriage return characters. A CSV file is a file where the columns are separated by commas and rows by carriage return characters. Data is imported from a spreadsheet by selecting the cells to be imported and choosing the Paste command from the Edit menu or Home tab of the spreadsheet.

To display the journal import dialog, choose the Transaction>Journal>Import command, or click on the down arrow just to the right of the JRN button on the main toolbar. If you are importing data from a spreadsheet, copy the cells in the spreadsheet before displaying the Import dialog.

This feature is principally intended for importing a journal from Sage via a CSV file, but can be used to import a journal in a wide variety of formats. Lists of transactions can be imported, but they are all imported as a single journal with a uniform date. A number of built in formats are provided, or you can set up any number of custom formats. In a custom format, you can specify the rows, columns or parts thereof that descriptions, debits, credits, VAT amounts and account names/codes appear in.

Entries using any account name or code system can be imported. If a name or code has not been used before, you will be asked to specify a VT Transaction+ account to match it to. A conversion table is provided for standard Sage account codes. Account codes could be taken from the column headers in an analysed cash book, provided they are all in the same row.

Currency and department entries cannot be imported.

To import a journal:

1.Select Transaction>Journal>Import. This opens the Journal Import dialog.

Journal_import

2.In Date, enter the date; all lines of the journal will have this date.

3.In Import via, choose the import method. If you are copying the trial balance directly from a spreadsheet, select Clipboard. If your trial balance is in a CSV file, select CSV file and Browse to choose your CSV file You can also import from a text file.

4.In Data format, select Journal. Selecting More info about this format displays the columnar format that your CSV file should be laid out as. For the Journal (and also Trial balance) format, this is:

Column A: Account name

Column B: Entry details (optional)

Column C: Debit amount

Column D: Credit amount

5.If the data is from Sage, select Sage to VTT+ in the Incoming account to VTT+ account conversion table.

If the data is from a different accounting package, select Custom names in the Incoming account to VTT+ account conversion table.

6.You can then assign account names/codes from the old package to VT Transaction+ accounts by selecting Converter.

7.Select Save or Save and Close to import.