Spreadsheet preparing for VAT scheme return preparation

We have clients that we prepare bookkeeping using Quickbooks but quarterly VAT returns are submitted using the Travel Agents Margin SCheme (TOMS).

We are looking to prepare a set of linked spreadsheet pages so that we can enter/import

1) Sales Transactions (Date, Invoice amount - net gross and standard VAT)
2) Purchase transactions (as above)

We then need a page showing all workings translating this data to being TOMS compliant (if necessary that we could submit direct to HMRC in the event of a query)

Finally we need a page showing the totals to be submitted to HMRC compliant with making tax digital