Yep year-end is a good time for accounts. You can move payroll really at any time.
We’ve never heard of Revenue looking for Sales Day books, we generate your VAT3 return for you automatically, then you just upload the file to ROS and you’re done.
Below is what we export from invoices, you’ll see sub totals there. But that report doesn’t sound like a lot of work so if it’s requested we can add it to our road map