The Creditor Account records or data are saved in a OpenOffice.org Calc Spreadsheet file when the data is exported in the Tools - Export menu option on the Creditors tab and the OpenOffice SpreadSheet (*.SXC) is selected. Once the data for Creditor Accounts have been saved to a file, you may access the file by locating it in the specific location and file name where you have saved this file on your system. You may use this OpenOffice.org Calc Spreadsheet file to analyse and sort this data for your specific requirements or to Import Creditors.

To access the OpenOffice.org Calc Spreadsheet file:

Locate the file on your system. You may use the Windows Explorer .

Double-click on the icon with the name you have saved the specific data for the exported creditor file. The selected file will be displayed.



The data fields exported from your creditor records is exported in columns, and the data, which you have entered in the Edit - Accounts - Creditor menu option is displayed in rows (from row 2 onwards). Each creditor account data is listed in its own row. Row 1 is used for the headings of the TurboCASH data fields.

The vertical scroll bar is located on the right-hand side of the spreadsheet file and is used to view more data for creditors. The horizontal scroll bar is located at the bottom of the spreadsheet file and is used to view more data fields for creditors.

The data fields on the screens in TurboCASH and the columns in which the data is displayed in the OpenOffice.org Calc Spreadsheet file spreadsheet is as follows:

General Information tab:



Remittance tab:



Accounting Information tab:



The detail for the columns is as follows:

Column	Field	Creditor Account - Tabs	Values
A	Account number	General Information	Alpha-numerical
B	Name	General Information	Alpha-numerical
C	Contact Person	General Information	Alpha-numerical
D	Address 1	General Information	Alpha-numerical
E	Address 2	General Information	Alpha-numerical
F	Address 3	General Information	Alpha-numerical
G	Postal Code	General Information	Alpha-numerical
H	Delivery Address 1	Remittance	Alpha-numerical
I	Delivery Address 2	Remittance	Alpha-numerical
J	Delivery Address 3	Remittance	Alpha-numerical
K	Phone 1	General Information	Alpha-numerical
L	Phone 2	General Information	Alpha-numerical
M	E-mail	General Information	Alpha-numerical
N	Fax number	General Information	Alpha-numerical
O	Credit Limit	Accounting Information	Amount
P	Charge Amount	Accounting Information	Amount
Q	Discount
R	Open Item Account	Accounting Information	True = Yes False = No
S	Remittance Message	Remittance	Alpha-numerical
T	Default Selling Price
U	Last Activity		Date
V	Tax Reference	Accounting Information	Alpha-numerical
W	Creditor Group 1	Accounting Information	Alpha-numerical
X	Creditor Group 2	Accounting Information	Alpha-numerical