Vat Return figures are different and do not match Dimensions

Changes have been made in Dimensions since the last time the VAT Data was refreshed in Access Digital Tax. Please try Refresh within Access Digital Tax.

The VAT reporting method set in the Dimensions System control options may cause the variation. A different date or period range is being used within Dimensions to the date range sent by HMRC. If Dimensions set to calculate VAT by dates, please check that the dates being entered within Dimensions match those requested by HMRC. Access Digital Tax will always use the correct dates. If Dimensions is set to calculate VAT by periods, please check that the Periods in Dimensions match the setup on your HMRC VAT Account and you have entered the correct period range in Dimensions. The help for the VAT Reporting Method should be followed - if your accounting periods do not end on the last day of the month, the field should be set as date, this will have the effect of the VAT report screens showing date rather than period ranges.

The data you are viewing in Dimensions is for different legal entities (VAT Groups and Sub Ledgers), to those selected in Access Digital Tax.

ADT periods is a date range & will pickup transactions based on invoiced date which is the tax date not the period it was posted, when tax is submitted these are marked within the Dimensions database, any transactions posted after submission but within the submitted period will be picked up on the next submission.

The last updated VAT return in Dimensions may not mirror what was last submitted to HMRC.

An older version of Access Connect may be being used which were identified to have a bug in reading the VAT return data. If so, Access Connect may need to be updated.

Check and make sure that ADT has updated Dimensions on the last submission to close that period off in Dimensions, as when ADT updates Dimensions it gives the VAT return a particular reference which is ADT followed by a date (ADT-191022) if during the last submission this did not get written back into Dimensions ADT will not pick up that period as closed in Dims so may pull through the current months figures and the ones for the previous month as well.

Ensure that the VAT return preview ran in Dimensions is for the same obligation dates/periods as required in Digital Tax for submission to HMRC?

In Dimensions, is the last updated VAT return showing correctly as the last submission that was sent to HMRC? If not, please ensure the last submission to HMRC matches the ASC VAT Return preview for that obligation. Confirming this, if required, appropriately update the VAT return in Dimensions so the last updated VAT return states the same as what had been last submitted to HMRC.

If VAT is being reported by periods in Dimensions, ensure that the Dates of the Periods are correctly in line to reflect whole months.

ADT will report by the Obligation date ranges which are set by HMRC, and will pull out transactions based on their invoice date, regardless of which period it has been posted into. For example, a transaction dated for October could be posted into the period for August, and so would be picked up in the VAT return covering October, if the transaction was not marked on a previous return.

Ensure that transactions are coinciding with the appropriate period number for its date, as a transaction can be picked up on an earlier return, or picked up in a later return, depending on it's date and period posted to.

If you Dimensions database is configured to more than 2 decimal places, then the VAT figures in Access Digital Tax maybe slightly different by pennies to the figures in Dimensions. In this scenario you will need to post a journal to make up the difference between both systems.