NeuSheet is in a free early trial. Check your spreadsheet

Keeping a spreadsheet that’s easy to check

You don’t have to change anything to use NeuSheet: upload your spreadsheet as it is. But a few habits make any set of accounts easier to check, whether it’s us reading it, your accountant, or you a year from now. None of this is about tax. It’s about records anyone can follow.

One row for each payment

Put each sale and each cost on a row of its own, rather than adding several into one figure.

A date on every row

Every transaction needs a date. Any common way of writing it is fine, but keeping to one makes the order clear: 4/5/26 could be 4 May or 5 April.

Say what it was for

A few words on each row, such as who you paid and what for, help anyone reading your records later, including you.

Amounts as numbers

Put each amount as a plain number in a column of its own, such as 64.20, rather than inside a description like “timber 64.20”. Keep money in and money out apart, in columns of their own or with costs shown as minus figures.

Let formulas do the totals

A total worked out with a formula stays right when rows change. A total typed in by hand doesn’t.

Check for repeats

If two rows have the same date, description and amount, check the payment really happened twice.

Mark personal spending in words

If personal spending is in the same sheet, say so in words, such as a column marked “personal”, rather than by colour alone. Colours don’t survive every copy or change of file, and a .csv file keeps none at all.

Keep the receipts

Keep receipts and invoices, above all for cash: with cash, they may be all there is to show for it. HMRC’s guidance on digital records says what to keep.

Journeys in a table of their own

If you log business journeys, keep them in a table of their own, with a row for each journey: the date, where from and to, why, and the distance.

Keep your own copy

We delete your spreadsheet within 6 hours, so keeping your files is up to you.Key dates says how long HMRC asks you to keep records.

Your spreadsheet doesn’t have to be perfect. If the free check can see we can’t work with it, it tells you what to fix.