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.

Input Requirements

  • A journal entry file sourced from your ERP systems (SAP, Oracle, Microsoft Dynamics, etc.).

  • 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

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

  • A population of journal entries that are considered out of your expected ID range

Last updated

Was this helpful?