How do I import a chart of accounts?
This article has been machine translated. If you find any errors, we would be grateful if you could report them to translation@timesensor.com.
Importing a chart of accounts saves you from having to create accounts manually. This is how you 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 .csv file. (Comma Separated Values):
- Column 1 for the account number
- Column 2 for the account description
- Column 3 for the account type
- 1 = Asset account
- 2 = Liabilities account
- 3 = Expense account
- 4 = Income account
Open Import Editor
Open the chart of accounts window in timeSensor LEGAL. You will find this window in the Special area under Accounting. In the Tools menu, select the Import Chart of Accounts command.
Import data from the CSV document
Click Import and configure the import to match your data:
- Select Import Table as the destination 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 will now appear in the Import Editor. Make sure the data is correct and then click Next to complete the import. The accounts are now added to the chart of accounts.
Related Articles
How can I add and change accounts?
This article has been machine translated. If you find any errors, we would be grateful if you could report them to translation@timesensor.com. This entry shows how to be able to independently maintain and update the chart of accounts stored in ...How do I control my accounting accounts?
All bookings are recorded and managed in timeSensor LEGAL via the cash accounts. Persons interested in accounting can also carry out further research in the balance overview window and in the posting journal. balance overview If you click on the ...How Can I Monitor my Accounts?
All bookings in timeSensor LEGAL made and managed through your ledgers. Anyone involved in accounting may also use the balance summary and the accounting journal to do additional research. Balance Summary Go to "Special", "Accounting", then click on ...How can I import bookings into timeSensor LEGAL?
General Information From build 3414, you can import bookings into timeSensor LEGAL. Thanks to our flexible import editor, virtually any file format can be imported. Since we do not want a failed import to ruin our accounting data, timeSensor LEGAL ...How Can I Import Contacts from Excel into timeSensor® LEGAL?
Follow these five steps to import contacts from Excel into timeSensor® LEGAL. Prepare your contacts in Excel and save them as a tab delimited text file (.txt). In timeSensor® LEGAL, go to "Contacts". In the "Tools" menu, select "Import", then ...