Mappings
Every data point across projects
The dimensions, objects, and derivations the organization consolidates from every connection, how source values reconcile into them, and where each one comes from.
Bank reconciliation exceptions
The match rules for each transaction kind, what becomes a composite match, and what is an exception with an owner.
7 approved1 suggested
Configuration
Derivation · reads 2 connections
Reconciles into
Bank Reconciliation ExceptionsBANK_REC_EXCEPTIONS
3 canonical values · 8 treatments
Time basis
Value date, plus or minus 3 days
The date every input aligns on.
Formula
BANK_TRANSACTIONS FULL OUTER JOIN Sage cash entries ON bank_account, amount, value_date ± 3d, reference; keep rows without an exact or composite match
Canonical values
3 targets. Every approved treatment resolves to one of these.
- MatchedMATCHEDOne bank line, one Sage entry
4 values - Composite matchCOMPOSITEOne bank line, several Sage entries1 values
- ExceptionEXCEPTIONNo match, with a reason and an owner2 values
Tell Eagle how to reconcile
Plain English. Eagle re-treats the matching rows and says what it did.
Instructions in effect
Nothing yet. Anything you say is applied to the table and kept for new source values.
Select rows to preview how they combine into a canonical value. Click a source value to inspect or edit its treatment. Hover a confidence to see why.