We’ve come to the end of the tax year so I thought, as I had a little time spare this afternoon, that I would see if my intelligent worklist/invoicing spreadsheet would speed up the preparation of the end-of-year report I send to my accountant.
This job normally takes me a couple of days, and I have just done it in less than an hour.
I made a copy of my work schedule, then deleted those entries that fell before the start or after the end of the tax year. At the ends of the year, I checked a few figures and kept those entries where I had invoiced within the 14-15 year, or where work had taken place then, even though invoiced before or after the year. (I have some clients who buy a block of training lessons, so it is quite common that an invoice will cover work spanning a period of several months.)
Having decided which records I needed, I refreshed my various pivot table reports, including my breakdowns of expenses and mileage claims, then filtered these so that only then entries within the tax year were included.
I copied all the relevant invoices into the same folder, and edited the hyperlinks in my invoice summary to point to these in their new location. So the accountant will have all my invoices as well.
I copied my main data table to its own location, replacing formulae with values, so that I was able to delete my lookup tables sheet.
Finally, I stripped out the code that I use to generate my invoices, and saved the workbook as a macro-free .xlsx file.
Job done!
