How to scale a debt mediation practice beyond spreadsheets

Signs the practice is ready for a better system

You may be at that point if:

• the same client information is copied into several sheets;
• affordability formulas are difficult to explain or check;
• proposal responses sit in individual inboxes;
• staff are unsure which creditor terms are current;
• payment allocations are recalculated manually each month;
• documents are copied from old templates;
• follow-ups are kept in personal reminders; or
• the owner has to approve or recheck every small task because the process is not visible.

None of these means the practice is failing. They are signs that the process has outgrown the tools holding it together.

Fix the workflow before adding automation

Software will not repair an unclear process. Before moving systems, agree on:

1. what must be captured at intake;
2. how affordability is assessed;
3. what makes a proposal ready to send;
4. which statuses a proposal can have;
5. who owns each follow-up;
6. how accepted terms are recorded;
7. how offline payments are recorded; and
8. what closes an account.

Write those decisions down. They become the practice's working method and make training much easier. Our workflow for firms is a useful starting template.

Separate roles as the team grows

A solo mediator may handle the whole file. A growing practice often needs different people to handle different stages.

Intake or client agent

Captures client information, requests missing documents, and flags urgent items.

Mediator

Reviews affordability, prepares proposals, negotiates with creditors, and records accepted terms.

Payment or administration team

Records offline payments, applies the practice's allocation method, checks distribution records, and follows up on exceptions.

Practice owner

Reviews workload, access permissions, outstanding actions, and the overall quality of the records.

The exact roles will differ by firm. The important point is that responsibility is visible and sensitive actions are limited to the people who need them.

Create one current record per client

Each client file should have one clear place for:

• identity and contact details;
• income and expenses;
• creditor accounts;
• current proposals;
• responses and follow-ups;
• accepted terms;
• payment-allocation records; and
• documents and account status.

If the team has to ask which spreadsheet is current, the practice does not have a single source of truth yet.

Measure the work that causes delay

Useful operational measures include:

• new intakes waiting for information;
• affordability assessments awaiting review;
• proposals awaiting a creditor response;
• counter-offers awaiting client approval;
• payments waiting for a distribution record;
• accounts ready for paid-up confirmation; and
• overdue follow-ups by staff member.

These measures tell the owner where the process is slowing down. They are more useful than tracking only the number of new leads.

Migrate in stages

Do not try to clean every historical file in one weekend. A practical migration can look like this:

Stage 1: Define the fields

List the information the practice actually needs. Remove duplicate fields and agree on names and statuses.

Stage 2: Start with active files

Move the clients who still have open proposals, active arrangements, or regular payment records. Leave closed historical files until the new process is working.

Stage 3: Check the first batch

Compare the new records with the source spreadsheets. Check balances, agreed terms, open tasks, and document links.

Stage 4: Train around real cases

Use a few ordinary files to teach the workflow. Staff learn faster when they can see how an intake becomes a proposal and then a payment record.

Stage 5: Retire duplicate processes

Once the team trusts the new record, stop maintaining a second spreadsheet “just in case.” Keeping two systems alive recreates the same uncertainty.

What DebtDesk can take off the spreadsheet

DebtDesk gives a mediation practice one case record for intake, affordability, creditor proposals, negotiation history, payment-allocation records, and documents.

It supports role-based access so an agent, mediator, administrator, and owner can work from the information relevant to their role.

DebtDesk does not receive, hold, or transfer mediation-client money. The practice handles all client fees and creditor payments offline and remains responsible for checking records before acting on them.

When a generic CRM may still be enough

A general CRM may be fine if the practice only tracks leads, referrals, and conversations, while another system or team handles affordability, proposals, and payment records.

The question is not whether a CRM is good or bad. It is whether the practice is asking it to manage work it was never configured to represent. We compare the two in debt mediation software vs a generic CRM.

Common questions

Related guides

• Debt mediation workflow for firms
• Debt mediation client onboarding checklist
• Debt mediation software for South Africa