Jump to section
Here is a claim I will defend all afternoon: you do not need a consultant, a data warehouse, or a five figure quote to see how your firm is doing. You need one screen, six numbers, and about three hours. By the end of today you can have a dashboard that pulls from data you already export, refreshes on its own, and lives somewhere your team actually looks. No code required.
I have built this for a two lawyer shop and for a twenty person firm. The recipe barely changes; what changes is which six numbers earn a tile. Here is the whole build, from picking metrics to sticking it on a wall.
Pick the six tiles that matter and ignore the rest
The temptation is to measure everything. Resist it. A dashboard with thirty numbers is a spreadsheet, and nobody reads a spreadsheet at a glance. Six tiles is the sweet spot: enough to tell a story, few enough to absorb in the ten seconds someone gives it while refilling their coffee.
Pick numbers that would change a decision this week. Not vanity counts, not totals that only go up. A good tile answers a question a partner is actually asking, the kind of firm operations question that otherwise gets guessed at. Here is a starting set for a small firm that bills by the hour:
| Tile | Question it answers |
|---|---|
| Billable hours this month | Are we on pace? |
| Work in progress not yet invoiced | What are we sitting on? |
| Accounts receivable over 60 days | Who owes us and for how long? |
| New matters opened this month | Is the pipeline healthy? |
| Matters closed this month | Are we finishing what we start? |
| Trust balance versus client ledger | Are we in balance and compliant? |
Swap freely. A family practice might trade work in progress for upcoming court dates; a flat fee shop might track average days to close. The rule holds either way: six, and each one earns its place.
Tip. Write the question above each number before you build anything. If you cannot name the decision a tile informs, it is not a tile, it is trivia. For more on this discipline, our piece on setting quarterly goals pairs well.
Where your numbers already live
You are not starting from scratch. Every practice management tool worth using can export the raw material for these tiles, usually as CSV. The trick is knowing which report holds which number.
- Time entries give you billable hours and, filtered by invoice status, work in progress.
- Invoices and payments give you receivables, and an aging column tells you the over 60 days figure.
- The matter list, with open and close dates, gives you opened and closed counts.
- Trust ledgers give you the balance and the per client breakdown you need for reconciliation.
In A1 CMS these all sit under the reporting exports for Time and Billing, Invoices, Matters, and Trust accounting, and each one downloads as a plain CSV you can open anywhere. Whatever you run, spend ten minutes finding the four or five exports that cover your six tiles. That reconnaissance is half the job.
The goal is a dashboard that refreshes on its own so you are always looking at current numbers, not last month's export. Priya Natarajan
Wiring a spreadsheet to your practice tool
Here is where people expect the hard part. There isn't one. A spreadsheet is your whole engine.
Create one workbook with a tab per export, and drop each CSV into its own tab exactly as it downloads. Then build a seventh tab called Dashboard. On that tab, each tile is a single formula that reads from the raw tabs. Billable hours this month is a SUMIFS across the time tab filtered to the current month. Receivables over 60 days is a SUMIFS on the invoice tab where the aging column exceeds sixty. Nothing fancier than functions you already half know.
- Paste each export into its own tab, headers and all.
- On the Dashboard tab, write one formula per tile that summarizes the raw data.
- Format the six results as big, bold cells with the question as a label above each.
- Add a small "last updated" stamp so nobody trusts a stale number.
Do this once by hand, replacing the raw tabs with fresh exports. If the six numbers on the Dashboard tab update correctly, your wiring works. That is the whole mechanism. The rest is making it effortless.
Note. Keep the raw tabs untouched. Never edit numbers in the export tabs, only paste over them. Every calculation lives on the Dashboard tab so a bad paste can never silently corrupt a tile.
Making the dashboard update itself
A dashboard you update by hand is a dashboard you will abandon by February. The goal is that fresh data flows in without anyone thinking about it.
Two honest options. The low tech one: a five minute Friday ritual where one person re exports the CSVs and pastes them in. That is genuinely fine for a small firm, and it fits neatly into the kind of weekly reset a lot of practices already run. The higher tech one: if your tool offers scheduled exports or an API and your spreadsheet lives in a cloud tool like Google Sheets, the exports can land automatically and the formulas recalculate on open. No code, just configuration.
Whichever you choose, decide the cadence, then remove yourself from it as much as you can. If manual steps are piling up generally, our note on outsourcing the right tasks is worth a read, and reducing decision fatigue starts with automating the numbers you check most.
Putting it on a screen people actually see
If nobody looks at the dashboard, the build was wasted. The final step is placement.
The best spot is a cheap monitor or an old tablet mounted somewhere with traffic: the shared kitchen, the reception wall, the corner of the boardroom. Set the Dashboard tab to full screen and leave it. People will glance at it a dozen times a day without meaning to, and that ambient awareness is the entire point. If your team is remote, pin the link in your chat channel and open it at the start of your standing meeting. The habits around visibility matter as much as the build, which is why cutting the meeting load and having a live screen so often go together: the screen replaces the status update.
Watch out. Trust and receivables numbers belong in front of the right people, not everyone. If your dashboard hangs in a client facing area, keep those tiles on a private version and put only pipeline and workload metrics on the public one. Check your law society's rules on client confidentiality before anything with client names goes on a wall.
That is the build. Six tiles you chose on purpose, fed by exports you already had, summarized in one spreadsheet, refreshed on a rhythm you can keep, and parked where your team will see it. Proper business intelligence tools are wonderful and there is a reason firms buy them, but you do not need one to answer the six questions that run your week, and you do not need to wait for a budget approval to start. Open a blank sheet this afternoon, drop in one export, and write the first formula. By five o'clock you will know something about your firm you did not know at lunch.
