Specifications

10  Lesson 6 Computer Tutorial 3
Row 14 has a formula that generates the account balance for the period from the general
ledger. This particular formula treats debits as positive and credits as negative.
Row 16 has a “\” which repeats information above it. In this case, it repeats the formula that
generates the account balance for the period from the general ledger, treating debits as
positive and credits as negative.
Row 17 has a formula that sums the balances of the accounts in the current asset section.
Row 21 has a “\-”. This repeats the formula in row 20 which repeats the formula in row 16.
The only difference is that credits are reported as a positive number, and debits would be
reported as a negative number.
FR menu
The FR menu contains the following functions (among others) that you may use in modifying
a specification file:
FR View: opens the dialog box that allows you to specify the accounts to be included, sorting
order, and other report options. Once these options have been chosen, the Statement Designer
will generate a financial statement. Using FR View allows you to test the specifications and
statement design that you have created and to preview financial statements before printing
them.
FR Paste: inserts commands and formulas into the cells of the spreadsheet. FR Paste allows
you to look up account numbers, define formulas and selection criteria, and create complex
formulas without having to enter the syntax manually.
FR Help: searches for help on Statement Designer topics.
In Exercise 6.4, you modify the working copy of the quikbal.xls specification file you created
previously.