Pending payouts that don't tie to settlement math
$943K marked "pending" across processors, none of it explainable from the settlement files. Settled ages every settled-not-funded dollar and names the batch it belongs to.
Settled reads your processors, your bank, and your store, then reconciles them per MID and per period — gross, refunds, chargebacks, fees, reserves, in-transit — and produces journal entries that agree with QuickBooks.
Built by operators who closed the books across five processors by hand. Private beta.
| Processor | MID | Gross | Refunds | Chargebacks | Fees | Eff. rate | Net funded | Tie-out |
|---|---|---|---|---|---|---|---|---|
| EMS | 5137·4402 | 1,842,610.44 | (96,204.18) | (18,740.00) | (171,388.02) | 9.30% | 1,556,278.24 | Agreed |
| Payarc | 8820·1176 | 1,204,880.10 | (74,336.55) | (11,205.00) | (128,919.73) | 10.70% | 990,418.82 | In transit |
| Maverick | 3391·7708 | 706,442.90 | (39,118.60) | (22,480.00) | (81,240.14) | 11.50% | 563,604.16 | Var 412.60 |
| Kurv | 6604·2295 | 488,205.75 | (21,904.30) | (7,120.00) | (52,663.19) | 10.79% | 406,518.26 | Open item |
| Total | USD | 4,242,139.19 | (231,563.63) | (59,545.00) | (434,211.08) | 10.24% | 3,516,819.48 |
Open item. Deposit of 282,410.00 posted 19 Aug with no matching settlement record in any processor file. Not a timing difference — no counterpart exists in the batch.
282,410.00Every one of these happened in a single month-end, to a real operator, with a spreadsheet and the best intentions. Reconciliation done by hand catches the ones you already suspect.
$943K marked "pending" across processors, none of it explainable from the settlement files. Settled ages every settled-not-funded dollar and names the batch it belongs to.
Rolling reserve is a balance, not a fee. Settled keeps a reserve ledger per processor — holds, releases, running balance — so the money you're owed is a number, not a guess.
A 10.5% effective rate hides in four statements with four fee vocabularies. Settled normalizes fees by type and shows the rate per processor, per MID, per month.
A $282K deposit with no settlement behind it, or a settlement with no deposit, looks like a timing difference until it isn't. Settled flags it as an open item with an owner and an age.
Statements and feeds come in; a reconciled ledger and a set of journal entries go out. Nothing in between is a spreadsheet.
Shopify installs as an app. Processors connect by API where they offer one, or by monthly statement upload where they don't — PDF, CSV, or XLSX. Bank accounts connect through Plaid.
Settlements are matched to deposits — exact, within tolerance, split, or batched. Fees are separated from payouts. Reserves and in-transit balances roll forward. Anything that doesn't tie becomes an open item.
Journal entries — gross, refunds, chargebacks, fees by type, reserve movements, clearing — post to QuickBooks with idempotency keys. The QBO bank balance is checked against what the ledger says it should be.
Every number on every screen traces to the lines that produced it. That is the whole design.
Per MID, per period: gross, refunds, chargebacks, fees, net funded, and a tie-out state for every row.
Tiered quantity breaks with remote-destination tables and Shopify variant pinning. A deterministic landed cost for every order line; supplier invoices matched line-by-line.
Owner, admins, and client teams with per-company permission whitelists. Every action is in the audit log with who, when, and from where.
A reserve ledger per processor and an aging view of settled-not-funded balances, so cash you are owed is a balance, not a rumor.
Fees normalized by type — interchange, markup, chargeback, PCI, misc — and expressed as a rate per MID, per month, with the trend.
Chart-of-accounts mapping per processor and fee type. Entries push with idempotency keys; a re-close reverses cleanly.
Each layer reads only from the ledgers below it. The P&L is built from reconciled settlements and matched supplier costs, not from a screenshot of a dashboard.
Every payout tied to a settlement tied to a sale. Reserves, in-transit, fee sweeps, effective rate.
Expected cost per order line; supplier invoices matched and varianced; true margin per order.
Revenue, COGS, fees, refunds, chargebacks, opex from bank categorization. Tax-ready, always.
Inventory valuation, wholesale invoicing, nexus tracking, cash-flow planning, more channels.
Financial data gets the isolation it deserves. This is how the platform is built, not a page of promises.