What is reconciliation and how does it work?

Updated last monthSara AhlénIntegrations

When you import data into Velory — from an HRIS like BambooHR, an MDM like Jamf, a telco provider, or a CSV file — Velory needs to figure out whether imported records match existing ones or should be created as new. This process is called reconciliation.

Before you begin

You need Admin access to view and manage reconciliation. Navigate to Settings → Reconciliation to see the reconciliation pages.

The Data Reconciliation page with cards for Hardware Devices, Employees and Phone Subscriptions
Three queues, one per kind of imported record.

How reconciliation works

When data arrives from an external source, Velory follows this process:

  1. Import — Data is received from an integration (HRIS, MDM, telco) or uploaded via a file. Each imported record becomes a candidate.
  2. Matching — Velory compares each candidate against your existing records using identifiers like email, serial number, or employee ID. Each match gets a confidence score (0–100%).
  3. Auto-resolution — High-confidence matches can be automatically merged if your reconciliation policies allow it. Unmatched candidates can be automatically created as new records.
  4. Admin review — Candidates that need manual attention appear in the reconciliation page for you to review and decide what to do.

What can be reconciled?

Reconciliation covers three types of records:

TypeWhere to find itMatched by
HardwareSettings → Reconciliation → HardwareSerial number, MAC address, MDM external ID
EmployeesSettings → Reconciliation → EmployeesEmail, employee number, employee ID, SSO ID
Phone SubscriptionsSettings → Reconciliation → Phone SubscriptionsPhone number, external reference, email + name

Each type has its own reconciliation page with a table of candidates, filters, and actions.

Candidate statuses

Each imported candidate has a status that tells you where it is in the process:

StatusWhat it means
PendingNot yet processed — awaiting matching
MatchedA match was found and auto-merged (if policies allow)
Review RequiredA potential match was found but needs manual review — either low confidence or multiple possible matches
No MatchNo existing record matched this candidate
Awaiting WorkflowA workflow automation is handling this candidate
CreatedA new record was created from this candidate
MergedThe candidate was merged with an existing record
SkippedAn admin dismissed this candidate without action
FilteredExcluded by a workflow automation

Reconciliation policies

You can control how Velory handles matches automatically, per integration source:

  • Auto-merge — When enabled, high-confidence matches are merged automatically without admin review. When disabled, all matches are queued for manual review.
  • Auto-create — When enabled, unmatched candidates are automatically created as new records. When disabled, they are queued for manual review.

These policies let you balance speed (automatic handling) with control (manual review). You can configure them per source in your integration settings.

Good to know

When do candidates appear?

Candidates appear whenever data is imported — whether through a scheduled integration sync (e.g. BambooHR syncing every few hours), a manual sync trigger, or a CSV file upload.

How is confidence calculated?

Confidence depends on the type of identifier that matched. Exact matches on unique identifiers (like serial numbers or email addresses) give 100% confidence. Fuzzy matches on names give lower confidence. The match reason is shown alongside the confidence percentage so you can see why Velory thinks a candidate matches.

Can I see the history of what was resolved?

Yes. Use the status filter on the reconciliation page to view Resolved candidates. This shows everything that has been merged, created, or skipped — useful for auditing past imports.

Was this article helpful?