Reconciling lender commission statements

A lender statement lists what they paid, not what they owed. Matching it by hand, line by line against your book, is how short-pays get missed. The reconcile screen does the matching and leaves you the judgment calls.

• ReconciliationReconciliation is a merchant's contractual right to have fixed MCA payments adjusted to match actual receipts when sales fall, a key feature of the true-sale structure.

Export the statement as a CSV (up to 5 MB). It needs a merchant name or a deal reference column, and an amount column. A date column helps. Common headings are recognized, such as Merchant, DBA, Business name, Deal ID, Reference, Commission, Amount paid and Paid date. Totals and note rows without an amount are skipped.

1. 1Open Commissions → Reconcile.
2. 2Drop the CSV, pick the Lender (it narrows matching to that lender's deals), and click Upload and match.
3. 3The statement opens with Reconciled, To review, Unmatched and Short-paid counts.
4. 4On To review, check each suggested match: the merchant, the funded date and what the deal still owes. Click Confirm, or Not this to clear a wrong match.
5. 5On Unmatched, use Match to a funded deal… to point the line at the right deal, then confirm it. Use Ignore for lines that are not commissions you track.
6. 6When the suggestions look right, Confirm N suggested confirms them all. Re-run matching tries again after you add a missing deal.
7. 7The statement shows Done once every line is confirmed or ignored.

A line is suggested at 60 points or more with a name score of at least 50 (or a reference hit), and each deal takes at most one line. Confirming applies the payment to the deal's open commissions, base first, as the lender's final payment: anything still owed becomes a short-pay, shown on the line as Short $….

Example: a line for "Greenway Landscaping LLC, $3,300" matches your funded deal "Greenway Landscaping" that still owes $3,600. The name scores high, the amount is about 8% under, so it is suggested. Confirming pays the $1,600 base in full and $1,700 of the upsell, and flags a $300 short-pay to chase.