What you're reconciling and why
A trust account reconciliation confirms that the money you're holding for clients matches across three independent records:
Your trust liability in BoldTrail BackOffice - what your brokerage owes to buyers and sellers, broken down property by property.
Your trust bank balance in QuickBooks - trust account transactions as recorded in your accounting software, after reconciling against the bank.
Your bank statement - the actual balance per your bank.
When these records fall out of sync, it can signal real problems: duplicate entries, missing deposits, data entry errors, or funds applied to the wrong property or party. Left undetected, discrepancies grow harder to resolve over time.
More importantly: earnest money and trust funds belong to your clients - not your brokerage. Any shortfall, regardless of cause, can harm clients and expose your brokerage to legal and regulatory liability. A regular, documented reconciliation is your primary safeguard.
Monthly reconciliation checklist
Every month, same order:
Receive bank statement. Confirm ending date and balance.
Complete the QuickBooks bank reconciliation for the trust account.
Run the BTBO EMD / Trust Reconciliation Report (same "As Of" date).
Open the worksheet template. Enter all three balances.
Verify both differences equal $0.00.
If differences exist → investigate → document in Follow-Up Log.
Attach all three supporting documents.
Preparer signs. Designated broker reviews and signs.
File the complete package.
Regulatory requirements
Many real estate commissions and regulatory bodies - in both the US and Canada - require brokerages to maintain a documented reconciliation process, typically monthly. Common mandates include:
Reconciliations completed within a set number of days after month-end
Written records retained for a minimum number of years (often 3-5)
Review and sign-off by the designated broker or supervising licensee
Records available for inspection during audits or investigations
Before you start
You need three things ready before you begin:
What | Where to get it | Details |
Bank statement | Your bank (online portal or mailed) | Use the ending balance and ending date. This anchors everything else. |
QuickBooks bank reconciliation | QuickBooks Online → Banking → Reconcile | Complete this before you start the 3-way comparison. The reconciled balance should match your bank statement ending balance. |
BTBO Reconciliation Report | BoldTrail Back Office (see Section 4) | Run the report using the same "As Of" date as your bank statement. |
All three sources must use the same date, typically the last day of the calendar month. Using the wrong date is the single most common cause of unexplained differences. If your brokerage reconciles on a non-standard schedule, confirm the correct date with your designated broker before pulling anything.
The reconciliation package
A complete reconciliation has two parts: a worksheet that ties the numbers together, and the source documents that back it up.
The template has two tabs: The Reconciliation worksheet - yellow cells are yours to fill) and Follow-Up Log for tracking discrepancies month over month.
Worksheet
The worksheet is a single document that records all three balances, calculates the differences, and captures who prepared and reviewed it.
Section | What goes there |
A. BTBO Trust Liability Balance | Grand total from the BTBO EMD / Trust Reconciliation Report - what you owe to clients across all open transactions. |
B. QuickBooks Reconciled Balance | Reconciled trust account balance from QuickBooks, after clearing all deposits and checks against the bank statement. |
C. Bank Statement Balance | Ending balance per your bank statement. Should match Section B - QuickBooks handles the detail; you're confirming the number. |
D. Three-Way Comparison | A minus B, and B minus C. Both should equal $0.00. Any non-zero difference gets documented in the Follow-Up Log. |
E. Certification | Preparer and reviewer signatures with dates. This creates your audit trail. |
Supporting documents
Attach all three to the worksheet before signing:
BTBO Trust Reconciliation Report (property-by-property breakdown, as of reconciliation date)
QuickBooks Bank Reconciliation (showing cleared and outstanding items)
Bank Statement (official statement from your bank for the reconciliation period)
How to run the reconciliation report
This report reconciles your trust bank balance to your trust liability account, broken down property by property. It tells you which transactions the money belongs to — not just whether the totals add up.
Select the "As Of" date
Before running the report, set the "As Of" date to match your bank statement ending date and QuickBooks reconciliation date. In most cases, this is the last day of the month.
Getting this wrong is the most common source of phantom discrepancies - the numbers aren't actually off, you're looking at different points in time.
Verify the output
Once the report generates, check three things:
Grand total matches. The report total should equal your BTBO trust liability balance. If it doesn't, something was posted after the report date or a transaction is miscategorized.
Every property line makes sense. Each open transaction should show a balance that matches the deposits you've received. Scan for zeros on active transactions (missing deposits) and balances on closed transactions (funds not yet disbursed).
Flag anything unexpected. An open balance on a transaction that closed months ago, a negative balance, a number that doesn't match what you know about the deal - write it down. It goes in the Follow-Up Log.
Print or export the report and attach it to your reconciliation worksheet.
Doing the 3-way comparison
With all three numbers in hand, the comparison itself is straightforward:
Enter the BTBO trust liability balance into Section A of the worksheet. This is the grand total from the reconciliation report.
Enter the QuickBooks reconciled balance into Section B. This comes from your completed QBO bank reconciliation.
Enter the bank statement ending balance into Section C. Pull this directly from your bank statement.
Calculate the differences. A minus B, and B minus C. The worksheet does this automatically if you're using the template.
Both differences should be $0.00. If they are - attach your three documents, sign, and get the designated broker's sign-off.
If either difference is non-zero - investigate before signing. Document the discrepancy, the suspected cause, and who's responsible for resolving it in the Follow-Up Log tab.
What a clean reconciliation looks like: BTBO trust liability = $47,500. QuickBooks reconciled balance = $47,500. Bank statement ending balance = $47,500. All differences = $0.00. Three supporting documents attached. Two signatures. Filed. Done.
When the numbers don't match
Discrepancies are common, especially in the first few months. Here are the usual suspects:
Discrepancy | Likely cause | Where to look |
BTBO ≠ QuickBooks (A ≠ B) | A deposit or disbursement was recorded in one system but not the other. Or a transaction was posted to the wrong account. | Compare the BTBO property-level report against the QuickBooks trust ledger. Look for entries that appear in one but not the other. |
QuickBooks ≠ Bank (B ≠ C) | Outstanding checks that haven't cleared, deposits in transit, or bank fees not yet recorded. | Check the QuickBooks reconciliation detail for uncleared items. Current items are normal. Stale uncleared items (30+ days) need investigation. |
BTBO ≠ Bank (A ≠ C) | Usually a combination of the above two. | Fix A vs. B and B vs. C individually. If both are clean, A vs. C resolves itself. |
Log every discrepancy in the Follow-Up Log tab - even if you resolve it immediately. The log creates a paper trail that demonstrates you identified and addressed the issue. Update the status each month until it's closed.
Documentation and sign-off
Attach all three supporting documents to the worksheet: BTBO reconciliation report, QuickBooks bank reconciliation, bank statement.
Preparer signs and dates the certification section.
Designated broker reviews the package - worksheet, supporting docs, and the Follow-Up Log - then signs and dates.
File the complete package. Retain for the period required by your jurisdiction (typically 3–5 years, though some states and provinces require longer). Keep it accessible for audits.
Most regulatory bodies expect reconciliations completed within a set number of days after month-end. Check your state or provincial real estate commission's specific deadline. Completing it within the first two weeks of the following month is a practical target.