Editing worksheet

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.

The editing worksheet at the right side of the Financial Statement Editor displays information that is representative of what will appear on the actual statement. No actual amounts or account descriptions will appear on the worksheet, only items representing the actual information that will appear when you preview or print the statement. This allows you to set up a statement that can be used for all of your clients without having to re-format the statement for each client.

The worksheet itself, similar to many popular spreadsheet applications, is made up of rows, columns, and cells. On the left, each row is assigned a number and a description that explains its role within the statement. While the number is purely for reference, the description may be changed depending on what function you want the row to perform in the statement. The application populates a cell by looking at the definition of the cell and the row, and then pulling the appropriate amount(s) and/or description(s) from the Chart of Accounts.

To modify the properties and contents of certain cells or rows, you must be in the appropriate mode. There are a variety of methods for choosing the correct mode.

  • For Row mode: press CTRL+W, click the Row mode button on the toolbar, or click the row number/description button on the left of the worksheet.
  • For Cell mode: press CTRL+L, click the Cell mode button on the toolbar, or simply click in the cell that you would like to modify. Depending on the current mode, different commands and options will be available for formatting the cell and defining its properties and contents.

You may assign a group of cells the same properties by selecting them and choosing the properties as you would for a single cell. To select an entire column of cells for formatting, click the column letter button at the top of the worksheet. To select a group of cells, click and drag to highlight them. Once the properties for a group of cells have been defined, any cell's properties within that group may be changed without affecting the rest of the group.

To view how the statement will appear when printed, choose File > Print Preview, or click the Print Preview button on the toolbar.

See also: Editing financial statements, overview

Was this article helpful?

Thank you for the feedback!