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 POSTED BATCHES TO A XML FILE
  
The Posted Batches records or data are saved in a XML (Extended Mark-up Language) file when the data is exported in the Tools - Export menu option on the Posted Batches tab and the XML File Type 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 XML file to store and Import the Posted Batches file.

To access the XML 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 Posted Batches file. The selected file will be displayed.

 

The exported data consists of 2 sections in the XML file, i.e. Metadata and Rowdata sections.

Metadata section of the file:

The data fields and their properties are defined in the Metadata section of the file. This is similar to that of row 1 (Headings) in an exported spreadsheet file.

Rowdata section of the file:

The individual details or data of the transactions as entered in the Input - Batches menu option and when it is posted or updated to the ledger are defined in each rowdata tag. Each transaction or line in a posted batch tarts with the tag "<" and ends with the tag ">". Each field for an transaction (e.g. Batch ID, Dates, Descriptions, Amounts, etc.) are displayed in a bold font type and is displayed between an identifier ("), e.g. Date - "20030331").

The respective fields are as follows:

The data fields and transaction data of the XML file is displayed on the screens in TurboCASH 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