BPM Country Reports

UK Tax Submissions

This section describes the fields and actions on the UK Tax Submissions workspace, as well as instructions on how to generate the report.

Quick Links: Selection Criteria | Generate Report | Report Fields | Limitations | Admin Setup | Appendix

Overview

The UK Making Tax Digital (MTD) Tax Submissions data export lets you automatically submit tax data following the MTD requirements in the United Kingdom (UK). This WebI report makes it possible to report on the history of these submissions and to offer transparency concerning the data that is behind the submitted figures.

The Tax Submissions WebI report provides an overview of the submissions completed using the UK Tax Submissions data export in Maconomy. It shows the figures and entries included in the submitted data.

Report Workspace

Navigation

To open the report workspace, select Reporting » Country Reports » UK » UK Tax Submissions.

Or, go to Reporting » BI Launch Pad and click Open BI Launch Pad. The report is located on the Business Performance Management » Reporting » UK folder.

Selection Criteria

Prompt Title Expression Mandatory
Company Tax No. Only include tax submissions and tax entries for which the company has the tax number(s) answered in the prompt. Yes
Tax Reporting Unit Name Only include tax submissions and tax entries for which the tax reporting unit name is the answered name(s) of the prompt. Yes
Company No. Only include tax submissions and tax entries for which the company has the number(s) answered in the prompt. No
From Year-Month (YYYY-MM) Only include tax submissions having a submission date equal to or after the answered Year-Month.

Only include tax entries belonging to a settlement starting with the answered Year-Month.

No
To Year-Month (YYYY-MM) Only include tax submissions having a submission date equal to or before the answered Year-Month.

Only include tax entries belonging to a settlement ending with the answered Year-Month.

No
From Entry Date Only include tax entries with an entry date equal to or later than the answered Entry Date of the prompt.
Note: This prompt does not influence the filtering of tax submissions shown in the Tax Submissions tab.
No
To Entry Date Only include tax entries with an entry date equal to or before the answered Entry Date of the prompt.
Note: This prompt does not influence the filtering of tax submissions shown in the Tax Submissions tab.
No

Generate the Report

Export the Report

To generate the report:

  1. Go to Reporting » Country Reports » UK » UK Tax Submissions.
  2. Enter the selection criteria for running the report.
  3. Click Run. The screen refreshes and displays the generated report.

    To keep a copy, click the Download icon. In the dialog box, specify the parameters for the export file (file type, reports and options), then click Export.

Submit the Report

Not applicable for this report.

Report Description

Export Fields and Descriptions

The report consists of two tabs:

  • Submission History: Lists the submissions that meet the selection criteria.
  • Tax Details: Lists the individual entries behind the submitted figures.

The information on each tab is grouped by:

  • Reporting Unit (Reporting Unit Name)
  • Company (Number and Name)

Submission History Tab

The Submission History tab contains a table of submissions, listed by Submission Date, in descending order.

Top-Level Header Header Title (Maconomy Name) Description Corresponding Tax Table Field
Date Submitted The date the submission was completed.

The table rows are ordered date in descending order

Tax Payable (Tax Due Sales) The tax amount of tax payable. This corresponds to the tax submission's Box 1. Box 1
EU Acquisition (Tax Due Acquisitions) The tax amount of EU Acquisition. This corresponds to the tax submission's Box 2, intra-community acquisitions of goods made in Northern Ireland from EU member states Box 2
Total Tax Due The sum of Tax Payable and EU Acquisition. Box 3
Tax Receivable (Tax Reclaimed) The sum of the tax receivable. Box 4
Net Tax Due The difference between the Total Tax Due and the Tax Receivable (Total Tax Due - Tax Receivable). Box 5
Tax Basis, Payable (Value of Sales, Ex. Tax) The tax basis amount for tax payable. Box 6
Tax Basis, Receivable (Value of Purchases, Ex. Tax) The tax basis amount for tax receivable. Box 7
Tax Basis of Goods, Foreign Customers (Value of Goods Supplied, Ex. Tax) The tax basis amount for tax payable, for which customers have a tax number and are non-UK EU customers from Northern Ireland companies, and where the tax amount relates to a Goods transaction.

