Create Leadsheets:
For each Item in a financial report, the Leadsheet shows the financial report sheet name (cell D3), the cell address of the Item balance (D4), the Item description (C6), the grouped accounts and respective balances, adjusted or unadjusted (according to the Adjusted Balances button status), Rounded or not (according to the Rounded button status), the sequence order of each grouped account (column B), and, if selected, a comparative period (column F).
Balances appear in parentheses if they have a different accounting sense than that of the Item.
Hint: Click on an account balance in the leadsheet to view the details of that account balance.
The working paper is placed into a new worksheet, named
LS-<{Identifier}>-Worksheet Name of the active financial report (max 10 characters)>-<Item Description> (limited to 30 characters)
Here is the financial report that was active when the Leadsheets button was clicked:
In this example, the Balance Sheet has a “Cash” Item Balance in cell E12.
After clicking the Leadsheets button, you are prompted to specify the Items in the active worksheet for which you wish to create a Leadsheet:
Check the desired items (or click Select all), then click Create Leadsheets.
NOTE: Leadsheets already created are removed from the list.
User Notes
Tickmarks, references, comments, initials, etc. can be written in the Leadsheet working paper, around the data managed by ExcelFSM (in the area represented by shadowed cells and rows):
Always up to date
Leadsheets are always up to date. Changes made through the Read Trial Balance Data process, in Adjusting Entries, in Item groupings, in the Adjusted balance button status, in Category selection, and in the Rounded button status are automatically reflected, to always show the balances of the related financial report.
Note: User Notes, located in the shadowed areas, remain preserved.
Comparative period
If the financial report had a comparative presentation, the closest comparative period to the current one will appear in the Leadsheet (column F). The comparative period can be changed by clicking the Comparative button.
If the financial report was built with the Balance Variation button ON, the comparative column (column F) will be blank and must be done manually, similar to the comparative column(s) in the financial report:
1.Copy column E to F
2.Click the ‘Balance Variation' Down Arrow button
3.Click ‘Select Period(s)
4.Select periods range
Both beginning and ending periods of the range will appear in the Leadsheet (row 5 and row 6).
Deleted Item Balance groupings
If an Item Balance grouping has been deleted from a financial report, it will be indicated in the Leadsheets as follows:
Deleted Financial Statements
If a financial report is deleted from the workbook, it will be indicated in the Leadsheets as follows:
