HELP GUIDE
×
Menu
Quick Guides
9 Column Statements with Budget Column
 
 
The column settings allow you to choose various options including:
 
9 Column Statements with Budget Column
 

1
Load column defaults
1. Load column defaults
Click to reset the column settings to the Resource Centre default.
2
Show/hide total columns
2. Show/hide total columns
Show/hide total columns for current year, prior year, or both.
3
Budget column
3. Budget column
Show/hide the budget column.
4
Display +/- column
4. Display +/- column
Display the +/- button next to the relevant table to allow you to change the signage of that row.
5
Foreign exchange
5. Foreign exchange
Apply foreign exchange values globally if entered in CaseWare.
6
2yr notes & schedules
6. 2yr notes & schedules
2 year notes and schedules can show single or both years with or without percent columns.
7
Column width
7. Column width
Set the minimum or maximum column width.
 
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:
 
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 Clear (C) or Select (S) button 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.
 
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.