Darpan.Request a walkthrough
Notes

Notes from the team.

Working notes on reconciliation: matching data across the systems that never quite line up, and proving what’s left over. For operators and finance both.

Guides

Reconciling Shopify orders against your ERP: the fields that drift.

MAY 28, 2026Guides

NetSuite reconciliation: where inventory and the GL disagree.

MAY 26, 2026Guides

OMS reconciliation: matching order management against the source of truth.

MAY 23, 2026AI

Can an AI agent reconcile your data? What works and what doesn’t.

MAY 20, 2026AI

Prompting an AI model to help reconcile two files: patterns that work.

MAY 16, 2026Spreadsheets

Reconcile two files in Excel with XLOOKUP, the right way.

MAY 12, 2026Spreadsheets

Finding what’s missing: Excel set differences with COUNTIF and MATCH.

MAY 8, 2026Methods

How to reconcile two systems by hand: a repeatable method.

MAY 5, 2026Guides

Amazon settlement reconciliation: matching disbursements to your ERP when the reserve hides the rest.

APR 22, 2026Guides

Marketplace payout reconciliation: the clearing account that makes every platform tie out.

APR 18, 2026Spreadsheets

A free reconciliation spreadsheet template for Shopify and Stripe payouts.

APR 15, 2026Guides

AR and AP reconciliation: when the aging report doesn’t tie to the GL.

APR 8, 2026Guides

Multi-currency reconciliation: telling an FX difference from a real one.

APR 4, 2026Spreadsheets

CSV gotchas that silently break a reconciliation: encoding, delimiters, and mangled IDs.

APR 1, 2026Guides

Why Shopify deposits never match your sales (and how to reconcile payouts instead).

MAR 28, 2026Operations

What auditors look for in a reconciliation — and how to be ready before they ask.

MAR 25, 2026Methods

Fuzzy matching records: catching the duplicate the invoice number hides.

MAR 21, 2026Guides

Bank reconciliation, step by step (and why it never feels done).

MAR 18, 2026Concepts

What we mean when we say “primary ID.”

MAR 14, 2026Methods

A month-end tick-and-tie checklist (and why the order matters).

MAR 10, 2026