Export / Import - General ledger accounts
This option will allow you to export your general ledger accounts into an Excel spreadsheet. You may then add new general ledger accounts, edit existing general ledger accounts and import it back into your general ledger accounts.
|
|
These accounts (Chart of Accounts) are maintained in Setup → Accounts (Setup ribbon). 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. |
|
|
You may also click on the Spreadsheet icon on the Setup → Accounts (Setup ribbon).
|
To export and import ledger accounts:
- On the Setup ribbon, select Import. The "Import Data into TurboCASH5.2" screen will be displayed.
- The "Data type to import" is "Documents" (default option). Select "Accounts".
- Click on the Excel import export button. The Excel spreadsheet will be displayed with the column headings (database table) for the general ledger accounts (without any data).
- Click on the Export icon. The data from your general ledger accounts will be imported (populated) into the spreadsheet.
- You may add new accounts, edit the accounts, set the account status to disabled or enabled, open item account, etc., whatever field, you find necessary.
- Click on the Import check icon. This will populate the Settings tab with the field names and values:
- You may select which fields not to update, use profile files and select the Import type (i.e. Import all, Just new, or Just existing records).
The data of the imported accounts are imported (populated) in the following fourteen (14) columns in the spreadsheet 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 |