Reconciliation Workbench

Overview

The Reconciliation Workbench is a dual-pane interface that allows you to link related financial data items together, creating a complete Money Flow graph of your financial data.

How Reconciliation Works

Reconciliation links connect any two entities (headers or line items) to establish relationships:

• Invoice totals linked to bank statement transactions
• Foreign exchange contracts linked to bank transfers
• Purchase orders linked to invoices
• Any financial data items that are related

Dual-Pane Interface

Left Pane (Source)

Select source entities to reconcile:

• Use Search mode to find entities across all documents
• Use Browse mode to navigate folders and select specific documents
• Filter by document type, date, amount, and other criteria

Right Pane (Target)

Select target entities to link with sources:

• Same search and browse capabilities as the left pane
• Independent filtering and selection

Linking Entities

1. Select one or more entities in the left pane (source)
2. Select one or more entities in the right pane (target)
3. Click "Link" to create reconciliation relationships
4. Specify the reconciled amount if different from the default

Auto-Reconciliation

The Workbench can automatically suggest matches:

• Mapping-based - Uses configured field mappings with day drift tolerance
• Exact date match - Falls back to exact date matching
• Duplicate detection - Identifies potential duplicates for review

Configure field mappings to match source and target fields automatically.

Browse Mode

Switch to Browse mode to navigate folders and select specific documents:

• View line items from a selected document
• Support for documents with multiple collections (e.g., holdings + activities)
• Seamless integration with the reconciliation workflow

Use Cases

Bank Reconciliation

Link bank statement transactions to invoices, receipts, or other documents to track money flow.

Invoice Matching

Match purchase orders to invoices, or invoices to payment records.

Multi-Step Reconciliation

Create chains of reconciliations to track money flow across multiple documents and transactions.