Real estate agency cockpit

Context

A real estate agency whose revenue is paid as commissions shared between several parties.

The problem

Cash, signed deals and commissions were reconciled by hand in spreadsheets each month, so no one knew the real cash position during the month.

The constraint

Two banks, several currencies and a commission split between up to five parties, reconciled by hand in spreadsheets each month.

What we built

• A management dashboard: available cash, cash forecast to month end, revenue collected, commissions to pay, cash trajectory and revenue by agent
• A deal sheet: the commission split computed automatically (referral partner, listing agent, co-agent, assistant, agency margin), invoices matched to the bank, the agent's tier progress and an audit trail
• An agent view on a phone: a weekly sales-activity score out of 100, with caps per activity and an approval-based bonus

How it works

Bank statements are imported as CSV from two banks. The account is detected from the file, categorisation rules apply, and amounts are converted at dated rates. Each deal's commission split is computed automatically and invoices are matched to the bank. A monthly Excel export of net commissions goes to the payroll provider, and a supplier-payment export goes to accounting.

What changed

Management sees available cash, the forecast to month end and commissions to pay during the month, instead of after a manual reconciliation.