Somewhere in your finance business there is a spreadsheet that works out repayments, fees, commissions or interest. Someone capable built it years ago and it was right. Then it was emailed to a new starter who adjusted a rate. Someone else added a tab for a new product. The original author left. Today there is a copy on every laptop, each one slightly different, and the quote a client receives depends on which copy the broker opened.
We hear this from brokers, lenders and advisers all the time, and it is hardly ever described as a software problem. People say "we need to get everyone on the same version". The problem is that a spreadsheet does not have a same version. Every copy that gets emailed is a new branch.
What it costs
- Quotes that do not match. Two brokers quote the same client and get different figures. The client notices before you do.
- Rates that lag. A lender changes a rate. The master copy gets updated. Half the office is still working from last month's file.
- No record of what was quoted. A client disputes a figure a year later. The spreadsheet has been overwritten a hundred times since then and there is nothing to show what they were told.
- Compliance that relies on trust. If a regulator asks how a figure was calculated, the honest answer is "whichever version the broker had open that day".
Containing it
You can slow the drift down before rebuilding anything.
- One master, locked. Keep the calculator in one shared location, protect the formula cells, and make the rate table the only thing anyone is allowed to edit.
- Put a version number on the front sheet. Change it every time the rates change, so an old copy is obvious at a glance.
- Save the output, not the file. Export every quote to PDF and attach it to the client record, so there is a record of what was said regardless of what happens to the spreadsheet afterwards.
These work for a small office with a disciplined manager. They stop working once there are more than a handful of products, more than a handful of people, or a second location.
What the alternative looks like
Businesses that fix this permanently stop treating the calculator as a file and build it into their system. The rates live in one place and one person changes them. Every broker uses the same calculation because there is only one. Every quote is saved against the client with its inputs and outputs, so it can be reproduced exactly a year later. The documents, from the quote through to the application forms, are generated from the same data.
That is what we built for Chase Finance: a broker CRM with the loan calculators built in, along with dynamic PDF generation and reporting for the internal checks and follow-ups that used to live in people's heads, such as balloon payments and settlements coming due. The Excel calculators that everyone had a different copy of were retired.
A calculator on its own is a small build. It is a good place to start because it is the part of a finance business where a wrong number costs the most, and the part where a shared system proves its worth fastest. Once the calculator is in the system, the CRM, the forms and the reporting usually follow, because the data they need is already there.
If your office is running on nine versions of one spreadsheet, have a look at what we build for finance businesses, or tell us where the numbers get re-keyed and we will talk it through.
