The Debtor 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 Debtors tab and the OpenOffice SpreadSheet (*.SXC) is selected. Once the data for Debtor 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 Debtors.

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 debtor file. The selected file will be displayed.



The data fields exported from your debtor records is exported in columns, and the data, which you have entered in the Edit - Accounts - Debtor menu option is displayed in rows (from row 2 onwards). Each debtor 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 debtors. The horizontal scroll bar is located at the bottom of the spreadsheet file and is used to view more data fields for debtors.

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:



Statements tab:



Accounting Information tab:



The detail for the columns is as follows:

Column	Field	Debtor 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	Statements	Alpha-numerical
I	Delivery Address 2	Statements	Alpha-numerical
J	Delivery Address 3	Statements	Alpha-numerical
K	Delivery Code	Statements	Alpha-numerical
L	Phone 1	General Information	Alpha-numerical
M	Phone 2	General Information	Alpha-numerical
N	E-mail	General Information	Alpha-numerical
O	Fax number	General Information	Alpha-numerical
P	Credit Limit	Accounting Information	Amount
Q	Charge Amount	Accounting Information	Amount
R	Discount	Accounting Information	Percentage
S	Monthly Interest on overdue accounts	Accounting Information	Percentage
T	Open Item Account	Accounting Information	True = Yes False = No
U	Account Disabled	Accounting Information	True = Disabled False = Not Disabled
V	Statement Message	Statements	Alpha-numerical
W	Default Selling Price	Accounting Information	Alpha-numerical
X	Last Activity		Date
Y	Tax Reference	Accounting Information	Alpha-numerical
Z	Debtor Group 1	Accounting Information	Alpha-numerical
AA	Debtor Group 2	Accounting Information	Alpha-numerical
AB	Salesperson	General Information	Alpha-numerical