The latter is defined by whether the Tax Popup 1 of the tax entry, is true (this is derived historically from the tax code).

UK companies having transactions under the Northern Ireland Protocols can also define the tax code Country to Northern Ireland.

Box 8
Tax Basis of Goods, Foreign Vendors (Value of Acquisitions, Ex. Tax) The tax basis amount for the tax receivable, for which vendors have a tax number and are non-UK EU vendors to Northern Ireland companies, and where the tax amount relates to a Goods transaction.

The latter is defined by whether the Tax Popup 1 of the tax entry, is true (this is derived historically from the tax code).

UK companies having transactions under the Northern Ireland Protocols can also define the tax code Country to Northern Ireland.

Box 9
Finalized States whether the submission was finalized.

Tax Details Tab

The Tax Details tab consists of three tables that include the tax entries that made up the submissions for each of the three tax settlement types: Tax Payable, EU Acquisitions, and Tax Receivable.

Things to consider:

  • If additional tax entries were created after a submission, and within the selection criteria of the report, these entries are included in the report, as well. Hence, the entries may not always sum up to the values stated on the submissions.
  • Some columns include a second header that states the name of the UK Tax Submission field, similar to the Submission History tab. However, if tax entries were posted into the same period, after submission, the Tax Details tab will show that entry, but the entry will not be included in the summation on the Submission History tab.
  • If additional tax entries were posted without corresponding tax submissions, the Tax Details tab may include more entries than what is stated in the tax submissions, on the Tax Submission History tab.
Top-Level Header Header Title Description
Customer No. The number of the customer associated Tax Payable entries.
Name The name of customers, respectively.
Country The country to which customers belong, respectively.
Invoice No. The number of the invoice created.
Invoice Date The date to which the invoice is created.
Vendor No. The number of the vendor associated Tax EU Acquisition and Tax Receivable entries.
Name The name of vendors, respectively.
Country The country to which the vendors belong, respectively.
Invoice No. The number of the invoice created.
Invoice Date The date to which the invoice is created.
Transaction No. The transaction number of the tax entry.
Journal No. The journal number of the tax entry.
Tax Code The name of the tax code on the tax entry.
Rate The rate of the tax code on the tax entry.
Type The type of the tax code on the tax entry.
Date The tax date on the tax entry.
Tax Code The name of the tax code on the tax entry.
Tax Rate The rate of the tax code on the tax entry.
Tax Type The type of the tax code on the tax entry.
Tax Date The tax date on the tax entry.
Entry Date The entry date on the tax entry.
Tax Basis (Value of Sales, Ex. Tax) (Value of Purchases, Ex. Tax) The basis amount of the tax entry.
Tax Amount (Tax Due Sales) (Tax Reclaimed) (Tax Due Acquisitions) Tax amount of the tax entry.

The tax amount of EU Acquisition.

This corresponds to the tax submission's Box 2, intra-community acquisitions of goods made in Northern Ireland from EU member states.

Total The total amount of sales plus taxes.
Tax Basis Goods, Foreign EU Customers

Tax Basis Goods, Foreign EU Vendors

(Value of Goods Supplied, Ex. Tax) (Acquisitions, Ex. Tax) The basis amount for tax payable related to customers that have a tax number, are settled in an EU country different from the Northern Ireland company's country, and for which the tax code states that it is a goods transaction. UK companies having transactions under the Northern Ireland Protocols can also define the tax code Country to Northern Ireland.

The basis amount for tax receivable related to vendors that have a tax number, are settled in an EU country different from the Northern Ireland company's country, and for which the tax code states that it is a goods transaction. UK companies having transactions under the Northern Ireland Protocols can also define the tax code Country to Northern Ireland.

Limitations

None reported.

Admin Setup

Maconomy Setup

Not applicable for this report.

External Setup

Not applicable for this report.