What format should I save the Excel spreadsheet? Magic Tax supports older versions of Microsoft Excel too! You should save your Excel spreadsheet in .xlsx (Microsoft Excel 2007 or newer) or .xls format (Microsoft Excel 97-2003). Be sure to download the template file type to match the version of Microsoft Excel you are using. You should not rename the sheet or the headers, or add any additional information in Line 1. Simply copy and paste the data into the spreadsheet and save locally ready for use in Magic Tax.
Will the Excel spreadsheet work with my Mac? Yes. Just save the spreadsheet in .xls or .xlsx format (depending on which version of Excel you are using).
Show more/less
What support is offered if I have a technical problem in the future? Should you encounter a technical issue, KFA Connect offers a support portal, which can be accessed here or in the ‘Support’ link in the bottom footer of this page. Simply register for the support service and our team will be able to help you.
I’m getting an error message that says: ‘You are not authorised to use this VRN’? The most likely explanation for this is that you have not completed the sign-up process with HMRC. You must sign-up for Making Tax Digital with HMRC (and wait for the email confirmation from them), which can take up to 72 hours to come back before you can add a company to Magic Tax.
I have signed up for Making Tax Digital with HMRC, but I am still getting a message saying “You are not authorised to use this VRN”? You should check that you are authorised with HMRC to make submissions for the company – you can check this with HMRC and that you have not de-authorised Magic Tax with HMRC. If this is the case, you must re-authorise Magic Tax to interact with HMRC before you will be able to add a company.
Do I need to wait for confirmation from HMRC that we signed up for MTD before adding my Company details? Yes. You should wait until you have confirmation from HMRC of your sign-up to Making Tax Digital BEFORE you trying to add a company or submit a VAT return using Magic Tax. HMRC can take up to 72 hours to confirm your sign-up.
I’m a ‘Limited Cost Trader’, can I still use Magic Tax? Yes! When adding your company, select ‘Normal’ as your VAT rate. You will need to use the ‘Standard Box Format’ template to submit your 9 figures. Since Magic Tax just sends the information to HMRC in this template and does not manipulate the figures at all, the figures you submit are the figures we will send… simple!
Can more than one user submit on behalf of a company? Yes, as long as they are registered with HMRC and have a Government Gateway User ID and Password to allow them to make submissions for that company – they will be able to add the company to their dashboard within Magic Tax.
Do I need to register again to submit on behalf of another company? Each Government Gateway account will require a separate Magic Tax account although you cannot register for a second Magic Tax account using the same email address, each registration will require a unique email address.
I having trouble registering or logging into Magic Tax or have invalidated my user ID? Check you are not already registered with Magic Tax, as you cannot use the same email twice. The password is case sensitive. If you have forgotten your user ID or password, get in touch with us here
When uploading my spreadsheet I have an ‘Error’ message? You should check that you have not entered any additional text/data in line 1 of your spreadsheet and that you do not re-name the columns or add any new columns. The information being uploaded into Magic Tax needs to be on Sheet 1 of your excel document and there should not be any other sheets. Do not rename the sheet and do not include any references to other spreadsheets or reference any other worksheets using formulas. Just copy and paste (values only) into sheet 1 of your document.
K Bahra
Eileen Norton
