Skip to main content

Solutions

Products

Recommended products

Questions? We are here to help.
Contact us

Purchase

Questions? We are here to help.

Resources

2024

2024.07 | 5 July 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
The Australian Tax Office (ATO) requires the top 100 GST taxpayers to complete the GAT analysis and recommends it for other taxpayers.
This release includes the Australia GST Analytical Tool, which helps customers reconcile data from the underlying BAS returns to financial data. 
Australia GST Analytical Tool
Businesses need to meet their global obligations by staying current with regulatory changes and fulfilling periodic filing requirements.
We ensure the tool reflects all legislative changes and continue to expand global coverage while staying updated with any legislative changes in covered jurisdictions.
Ability to export the Italy VAT Return for E-filing purposes on quarterly returns with a monthly breakdown.
Customers see a growing need for a unified solution that shows a direct comparison between their e-invoicing and tax returns data to identify any discrepancies.
By introducing a reconciliation report, which compares data from e-invoicing solutions and VAT returns and enables a direct comparison between the 2 sets of data.
Introduced the E-invoicing reconciliation report.

Legislative Updates

Thomson Reuters' content team constantly monitors changes in Indirect Tax Legislation, ensuring our content supports the latest requirements from the covered jurisdictions.
Egypt VAT Return -
 Updated the return summary to reflect the latest version of the VAT declaration.
Summary of the changes compared to the previous form:
  • Changed the Adjustment value and Total value to be a category instead of a lump sum at the bottom.
  • Added lines in the
    Sales
     section for the 14% and 5% VAT-rated transactions.
  • Extended the
    Table Tax
     section by category –
    Works of subcontractors
    .
  • Added lines in the
    VAT
     section for 14% VAT, 5% VAT, zero-rated and exempt transactions.
Jordan VAT Return -
 Updated the return summary to reflect the latest version of the GST declaration.
Summary of the changes compared to the previous form:
  • Box 2 – added lines for Domestic purchases zero-rated and purchases of taxable assets and expenses.
  • Box 3 - added lines for Imports zero-rated and Taxable Imported Services.
  • Box 7 – Split Domestic zero-rated sales into 2 lines: Domestic sales to zero-rated entities and Domestic sales of zero-rated goods & services.
Romania VAT Return -
 Updated to remove elements for boxes 14.1 and 14.2 from the schema, as they aren't needed in the legislative update.

Content Enhancements

Australia GST Analytical Tool
The Australian Tax Office (ATO) focuses on understanding a taxpayer’s tax governance framework and testing their tax risk management controls and processes as part of their review. This includes a clear expectation that taxpayers are undertaking a reconciliation process between the BAS and audited financial statements, with the assistance of the
GST Analytical Tool
 (GAT).
To manage this challenge, we're releasing a new module called
Australia GST Analytical Tool
 (GAT), which can be added to customer databases in customer management as per other country templates.
This module includes worksheets for:
  • BAS and Accounting Summary (ATO Summary).
  • Method Statement.
  • Revenue & Expenses.
  • Business Activity Statement Summary.
The GAT is linked to the underlying OIC returns. It brings in and summarizes the Business Activity Statement (BAS) figures for these underlying returns. Clients can enter BAS figures into the Australia GAT module themselves. Currently, you'll need to enter the revenue and expense sheets manually. However, a new feature will enhance this process by aiding the import of this data into OIC in a release later this year.
If you're interested in learning more about this, please contact the support line or discuss with the ONESOURCE team.
Bahrain VAT Return -
 Resolved the inconsistency between
Tax Rate
 and
Net Box Number
. We've assigned previously incorrect Tax Rates to the respective VAT Return boxes. The fix now ensures that the values customers generate via the report
Box Number Report - CN/INV Mappings and Net/Tax Box info – KDN
 give a correct output.
Cyprus VAT Return -
 Added validation checks to boxes 6 and 7 for the Cyprus VAT Return. Boxes 6 - 11b can't be negative values and Boxes 8 - 11b already had the validation check.
Croatia UR-A listing -
 Amended the formula calculating the VAT Deductible Amount if the Irrecoverable Percentage was applied. Previously the order of the formula condition was incorrect, and the calculation of the VAT Deductible Amount was wrong.
