Owner payouts computed to the cent, and checked against reality

The situation

The operator manages dozens of properties on behalf of third-party owners. Every month the routine was the same: work out what rent actually arrived for each owner’s units, including housing assistance payments on their own schedule, subtract the management fee, wire the remainder, and message each owner a confirmation. Done by hand across 34 owners and 84 managed properties, it was slow, and one class of error was nearly invisible: a correction typed into last month’s records after the wire had already gone out, silently making a finished payout wrong.

What we built

• A monthly disbursement engine. On schedule each month, it joins the rent records with the tenant roster, groups by owner (merging the variant spellings real spreadsheets accumulate), and computes each payout to the integer cent from rent actually collected, never rent expected.
• Books that write themselves. Every run produces a per-property fee tracker, a permanent run log, an always-current annual rollup per owner, and a queue of ready-to-send owner confirmation messages with each owner’s contact details attached.
• A retro-edit detector. Every run re-compares months that were already paid out against the records as they stand today and flags anything that changed, with the exact rows. Building it caught two real data-integrity bugs before any money moved.
• Deliberate limits. The system never touches a bank account and never messages an owner on its own. A human reviews the summary, wires the money, and hits send. Exceptions become tasks, not surprises.
• Proof before switch-on. We ran it in parallel with the manual process on live data. Forty-one of 45 comparable properties matched to the cent; on every one of the remaining four, the system agreed with the source records and the manual books did not. It also surfaced three properties the manual list had missed entirely. The head-to-head found errors, just none of them in the software.

The result

More than $134,000 of monthly rent reconciled in one run with zero data flags. Owner statements draft themselves, the annual books stay current without a year-end scramble, and edits to already-paid months get caught by software instead of by an owner phoning about a wrong wire.