Month-End Close Automation & Financial Reconciliation3 min readUpdated September 2026

A Debt Advisory Firm's Close, Worked Through a Real Quarter

Take a commercial mortgage and debt advisory firm that placed twelve loans in a quarter, ranging from a small bridge loan to a large permanent financing deal, each carrying its own fee structure and closing timeline. Here's how that quarter's close actually worked, and where FloQast or BlackLine changed the outcome.

Vendors Covered in this Article

Disclosure: We may earn a commission if you buy through some links on this page. It doesn't change what we recommend.

The Fee That Wasn't Confirmed Until the Deal Actually Funded

A broker's fee on a commercial mortgage deal typically isn't earned, and shouldn't be recognized as revenue, until the loan actually funds, not when the term sheet is signed or even when the loan is approved. This firm had one deal where the term sheet was signed in one month but funding slipped into the next due to a title issue on the collateral property, and the pipeline worksheet, tracking each deal's stage separately from its fee recognition, was what kept that fee from getting booked a month early.

The Warehouse Line Interest That Accrues Daily

For deals the firm briefly warehouses before selling to a permanent lender, interest on the warehouse line accrues daily and needs a monthly accrual entry that ties to the actual days the loan sat on the line, not a flat monthly estimate. Getting this wrong in either direction, over- or under-accruing, distorts the firm's actual margin on warehoused deals versus pure brokerage deals where no warehousing occurs, two economically different activities that need to stay visible as separate lines in the close.

The Pipeline Report That Didn't Match the Commission Register

Midway through the quarter, the firm's pipeline report showed eleven active deals while the commission register, tracking fees actually earned, only reflected nine, a three-deal gap that traced back to two loans funded directly with the lender's own closing agent without looping the firm's accounting team in immediately. A monthly reconciliation between the pipeline tracker and the commission register, a specific task now built into the close checklist, catches this kind of gap going forward instead of discovering it at quarter-end.

How the Numbers Looked Once the Process Was Fixed

Once the fee recognition rule, the warehouse accrual and the pipeline-to-commission tie-out were formalized as three specific monthly tasks, this firm's close time dropped meaningfully, and it did that before ever evaluating FloQast or BlackLine. The platform question only became relevant once the firm wanted the discipline enforced automatically rather than depending on one person remembering the checklist every month, at which point FloQast's task model was layered on top of a process that was already working.

Formalize these monthly tasks before evaluating any platform:

  • Recognize a broker fee only when the loan funds, tied to the funding date rather than a term sheet or approval.
  • Accrue warehouse line interest daily, based on the actual days each loan sat on the line.
  • Reconcile the pipeline tracker to the commission register every month to catch deals funded without accounting being looped in.
  • Keep warehousing margin visible separately from pure brokerage fee income.

Why This Firm Didn't Need BlackLine

With one legal entity, roughly a dozen deals a quarter, and no consolidation requirement, this firm's transaction volume and entity structure never approached the point where BlackLine's heavier matching would add proportional value. That calculus would shift if the firm added a second entity for warehousing specifically, common at larger debt advisory shops, or if deal volume grew several times over.

What the Broader Numbers Suggest for a Firm This Size

With the effective federal funds rate at 3.63 percent as of mid-20261, warehouse line interest costs are a real, live line item worth tracking closely rather than estimating loosely, since even a modest rate move changes the economics of warehousing a deal versus pure brokerage. On staffing, the median wage for accountants and auditors nationally is $83,680 a year2, a useful reference for a firm weighing a dedicated back-office hire against a close platform's ongoing cost.

The Deal That Almost Slipped Through the Cracks

One deal in this quarter closed on the final business day of the month, funding late in the afternoon after the accounting team had already started its close review. Because the fee recognition rule was tied specifically to funding date rather than a looser end-of-month approximation, that deal's fee correctly landed in the right period once the funding confirmation came through, even though it arrived after the team had begun wrapping up. A close process that can absorb a last-minute funding without forcing a full reopen of the books is a good sign the underlying checklist, not just the platform running it, is built correctly.

What a Growing Firm Should Watch For Next

As deal volume grows past what one person can track by memory, the firm's next real decision point isn't really FloQast versus BlackLine, it's whether to add a second person to the close process or formalize the existing checklist into a platform first. Most firms at this size get more value from formalizing the checklist, since that discipline is what a platform actually automates, and a platform layered on top of an undocumented process just makes the undocumented process run with a nicer interface.

Executive Capability Standard

What Good Looks Like

A debt advisory firm closes with broker fees recognized only on funding, warehouse line interest accrued daily against actual days outstanding per loan, and the pipeline tracker reconciled monthly against the commission register so no funded deal falls through the accounting process unnoticed.

Building The Capability (5-Stage Skill Ladder)

1. Learn:Pull the pipeline tracker and the commission register side by side and identify every deal where they don't currently agree.
2. Do Manually:Build a daily warehouse interest accrual worksheet and run it by hand against actual funding dates for two closes.
3. Delegate:Assign one person ownership of the monthly pipeline-to-commission reconciliation as a standing task.
4. Automate:Use FloQast to track fee recognition, warehouse accrual and pipeline reconciliation monthly with sign-off.
5. Buy:Move to BlackLine only if a second warehousing entity or a significant jump in deal volume changes the underlying complexity.

How to Get Started

Disclosure: We may earn a commission if you buy through some links on this page. It doesn't change what we recommend.

Mercury

A debt advisory firm managing warehouse line draws alongside operating cash benefits from Mercury's account structure and visibility into cash sitting between deal closings.

Visit Mercury→

Frequently Asked Questions

When should a mortgage broker recognize its fee on a deal?

When the loan actually funds, not when a term sheet is signed or even when the loan is approved. A deal can fall apart between approval and funding for reasons like title issues or last-minute financing changes, so recognizing the fee earlier risks a reversal if the deal doesn't close.

How should warehouse line interest be accrued?

Daily, tied to the actual number of days each specific loan sat on the warehouse line before being sold to a permanent lender, not as a flat monthly estimate. This keeps warehousing margin visible separately from pure brokerage fee income.

Does a debt advisory firm need BlackLine if it only places a dozen deals a quarter?

Usually not. At that volume, with one legal entity and no consolidation requirement, a disciplined FloQast checklist or even a well-run manual process typically covers the close without the heavier setup BlackLine requires.

Sources

Where we quote a benchmark, we show its source. Other figures in this guide are estimates or general guidance, so check them against your own numbers.

  1. Effective federal funds rate (monthly average). FRED series FEDFUNDS; cross-checked vs Federal Reserve H.15 release (3.63% on 2026-06-30), 2026.
  2. Annual wage, Accountants and Auditors (SOC 13-2011), US all industries. BLS OEWS May 2025, 2025.

Related Guides