Using the 9 column financials statements format for consolidations
 
  • The 9 column financial statements format also gives you the ability to show the entities on the Balance Sheet, Income Statement, Statement of Retained earnings and the Statement of Cash Flows.
  • Column headings for the Balance Sheet, Income Statement, Statement of Retained Earnings, and Statement of Cash Flows 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.
 
The column settings allow you to choose various options including:
 
Using the 9 column financials statements format for consolidations
 
1
Show/hide total columns
1. Show/hide total columns
Show/hide total columns for current year, prior year, or both.
2
Load column defaults
2. Load column defaults
Click to reset the column settings to the Resource Centre default.
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
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.
 
The following options can only be changed for each individual column if the total columns is set to hide or if the popup menu in the total column for the option is set to As selected :
 
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 columns.
15
Period
15. Period
Select the relevant period within the year selected that you want to view. This is dependent on the Bucket selected.