Mortgage Branch Bookkeeper — QuickBooks + Commission Reconciliation (Long-Term, Part-Time)
About the Role
I run a residential mortgage branch in San Diego, California. I'm looking for a detail-oriented bookkeeper to take over my monthly commission reconciliation, external loan officer payouts, and QuickBooks Online setup and maintenance.
This is a long-term position with predictable monthly work. I have a comprehensive handoff document (12 sections, includes worked examples) and an existing tracking spreadsheet, so you won't be building from scratch. I value reliability, accuracy, and clear communication over speed.
Realistic Time Commitment
Most of the work is concentrated in week one of each month when payroll comes in. Here's what to expect:
Setup phase (first 4-6 weeks): 8-12 hours/week as you learn the system and get QuickBooks dialed in
Steady state: 5-8 hours/week, mostly concentrated around payroll cycles
Month-end: 1-2 extra hours for summary reports
If you bill more than this consistently after the setup phase, we'll talk about whether the work is genuinely there or if something needs to change in the workflow.
What You'll Be Doing
Reconciling weekly payroll from our parent mortgage company against closing disclosures and lock confirmations
Calculating commission splits across multiple loan officers using established formulas
Tracking external payments to sub-loan officers, processors, and assistants
Setting up and maintaining QuickBooks Online for the branch
Categorizing income and expenses, reconciling bank statements
Flagging payroll discrepancies for me to dispute with our payroll lead
Preparing month-end summaries
Maintaining a Google Sheet tracker
Required Skills
3+ years bookkeeping experience with US clients
QuickBooks Online proficient (ProAdvisor certification preferred but not required)
Strong Excel and Google Sheets skills (formulas, SUMIF, pivot tables)
Excellent written English
Attention to detail (this work involves reconciling dollar amounts to the cent)
Comfortable working independently with established procedures
Available for at least 2-3 hours of overlap with US Pacific Time
Nice to Have (Not Required)
US mortgage industry experience (rare, won't filter you out if missing)
Real estate bookkeeping background
Familiarity with Arive, Encompass, or other Loan Origination Systems
Experience with payroll dispute documentation
What I'll Provide
Complete handoff document explaining how mortgage commissions work (no prior mortgage knowledge needed)
Working spreadsheet with all current data
Direct access to our payroll system and closing disclosures
1-2 hours of training calls in the first week
Reliable, on-time weekly payments via Upwork
What I'm Looking For in a Candidate
Someone who reads instructions carefully and follows them
Someone who flags issues rather than guessing
Someone who asks good questions when something doesn't add up
Someone who's looking for a stable long-term role at consistent weekly hours
Looking forward to working with the right person.
I run a residential mortgage branch in San Diego, California. I'm looking for a detail-oriented bookkeeper to take over my monthly commission reconciliation, external loan officer payouts, and QuickBooks Online setup and maintenance.
This is a long-term position with predictable monthly work. I have a comprehensive handoff document (12 sections, includes worked examples) and an existing tracking spreadsheet, so you won't be building from scratch. I value reliability, accuracy, and clear communication over speed.
Realistic Time Commitment
Most of the work is concentrated in week one of each month when payroll comes in. Here's what to expect:
Setup phase (first 4-6 weeks): 8-12 hours/week as you learn the system and get QuickBooks dialed in
Steady state: 5-8 hours/week, mostly concentrated around payroll cycles
Month-end: 1-2 extra hours for summary reports
If you bill more than this consistently after the setup phase, we'll talk about whether the work is genuinely there or if something needs to change in the workflow.
What You'll Be Doing
Reconciling weekly payroll from our parent mortgage company against closing disclosures and lock confirmations
Calculating commission splits across multiple loan officers using established formulas
Tracking external payments to sub-loan officers, processors, and assistants
Setting up and maintaining QuickBooks Online for the branch
Categorizing income and expenses, reconciling bank statements
Flagging payroll discrepancies for me to dispute with our payroll lead
Preparing month-end summaries
Maintaining a Google Sheet tracker
Required Skills
3+ years bookkeeping experience with US clients
QuickBooks Online proficient (ProAdvisor certification preferred but not required)
Strong Excel and Google Sheets skills (formulas, SUMIF, pivot tables)
Excellent written English
Attention to detail (this work involves reconciling dollar amounts to the cent)
Comfortable working independently with established procedures
Available for at least 2-3 hours of overlap with US Pacific Time
Nice to Have (Not Required)
US mortgage industry experience (rare, won't filter you out if missing)
Real estate bookkeeping background
Familiarity with Arive, Encompass, or other Loan Origination Systems
Experience with payroll dispute documentation
What I'll Provide
Complete handoff document explaining how mortgage commissions work (no prior mortgage knowledge needed)
Working spreadsheet with all current data
Direct access to our payroll system and closing disclosures
1-2 hours of training calls in the first week
Reliable, on-time weekly payments via Upwork
What I'm Looking For in a Candidate
Someone who reads instructions carefully and follows them
Someone who flags issues rather than guessing
Someone who asks good questions when something doesn't add up
Someone who's looking for a stable long-term role at consistent weekly hours
Looking forward to working with the right person.