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:
| Number | Name | Description |
|---|---|---|
|
Show/hide total columns |
Show/hide total columns for current year, prior year, or both. |
|
Budget column |
Show/hide the budget column. |
|
Display +/- column |
Display the +/- button next to the relevant table to allow you to change the signage of that row. |
|
Foreign exchange |
Apply foreign exchange values globally if entered in Caseware. |
|
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. |
|
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. | ||
|
Load column defaults |
Click to reset the column settings to the Resource Centre default. |
|
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. |
|
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. |
|
Foreign Ex |
The foreign exchange can also be applied to each individual column(s). |
|
Discrete |
Select the discrete period (Yes = Period movements, No = cumulative balances up to period selected (year-to-date)). |
|
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. |
|
Year |
Select the financial year (current, prior 1 through 4) for each column.
|
|
Bucket |
Select the bucket (active, random, yearly, semi-annually, quarterly, monthly, etc.) for each column. |
|
Period |
Select the relevant period within the year selected that you want to view. This is dependent on the Bucket selected. |
