Details toggles the display of an Item's accounts. Also toggles the adjusting entry lines in the Trial Balance working paper.
To illustrate, here is a sheet with a financial report.
It is shown first with Details turned Off, then with Details turned On for the first Item:
Details turned Off
Details turned On for the first Item
Figure 1: When Details are turned on, the accounts grouped in the Item are shown. Notice how rows are inserted to show the accounts for the "Cash" Item.
Double-clicking on an account's balance provides the detail of the account's balance
and double-clicking on an adjusting entry from the Account Balance Detail provides the detail of the journal entry
With the General Ledger Drill Down feature, double-clicking on the unadjusted balance in the Account Balance Detail provide the Account Unadjusted Balance Detail.
You can also choose not to have the account numbers shown:
Figure 2: Details are turned on for the first Item, but the account numbers are not shown.
The detail rows are inserted prior to the Item balance, separated by cell borders: a top border is added in the Item balance cell with Details ON, and removed with Details OFF.
Toggling an Item's Details
Select the item(s) in the worksheet that you wish to toggle:
•Click a single item
•Hold down the Ctrl key while clicking to select multiple items
•Hold down the Shift key while clicking items to select all the items in between.
•Click an item and drag the mouse to select the items within the rectangle you drag.
•Select all the items in the worksheet by clicking the square in the upper left corner of the worksheet:
Details are toggled based on the state of the first selected item. If the first selected item does not have its details showing, then details are shown for all the selected items. Conversely, if the first selected item does have its details showing, then details are removed for all the selected items.
Note: The Details button is pushed (or not pushed) when the active cell contains (or does not contain) details, respectively .
Show Account Numbers In Details
Whether or not Account Numbers are shown is determined by the Details ribbon button. Click on the arrow next to the Details to select from the drop down menu:
The next time you press the Details button, your choice will be used.
Trial Balance Working Paper
The Details button also toggles the adjusting entry lines in the Trial Balance working paper.
Formulas
The formulas in the cells containing details are e.g.
=FSMACCOUNTTITLE("8")
=FSMACCOUNTBALANCE("8, D, 0, 0")
Transforming Item's Accounts Into Items
From the toggled Details of an Item (shown without account numbers in the following sample)
you can select accounts
then click the Item Balance button from the FSM ribbon, and choose to transform the selected accounts into one item per selected account
or choose to transform the selected accounts into one item for all selected accounts
