Audit Ready Earnest Money Logs for Brokers: Field by Field Risk Map

An earnest money log must capture the transaction ID, amount, payer, instrument, escrow holder, escrow receipt date, and ledger reference for every deposit a brokerage handles. The single control that matters most is recording the date the escrow holder confirms receipt, not the date the buyer sent the funds. Brokers must also keep trust funds in a separate account and reconcile it every month.
TL;DR:
- Recording the escrow receipt date is critical because it begins the calculation for deadlines such as financing or inspection contingencies, not the date the buyer initiates the transfer.
- Proper escrow documentation includes a confirmation from the custodian with a date, amount, and reference number, which must be attached to the log for verification.
- The trust account must be reconciled monthly through a three-way check comparing bank statements, client ledgers, and the cash receipts and disbursements journal to identify discrepancies.
- Violations like commingling funds or missing escrow receipts are common causes of disciplinary action, and discipline can be prevented by strict logging, segregation, and approval controls.
- Using specialized platforms like BrokerPay automates transaction logging, approval workflows, and compliance, reducing manual errors and audit risks in escrow and payment management.
Table of Contents
- What to include in an earnest money log
- Who holds earnest money and why the escrow receipt date matters
- Monthly reconciliation and the 3-way trust-account check
- How earnest money shows up on the Closing Disclosure
- Common violations, E&O exposure, and Board guidance
- Funds-path controls and preventing wire fraud
- Operationalizing logs: how compliant tooling reduces audit risk
- Why consistent logging protects brokerages and clients
- BrokerPay: turning earnest money logs into automatic records
- Sources
- FAQ
What to include in an earnest money log
A usable earnest money log is not a spreadsheet with a few dollar amounts typed in. It is a structured record that ties a deposit to a contract, a custodian, and a paper trail a state examiner or a plaintiff’s attorney could follow years later. Each entry needs enough detail that someone with no memory of the transaction could reconstruct exactly what happened and when.
The core fields belong in every log, regardless of brokerage size or the software behind it:
- Transaction ID: a unique, unchangeable identifier tied to the property address and contract, never reused across deals.
- Contract ID or reference number: links the deposit to the specific purchase agreement and its earnest money clause.
- Payer name: the buyer or buyer’s entity exactly as it appears on the contract.
- Amount and instrument: the dollar figure and how it arrived, whether certified check, wire, or electronic transfer.
- Bank or wire reference number: the confirmation number from the sending bank, which matters if funds are ever disputed.
- Date sent: when the buyer initiated the transfer or handed over the check.
- Escrow receipt date and custodian information: the date the title company, escrow agent, or brokerage trust account actually confirmed the funds, plus the custodian’s name and contact.
- Deposit account: the specific trust or escrow account number where funds landed.
- Memo or contract clause referenced: the section of the purchase agreement authorizing the deposit and its conditions for release.
- Disposition instructions: what happens to the funds at closing, on cancellation, or in a dispute.
- Recorded-by and timestamp: who entered the log record and when, which supports audit trails if the entry is ever questioned.
Two short examples show why the distinction between “sent” and “received” matters. Say a buyer hand-delivers a certified check for $8,000 to a title company on a Friday afternoon. The log should show the check date, the amount, and the payer, but the escrow receipt date is not logged until the title company’s escrow officer stamps or emails confirmation, which might not happen until the following Monday. If a financing contingency deadline is tied to “five days after earnest money receipt,” that Monday date is the one that counts.
A wire deposit works the same way but often creates more confusion. A buyer might send $15,000 by wire on a Tuesday, and the sending bank will generate a confirmation number immediately. That confirmation number goes in the log as the “date sent” reference. But wires can take one to three business days to land in an escrow account, and the escrow holder’s confirmation, not the wire’s origination timestamp, is the date that satisfies the contract’s earnest money deadline.
Pro Tip: Attach a scanned PDF of the escrow receipt directly to the log entry rather than just noting that one exists. If the file is ever separated from the log, the entry becomes unverifiable.
Formatting discipline prevents most of the headaches that turn into E&O claims later. Use sequential, non-reusable transaction IDs so no two deposits can be confused with each other. Store scanned escrow confirmations and deposit slips in PDF form, named consistently (address, date, amount), so anyone searching the file system can locate them without opening every document. Avoid handwritten notes as the sole record of receipt: a text message or a verbal confirmation from a title company is not something you can hand to a regulator. The goal is a log where every dollar has a documented origin, a documented custodian, and a documented release condition.
Who holds earnest money and why the escrow receipt date matters
Earnest money does not sit with the buyer, and in most transactions it does not sit with the listing broker either. The purchase agreement should name a specific custodian, and that choice shapes how the log gets built.
Common custodians include:
- Title or escrow companies, which hold funds as a neutral third party until closing or a resolved dispute.
- Independent third-party escrow agents, sometimes used in commercial or out-of-state transactions.
- Brokerage trust accounts, when local practice or contract terms designate the broker as custodian.
- Real estate attorneys, common in states where attorneys routinely handle closings.
Escrow accounts exist to give both parties a neutral holding point: funds are released only when the contract’s conditions are actually met, which protects the seller from a buyer walking away without consequence and protects the buyer from a seller claiming funds prematurely, according to NAR’s overview of escrow accounts. It is a common misconception that escrow exists only to protect the buyer’s deposit. The same source notes escrow protects both sides of the transaction equally.
The escrow receipt date, meaning the date the custodian confirms funds are actually in hand, is the operative date for nearly every deadline that follows in the transaction. Inspection periods, financing contingencies, and other cutoffs are typically written to run from the date earnest money is received, not the date it was mailed or wired. If a log only records when a buyer says they sent a check, and that check gets lost or delayed, the brokerage has no defensible record of when the contingency clock actually started.
Getting a proper receipt is straightforward but often skipped. Ask the custodian for a written confirmation, which can be an email from the escrow officer, a scanned deposit slip, or a formal receipt letter from the title company. Whatever form it takes, it needs a date, an amount, and the custodian’s identifying information, and it needs to be filed with the log entry, not just referenced from memory.
Local rules on who may hold earnest money, and what documentation is required, vary by state and sometimes by contract form. When a transaction falls outside routine practice, such as an out-of-state buyer or a non-standard holding arrangement, check the guidance published by the relevant state real estate commission before assuming the default custody rules apply.
Monthly reconciliation and the 3-way trust-account check
A trust account that looks fine on a bank statement can still be out of compliance if the underlying client ledgers do not match. That is why the 3-way reconciliation, comparing the bank statement, the cash receipts and disbursements journal, and individual client ledger balances, is treated as the regulatory standard for trust accounting rather than an optional best practice.
The monthly process follows a consistent sequence:
- Pull the bank statement for the trust account covering the full calendar month.
- Close out the cash receipts and disbursements journal, totaling every deposit and withdrawal recorded during the period.
- Reconcile individual client ledger balances against both the bank statement and the journal, confirming that the sum of every client’s earnest money balance equals the trust account’s total.
- Document any adjustments, including outstanding checks, deposits in transit, or bank fees, with a clear explanation for each.
- Escalate unresolved discrepancies to the broker of record or compliance officer immediately rather than carrying them into the next month.
A sample discrepancy might look like this: the bank statement shows $42,000 in the trust account, but the sum of client ledgers only totals $41,200. An $800 gap like that usually traces back to one of a handful of causes: a deposit recorded in the journal but not yet cleared by the bank, a disbursement made without updating the corresponding client ledger, or a data entry error where a check amount was transposed. The corrective entry should note the ledger it affects, the dollar amount of the correction, and a reference to the supporting document, such as the corrected deposit slip or the bank’s own transaction detail.
Pro Tip: Never let an unexplained variance carry forward to the next reconciliation period. A small unresolved gap this month becomes a much harder problem to trace after two or three more months of transactions layer on top of it.
Common causes of discrepancies are predictable once you have seen a few of them. Timing differences between when a deposit is recorded and when it clears the bank account are the most frequent, followed by disbursements that were processed correctly at the bank but never updated in the individual client ledger. Less common but more serious causes include a check applied to the wrong client file or a wire that landed in the trust account but was never matched to a transaction ID in the log. Building the reconciliation habit around the log’s transaction IDs, rather than dollar amounts alone, makes these errors far easier to catch before they compound.

