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.

Master Consolidated View
Mapping Reconciliation / Bank accounts

Bank accounts

Bank feed nicknames and Sage bank ids matched to eight accounts, with internal clearing accounts kept as members that never expect a statement line.

16 approved1 need review1 suggested
Configuration
Dimension · reads 2 connections
Reconciles into
Bank AccountsBANK_ACCOUNTS
8 canonical values · 18 treatments
Sources
Banking dataSage 300 CRE
Members
8 · 2 source values excluded
Canonical values a source value can map to.
Canonical values
8 targets. Every approved treatment resolves to one of these.
  • Frost Operating LGVFROST-4471
    Longview operating, funds AP runs
    3 values
  • Frost Operating ESTFROST-4472
    Eastland operating
    2 values
  • Frost Operating ROSFROST-4473
    Roscoe operating
    2 values
  • Frost Operating ASHFROST-4474
    Ashdown operating
    2 values
  • Peoples RavennaPEOPLES-3310
    Ravenna operating, separate bank
    2 values
  • Frost LockboxFROST-8820
    Customer receipts, all shops
    2 values
  • Frost PayrollFROST-4489
    Funded by sweep before each pay date
    2 values
  • Notes clearing (internal)NOTES-CLR
    Internal clearing, never receives statement lines
    1 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.