DM 20b Admin – Return Data: National (No Group Filing) to Local (No Group Filing)

The following has been taken from the Tax Provision Blueprint "Instruction Guide" starting at page 196.

See KB article: "Tax Provision Blueprint Instruction Guide - PV7.3.0 SV100"

See KB article: "Data Integration"

Dashboard DM 20b Admin – Return Data: National (No Group Filing) to Local (No Group Filing)

• Select a WF entity and a Local Jurisdiction that you want the National Return data to be copied into.
• If the “All Entities” check box is selected, then all the entities in the combo box and all the UD7 members associated to each entity will be copied or cleared. It does not matter what is in the POV; the check box supersedes the POV. We refer to this as a “bulk” copy or clear.
• If the “All Entities” check box is not selected, then only the POV selected in the combo boxes will be copied or cleared.
• The bottom section of the toolbar will update with a “timestamp” with the last time a “bulk” copy or clear was executed. The timestamp will not be updated if the “All Entities” check box is not selected.
• After a copy is completed, a 1 is entered to account TXP_Data_Copy_20b
• A Cube View is supplied in the dashboard to show the user the Local Jurisdiction copied data.
• You must select the RTP Year that you want to process.
• The JD RTP year/month is pulled from Schedule 02 Set the Return Year
• The RTP year drives the copy / clear business rules.
• The JD RTP period is for informational purposes only.
• As each Local Jurisdiction can have a different RTP year/month, the cube view only shows the current jurisdiction.
• The last three columns help explain the variance for data that has been entered in local only permanent or temporary difference accounts.

If you selected an entity/Jurisdiction that does not have an RTP year and period entered into Schedule 2 Set the Return Year, the dashboard returns an RTP year of “2099”. This is the maximum year that OneStream allows. There should never be any data in this future year. You will also see that the RTP period now says, “No Period entered in Sch 02”.