How earnest money shows up on the Closing Disclosure
Earnest money does not disappear once a transaction closes. It shows up as a specific line item that reduces the amount of cash the buyer needs to bring to the table, and the log’s records need to support that figure exactly.
The CFPB’s sample Closing Disclosure shows earnest money credited to the buyer within the “Calculating Cash to Close” section, alongside other adjustments like loan amount and closing costs. The earnest money deposit is applied as a direct credit against the buyer’s cash due at closing, and the same sample document lays out the line-item structure brokers commonly encounter at settlement. If a $10,000 earnest money deposit was collected and verified during the escrow period, that $10,000 reduces the buyer’s out-of-pocket total on closing day dollar for dollar.
Bookkeeping entries should track the deposit through its full life cycle:
- Receipt: debit the trust bank account, credit the specific client’s earnest money liability ledger.
- Holding in escrow: no entry needed beyond the initial receipt, since the funds remain untouched until a triggering event.
- Credit at closing: debit the client’s earnest money ledger, credit the closing settlement statement to reflect the funds moving to the transaction.
- Refund to buyer: debit the client’s earnest money ledger, credit the trust bank account, supported by a signed release from both parties.
- Forfeiture to seller: debit the client’s earnest money ledger, credit the trust bank account, supported by a signed release or, in a contested case, a documented arbitration or court outcome.
Every one of these entries needs a supporting document attached, not just a journal notation. A refund needs a signed mutual release. A forfeiture needs either a signed release or a documented resolution from arbitration or litigation. Without that paper trail, an examiner reviewing the trust account has no way to confirm the disbursement was authorized rather than simply taken.
Common violations, E&O exposure, and Board guidance
Most earnest money complaints trace back to a small set of recurring mistakes, and nearly all of them are preventable with the logging discipline covered above.
The most frequent violations include:
- Commingling, where a broker deposits client trust funds into a personal or general operating account instead of a dedicated trust account.
- Failure to deposit into a separate trust account at all, sometimes from simple neglect rather than intent.
- Missing escrow receipts, where a broker’s file shows a deposit was made but has no confirmation from the custodian that funds actually arrived.
- Inadequate reconciliation, where the trust account is never checked against client ledgers, so shortages go unnoticed for months.
The REALTOR® Code of Ethics addresses this directly. Article 8 and its case interpretations require that monies a broker holds in trust for others be kept strictly separate from the broker’s own funds. The published case interpretations include examples where a broker deposited client earnest money into a personal account and faced disciplinary action as a result. A properly maintained log, tied to a segregated trust account with a documented custodian, would have made that kind of commingling immediately visible rather than something that only surfaced after a complaint.
Monies received by a REALTOR® or the REALTOR®'s firm on behalf of a client or another party that are not the property of the REALTOR® or firm must be kept separate from the personal or business funds of the REALTOR® or firm.
Operational controls reduce E&O exposure well beyond just avoiding commingling. Segregation of duties means the person who logs a deposit is not the same person who authorizes its release. Retention policies should keep every escrow receipt, ledger entry, and disbursement record for the period required by the relevant state commission, often several years past closing. Two-signature releases on any disbursement over a set threshold catch errors before money moves. Documented owner or broker approval on every release, even routine ones, creates the audit trail that turns a log from a convenience into a defense.
Funds-path controls and preventing wire fraud
Wire fraud targeting real estate transactions typically works the same way: someone intercepts email communication between the buyer, agent, and title company, then sends revised wire instructions that look legitimate but route funds to a criminal’s account. A strong funds-path policy closes that gap before it opens.
A brokerage’s wire-fraud prevention checklist should include these steps in sequence:
- Verify the escrow contact independently before any wire is sent, using a phone number obtained outside the email thread in question.
- Never accept wire instruction changes sent only by email, regardless of how official the message appears.
- Confirm instructions out-of-band, meaning a phone call to a previously verified number, not a number provided in the same email as the new instructions.
- Require documented wire confirmations from both the sending party and the receiving custodian before marking a deposit as received in the log.
- Apply two-person approval to any non-routine transfer, including last-minute changes to escrow instructions or unusually large deposits.
These policies work because they add friction exactly where fraud depends on speed and urgency. A criminal impersonating a title company relies on the buyer or agent acting quickly without double-checking, so a mandatory callback step defeats most attempts outright.
Technical and human controls reinforce each other. Secure payment channels, similar to the payment gateway infrastructure real estate brokerages increasingly rely on, reduce reliance on email for anything involving money movement. Locked ledgers, meaning entries that cannot be edited after the fact without a visible change log, and audit logging that records who accessed or modified a transaction record, both make after-the-fact review possible. Approval workflows that require a second person to sign off before funds move add the same friction internally that out-of-band verification adds externally.
Pro Tip: Treat any last-minute change to wire instructions, no matter how small, as a red flag that requires a phone call before a single dollar moves.
When fraud is suspected, speed matters more than almost anything else. Contact the sending and receiving banks immediately to request a wire recall, since funds are often recoverable only within the first 24 hours. Document the incident thoroughly, including timestamps, the exact email or message that triggered the fraudulent instructions, and every step taken afterward, since that documentation will matter for insurance claims, regulatory reporting, and any law enforcement involvement.
Operationalizing logs: how compliant tooling reduces audit risk
A checklist is only as good as the discipline behind it, and manual logs tend to fail in predictable ways: entries get skipped during busy weeks, receipts get filed in the wrong folder, and reconciliation gets pushed to “next month” until it is six months behind. Purpose-built platforms address these failure points directly rather than relying on individual diligence.
The features that matter most map directly onto the checklist covered above:
- Immutable audit trails that record who entered a transaction and when, preventing after-the-fact edits without a visible history.
- Approval workflows that require a second person to sign off before any disbursement, enforcing the segregation of duties Article 8 case guidance points toward.
- ACH transfers routed through brokerage-controlled accounts, replacing informal payment apps with a documented, traceable transfer method.
- Centralized documentation storage, keeping escrow receipts, signed releases, and ledger entries attached to the transaction record instead of scattered across email and shared drives.
The platform is designed specifically for brokerage-side commission and payment workflows, including earnest money tracking, agent splits, referral fees, and co-op commissions, with the stated goal of keeping brokerages RESPA-compliant and eliminating the Venmo and Zelle workarounds that create federal liability. Its positioning centers on routing funds through brokerage-controlled accounts with full audit trails and approval workflows rather than informal peer-to-peer transfers.
Evaluating any platform for this purpose, BrokerPay included, comes down to a short checklist: does it capture an audit trail automatically, does it support escrow receipt documentation as a first-class record rather than an afterthought, does it enforce an approval workflow before funds move, does it use a secure transfer mechanism instead of consumer payment apps, and does it generate the reports a 3-way reconciliation actually requires. A platform that only automates payment without solving documentation just moves the same manual risk somewhere else.
Why consistent logging protects brokerages and clients
Most earnest money complaints I’ve seen described in Board case files did not start with fraud. They started with a missing receipt, a sent-versus-received date nobody bothered to distinguish, or a reconciliation that quietly stopped happening after a busy quarter. The fix is rarely complicated. It is a log that captures the right fields every time, a monthly reconciliation that actually happens, and a funds-path policy that treats every wire instruction with the same suspicion.
Brokers who adopt this discipline early rarely think about it again until an examiner or a plaintiff’s attorney asks for records, at which point the difference between a complete file and a partial one is the difference between a five-minute conversation and a serious liability. Start with the field checklist, run the reconciliation every month without exception, and treat the escrow receipt date as the fact that matters most in the file.
— Wes
BrokerPay: turning earnest money logs into automatic records
Every control covered in this piece, the escrow receipt capture, the approval workflow, the audit trail, the elimination of email-based wire changes, is something a brokerage either builds manually or gets automatically from the right platform. BrokerPay was built around that second option specifically for brokerage payment operations.

