I have just had a conversation with Sage and wanted to know if anyone can shed any light on the process of importing information from Excel into bespoke software such as Sage.
I have a template from Sage which has the headings required for import. A client has a workbook with 12 tabs, each tab holds a monthly invoices where the net, and VAT totals are, by way of example, in cells F30 and F31 on each page.
My understanding is that with the clients workbook open, I will have to go into the Sage Excel template and under the 'Net Amount' heading select the formula '=F30' of the clients workbook page and under the heading Tax Amount select '=F31' as I have taken MTD to mean once a human has inputted the information into Excel, another human cannot simply type those numbers into anything else and has to bring them in using formulae.
Sage says, I am to manually type the figures into the Sage template from the invoices raised in the clients workbook, in order to import the excel information into Sage. Maybe I am taking things too far, but is Sage not asking me to manually re-type something in their sheet, that has already been typed into Excel by a human, which I have understood to mean that I can't under MTD.
Any clarification would be much appreciated.