To illustrate the exported fields and data, the exported text file is opened in a spreadsheet. 

Once the text file is saved, you need to launch your spreadsheet application i.e. Microsoft Excel, Apache OpenOffice, LibreOffice, Ultra Office, etc. 

 If you do not enter and save the Export.txt file name, you may replace existing (previously exported) files. 

If the exported Text (*txt) file is opened (active), and you are trying to open the export file with the same name, a similar error message as the following will be displayed:

Cannot create file "D:\Export\Export.txt". The process cannot access the file because it is being used by another process. 

On your spreadsheet application, open the accounts saved text (*.txt) file and confirm your tab delimited settings ("Separator Options") on the "Text Import" screen. 

export-accounts-text-import-spreadsheet

This will open your exported text file of the accounts in a spreadsheet. An example of the exported file opened in "LibreOffice Calc" spreadsheet, is as follows: 

export-accounts-text-imported-spreadsheet


The exported data will be exported in 15 columns:

Column

Column heading

Source / fields

Remarks


A

WACCOUNTTYPE

Account type 

Ledger / Bank / Tax

Integer

0 = Ledger 

3 = Bank

4 = Tax

B

SDESCRIPTION

Description

Name (Account description)

String (35)

C

SACCOUNTCODE

Account no.

Account code

String (6) Prefixed by account type

G = Ledger 

B = Bank

T = Tax

D

BINCOMEEXPENSE

Account type

Income statement / Balance sheet

(Tax and Bank accounts is by default a Balance sheet Account) 

List

1 = Income statement account type

0 = Balance sheet account type

E

BSUBACCOUNTS

Sub-accounts


B=CheckBox

1 = Sub accounts (True - checked) 

0 = No sub-accounts (False - not checked) 

F

BOPENITEM

Open item account

No / Yes

List 

1 = Open item account (Yes - checked) 

0 = Not an Open item account (No - not checked) 

G

BINACTIVE

Status 

Enabled / Disabled

List

1 = Account disabled (inactive) - (Enabled - selected) 

0 = Account enabled (active) - (Disabled - not selected) 

H

SGroup1

Account group 1


String (30)

I

SGroup2

Account group 2


String (30)

J

DSTARTDATE


Not available to select (only applicable to Tax accounts)

Date

K

DENDDATE



Date

L

FRATE

Percentage (Tax tab)

Only applicable to Tax accounts

Float(numeric)

M

SReceipt

Receipts (Bank tab)

Receipts batch (only applicable to Bank accounts)


N

SPayment

Payments (Bank tab)

Payments batch (only applicable to Bank accounts)


O

SCurrency

Currency