1
Upload your files

From the dashboard, click New reconciliation. You will see an upload screen with two drop zones — File A and File B.

File A is typically your primary source — an ERP export, general ledger, or accounts payable report. File B is the file you reconcile against — a bank statement, counterparty report, or subsidiary data.

CSV (.csv) Excel (.xlsx)

The files do not need to have the same column names, the same number of columns, or the same number of rows.

Upload screen — two drop zones

Upload screen — two drop zones

ℹ️ After uploading, Reconcio reads your files and displays row counts for each file before you proceed to mapping.
2
Configure column mapping

After upload, Reconcio analyses both files and suggests how columns correspond. The suggestion is based on column names, data types, and value patterns.

Column mapping — join keys configuration

Column mapping — join keys configuration

Join keys

A join key is the column (or combination of columns) that uniquely identifies a record. Reconcio uses join keys to match rows between files. At least one join key is required.

You can use composite join keys — multiple columns together that uniquely identify a record. For example, InvoiceId + CompanyCode.

Comparison conditions

For non-join-key columns, choose how values are compared:

EQ — must be equal GT — A must be greater than B GTE — A must be ≥ B LT — A must be less than B LTE — A must be ≤ B IGNORE — exclude from comparison
⚠️ Every column must be either a join key or have a comparison condition set. The Run button stays disabled until all columns are configured.
3
Run the reconciliation

Once all columns are configured, click Run reconciliation. The job runs on the server — you can navigate away; the status updates automatically.

Processing time depends on file size. A 10,000-row file typically completes in under 30 seconds. Files with 100,000+ rows may take 1–3 minutes.

Processing screen — reconciliation in progress

Processing screen — reconciliation in progress

4
Review the results

When reconciliation completes, you are taken to the results screen showing the convergence score, four row counters, and a downloadable diff file.

Results screen — convergence score and row counters

Results screen — convergence score and row counters

For a full explanation of every metric and the diff file format, see the Results & Diff File guide →

Using templates

If you run the same reconciliation regularly — same supplier, same ERP export format — save the column mapping as a template. Next time, load the template instead of configuring from scratch.

To save: after configuring column mapping, click Save as template and give it a name. To apply: on the mapping screen of a new reconciliation, click Apply template and select from the list.

Templates list — saved mapping rules

Templates list — saved mapping rules

ℹ️ Templates store column names and join key / condition configuration. If a supplier changes a column name in their export, update the template once.
🕐
Reconciliation history

The History section in the left sidebar shows all your past reconciliations in chronological order. Each entry shows the reconciliation ID, status, file names, row counts, and creation date.

You can filter the list by status (completed, failed, processing) and by date range. Use the ID search to quickly find a specific reconciliation — useful when an auditor asks about a particular run.

History screen — past reconciliations with filters

History screen — past reconciliations with filters

ℹ️ Clicking any row opens the full results of that reconciliation. The diff file remains available until its expiry date shown in the results.
🔑
API Keys

API keys are available on Pro and Enterprise plans. Go to Settings → API Keys to create a key for integrating Reconcio into your own systems.

Each key has a name, optional rate limits (requests per minute / per day), and an optional expiry date. Pass the key in the Authorization header:

Authorization: Bearer <your-api-key>
⚠️ Copy your API key immediately after creation — for security reasons it will not be shown again.

For the full API reference, see the API Reference →

⚙️
Settings & Two-Factor Authentication

Appearance

In Settings → Appearance you can switch the interface language (English, Russian, Chinese) and toggle between light and dark themes.

Change password

In Settings → Security, enter your current password and then the new password twice. The password strength indicator shows whether your new password meets requirements (must contain uppercase, lowercase, digits, and special characters).

Settings — change password with strength indicator

Settings — change password with strength indicator

Two-Factor Authentication (2FA)

2FA adds an extra layer of security via a TOTP authenticator app (Google Authenticator, Authy, or any compatible app).

To enable: click Enable 2FA in Settings → Security. A QR code will appear — scan it with your authenticator app, then enter the 6-digit code to confirm. From that point, every login will require both your password and a fresh 6-digit code.

To disable: click Disable 2FA and confirm with a valid 6-digit code from your app.

Settings — 2FA setup with QR code

Settings — 2FA setup with QR code

⚠️ If you lose access to your authenticator app and cannot log in, contact support. Keep a backup of your authenticator or store backup codes in a safe place.

Supported file formats

Reconcio currently supports the following formats. The first row of each file is treated as the header row. Blank rows are skipped. Leading and trailing whitespace in values is trimmed automatically.

Format Extension Notes
CSV .csv UTF-8 encoding, comma or semicolon delimiter auto-detected
Excel .xlsx First sheet is used. Formulas are evaluated to their computed values.
⚠️ Legacy .xls format is not supported. If you have an .xls file, open it in Excel or LibreOffice and save as .xlsx or export as .csv before uploading.

File size limits

Plan Max file size Max rows (approx.)
Base (free) 10 MB ~50,000
Pro 100 MB ~500,000
Enterprise Unlimited Unlimited