Export / Import - General ledger accounts
You may export and import general ledger accounts (chart of accounts).
This feature may be used to import ledger accounts (chart of accounts) into:
- Into the same Set of Books.
- Into a different Set of Books.
- Into a new Set of Books - Created from scratch - Create your own Set of Books (Advanced)? option for Firebird database types.
- Into a new Set of Books - Created from scratch - Create your own Set of Books (Advanced)? option for Microsoft SQL sever (MSSQL) database types.
|
|
Before you may import ledger accounts in a new Set of Books, you need to do the necessary setup and configuration. Once this is done, you may start to import ledger accounts from a saved "Excel Workbook (*.xlsx) file type or from a saved the "Tab delimited" (*.txt) file. |
|
|
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. |
Export / Import options on Setup ribbon
To be able to import the data for Account records, you need to created a "Tab delimited" export file in the Export (Setup ribbon).
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).
Spreadsheet export / import
osFinancials5 supports the "Excel Workbook (*.xlsx) file type Spreadsheet import and export feature.
- Spreadsheet export - You may export ledger accounts and save it as a "Excel Workbook (*.xlsx) file type.
- Spreadsheet import - You may import ledger accounts from a saved "Excel Workbook (*.xlsx) file type.