2024.10 | 4 October 2024
KEY RELEASE HIGHLIGHTS
This key release highlights solutions to our customers' relevant business challenges and ensures an improved user experience on the ONESOURCE Indirect Tax platform.
Business challenge | How OIC can help | Product updates in this release |
|---|---|---|
Tax departments with numerous obligations and tight deadlines need to manage processes efficiently. Manually compiling data needed for certain boxes / sections of returns & submissions, that require non-transactional data to be entered, and entering that data manually, can be time consuming and repetitive. | Providing a framework that allows users to easily bulk load data into the application, to populate sheets and sections with relevant data for reporting purposes. This data can be loaded to the correct sections of returns, from CSV templates that have been generated containing the appropriate non transactional / statistical / pre-calculated data. | Advanced Import |
Global businesses can realize process efficiencies through standardization. | TR can provide a single solution to cover a vast array of global filings across many jurisdictions, allowing businesses to focus on managing a single relationship with a single provider and implement common processes across their teams. | Iceland VAT return |
Submitting returns and filings on time in the correct format is crucial to avoid penalties and minimize audit risks. | Supporting Efiling across the jurisdictions and forms covered by the OIC content, to allow for more efficent processes and process tracking of filings. | Azores and Madeira Efiling |
Legislative updates
Thomson Reuters' content team are constantly monitoring changes in indirect tax legislation to ensure the latest requirements from the jurisdictions covered are supported in our content.
Portugal-Madeira
- the super reduced VAT rate for Madeira has been lowered from 5% to 4%. The change is valid from 1st of October 2024. The updated rates have been added to all Madeira tax codes supporting the super reduced rate.Spain VAT return - updates to forms 303 and 322 in order to accommodate legislative changes recently published by tax authorities and to be able to efile successfully. Update covers among others:
- Addition of boxes 166 (form 303) and 172&166 (form 322) to report transactions under the new 2% rate – both boxes are manual entry
- Update of existing boxes 154 (from 303) and 163&154 (form 322) related to reporting of transactions with super reduced rate increased from 5% to 7.5%
- Additional boxes added and rate updated on recargo equivalencia scenario – boxes 169&17 (from 303) and 169&34 (from 322)
VAT return/listings:
Australia GAT:
We did not file the GST Calculation section and do not need to pull it into the AU GAT return; therefore, we removed it. Now, this sheet only contains the boxes submitted as part of BAS.
Czechia VAT return PDF form
:
- The box including the VAT registration number in the VAT return pdf form has been resized to ensure the value fits within the designated space without extending beyond the box.
- A change has been introduced to how the full name of taxpayer’s Main Economic Activity is displayed. Previously, OIC displayed it a six digits NACE code instead of description which is necessary for XML format purposes. The form now displays the value as text/description.
Czechia Control Statement:
- Amended the formula for reporting transactions in sections B3 and A5 of the Czechian VAT Control Statement. Previously, invoices with a gross value exactly equal to 10,000 CZK, which should be reported in A3 or B5, were excluded from the statement. After the fix, transactions valued at 10,000 CZK that meet the conditions for B3/A5 will now flow to these sections.
- Updated the reporting of transactions with natural persons (B2C). Transactions with customers who do not have a domestic VAT Registration Number should flow to section A.5, regardless of the threshold, if Customer&SupplierJurisdictionID equals CZ and the CustomerVATregistration field is not populated.
Czechia Company information sheet
: An enhancement to link fields between returns and the main Company Information sheet to avoid inserting duplicating information across VCL, ESL and VAT returns.Germany VAT return
:
- An error was added to the Company information sheet to highlight a mismatch between Federal state and Tax office code if such occurs to ensure the user selects the correct combination.
- A validation error has been added for the VAT registration number, as this field is now used in ESL XML filing. The expected value is the domestic VAT identification number of the reporting party, consisting of the country code 'DE' followed by exactly 9 digits.
Japan VAT return pdf form:
- Enabled Japanese Imperial dates in date boxes on forms. This applies to PDF forms (Form 3-1, Form 3-2), requiring dates to be provided in the Japanese Imperial format instead of the Gregorian calendar.
- Resized several boxes to ensure numbers are displayed with appropriate spacing within the box.
Portugal
:
- Boxes 65 and 68 in Portugal main return will now be automated based on the existing values in boxes 63&64 in the Azores and Madeira returns which are now part of the Portugal VAT return. Previously these boxes were manual entry.
- Box Number report - An inconsistency has been fixed in the tax codes metadata to ensure net amounts of credit notes are correctly captured in the analytics reports. There is no impact on box mappings in the return summary.
Romania form 394
- Form 394 section D (purchases with non registered counterparties) logic has been enhanced so tax code "DOMPURSRV_E" will now be flowing to the section. To achieve this, it is key that the field SupplierVATNumber is not populated and the field SupplierTaxID should be populated, as this covers exempt purchase transactions with non registered counterparties.
- Update to 394 form so any transactions with counterparties with GB VAT Number will be flowing to F section rather than E section.
Spain
:
- VAT return pdf form – updated Sheet V5 Page 6 of the pdf VAT form 303 in the Spanish return to ensure all boxes can be populated either by manual entry or via formulas picking up data from the Return Summary Analysis.
- VAT return form 322 – the form is used for reporting of groups of companies and now the form has been added to the group template Return Summary therefore it is possible to create returns for the group structure (child entities and the group head), previously it was only supported in the single template for the group representative.
UAE VAT return
: Updated incorrect formulas related to the tick box acknowledging a user has reviewed inconsistency in tax rates, previously the error persisted even after ticking the box.Enhancement to the Other Adjustment Report to include an Other Adjustments (S3) sheet
: This sheet supports manual adjustment boxes and manual return boxes on the Return Summary Analysis sheet, allowing users to import and report multiple adjustments for each of these boxes on the return. This enhancement is released for the following jurisdictions: Austria, Croatia, Czechia, Estonia, Finland, and Netherlands.Tax codes
Germany
: New tax codes have been added to enable reporting in the territory of Jungholz & Mittelberg under the standard VAT rate of 19%. The tax codes 'Intra-community acquisition of goods' and 'Domestic supply of goods/services' will automate reporting for boxes 037 and 088 in both Periodic and Annual returns.
Greece
:
- New tax codes added to support reporting of transactions related to supplies to the Aegian Islands, previously the boxes in the return required manual entry.
- Domestic Supply of Goods to Aegean Islands (AR_DOMSPLYGDSAEI)
France
:
- New tax code added to allow reporting of imports from Overseas Departments under an 8.5% rate in Box I3 of the VAT return, previously this box was manual entry:
- Import VAT goods (with deferral) - AP_IMPGDSDEFREV.
- New tax code to allow reporting of Domestic purchases with author rights under the reverse charge mechanism:
- Domestic purchase with author rights (AP_RCPURAUTH).
Ireland
:
- New tax codes to allow reporting domestic purchases with Partially Recoverable input VAT amounts under all tax rates in this jurisdiction:
- Domestic purchase of goods - partially recoverable (AP_DOMPURGDSX)
- Domestic purchase of services - partially recoverable (AP_DOMPURSRVX)
- Domestic purchase of trading goods - partially recoverable (AP_DOMPURGDSTRDX)
Romania
:
- New tax code to cover a scenario previously not available that allows reporting of intracommunity acquisitions reported in box 5 when the recipient is the last party in the triangulation (Party C):
- Simplified triangulation: acquisition of goods by party C (AP_TRIACQC)
UAE
:
- Additional tax codes to allow reporting of transactions under reverse charge mechanism with Input and Output VAT amount being in different periods:
- Reverse Charge Input -only (AP_RCINP)
- Reverse Charge general case Output -only AP_RCGENOUT
- AP_RCGDSIMPOUT
Reporting of call off stock transactions:
- New tax codes added with an exempt rate to be included in ESL but excluded form VAT return reporting. Additional sheets in the listing section were added as well if required. The reporting has been enabled for the following jurisdictions: Belgium, Italy, Germany, Netherlands, Spain.
- Consignment Stock - Fill Up (AR_CONSSTOCKFUP_E)
E-filing and coverage expansion
Portugal VAT efiling
: Anex R has been added to the Portugal VAT return filing for reporting transactions related to Azores and Madeira which have been included in the Portugal jurisdiction as of the September release.Czechia VAT Return XML schema
: The e-filing has been enhanced to support submitting forms on quarterly basis along with already supported monthly frequency of submissions.SAF-T digital tax reporting
Norway
: The new SAF-T Financial schema v.1.30 for Norway comes into force for the first period with financial reporting starting on January 1, 2025, or later. Until then, the use of SAF-T schema v.1.30 will be voluntary. The changes aim to enhance flexibility and comply with Norwegian bookkeeping regulations:
- Four elements and one structure, already intended to be mandatory according to the documentation, have now changed from optional to mandatory in the XSD schema.
- Datatypes have been modified to accommodate more characters based on reported needs.
- The choice of mapping to the Standard Chart of Accounts has been removed. The only valid mapping option now is mapping to the business statement using the elements <GroupingCategory> and <GroupingCode>.
- A new structure for Customers and Suppliers in Masterfiles has been introduced to enhance flexibility in choosing more than one balance account.
- To approach a more standard format, three new elements have been added to GeneralLedgerEntries: VoucherNumber, VoucherDescription, and ModificationDate.
Accelerated customer content
We are pleased to announce that we have increased the coverage of our Accelerated Customer Content based on customer demands, with the addition of:
- Iceland VAT Return
If you are interested in implementing a new return or jurisdiction, please contact a member of the ONESOURCE team.
Resolved issues on data transfers
: The previously reported issue with data synchronization from the child return to the group return has been resolved. Our analysis revealed that the initial data upload from the child return to the group was successful, but discrepancies arose during subsequent data imports to the child return. The logic has now been updated, resolving the issue.Returns
Improvements to CZ Control Statements - Total Invoice ID Display Logic
: Enhanced the workbook logic for CZ statements to display values in the TotalInvoice ID based on the following:
- For AP transactions: The display logic is now based on the combination of InvoiceID and SupplierVATNumber, regardless of the presence of CustomerVATNumber.
- For AR transactions: The display logic is now based on the combination of InvoiceID and CustomerVATNumber, regardless of the presence of SupplierVATNumber.
CZ roll forward
: An update has been rolled out to ensure that the latest CZ template (Jurisdiction: Czechia, Template Version: CZ VAT Template) is selected during the auto roll-forward process. Using the latest template ensures customers have access to the most current library of tax codes and rates, as well as updated forms. It also allows customers to benefit from enhancements and features delivered by the team, such as e-filing, listings, and markups to drive automation and reporting.Advanced import process
We are excited to introduce a new way of loading data to ONESOURCE Indirect Compliance - “Advanced Import”. This is a new feature designed to facilitate the import of data that doesn’t fit the typical content model (which is designed to handle the import of transactional data with a net and tax amount). Advanced import can be used to map data contained within a CSV file directly to supported sheets on a return.
This initial release will support import to the Revenue and Expense sheets of the Australian GST Analytical Template (GAT). However, there is scope for this feature to be expanded to support population of additional forms and templates. This opens up opportunities to populate cells, sections, sheets and forms using a simplified (and in future, fully automated) process.
If you are interested in learning more about the advanced import capabilities, or the AU GAT, please contact customer support or your TR contact.
API
Simplified API Access for Multiple Clients:
Previously, customers using ONESOURCE Client Manager needed to add a 'Scope' variable in their APIs when working with the ONESOURCE Indirect Compliance application. The process has now been enhanced for greater ease of use. API access has been streamlined for those with ONESOURCE Client Manager enabled. The 'scopes' variable in the Token generation endpoint, where the Client ID or Client Name was specified, is no longer required. Instead, client information can be provided using the following header at individual endpoints: X-ONESOURCE-Client-Id:{{ClientID}}. This update is intended to make API management more straightforward and efficient.note
Customers can now use a single token for all clients, simplifying the process and reducing administrative overhead.
Imports
Enhanced Processing Speed for PROMOTE Step in Import Workflow:
To enhance the efficiency of the Import process, the Promote step (the final stage of import where data transitions from the Validating state to the Promote Successful state, before being pushed into respective returns) has been optimized. Multi-threading has been implemented, allowing the operation to run in parallel. Extensive testing with datasets of up to 1 million transactions has demonstrated a substantial median reduction in processing time during the Promote phase of the import process. The exact percentage improvement will be provided once the metrics are fully captured. Enhanced Workpapers Integration with New Excel Add-In:
In this release, an enhancement has been made to the integration between Workpapers and OIC application, allowing users to seamlessly push data from Excel to the system using an improved Excel add-in developed by the Workpaper Integration team. The current add-in version v8.0.24.0 available in production will be upgraded to the new add-in version v2024.4.51.0.This new add-in requires specific updates within OIC to function correctly. These updates have been implemented to ensure a smooth transition for customers upgrading to the new add-in, with no interruption to their workflow. Additionally, customers who choose not to upgrade immediately will continue to experience uninterrupted service, ensuring a seamless experience for all users regardless of their version choice.
Resolution for Bulk Edit Issue in Transactional VAT Number Validation Report:
This update enhances functionality by enabling users to edit the transactional fields of multiple transactions in a single attempt, facilitating bulk edits directly from the Transactional VAT Number Validation Report. Consistent with edits performed from Active Transactions in Import Details, users can now edit up to 50,000 transactions at once.Reports
Performance Improvement-Transaction Details Report
: As part of our continuous efforts to enhance report performance, we have improved the generation time of the Transaction Details Report. For a volume of 1 million transactions, the generation time has been reduced by 32% following this release.Resolved report generation issues for 'Returns Data - Tax Codes Information' and 'Tax Classification Box Mapping Reports':
We fixed an issue identified where users couldn't generate reports using uppercase values (NL) or leaving the ‘Jurisdiction id’ parameter blank. This release, we have enhanced the ‘Jurisdiction id’ parameter to be case-insensitive and if no value is provided, data will be fetched from all jurisdictions.Enhanced access of
the Active transaction report:
This report was previously only accessible to the ‘system administrators’ but it has now been extended nowImprovements to E-Invoicing Reconciliation Report:
We have updated our E-Invoicing Reconciliation Report to improve your experience. The report has been renamed to Tax Return to E-Invoicing Reconciliation Report
, and some column names have been changed to better represent their contents on the view transaction
screen. These changes aim to make the report clearer and easier to use. We hope these updates will make your reconciliation tasks easier to understand and navigate.The below mentioned fields have been updated for
E-invoicing
import on the transaction screen:The below
Status
have been updated in the Tax Return to E-Invoicing Reconciliation Report
:Existing name | Revised name |
|---|---|
Not In E-Invoicing | Not in E-INV |
Not In VAT | Not in OIC |
The
Type of Mismatch
have been updated in the Tax Return to E-Invoicing Reconciliation Report
:Existing name | Revised name |
|---|---|
Missing In E-Invoicing | Missing in E-INV |
Missing In VAT | Missing in OIC |
The
column name
has been updated in the Tax Return to
E-Invoicing Reconciliation Report
:Existing column name | Revised column name |
|---|---|
EntityCode VAT | EntityCode (OIC) |
EntityCode E-Invoicing | EntityCode (E-INV) |
Tax Amount (E-Invoicing) | Tax Amount (E-INV) |
Tax Code VAT | Tax Code OIC |
E-InvoicingVAT Matchfield (E-Invoicing) | E-InvoicingVAT Matchfield (E-INV) |
Save Parameter Functionality in Reconciliation Reports:
The functionality of the 'Save parameter' has been enhanced in the Reconciliation Reports. Previously, when generating the reports, the 'minimum difference in amount' parameter was not taken into consideration. However, this issue has been resolved. Now, when generating the reconciliation report, only transactions that meet the specified "Minimum Difference In Amount" parameter values are displayed. This update ensures that your settings are correctly saved and applied when running reports from the screen. As a result, this improvement significantly improves the accuracy and efficiency of your reconciliation processes. Please refer to the snapshot below for further details.Enhancement to the Import Status report:
When a user runs the import process again, the Import Status Report is updated with the latest modifications. We have added 'UpdatedBy' and 'UpdatedDate' columns to the report to show the last person who made changes and when they were made. The 'Import Date' and 'User Name' columns will still show the details of the first user who imported the data. This makes it easier to track updates and improves transparency in managing your data.Rollback of Data Population Changes in Audit Reports
: Following changes to the flow of modified/original data in audit reports, users experienced impacts on their internal custom automations based on these report data columns. To allow customers time to adjust their customizations, we will roll back the update in the 2024.10 release and will re-initiate it in upcoming releases.Other updates
Performance Enhancement: Filtering Large Return Datasets:
This release, we have enhanced system's performance when filtering values using the Return
field. As part of this enhancement, the default display will now show the latest top 2000 datasets when filtering by value
. If there are more than 2000 items, users will need to use the filter by condition
option. This update ensures optimum system performance in handling large volumes of data on Active transactions
and Drilldown screens
. However, users are also suggested to leverage several column filters available on the screen prior to filtering by value when working with high volumes of data to ensure smoother user experience within the platform.Improvements on dashboards:
Graphs seen in dashboard screen have been enhanced visually to differentiate between input and output values for easier data analysis and user readability.Resolves issues seen while deleting datasets:
We have addressed an issue that was preventing users from deleting datasets when the WORKFLOW setting was enabled. Previously, attempting to delete a dataset under these conditions would fail. Now users can delete datasets seamlessly, even when WORKFLOW settings are enabled. Enhancements to data synchronization logic:
Updates to logic to ensure synchronization between periodic and annual returns considering return statuses.Content template versions
VAT3AE17_6_146_TPL.XML
VAT3AT16_10_193_TPL.XML
VAT3ATGRP16_10_122_TPL.XML
VAT3ATANN15_7_69_TPL.XML
VAT3ATANNGRP15_7_58_TPL.XML
AUGAT2024_1_9_TPL.XML
VAT3BE15_7_199_TPL.XML
VAT3BEGRP15_7_128_TPL.XML
VAT3CZ16_8_386_TPL.XML
VAT3CZGRP16_8_232_TPL.XML
VAT3DE15_12_266_TPL.XML
VAT3DEGRP15_12_211_TPL.XML
VAT3DEANN15_12_159_TPL.XML
VAT3DEGRPANN15_12_147_TPL.XML
VAT3EE15_2_166_TPL.XML
VAT3EL17_6_137_TPL.XML
VAT3ELGRP17_6_103_TPL.XML
VAT3ES16_11_482_TPL.XML
VAT3ESGRP16_11_311_TPL.XML
VAT3FI12_4_136_TPL.XML
VAT3FR15_10_230_TPL.XML
VAT3FRGRP15_10_173_TPL.XML
VAT3HR14_6_172_TPL.XML
VAT3HRGRP14_6_107_TPL.XML
VAT3IE14_9_232_TPL.XML
VAT3IEGRP14_9_144_TPL.XML
VAT3IEANN14_9_113_TPL.XML
VAT3IEANNGRP14_9_69_TPL.XML
VAT3IS2410_1_19_TPL.XML
VAT3ISGRP2410_1_10_TPL.XML
VAT3IT16_8_224_TPL.XML
VAT3ITGRP16_8_150_TPL.XML
VAT3JP17_6_162_TPL.XML
VAT3JPGRP17_6_85_TPL.XML
VAT3NL14_10_386_TPL.XML
VAT3NLGRP14_10_256_TPL.XML
VAT3PT15_10_306_TPL.XML
VAT3PTGRP15_10_209_TPL.XML
VAT3RO16_7_466_TPL.XML
VAT3ROGRP16_7_275_TPL.XML