Quick Guides
Balance Sheet (9-column Statement Format)
The 9-column Balance Sheet format allows you to show up to 7 columns + a current year and prior year total or 1-9 columns that can be individually setup. Refer to 9 Column Statements with Budget Column on how to setup the 9-column statement format.
This statement can be used when preparing Not-for-Profit, PSAB or Combined/Consolidated financial statements.
The same functionality exist on the 9-column statements and the 2 year with % statement formats with the exception of the following items:
Balance Sheet (9-column Statement Format)
Statement format
1. Statement format
There are two Balance Sheet format types available for the 9-column with budget statement format. Use the popup menu to select the applicable format.
  • 1-9 column classified Balance Sheet
  • 1-9 column unclassified Balance Sheet that can also be used for PSAB statements.
Statement settings
2. Statement settings
The statement settings provide additional options for the Balance Sheet.
Statement title: Use the popup menu to choose an alternative statement name or manually enter the name in the input field. The statement name changes depending on the type of structure selected in the Client Profile section of the Home Menu.
Page size: The page size and page orientation is set depending on the number of columns selected. The following restrictions exist for printing the Balance Sheet:
  • The maximum number of columns available for Letter / Landscape is 6
  • The maximum number of columns available for Legal / Landscape is 9
  • The maximum number of columns available for Letter / Portrait is 4
Reminder to link to generic note number: Select to switch the reminder on or off. This will give you a warning message when connecting a generic note to remind you to link the note number reference to the statement if applicable. This option is only available if only the total CY and PY columns are selected. 
3. Columns
Click on the folder icon to show the column settings. In addition to setting the column headings, you can jump to the global
Column headings
4. Column headings
Use the checkboxes to the left of each heading line to skip or print the headings. Select the heading option you'd like to print using the popup menus. The following headings are available:
Row 1: Entity name - This is populated from the Engagement > Consolidate dialog in CaseWare.
Row 2: Balance type - Consolidated, Report, Unadjusted, Adjusted, Budget and Forecast. This can be used in conjunction with the balance type setting selected in the column settings.
Row 3: Selected period - Year-to-date, Months, Quarters, Periods, etc.
Row 4: Choose show to unaudited or restated in the headings.
Row 5: Description changes based on bucket selection in the column settings.
Row 6: Shows the year-end. You can also choose to show the balance type here.
Show/hide rounding
5. Show/hide rounding
Click on the folder icon to show/hide the statement rounding options.
Heading formatting
6. Heading formatting
The headings for the Balance Sheet can be formatted. Refer to Statement Section Headings Formatting for more information on the options available.