Client Money Checklist for Sole Practitioners: Monthly Controls With AI

Coding Liquids tutorial cover featuring Sagnik Bhattacharya for Client Money Checklist for Sole Practitioners: Monthly Controls With AI.
Coding Liquids tutorial cover featuring Sagnik Bhattacharya for Client Money Checklist for Sole Practitioners: Monthly Controls With AI.

Each month a sole practitioner should reconcile the client account to the bank, check the client ledgers add up to the same total, clear or explain every unallocated receipt, review money held too long, and record the sign-off. AI can prepare exception lists and reminders from summaries, but reconciliation and judgement stay with you.

The rules differ by regulator and country, and they change, so treat this as a working frame rather than a statement of what yours require. What it adds is order: the same steps in the same sequence each month, with a note of who or what does each one. Working alone makes that order more important, not less, because nobody else sees a missed month.

Follow me on Instagram@sagnikteaches

The monthly sequence, in the order that saves rework

Order matters because each step feeds the next. If you start by reviewing old balances before the bank is reconciled, you review figures that may be wrong. This sequence moves from proof to explanation to follow-up.

Connect on LinkedInSagnik Bhattacharya
  1. Get the month-end bank statement for the client account. Download it yourself; do not rely on a feed you have not looked at.
  2. Reconcile three figures: the bank balance (adjusted for uncleared items), the cash book balance for the client account, and the total of all client ledger balances. All three should agree. If they do not, stop and find the difference before anything else.
  3. Clear unallocated receipts and payments. Every receipt must belong to a named client ledger; every payment must have an authority.
  4. Check for negative ledger balances. A client ledger below zero means you have used another client's money. That is an immediate action, not a note.
  5. Review old balances. List ledgers with no movement for a set number of months and decide whether the money should be returned, transferred or queried.
  6. Check transfers to the office account. Each must be supported by a bill or an agreed amount, and the matching entries must be in both ledgers.
  7. Check interest, fees and bank charges were dealt with as your rules require.
  8. Sign, date and file the reconciliation with the statement, ledger list and exception notes.

The first two steps are where the tooling stops and you start. Everything from step 3 is where an assistant can help prepare the list you work through.

Subscribe on YouTube@sagnikteaches

What AI can prepare, and what it must not decide

Draw the line plainly. AI prepares; you decide and sign. It never touches the bank, never approves a transfer and never produces the reconciliation figure that you rely on.

StepAI may prepareStays with you
ReconciliationA blank checklist and a layout for your reconciliation noteThe figures, the matching, the sign-off
Unallocated itemsA sorted exception list from an anonymised export, with possible matches suggested for you to checkDeciding where each item belongs
Negative balancesA flag list of any ledger code below zero in the exportWhy it happened and how it is cured
Dormant balancesA list of ledgers with no movement beyond your threshold, and a draft letter templateThe decision to return, transfer or query
TransfersA list of transfers without a matching bill numberWhether the transfer was properly authorised
RemindersCalendar entries, follow-up emails, a month-end task listWhether the work is done

The reason for this split is that a wrong AI suggestion in a preparation step costs you a few minutes, and you catch it because you are checking against the real records. A wrong AI figure in the reconciliation itself would look right and be wrong, which is the one place a practitioner cannot afford it.

The Complete Excel Course with AI Integration thumbnail

The Complete Excel Course with AI Integration

From formulas and pivot tables to Power Query, DAX, VBA and AI with Copilot, ChatGPT and Claude — hands-on from the first lesson.

By Sagnik Bhattacharya and Virginia Thorn, Primetime Emmy Award winner

Buy now

Keep client details out of the export you give an AI tool

Export from your accounts software only the columns you need: ledger code, date, amount, type (receipt or payment), reference and age in days. Replace the ledger code with a neutral code if the tool does not need to know it, and strip account numbers and descriptions that include names. A table of 40 rows with codes and amounts is enough to find exceptions.

Ledger,Date,Type,Amount,Ref,Days_since_last_movement
L014,2026-10-03,Receipt,2500.00,TFR-0381,0
L014,2026-10-18,Payment,1200.00,CHQ-2210,0
L022,2026-04-02,Receipt,800.00,TFR-0144,215
L031,2026-10-29,Receipt,450.00,UNALLOC,6
L040,2026-10-30,Payment,3100.00,CHQ-2219,5

Use a business plan that does not train on your content by default, and turn the consumer training setting off if you must use a personal plan. The data-control steps written for tax practices apply unchanged, including the three-tier list of what never goes in. Check that using AI at all is consistent with your engagement terms and your regulator's guidance on confidentiality.

A prompt that turns the export into an exception list

I run a one-person practice. Below is an anonymised export from my
client account for October. Do not give advice. List, in separate
sections:
1. Any ledger with a negative running balance (calculate it from the
   rows, show the arithmetic).
2. Any row whose Ref is UNALLOC.
3. Any ledger with Days_since_last_movement over 180.
4. Any payment with no receipt earlier on the same ledger.
5. Any row where Amount is a round number over 2,000 (for me to eyeball).
If a section has nothing, write "none found". State the number of rows
you read. [paste the CSV]

