Setting up an Accounts row in a financial statement

Alerts and notices
Leave feedback

Contact information (optional):

Leave this blank:

Please tell us how we can make this information more helpful.

Characters left:

Important reminder!

Product support for Engagement CS is ending on September 30, 2020. See Engagement CS license expiration 2020 - frequently asked questions for more information.

Licenses for Payroll CS, Trial Balance CS, and Write-Up CS permanently expired on March 1, 2017.

Some processes documented in the Help & How-To Center are no longer applicable, due to the discontinuation of Creative Solutions Accounting.

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

Share This