Find the outcome you need.

• Inspectable example

  Synthetic Stripe payout: five charges, two refunds, one deposit and a clearing balance that returns to zero

  A worked, invented payout shows how gross charges, fees and refunds add up to the single bank deposit and what ledger entries make the bank line match.

• Inspectable example

  Synthetic mapping table: eight categories and what a sync should do with each

  An invented category-to-account table shows mapped, unmapped, archived, renamed and reused-code cases, with the disposition a checked mapping should give each line.

• Inspectable example

  Synthetic monthly drift list: one duplicate, one missing refund and one timing item

  An invented month shows how matching by identifier turns two differing totals into three itemised, explained or open differences with a named next step.

• Inspectable example

  Synthetic foreign-currency check: the same 100.00 USD order with Xero-style and QuickBooks-style rates

  Invented arithmetic shows how a copied, inverted or default rate changes the base total, and how treating minor units as whole units shrinks a yen amount a hundredfold.

• Troubleshooting guide

  Xero and QuickBooks request keys help a retry, but not for as long as you might think

  Compare what Xero's Idempotency-Key and QuickBooks Online's request id protect, for how long, and why a stored order identity and a lookup remain the lasting control.

• Troubleshooting guide

  Duplicate Xero contacts: choose the identity your sync matches on before cleaning anything

  Separate Xero's ContactID, ContactNumber, name and account number, and design a match order that survives a changed email, a same-name pair and an archived contact.

• Troubleshooting guide

  QuickBooks "Stale Object Error": the version token your update used is out of date

  Understand SyncToken, why a sync keeps an old one, and how read-before-write, sparse updates and a written conflict rule remove intermittent update failures.

• Troubleshooting guide

  A bulk Xero job loses orders when it meets a rate limit: pace it and keep a checkpoint

  Read Xero's limits, understand why a 429 or a batch response can silently drop orders, and design pacing, per-item checks and a checkpoint so every order ends created or held.

• Troubleshooting guide

  One Stripe deposit, many sales: why the bank line matches nothing in the ledger

  Explain how an automatic Stripe payout bundles charges, fees and refunds into one net deposit and how a clearing account and a payout-level entry make the bank line match.

• Troubleshooting guide

  PayPal sales reach the ledger but refunds and fees do not: reconcile three separate records

  Treat a PayPal sale, its refunds and its fees as linked but separate records, read amounts from PayPal rather than recomputing them, and hold a refund until its sale exists.

• Troubleshooting guide

  PayPal webhooks can repeat and arrive late: make the ledger update safe to repeat

  Use PayPal's delivery contract to design an event inbox with a unique event id, raw-body verification, held dependent events and a report-based safety net.

• Troubleshooting guide

  A PayPal report export leaves gaps: 31-day windows, a three-hour delay and a per-request record cap

  Plan non-overlapping report windows with a lag, page through every result, deduplicate, and treat a too-large error as a signal to shrink the window, so an export or replay neither misses nor repeats PayPal transactions.

• Troubleshooting guide

  Which ledger account does this line post to? Replace hard-coded codes with a checked mapping table

  Design a category-to-account table keyed by account identifier, validated against the live chart before each run, with no default account and a held list for gaps.

• Troubleshooting guide

  The same exchange rate means opposite things in Xero and QuickBooks Online: check direction and units

  Compare how Xero and QuickBooks Online express rates, why a copied rate inverts the base total, why a default of one is wrong, and how currency minor units cause factor-of-100 errors.

• Troubleshooting guide

  Expenses import as bills but the receipts are missing or on the wrong bill

  Link expense, bill and receipt through one expense id, attach files after the bill exists within Xero's limits, and make a re-import safe, with draft-only creation.

• Troubleshooting guide

  A scheduled Google Sheets export stops at the same row or shows old numbers: check limits and state

  Understand Apps Script run-time and daily trigger limits, trigger ownership, Sheets API quotas and locks, and design a staging swap and status block so failures are visible.

• Troubleshooting guide

  Reading Xero invoices: paging, itemCount and If-Modified-Since so a report is complete

  Use Xero's paging defaults, pagination object and If-Modified-Since header to read every invoice, advance an incremental watermark safely and prove completeness.

• Troubleshooting guide

  A Xero sync that quietly stopped: refresh tokens, quiet spells and parallel refreshes

  Understand Xero's token lifetimes, why an infrequent or parallel integration loses its connection, and what the connection owner must do, so a stopped sync is noticed at the next check.

• Troubleshooting guide

  Reconciliation drift: six kinds of difference between a payment processor and a ledger

  Classify differences as missing, extra, amount, duplicate, timing or currency, match by identifiers rather than totals, and decide what is escalated before a monthly list is trusted.

