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

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

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



An Exported Posted Batch with VAT transactions:



The detail for the columns is as follows:

Column	Field	Account - Details	Values
A	Batch Type	The name for the batch type as Setup - System Parameters - Batch Type menu option.	Alpha-numerical
B	Account	The selected account and tax account (if selected).	Alpha-numerical
C	Tax Account	The Tax Account which is applicable to a transaction.	Alpha-numerical
D	Contra-Account	The specified or selected account in the Batch Setup option.	Alpha-numerical
E	User name	The name of the user if created in the Access Control menu option.	Alpha-numerical
F	Description	The description for the transaction as entered in each line. The last transactions, which is indicated by ******** (8 asterisks) is generated by TurboCASH when the batch is balanced.	Alpha-numerical
G	Unique ID	TurboCASH generates the Unique ID.	Numerical
H	Alias	The Alias as displayed in the Title bar of the Batch Entry screen. The alias is changed on the Processing Options for the Batch.	Alpha-numerical
I	Batch ID or number	TurboCASH generates the Batch ID (or number).	Numerical
J	Line ID or number	The line number for the transaction in a batch.	Numerical
K	Date	The date of the transaction.	Date
L	Period ID	The ID for the accounting period for the transaction date.	Numerical
M	Reference	The reference number or source document number (e.g. cheque number, etc.) for the transaction.	Alpha-numerical
N	Amount	The amount of the transaction.	Amount
O	Tax Rate	The percentage which applies to the selected Tax Code	Percentage
P	Tax Amount	The amount is calculated as a percentage of the amount in column L if a Tax Account was selected for the transaction.	Amount
Q	Tax Rate 2	The tax percentage of the second tax account if a Tax Account was selected for the transaction.	Numerical
R	Tax 2 Amount	The amount is calculated as a percentage of the amount in column L if a second Tax Account was selected for the transaction.	Amount
S	Forex	The forex value is currently 1 for all transactions.	Amount