Setting up an Accounts row in a financial statement

Show expandable text

Warning

Product support for the Creative Solutions Accounting platform ended on September 30, 2020.

Help & How-To Center content for the Creative Solutions Accounting platform may be outdated and is used at your own risk.

Financial Reporter module

Choose accounts when you want to display the GL amounts for every account in a certain account group or range of accounts. On the printed report, each account will appear on a separate line. When you choose to define a row as an Accounts row, the application will automatically enter the text Account Description into whatever you define as the Text Column. That text will not actually appear on the statement. The account name from the Chart of Accounts will appear instead.

Note: Ranges of accounts, columns, rows, and cells in financial statements will now use a colon ( : ) instead of "to" to create the range. For example, the account range Act(100to120) is now displayed as Act(100:120). All existing statements were automatically converted to this format upon opening for the first time after you installed CSA version 2004.3.x. Ranges that are manually entered into formulas or cell contents, after this update, should also use this format.

  1. Press CTRL+W to select Row mode.
  2. In the Row Properties box, choose Accounts from the drop-down list in the Type field.
  3. In the Amounts field, specify an account group, a range of accounts, or a storage name.
    • To choose an account group, either select it from the drop-down list, or type it into the field.
    • To enter a range of accounts, type the account numbers in using the following format: act(###) or act(###:###).
    • To choose a storage name, type it manually or press F5 and select it from the Formula dialog.
  4. In the Text Column field, type in the letter of the column in which you would like the account description(s) to appear.
  5. If you want to store an amount definition for a formula or for a complex range of accounts as entered in the Amounts field for this row, enter a description in the Storage Name field.
  6. In the Sort Order field, choose the desired option from the drop-down list - Account #, Description, Amount Ascending, or Amount Descending.

    Note: If you choose Amount Ascending or Amount Descending by amount, you may also set one of the columns as the dominant column by selecting in from the drop-down list in the Sort Column field. If no selection is made, the application automatically assigns the left-most column that contains values as the dominant column.

  7. You may mark the Change Sign checkbox to change the sign of the amount to a debit or credit.
  8. If you want to print the account numbers or print zero balance accounts, mark the appropriate checkbox(es).
  9. Press CTRL+? to move to the next row, or click on the next row to save the changes you have just made.

Top of page

Was this article helpful?

Thank you for the feedback!