The case for the spreadsheet
Excel is a brilliant ad-hoc tool. For a single-broker book under 100 loans, a clean trail spreadsheet that imports the monthly CSV and pivots on lender / settlement date is genuinely useful — and free. Many brokerages run this way for years.
Where it breaks
The seams show as the book scales:
- Multi-aggregator data — pulling Connective, MyCRM and AFG into one spreadsheet means re-coding column mappings every month. The headers differ; the date formats differ; the row vs column commission shapes differ.
- Retention scoring — assigning a per-loan risk score by hand is impractical past a few dozen loans. A spreadsheet model can be built but is brittle.
- Clawback exposure — knowing which lender clawback period each loan is in requires the AFG schedule (56 lenders × 8 bands). Embedded in TrailScope; hard to maintain in a spreadsheet.
- Multi-user workflow — once two or more people need to edit the same workbook simultaneously, version control gets ugly fast. Sharing the file by email leads to forks.
- Forecasting — projecting trail revenue forward needs the per-loan amortisation schedule plus assumed run-off curves. Possible in Excel; tedious to maintain.
- AI — you can't ask Excel "which clients have I not contacted in 90 days but are 18 months past settlement with a fixed-rate expiry coming up?". You can ask TrailScope.
| Capability | TrailScope | Excel / Google Sheets |
|---|---|---|
| Auto-detect aggregator column shapes | Yes | Manual re-mapping |
| Retention scoring | Yes | DIY, brittle |
| Clawback schedule lookup | Built-in | External reference table |
| AI Insights | Yes | No |
| Multi-user, row-level security | Yes | Sharing-based |
| PDF report generation | 6 + custom | Manual |
| Time to spin up | Upload a CSV, 5 minutes | An afternoon, then ongoing maintenance |
| Cost | From A$15/mo per broker | Free (your time isn't) |
When to keep using Excel
If you write fewer than 30 loans a year, manage them solo, and don't need retention or forecasting workflows — Excel is fine. You don't need software for software's sake.
When to upgrade
If you have 100+ active loans, multiple writers, or you've ever lost a refinance because you didn't see a fixed-rate roll-off coming, the maths starts to favour a purpose-built tool. The first refinance saved usually pays for a year of TrailScope.
FAQ
Can I import my existing spreadsheet into TrailScope?
Yes — if your spreadsheet is based on an aggregator export, just upload that. If it's a custom format, save as CSV and use the column-mapping screen.
Do I have to give up my spreadsheet to start?
No. Most brokers run both for a month or two — TrailScope for analytics, Excel for whatever the existing reporting flows are.
Is TrailScope easier than maintaining a complex spreadsheet?
For most brokers, yes — the column mapping is auto-detected and the retention/clawback logic is built-in. There's still a learning curve for the dashboard navigation.
Will my accountant accept TrailScope reports?
TrailScope exports PDFs for trail income, clawback exposure and custom slices. Most accountants accept these alongside the aggregator's own statements.
Is my spreadsheet's data private?
Both are private if you keep them that way. TrailScope adds row-level security and an audit log so you can prove who accessed what.