BrokerPay routes commission payments, agent splits, referral fees, co-op commissions, and earnest money documentation through brokerage-controlled accounts rather than informal apps like Venmo or Zelle, which create RESPA compliance exposure when used for real estate transaction funds. Specific items it addresses directly:
- Audit trails that log every transaction automatically, without relying on someone remembering to update a spreadsheet.
- Approval workflows that enforce the two-person review this article recommends for non-routine transfers.
- ACH transfers that replace peer-to-peer payment apps with a documented, compliant transfer method.
BrokerPay offers Starter, Growth, and Enterprise plans, with pricing available on request. Brokerages evaluating a move from manual logs can Brokerpay to see how the platform fits their existing reconciliation process.
Sources
These sources cover the rules and sample forms referenced throughout this article:
FAQ
How much is earnest money on a $400,000 house?
Earnest money deposits typically range from 1% to 10% of a home’s purchase price, according to NAR’s consumer guide. There is no legal mandate for a specific percentage, so the exact figure comes down to what buyer and seller agree to in the contract.
What voids an earnest money contract?
Earnest money contracts are typically voided when a buyer exercises a contingency they are entitled to, such as a failed inspection or unmet financing condition, within the timeframe the contract specifies. The clock on those contingency deadlines generally starts from the escrow receipt date, meaning the date the custodian confirmed funds were received, not the date the buyer sent them.
What does an earnest money check look like?
An earnest money check looks like a standard certified or cashier’s check made payable to the escrow holder, such as a title company, rather than to the seller or buyer’s agent directly. It should reference the property address or contract number in the memo line, and the custodian’s confirmation of receipt, not the check itself, is what should be logged as the operative date.
How will the earnest money be recorded on the closing disclosure?
Earnest money appears as a credit to the buyer in the “Calculating Cash to Close” section of the CFPB’s sample Closing Disclosure, reducing the total cash the buyer needs to bring to closing. The deposit amount should match exactly what was logged and confirmed by the escrow holder during the transaction.