9 Column Statements with Budget Column
 
  • The 9 column financials statement format also gives you the ability to show the entities on the Balance Sheet, Income Statement, Statement of Retained Earnings and the Cash Flow.
  • Column headings for the Balance Sheet, Income Statement, Statement of Retained Earnings, and Cash Flow are all controlled through centralized settings.  Click on the Show Column settings button in the freeze frame at the top of the document or click on the Columns tab in the Home menu.
  • These settings are retained in the Caseware file's CV Database. Consequently the settings are tied to the Caseware file and not the CaseView document. Please see CV External Data for more information.
 
The column settings allow you to choose various options including:
 
9 Column Statements with Budget Column
 
1
Show/hide total columns
1. Show/hide total columns
Show/hide total columns for current year, prior year, or both.
2
Budget column
2. Budget column
Show/hide the budget column.
3
Display +/- column
3. Display +/- column
Display the +/- button next to the relevant table to allow you to change the signage of that row.
4
Foreign exchange
4. Foreign exchange
Apply foreign exchange values globally if entered in Caseware.
5
2yr options
5. 2yr options
2 year notes and schedules can show single or both years with or without percent columns.
Column width can be modified with respect to 2 year notes and schedules
Option to bold or unbold current year column can be modified with respect to the 2 year notes and schedules.
 
6
Show all / Column selection / Period settings
6. Show all / Column selection / Period settings
Toggle between showing only the column selection area (top half) or showing the period settings area (bottom half) or showing both.
 
The following options can only be changed for each individual column if the Show/total columns is set to hide or if the popup menu in the total column for the option is set to As selected:
 
7
Load column defaults
7. Load column defaults
Click to reset the column settings to the Resource Centre default.
8
Switch column(s) on/off
8. Switch column(s) on/off
Use the checkboxes to check or uncheck which columns you want to switch on or off for each statement. Click on the arrow buttons to select all or deselect all columns in either the row or column. for a column or statement to check
 
or uncheck the checkboxes at once.
9
Entity
9. Entity
Assign the entities to the relevant columns. Entities should be added using the consolidations dialog in Caseware.  Please see Setting up entities in Caseware for more information on setting up entities.
10
Foreign Ex
10. Foreign Ex
The foreign exchange can also be applied to each individual column(s).
11
Discrete
11. Discrete
Select the discrete period (Yes = Period movements, No = cumulative balances up to period selected (year-to-date)).
12
Balance type
12. Balance type
Select the balance type (budget, consolidated, report, adjusted, unadjusted, forecast) that you want to use. This can be used when setting up Group/Company statements.
13
Year
13. Year
Select the financial year (current, prior 1 through 4) for each column.
 
14
Bucket
14. Bucket
Select the bucket (active, random, yearly, semi-annually, quarterly, monthly, etc.) for each column.
15
Period
15. Period
Select the relevant period within the year selected that you want to view. This is dependent on the Bucket selected.