How do you reconcile Square sales across many vendors?

Square is great at being Square. It is not automatically great at being “the market’s unified ledger” because each vendor owns their own account, tax settings, item library, and refund behavior. Coordinators reconcile events, not individual POS companies.

This guide assumes vendors keep Square (good) and you need settlement-grade totals (also good). The trick is to stop imagining a fantasy single-tenant export and start building a workflow that respects multi-tenant reality.

Why this is hard today

You do not get one market-wide Square report unless everyone runs through your merchant account—which most markets will not (and should not) force.

Even when two vendors both use Square, refunds may post on different days, tips behave differently, and cash may never touch Square at all.

This is the reconciliation gap. Nobody owns the number together — and that is exactly what MoneyLayer is built to fix.

Options coordinators use

• Vendor CSV exports emailed to you—high integrity if vendors are consistent; high variance if not.
• Connected ingestion with vendor consent—less manual, requires onboarding and support.
• Self-report with Square screenshots as evidence—worst automation, best realism for holdouts.

Step-by-step

1. Define the event window and gross line. Close-of-day rules matter for night markets. Write them down before you argue about refunds.
2. Build a roster keyed by vendor legal identity. Square location names change. Stable IDs reduce mismatch risk across weeks.
3. Reconcile coverage first, dollars second. Know who is missing before you debate the 2% outliers.
4. Publish payouts only from reviewed totals. Make review a named step with an owner so “someone checked it” is true.

How MoneyLayer handles this

MoneyLayer’s Square lane is designed around consent-based connected data plus structured fallbacks. If a vendor will not connect, you still need a policy for them—software cannot waive that.

FAQ