How to move from a commission spreadsheet to software without losing history
Do not retype the past. Bring it in, check it against the sheet to the cent, and run both side by side until a real closing matches.
The commission spreadsheet is often the most trusted thing in the office. It has every closing for years, every agent's cap, and formulas only one person understands. That is the reason to move off it carefully. The goal is not a new system on day one. It is a new system that agrees with the old one before anybody relies on it.
Decide what history has to come over
Not everything in the sheet has to become a live record. Three things usually do:
- This year's closings for every agent, because caps and year-end totals are built from them.
- Each agent's plan, where they stand on their cap today, and the day their cap year opened.
- Last year's paid closings, until that year's tax forms are done. What those need is in 1099-NEC for real estate agents.
Older years can stay as they are: a copy of the sheet, kept read-only, labeled with the date you stopped using it. The new system does not need ten years of closings to work out next week's split. It needs this cap year to be right.
Freeze a copy before you start
Make a copy of the workbook and put the date in its name. Work from the copy. The working sheet stays as it is until the switch, so the office is never without the record it trusts. Nobody fixes a typo in the old sheet during the move without writing down that they did.
Check it to the cent
Bring the rows in, then compare. For each agent: the number of closings this year, the volume, what they were paid and what the office kept. For the office: the total of each. Every figure should match the sheet to the cent. Where one does not, find out which side is right before you go on. The usual causes are a closing typed twice, a referral counted as a closing, a split changed in the middle of the year with the old rows worked again on the new split, or a number typed over a formula.
Do not repair a difference by editing the new record until it agrees. If the sheet was wrong, write down why. That note is part of the history, and it is the answer when an agent asks why their cap moved.
Keep the plan each closing was paid on
The most common way history is lost is not a dropped row. It is a split that changed in May, applied to January's closings. Whatever you move to, each past closing should keep the plan it was paid on, and a change of plan should apply from a date forward. Write the plans down before the first closing in the new system; how is in how to set agent commission plans.
Run both for one closing, then switch
Pick a date. Until then, work each closing in both and compare the split, the cap, the fees and the take-home. When a real closing comes out the same in both, to the cent, switch. After the switch the old sheet is read-only. Two live records of the same money are how two different numbers end up on two statements. If you are still deciding whether to leave the sheet at all, Google Sheets or a brokerage back office weighs it.
Open files come over with their dates. Check each closing, inspection and financing deadline against the contract, not the sheet. The transaction timeline calculator works those out from the contract date and the closing date.
How it works in Deskwork
On Tracker, open the commission workbook you keep today, an .xlsx file dropped in or chosen from Google Drive. Deskwork shows its rows beside the desk's own figures and lists the past closings it has no file for. You see them first, and nothing is created until the broker-owner says so. An office that would rather keep its Google Sheet in use can connect it and try writes on a copy first. Deskwork never deletes a row, clears a cell or writes into a formula. Each closing keeps the plan it was paid on. The Google Sheets page has the detail.
Questions brokers ask
Do we have to bring every past year into the new software?
No. Bring this cap year, and last year's paid closings until the tax forms are done. Keep older years in a dated, read-only copy of the sheet.
How do we know the move worked?
When every agent's closings, pay and the office's share match the sheet to the cent, and one real closing worked in both comes out the same. Then switch, and make the sheet read-only.
Can we keep using the spreadsheet after we switch?
As a record of the past, yes, read-only. Two live records of the same money drift apart. If the office wants its sheet kept current, let one tool write to it, not two people.
Try it on your own office
Set up a plan, file a deal and close it before you decide. A desk you set up yourself through the signup page is free. If we set up your desk with you, what your brokerage pays is set out in our written agreement with you. Read about pricing.
Sign up free Have us set it up