Common errors across all data types
Blank cells
Every row in your dataset needs complete information to be processed correctly - all required fields need a data input for every row of your file. If you have blank cells in the quantity data, you should either:
- Input the correct data if consumption occurred
- Enter '0' if no consumption took place for that period
Value limits
Our system cannot process individual values exceeding 1 billion.
If you have a purchase or utility measurement above this threshold, you'll need to split it into smaller amounts in your input data.
Country validation
The spend_country field must use ISO three-letter country codes rather than full country names.
For example:
- United States → USA
- Germany → DEU
- China → CHN
Date-related issues
What date format should I use? Dates must be in valid ISO format. For example:
- YYYY-MM-DD
- 2024-12-01
Other things to keep in mind:
- The start_date must always be before or equal to the end_date
- Dates must fall between January 1, 1970, and January 1, 2100
What happens if my start date is after my end date? If your start_date is after your end_date, the system will flag both fields as errors. Always ensure your dates are in chronological order.
Common Spend or Procurement data errors
Product information
What product information is required? You must provide at least one of these fields:
- Supplier
- Spend category
- Product description
Spend and currency (Spend data only)
Spend data requires both the spend_value and spend_currency fields to be completed.
Quantity and units
Quantity data required both quantity and quantity_unit fields to be completed.
Amounts and units
When uploading data you must include either:
- Both quantity and quantity_unit fields OR
- Both spend_value and spend_currency fields
Providing incomplete pairs will result in errors.