Generating a Leadsheet based on Report Tab Settings
Prerequisites
You can generate leadsheets based on the settings from either the Engagement | Mapping | Report tab or the Working Trial Balance | Report tab. We recommend to set up the leadsheets using Engagement | Mapping | Report tab for the following two reasons:
| Reason | Engagement | Mapping | Working Trial Balance | Report |
| Using the same reports in more than one client file | Reports will work for each client file whose chart of accounts is assigned to the map numbers. You can copy this structure to another client file using Copy Components, and all you have to do is assign their chart of accounts to the map number to use these financial statements and schedules. | Reports will work only for the client chart of accounts they were based on. If you are setting up another client file using Copy Components, you will have to go through all the lines of the report and verify or change the account numbers to match that client's chart of accounts. |
| Consolidated files | The map number is the heart of the Consolidation function in Working Papers. The charts of accounts for all entities in a consolidated client file must be assigned to one map number. Once the sub companies' and divisions' charts of accounts are assigned to the map number, financial reports for each and every subsidiary can be printed from the single set of financial statements and schedules laid out in the Map number Report screen. | If you are setting up draft financial reports for a consolidated company, you will have to create separate reports for each entity and division in the consolidation tree. Some of this can be done using copy and paste but then you have to verify the entity, division and account number fields for every line of each entity. |
Procedures
-
While on the Document Manager, click an area where you want to add the document.
-
Click
on the Document
toolbar. -
In Format, select Account balances with totals.
-
In Order , select Report to present the leadsheet with the formatting specified in the report tab.
-
In Grouping , select the type of grouping you want to use to present the accounts.
-
In the Group No., enter the applicable leadsheet, group or map number, or tax code that corresponds to the type of grouping selected in the Grouping box.
-
Click OK to finish.
