The useful starting point
Compare funded-loan and commission records with the accounting ledger, confirm the reporting cutoff, trace differences to supporting records, and document unresolved items before interpreting revenue per funded loan.
01 / REVIEW
Start with the balances behind revenue
Review cash, commission receivables, clearing accounts, and relevant loan balances on the Balance Sheet. A revenue report can appear reasonable while an unsupported receivable or clearing balance carries forward. Keep supporting schedules for material balances and identify what each outstanding item represents.
02 / REVIEW
Align the reporting period
A funded date, commission statement date, and cash receipt date may differ. Agree the accounting method and cutoff with the business before comparing records. Separate expected receipts from recorded income and cash already received. Avoid treating every timing difference as missing revenue.
03 / REVIEW
Trace records to the General Ledger
For the agreed population, match source identifiers to ledger entries. Review amount, date, category, entity, and any adjustments. Check for duplicate entries, unapplied receipts, reversals, and expenses recorded against revenue. Keep a difference schedule instead of forcing unmatched items into a convenient category.
04 / REVIEW
Read production and profitability together
In the fictional dashboard, $218,400 of revenue divided by 42 funded loans gives $5,200 per loan. That is a revenue measure, not profit per loan. Compensation and operating costs still matter. Use a consistent definition of the loan population and revenue before comparing branches or periods.
05 / REVIEW
Finish with a useful follow-up list
Record each unresolved item, its supporting evidence, the person responsible, and the next review date. Tie the final schedule back to the agreed account balances. Reliable bookkeeping helps prepare organized financial information; specific regulatory filings and compliance reporting require a separately defined engagement.
Examples are fictional. Accounting treatment, reporting definitions, and responsibilities depend on your business and agreed engagement.
Related software documentation
For the mechanics of reconciliation and reporting within QuickBooks Online, consult the official documentation. Available reporting features depend on your subscription and setup.
Intuit: Reconcile an accountIntuit: Run reports by classIs mortgage broker revenue the same as cash received?
Not necessarily. The accounting method and the timing of production, commission statements, and receipts affect the comparison. Review receivables and source records alongside the ledger.
What should support a commission reconciliation?
The agreed production or commission records, bank activity, General Ledger detail, adjustments, and a schedule explaining open differences.