# Data Reconciliation

> Checking that copied data still matches its source. You compare counts and totals.

**Field:** Data Engineering  
**Category:** Governance & Quality  
**Also known as:** Data Recon, Source-to-Target Reconciliation, Row Count Check

## Think of it like

It is like counting your change after you shop. The receipt and your purse must match.

## Definition

Data reconciliation checks that two copies of the same data agree. You compare the source with the place the data was copied to. The simplest test compares row counts. A stronger one also compares totals, like the sum of all orders. If the numbers differ, data was lost, doubled or changed on the way. Teams run it after each load, before anyone reads the new data.

## Example

The shop database shows 1,204 orders last night, but the warehouse has 1,192. The check fails and the load is held back. Emma finds 12 orders stuck on a bad date.

## Example code

```sql
SELECT COUNT(*), SUM(total) FROM orders
WHERE order_date = '2026-11-15';
-- source:    1204 | 52300
-- warehouse: 1192 | 51780
```

The same query runs on both sides. The counts and totals differ, so 12 orders went missing.

## Why it matters

A pipeline can finish green and still drop rows. Only a check against the source shows it.

## Common mistake

Comparing only row counts. The counts can match while the amounts are wrong.

## Three principles

- **Two sides.** The source against the copy.
- **Counts and sums.** Rows first, then totals.
- **Before anyone reads.** Hold the data until it matches.

## Related terms

- [Data Quality Check](https://learn.benibix.com/term/data/data-quality-check)
- [Data Completeness](https://learn.benibix.com/term/data/data-completeness)
- [Data Accuracy](https://learn.benibix.com/term/data/data-accuracy)
- [Data Pipeline](https://learn.benibix.com/term/data/data-pipeline)
- [Data Profiling](https://learn.benibix.com/term/data/data-profiling)

![On the left, a profile card for an email column: 10,000 rows, 312 empty, 9,410 different values, and a highlighted row where test@example.com appears 240 times. On the right, a shop database with 1,204 orders and a warehouse with 1,192, and a highlighted box: 12 orders missing.](https://learn.benibix.com/diagrams/dat2-profile-reconcile.svg)

---

Source: https://learn.benibix.com/term/data/data-reconciliation
Author: Behnia Zarei (a developer in Vienna, Austria, who builds and teaches data, AI and business intelligence at BENIBIX)
Publisher: BENIBIX Learn (https://learn.benibix.com/)
Last updated: 2026-11-18
Licence: CC BY 4.0 (https://creativecommons.org/licenses/by/4.0/). Quote freely with attribution.
