Real estate · Property management · Hong Kong

Management fee automation for a Hong Kong property manager

Five thousand managed units, separate bank accounts — and every bank-in is now matched to a unit or flagged for a person.

270 hoursestimated time saved a month
Target0bank-ins posted on a guess
Target3rd working dayreport ready for the owners' corporation

Representative example — a composite of typical Hong Kong workflows, written from the duties in current job ads. Company names, documents and figures are sample data.

A Hong Kong property management company manages about 5,000 homes and car-parking spaces across several estates and commercial buildings. One is a three-block estate of 420 flats and 150 car-parking spaces, managed for its owners' corporation (the statutory body formed when the Land Registrar registers the owners as a corporation). Each month the company issues a demand note (the monthly bill) to every unit, matches every payment that lands in the bank, follows up arrears and reports each property's income and spending to its owners' corporation.

At a glance

The files they already use

  • Bank statement lines
  • Flat and car-park register
  • Management share schedule
  • Scanned cheques and bank-in slips
  • Supplier invoices
AI systembuilt around their rules
  • Fee by each flat's management shares
  • Late charge as set in the DMC
  • Every bank-in matched to one flat, or flagged
  • Oldest arrears cleared first
  • Reminders drafted at 30 / 60 / 90 days

Done automatically

  • Monthly demand notes
  • Bank-in matching table
  • Reminder letters — drafted
  • Income and expenditure report

The accounts clerk confirms every flagged bank-in, and the manager approves every letter before it is sent.

How they used to do it

Owners paid by autopay, FPS, cheque and cash at the management office. Each morning the clerk downloaded the daily bank transaction export and ticked payments off a printed list of 420 flats, going by whatever reference the owner had typed — often just a floor and a flat, with no block.

Arrears and late charges were worked out on an Excel sheet at month-end, reminder letters were typed one by one, and the monthly income and expenditure report for the owners' corporation meeting was built by hand from the bank statement and a folder of supplier invoices.

The difficulties

  • Payments without a block. A reference like “12C” fits a flat in more than one block, and a wrong guess put one owner in arrears and another in credit.
  • Two months in one cheque. A cheque covering arrears and the current month was sometimes posted to this month only, so the arrears stayed open.
  • Late charges by hand. The late charge set in the DMC was worked out flat by flat on a calculator, and missed in busy months.
  • Reminders late. Letters at 30, 60 and 90 days were typed one by one, so the ones for longer arrears went out late or not at all.
  • A report built from scratch. The owners' corporation's monthly report took two days to put together from the bank statement and supplier invoices.

Their formula, broken down

A demand note looks like one fee. Behind it are the flat's management shares, a car-park fee, last month's arrears and a late charge. Here is this month's note for Flat 12C, Block B, which did not pay last month.

Their formulaAmount payable = management fee (by management shares) + car-park fee + arrears + late charge (5% of the overdue amount, as set in the DMC)
  1. Work out the management fee from the flat's shares

    Each flat pays according to its management shares — the portion of the estate's running costs that the deed of mutual covenant (DMC, the agreement every owner is bound by) allots to it. For this flat that is HK$1,860.00 a month.

    Management shares × this year's budget rateHK$1,860.00

  2. Add the car-park management fee

    The owner also holds one car-parking space, with its own fee of HK$450.00 a month.

    1 space × HK$450.00+HK$450.00

  3. Bring forward last month's arrears

    Last month's management fee of HK$1,860.00 was not paid, so it is carried onto this note.

    last month's fee HK$1,860.00, unpaid+HK$1,860.00

  4. Add the late charge

    The late charge set in this estate's deed of mutual covenant (DMC) is 5% of the overdue amount (a sample figure).

    5% × overdue HK$1,860.00+HK$93.00

Amount payable this monthHK$4,263.00

What the system produces

estate.alveek.ai/bank-in/2026-10Sample data

Bank-ins received

Bank statement (CSV)Flat register.xlsxCheque scans
Paid byReference givenHK$
AutopayB-03A1,860.00
FPS12C2,310.00
ChequeA-07B3,720.00
Total received7,890.00

Bank-in matching table

Matching table.xlsxDemand note B-12C.pdf
ReferenceMatched toHK$
B-03AFlat 3A, Block B · this month's fee — matched1,860.00
A-07BFlat 7B, Block A · last month's arrears1,860.00
A-07BFlat 7B, Block A · this month's fee1,860.00
12CHeld — 12C exists in Block A and Block B2,310.00
Total received7,890.00

How it was calculated

Cheque A-07B: HK$3,720.00 = 2 months × HK$1,860.00 → clears last month's arrears first, then this month

Total received = B-03A HK$1,860.00 + A-07B HK$3,720.00 + 12C HK$2,310.00 = HK$7,890.00

