Reconciliation guides

One guide per template: the two exports you need, how their rows are matched, sample files, and the steps to rerun it next month.

Templates10 guides

Shopify orders and 3PL shipments on Name Orders and the payout report on Name Payouts and the orders inside them sum minus fee Amazon settlement and orders total compared PayPal and the bank statement dates within 2 days Stock count and system inventory qty compared Timesheets and payroll hours compared CRM customers and subscriptions on email Data before and after a migration status compared Supplier prices against last period price compared

Every guide comes with

Two sample files you can download, the template that opens in the app with one click, and the result the recipe gives on those samples, so you know what a correct run looks like before you try your own files.

Template tp-01Read the guide

Name: Orders to shipments
Files: Shop orders · 3PL shipment report
Match: on Name
Samples: tp-01-orders.csv, tp-01-shipments.csv

Open in appDownload samples

Rules you no longer keep in your head

For centuries a bookkeeper ticked each line of one book against another and carried what did not agree to the next page. The rules lived in their head.

A guide writes those rules down once, as a recipe, so the same check runs the same way every month, whoever runs it.

Orders to shipmentsrecipe · a few kilobytes

{
  "sources": [
    "orders",
    "shipments"
  ],
  "keys": [
    {
      "leftColumnId": "Name",
      "rightColumnId": "Order Number"
    }
  ],
  "mode": "exact"
}

What next month looks like

Run the same template on the next exports and last month’s open rows come back with their age. The ones whose partner turned up close, with the date.

tp-01, the month after11 of 13 matched · closed 2024-02-29

Order	Status	Since	Age
SO-0998	Only in shipments	2024-01-02	58days
SO-1007	Values differ	2024-01-15	45days
SO-1009	Matched	2024-01-27	closed 2024-02-03
SO-1011	Matched	2024-01-30	closed 2024-02-06