Product news

Importing purchases and expenses into TimeLog Project

Need to import your project expenses from your financial system? TimeLog Project now offers full import of .TXT and .CSV files.

Eliminate duplicate entries and save time

If you register your business expenses in a financial system such as e-conomic, C5, Navision, Axapta or the like, you can now eliminate duplicate entries by importing data on supplier invoices, employee and travel expenses, etc. from a comma-separated .TXT or .CSV file. This consolidates all internal and external project-related expenses. And if you invoice your customers using TimeLog Project, you’ll be able to include these expenses, too.

Importing the file

Go to the system’s main menu, then go to the Management Reports group, select Import and Export and then select Import of Expenses. Next, go to the Select File tab and select the import file. This shows the import file data in table format on the Select Expenses tab. Now mark the rows in the import file that you wish to import. Import the file by selecting Import in the Select action drop-down list, and click OK. This imports the file into TimeLog Project, showing the predefined fields.

Import file requirements

To read the comma-separated import file, each row must include 11 fields in a specific order. Also, the fields require specific formatting.
The names of the corresponding fields in your financial system don’t necessarily match those of the destination fields in TimeLog Project. Likewise, the fields may appear in a different order in TimeLog Project than they do in the import file.

Find out how to get started by reading these user guides:

How to import purchases/expenses in TimeLog Project

How to format your file for importing expenses into TimeLog Project

comments powered by Disqus

Share this article