The line "state the number of rows you read" is a cheap guard against the tool silently dropping data. Compare the number to your export before trusting the lists.

An illustrative result and the fixes you make

With the five-row sample above, a good answer reports no negative balances (L014 received 2,500 and paid 1,200, leaving 1,300), one unallocated receipt (L031, 450.00, six days old), one dormant ledger (L022, 215 days) and one payment with no earlier receipt on its ledger (L040, 3,100). That last one is the finding that matters: a payment from a ledger with no money in it is a negative balance of 3,100, and the tool should have reported it in section 1 as well. If it missed that, your fix is to say "a payment on a ledger with no prior receipts counts as negative" in the prompt, and rerun. This is also why you always check a few lines by hand: the arithmetic here takes seconds, and it finds exactly the failure a quick read would miss.

A worked month for a one-person practice

Say a sole practitioner has 28 active client ledgers and a client account total of $186,420 at month end. The bank statement shows $191,920, with two uncleared cheques totalling $5,500. Adjusted bank balance: $191,920 minus $5,500 equals $186,420. The cash book also shows $186,420, and the ledger total is $186,420 as well, so all three agree. That takes about 20 minutes with the export open.

Now the exceptions. The AI-prepared list shows one unallocated receipt of $450, which turns out to be a client's top-up paid without a reference; the practitioner confirms with the client by email and allocates it. It shows one ledger dormant for 215 days with $800 sitting in it: the practitioner decides to write to the client, using a draft the assistant prepared, asking where to return the money. It shows no negative balances. Total time: 75 minutes, of which 20 are reconciliation, 25 are working through exceptions, 20 are writing and checking two letters, and 10 are filing.

Without the preparation, the same month often takes closer to two hours because the exceptions are found by scrolling. These are illustrative numbers, but the shape is typical: the time saved is in finding exceptions, not in the reconciliation itself.

When the three figures do not agree

The month the figures disagree is the month the checklist earns its keep. Suppose the bank adjusts to $186,420, the cash book shows $186,420 and the ledger total is $186,870. The ledgers are $450 higher than the other two. That is exactly the size of the unallocated receipt in the earlier example, which suggests the $450 was posted to two client ledgers instead of one, or credited to a client ledger although it never reached the bank or the cash book.

A sensible search order for a difference, from cheapest to most expensive:

  1. Look for a difference equal to one item. Search the month's rows for the exact amount, then for half the amount (an item posted to the wrong side, such as a receipt keyed as a payment, shows as a difference of double its value).
  2. Look for a transposition. A difference divisible by 9 often means two digits swapped, such as 540 keyed as 450.
  3. Check the cut-off. An item dated 31 October on your books and 1 November at the bank is a timing difference, not an error.
  4. Check the opening position. Did last month's signed reconciliation start from the same figures? A difference that appeared before this month is carried, not new.
  5. Escalate. If you cannot explain it within a set time, say 45 minutes, write down what you tried and ask your bookkeeper, your accountant or your regulator's helpline, depending on the size of the gap and your rules.

An assistant can help with steps 1 and 2 on an anonymised export: "Find any two rows whose amounts sum to 450, any row equal to 450, and any pair of rows where the digits of one are a transposition of the other." Treat its answer as a lead and open the rows yourself. The arithmetic divisible-by-9 test above is something you can do on a calculator in ten seconds, which is a good reminder that not every step needs a tool.

A dormant balance, from flag to letter

Take ledger L022 from the sample: $800 received 215 days ago, nothing since. The monthly review flags it. Before writing, look at the matter: is it closed, is a bill outstanding, did the client ask you to hold the money? Your rules decide what you may do next, and they vary, so check them. If the correct step is to ask the client where to send the money, an assistant can draft the letter from a template you supply.

Draft a short letter from a one-person practice to a client,
[first name]. We hold $800 on their behalf following the completion
of their matter. Ask them to confirm in writing where we should
send it, and say we will write again in 28 days if we hear nothing.
Plain, courteous, under 120 words. Use [ref] for our reference.
Do not give advice about their rights.

Illustrative output: three short paragraphs, the amount, the request, the 28-day follow-up. What you fix: the tool may add a sentence about "regulatory requirements" that you cannot verify, or promise a payment date. Delete both. Then put a diary entry for day 28 and record the letter in the ledger notes. The point of the exercise is that the practitioner decides what to do, and the assistant saves ten minutes of typing.

Checking transfers to the office account against bills

Transfers from client money to office money are where small practices most often drift. Take the month's list of transfers and match each to a bill number, an amount and a date. Illustrative month: four transfers of $1,200, $850, $2,400 and $600, total $5,050. Four bills exist, numbered 1,042 to 1,045, for $1,200, $850, $2,100 and $600. The third transfer is $300 more than its bill. That is either a bill that was changed after issue or a transfer keyed incorrectly, and it needs an answer the same day. An export with a bill-number column makes this a one-minute check; a prompt asking for "transfers whose amount differs from the bill with the same number" does the comparison, and you confirm the two rows.

Keep the habit even if no transfers differ. A clean list is evidence that you looked.

Cover for holidays, illness and the unexpected

