FirmTier vs spreadsheets and email
When the AML file lives in a spreadsheet, it’s only as good as the last person who updated it
Spreadsheets and email are free and familiar, and for a very small firm they can be enough. What they can’t do is stop work starting before the checks are done, re-screen clients when a sanctions list changes, or show your supervisor who decided what, and when.
Side by side
Spreadsheets and email compared with FirmTier
| Spreadsheets and email | FirmTier | |
|---|---|---|
| Client due diligence | A checklist per client, kept up by hand | A case per client, listing the evidence your firm requires for that risk level |
| Sanctions screening | Manual searches, if someone remembers | UK Sanctions List, UN, EU and OFAC, re-screened when they change |
| Stopping work before approval | Relies on people checking first | Engagements wait for approval by default |
| Audit trail | File history and email searches | Who decided what, when and why, kept with the evidence |
| Preparing for a monitoring visit | Pulling the file together by hand | AML register and firm risk assessment ready to export |
| Deadlines | Typed in and updated by hand | Worked out from client records and Companies House |
| Chasing clients | Someone remembers to email | Records requests and overdue reminders, sent for you |
| Cost | Nothing extra | A subscription per person |
means partly, or with extra work. This compares typical setups, not any one product.
Where FirmTier is the better fit
- You need to show your supervisor a consistent AML file for every client.
- Work keeps starting before the checks are finished.
- Deadlines and chasing depend on one person’s memory.
- The client list, the AML file and the invoices have drifted apart.
When spreadsheets may still be enough
- A very small firm with a handful of clients and one person doing every check.
- You have no need for time, billing or shared email in the same place.
- You’d rather keep costs at zero and accept the manual work that comes with it.
Switching
Moving from spreadsheets in three steps
Import your client list
Bring your spreadsheet in, match its columns to FirmTier’s fields, and check the preview. Nothing is saved until you’re happy with it.
Open cases for current clients
Start onboarding cases and file the evidence you already hold against each client.
Switch on the chasers
Turn on records requests and overdue reminders once a dry run has shown you exactly who would be contacted.
Can we import our spreadsheet?
Yes. Match your columns to FirmTier fields, preview the result, and save the mapping for next time.
What happens to evidence we already hold?
File existing documents against each client’s case and mark each item verified, waived or not required.
Do we have to move everything at once?
No. Many firms start with new clients and bring existing ones across at their next review.
Is FirmTier more work than a spreadsheet?
It asks for the same checks every time. That’s the point: the file is complete without anyone having to remember to update it.
How is it priced?
Per person, with seat types for the work each person does and at least one All-in-One seat per firm. There are no per-check fees for sanctions screening.