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 STOCK TO A LOTUS SPREADSHEET FILE
  
The Stock Items records or data are saved in a Lotus 123 file when the data is exported in the Tools - Export menu option on the Stock tab and the Lotus 123 File Type 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 Lotus 123 file to analyse and sort this data for your specific requirements or to Import Stock Items.

To access the Lotus 123 file:
Locate the file on your system. You may use the Windows Explorer .
Title bar - program name. Title bar - name of the saved exported file. Restore button - click to restore the program to the size in which the progam was displayed. Close button - click to close or exit the program. Minimise button - click to minimise the program. Menu bar - click to access the menu options in the program. Minimise button - click to minimise the active spreadsheet. Restore button - click to restore the spreadsheet to the size in which the progam was displayed. Close button - click to close or exit the active spreadsheet. Program name and icon. New - click to open a new spreadsheet. Open - click to open an existing spreadsheet. Save - click to save the data or your changes in this speadsheet. Print - click to print this spreadsheet or the selected cells. Cut - removes the contents of the selected cells and places it on the Clipboard. Copy - places the contents of the selected cells on the Clipboard. Paste - places the contents from the Clipboard into the selected cells of the active spreadsheet. Undo - click to undo a last or previous action. Change sheet properties. Select range or graphic object. Copy a range's styles to other ranges. Size columns to fit. Sum values above or to the left. Select several objects Create a chart. Create a map. Create a query table. Create a new version of the selected range. Create a script button. Create a text block. Draw an ellipse or circle. Draw a forward-pointing arrow. Name Box - displays the column and row of cells Formula bar - displays the contents or a formula for seelcted cells. Columns. Scroll bar Row 1 - Headings for the exported data fields. Universal SmartIcons set Change range properties. Range SmartIcons set. Print Preview Worksheet Sheet number or name. Previous spreadsheet or next spreadsheet. Create a new spreadsheet. Stock code. Barcode. Name or Description of the Stock Item. Stock quantity on hand. Selling Price 1 (excluding VAT). Selling Price 2 (excluding VAT). Selling Price 3 (excluding VAT). Average Cost Price for each Stock Item. Rows. Rows 2 to the end - the data for each account. Minimum Stock Item re-order quantity level. Apply Invoice Discount. Unit Cost Price (excluding VAT). Stock Unit Description. Stock Group 1. Stock Group 2. Exported Stock in Lotus

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 Lotus 123 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