Files: P_INPUT_10.xml / P_INPUT_10.xlsx / UI_P_INPUT_10.xml

This input sheet calculates entries (based on company's to IS and BS), which are needed to record all the reversals of tax-based reserves into equity and deferred tax liability. The template includes formulas that calculate the entries to be made by the input unit. By saving the template, these entries are saved. By running the input sheet calculation for the template, it is possible to save the entries for all group companies at once (other alternative is open the template and save it manually). Entries are saved to document series 32 000. The counter unit for the entries is the one the admin has set to CODIM00UNIT_TAXBASEDPROVISION - global parameter, and it must be within the reported consolidated level.

Note that separate template is needed for each reported consolidated level if several exist in the same database. In each template set the required counter unit code (or new global parameter you have created) as dimensionudid value of dimension (codim00) in settings of all relevant datacolumns. Tip: use search (codim00) to find all relevant columns.

The sheet takes also into account changes in tax and consolidation percentages. The unit currency and cumulative type of data are used by default.