JAZZIT FUNDAMENTALS HELP GUIDE
×
Menu
Quick Guides
Generic 9 column with subtotals Schedule
Generic 9 column with subtotals Schedule
1
Schedule title
1. Schedule title
Customizable schedule title which appears at the top of the schedule and on the Index Page
2
Balance transfer
2. Balance transfer
Select from the dropdown if the schedule total should be included in the following Balance Sheet or Income Statement areas:
  • Exclude from statements
  • Net added to trade sales - Transfer schedule total to trade sales in the Income Statement
  • Net added to cost of sales - Transfer schedule total to cost of sales in the Income Statement
  • Net added to fee income - Transfer schedule total to fee income in the Income Statement
  • Net subtracted from fee income - Transfer schedule total to be subtracted from fee income in the Income Statement
  • Net added to expenses - Transfer schedule total to expenses in the Income Statement
  • Net added to other income - Transfer schedule total to other income in the Income Statement
  • Net subtracted from other income -  Transfer schedule total to be subtracted from other income in the Income Statement
  • Net added to current assets - Transfer schedule total to the current assets in the Balance Sheet
  • Net added to long term assets - Transfer schedule total to the long term assets in the Balance Sheet
  • Net added to current liabilities - Transfer schedule total to the current liabilities in the Balance Sheet
  • Net added to long term liabilities - Transfer schedule total to the long term liabilities in the Balance Sheet
3
Page break
3. Page break
Select if the page break should be enabled at the top of the schedule.
4
Section rounding
4. Section rounding
Enter amounts for rounding of the specific section if needed.
5
Schedule control
5. Schedule control
Left-click the button to delete the schedule.
Right click the button to reload the schedule from the Resource Centre.
6
Schedule settings
6. Schedule settings
 
Open the SCHEDULE folder to find the following schedule settings:
  • Sections visible - Select the number of sections required for the schedule (between 1 - 6 sections are available for this schedule)
  • Grand total - Turn the grand total on or off for the schedule
  • Running totals - Turn on running totals between sections (running totals are only available from section 2 - 6 in the schedule)
  • 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
     
7
Column settings
7. Column 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
8
Rounding row
8. Rounding row
The line with this symbol in the express menu has been set to round any amounts set in the rounding line (above).
Any line can be set as the rounding line by using the express menu functionality.
9
Link number
9. 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.
10
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.
11
Link type
11. 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.
12
Section total add or subtract from grand total
12. Section total add or subtract from grand total
Select if the section total should be added (+) or subtracted (-) from the schedule grand total
13
Section running total
13. Section running total
 
 
Open the desired sections Running Total Options for the following setting:
Grand total for the schedule (running totals do not affect the Grand Total)
  • Select which sections are to be included in the running total by selecting the relevant sections tickbox
  • Select if a sections total should be added (+) or subtracted (-) from the running total
  • C - Clear all tickbox selections
  • S - Select all tickboxes
14
Grand total
14. Grand total
Grand total for the schedule (running totals do not affect the Grand Total)
15
Comments (input paragraph)
15. 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.