This facility is in addition to the powerful Report Export facility, in which all reports for Creditors in TurboCASH may be exported and saved in any available format on your system, such as Word Processing (Text), Spreadsheets, etc. Using this facility, you may also export the data of your Creditors in an open Set of Books to XML Database format or any available format on your system. You may then open the other applications to which the exported data is saved and work in the applications, such as OpenOffice.org Calc, Lotus 123, Microsoft Excel, etc.

All the information regarding each creditor as entered in the Edit - Accounts - Creditor menu option as well as the last date the transactions was entered for creditors will be exported in the selected file format.

To Export Data for your Creditors:

Click on Tools - Export menu option or press the and and keys on your keyboard. The Export Data to File (Documents tab) screen will be displayed. Select the Creditors tab if not selected. The screen will change to display the options for the Creditors Options.


Select and enter the following for the options to create an 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 Creditors search facility will be automatically initiated. Select any range of accounts.

Click on the button. TurboCASH will create the export file and save it in the specified directory.

---

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

---

The information for the Debtors, which will be exported, is the following:

• Account Code
  
  
• Description or name
  
  
• Contact persons
  
  
• Postal and Delivery Addresses
  
  
• 2 Telephone numbers and Fax number
  
  
• E-mail addresses
  
  
• Credit limits
  
  
• Charge amounts
  
  
• Discount
  
  
• Open Item Creditor indicator
  
  
• Disabled Account indicator
  
  
• Remittance Advise messages
  
  
• Reporting Groups 1 and 2
  
  
• The last date a transaction was entered for the debtor accounts will also be included into the selected export file.