💰 Billing & Commission
Invoice & Commission Automation for Mortgage Brokers: Track Every Dollar, Get Paid Every Time
Here's an uncomfortable truth: most independent mortgage brokers are leaving money on the table every single month. A loan closes, you move on to the next deal, and two months later you realize the processor never sent your commission check, or sent the wrong amount.
Manual commission tracking in a spreadsheet works until you close more than 5 loans a month. After that, things slip through the cracks. Automated billing and commission tracking closes that gap and makes sure you get paid for every dollar you earned.
This tutorial shows you how to set up a complete billing automation system in about 45 minutes. You'll track every loan from closing to commission received, auto-send invoices to processors, and get payment reminders going without lifting a finger.
Professional invoicing with automatic reminders, recurring billing, and Zapier integration. Best for brokers billing processors or referral partners regularly.
From $17/mo, Try FreshBooks free 30 days →100% free invoicing and accounting for small businesses. Handles invoices, payment tracking, and basic reporting. Perfect for solo brokers starting out.
Free, Try Wave free →Custom commission tracking spreadsheet that automatically populates when loans close in your CRM, with automated alerts for overdue commissions.
From $0, Try Zapier free →Track deals through closing and trigger invoice automations. The free CRM integrates with FreshBooks and Wave via Zapier for end-to-end workflow.
Free CRM, Try HubSpot free →| Field | Why It Matters | Where to Get It |
|---|---|---|
| Loan Number | Unique identifier for matching commission payments | Lender closing docs |
| Borrower Name | Quick lookup when following up on payments | Your CRM |
| Lender / Processor | Know who owes you and how to contact them | Loan origination file |
| Loan Amount | Calculate expected commission at your BPS rate | Final closing statement |
| Expected Commission ($) | Your contracted rate × loan amount | Calculated field |
| Closing Date | Start the commission payment clock | Title company / closing docs |
| Expected Pay Date | Most lenders pay 7–14 days post-close | Your lender agreement |
| Commission Received ($) | Actual vs expected, flag discrepancies immediately | Bank statement / check |
| Status | Pending / Received / Discrepancy / Escalated | Updated manually or via Zap |
Create a Google Sheet with the columns from the table above. Add conditional formatting: if Commission Received is blank AND today is more than 14 days past Closing Date, highlight the row red. If there's a variance between Expected and Received of more than $50, highlight yellow. This gives you an instant visual dashboard for outstanding commissions every morning.
In Zapier, create a Zap: Trigger, HubSpot deal moves to "Closed Won" stage. Action, Google Sheets creates a new row with the deal's loan number, borrower name, lender, loan amount, expected commission (calculated), and closing date. This removes the manual step of updating your tracker every time a loan closes, it happens automatically within 5 minutes of you updating your CRM.
In FreshBooks, create one invoice template per lender or processor you work with (most brokers have 5–10 regular lenders). Set up a Zapier trigger: when a loan closes in HubSpot, create and send an invoice in FreshBooks to the appropriate lender contact. The invoice auto-populates with borrower name, loan number, and commission amount from the CRM. No manual invoice creation needed.
Set up three Zapier delayed actions from the closing date: Day 14, if Google Sheets status is still "Pending," send an email to the lender contact with the invoice attached. Day 25, if still pending, send a follow-up email with a firmer tone. Day 35, send a final email and flag the row in your sheet for a personal phone call. Most commissions resolve before Day 25, but having the automation means you never have to remember to follow up manually.
At the end of each month, Zapier (or a Google Sheets IMPORTRANGE formula) generates a summary email to yourself showing: total loans closed, total commissions expected, total received, outstanding balance, and any variance flags. This takes 2 minutes to review vs. 2 hours of manual spreadsheet checking. Connect to QuickBooks or Wave for automatic accounting sync.
Screenshot placeholder: Google Sheets commission tracker with red/yellow conditional formatting for overdue payments
| Day Post-Close | Action | Channel | Who Sends It |
|---|---|---|---|
| Day 0 (close) | Auto-send invoice to processor | Email (FreshBooks) | Zapier + FreshBooks |
| Day 7 | Friendly reminder if not paid | FreshBooks auto-reminder | FreshBooks |
| Day 14 | Follow-up with invoice re-attached | Email (Zapier) | Zapier automation |
| Day 25 | Escalation email, request ETA | Email (Zapier) | Zapier automation |
| Day 35 | Flag for personal call | Phone (flagged in sheet) | You |
| Day 45+ | Escalate to broker manager or legal | Formal letter | You |
Subject: Commission Invoice, [BORROWER NAME] / Loan #[LOAN NUMBER] Hi [PROCESSOR NAME], Thank you for the successful close on [BORROWER NAME]'s loan. Please find attached our commission invoice for this transaction: • Loan Amount: $[LOAN AMOUNT] • Commission Rate: [X] BPS / [X]% • Commission Due: $[COMMISSION AMOUNT] • Payment Due: [DATE, 14 days from close] You can pay by check to [your address] or ACH to [your bank details]. Please let us know if you have any questions. Best, [Your Name] | [Brokerage Name] [Phone] | [Email]
Subject: Following Up, Commission Invoice #[INVOICE NUMBER] Hi [PROCESSOR NAME], I wanted to follow up on our commission invoice for [BORROWER NAME] (Loan #[LOAN NUMBER]), which was due on [DATE]. I've attached the invoice again for reference. If payment has already been sent, please disregard, I'd just love a quick confirmation. If there's a question about the amount or any processing delay, just reply and we'll sort it out quickly. Thank you, [Your Name] [Phone]
Subject: Monthly Commission Reconciliation, [MONTH YEAR] LOANS CLOSED THIS MONTH: [X] TOTAL EXPECTED COMMISSIONS: $[AMOUNT] TOTAL RECEIVED: $[AMOUNT] OUTSTANDING BALANCE: $[AMOUNT] --- ITEMS NEEDING ATTENTION --- [Loan #], [Borrower], Expected $[X], [X] days overdue, Status: [Pending/Escalated] [Loan #], [Borrower], Variance of $[X], Received $[X] vs Expected $[X] --- ACTION ITEMS --- • Call [lender] re: Loan #[X] (35+ days) • Dispute $[X] variance on Loan #[X] Next reconciliation: [DATE]
Kevin runs a 3-broker independent mortgage shop in Minneapolis. Before automation, they tracked commissions in a shared Google Sheet that nobody updated consistently. When we audited 12 months of their records, they found 8 underpayments and 3 commissions that were simply never paid, totaling $14,200.
Kevin set up the system in this tutorial over one Saturday afternoon. He connected HubSpot to Google Sheets via Zapier, set up FreshBooks invoice templates for his 7 main lenders, and activated the 3-touch follow-up sequence.
In the first 90 days, the system caught 4 late commissions before they became problems, recovered two underpayments totaling $3,100, and saved Kevin's team an estimated 5 hours per month in manual reconciliation work.
FreshBooks makes it easy to send professional invoices and automate payment reminders. Start free for 30 days, no credit card needed.
Try FreshBooks Free 30 Days → Get Setup Help →Use a Google Sheets tracker synced to your CRM via Zapier. When a loan closes, Zapier creates a row in the sheet with expected commission. A second Zap watches for the commission received date and flags any loan past 30 days without payment. Conditional formatting makes overdue items jump out visually every morning.
FreshBooks is ideal for mortgage brokers, it integrates with most CRMs via Zapier, tracks outstanding invoices, and sends automatic reminders. Wave is a great free alternative for solo brokers just starting out. Both connect to QuickBooks for accounting.
Yes. Use Zapier to watch your CRM for loan status changes to "funded," then automatically generate and send a commission statement to your processor. This alone saves 2–3 hours per week for most brokers, and means your processor gets the invoice the same day the loan closes, not a week later.