ATC Global Tax Reporting Module

Welcome to the ATC Tax Reporting Module Guide

Follow detailed instructions on using our tax reporting solution in OneStream. Click below for a step-by-step walkthrough.

Get Started

ATC Global Tax Reporting Module

Michelle

Updated: May 19, 2025

Description

Click through a step-by-step, interactive demo walkthrough, powered by Supademo.

Steps

Welcome to the ATC Tax Reporting Module Guide

Click the Tax Reporting option once the user logs into the system

Then choose the desired period and scenario and click GO

Users will see the relevant tax forms displayed under OnePlace - Workflow for the selected entity, scenario and period.

Under Workflow View, users can see the full descriptions of an entity, change the scenario or year, and navigate to the desired sheet if needed.

The module includes 3 key pages: Information Visibility Page, Input Schedules Page, and Reports Page. Click an icon to navigate to each page.

Users can input three types of tax rates, which link to the relevant cells in input schedules or reports for calculations.

Step 1 - Information Visibility Page

At the top of the page, ensure the correct entity is shown. Then users can begin answering the tailored questionnaire.

The questionnaire contains Yes/No questions. Selecting 'Yes' activates the corresponding tax form in the Input Schedules Page, while 'No' deactivates it and disables data entry. After all questions are completed, clicking Submit will save the selections and apply them across the application.

Step 2 - Input Schedules Page

Input Schedule 01

After submitting the questionnaire, navigate to the Input Schedules Page. Up to 10 input schedules may be available, and this guide will cover each one.

Before diving in, note that 1. Blank white cells require manual input 2. Yellow cells source data from other cubes or forms 3. Light blue and Dark blue cells contain formulas that generate numbers automatically

The first cell, highlighted in yellow, links to the Finance Cube. Users can manually input adjustments in the cell below, which will automatically recalculate the PBT.

Next, no user action is needed for Accounting Temporary Differences. The line items are generated automatically from Schedule 04, Tax Basis Balance Sheet, showing both total amounts and the breakdown of Recognized and Unrecognized amounts.

Figures for Other pre-tax (temporary) Differences, Excess of Interest, and Ordinary Loss/Other Carry Forwards flow from their corresponding schedules. Only Transfer of Result Out/In and Other Carry Forward effects require manual input.

Tax adjustments after Estimated Current Income Tax (Expense)/Benefit are either manually input or automatically generated. Generated amounts flow from schedules that appear later. The Current Tax Charge cell represents the tax charge for the current year's financial net income or loss.

Items under Other Items can be manually input or automatically generated, including prior year adjustments, which are essential for calculating the Total Current Tax Charge. It is derived from: 1\. Current year tax charge 2\. Prior year tax charge 3\. Other adjustments Automatically generated amounts will appear from subsequent sheets. The Total Current Tax Charge is reflected in the Reported Current Income Tax (Expense)/Benefit cell, which is calculated automatically.

Input Schedule 01 - Sub-National

A dedicated Sub-National schedule is available for calculating the Current Tax Charge at the sub-national or the state level. The names of sub-national entities (e.g., "Sub-National 3", "Sub-National 4") are fully configurable and can be customized in advance to match the required names.

Tax data can be entered for each sub-national entity and is automatically calculated based on predefined tax rates configured in the backend.

The total sub-national charge is displayed in this schedule.

It is then consolidated into the National schedule, ensuring an accurate and complete Current Tax Charge in the P&L.

Alternatively, in the Sub-National schedule, a blended tax rate can be applied across all sub-national entities to simplify the calculation when detailed rates are not required.

Input Schedule 02

Next, we move to Schedule 02: Current Tax Charge Calculation (EQ). The line items here are similar to those in the previous section on Current Tax Charge Calculation (P&L), so this section will focus only on the key differences.

Users must manually enter figures for each category under both Opening and Closing Balance Equity (Commercial). The entered values will be summed and displayed in the Total column. The Equity Movement Before Tax will be automatically generated based on these inputs.

A Sub-National schedule is also available for Current tax charge (EQ).

Input Schedule 03

This schedule includes detailed and compressed versions of Current Income Tax and Pillar 2 Top-up Tax sheets. A Sub-National Current Income Tax sheet is also available.

The header shows the Opening Balance, tax movements from P&L, Equity, and Balance Sheet, leading to the Closing Balance. Current income tax charges are sourced from 01 Current Tax Charge Calculation (P&L). Initially, users manually input data, but from the next year, it rolls forward automatically.

The detailed version offers more information on both Opening and Closing balances. And the Sub-National and the Pillar 2 Top-up Tax sheet follow the same structure as the Current Income Tax National sheet.

Input Schedule 04

