Lead Sheets
In
Review & Edit
, LEAD SHEETS
are used to review your balances for Total Tax Provision (Benefit), Deferred Tax Asset ( Liability) or (Payable) Receivable. Within the Lead Sheet grid, you can review the line item name and it's value.Three Lead Sheets are available:
Provision
, Deferred
, and Payable
.note
A Lead Sheet is not available for Effective Tax Rate (%) as the ETR value is derived from the provision lead sheet.
To review the Lead Sheet data for your Units and Sub-Consolidations.
- Select aBASE DATASETto see all Units and Sub-Consolidations that are active for that dataset.
- Select aLEAD SHEETfrom the drop-down list.
- Select
to change between the Reporting and Local currency. - Use the Data Menu Bar to refresh, export, and print data in the grid.
- Select theUNITS/SUBCONSOLIDATIONSdrop-down list to view and select a different unit or sub-consolidation.
- Select Manage Units to see all of the units for the selected dataset.
note
You can export the Lead Sheet to create a pre-defined pivot table that includes the Code, Class & Subclass.
Lead Sheet Tutorial Video
View the tutorial video below for information on how to access and update lead sheets.
Lead Sheet - Manage Units

Provision
The
Provision Lead Sheet
data provides information showing you how the system calculated the Summary value.
When you hover on the
Total Tax Provision Expense
, the definition appears showing you the calculation.
When you hover on the
Effective Tax Rate
, the definition appears showing you the calculation.
Deferred
The
Deferred Lead Sheet
shows a summary of the deferred amounts for the Federal + State + FBOS. In the unit's column, you can review the Tax Effected values for the deferred entries.Payable
The
Payable Lead Sheet
shows a summary of the payable amounts. The activity uses the Txn Types (CPROV - Payable Auto Posting) set up for the payable. The system determines the BBAL- Beginning Balance, Ending Balance, and CTA balance.note
The Payable Lead Sheet requires some configuration to review the payable entries.