| Anchor | ||||
|---|---|---|---|---|
|
| Anchor | ||||
|---|---|---|---|---|
|
| Anchor | ||||
|---|---|---|---|---|
|
| Wiki Markup |
|---|
*Technical remarks*
Tax rate reconciliation \[TRR\] is in accordance with IAS 12.81 \[c\] required disclosure which illustrates relationship between tax expense \[tax revenue\] in accordance with P/L statement and tax balance result before taxes. Using the reconciling items Quotentreiber are disclosed and tax rate is deduced. Tax rate is a key indicator of tax accounting.
The starting point of the TRR is the product from the tax balance result before taxes and applied tax rate. The following tax rates are regarded, acc. to IAS 12.85: |
Wiki Markup \[1\] national tax rate in a country where a parent company is based
Wiki Markup \[2\] for companies that operate in several tax law circles; a combined tax rate
| Wiki Markup |
|---|
Although the first variant \[1\] is far more common, the GTC supports both variants. If you want to use a combined tax rate, create a dummy corporation with an average tax rate as a parent company.
The structure of TRR is not stated in the IAS 12. The GTC uses the most frequently used TRR positions.
*Data origin TRR columns*
The 'TRR' dialogue consists of the following three \[four\] columns: |
Column: |
Adjustment
]]></ac:plain-text-body></ac:structured-macro>
IFRS
IFRS
Content
Local GAAP | Late Adjustments |
Adjustment IFRS | IFRS |
Content |
|
* Calculation of expected income tax expense based on tax balance result before taxes acc. to local GAAP [for late adjustments to current taxes] | * Calculation of expected income tax expense based on tax balance result before taxes |
[for |
<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="93c65e49-834b-4627-b731-44953157394e"><ac:plain-text-body><![CDATA[* Calculation of expected income tax expense based on tax balance result before taxes [for IFRS result adjustment]]]></ac:plain-text-body></ac:structured-macro>Calculation of expected income tax
IFRS result adjustment] |
|
Display |
|
|
- The column is always displayed
- The column is always displayed
Data Origin
- 'Current Taxes' dialogue
|
|
|
Data Origin |
| * 'Current Taxes' dialogue [when using Toolbox, for |
]]></ac:plain-text-body></ac:structured-macro>
foreign companies]
| Dialogue:
|
|
| Wiki Markup |
|---|
_Table 15: TRR columns_ *Difference: Germany / other countries* Depending on whether it is a German company \[German tax law\] or a company from other country \[toolbox\], the selected rows are displayed or hidden. This will be explained in the next chapter. The dialogue _TRR_ in the main area _\[Sub-\]Group_ offers an overview of all TRR items. *TRR tooltips* TRR items displayed in the _TRR_ dialogue have tooltips \[ !worddavfa38a756f23e84adc03eb00e50e0b786.png|height=15,width=14! \]. Click on a green square to view the explanation to a TRR item. It displays the dialogue of origin, the relevant row and the tax base. !worddavb6abe4c3040ca8f34a0a52dbf1731562.png|height=114,width=552! _Fig. 113: Tooltip in the 'TRR' dialogue_ Click on !worddav0e6aed2e2be6524c594577b2cfb8f9cc.png|height=17,width=18! to switch to the origin dialogue. *Validation: P/L and tax expense/profit and calculated tax expense/earnings* TRR is validated directly in the dialogue header and any potential differences are displayed here. It is checked, whether TRR items explain the difference between effective income tax expense \[original + deferred taxes\] and expected income tax expenses \[EBT x company tax rate\]. !worddav194b5139870c543d736d0c599a6d2124.png|height=84,width=646! _Fig. 114: TRR validation_ TRR item _Other tax_ can amount to max. 5% of the expected income tax expenses. If this amount is exceeded, a yellow warning triangle with an exclamation mark appears and user has to add a comment. Otherwise, the status of the _Deferred taxes_ milestone cannot be changed to _data ok{_}. The 5% rule is not fixed in the IAS 12; |
...
it has been taken from the earlier US GAAP regulation and is widely used. |
{*}{_}Tips for validation errors_*
Creation of a TRR in tax accounting belongs to one of the most time-consuming activities. The GTC facilitates the process significantly. However, there are certain requirements that have to be fulfilled for the highest possible degree of automation. The following points should be considered in case of validation errors:
- Allocation of tax balance sheet corrections in tax calculation
- Balance sheet differences local GAAP / tax comparison do not correspond tax balance sheet corrections
- Rollforward LCF has not been performed
- Changes in balance sheet differences IFRS / Local GAAP do not correspond the IFRS / Local GAAP result difference
| Wiki Markup |
|---|
*Allocation of tax balance sheet corrections in tax calculation* In the _B/S Comparison_ dialogue there is a local GAAP / tax balance deviation of 100,000. Thereof 60,000 – temporary and 40,000 – permanent. Tax rate is 30%: !worddavb21715d1992371b720320cc3a2c1c40e.png|height=153,width=524! _Fig. 115: Allocation of tax balance sheet corrections in tax calculation – 'B/S Comparison' dialogue_ Proposed values for tax profit are displayed for tax calculation purposes \[{_}Current Taxes_ dialogue\]: !worddav1fa7cc2ed718d82c5d041aabbd7550d0.png|height=66,width=646! _Fig. 116: Allocation of tax balance sheet corrections in tax calculation – 'Current Taxes' dialogue_ The taxable income of 100,000 has a 20% tax rate, which results in 20, 000 taxes. Deferred tax assets amount to -12,000 \[60,000 temporary difference x 20%\]. The TRR: !worddav8b58ff7382905d2399da3589c9d25102.png|height=194,width=646! _Fig. 117: Allocation of tax balance sheet corrections in tax calculation – 'TRR' dialogue_ There is only one IFRS-TRR item resulting from permanent balance sheet difference: !worddav35b2e659f6433f90439bebeee64c385a.png|height=116,width=646! _Fig. 118: Allocation of tax balance sheet corrections in tax calculation – 'TRR' dialogue_ If the allocation of the tax balance sheet corrections in the _Current Taxes_ dialogue differs from the proposed value, this results in the same taxable income \[100,000\]: !worddav00244009164b142d48a671022a60db81.png|height=96,width=646! _Fig. 119: Allocation of tax balance sheet corrections in tax calculation – 'Current Taxes' dialogue_ The TRR validation fails because of wrong allocation of tax balance sheet corrections: !worddav1517c932f04f601d01938604bf0c2f81.png|height=194,width=646! _Fig. 120: Allocation of tax balance sheet corrections in tax calculation – 'TRR' dialogue_ !worddav35b2e659f6433f90439bebeee64c385a.png|height=116,width=646! _Fig. 121: Allocation of tax balance sheet corrections in tax calculation – 'TRR' dialogue_ *Balance sheet differences Local GAAP / Tax Balance do not correspond to local tax balance sheet corrections* In the _B/S Comparison_ dialogue there is a Correction to local tax balance of 100,000 classified as temporary. The tax rate is 20%: !worddav73fcb85cd409a430377eab333ffc90ed.png|height=161,width=517! _Fig. 122: Balance sheet differences Local GAAP / Tax Balance do not correspond to local tax balance sheet corrections – 'B/S Comparison' dialogue_ For purposes of tax calculation a proposed value is displayed for the tax profit differences \[{_}Current Taxes_ dialogue\]. The proposed value can be viewed in the _Local GAAP – Tax Comparison_ report \[ !worddav352712f7d4ad1607733657159f3c963f.png|height=31,width=167! / main dialogue _Reports_ / dialogue _Tax Reports{_}\]: !worddav2a4cac18bfbb4b743e1287e754f2d4df.png|height=68,width=646! _Fig. 123: Balance sheet differences Local GAAP / Tax Balance do not correspond to local tax balance sheet corrections – 'Current Taxes' dialogue_ The taxable income amounts to 100,000 and results in 20,000 taxes with the tax rate of 20%. Deferred tax assets amount to -20,000 \[100,000 temporary difference x 20%\]. There are no TRR items in the _TRR_ dialogue: !worddav05f4187f998e3a0b4b1d18c04b3f04d3.png|height=186,width=646! _Fig. 124: Balance sheet differences Local GAAP / Tax Balance do not correspond to local tax balance sheet corrections – 'TRR' dialogue_ If the calculated tax balance sheet correction differs from the proposed value in the _Current Taxes_ dialogue, this may arise from the non-considered in the GTC data in the previous year tax return \[true-up\]. In this case another correction amount has to be entered for tax calculation: !worddavddf5cb6969e063c486a7945012c03c17.png|height=78,width=646! _Fig. 125: Balance sheet differences Local GAAP / Tax Balance do not correspond to local tax balance sheet corrections – 'Current Taxes' dialogue_ The TRR validation fails, because the tax balance sheet correction differs from the proposed value: !worddav17eac821021f5b70a778c94d38447025.png|height=182,width=646! _Fig. 126: Balance sheet differences Local GAAP / Tax Balance do not correspond to local tax balance sheet corrections – 'TRR' dialogue_ The reason for this is that the deferred taxes \[P/L statement effect, here 20,000\] are calculated based on the balance sheet comparison. If the resulting proposed value is not accepted in the _Current Taxes_ dialogue, the TRR validation fails. Creation of a true-up effect in the _Others_ dialogue solves the problem: -30,000 x 20% = -6,000. The true-up effect is explained in a separate chapter and can be calculated in the GTC automatically. Then the proposed value is displayed: !worddav07fc4c9f97e835505667dd997fd52e7f.png|height=82,width=646! _Fig. 127: Balance sheet differences Local GAAP / Tax Balance do not correspond to local tax balance sheet corrections – 'Others' dialogue_ A prior-period effect from the adjustment in the previous year results in TRR items in the _Deferred taxes related to other periods_ row. The validation is successful: !worddav440fe5ace047d499eec9214f7b3c8eb8.png|height=61,width=602! _Fig. 128: Balance sheet differences Local GAAP / Tax Balance do not correspond to local tax balance sheet corrections – 'TRR' dialogue_ *Balance sheet differences IFRS / Local GAAP do not correspond to IFRS / Local GAAP result difference* In the _B/S Comparison_ dialogue there is a difference of 100,000 between IFRS and local GAAP. The difference is temporary: !worddav0a667d4a806bff1a9d6b652a872e67eb.png|height=184,width=646! _Fig. 129: Balance sheet differences IFRS / Local GAAP do not correspond to IFRS / Local GAAP result difference – 'B/S Comparison' dialogue_ If the tax rate amounts to 20%, deferred taxes are 20,000. IFRS-EBT is 100,000 because of the balance sheet deviation. The validation is successful: !worddav64c97e7caee8a7f63c04b9059c4dcc98.png|height=172,width=646! _Fig. 130: Balance sheet differences IFRS / Local GAAP do not correspond to IFRS / Local GAAP result difference – 'TRR' dialogue_ If a deviating IFRS-EBT is detected, the TRR multiplied by the amount of difference does not equal the tax rate. Effect on earnings is traceable in this simple case. In real life it is not always evident whether asset differences between local GAAP and IFRS \[documented in the GTC\] have the right impact on earnings. The report 'Transition P&L results local GAAP / IFRS' \[ !worddav2f769d08b772dfef1574b66a58fd1247.png|height=28,width=243! \] is helpful here. The report shows whether the adjustments of balance sheet differences correspond to result differences: !worddavf445118dd5d4f8406a9091d0351c2487.png|height=259,width=560! _Fig. 131: Report 'Transition P&L results local GAAP / IFRS'_ |