The Grouping Schedule Report enables you to group similar accounts together for analysis and review. You may choose to include any or all of the five grouping schedules and their subcodes, as well as one selected basis type each time you generate the report. You may also choose to suppress specific accounts and zero balances, insert page breaks after each group, round amounts, print ungrouped amounts per schedule, include unadjusted and/or adjusted balances, include tickmarks and workpaper references.
Open the File > Print Reports dialog by using one of the following methods: (1) clicking the Print button on the toolbar, (2) clicking the Print Reports icon on the shortcut bar, (3) choosing Print Reports from the File menu, or (4) pressing the CTRL+P shortcut keys. On the Reports tab in the Print dialog, double-click Grouping Schedule to move this report to the Selected pane. With Grouping Schedule still highlighted, click the Options button to open the print options dialog for this report.
Notes
- You can use the Setup > Grouping Schedules dialog to change the codes contained in a grouping schedule.
- You can assign predefined categories to each grouping code that can be displayed as subtotals on the Grouping Schedule Report (for example, A - Total Cash), by category (for example, Total Current Assets), as well as by type (for example, Total Assets).
- You can use the Tasks > Trial Balance window to change the assignment of grouping schedules.
- The Grouping Schedule Report includes only those grouping schedules with assigned codes.
See also: Trial Balance CS reports
Print options
Print options for a report may be saved as part of a report profile. Otherwise, print options automatically revert to their default settings when you unselect a report for printing or exit the Print dialog (unless the Save report options checkbox is marked in the Print tab of the Setup > User Preferences dialog).
General tab
You may choose to sort grouping codes and related subcodes in the Grouping Schedule Report by Alpha (default) or by Order Entered.
Grouping schedule(s)
Choose the grouping schedule(s) to include on the report. You may include all of the grouping schedules (up to five), or a selected grouping schedule.
Range of codes: To/From
You may specify a range of grouping schedule codes to include in the report by marking this checkbox and selecting both the first and last codes to include.
Choose one or more of the following balances to display in this report:
- Unadjusted
- Adjusted
- Report
- Tax
- Other
Note: To define the basis types, choose Setup > Balance Definitions.
Mark the Include prior year balances checkboxto select one of the following options from the available drop-down list.
- Unadjusted
- Adjusted
- Report
- Tax
- Other
Note: To define the basis types, choose Setup > Balance Definitions.
Select one of the following options to display Adjusting Journal Entries in the Grouping Schedule Report:
- None (default selection)
- Totals
- Details
Notes
- This field is available when:
- One or more of the following checkboxes is marked in the Balance display group box:
- Adjusted
- Report
- Tax
- Other
- The Unadjusted checkbox is marked in addition to one of the checkboxes listed above.
- This field is unavailable (grayed) when:
- The Unadjusted checkbox is the only checkbox marked.
- All checkboxes are unmarked.
- The Include account number option in the Print Options group box is checked by default and made unavailable (grayed) when Details is selected in combination with any of the selected balances (excluding Unadjusted).
You may choose one or more of the following options for this report:
- Include account number
Mark this checkbox to include account numbers in this report.
- Include subcode
Mark this checkbox to include subcodes in this report.
- Subtotal to grouping code category
Mark this checkbox to include subtotals for each grouping code category.
- Page break after each code
Mark this checkbox to insert a page break after each grouping schedule code.
- Round amounts
Mark this checkbox to round amounts in this report.
- Print ungrouped accounts per schedule
If marked, the program prints a list of accounts not assigned a code from the selected grouping schedule.
- Include unadjusted budget balances balances
Mark this checkbox to include unadjusted budget balances in this report.
- Include adjusted budget balances balances
Mark this checkbox to include adjusted budget balances in this report.
- Include tickmarks
Mark this checkbox to include an additional column in this report that displays tickmarks posted to the Trial Balance grid. Note that this checkbox is available only when the Include account number checkbox is marked.
- Include unadjusted budget balances
Mark this checkbox to include unadjusted budget balances in this report.
- Include adjusted budget balances
Mark this checkbox to include adjusted budget balances in this report.
- Include workpaper reference
Mark this checkbox to include an additional column in this report that displays any workpaper references posted to the Trial Balance grid. Note that this checkbox is available only when the Include account number checkbox is marked.
- Print zero balance
Mark this checkbox to include accounts with zero balances in this report, and then choose one of the following options.
Note: These two options are available only when the Print zero balance checkbox is marked.
Account Selection tab
You may choose to include either all or selected accounts in this report. The Accounts Available and Accounts Selected panes are available only when the Print selected accounts option is marked.
This pane is available only when the Print selected accounts option is marked at the top of this dialog.
All accounts in the client's Chart of Accounts are listed here (except those already listed in the Accounts selected pane). Double-click an Account to select it for inclusion in this report.
This pane is available only when the Print selected accounts option is marked at the top of this dialog. All accounts that have been selected for inclusion in this report are listed here. Double-click an account if you do not want to include it in this report.
Loc/Dept Selection tab
(available only when the Chart of Accounts mask includes locations and/or departments)
You may choose to include either all or selected locations/departments in this report. The Available and Selected panes of this dialog are available only when the Print selected locations/departments option is marked.
This pane is available only when the Print selected locations/ departments option is marked at the top of this tab.
All locations and/or departments in the client's database are listed here (except those already listed in the Selected pane). Double-click a department and/or location to select it for inclusion in this report.
This pane is available only when the Print selected locations / departments option is marked at the top of this tab. All locations and/ordepartments that have been selected for inclusion in this report are listed here. Double-click an item if you do not want to include it in this report.
Font tab
Typeface/Size
Page Layout tab
Page Layout and Page Orientation