Adopting a full balance sheet approach, the tax basis balance sheet reconciles the tax basis of assets and liabilities with their book basis, commonly referred to as book-to-tax differences, identifying both temporary and permanent differences essential for calculating current and deferred taxes.

A pre-built example chart of accounts for Assets and Liabilities is provided and can be customized as needed.

Click the toggle next to each account to expand and access 10 tax specification lines. In this view, the user can: 1. Indicate if the difference is temporary or permanent by choosing Yes/No. 2. Classify the impact as P&L or Equity. 3. Add details in the Tax specification description field.

In the Opening Balance section, users can view the breakdown from Group GAAP to Local GAAP, and then to Tax base. Columns for Recognized, Unrecognized, and Permanent differences are positioned between these values.

For permanent items: After manually entering Group GAAP, Local GAAP, and Tax Base values, differences are automatically displayed in the Permanent column. No amounts will appear in the Recognized or Unrecognized columns.

For temporary items: After manually entering Group GAP, Local GAP, and Tax Base values, differences are automatically displayed in the Recognized column. If a value is manually entered in the Unrecognized column, the remaining differences will automatically appear in the Recognized column. No amounts will appear in the Permanent column.

The interactions in the Closing Balance section are the same as those described in the Opening Balance section.

ATC provides four tables for Movements when items are temporary: - Accounting Recognized and Accounting Unrecognized (from Group GAAP to Local GAAP) - Tax Recognized and Tax Unrecognized (from Local GAAP to Tax Base) These tables only appear if the item is temporary; otherwise, they remain empty.

Under a similar structure for all tables, the process is as follows: - Current Year data is automatically calculated based on inputs elsewhere in the sheet. - PYA requires manual input. - Total Balance Sheet Movements is the sum of the four adjacent items. Once these four are manually entered, the total is automatically displayed.

Next are the Permanent Movements columns, where the numbers are automatically calculated based on the data entered in the Opening and Closing Balance.

The Equity category includes a selector for categorizing Equity items. Users can make a selection for items affecting Equity. If no selection is made, the item defaults to the Other category.

Input Schedule 04 - CTA effect

The CTA effect is also available in this section. It captures gains or losses arising from currency translation when converting financial statements from a subsidiary’s local currency into the parent company’s reporting currency. In OneStream, tax rates for Opening, Closing, and Statutory scenarios are pre-configured in the backend.

This schedule is currently entered in the local currency (HKD). Under the CURRENCY list, a central reporting currency (e.g., EUR) can be selected, and the values are automatically translated upon selection.

After selecting EUR, the data is immediately translated into Euro figures.

The resulting foreign exchange differences are reflected as the CTA effect, providing clear visibility into the impact of currency translation on tax balances.

Input Schedule 05

The Other Differences (Pre-Tax) sheet captures the gross amount of adjustments, while the Other Differences (Tax) sheet records the tax amounts. Both sheets have the same structure, with the Pre-Tax sheet used as the example.

The user must first choose either P&L or Equity from the provided options.

The cells in the P&L/EQ section require manual input from the user, as do the cells in the BS section.

For the Derecognition cell, if the sum of the opening balance (recognized/unrecognized) plus the movement (recognized/unrecognized) does not match the closing balance (recognized/unrecognized), ATC assumes a change in the qualification of recognized/unrecognized. This adjustment will be reflected in the “(De)recognition” cell.

For the Closing Balance, no action is required from the user, as all cells are automatically calculated.

Input Schedule 06

The Excess of Interest schedule provides a detailed breakdown of movements from the opening balance to the closing balance. The header includes information on tax movements such as additions/utilizations, expirations, prior year adjustments, and balance sheet entries. This schedule is designed to capture both recognized and unrecognized excess interest amounts.

During the initial implementation, the user must manually input the Recognized and Unrecognized amounts of the Opening Balance for each year. From the following year onward, the data will roll forward automatically, simplifying the process.

During the initial implementation, the user must manually input all movement data for each year. From the following year onward, the data will roll forward automatically, simplifying the process. The (De)recognition cell is calculated automatically.

For the closing balance, amounts are automatically categorized as Recognized unless Unrecognized amounts are manually entered.

Input Schedule 07

The NOL section includes Tax Loss Carryforwards and Other Carryforwards. Both sheets share the same structure as schedule 06, Interest Excess, with identical headers and index columns. For more details, please refer to the last section.

Input Schedule 08

The Tax Credits section includes Withholding Tax Credits and Other Tax Credits, both following the same structure as sheets 06 (Interest Excess) and 07 (Loss/Other Carryforwards), with identical headers and index columns. The key difference is that users must first specify whether the credits belong to P&L or Equity, which can be selected from the dropdown list in the Tax Credits Qualification column.

Input Schedule 09

