How do I import a chart of accounts?

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).



  1. Column 1 for the account number
  2. Column 2 for the account description
  3. Column 3 for the account type
    1. 1 = Asset Account
    2. 2 = Liability Account
    3. 3 = Expense Account
    4. 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:
  1. Select Import Table as the target of the import
  2. Select the encoding so that umlauts are displayed correctly
  3. 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.



    • 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 ...

    • Is timeSensor LEGAL compatible with Bexio?

      General timeSensor LEGAL supports the export of bookings to a large number of accounting programs ( https://support.timesensor.com/portal/de/kb/articles/possible-interfaces-der-timesensor-buchhaltung ), including Bexio. preparations Before you can ...

    • 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 ...