Create Grouped Account Sheets:
For each account grouped into an Item in a financial report, the Grouped Account Sheet shows the name of the financial report (cell E3), the Item description and sequence number of the account in the grouping of the Item (E4), the as of date (E5), the account (B7), the unadjusted balance, the adjusting entries allocated to the account1, and the adjusted balance of the account for the current period.
1 Adjusting entries shown are limited to the selected categories of the related financial report.
The working paper is placed into a new worksheet, named
GAS<Identifier>-<Worksheet Name of the active financial report (max 10 characters)>-<Account id> (limited to 30 characters)
In this example, in the Balance Sheet, the account “10003-Petty Cash" is the second account grouped in the Item "Cash".
Here is the financial report that was active when the Grouped Accounts Sheet button was clicked:
After clicking the Grouped Account Sheets button, you are prompted to specify the grouped accounts in the active worksheet for which you wish to create a Grouped Account Sheet:
Check the desired accounts (or click Select all), then click Create.
NOTE: Grouped Account Sheets already created are removed from the list.
User Notes
Tickmarks, references, comments, initials, etc. can be written in the Grouped Account Sheet, around the data managed by ExcelFSM (in the area represented by shadowed cells and rows):
Always up to date
Grouped Accounts Sheets 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, and in Category selection are automatically reflected, to always show the balances of the related financial report.
Note: User Notes, located in the shadowed areas, remain preserved.
Deleted Item groupings
If the account is no longer grouped to an Item in the financial report, it will be indicated in the Grouped Account Sheet as follows:
Deleted Item Balance groupings
If an Item Balance grouping has been deleted from a financial report, it will be indicated in the Grouped Account Sheets as follows:
Deleted Financial Reports
If a financial report is deleted from the workbook, it will be indicated in the Grouped Account Sheets as follows:
