Input and output templates

Clear Purchase Document Template

Format: CSV, XLS, XLSX (In the case of XLS or XLSX, Clear will read only the first sheet in the file).

Template:

Purchase Document Line Object

In addition to the fields in the Clear PR template, we support up to 10 additional fields that can be ingested into Clear as custom fields (eg. Tax codes / ERP usernames/others).

Ingestion Error

Format: CSV (irrespective of the input file)

Template with Sample Data:

2KB

Ingestion Error.csv

Open

The template of the file will be the same as the input file. However, in addition to the columns in the input file, there will be 2 additional columns that have "No. of Errors" and "Error Message".

Reconciliation Result

Format: GZIP File

This file will be in JSON Lines format where each line in the file is a separate JSON object.

Sample File:

1KB

data_bab1e89c-c246-4f93-9246-8e0e10d09687.gz

Open

Vendor File

Format: GZIP File

Sample File:

218B

data_afd71349-1979-493d-91d0-cffe0ce21ed6.gz

Open