Czechia VAT Return E-filing -
 Box 53 for VAT Return should only be filled out for the last tax period of the year or at the end of registration. OIC puts
0
 as a default and includes the value in the XML output.
Enhanced the XML output to show the markup for Box 53 only if there is any value for it completed in the return.
Czechia VAT Control Statement -
 Only
EU VAT IDs
 are allowed to report in the A.2. section of the VAT Control Statement. We built an enhancement to replace the GB VAT ID with blank values to avoid critical errors that prevents form submission.
Hungary DSPL Update -
 Enhanced the DSPL report logic for scenarios where a partially recoverable already deducted tax code was used. Currently, the full Tax Amount is displayed in the DSPL listing. The implemented solution resolves scenarios when the client's import to OIC already deducted the VAT amount via "partially recoverable deducted" tax codes. In such cases, the DSPL listing the Full Tax Amount must be displayed and the values must be calculated by Net Amount and Tax Rate rather than importing directly from the source file.
Italy VAT Return PDF Form -
 The Italy VAT Return PDF allows reporting of the monthly split in a quarterly return. The values are populated from the RG sheet that includes 3 columns with each month.
Portugal ESL -
 Updated the schema for generating the ESL listings report to capture information on the Certified Accountant ID populated in the Company Information sheet. We released the change in June 2024, but it needed an update due to a change in order by the Portuguese tax authorities.
Portugal Annex I and II -
 Annexes have updated logic as per below:
Annex I – Customer List:
  • We added another method for reporting transactions under 5k, as allowed by Portuguese law. Based on the tick available on the Company Information (P) sheet, the client can either include transactions below 5k in a separate box or allocate them to the respective boxes of the Annex, disregarding the 5k threshold.
  • We updated the upload condition of transactions for Annex II to unify reporting with Box 8 of the VAT Return, ensuring that Credit Notes are no longer imported.
Annex II – Suppler List:
  • We added another method for reporting transactions under 5k, as allowed by Portuguese law. Based on the tick available on the Company Information (P) sheet, the client can either include transactions below 5k in a separate box or allocate them to the respective boxes of the Annex, disregarding the 5k threshold.
  • Implemented the logic to replace the missing supplier
    VAT Id
     with a number consisting of a reporting entity VAT Number and RC (Reverse Charge) as a prefix.
  • Updated the upload condition of transactions for Annex II as the Credit Notes aren't importing anymore to unify reporting with Boxes 20-24 of VAT Return that also don't report Credit Notes.
Portugal VAT Return -
 We've applied the proper mark-up in the Irrecoverable percentage column to display different rows when the same tax code, but different percentages of recoverability were used. Resolved the item as it was reported as an issue where the irrecoverable percentage is aggregated for all the lines.
Saudi Arabia Box Number Report -
 Extended support to the Box Number Report for Saudi Arabia as this report wasn't supported earlier.
Slovakia Control Statement -
 Minor enhancements to the Control Statement include:
  • Ability to the get the
    Country
     element exported into the XML output. You could populate this field from the Control Statement Company Information sheet, then it will flow accordingly to output.
  • Logic enhancement into section B.3.1 so only 1 line with totals is displayed.
Slovenia VAT Return -
 Included hyperlinks to the A Sheet (Return Summary) for user to navigate the checkboxes for boxes 03 and 04 in Slovenian V Sheets (PDF forms for both language versions).
Luxembourg Periodic and Annual VAT Return E-filing -
 Added Value “0,00’ to box 419 in the XML output if no value is entered by the user to avoid blocking the E-filing process.
Singapore enhancement -
 This release comes with several improvements as follows:
  • Company Registration Number and Company Name can now be automated from the Entity Manager.
  • We included additional key fields to various reports for analytical purposes.
Management information sheet -
 Included the
VAT Due / Repayable
 caption on the B sheet in the VAT Single Template to be consistent with the group template. We've only released this change in group templates in other countries. We also need to release this change in single templates for these countries. The change was applied to the following returns: Austria Annual, Bulgaria, Cyprus, Denmark, Finland, Latvia, Luxembourg, Luxembourg Annual, Malta, Portugal Annual, Saudi Arabia, Slovenia, Singapore, and Turkey.
