Quick Guides
1-9 Income Statement with Budget Schedule
1-9 Income Statement with Budget Schedule
Schedule title
1. Schedule title
Customizable schedule title which appears at the top of the schedule and on the Index Page
Balance transfer
2. Balance transfer
Select from the dropdown if the schedule total should be included in the following Income Statement areas:
Operations - Transfer schedule total to the related areas of the income statement i.e. Trade sales to Trade Sales, Cost of Sales to Cost of Sales, etc.
Net in other income - Transfer schedule total to other income in the Income Statement.
Net in trade sales - Transfer schedule total to trade sales in the Income Statement.
Net in fee income - Transfer schedule total to fee income in the Income Statement.
Exclude from income statement
3. Rounding
Enter amounts for rounding of the schedule if needed.
Schedule control
4. Schedule control
Left-click the button to delete the schedule.  Right-click the button to reload the schedule from the Resource Centre.
Schedule settings
5. Schedule settings
Open the SCHEDULE folder to find the following schedule settings:
Default link type - Select the default grouping you want to use for the schedule linkage. The schedule is defaulted to use the Map No link.
Comparative row - Select if you would like to print a manual comparative prior year row after the total at the bottom of the schedule.
Foreign exchange - Select to apply foreign exchange to the schedule.
Percentages - Set the number of decimal points to be displayed in the schedule.
Schedule headings settings
6. Schedule headings settings
Open the Headings folder to find the following schedule headings settings:
Bold - Set the desired heading to bold.
Uppercase - Set the desired heading to uppercase.
Singular - Set the desired heading to singular.
Heading - Select the desired heading title or enter a custom description (entering a custom description will cause the uppercase and singular option to no longer function on that specific line).
Schedule columns settings
7. Schedule columns settings
Open the COLUMNS folder to find the following schedule headings settings:
Column defaults -  Set the column defaults from the Resource Centre (current year and prior year totals are default).
Bold Column - Select which column is to be bolded.
Total columns - Select if you would like both total columns to appear, only the current or prior year total column, or no total columns.
Budget column - Set the budget column on or off.
Display +/- column - Set to display the signage column to the right of each line.
Column Selector - Choose which column will be used in the schedule.
Entity - Assign the entities to the relevant columns. Entities should be added using the consolidations dialog in CaseWare.
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)).
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.
For more information on the above settings, refer to the column settings page in the Help File
Rounding row
8. Rounding row
To apply the rounding difference to a row, right-click on the Express button () and select Adjust this row for rounding.
Show nil line
9. Show nil line
Select the tickbox if you would like a section without balances to print a total nil balance line.
Once selected, you can choose to rather display the section heading with a single nil line instead
Express button
10. Express button
Right-click on the Express button to insert more linked or manual lines, insert subtotals, sort and delete current lines where the options are available.
Link number
11. Link number
The link number indicates which linked number (i.e. map number) the row is linked to. Use the popup menu to select a link number. This can be a map, account or group number depending on the link type selected. Refer to Balance Origins for more information.
Link type
12. Link type
The link type is set from the default link type selected. You can change the link type for the individual row item if different from the default link type.
Gross profit percentage
13. Gross profit percentage
Right-click on the Gross Profit cell to either show or hide the percentages and decimal places.
Comments (input paragraph)
14. Comments (input paragraph)
You can edit existing input paragraphs or insert more paragraphs using the Express button (). Refer to Input Paragraphs for more information on inserting paragraphs.