Dataset Relations & RTP Posting

Dataset Relations lets you automatically update the Tax Provision through the calculation and posting of RTP true-ups. For the system to post RTP adjustments, you must relate a dataset with Tax Return data (contains the filed tax return data) to the same or previous period dataset with Provision data (final provision data), and a same or future period Target dataset (current year tax provision).
In the Tax Return (PROV) dataset, you set up the relationship between the tax return (
RTP Return
), final provision (
RTP Provision
) and current provision (
RTP Target
) within the
Dataset Relations
tab.
RTP Return
: A PROV type dataset with the filed tax return data.
RTP Provision
: A PROV type dataset with the final tax provision data.
RTP Target
: A PROV type dataset with the current year's
tax provision data.
For RTP adjustments to be posted, a Tax Return dataset (RTP Return) that has the filed tax return data must be related to:
  1. The same or previous period dataset with Provision data (RTP Provision) (final provision).
  2. The same or future period Target dataset (current year tax provision).
The system posts True-ups to the current year Tax Provision (target dataset) using Non-Cash Tax Adjustments (for the current) and Deferred Only adjustments (for the Deferred). Through the use of parameters, the system also allows you to post multiple RTP adjustments to a single RTP Target dataset.
note
This feature is only available in a PROV (Provision Dataset).
Set up and edit the relationship between datasets in the
Dataset Relations
tab.
To access the
Dataset Relations
tab, select Datasets, then click the edit (pencil) icon next to a dataset.