Details

Top  Previous  Next

Details toggles the display of an Item's accounts.

 

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

clip0043

 

 

 

 

 

Details turned On for the first Item

clip0044

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 provide the detail of the account's balance

clip0045

 

and double clicking on an adjusting entry from the Account Balance Detail provide the detail of the journal entry

clip0042

 

 

 

You can also choose not to have the account numbers shown:

clip0046

 

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:

 

 clip0048

 

 

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:

 

clip0049

 

 

The next time you press the Details button, your choice will be used.

 

 

 

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)

 

clip0050

 

 

you can select accounts

 

clip0051

 

 

then click the Item Balance button from the FSM ribbon

 

clip0052

 

 

and choose to transform the selected accounts into one item per selected account or into one item for all selected accounts

 

clip0047

 

 

 

Selected accounts transformed into one item per selected account:

 

clip0053

 

 

 

Selected accounts transformed into one item for all selected accounts: