Individual leadsheets are automatically created for each financial group assigned to one or more accounts in the financial trial balance. Changes to the group assignments in the trial balance, including the addition or modification of sub-group assignments, automatically update the leadsheets.
If a financial group is not assigned to an account in the trial balance, then a leadsheet is not created for that group.
If a financial group is no longer assigned to accounts on the financial trial balance, then the leadsheet is automatically deleted.
Select the entity you want to view. The consolidated entity is always the first item on the list. Then, each subsidiary with a trial balance is listed in the same order as they appear on the Subsidiary Setup page.
The leadsheet data that displays on the page is for the selected entity only.
The consolidated view displays a row for each subsidiary that has accounts assigned to the leadsheet. To view the account detail for a subsidiary, click the arrow next to a subsidiary to expand the subsidiary.
This view includes the following columns which are not available for non-consolidated engagements and subsidiaries:
EJEs (current year)
Consolidated total (current year)
Consolidated total (prior year)
You can add and view eliminating journal entries (EJEs) from the consolidated view by clicking on the Journal Entry button on the tool pane.
The subsidiary view displays the accounts and balances assigned to the leadsheet. You can add comments, tick marks, and journal entries.
Select the entity you want to view. The consolidated entity is always the first item on the list. Then, each subsidiary with a trial balance is listed in the same order as they appear on the Subsidiary Setup page.
The leadsheet data that displays on the page is for the selected entity only.
If a consolidated or a lower parent is selected at the top of the page, the leadsheet will display a row for each entity that rolls up to the parent that has accounts assigned to the leadsheet.
Click the arrow next to a subsidiary row to expand and see the account details.
This leadsheet includes the following columns:
EJEs (current year)
Consolidated total (current year)
Consolidated total (prior year)
You can add and view eliminating journal entries (EJEs) from the consolidated view by clicking on the Journal Entry button on the tool pane.
If a subsidiary is selected at the top of the page, the leadsheet will display the accounts and balances that are assigned to the leadsheet.
Allows you to export the financial statements to a Microsoft® Excel® workbook. Each financial statement appears on its own tab in the workbook.
Subsidiary Setup
Only available in consolidated engagements. Opens the Subsidiary Setup page, where you can add or modify information for subsidiaries.
Access a Workpaper from the Leadsheet
If you have tagged a workpaper to a leadsheet, you can access it by clicking the workpapers link that appears on the top right of the leadsheet. In addition, if workpaper reference links were added for an account from the trial balance, a blue icon will display next to the Final Balance (current year) column. You can click this icon to open or download the workpaper. See Referencing Workpapers from the Trial Balance for more information about workpaper reference links.
Work with Comments in a Leadsheet
In a Pro engagement, you can add comments to a leadsheet by entering text in the box that displays at the top left of the page. Click into the box and enter the needed text. The text is automatically saved when you click outside the box or navigate to another page.
If you later need to edit or delete a comment, click into the box to make your changes.
If you unassign all accounts from the group, then the comments on the leadsheet will be removed and will not come back with any future account assignments to the group. Leadsheet comments do not roll forward with the engagement.
Working with Single-Tier Consolidated Engagements
icon.
next to a subsidiary row to expand and see the account details.
icon will display next to the Final Balance (current year) column. You can click this icon to open or download the workpaper. See Referencing Workpapers from the Trial Balance for more information about workpaper reference links.