Hi Fuchsia,

If you can export the data from the Zettle Report in a .csv / excel format then you can use the audit trail transactions import template to import a number of different transaction types into Sage 50. To locate the import templates go to C:\Program Files (x86)\Sage\Accounts\Import Templates (where C is the drive that your client for Sage is installed).

This gives you the various import templates you can use to bring information into Sage, and the format the data should be in. Once created you can import them by going to File>Import in the Sage menu options and following the wizard.

If you are not confident about setting this up please do give me a call on 01462 374073 or email [email protected]

Kind regards,

Tim

Thanks Tim - I got as far as looking at the audit trail transactions template but couldn't see a way of relating it to the Zettle report without just typing in the figures from Zettle into that sheet and then importing it. This seems pointless, as then I'm just manually typing the figures into an excel sheet to then import them, as opposed to typing them straight into Sage? I was assuming I'd need it to import directly from the Zettle report, otherwise how is it any more accurate as far as hmrc are concerned? I'm probably missing something!

you are quite right Fuchsia - you can't use copy and paste anymore either. However you can link data (for example by formulas) and upload data from one source into another;

• Upload/download or import/export of data: Transaction data can be outputted from source data digital records into a digital format like a XML or CSV file. It will then need to be imported into the calculation spreadsheet or software to form a compliant digital link.

It may be a bit convoluted to set up in the first instance, but once you've crested the initial template it would work going forward. I'd be happy to talk you through it.

Kind regards,

Tim

Thank you so much. I'll take a look at this and call you if I get stuck, which I probably will by the looks of it! Just to confirm... it's definitely not mtd compliant for me to keep inputting the weekly takings from the Zettle report? I wasn't sure if it was only if you were referencing from your own spreadsheets that there needed to be a digital link? Whereas I'm taking the data straight from Zettle...

I'm afraid not, HMRC's rules on MTD say;

'Once data has been entered into software that you use to keep and maintain your electronic account, any further transfer, recapture or modification of that data must be done using digital links. Each piece of software must be digitally linked to other pieces of software, to create the digital journey. Manually transferring data within or between software programs, products or applications (that make up functional compatible software) is not acceptable under Making Tax Digital. For example, you must not note down details from an invoice in a ledger, then use that handwritten information to manually update another part of the business functional compatible software system'.

So if you just were given an invoice from a supplier and enter than manually into your Sage software (and keep the original or an electronic copy of the document) - that's ok because this is the source data.

But from what I read of your situation you've already got the source data in Zettle electronically and need to transfer that into your Sage. Obviously check with your accountant if you want to be 100% sure. 

Luckily HMRC does say 'A digital link includes linked cells in spreadsheets, for example, if you have a formula in one sheet that mirrors the source’s value in another cell, then the cells are linked.'

It will be a bit time consuming in the first instance but worth it in the long run.

Good luck! and shout if you need help

Yes I read that, but doesn't me keying the Zettle figures from their own report (not mine) relate more to this part of the statement?

"So if you just were given an invoice from a supplier and enter than manually into your Sage software (and keep the original or an electronic copy of the document) - that's ok because this is the source data."

I know it's not an invoice as in this example, but it is the 'source data'.

Hi Fuchsia, 

I would hate to send you off on the wrong path so please do check with your Accountant before creating anything.

It all hinges on whether Zettle or Sage is the start of your digital journey, and whether, if the information (on a daily total basis) can be taken electronically out of Zettle (excel / csv), then it should be imported not input with the April rules changes.

Thanks,

Tim