TurboCASH Accounting Software TurboCASH United Kingdom
Select your Country
OPEN SOURCE ACCOUNTING SOFTWARE
HomeFeatures & ScreenshotsShop onlineCompareFAQForumRegisterContact
Community
Free Downloads
Shop
Other Titles

Using TurboCASH

 







EXPORT DATA
EXPORT POSTED BATCHES
  
This facility allows you to select a posted batch and to create an export file containing all the posted transactions, which was updated or posted to the ledger. TurboCASH will create a data file in the selected file format or file type.

To be able to select the correct batches with ease, you need to utilise the Change the Alias batch processing option, before posting or updating a batch to the ledger. If you did not Change the Aliases, you may find it difficult to locate the correct batches, you wish to import.

You will use this option to create an export file when you wish to use the Import Posted Batches batch processing option to import the posted transactions in a selected batch or journal . You may need to do this to cancel a batch, which was incorrectly posted or to create a new batch containing similar transactions, which you may edit and post to the ledger.

 

B> To Export Data from TurboCASH:
Click on Tools - Export menu option or press the and and keys on your keyboard. The Export Data to File screen will be displayed. Click on the Posted Batches tab. The screen will change to reflect the options for the selected type of data.

Title bar - double-click to display the screen in full size or to return to the normal size. Minimise - click to minimise this sceen. Restore - button inactive Close - click to close or exit this screen. Select to export data for documents. Select to export data for stock items. Select to export data for debtors. Select to export data for Accounts. Select to export data for creditors. Select to export transaction data for posted batches. Click to generate the export file and save the data in the file name and selected directory. Close - click to close or exit this screen. Click to select a different folder on the Browse for Folder screen. Select XML Database, Comma Separated Value (CSV), Lotus 123 (WK1), MS Excel (XLS), TurboCASH Exchange File (TXF), SYLK (SLK) and OpenOffice Calc (SXC) file types. Enter a name to save the exported data. Enter a File Name for the Log File. Select the Batch Number from the Batch List search facility. Select the end date for the period up to when you wish to export the posted batches. Export Posted Batches Options
Select and enter the options for the Posted Batches export data file.

Option Description
Export to The installation directory in which TurboCASH is installed will be displayed. You may click on the Browse icon to select a folder on the Browse for Folder screen on which you may select any available folder or drive on your system into which you wish to export the documents to.
File Type You may select to export the file in the XML Database (*XML), Comma Delimited File (*CSV), Lotus Spreadsheet File (*WK1), MS Excel Spreadsheet (*XLS) or any other format available on your system from the dropdown list.
Export File Name Enter the File name. You need to select this file at a later stage when you wish to Import the File or analyse the data in a spreadsheet.
Log File Enter the Log File name.
Range From and To The Batch List search facility will be automatically initiated. Select an available batch number from the Batch List search facility. You may only import 1 batch (the From and To fields would be the same batch number). You need to use the descriptions (aliases) to guide you to select the correct batches.

From Select the date on the Date Picker until which you need to include the posted batch transactions.

Click on the button and the selected batches will be exported to the selected folder in the selected file format.


If you locate the exported Posted Batches file, the saved exported file formats or file types will be displayed as the following icons:

 - XML Database file

 - OpenOffice.org Spreadsheet

 - Lotus 123 Spreadsheet file

 - Microsoft Excel Workbook (Spreadsheet).

 - Comma Separated Value