Think Build Implement Repeat
London, UK +44 7367 067226
WhatsApp FOLLOW f in X
  1. Home
  2. Blog
  3. Why Are We Still Chasing Service Charge Arrears With a Spreadsheet?
Problems We Solve

Why Are We Still Chasing Service Charge Arrears With a Spreadsheet?

Block managers chase service charge arrears by hand across dozens of blocks. We build a staged arrears workflow that follows your credit control procedure.

Updated 3 min readBy SpiderHunts Technologies

Free estimateNo obligation

Get a free estimate

Tell us what you need. A senior engineer reads every enquiry.

Takes under a minute. We never share your details.

  • Free consultation
  • No commitment
  • NDA on request

Prefer to talk? Book a free 30-minute call →

Quick answer — TL;DR

Arrears chasing breaks down when it depends on someone remembering to run a report and write letters for each block. We build a workflow that reads balances from your block management system, applies the stages your own credit control procedure sets, drafts the right reminder for each leaseholder and hands anything sensitive, such as a dispute or a payment plan, to a person.

The arrears report nobody has time to finish

Service charge demands went out at the start of the quarter. A few weeks later the credit controller, or more often the property manager, runs an aged debt report, exports it to Excel and starts working down it. Reminder letters for some, a phone call for others, a note on the file for the one who said the cheque is in the post.

Then a leak comes in, a director wants an update, and the list stops halfway. Next quarter it starts again from the top, and the leaseholders who were three months behind are now six.

Why the process keeps stalling

Most firms have a written credit control procedure: first reminder, second reminder, final notice, referral. The procedure is fine. What fails is that nothing runs it. Every stage depends on a person pulling a report, deciding who is at which stage and writing the letter.

The information needed to decide the stage is also split. The balance is in the accounts, but the fact that a leaseholder disputed a charge, agreed a payment plan or is selling the flat lives in emails and notes. So each letter needs a check first, and the check is what takes the time.

The cost to the blocks you manage

Arrears hit the block, not your firm. Contractors go unpaid or works get delayed because the service charge account is short, and the paying leaseholders end up subsidising the others. Directors of resident management companies notice and ask why.

There is a risk the other way too. A reminder sent to someone with an agreed payment plan, or a formal letter during a live dispute, damages the relationship and generates complaints that take longer to handle than the arrears themselves.

The arrears workflow we build

We automate the routine stages and keep people on the ones that need judgement. The stages and wording come from your procedure, not ours.

  1. Balance feed: we read leaseholder balances and demand dates from your block management system on a schedule, through its API or a report export.
  2. Hold flags: a simple register records disputes, payment plans, sales in progress and anything else that should pause chasing. Property managers set these, and the system respects them.
  3. Stage rules: each overdue balance is placed at the stage your procedure defines, based on age, amount and previous contact.
  4. Drafting and sending: reminders are generated from your templates with the correct figures and sent by email, with printed letters queued for those who need post.
  5. Escalation queue: anything reaching a final stage, or any account with a hold flag that has expired, goes to a named person with the history summarised.
  6. Block view: each block gets a current arrears summary that property managers can share with directors.
SituationWhat the system doesWhat a person does
Recently overdue, no flagsSends the first reminder from your templateNothing unless the leaseholder replies
Still unpaid at the next stageSends the next reminder and logs itReviews the list weekly
Dispute or payment plan recordedPauses chasing and shows the reasonDecides when to resume
Final stage reachedStops and escalates with a summaryDecides next steps with the client's advisers

What changes in the office

Routine reminders go out on time without anyone remembering to run a report. The credit controller or property manager works from a short list of accounts that need a decision, each with the balance, the history and any notes in one place.

When a director asks about arrears on their block, the answer is a current summary rather than a promise to look into it.

Is this your situation?

  • Arrears chasing happens in bursts when someone finds time.
  • Reminders have gone to leaseholders who had agreed a payment plan.
  • The aged debt report lives in Excel and is rebuilt every quarter.
  • Directors ask for arrears figures and it takes a day to produce them.
  • Some blocks are short of funds for works because of long-running arrears.

FAQ

Frequently asked questions

The questions readers ask us after this guide.

Still have a question?

Ask us directly — a senior engineer will get back to you.

Ask about your project

Will it send legal or formal notices automatically?

No. We automate routine reminders only. Anything formal, or anything that depends on the lease or legal advice, is escalated to a person to decide with the client's advisers.

Does it work with our block management system?

Usually yes. We read balances through an API where there is one, or from a scheduled report export where there is not.

What if a leaseholder has already paid?

The system refreshes balances before each run, so a recent payment removes them from the list. Payments received but not yet posted can be marked by a person to pause chasing.

Can we keep our own letter wording?

Yes. Templates come from your procedure and you can edit them. We only insert the figures, dates and block details.

What drives the cost?

The number of stages, whether post as well as email is needed, and how easy your system makes it to read balances and write back notes.

Keep reading

More on Problems We Solve

Start here

Tell us where your block management admin gets stuck

Describe the task, how many blocks it touches and which system you run them on. We will tell you what we would automate, what should stay with your property managers, and if a smaller change to your current setup would fix it, we will say that instead.

  1. You tell us what you needTwo minutes on the form, or a message on WhatsApp.
  2. A senior engineer reviews itAnd comes back with questions, a realistic range and an honest view on fit.
  3. Free 30-minute scoping callWe talk through scope, options and a realistic estimate — with no obligation.
Free estimateNo obligation

Talk to someone who builds this

Send a short brief and we will come back with an honest view and a realistic range.

Takes under a minute. We never share your details.

  • Free consultation
  • No commitment
  • NDA on request

Prefer to talk? Book a free 30-minute call →