Format drift
CardConnect, First American, Secure Bancard, and other residual files do not stay identical. A renamed column or new fee line becomes a silent calculation risk.
Stop splitting residuals in spreadsheets
01
The pain
Every residual cycle starts the same way: export files from one or more processors, paste into a workbook, chase which tab is “the real one,” and hope the split formulas still match last month’s agreements. Reps ask for statements. Ops rebuilds mappings when a column moves. Finance asks why payouts slipped a day—or a week. The spreadsheet is familiar, but it was never designed to be your commission system of record.
02
What breaks
Version conflicts
Email attachments and shared drives multiply “final_v3_USE_THIS” files. Nobody can prove which workbook drove last month’s payouts.
Agreement drift
Buy rates, overrides, and multi-rep splits live in cells and tribal knowledge. When a deal changes, half the formulas get updated and half do not.
Opaque rep experience
Reps cannot self-serve balances or merchant performance, so ops becomes a help desk for residual questions.
Slow close
Manual refreshes and rechecks stretch the path from residual file to approved payout, even when the portfolio itself did not grow.
03
How MySplitPay replaces the workflow
MySplitPay keeps the same business logic you already run—processor residuals in, split agreements applied, reps paid—but moves it into a purpose-built residual and commission ledger instead of a fragile workbook.
1
Upload
Upload residual reports; Smart Reports AI detects common formats so you are not rebuilding import maps by hand.
2
Auto-split
Auto-split commissions to reps from your agreements, with live balances as files process.
3
Review and pay
Review and pay from a ledger, and give reps portal access to their own numbers so statement requests drop.
Merchant Hub groups MIDs under the businesses they belong to, so you manage customers—not just a flat MID list—across locations and processors.
04
Spreadsheets vs MySplitPay (honest comparison)
Spreadsheet
MySplitPay
System of record
A file (or many).
A live ledger tied to uploads, splits, and payouts.
Report intake
Manual paste/import and column mapping.
Upload with Smart Reports AI format detection for supported processors.
Split rules
Formulas and tabs you maintain.
Agreements applied in-product when residuals post.
Rep visibility
Email exports or shared sheets.
Rep portal included on plans.
Setup cost
“Free” until ops time and error risk count.
Starter $50/mo (3 reps, 1 processor); Growth $200/mo (10 reps, 3 processors); Enterprise custom; 30-day free trial with no credit card.
What we do not claim
Spreadsheets can still work for a tiny book with one processor and one person who never leaves. MySplitPay is for teams that have outgrown that and need a repeatable residual close.
More detail on processors, trial terms, and security is on the homepage FAQ.