Comparison
Spreadsheet reporting vs portfolio-level reporting
If your numbers live in spreadsheets, every report is only as current as the last person who updated the file. A structured portfolio-level approach pulls reports straight from the underlying ledger, levies, lease and maintenance records, so figures reconcile to source data instead of being re-typed. Spreadsheets remain flexible and familiar, and for a small portfolio they can be enough. But as units, schemes and statutory obligations grow, the manual copy-update-version cycle becomes the main source of errors and late reporting. Below is an honest comparison across the criteria that matter to South African managing agents, trustees, landlords and rental agents.
| Regalis | spreadsheet reporting | |
|---|---|---|
| Source of figures | Reports read directly from the transactional ledger, levy and lease records, so totals tie back to source entries rather than re-keyed values. | Figures are typed or pasted into cells from statements, invoices and emails; the report is a separate copy that can drift from the underlying records. |
| Audit trail | Each posting and change carries a timestamp and user, giving a traceable record useful for trustee and CSOS scrutiny under the STSMA and CSOS Act. | A spreadsheet records the final value, not who changed what or when, unless someone maintains version notes by hand. |
| Real-time accuracy | Balances and arrears update as transactions are captured, so a report opened today reflects today's position. | Accuracy depends on the last manual refresh; a report is current only up to whenever the file was last touched. |
| Multi-scheme / multi-portfolio rollup | Consolidated and per-scheme or per-portfolio views are generated from one dataset without merging separate files. | Each scheme or portfolio usually sits in its own workbook; consolidation means manually combining files and reconciling totals. |
| Arrears and levy tracking | Arrears, levy raises and receipts are tracked per unit against the ledger, with ageing produced automatically. | Arrears ageing is maintained by hand; a missed receipt entry quietly understates or overstates what owners owe. |
| Error and formula risk | Calculations run through fixed, tested logic rather than editable cell formulas, reducing the chance of a broken or overwritten formula. | A wrong cell reference, dragged formula or deleted row can silently corrupt totals with no warning. |
| Access control and POPIA handling | Access is role-based and personal data sits in a controlled system, supporting POPIA-aligned handling of owner and tenant information. | Workbooks are often emailed or shared via shared drives, making it harder to control who sees personal and financial data. |
| Reporting effort and turnaround | Standard owner, trustee and management reports are produced on demand from live data. | Each reporting cycle requires manual updates, checks and formatting before the report can be issued. |
| Continuity if a person leaves | Reporting logic lives in the platform, so it survives staff changes and handovers. | Complex workbooks often rely on the one person who built and understands them; continuity is at risk if they leave. |
Where Regalis is strong
- Reports reconcile to source records, reducing re-keying errors and manual reconciliation.
- Timestamped, user-attributed history supports trustee oversight and CSOS Act and STSMA accountability.
- Consolidated multi-scheme and multi-portfolio reporting from a single dataset, with on-demand turnaround.
- Role-based access supports POPIA-aligned handling of owner and tenant data.
Where this approach can make sense
- Highly flexible and familiar, with low or no software cost for a small portfolio.
- Easy to build a quick one-off or custom view without waiting for a feature.
- No vendor dependency, the file can be opened and edited anywhere.
- Can be entirely adequate for a single small scheme or a handful of units with simple finances.
This page compares general operating approaches, not any specific product or provider. Your experience depends on your own tools, data and processes. Published by Regalis.
Spreadsheet reporting vs portfolio-level reporting — FAQ
Can I still use spreadsheets alongside a reporting platform?+
Yes. Many managing agents keep spreadsheets for ad-hoc analysis or one-off calculations while relying on the platform for the figures that must reconcile to the ledger and feed owner, trustee and statutory reports. The aim is to remove manual re-keying from the reports that matter, not to ban spreadsheets entirely.
Is spreadsheet reporting a problem for CSOS or trustee accountability?+
Spreadsheets themselves are not prohibited, but they record only the final figure, not who changed what or when. Where trustees or the CSOS query a number under the STSMA or CSOS Act, a timestamped, user-attributed trail from a structured system is easier to stand behind than a manually maintained workbook.