Other adjustment report -
 Enhanced to include the Other Adjustments (S3) Sheet. This sheet supports the manual adjustment boxes and manual return boxes on the Return Summary Analysis sheet. The sheet allows users to import and report on multiple adjustments for each of these boxes on the return. This enhancement was applied to the following jurisdictions: Hungary, Luxembourg, Portugal, and the U.K.
Greece VAT Return PDF Form -
 Updated the V sheet to reflect the changes included in the new VAT form that applies to reporting periods starting from July 1 2024 onwards. The changes compared to the old form are the following:
  • Added Boxes 308 and 338 for outgoing intra-community acquisitions and acts of the recipient with a VAT rate of 4%.
  • Added Boxes 309 and 339 for outgoing intra-community acquisitions and acts of the recipient with a VAT rate of 3% to the Aegean islands and from the rest of Greece to these islands.
  • Added Boxes 313, 314, and 315.
  • Deleted Box 400.
  • Added Box 912 (value of exempt transactions to and from the Mount Athos region).
The new form (050 - VAT EDITION 2024, Φ2 TAXIS), published on the Greek Tax authority (ΑΑΔΕ) on the third of May 2024 and can be found here.
Romania VAT Return PDF Form -
 Updated the V sheets to reflect the latest changes included in the new VAT form that applies from the month the decision was published (May 2024). The changes compared to the old form are the following:
  • Deleted Boxes 14.1 and 14.2 from the VAT form.
  • Deleted references for boxes 14.1 and 14.2 in captions in box 19.
Decision 888/2024 can be found here.
Singapore VAT Return -
 Added new tax codes to the TA8 table to provide compliant the Box Number report and Tax Classification Box Mapping report for clients.
UK MTD XML -
 Updated new fields in the UK MTD Schema. In addition to the existing ones, we've added 3 new fields to the UK MTD XML output:
  • <VATRegNo>
  • <PeriodStart>
  • <PeriodEnd>
note
This change doesn't impact customers or the previous e-filing process.
Turkey VAT Return
 – Implemented the changes published by the Turkish Tax Administration in the VAT Communiqué No 49.
We've changed the name of the "109-VAT Declared as Responsible" field in the Discounts table in the Discounts section to "109-VAT Paid by Declaration as Responsible".

Tax Codes

Belgium VAT Return -
 Added a new tax code to improve reporting of partially recoverable input VAT: Domestic purchase trade goods and raw materials – partially recoverable AP_DOMPURTRDGDSX

E-Filing & Content Expansion

Italy VAT Return XML -
 Added the Italian VAT E-filing coverage to the ONESOURCE Indirect Tax platform. It can be extracted as an XML output to file with the tax authorities.
E-filing needs to be performed from datasets with quarterly periodicity and there are 2 methods:
  • Quarterly e-filing –
     Total quarterly values are taken from the Quarterly return summary.
  • Monthly breakdown e-filing –
     Values from each month are taken from the Monthly return summary (sheet RG). This type of filing is available only in returns where the Monthly Return summary sheet is inserted.
note
For the Monthly breakdown e-filing method mentioned above, the creation of Monthly datasets and Quarterly Dataset are required. This way the Monthly dataset information will flow into the “RG sheet” within the Quarterly dataset, and the user will be able to perform e-filing.

Digital Tax Reporting

SAF-T reporting (Single Audit File for Tax) is based on the OECD requirements allowing users to generate a standard file format that includes various types of accounting transactional data using the XML format. The scope of reporting varies from jurisdiction to jurisdiction. The reporting is country specific to meet local requirements. Currently, OIC supports this type of reporting in the following jurisdictions: Austria, Lithuania, Luxembourg, Norway. Poland, and Romania.
Poland JPK_VAT Report -
 JPK_MAG (on-demand SAF-T) - Changed the logic for generating the report to allow reporting of selected operation types. The changed report logic excludes total values for non-mandatory sections of the report if there are no transactions to be reported.  Previously the control amount with the count and sum of total values referring to all sections were incorrectly included in the output making it inconsistent with the schema structure.

Return Enhancements

Auto Save of Data in Returns -
 We’ve soft-launched a new feature called
AutoSave
, which is initially enabled to some databases to get actionable feedback. After the feedback gathering phase, this will open and become available to all customers. This feature automatically saves workbook data whenever changes occur, eliminating the need for manual intervention. AutoSave triggers data saving at regular 5-minute intervals.
By saving data automatically, the risk of losing critical information during unexpected events such as system crashes or power outages is significantly reduced. This proactive approach enhances data integrity and reliability, providing a better experience for users. The functionality is driven through a setting
Enable autosaving of workbook
 in the settings page.
Please contact TR support if you don't want to use this feature and would like to disable at a DB level.

API Updates

Updated Handling of Empty Values in Reports -
 In earlier releases, several performance improvements were done for Reports. Notably, empty report values previously represented as "" are now displayed as nulls instead.
  • Client Action Required:
     Clients using automated processes via API should update their comparison logic to accommodate null values in the Subcategory and Amount fields of the "Returns Data - Return summary analysis" report. This adjustment ensures smooth reconciliations post-update.
  • Future Updates:
     Changes impacting API contracts are included in release notes beforehand, ensuring transparency and preparedness.
Concert Roles of API Account Users -
We made an enhancement to improve the synchronization of API account roles within OIC, particularly when using the
Apply permissions to all clients
 option. This improvement ensures that API accounts with the Client Admin role can generate audit reports as intended, with roles accurately reflected. Updated permissions at the individual client level correctly reflect the appropriate roles now, allowing users to access audit reports as expected.
Ongoing efforts are focused on further enhancing the system's capability to handle global permissions applications seamlessly. This update ensures that API account roles are accurately reflected in OIC, enabling appropriate access to OIC functionalities.

Import Enhancements

Corrected Import Status for Group Return Post E-filing -
 The import status of group returns accurately reflect the state of the return after e-filing, ensuring users have the correct status information. Updated the status correctly to
"Read only return - data not uploaded"
.
Users will experience clear and accurate status updates for their returns, enhancing efficiency in return management and contributing to a more reliable and user-friendly experience in handling group returns in OIC.
Introducing Access Controls for Bulk Deletion of imports -
 The system now offers the ability to grant or revoke permissions for performing bulk delete operations on imports. Previously, users could delete imports even when the
Delete Import
 permission was removed in concert.
When the
Delete Import
 permission in concert is enabled or granted to a user, they can select multiple imports and perform the delete operation on the Import Details screen. When this permission is disabled or revoked, users can't select multiple imports for deletion.
This update ensures precise control over bulk delete operations, enhancing security and user management. Administrators can manage permissions, ensuring that only authorized users can perform bulk deletions, maintaining the integrity of import data.
Restricting Duplicate Names of Import Files -
 Refined the setting
'Do not allow import with same file name more than once’
 to now display an error message on the New Import screen when an attempt is made to import a file with an existing name. The restriction on importing files with the same name is scoped to operate within individual clients only, rather than globally across all clients.
These enhancements ensure that users experience predictable behavior aligned with the configured settings, preventing unnecessary work disruptions, and supporting better data management practices across different clients.
Increased Tax Code Field Character Limit for DTR Imports -
 Enhanced the Tax Code field character limit from 35 to 50 for the following DTR import types:
  • DTR-TaxTable
  • DTR-Customers
  • DTR-Suppliers
  • DTR-Invoices
  • DTR-Product
This enhancement ensures comprehensive data import and management.
Improved Visibility and Discoverability of Import Errors in OIC -
 Made improvements to enhance imports error visibility and the overall user experience during the import process in OIC:
  1. Enhanced Error Interaction:
     A new hyperlink in the "Original Line Number(s)" column opens a pop-up displaying the first 1000-line numbers associated with a specific error, offering a detailed view of the issues.
  2. Accurate Error Count Display:
     The error count now reflects the total number of errors across the file, rather than just the first 1000. For example, if there are 4500 rows with the "Entity E1 Not Mapped" error, this total is displayed, giving an accurate representation of the issues.
  3. User Interface Adjustments:
     Minor UI adjustments include the alignment of the section separator line and the update of the column name from "Original Line Number(S)" to "Original Line Number(s)" for consistency.
