Viewing and amending VAT obligation calculations (MTD)
Use the MTD Obligations and Returns form to calculate and verify the amounts to be included in each of boxes on the VAT Return form for the specified time range.
- Open the MTD Obligations and Returns form.
If a different site is used to consolidate MTD information from the current site, this form is disabled at the current site. See Setting up MTD when multiple sites have the same VAT ID (VRN).
- Specify the date range for the obligation.
- This information about the obligation is displayed in the header:
- Due Date
- This field displays the deadline for fulfillment of the obligation.
- Received Date
- This field displays the date when final payment of the obligation has been posted and no balance remains.
- Status
- This field displays the status of the obligation: Fulfilled (paid in full) or Open.
- In the Returns tab, specify the Tax System and Tax Jurisdiction on which the calculations will be based.
- Click Calculate to calculate and display this information, to be used in the VAT Return:
Field Calculation Sales VAT due Include sales and sales tax amounts from the VAT Report and Sales VAT Register Report Acquisitions VAT due Include tax amounts where the associated tax code has MTD EU Acquisition selected and VAT Amount Boxes set to 2. Total VAT due Sum of Sales VAT due and Acquisition VAT due. Reclaimed VAT due Include purchase and purchase tax amounts from the VAT Report and Purchase VAT Register Report. Net VAT due Total VAT due minus Reclaimed VAT due Total sales value excluding VAT Sales VAT due minus all sales tax Total purchases values excluding VAT Reclaimed VAT due minus all purchase tax Total goods supplied value excluding VAT Include tax amounts where the associated tax code has MTD EU Acquisition selected and Tax Basis Boxes set to 8. Total acquisitions excluding VAT Include tax amounts where the associated tax code has MTD EU Acquisition selected and Tax Basis Boxes set to 9. Note: These calculations exclude any General Ledger journals that include tax code values. - Verify the calculated amounts. To compare them to the matching transactions:
-
Click View Transactions.
The MTD Transactions form is displayed.
- You can filter the transactions based on these fields. Click Refresh to update the list of transactions.
- VAT Return Box
- Select a box number (1- 9) to view all the transactions that were included in the calculation of the amount in that box.
- Tax System
- Select a tax system to further filter the transactions. This value defaults to Tax System 1.
- Tax Jurisdiction
- Optionally, select a jurisdiction to further filter the transactions.
- Site
- Select a site here, to view only the transactions generated by that site. This can be helpful if you consolidate transactions from multiple sites.
Note: You can export the transaction information in the grid to Excel, if you want to save the transaction data for later viewing. - When you finish comparing the transaction amounts to the calculated amounts, close the form and return to the MTD Obligations and Returns form.
-
Click View Transactions.
- If you need to amend any of the calculated amounts:
- Click Enter Adjustments.
The MTD Adjustments form is displayed.Note: MTD adjustment records are permanent records which form part of the required digital record keeping. If an adjustment also requires an update to the General Ledger balances, you must additionally process a separate GL journal, which will not include any tax code.
- Use the grid in this form to enter adjustments to the calculated values for the VAT Return boxes.
Specify this information:
- Obligation Start / Obligation End
- These fields show the start and end date of the obligation period. If you opened this form from the MTD Obligations and Returns form, the dates are defaulted from that form.
- Box Number
- Specify the VAT Return box number that must be adjusted. If an adjustment can be made to 2 or more boxes, use different rows
for each box. You can also add multiple rows for one box number.
For every box calculation that you want to adjust, you must create a row in the MTD Adjustments form and specify the box to be adjusted.
- Amount
- Specify the amount of this adjustment.
- Adjustment Date
- Specify the date of the adjustment. This defaults to the current date.
- Notes
- Enter notes to explain this adjustment.
- Status
- This field displays a Pending status until the VAT Return is submitted. At that time, the status changes to Submitted.
- When you save your changes and close the form, the adjustments for each VAT Return box are summed and displayed in the appropriate Adjustment field in the MTD Obligations and Returns.
- Click Enter Adjustments.
- The Final Amounts fields display the sum of the Calculated Amounts plus any Adjustments for each VAT Return box.
- When you have ensured that the amounts are correct for this obligation, you can submit your VAT Return.
Related topics