Flagged for a person to confirm

  • FPS “12C”, HK$2,310.00: flat 12C exists in both Block A and Block B. The amount is held, not posted, until a person confirms which flat paid.
  • Flat 12C, Block B is now 30 days overdue. A first reminder letter is drafted for the manager to approve; any legal action is decided by the owners' corporation and the manager, never by the system.

In this example: every bank-in is matched to one flat or held for a person, the cheque for two months clears the older arrears first, and the demand note shows exactly how the late charge was reached.

How we helped

We build one record per flat and per car-parking space — owner, management shares, fees and every payment received — and a system that reads the daily bank transaction export each morning and matches each bank-in to a flat. Anything it cannot match with certainty is held for the clerk. Demand notes, arrears, reminder letters and the monthly report all come from the same record.

  1. Bank-ins come in. The daily bank transaction export and scanned cheques are read, and each payment's reference is compared with the flat register.
  2. Matched, or held. A payment is posted only when it points to one flat; a payment covering several months clears the oldest arrears first. Anything unclear is held for a person.
  3. Notes and reminders prepared. Demand notes are worked out from the management shares, car-park fees, arrears and the DMC late charge; reminders are drafted at 30, 60 and 90 days.
  4. Reviewed, then sent. The manager approves every letter and demand note before it goes out. Any legal step is decided by the owners' corporation and the manager.

What the system handles

Demand notes

Monthly notes for 420 flats and 150 car-parking spaces, worked out from each unit's management shares and fees.

Bank reconciliation

Autopay, FPS, cheque and cash receipts are matched to flats daily, and the bank balance is agreed at month-end.

Arrears

Arrears are aged by month, with reminder letters drafted at 30, 60 and 90 days for a person to approve.

Owners' corporation report

The monthly income and expenditure report, set against the year's budget, ready for the owners' corporation meeting.

Renovations and moves

Renovation applications, deposits and move-in or move-out dates are recorded per flat, with open items listed for follow-up.

Before and after

TopicBeforeAfter
Bank-insPayments were ticked off a printed list, and unclear references were guessed.Every payment is matched to one flat or held for a person to confirm.
ArrearsA payment for two months sometimes cleared only one, and old arrears stayed open.Payments clear the oldest arrears first, and every flat's balance is up to date each morning.
Late chargesThey were worked out by hand and missed in busy months.The late charge is applied on every demand note at the rate set in the DMC.
RemindersLetters were typed one by one and often went out late.Reminders at 30, 60 and 90 days are drafted automatically; the manager approves each one.
Monthly reportThe owners' corporation report took two days to build by hand.The report is ready on the third working day, with every figure traced to the bank statement.

How much time it saves

  • About 5,000 bank-ins a month, each taking around 3 minutes to identify and post by hand.
  • 5,000 × 3 minutes = 250 hours, plus about 20 hours of arrears and reminder letters and 10 hours for the owners' corporation reports: about 280 hours a month.
  • With the system, the clerks handle only the held bank-ins and check the letters and reports: about 10 hours a month.
  • Time saved ≈ 270 hours a month — about 34 working days.
  • At HK$110 an hour (about HK$19,000 a month for one full-time clerk, MPF included), that is about HK$29,700 a month — before counting arrears collected sooner.

These are the working assumptions behind the figure, not an audited result.

How a project like this runs

  1. Free assessment. We sit with your accounts clerk through one real month-end and collect a month of bank records, demand notes and the last owners' corporation report.
  2. Built on your own records. The fee, arrears and late-charge rules are rebuilt from your past demand notes and tested until they reproduce every flat's balance.
  3. Side by side. For two months your clerk matches bank-ins by hand while the system matches the same records, and the two are compared payment by payment.
  4. Live, then maintained. Once they match, the manual matching stops. Other buildings, such as commercial buildings, are added with their own fee rules, and we fix anything that comes up.

Questions owners usually ask

  • Will the system take legal action against owners in arrears?
    No. The system only drafts reminder letters at 30, 60 and 90 days for the manager to approve. Any legal action is decided by the owners' corporation and the manager, never by the system.
  • What happens when a payment reference is unclear?
    The payment is held, not guessed. The clerk sees the possible flats side by side and confirms which one paid.
  • Does this work for the commercial buildings too?
    Yes. Each building keeps its own fee rules and bank account, and each gets its own monthly report.

The results

  • Every bank-in is matched to one flat or held for a person; none is posted on a guess.
  • Demand notes show the management fee, car-park fee, arrears and DMC late charge line by line.
  • The owners' corporation's monthly report is ready on the third working day.
PythonClaudeExcelEmail

Representative example — a composite of typical Hong Kong workflows, written from the duties in current job ads. Company names, documents and figures are sample data.

← Back to all case studies

Does your company have a formula like this?

Send us one real example — a quotation, an invoice or a month-end statement — and we will show you how the system would work it out. The assessment is free.

Get a free assessment →