Export General ledger accounts
This facility is additional to the powerful Report Export facility in which all reports in TurboCASH4 may be exported, and saved in any available format on your system, such as Word Processing (Text), Spreadsheets, etc.
Using this option, you may also export certain data regarding General ledger accounts in an open Set of Books to XML Database format, or any available format on your system.
All the information regarding each account, as entered in the Edit → Accounts menu (includes specific data for general ledger, bank and tax accounts), will be exported in the selected file format.
To export accounts data from TurboCASH4:
1.Click on the Tools → Export menu. The "Export Data to File" screen will be displayed.
2.Click on the Accounts button, if not selected. The screen will change to display the options for the Accounts:
3.Select and / or enter the following:
a)Export to - The installation directory in which TurboCASH4 is installed, will be displayed. You may click on the Browse icon to select a folder on the Browse for Folder screen. You may then select any available folder, or drive, on your system into which you wish to export the data.
b)File type - Select to export the file in the XML Database (*XML), Comma Separated Variable (*CSV), Lotus Spreadsheet File (*WK1), MS Excel Spreadsheet (*XLS), or any other format available on your system from the drop-down list.
c)Export file name - Enter the File name. You need to select this file at a later stage when you wish to import the file, or analyse the data in a spreadsheet.
d)Log file - Enter the Log file name.
e)Range -From... To - The Accounts lookup will be automatically initiated. Select any range of accounts to include in the export file.
f)Increment Export - Leave blank.
4.Click on the Export button. TurboCASH4 will create the export file, and save it in the specified directory.
The information for the General ledger accounts, which will be exported, is:
•Account ID (Ledger account, Bank or Tax account).
•Description or name of account.
•Income / Expense or Balance sheet indicator.
•Account reporting groups 1 and 2.
•Start and End dates (only applicable to Tax (VAT/GST/Sales tax) accounts).
•Rate - percentage (only applicable to Tax (VAT/GST/Sales tax) accounts).
•Receipts and payments batch (only applicable to Bank accounts).