A sole practitioner has no colleague to notice a missed month, so build cover in advance. Write a one-page note: where the client account statements are, who can access the bank, who may sign the reconciliation if you cannot, and where the checklist lives. Name a person or firm to act in an emergency, and check what your regulator expects for arrangements if a practitioner cannot practise. Store the note in a place a trusted person can reach, and review it each year with your insurance renewal.

For holidays, move the month-end routine earlier or later rather than skipping it, and put the new date in your calendar the day you book the leave. A reconciliation done on day three instead of day one is a minor point; a month with none is a finding.

Quarterly and annual checks that sit above the monthly routine

  • Quarterly: trace one ledger end to end, from the first receipt to the last payment, and confirm every entry has a document behind it.
  • Quarterly: check bank mandates and online access: who can sign, who can view, and whether anyone who has left still has access.
  • Annually: reread your regulator's current rules and note any change in the checklist, with the date.
  • Annually: confirm your insurance and any accountant's report requirements are met, and that the file of monthly reconciliations is complete, twelve out of twelve.
  • Annually: test your AI preparation prompts again on a fresh anonymised export, since tools and your account software both change.

Reminders that stop a missed month

For a one-person practice, the biggest risk is skipping a month under pressure. Put reminders where you cannot ignore them.

  • A recurring calendar event on the same working day each month, 90 minutes long, titled with the first step ("Download client bank statement").
  • A second event three working days later: "Reconciliation signed? If not, do it today."
  • A quarterly event to review the dormant list and any items you have carried forward more than one month.
  • An annual event to reread your regulator's rules and update your checklist.

An assistant can write the events and the checklist text; the calendar sends them. If you use a practice-management system, check whether it can create tasks on a schedule: Clio's newer AI workflows, for example, can run monthly and create tasks (what to set up first in Clio covers which plans include them), though a calendar works just as well.

A filled-in month-end checklist

ItemDoneEvidence keptNotes (illustrative)
Bank statement downloaded31 OctPDF in October folderStatement balance $191,920
Three figures agree31 OctReconciliation sheetAll $186,420; two cheques uncleared
Unallocated items cleared1 NovEmail to client$450 allocated to ledger L031
Negative balances1 NovException listNone found
Dormant ledgers reviewed1 NovDraft letterL022, $800, letter sent
Transfers matched to bills1 NovBill listFour transfers, four bills
Signed and filed1 NovSigned sheetNext review 30 Nov

Where checks go wrong and how it shows up

  • A reconciliation that agrees by plugging a figure. A "balancing" entry hides a real difference. It shows up when the same small difference recurs. Rule: never plug; find the item.
  • Uncleared items that never clear. A cheque listed month after month. It shows up in the adjusted bank balance. Rule: any uncleared item older than a set number of weeks gets a call or a re-issue.
  • Allocating a receipt to the wrong client. It shows up when a later payment makes that ledger negative. Rule: confirm the payer before allocating.
  • Trusting the AI count. The tool reads 38 of 40 rows and reports "none found". Rule: check the rows-read number.
  • Letting the checklist become a ritual. You tick boxes without looking. Rule: once a quarter, pick one ledger and trace it from first receipt to last payment.

For overdue bills and the letters around them, AI-drafted chasers for overdue bills shows how to keep the drafting separate from the money decisions. A related page, the AI readiness checklist for professional firms, covers the policy side.

Write down the rules for AI in your own procedures

A short paragraph in your office manual protects you and any locum or successor. It should say: AI tools may be used to prepare lists and drafts from anonymised data; they must not be given account numbers, passwords or identifiable client details beyond what is necessary; they must not make or approve transactions; every list is checked against the records; reconciliations are signed by the practitioner. Date it and review it each year. If your regulator publishes guidance on technology or outsourcing, add a line saying you have read it.

If you would like help turning your month-end into a routine with the preparation steps automated safely, that is what my AI implementation consultation covers. The checklist above works without it.

Questions sole practitioners ask about monthly client money checks

Can AI do my client account reconciliation?

No. Reconciliation is the control that proves the money is where the records say it is, and it needs a person who is accountable and has the real bank and ledger data. AI can prepare lists of exceptions and reminders around it, using anonymised or summarised data.

Which rules apply to my client account?

They differ by regulator, country and profession, and they change. This checklist is a practical frame only. Read your regulator's current rules and any guidance on monthly or periodic checks, and ask your regulator or adviser when a case is unclear.

Should I paste client ledgers into an AI tool?

Avoid it. Export only what you need, replace names with ledger codes, remove account numbers and use a business plan that does not train on your content. A list of ledger codes, dates and amounts rarely needs a name.

How long should the monthly check take?

A tidy one-person practice with a handful of active ledgers might need one to two hours. If it regularly takes longer, the problem is usually unreconciled items from earlier months rather than the checklist.

Further reads

Sources: regulator rules differ and were not summarised here; the practice described is the common pattern of a three-way check between client ledger, cash book and bank statement. Check your own regulator's current rules.

Want a monthly routine you will actually keep?

On a 1:1 call we can map your month-end steps, decide which preparation jobs AI can take on safely and set up the reminders around them.

Book a 1:1 call with me