After uploading your Bulk Import, if the system detect errors in the file an Error Report will be generated. This guide explains what those error messages mean and how to fix them quickly.
1. Errors in both Spend and Activity- based bulk import:
📅 Start Date
Description
The start date of the transaction.
Potential error messages
"Start date is missing""Start date is not a valid date""Start date cannot be after End date"
How to fix it
Make sure the field is not empty.
Only supports DD.MM.YYYY as a date format.
Use same date format in every row.
Check that the Start Date is earlier than the End Date.
📅 End Date
Description
The end date of the transaction. Only required if transaction occured over a time period (e.g. provision of services during the whole year).
Potential error messages
"End date is not a valid date"
How to fix it
Only supports DD.MM.YYYY as a date format.
Use same date format in every row.
📍 Location
Description
The name of the location where the activity takes place. It must match an existing location in the app.
Potential error message
"Location with name '[name]' doesn’t exist in the app. Correct the name or create a new location '[name]' on the Company page"
How to fix it
Double-check the spelling.
Use the exact location name as listed on your company page in the app. (case insensitive e. g. "New York Office" will work as same as "new york office")
If needed, create the location on the Company page.
🏢 Supplier Name
Description
The name of the company or individual providing the product or service.
Potential error message
"Supplier is missing"
How to fix it
Fill the blank cells
Enter a clear, valid name (e.g.,
Green Tech Solutions).
📝 Description or Activity description
Description
A short explanation of what the item or service is.
Potential error message
"Description is missing"
How to fix it
Fill the blank cells
Provide a simple and clear summary (e.g., "Solar panel installation").
2. Errors applicable only to Spend- based bulk import:
💰 Price
Description
The cost of the item or service. This must be a positive number, without any letters or symbols.
Potential error messages
"Price is missing""Price is not a valid number"
How to fix it
Make sure you've entered a number greater than zero.
Do not include symbols (e.g., enter
100instead of$100)Make sure numbers are formatting as "number" and no "text"
Delete any comma. We only support "." as a decimal separator.
💱 Currency
Description
The type of money used (e.g., USD, EUR). It must match a known currency in the system.
Potential error messages
"Currency is missing""Unknown currency"
How to fix it
Enter a common 3-letter currency code like
USD,EUR, orGBP.Check for typos (case insensitive EUR will work as same as eur)
Check if the currency code use is included in ISO 4217
3. Errors applicable only to Activity-based bulk import:
📊Activity amount
Description
Quantity of the activity (material or service). This needs to be a number.
Potential error messages
"Activity amount is missing""Activity amountis not a valid number"
How to fix it
Make sure you've entered a number greater than zero.
Do not include symbols (e.g., enter
100instead of100kg)Make sure numbers are formatting as "number" and no "text"
Delete any comma. We only support "." as a decimal separator.
📏 Activity Unit
Description
Unit of measurement for the activity (material) or service.
Potential error messages
"Unit is missing""Unknown unit"
How to fix it
Check is a weight unit.