ATC includes phase-out schedules for various tax adjustment items. These schedules allow users to outline how the closing balance amounts are expected to change over future years, offering a clear projection of upcoming adjustments.

First is the Timing Differences sheet. The line items in the index column are automatically linked to the accounts in the 04, Tax Basis Balance Sheet. The figures, serving as the starting point for this sheet, are the closing balances of the reporting year and are automatically pulled from the corresponding cells in the 04, Tax Basis Balance Sheet.

Any amounts will automatically be classified under Later unless data is entered for the years from CY+1 through CY+5.

Next is the Other Differences sheet, with line items automatically linked to accounts in the 05, Other Temporary Differences Schedule. The figures, pulled from the reporting year’s closing balances, serve as the starting point. In the 5-year allocation section, users can manually input data for each year, with any unspecified amounts automatically classified under Later.

The Loss Carryforwards section includes two sheets. The first, Expected Year of Utilization – Recognized, starts with the Recognized total retrieved from the closing balance of 07, Loss/Other Carry Forwards – Tax Loss Carryforwards.

Users can manually input data for Current Year + 1, +2, +3, +4, +5, and +6 to +10, with any remaining amounts automatically classified under Later.

Expiration – Unrecognized sheet starts with the Unrecognized total from the same closing balance of the same sheet. Users can manually input data into three columns: Never Expire, Current Year +1 to +5, and Current Year +6 to +10. Remaining amounts are classified as Later.

The sheets within Other Carryforwards are identical to those in Loss Carryforwards. The starting point for these sheets is the Closing Balance Recognized from 07, Loss/Other Carry Forwards – Other Carry Forwards. For additional information on the remaining items, users can refer to the previous section, Phase-Out – Loss Carryforwards.

The sheets Interest Excess, Withholding Tax Credits, and Other Tax Credits are identical to the first sheet within Phase-Out – Loss Carryforwards.

Input Schedule 10

The Other Tax schedule allows users to record customized items with two types of "Other Tax": 1. Other Tax Calculated: 10 default lines. The first 2 columns require manual input, and the Tax amount is automatically calculated as the product of the first 2 columns 2. Other Tax Input: 3 default lines, with all columns requiring manual input. The descriptions can be updated.

Step 3 - Reports Page

Reports 01

The ETR schedule is auto-generated with no manual input required. It includes two identical tables: one for Profit & Loss and one for Equity, starting with the statutory tax rate applied to Profit before Tax or Equity Movement before Tax to calculate the Estimated Tax Charge.

The tables then outline permanent differences, temporary differences, and other tax effects. After these adjustments, the Actual Tax Charge is calculated. The report highlights the differences between the statutory and effective tax rates by detailing the tax components contributing to the actual tax burden.

Reports 02

On the Deferred Tax Overview page, users can select either a Compressed or Detailed view based on their needs. Most data is auto-generated, with some sections requiring manual input.

The deferred tax rate is automatically calculated based on the tax rate provided by the user in the system.

The row for Netting allows manual input if needed to finalize the Total Deferred Tax Position.

A Sub-National Deferred Tax Overview is also available.

Reports 03

On the Total Tax Summary page, users can select either a Compressed or Detailed view based on their needs. This summary provides a comprehensive overview of key tax information for easy reference and is generated automatically with no manual input required.

Reports 04

ATC now provides a Change of Tax analysis within the reporting schedule, helping users identify the drivers of deferred tax movement due to rate changes.

The schedule displays various tax rates used in the analysis. The Statutory Enacted Rate, Deferred Opening Rate, and Deferred Closing Rate are sourced from backend configurations. If users input custom rates in the Deferred Tax Overview, those values appear as the Custom Opening and Custom Closing Rates.

The rates are then fed into the Change of Tax Rate analysis, which consists of two components: - Change of Tax Rate – Reflects the impact of statutory rate changes between deferred opening and closing balances. These changes are typically driven by tax law updates and automatically applied through backend setup.

The analysis displays the effects by P&L, Equity, and the Total impact of different tax rates.

Now Available – USGAAP version

ATC supports tax reporting under both IFRS and US GAAP frameworks. The schedules used for US GAAP are structurally identical to those under IFRS. The key difference lies in the valuation allowance concept specific to US GAAP, which drives the main variation in reporting.

For Valuation Allowance (VA) analysis, either the Automated or Manual approach can be used—only one is selected based on discussions with the client. - Automated Approach – Users enter VA (Gross) balances in the Tax Basis Balance Sheet. The system automatically calculates the corresponding Valuation Allowance using predefined logic, and the results are reflected in the reports.

Manual Approach – Valuation Allowance values can be entered directly in the Deferred Tax Overview section within the reporting area, providing full control for adjustments as needed.

Well Done!