All the information of each account, as entered in Setup → Accounts (Setup ribbon) (includes specific data for general ledger, bank and tax accounts), will be exported in the selected file format. 

It is recommended that the accounts (chart of accounts) is exported in the "Tab delimited" (*.txt) file format. This file format may be used to import the "Tab delimited" (*.txt) file format in the Import (Setup ribbon).

It is recommended to print the report from the source Set of Books (Reports → Ledger → Listing - Chart of Accounts (Reports ribbon).

Disabled accounts (Status set as Disabled) will be included in the export file. 

After importing the general ledger accounts, all inactive ("Disabled") accounts will be imported as active ("Enabled"). After Import you need to decide whether to keep them as active accounts or do the following in Setup → Accounts (Setup ribbon):

  • Set the status as inactive ("Disabled").
  • Delete the Accounts 

To export accounts from a Set of Books: 

  1. On the Setup ribbon, select Export. 
  2. Click on the Accounts button. 
  3. Select and / or enter the following: 
    1. Export to - The installation directory in which osFinancials5 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.
    2. 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 list. 

It is recommended that the "(*.txt) Tab delimited" file type is selected to Import general ledger accounts.

It will create the following export file types for the export file name:

*.txt - Tab delimited text file - Recommended for Import on the Setup ribbon.

*.slk - Can be opened in spreadsheets of LibreOffice, OpenOffice or UltraOffice). You may save it as a a Microsoft Excel file. 

*.xml - Can be opened in your system's default web browser or Notepad.
    1. Export files 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.
    2. Log file - Enter the Log file name.
    3. Range - From / To - The Accounts lookup will be automatically initiated. Select any range of accounts to include in the export file.
    4. Increment Export - Leave this option blank.
  1. Click on the Export button to 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. 
  • Account code. 
  • Income / Expense or Balance sheet indicator. 
  • Sub-Accounts 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).