Why reconciliation is still broken for multi-location businesses

If you run a single-location business with one bank account and one payment processor, reconciliation is annoying but manageable. You export two CSVs, eyeball them side by side, and move on.

Now multiply that by 40 locations. Add three POS systems, four delivery platforms, two payment processors, and a payroll provider. Each source has its own format, its own settlement timing, its own fee structure. A single customer transaction might touch five systems before it lands in your bank account.

The spreadsheet ceiling

Most finance teams hit a ceiling somewhere around 10 locations. Below that, a skilled bookkeeper with Excel can keep up. Above it, the combinatorial explosion of sources and timing windows makes manual reconciliation a full-time job — and an error-prone one.

The typical workaround is to reconcile at the summary level: does this week’s total deposits roughly match this week’s total sales? That works until it doesn’t. And when it doesn’t — when a payment processor changes its fee structure, or a delivery platform starts holding funds longer — the discrepancy is buried in thousands of line items with no way to trace it back.

What “reconciled” actually means

True reconciliation isn’t matching totals. It’s linking individual transactions across sources: this sale, to this payment, to this deposit, to this fee deduction. It’s knowing that a $47.82 DoorDash order at your Austin location on Tuesday resulted in a $41.03 deposit on Friday after platform fees, and that the $6.79 difference is accounted for.

That level of granularity is what auditors want, what operators need for decision-making, and what no spreadsheet can sustain at scale.

A different approach

This is the core problem Genledger was built to solve. Instead of reconciling after the fact in spreadsheets, we ingest every transaction from every source as it happens, normalize it into a canonical format, and programmatically link related events across systems.

The result is a living graph of your financial data where every dollar is traceable from origin to destination. Discrepancies surface automatically. Your finance team opens their morning to exceptions — not a blank spreadsheet and a prayer.