I wondered if anyone knows how to treat sales information for MTD when the client uses a 'template' in Excel to raise the invoice and prints a hard copy that is sent in a pack to the accountants to be processed into Sage.
My concern is that although the sale is not being recorded in Excel in rows for book keeping purposes, the sales figure is appearing in a cell in Excel. If the client has for example 12 pages of templates (1 for each month of the year that is overwritten from the year before), per client and has 50 clients. I would worry about accuracy if the client has to click into each cell on each page to provide their sales figures for the quarter. They would normally print off the hard copies and put them in their pack together with their purchase receipts, and we would then enter these into Sage directly, for their VAT return.
On looking at Public Notice 70/22 Section 3.2 mentions a a spreadsheet is capable of recording and preserving digital records, then Section 3.2.1 'Digital Links,' mentions, it is one where a transfer or exchange of data is made or can be made electronically between software programs.
In this instance, would it be acceptable for us to continue to enter the information from the printed sales invoices manually under MTD?