# Journal Entries - Duplicates and Sequence Testing

This template takes a look at your journal entries. It helps identify duplicates by ID and amount. It also helps you identify any JE ID's that might be missing in a sequence or out of an expected range of ID's.

{% embed url="<https://auditboard-education-services.wistia.com/medias/rwretl9q71>" %}

### Input Requirements

* A journal entry file sourced from your ERP systems (SAP, Oracle, Microsoft Dynamics, etc.).
* [Parameters](https://docs.auditboardanalytics.com/workflows/parameters)
  1. Journal Entry Sequence Beginning: Beginning number of journal entry ID's you'd expect to see
  2. Journal Entry Sequence End: Ending number of journal entry ID's you'd expect to see
  3. [File Input Parameter](https://docs.auditboardanalytics.com/workflows/parameters/file-input-parameters)

### Output Expectations

* A population of journal entries that are considered duplicate by ID
* A population of journal entries that are considered duplicate by amount
* A population of journal entries that are considered missing from your sequence&#x20;
* A population of journal entries that are considered out of your expected ID range