Commission and Invoicing Automation
How a lender automated loan officer commission splits and invoice generation between Zoho CRM and Books, with lead attribution carried through to marketing ROI reporting.
Client details generalized to protect confidentiality.
Lenders or brokerages calculating commission by hand each cycle, especially where splits vary by officer and referral source.
The Challenge
Commission was calculated from a CRM export once per cycle, with split and ratio rules applied by hand. Splits varied by officer, product, and whether a deal came from a referral partner, so the calculation was rebuilt each time. Invoicing was a separate manual step, and because invoices carried no lead source, there was no way to tie revenue back to the marketing that produced it.
The Solution
Commission Functions with Split and Ratio Logic
Commission calculates from the loan record itself, applying the split and ratio rules that apply to that officer and that deal.
- Deluge function on funding
- Split percentage and ratio handling
- Referral source override rules
- Multi-participant allocation
Generate Invoice Button on the Loan
One button on the loan record creates the invoice, so invoicing is part of closing rather than a separate cycle.
- Button on the loan layout
- Invoice built from loan and fee fields
- Duplicate guard against re-running
- Link back to the created invoice
Lead Attribution Carried Into Books
The invoice carries the lead source, which is what turns accounting data into marketing ROI reporting.
- Lead source written to a Books custom field
- Referral partner captured on the invoice
- Campaign field preserved end to end
- Reportable in Books and Analytics
Reconciliation and Reporting
Calculated commission and issued invoices are checked against each other on a standing report rather than at month end.
- Report comparing calculated versus invoiced
- Exception flags for mismatches
- Per-officer commission statement
- Revenue by lead source view
Apps in This Solution
Zoho CRM
Zoho Books
Under the Hood Technical detail
- Calculation Timing
- Commission calculates at funding rather than in a monthly batch, so the number exists when the officer asks rather than being produced later. A guard field prevents recalculation if the loan is edited after the fact, which keeps an approved amount from silently changing.
- Split Handling
- Ratio logic covers the case where two officers share a loan unevenly, which a flat percentage split cannot express. Each participant gets their own commission record, which is what makes multi-participant deals reportable rather than collapsed into one figure.
- Invoice Generation
- The Generate Invoice button includes a duplicate guard, because the most common failure in button-driven invoice creation is someone clicking twice. The created invoice ID is written back to the loan so the link is bidirectional.
- Attribution
- Lead source is written to a custom field on the Books invoice rather than living only in CRM. That single field is what allows marketing spend to be compared against booked revenue instead of against closed deal counts.
- Notable Constraint
- Commission plans change and clawbacks happen. Adjustments post as their own records against the same loan rather than editing the original, so the audit trail survives and statements can explain themselves.
The Results
- Commission calculates at funding instead of in a monthly spreadsheet cycle.
- Invoicing happens from the loan record in one click.
- Marketing ROI is measurable because invoices carry the lead source.
Commission Living in a Spreadsheet?
We have built commission logic with layered split rules for lenders, brokerages, and sales teams. Tell us how yours works.