Transaction Reconciliation

This page illustrates how to configure and perform reconciliation, including creating new reconciliation tasks, applying automated rules, and manually matching transactions and journal entry data. It also covers how to export reconciliation records.

1. Accessing the Reconciliation module

  1. On the project homepage, navigate to the Reconciliation page.

2. Creating a new Reconciliation task

  1. Click the "New Match Set" in the upper right corner.

  2. Enter the desired reconciliation task name.

  3. Select the account, direction, and other details for the reconciliation task.

  4. In the task detail page, adjust the filters and select the transaction data and journal entries to be used for reconciliation.

3. Automated Reconciliation rules

  1. In the reconciliation task page, click the "Add Rule" button to configure the automated reconciliation rules.

  2. You can match both sides of the reconciliation using criteria such as amount, time, ID, account, etc.

  3. Click the "Start Matching" button to execute the automated reconciliation rule.

4. Manual Reconciliation

  1. Select the Unmatched tab from the top of the page.

  2. On the left panel select the transaction data to manually match, and in the right panel the ledger data to match.

  3. Click the "Match" button to complete manual matching.

5. Exporting Reconciliation tasks

  1. Click the "Export match set" button in the upper right corner to export the records of matched items, unmatched items, and operational logs.

Last updated