Health and family

One place for all your accounting clients' expense records

A UK accountant's guide to keeping expense records for 20 sole-trader and small-company clients in one tidy system, with a quarterly cycle.

Editorial illustration for One place for all your accounting clients' expense records

An accountant with 20 clients does best with one organised home for client expense records and a routine that follows the rhythm of their clients' year. The routine matters more than the software: a standard onboarding page, a standard monthly pull and a short list of tests before anything leaves your desk.

Examples below are in pounds and are hypothetical. This is about records and habits, not tax or compliance advice.

Start with the client mix

Say your 20 clients split into 11 sole traders, 6 small limited companies and 3 landlords with a couple of properties each. Their records behave differently. The sole traders send a jumble of card receipts and one personal-and-business account. The companies have a dedicated account and a few subscriptions. The landlords have repairs invoices and agent statements. One system can hold all three, but your category list and your checklist should differ by type.

What goes on the onboarding page?

  • Business name, trading start date and year-end
  • Which accounts and cards to expect, and which are mixed personal use
  • Currencies besides pounds, such as a supplier billed in euros
  • Who sends records and by which date each month
  • Anything unusual: a van, working from home, a loan, a partner who pays some costs personally

Complete it once at the start of the engagement and review it each year. It saves you the awkward mid-year discovery of an account nobody mentioned.

How do you handle mixed personal and business spending?

Ask the client to nominate one card or account for business and stay with it. Where that has not happened, categorise the personal items as drawings or owner spending in a separate category rather than deleting them. That keeps the statement total matching the bank while keeping the business figures clean.

A quarter in three steps

  1. Month one: pull statements, categorise, tick every line against a receipt where one exists
  2. Month two: repeat, and look at the quarter so far for oddities such as a subscription that doubled
  3. Month three: reconcile, write a note of open questions and send the client a one-page summary

Because many clients work to a quarterly rhythm, the third month is the busiest. Schedule your heavy reconciling days for the second and third weeks, and keep the first for chasing.

Do you need a different category list per client?

A shared core list helps you compare clients and spot problems quickly, with a few extras for specific trades. A hypothetical core: Materials, Travel, Software, Insurance, Phone and internet, Bank charges, Professional fees, Other. Add Rental repairs only for landlords and Subcontractors only for tradespeople. Keep names identical across clients so a pivot table across all 20 works in seconds.

What should each client see?

A one-page summary beats a spreadsheet dump. Show money in, money out, top five spending categories and any items you need to ask about. For example: month spend £4,860.40, of which Materials £2,110.00, Travel £640.30, Software £212.10, Other £1,898.00. Check the maths before sending: 2,110.00 plus 640.30 plus 212.10 plus 1,898.00 comes to £4,860.40, which matches the month's spend. If the category lines ever come to a different figure from the total, find the gap before the summary goes out the door.

Final habits

  • One folder pattern for everybody
  • One monthly deadline for clients
  • A closing checklist you tick for every client
  • Records kept and exports archived when a client leaves

If you also track your own household spending, a personal tool such as SpendixAI can sit beside this work, but it is not meant to hold other people's books.

SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports