Skip to main content
CCH Software User Documentation

Making Tax Digital for VAT: Guide for Clients

Product Help Banner.png

 

This quick start guide documents how to work with Making Tax Digital for VAT within CCH OneClick.

Introduction and Prerequisites

Making Tax Digital for VAT introduces the requirement for VAT registered businesses with taxable turnover above the VAT registration threshold to keep records in digital form and file their VAT returns via compatible software.

Our priority is to support Advisors, and their Clients, by delivering a VAT filing solution that allows you to maintain your current VAT processes as closely as possible. You may have significant legacy calculations and formulas within spreadsheets today that makes the recurring task of completing your VAT return more efficient.

This quick start guide documents how to work with Making Tax Digital for VAT within CCH OneClick.

Note: you need to have signed up/subscribed to MTD for VAT on HMRC’s website, otherwise you will not be able to authorise CCH OneClick with HMRC.

The authorisation with HMRC is expected to last for an 18-month period, so should not need to be repeated frequently. However, if HMRC introduce any new APIs/services, then this may require CCH OneClick to be authorised again.

Please note: once you have signed up to MTD for VAT, HMRC may take up to 72 hours to send a confirmation email.

DO NOT try to enter your VAT registration number in CCH OneClick until you have received this email, otherwise, it will fail.

Businesses that currently pay VAT by Direct Debit cannot sign up for MTD for VAT in the 7 working days leading up to, or the 5 working days after their VAT Return is due. For example, VAT return quarter-end 30th April 2019 means you have to sign up by the 18th April or wait until 9th May 2019 to sign up.

clipboard_e5877b1c15db22909e8651574a2a6ccda.png

CCH OneClick Activation

To enable you to use the VAT submission functionality within CCH OneClick, you will need to have an activated CCH OneClick account
You should have received a CCH OneClick activation email sent by your advisor from notifications@accountantspace.co.uk

  1. Click the link in the email and enter your activation ID (Your advisor will have informed you of this, or you will have received a text message when your account was activated)
  2. Create a new password
  3. Select two security questions
  4. Log into the client workspace using your email address and new password

Your workspace will show Making Tax Digital for VAT, Messages & Documents and/or the Digital Data Request App tiles depending on the access given to you by your advisor.
clipboard_ef50448e3040083319af631bae1505734.png

Authorise CCH OneClick with HMRC

1. CCH OneClick must be authorised with HMRC
2. Click on the VAT Returns tile
clipboard_e2f728e5fb4e0d3b3427df7711572dcf2.png

3. Click on 'Authorise'
clipboard_e9bf9686b35d862f066bf21cc209fa04e.png
3. The page is redirected to the HMRC website
3. Click on 'Continue'
clipboard_e45b1e95d9ef9c6ae81c5e4414300d999.png
4. Enter your HMRC user ID and Password
clipboard_e63bbe4962ed4de9d55a950d5a1a8cf5e.png
5. Click on 'Sign in'
6. Click on 'Grant authority'
clipboard_e0f35bfff8db8a24ecfd95f45d52527dc.png

Note: your credentials used to sign into HMRC’s page, in order to grant authority for CCH OneClick with HMRC must be your government gateway ID that HMRC require all businesses to create. These will be used to use all the API-based services that HMRC provide. The authorisation with HMRC is expected to last for an 18-month period, so should not need to be repeated frequently.

Confirmation email

8. Once you have signed up to MTD for VAT, HMRC may take up to 72 hours to send a confirmation email. DO NOT try to enter your VAT registration number until you have received this email otherwise it will fail
9. Once you have received the confirmation email from HMRC, it’s now time to enter your VAT number by clicking on 'Add VAT number'
clipboard_e7ea7ba366ac302ed01f5c30c6b88a374.png

10. Add your VAT number
clipboard_ef72b6efe5aea2f64e83a02e8cdde331d.png
11. Validation is then applied to check that:

  • Your business has subscribed to Making Tax Digital for VAT. If not, then the error below is shown.

clipboard_e711fef3cfb048589b08ebcee6b5be88c.png

  • If the VAT Number does not contain the correct number of digits a validation message will be displayed
    clipboard_eed9ce2b92c3ad8be1dfe880ecbe50408.png

12. Click on 'Add'
clipboard_ec95504b35f105ea26e74347f10318a22.png

13. If you need to edit the VAT number click on 'Edit'
clipboard_eee02d7cecfdcdfa677603df232cc6bdc.png

14. Click on 'Save'

Authorising Multiple businesses/company’s

  1. If you are an associated contact of multiple businesses, each client workspace is accessed by clicking on your email address.
    clipboard_ebb1d35236bbcced383753bf100adf2d1.png
    Each business/company will need to be authorised with HMRC by following the process above.

Creating Digital Links

Scenario 1 (Simple)

Your current bookkeeping solution is not MTD compliant or you want to make minor changes to the VAT calculation.

  1. Export the VAT return from your bookkeeping solution into MS Excel
  2. Continue to follow the instructions Tagging the MS Excel spreadsheet

Scenario 2 (Complex)

If you have multiple spreadsheets for example, a spreadsheet containing the sales detail and one containing purchases detail, or if you encounter a problem during the upload due to the spreadsheet complexity, use this method to create digital links.

1. Open the spreadsheet for VAT_Detail
clipboard_e4219455cf24ad206953706f25272c3bc.png
2. Create a new Workbook within MS Excel for example - VAT Return
clipboard_eb8df2a8a3b07fc27d80bbc715a5746f0.png

3. In column B allocate a number from 1 to 9 against the rows as shown in the example below:
clipboard_e56b3cf60eb3fe6c8ff6b1ca8ffca312a.png

4. In row 15 column C, type = then browse to the Total VAT figure for on the VAT_Detail spreadsheet and press 'Enter'
clipboard_e38ee9a9ef5633b4aaf82cc17a060d662.png
5. In row 18 column C, type = then browse to the Total VAT figure for from VAT_Detail spreadsheet and press 'Enter'
clipboard_e62c7dda9f8c8142174896ac0bf401fee.png
6. Continue the process until all relevant values have been digitally linked

Please note: the spreadsheets can have any naming convention, and Sales and Purchase can be within the same spreadsheet on different sheets or in separate workbooks.The above is for demonstration purposes only. Please make sure all relevant values have been digitally linked. 

Tagging the Excel Spreadsheet

Before the spreadsheet can be uploaded into Making Tax Digital within CCH OneClick, tags need to be applied to boxes 1 to 9.
clipboard_e1dd97c12b8ac0dd2e153cce41f3c4e16.png

  1. We are using the Excel Name function to tag the VAT information to allow it to be imported
  2. Excel name function is used to rename a cell from C15 to a set name that will allow the software to read the data
  3. To apply the tags to the above example, Click on Cell C15
  4. Select Formulas>Name Manager>New
  5. Name = VATB1
    clipboard_ef72d53b623f0cbbdddcf4d44b51e14f0.png
  6. Repeat the process for the other 8 VAT box cells
    clipboard_efe7b537b4a389bf4248ecddda6c5e7b4.png

Submitting a Return to HMRC

  1. Click on the 'VAT Returns' tile
    clipboard_e9b8df78d345a1722757d31af877ab434.png
  2. Defaults to the 'Vat Submissions' tab
    clipboard_e3d598a5fa648efae4cd3472e495e3cac.png
  3. Click on 'ADD RETURN'
  4. Click on 'UPLOAD'
    clipboard_ee411d76f144340a63a30455b024761bd.png
  5. The date is automatically pre-populated based on the obligations issued from HMRC
  6. Click on 'UPLOAD'
  7. Browse to the location of the spreadsheet, then select open and the validation screen will appear

Please note: the obligation date in this example is for demonstration purposes only.

clipboard_e38dbcf6df690ff0c00836bb19da5e034.png

Note: Validation is then applied such as: are all the nine tags found, are any of the tags duplicated, are the tagged amounts consistent with HMRC’s requirements and do the amounts tagged pass arithmetic tests.

8. Click on 'OK'

Note: If the Validation has not passed, check the naming convention of the tags. 

clipboard_ec671d98eb62def0f600dd91daf7040e9.png
9. To delete the return, click on
clipboard_edb1dc5dcdfa3d286ebf3aa73a7ce1c42.png

Note: once the VAT return has been sent to HMRC, it cannot be deleted.

10. To send the return to HMRC, click anywhere on the row
clipboard_e5a35aac12d7bbc3a00b33f365970f1d8.png

11. Click on 'Send to HMRC'
clipboard_ec43222037625730dc3398707c251ae73.png

12. Click 'Yes' or 'NO' on the Declaration
13. If 'Yes' is selected the following message is displayed 'Data was successfully sent to HMRC'

Please Note: If 'NO' is selected then the VAT return is not submitted.

14. Export to PDF will display the following information
clipboard_e5980193f882c0966f628cc9bf1608ead.png

15. To download a copy of the spreadsheet, click on
clipboard_e98e8039b1db89dd2eddc1c587fae9668.png
16. Click on the spreadsheet to view
clipboard_eae546fa96bc1cc8a696ec0edd91a4763.png

Digital VAT Account and History Tab


1. Click on the Digital VAT Account tab to display information on liabilities returned by HMRC
clipboard_e4ff1c3cdadac6c2d7c12c22b608db8f5.png

Note: the first time you submit a VAT return, they may be a slight delay in the Digital VAT Account being updated, please check again after one hour.

To view data that is more than one year old, change the date filter.
clipboard_e481ef8c44b2188472187d7984b3d3c5a.png
clipboard_ec21a11e99b78b71d2e2f5bf65e55dbb7.png

2. The history tab will display all submissions made to HMRC.

Please note: until a VAT submission is made or a payment made for a liability under MTD for VAT, the payments and liabilities tabs will not return any data.

This is because only data relating to MTD for VAT can be shown. Meaning liabilities and payments prior to MTD for VAT cannot be shown. 

 

  • Was this article helpful?