• Platform

  Xero integrations: identity, limits, accounts and currency decide whether a sync can be trusted

  What Xero documents for integration builders (contacts, invoice numbers, idempotency, paging, limits, accounts, lock dates, demo company) and which failures map to which guide or outcome.

• Platform

  QuickBooks Online integrations: version tokens, request ids, throttles and one shared name space

  What Intuit documents for QuickBooks Online integrations (SyncToken, request id, throttling, unique display names, multicurrency, sandboxes) and which failures map to which guide or outcome.

• Platform

  PayPal in your ledger: webhooks that repeat, a report with windows, and refunds with their own fees

  What PayPal documents for reconciliation (webhook retries, raw-body verification, report limits, capture and refund breakdowns) and which failures map to which guide or outcome.

• Buyer collection

  For a bookkeeper: make payment-processor activity reconcile to the ledger without rebuilding it every month

  Questions, evidence and decisions for a bookkeeper who inherits a processor-to-ledger integration that never quite agrees with the bank.

• Buyer collection

  For an operations lead: know when a finance sync has stopped, duplicated work or dropped orders

  Three counts, three owners and four questions that tell an operations lead whether a sync into the accounting system can be trusted this month.

• Collection

  Processor to ledger to bank: diagnose a month that does not reconcile, in this order

  An ordered process map: confirm scope, payout type, payout entries, refunds and fees, duplicates, timing and report completeness before asking anyone to change an integration.

• Collection

  A finance sync that cannot be trusted: check these in order before re-running anything

  An ordered process map for a broken invoice sync: connection, completeness, accounts, contact identity, retries and duplicates, updates and currency, then re-count.

• Free tool

  CSV header diff: find missing, added, renamed and duplicate columns between two files

  Paste two CSV header rows, or read the header of two small files in your browser, and see missing, added and likely renamed columns, duplicate and empty headers and the delimiter. Nothing is uploaded.

• Free tool

  Invoice rounding bench: compare per-line and total rounding, half-up and half-even

  Enter invoice lines and see net, tax and gross under four rounding rules side by side, in exact whole-number minor units, with the difference between summing lines and rounding the total. Not tax or accounting advice.

• Free tool

  Pack and case unit-price calculator: compare supplier prices per single unit

  Enter supplier price lines priced per unit, pack or case. Get the exact price per single unit, the working, and the lines whose pack basis is unclear. No floating point.

• Buyer collection

  For a bookkeeper retyping supplier invoices: get a batch into rows, with the doubtful ones listed

  Measure whole invoices, not fields. Check the arithmetic on every invoice, keep an exceptions list, and test on invoices you labelled and the tool has not seen.

• Buyer collection

  For an analytics lead with conflicting numbers: define the key metrics once, then test any question tool against them

  Settle what each metric means, write it as code, and prove it against control totals before an AI tool or a colleague asks the data a question.

• Buyer collection

  For a data engineer with an AI step already in production: give it a test that fails when it gets worse

  Build a labelled golden set, grade by exact match in code, prove the test fails on planted regressions, then score it monthly with fresh rows.

• Buyer collection

  For a purchasing manager whose supplier changed every product code: match old to new without guessing

  Count exact barcode matches separately, match the rest on attributes, send look-alikes to an unsure list, and never create an identifier.

• Collection

  From messy files to numbers you can trust: the order to put checks around data jobs that use AI

  Six steps, from reading documents and matching records to defining metrics, watching data and keeping AI steps honest, each with the outcome that covers it.

• Inspectable example

  A synthetic golden-set test: eight planted changes, five that must fail and three that must pass

  An invented extraction step and an invented test show which changes a golden-set test must catch, which it must let through, and what a clear verdict looks like.

• Troubleshooting guide

  Invoice extraction: why whole-invoice accuracy matters more than field accuracy

  A small public test shows how a 91.7% field score can hide an invoice error rate of 25% to 40%, and what an arithmetic check can and cannot catch.

• Troubleshooting guide

  Matching company names across two lists: standardise, block, then use a model only for the unclear pairs

  How record linkage tools work, why comparing every pair is wasteful, and why the false-link rate on look-alikes is the number to test.

• Troubleshooting guide

  A forecast must beat a simple baseline: how to test one on your own history

  Rolling-origin testing against mean, naive, seasonal-naive and drift forecasts, and why a language model is not a reason to trust a forecast.

• Troubleshooting guide

  Asking your data questions: define the metrics before you let a tool write queries

  What two 2026 and 2024 studies found about query-writing tools on raw tables, and why definitions and a question set come first.

• Troubleshooting guide

  Barcodes and product identifiers in a feed: supply them only when you are sure

  What Google Merchant Center says about GTINs and categories, and a simple rule for any tool that fills or matches product data.

Can't find it? Describe a custom outcome.