These updates make the error handling process intuitive and informative, aiding users in quickly identifying and resolving import issues.
Improved Error Message Display for Import Failures -
 Enhanced the error message display functionality for import failures due to allocation errors. Previously, users faced an issue where import details shown an error count but clicking on the error provided no additional information leaving users unaware of specific issues.
We resolved the issue to ensure that error messages are accurately displayed. Users will see detailed error information as improvements were made to correct imports error visibility, in cases such as missing exchange rate configurations. Previously, errors were not visible on the UI which is now displayed as:
Exchange rate map is not defined for 'CurrencyCodeA' To ‘CurrencyCodeB'
.
Resolved Duplicate Exchange Rate Errors on OIC -
Users will receive accurate notifications regarding the duplicate exchange rates in custom Exchange Rate Sources. We made enhancements to improve the import process for exchange rates, eliminating erroneous error messages that previously occurred. The system now correctly interprets the exchange rates, ensuring it doesn't add duplicate records incorrectly by default when calculating the exchange rates.
Improved Import Functionality for Handling More than 100 Entities -
 Identified an issue where imports targeting more than 100 returns would fail with a
System Error in Uploading
 state due to recent internal code refactoring. This issue impacted existing functionality. After extensive testing and validation, a patch has been successfully deployed to resolve this issue. Imports now operate correctly even when targeting more than 100 entities.

Report Enhancements

Resolved Issues in Displaying Group Entities Data:
 It was reported that the "
Entities by Net Tax
" report wasn't displaying data for group entities. This issue was impacting the user's ability to view and analyze consolidated tax data across different group entities.
We've fixed this issue to ensure that the report now correctly displays data for all group entities. We've adjusted the data retrieval queries and ensured proper aggregation to facilitate accurate and comprehensive reporting.
This update is aimed at enhancing data visibility and accuracy in financial reporting, improving decision-making processes for our users.
Improved 'Save Parameters' Functionality in Batch Reports:
  1. Changes to The Saved Parameters:
     This modification ensures that saved parameters are updated based on the addition or removal of reports in the batch reports.
  2. Parameter Group Update:
     Renamed The 'Parameter name' to 'Parameter Group' to better reflect its functionality.
  3. New Tracking Columns:
     Introduced 2 new columns in the Parameter Group panel to provide better tracking of parameter modifications:
    • Last Update Date:
       This column displays the most recent modification date of the saved parameters, allowing users to easily identify the latest changes.
    • Created date:
       This column shows the date when the parameters were initially created, helping users track the inception of each parameter group.
These improvements aim to enhance the user experience by providing clear and detailed information about parameter changes and creation within batch reports.
VAT E-Invoicing Reconciliation Report:
 This release introduces the new E-Invoicing Reconciliation Report, designed to assist businesses in reconciling e-invoices with the VAT or GST return and is available to all customers from this release.
The report will highlight discrepancies in documents using logic that matches the entity, reporting date, and invoice ID.  The discrepancies flagged include:
  • Present in the e-invoicing extract but not in the VAT or GST, import or vice versa, and mismatches in terms of amount
The report will be enhanced based on customer feedback in future releases.
Performance Improvement to Audit Tax Classification Map Report:
 We've enhanced the working logic and data handling techniques of audit reports. We've resolved earlier issues reported of not being able to run the report for large databases with over 100 clients. We also see a marginal improvement in the time taken to run the report from earlier releases. The fix given is effective across all audit reports.
Resolved Issue with ECB Report:
 Previously, users encountered an issue where the ECB Report could be viewed on screen without any problems but attempts to export the report to Excel were unsuccessful.
We've identified and fixed the underlying problem that prevented the export of the ECB Report to Excel format. Users can now easily export their reports to Excel, ensuring that data manipulation and analysis can be conducted effectively outside of the system.
This fix aims to enhance the functionality and reliability of our reporting tools, providing a consistent user-friendly experience.
Resolved issues seen in running custom reports using API:
 Users experienced difficulties when attempting to run custom reports through the API after changing parameters at the copy stage. This issue prevented the execution of updated reports, affecting workflow and data accessibility.
