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

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



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

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

Column	Field	Details	Values
A	Stock Code	Stock Item code	Alpha-numerical
B	Barcode	Barcode	Alpha-numerical
C	Description	Description or name of the Stock Item	Alpha-numerical
D	Quantity on Hand	Quantity or number of Items on Hand	Numerical
E	Re-Order Quantity	Minimum Quantity on Hand to re-order new Stock Items	Numerical
F	Apply Invoice Discount	Allow Discount on Invoices for Debtors / Customers.	True= Allow Discount / False do not Allow Discount.
G	Selling Price 1	Amount (Excluding VAT)	Amount
H	Selling Price 2	Amount (Excluding VAT)	Amount
I	Selling Price 3	Amount (Excluding VAT)	Amount
J	Unit Average Cost	Amount (Excluding VAT)	Amount
K	Unit Cost	Amount (Excluding VAT)	Amount
L	Unit	Unit Description (e.g. each, litres, etc.)	Amount
M	Group 1	Stock Group 1	Alpha-numerical
N	Group 2	Stock Group 2	Alpha-numerical
O	Cost Account	Cost of Sales Account	Alpha-numerical
P	Sales Account	Sales Account (Income)	Alpha-numerical
Q	Stock Account	Stock Control Account	Alpha-numerical
R	Input Tax Account	Tax Account used for Input Tax on Purchase and Goods Returned documents.	Alpha-numerical
S	Output Tax Account	Tax Account used for Output Tax on Invoices, Credit Notes and POS Invoices.	Alpha-numerical