Did you know? Importing Journals

SQLWorks Accounting includes the option to enter Journals both manually, but also offers the chance to save time by importing journals from a spreadsheet of data directly to your Nominal Ledger.

When in the Nominal Ledger click ‘Journal’ in the top toolbar, and the add Journals window opens. To begin importing your journals, click the ‘Import Journal Option, and browse for the file you wish to import.

Imports must be imported using a fixed format from a template file: a copy of which can be found within your SQLWorks installation ‘Misc’ Folder as a Microsoft Excel spreadsheet – or downloaded here. You will need to enter your data and save the file as a tab-delimited text (.txt) file before importing.

SQLWorks will warn you if the data you are seeking to import is old, and may block you from entering nominal journals into locked accounting periods.

Once importing journals has run successfully, your nominal journal data will appear in the list of journals to be added, and users can commit them to the Nominal Ledger by clicking ‘Save and Close’.

 

For accounting advice and support, contact the SQLWorks team today.