The Excel dues tracking vs estate software question usually appears when an estate's spreadsheet has become large enough that somebody spends hours updating payments, checking bank transfers, sending reminders and correcting balances. Excel can work very well for a small estate, but the more households, levies and administrators involved, the more work has to be done manually.
Estate software such as Kompound approaches the same problem differently. Instead of maintaining rows yourself, charges, payments, reminders, credits and household balances are connected to the resident and estate records.
When does Excel work well for estate dues?
Excel is not a bad tool.
For a small estate with straightforward finances, a well-designed workbook can track:
- house numbers;
- resident names;
- service charges;
- payments;
- outstanding balances;
- special levies;
- dates;
- and notes.
Modern Microsoft 365 versions of Excel can also support simultaneous editing when the workbook is stored in OneDrive or SharePoint.
Microsoft currently supports co-authoring across Excel for Microsoft 365, Excel for the web and compatible mobile versions. Cloud-hosted workbooks can also retain version history, allowing administrators to review or restore previous versions. (support.microsoft.com)
That solves some of the old problems of emailing spreadsheets between treasurers.
For a 20-house estate where one person collects one annual charge, Excel may be perfectly adequate.
The problem is not that Excel cannot calculate balances.
It is everything surrounding those calculations.
Once an estate starts managing several charges, hundreds of households, part payments, exemptions and multiple payment channels, maintaining the spreadsheet itself becomes part of the job.
Our guide to calculating service charges for an estate explains the financial structure before deciding which system should maintain it.
What becomes difficult as the spreadsheet grows?
Imagine an estate with 250 homes.
Each household may have:
- monthly or annual service charge;
- security levy;
- generator contribution;
- water charge;
- special project levy;
- previous arrears;
- and occasional exemptions.
Now payments start arriving.
Someone transfers ₦150,000 without putting their house number in the narration.
Another resident pays half.
Someone pays next year's dues in advance.
A committee approves an exemption for one household.
Another resident sends a payment screenshot to WhatsApp.
The treasurer now has to make sure every change reaches the correct spreadsheet row.
That is possible.
But it depends on somebody doing it correctly every time.
As the workbook becomes more complicated, common problems include:
- duplicate entries;
- payments assigned to the wrong house;
- formulas accidentally overwritten;
- unclear payment references;
- inconsistent notes;
- missing exemptions;
- several versions of the workbook;
- and balances that only one treasurer fully understands.
Even with Excel's cloud collaboration and change history, the estate still has to design and maintain the accounting workflow itself.
That is the distinction between a spreadsheet and purpose-built estate software.
How does Kompound handle dues differently?
Kompound treats the household, charge and payment as connected records.
Management can create:
- recurring dues;
- one-off levies;
- special project charges;
- household exemptions;
- and prepaid credits.
Kompound's current platform documentation says scheduled charges can be applied to households automatically, with residents receiving reminders through the app and other supported notification channels. It also supports exemptions and credit for residents who paid ahead or through a previous management arrangement.
This changes the workflow.
Instead of:
> Create spreadsheet → copy previous month → add new charge → calculate balances → send reminders manually
the estate can define the charge once and allow the system to maintain the individual household records.
That becomes particularly useful for recurring service charges.
Read how to collect estate dues without constant chasing for the wider collection process.
Kompound also connects payments to the same estate account.
Its current platform includes resident wallets and documented transaction records, with dues, bills and other payments settling from the resident's balance.
The purpose is not to eliminate the accountant.
It is to eliminate repetitive bookkeeping that software can perform automatically.
What about reconciliation, receipts and arrears?
This is where Excel dues tracking vs estate software becomes more noticeable.
In Excel, a bank transfer usually has to be matched manually to a resident.
Then someone updates the workbook.
Then someone may need to issue or confirm a receipt.
If the resident later disputes the balance, the administrator may need to check:
- the bank statement;
- the spreadsheet;
- WhatsApp messages;
- transfer screenshots;
- and possibly the previous treasurer.
A purpose-built estate platform can keep the charge and payment history connected.
Kompound describes its payments system as maintaining documented charges and transactions so estate statements can be reviewed without reconstructing the financial history manually.
That makes three related jobs easier.
Reconciliation
Payments can be matched against known resident and household records rather than existing separately from the billing system.
See how to reconcile estate payments every month.
Receipts and proof
Residents can have a persistent payment history rather than depending entirely on screenshots.
See estate payment receipts and records.
Arrears
Management can identify households with outstanding charges without rebuilding the list from spreadsheet formulas every time.
For larger estates, this changes dues collection from a periodic accounting exercise into a continuously updated record.
Which is better when several people manage the estate?
Excel has improved greatly here.
With Microsoft 365, several authorised users can co-author the same cloud-hosted workbook, see changes and access previous versions.
So the old argument that “only one person can edit Excel” is no longer generally true.
The more important issue is role and workflow.
Should every EXCO member who needs a financial report also have editing access to the entire workbook?
Should the security chairman be able to change payment balances?
Should a facility manager have access to accounting formulas simply because they need to check whether a particular household has been billed?
Estate software can separate responsibilities.
One user may need financial administration.
Another may need resident management.
Another may work only at the gate.
Residents should normally see only their own household information.
Kompound's platform itself is structured around different resident, estate-management and operational roles rather than putting everyone inside one editable spreadsheet.
Its privacy documentation also describes payment information as part of the platform data associated with dues, bills and wallet transactions.
That role separation becomes increasingly important as the estate grows.
What happens when the treasurer or EXCO changes?
This is one of the most important questions.
A spreadsheet can be handed over perfectly well if:
- the file is organised;
- formulas are documented;
- supporting bank records exist;
- access credentials are transferred;
- and the outgoing treasurer explains the system properly.
But many estate handovers are not that clean.
The incoming committee may receive:
> Final Estate Accounts Updated NEW v7.xlsx
and still have no idea why House 44 has a credit or why House 91's balance was manually adjusted six months earlier.
An estate platform keeps financial history connected to the estate instead of one person's spreadsheet design.
That can make handing over estate finances to a new EXCO significantly easier.
The incoming administration should be able to see:
- household balances;
- charges;
- payments;
- exemptions;
- credits;
- and transaction history
without reverse-engineering the previous treasurer's formulas.
That does not remove the need for proper governance.
It gives the governance process better records.
When should an estate move from Excel to Kompound?
Excel may still be enough when:
- the estate is small;
- billing is simple;
- one or two people manage the books;
- payments are easy to identify;
- and administrators are comfortable maintaining the workbook.
Consider moving to purpose-built estate software when:
- the number of households is increasing;
- several levies run simultaneously;
- arrears are difficult to track;
- residents regularly ask whether payments were received;
- reminders consume significant administrative time;
- multiple administrators need different levels of access;
- EXCO handover is becoming difficult;
- or the estate is already using separate systems for visitors, notices, payments and complaints.
That last point is where Kompound becomes especially relevant.
Kompound does not exist only to replace the dues spreadsheet.
The same platform can connect dues with:
- residents and units;
- visitor access;
- gate records;
- payments;
- notices;
- issues;
- emergency functions;
- and wider estate administration.
That means a resident does not need one system to pay dues, another to approve visitors and WhatsApp to report every estate problem.
For a broader look at that transition, read estate management software in Nigeria.
Excel remains an excellent calculation and analysis tool.
You may still export estate information into spreadsheets when deeper analysis is needed.
But once the spreadsheet itself has become the estate's billing engine, receipt book, arrears register, resident database and handover file, the estate may have outgrown it.
Use Excel where a spreadsheet is the right tool.
Use Kompound when dues have become part of a larger estate operation that needs to keep running regardless of who happens to be treasurer this year.