Business finance spreadsheets
Find out whether trading is actually profitable and keep the petty cash tin in order, with spreadsheets that use pounds, UK dates and A4 paper.
These spreadsheets are for sole traders, small limited companies and shop owners who want their own view of the figures between meetings with the accountant. The profit and loss account sets out turnover, cost of sales, overheads and net profit month by month in familiar UK terms, with a year-to-date column and a summary of gross and net margin.
The petty cash book runs on the imprest system: each voucher goes against an analysis category, the balance updates as you go, and the cash count tells you how much to draw from the bank to bring the float back up.
Every file uses £, dd/mm/yyyy dates and A4 paper, and opens in Excel, Excel for Mac, Google Sheets and LibreOffice. No macros, no add-ins, no account. Download the .xlsx or make a copy in Google Sheets.