This option will allow you to import your Accounts (Chart of accounts) file from a valid an Excel spreadsheet in the Excel Workbook (xlsx) file format. You may then add new accounts, edit existing accounts and import it back into another Set of Books.

Reports for the accounts (Chart of Accounts) are printed in Reports → Ledger → Listing - Chart of Accounts (Reports ribbon).

Before using this feature, it is recommended to print the report. 

If you make any changes in the Excel spreadsheet, and Import it, these changes will be reflected.

To import Accounts from a Excel Workbook (xlsx) file: 

Select the Set of Books which contains the Accounts (Chart of accounts) you need to export.

To export accounts to a spreadsheet: 

  1. In the source Set of Books from which you wish to export the Accounts to a spreadsheet file, go to Setup → Accounts (Setup ribbon).

  1. Click on the Spreadsheet icon. A blank "Data Import Export" spreadsheet will be displayed with the column headings of the "Accounts" table.

  1. Click on the Export icon on the "Data Import Export" screen. All the "accounts" (chart of accounts) is exported (populated) in the spreadsheet.
  2. To save the Spreadsheet export as a file, click on the Save as... icon. 

  1. The recommended file type is Excel Workbook (*.xlsx).  
  2. Select the location where you wish to save the spreadsheet file.   
  3. Enter a name Click the Save button.
  4. Close the "Data Import Export" spreadsheet screen.  

Spreadsheet columns

The data of the exported accounts into the spreadsheet, consists of fourteen (14) columns, and is as follows:  

Column

Field name

Values

Comments


A

SACCOUNTCODE

Account code prefixed by account type:

G - General ledger 

B = Bank account

T = Tax account

3-Digits for main account and 3-Digits for sub-accounts. 


B

SDESCRIPTION

Description or name of account



C

BINCOMEEXPENSE

0 = Income / Expense account

1 = Balance sheet account



D

BSUBACCOUNTS

 0 = No Sub-accounts

1 = Has sub accounts



E

BOPENITEM

0 = Not set as open item

1 = Open item account



F

BINACTIVE

0 = Active

1 = Disabled (inactive)



G

SGROUP1

Account Reporting group 1 

Description 


H

SGROUP2

Account Reporting group 2

Description


I

DSTARTDATE

Not applicable

Not imported


J

DENDDATE

Not applicable

Not imported


K

FRATE

Tax rate (percentage) 

Tax rate - Account code prefix = T 


L

SRECEIPT

Name of Receipts batch linked to the bank account

Account code prefix = B 


M

SPAYMENT

Name of Payments batch linked to the bank account

Account code prefix = B 


N

SCURRENCY


Not imported