# 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**: 

{% content-ref url="../../../clear-finance-cloud/cfc-api-reference/resources-and-masters/purchase-document-line-object" %}
[purchase-document-line-object](https://docs.cleartax.in/cleartax-docs/clear-finance-cloud/cfc-api-reference/resources-and-masters/purchase-document-line-object)
{% endcontent-ref %}

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**: 

{% file src="<https://2888774781-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LZ9fXxeBEm3pJiVldcu%2Fuploads%2FcMJtIpym4PFyyOkg39Gf%2FIngestion%20Error.csv?alt=media&token=d99a6a7e-2934-4150-a401-b307799c8270>" %}

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.&#x20;

**Sample File**:&#x20;

{% file src="<https://2888774781-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LZ9fXxeBEm3pJiVldcu%2Fuploads%2F1euWbFR4Q2zesYmPbzIJ%2Fdata_bab1e89c-c246-4f93-9246-8e0e10d09687.gz?alt=media&token=570575ec-1c74-4ec6-a749-1baf7fe65e3c>" %}

## Vendor File

**Format**: GZIP File&#x20;

**Sample File**:&#x20;

{% file src="<https://2888774781-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LZ9fXxeBEm3pJiVldcu%2Fuploads%2FVMbTUUzXGrOCvIuFnd9Q%2Fdata_afd71349-1979-493d-91d0-cffe0ce21ed6.gz?alt=media&token=8b240a3a-2509-4bbb-97f0-65d699ad2dde>" %}