Quick Guides
Analysis of Sales and Gross Profit Schedule
Analysis of Sales and Gross Profit 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:
  • Exclude from income statement
  • 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.
Default link
3. Default link
Select the default grouping you want to use for the schedule linkage. The schedule is defaulted to use the Map No link.
4. Entity
Select an entity to use in this schedule (blank is default)
Sort sections
5. Sort sections
Click to manually sort the sections in the schedule
Page break
6. Page break
Select if the page break should be enabled at the top of the schedule.
Schedule control
7. Schedule control
Left-click the button to delete the schedule.
Right click the button to reload the schedule from the Resource Centre.
Line signage
8. Line signage
Select if the row should be added (+) or subtracted (-) from the section/schedule total
Link type
9. 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.
10. Entity
Select an entity to use in a specific line (blank is default).
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.
12. Denominator
This symbol denotes the denominator line for the purposes of calculating gross profit. Right-click on the express menu of a line for the option to designate a line as the denominator.
Express menu
13. Express menu
Right-click on the express menu to insert more linked or manual lines, insert subtotals, sort and delete current lines where the options are available.
Section folders
14. Section folders
Click on the folder icon to print or skip a section or total
Comments (input paragraph)
15. Comments (input paragraph)
You can edit existing input paragraphs or insert more paragraphs using the express menu. Refer to Input Paragraphs for more information on inserting paragraphs.
16. Heading
Right-click on section headings for formatting options (bold, italics or both). Formatting options also include options for: indents, extra description column, currency symbols placement, and page break placement.
Gross Profit %
17. Gross Profit %
Double-click on a gross profit % to set the number of decimals points for all % information in the schedule.