Export / Import Debtor accounts
You may export and import debtor (customer / client) accounts and creditor (supplier / vendor).
This feature may be used to import debtor (customer / client) accounts and creditor (supplier / vendor) 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 debtor (customer / client) accounts and creditor (supplier / vendor) 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 valid saved file type. |
|
|
The debtor (customer / client) accounts (Chart of Accounts) are maintained in Debtors (Default ribbon). The creditor (supplier / vendor) accounts (Chart of Accounts) are maintained in Creditors (Default 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 debtor (customer / client) accounts and creditor (supplier / vendor) accounts, you need to created a "Tab delimited" (*.txt) export file in the Export (Setup ribbon).
It is recommended that the debtor (customer / client) accounts and creditor (supplier / vendor) 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 debtor (customer / client) accounts and creditor (supplier / vendor) accounts and save it as a "Excel Workbook (*.xlsx) file type.
- Spreadsheet import - You may import debtor (customer / client) accounts and creditor (supplier / vendor) accounts from a saved "Excel Workbook (*.xlsx) file type.