How do I import a chart of accounts?
By importing a chart of accounts, you save yourself the manual creation of accounts. Here's how to proceed:
Preparation in Excel
Prepare the chart of accounts in Excel. Create three columns in your Excel document and save the Excel document as a .txt file (tab-delimited text).
- Column 1 for the account number
- Column 2 for the account description
- Column 3 for the account type
- 1 = Asset Account
- 2 = Liability Account
- 3 = Expense Account
- 4 = Revenue Account
Open Import Editor
Open the chart of accounts window in timeSensor LEGAL. You can find this window in the Special area under Accounting. In the menu, select Tools and then the command Import Chart of Accounts.
Import data from the txt. document
Click Import... and configure the import so that it matches your data:
- Select Import Table as the target of the import
- Select the encoding so that umlauts are displayed correctly
- Assign the columns to the fields of the import table as shown
Add data to the chart of accounts
The imported data now appears in the Import Editor. Make sure the data is correct and then click Next to complete the import. The accounts will now be added to the chart of accounts.