Import business expenses from Excel

From Protemos Wiki
Jump to: navigation, search

Import business expenses from Excel page: https://cloud.protemos.com/expense-import/index

If you already have the list of business expenses, you can easily import it on this page without entering such information manually.

To do that, go to the Business expenses page and click the "Import from Excel" button:

Import expenses.png

1. Download the template file for import by clicking the "Download Excel template" link, and fill it out.

2. Click the "Choose file" button to upload the template with your information into the system.

3. Click the "Submit" button to import the template:

Download the template.1.png

If the filled file has no mistakes, the information from it will be imported into the system.

Otherwise, the file will be returned with an indication of the found mistakes in the Errors column. Correct the mistakes to be able to import the information again.

1. Download and open the Expense template. Here you can see the following:

Import template for expenses.png

2. Copy and paste the required information about expenses.

  • The "Paid at" field should be filled in in the following format: "YYYY-MM-DD HH:MM"

3. You need to select the available options from drop-down lists to specify: Legal entity, Category, and Currency.

Retrieved from "https://wiki.protemos.com/index.php?title=Import_business_expenses_from_Excel&oldid=24447"