Data Flow Flowchart - Actual and Forecast

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

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

Attached are 2 PDF files that shows the Actual and Forecast Data Flow Overview. They are high level flowcharts that shows the flow of data from schedule to schedule while splitting up the functions between Data Collection / Workpapers / Calculations and Reporting.

Data Flow Overview

We define Tax Provision Blueprint in four sections: Data Collection, Workpapers, Calculations and Reporting. A data point is entered once and then flows through the tax provision calculation as defined.

The main data input is achieved through the Schedules (Forms) 01 – 06 as shown in the blue boxes below.

• Data Collection – Schedules 01 – 04
• Workpapers / Calculations – Schedules 05 – 18

The data collected and calculated in Schedules 01 – 06 are then used to populate Schedule 07 – 18 (Tax Account Reconciliation, Statutory ETR, and Consolidated ETR, Interim Reporting ETR, Applied Interim Reporting ETR). These forms are view only, except for the ability to reclassify income statement or balance sheet data in the Tax Account Reconciliation.