|Top Previous Next|
This application is part of the Commercial Module add-on.
How to start the Accounts Exporter
The CSV Exporter will allow you to produce "comma separated values" files (CSV) which can be imported into many accounts packages, as well as opened for viewing in Excel or OpenOffice Calc.
A CSV file is a standard way of transferring data from one program to another, and stores specific data in a simple, unformatted and readable format. The destination program (such as Xero Accounts) expects to see the information in a particular sequence, and will only be expecting to see pre-determined items of data, so the Transactor Exporter needs to create the file using a template provided by the destination program. These templates are available online and can be downloaded directly within the CSV Exporter. Once downloaded, a template is stored on your Transactor computer and you can then access that template without having to access the internet every time.
(Note, if you open a CSV file in your spreadsheet program, and then make changes and save, the new file may not be compatible with your accounts package any more! If you need to open the file in your spreadsheet program you should work with a copy of the original CSV file)
Occasionally we may release new templates, such as when new accounts packages become available. You can download these online when we release them.
If we need to make any changes to existing templates, you can download the updated template online too, using the "Automatically check for new versions online" checkbox on the Browse page.
Using the CSV Exporter
The resulting CSV file can be imported into the appropriate accounts package or opened in Excel/OpenOffice Calc as a comma separated CSV file.
Note that once you've exported accounting data, the Lock Date can be set within Transactor, and you will be prompted if you wish to do this. If you choose to lock your data you can no longer make changes to those invoices that were included in the export. This is to ensure consistency between your account package and Transactor. If you wish to unlock your data again you can just visit the Accounting Rules page of Control Centre > Advanced within Transactor, and change the Lock Date.
Further details of each screen are given below.
You can reach this page by clicking "Browse" from the main page of the CSV Exporter.
The large left panel lists all the templates you have previously downloaded to your computer. You can select any one of these to see a short description of that template on the right panel.
A template contains the instructions required to export data from Transactor in the format required for importing into the selected application. Every accounts package will have its own requirements for importing from a CSV file, so you will need to ensure you select the template that is appropriate for the accounts package that you use.
You can get more templates from our online library, by clicking the button "Get more templates online".
Once you have selected the template you wish to use, click the button "Use this template". You will be returned to the first screen and your template will be loaded and ready to use. If you need to enter parameters (such as start and end dates for your export) you will be prompted to enter these. Click "Export to CSV file" to choose an output file and begin the export.
Occasionally it may be necessary for us to release a new version of an existing template, such as to include additional data or work around a problem. If the box "Automatically check for updated versions online" is ticked, then whenever you select a template in the list, if a newer version is available you will be notified and given the option to download the updated version.
You can reach this page by clicking "Get more templates online" from the Browse page of the CSV Exporter
The large left panel lists all the templates available online that you don't already have. You can select any one of these to see a short description of that template on the right panel.
A template contains the instructions required to export data from Transactor in the format required for importing into the selected application. Every accounts package will have its own requirements for importing from a CSV file, so you will need to ensure you use the template that is appropriate for the accounts package that you use.
To download a template, select it, then click the button "Download this template". The template will be downloaded into your library and you can find it using the Browse button from the main page.