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.