We've fixed this issue by ensuring that changes in parameters are correctly recognized and processed by the API. Ensuring the proper execution of custom reports, even when modifications are made to the parameters at the copy stage.
This update aims to enhance user experience and ensure efficient report generation.

Other Updates

Enhancements to Return Summary Screen -
 Updated the Return Summary modal. Previously, it displayed a maximum of 25 import files associated with the return. However, with the recent enhancement, we've introduced pagination, which now shows all imported files. This implementation provides a comprehensive overview of the files, reducing ambiguity. Users can access all relevant files, overcoming display limitations, giving a robust user experience.
Enhanced Error Messages on Datasets -
 Improved error messages displayed on datasets for users to better understand corrective steps that need to be taken to rectify the error. This improvement will help users better understand and resolve issues, leading to an efficient workflow.
Key benefits:
  • Clarity:
     We've rewritten error messages to provide straightforward and easy-to-understand explanations of issues seen.
  • Detail:
     Included additional information to help users diagnose problems without needing to refer to support or additional documentation.
  • Actionable Guidance:
     Where applicable, error messages now include suggested actions or steps users can take to resolve the issue.
UI Enhancements on Multiple Screens -
 As part of this release, we've designed key UI elements to improve usability and improve your experience on multiple screens.
Key changes:
  • Entity Manager:
     Removed double scrollbars from the Entity Manager screen to increase workability of the functionality.
  • Report Output:
     Adjusted blank screen space to show more transactions on the screen.
  • View Transaction:
     To increase usability of the platform we've removed certain double scrollbars that appeared for files with long names. Instead. file name up to 60 chars will be displayed as is, more than 60 chars will be shown in the tool tip (seen when you hover over an icon).
  • Insert Sheet:
     We made the
    Ok
     and
    Cancel
     action buttons more visible so users can easily access when inserting sheets.

Known Issues

Insert sheets is not working from the return screen -
 Insert sheets aren't working, when inserting the sheets using the
More
 option.
note
Suggested workaround, users can open the return and then insert the sheets. This issue will be resolve in the upcoming release.
Display of Errors During Import:
 When performing an import in OIC with multiple entities, users may encounter an issue where errors related to tax code and exchange rate mappings aren't displayed if certain entities aren't mapped. Specifically, only errors for unmapped entities are shown, even though there are other errors related to mapped entities. We plan to get this fixed as part of the upcoming release.

Content Template Versions

VAT3ATANN15_7_64_TPL.XML
VAT3ATANN15_7_65_TPL.XML
VAT3ATANNGRP15_7_54_TPL.XML
VAT3BG13_7_155_TPL.XML
VAT3CY14_3_107_TPL.XML
VAT3CZ16_8_359_TPL.XML
VAT3CZGRP16_8_209_TPL.XML
VAT3DE15_12_259_TPL.XML
VAT3DEGRP15_12_204_TPL.XML
VAT3DEANN15_12_157_TPL.XML
VAT3DEGRPANN15_12_145_TPL.XML
VAT3DK14_5_137_TPL.XML
VAT3EL17_6_135_TPL.XML
VAT3ELGRP17_6_101_TPL.XML
VAT3FI12_4_131_TPL.XML
VAT3HR14_6_168_TPL.XML
VAT3HRGRP14_6_104_TPL.XML
VAT3ITGRP16_8_144_TPL.XML
VAT3IT16_8_210_TPL.XML
VAT3KS17_6_125_TPL.XML
VAT3KSGRP17_6_90_TPL.XML
VAT3LU15_9_307_TPL.XML
VAT3LUANN15_9_155_TPL.XML
VAT3LV18_8_129_TPL.XML
VAT3MT14_2_92_TPL.XML
VAT3PT15_10_255_TPL.XML
VAT3PTANN15_8_61_TPL.XML
VAT3PTANNGRP15_8_56_TPL.XML
VAT3PTGRP15_10_172_TPL.XML
VAT3RO16_7_419_TPL.XML
VAT3ROGRP16_7_247_TPL.XML
VAT3SK16_8_254_TPL.XML
VAT3SKGRP16_8_191_TPL.XML
VAT3SI16_4_154_TPL.XML
VAT3TR11_11_209_TPL.XML
VAT3TRGRP11_11_148_TPL.XML

This article applies to: