I produced the attached sheet in answer to this query on Mumsnet. This is a skeleton solution with not much by way of formatting or layout and doesn't have the usual amount of documentation or instructions, but if you are reasonably confident in Excel you should be able to use it to generate a summary which links in to any number of workbooks which have the same layout as each other.

If you have come here from this thread on mumsnet, then you are in a loop!

The image is no longer available here.

This spreadsheet was created in response to a thread on Mumsnet. Feel free to download it by clicking on the filename "SalesInvoiceRegister.xls" below. You may use it as you wish, subject to the notice shown under "IMPORTANT INFORMATION" in the spreadsheet.

If you find this spreadsheet useful (or not!) please leave a comment on this page. Your comment will not appear immediately unless you are logged in to this site.