Plain-English Excel how-to guides for UK businesses — VAT returns, bookkeeping, cash flow and more, written by our team.
Bank reconciliation sounds like an accountant's chore, but it is really just a careful comparison: does your record of the money match…
Read guide
A profit and loss statement, often just called a P&L, tells you whether your business made money over a period. It is…
Read guide
A simple wage calculator in Excel is one of the most useful tools a small employer can build. It turns hours and…
Read guide
Once you can add up only the rows that meet a condition, your bookkeeping spreadsheet stops being a list and starts being…
Read guide
If you use your own car for work, HMRC lets you claim a set amount per mile to cover fuel and wear.…
Read guide
Chasing late payment is the least enjoyable part of running a business, and the easiest to forget. Conditional formatting fixes that by…
Read guide
Profit is an opinion, but cash is a fact. Plenty of healthy UK businesses get into trouble not because they are unprofitable,…
Read guide
If you keep your bookkeeping in a long list of transactions, a pivot table is the fastest way to make sense of…
Read guide
VLOOKUP is the function that finally makes a spreadsheet feel powerful. Once you can pull a price, a VAT code or a…
Read guide