Ready-to-use Excel systems built for Singapore law firms and clinics — automated tracking, flagging, and reporting so your team stops doing manual admin and starts closing more work.
| A | B — Patient | C — Status | D — Flag |
|---|---|---|---|
| 1 | Tan, S.L. | No-show | RE-BOOK |
| 2 | Farah, N. | Attended | — |
| 3 | Lee, W.K. | Stock < 10 | REORDER |
| 4 | Rajan, P. | Claim pending | CHASE |
Fee earners log time once — the sheet auto-splits billable vs non-billable, flags idle days, and totals per matter without a paralegal touching a calculator.
| Matter | Hrs | Bill? |
|---|---|---|
| Tan Holdings | 3.5 | Y |
| Admin | 1.0 | N |
| Lim Conveyance | 2.25 | Y |
Every contract's expiry auto-counts down. Anything inside 30/60/90 days turns red — no one has to remember to check a folder of PDFs again.
| Client | Expiry | Days |
|---|---|---|
| Wee & Co | 18 Jul | 13 |
| Ong Retail | 02 Sep | 59 |
| Kwek F&B | 21 Dec | 169 |
Type a new client's name and the sheet auto-searches your entire matter list for name matches — a conflict check that used to take a junior 20 minutes now takes one keystroke.
| New client | Match? | Matter |
|---|---|---|
| Koh Trading | HIT | #2291 |
| Sim Family | — | — |
Auto-tallies active vs closed matters per lawyer and computes real utilisation %, so partners spot who's overloaded before a deadline gets missed.
| Lawyer | Active | Util% |
|---|---|---|
| J. Ho | 14 | 92% |
| R. Devi | 7 | 61% |
Enter the transaction value and matter type — the sheet auto-computes conveyancing and court fee tiers so quotes go out in minutes, not after a fee-schedule lookup.
| Value | Type | Fee |
|---|---|---|
| $680,000 | Sale | $2,340 |
| $1.2m | Purchase | $3,150 |
Plot leave dates and the sheet auto-flags any day where a practice area has zero cover — built so you catch the gap before a client calls and no one picks up.
| Practice | Date | Cover |
|---|---|---|
| Litigation | 14 Jul | GAP |
| Corporate | 14 Jul | OK |
Auto-calculates your no-show rate per doctor and per time slot, and spits out a same-day rebooking list — no front-desk staff needed to compile it by hand.
| Slot | Status | Rate |
|---|---|---|
| 9am Dr Tan | No-show | 18% |
| 10am Dr Lim | Attended | 4% |
Every SKU auto-checks against its reorder threshold and generates a ready-to-send PO quantity — stock-outs get caught before a nurse notices the shelf is empty.
| SKU | Stock | PO Qty |
|---|---|---|
| Paracet 500mg | 8 | 200 |
| Amoxicillin | 64 | — |
Build the week's roster and the sheet auto-checks MOH rest-hour rules and flags anyone heading into overtime — before payroll finds out the hard way.
| Staff | Hrs/wk | Flag |
|---|---|---|
| Nurse Aini | 46 | OT |
| Nurse Choo | 38 | OK |
Auto-matches insurer payouts against what was billed line by line, and highlights every shortfall — no more manual cross-checking against statements.
| Claim | Billed | Gap |
|---|---|---|
| #8841 | $420 | -$60 |
| #8842 | $180 | $0 |
Auto-ranks every doctor by revenue per clinic-hour, so you know exactly which sessions are worth expanding — without a manager building the report manually.
| Doctor | Rev/hr | Rank |
|---|---|---|
| Dr Wong | $310 | #1 |
| Dr Suresh | $255 | #2 |
Type the bill amount and the sheet auto-computes 9% GST, assigns the next sequential invoice number, and formats it ready to print or email.
| Inv# | Subtotal | +GST |
|---|---|---|
| 0442 | $180.00 | $196.20 |
| 0443 | $95.00 | $103.55 |
Need something not in the catalogue? I build custom spreadsheets and simple AI tools for SG SMEs — DM to scope it.
No storefront checkout maze. Three steps, all through chat.
Message @SynthAlpha with the sheet's tab reference (e.g. "B2 — Reorder Automator") or which team you're buying for.
You'll get a direct checkout link for that exact sheet — no browsing, no wrong version.
Pay on Payhip, download the .xlsx, and drop your team's data into the highlighted input cells. It's already automated.