Reconciliation Overview
Cross-system data validation: Zoho 2.0 · Zoho Legacy · Xero
Sales Orders
0
Credit Notes
0
Inventory Items
0
Open Issues
0
Data Integrity
Date range in DB
— → —
Deduplication
Enforced by DB constraint
Each source ID can appear once per system
Last successful sync
Zoho 2.0—
Zoho Legacy—
Xero—
PO Coverage — 1 Jan 2025 to 11 Mar 2026
Every Zoho PO should have one Xero invoiceZoho Total
0
0 legacy+0 2.0
Xero Total
0
baseline
Gap
0
0% aligned
Zoho orders with a matching Xero invoice0%
Order Value & Volume — 1 Jan 2025 to 11 Mar 2026
Zoho (combined) vs Xero| Metric | Zoho Total | Xero Total | Gap |
|---|---|---|---|
| Total order value | £0.00 | £0.00 | £0.00 |
| Avg order value | £0.00 | £0.00 | £0.00 |
| Total units sold | — | — | — |
Zoho Legacy vs 2.0 breakdown0 legacy · 0 2.0
Zoho Legacy0% of orders
Orders
0
Total value
£0.00
Avg order
£0.00
Units sold
—
Zoho 2.0100% of orders
Orders
0
Total value
£0.00
Avg order
£0.00
Units sold
—
Match Status — 0 total groups
Matched
0
0% of total
Mismatched
0
0% of total
Missing
0
0% of total
Ambiguous
0
0% of total
Discrepancy Breakdown — Zoho vs Xero
0 open · 0 total| Field | Open | Total | |
|---|---|---|---|
| No discrepancies yet — run a reconciliation first. | |||
Inventory SKU Reconciliation
View all →SKU Matched
406
Xero + Zoho confirmed
Zoho-only SKUs
527
Not invoiced in Xero
Xero-only SKUs
44
Discontinued / DO NOT USE
Active Xero SKUs with a Zoho match100% — all active SKUs matched
44 Xero-only SKUs are all legacy/discontinued items (prefixed XX, SPARE, or test codes) — no active product gaps.
Gap Report — Zoho Orders Missing from Xero
Download CSV →Orders
194
Zoho Historical only
Total Value
£1,480,580.48
Jan – Mar 2025
Xero invoices missing Zoho
£88,906.51
4 invoices
Top customers by gap value
| Customer | Orders | Value |
|---|---|---|
| All customers | 0 | £0.00 |
Gap by month
Note: Xero SKU data is only available for Shopify D2C orders. Large wholesale invoices in Xero were entered without item codes, so their units cannot be attributed to specific SKUs. Xero totals in the summary table above are complete.
Units Sold per SKU — Jan 2025 to present
Zoho: 0 units · Xero: 0 units| SKU | Name | Zoho Units | Xero Units | Difference | Zoho Revenue | Xero Revenue |
|---|---|---|---|---|---|---|
| No line item data yet — sync sales orders first. | ||||||
Recent Sync Runs
View all →| Source | Entity | Status | Fetched | Inserted | Failed | Started |
|---|---|---|---|---|---|---|
| No sync runs yet — trigger your first sync above. | ||||||