Enter a fund number to show only accounts in that fund on the report.

This drop-down is only active if the Fund Number field is blank. If you want to print one report that displays all the included funds, select Combined from the drop-down. If you want to print a separate report for each fund, select Separated.

Use these boxes to set the range of accounts you want to include. The default settings for these boxes include all the accounts in your Chart of Accounts.

(Fund product only) If you selected a source fund, the Lookup will be filtered by the selected fund and the fund number will appear in the appropriate segment.

Choose the Report Type according to the type of information you want to see and the way you want it organized.

From the drop-down, select whether you want to run the report by period or date. Depending on your selection here, the labels for the Starting and Ending boxes below will either read Starting Period / Ending Period or Starting Date / Ending Date. The default for this option is Period.

If you select the Print Consolidated Ledgers check box, this drop-down is set to Date and is disabled.

Select this check box to exclude accounts with no activity within the date range. If you choose to skip accounts with no activity, your report totals might appear out of balance.

Select this check box to exclude accounts that have a zero balance for the specified time period on the report. If the accounts have a balance, but not in the time period shown on the report, they will not appear on the report. If you choose to skip accounts with zero balance, your report totals might appear out of balance.

Select this check box to include subtotals by month for the included GL Accounts on the report. To run the report without subtotals, deselect the check box. The default for this check box is checked.

Enter the starting and ending period number(s) that you want to include in the report. You can choose any period(s) in your fiscal calendar, from 1 to 60. If you want to include only one period in the report, enter the same number in both the Starting Period and Ending Period boxes. The defaults for these boxes are the Present Period as shown in your fiscal calendar.

When you enter the period number, the first date of the starting period and the last date of the ending period will appear to the right of the corresponding boxes so you can verify that these are the periods you want to include in the report.

(Fund product only) If the Allow multiple fiscal calendars check box is selected in Module Preferences and the fund calendar is different than the organization calendar, the fund’s organization calendar will be used for these dates.

If you select to use Date in the Use box, specify the posting date range of the transactions you want included in the report. To specify a posting from a single date, enter the same date in both boxes. The defaults for these boxes is the system date.

This option is only enabled if you select Date in the Use field on this tab. From the drop-down, select a predefined period to run the report for.  

The check box is only available when the Report Type is Detailed or Detailed Landscape. Select this check box if you want to show posted Cost Center information for each expense account on the report.

You cannot print the report to CSV if you check this box.

If you chose Period in the Use box above, you can specify which year to include in the report by selecting this check box, and then entering the number of years back to print in the Years Back To Print box at the right, which will become activated once the Print Prior Year check box is selected. If you chose Date in the Use box above, this check box is unnecessary and becomes inactive since you will instead specify the year by the date you enter. The default for this check box is unchecked.

If you selected Period in the Use box, and selected the Print Prior Year check box, enter the number of years back that corresponds to the period you want included in the report. For example, if you want to see Periods 1 through 3 of last year, you would enter 1 in the Starting Period box, 3 in the Ending Period box, select the Print Prior Year check box, and enter 1 in the Years Back To Print box.

Select this check box if you want to include inactive accounts on the report. You can mark accounts inactive in the GL Accounts window. If you have a balance in your inactive accounts and you don’t include them on the report, your report might be out of balance.

Select this radio button and enter a filter to use to print a customized report which includes only those accounts that meet the filter criteria.

This check box is only active if you select Combined from the Print All Funds drop-down. Select this check box if you want to sort the included accounts by fund number.

If you selected the Use Account Filter check box, enter a filter to use to specify which accounts to include. Only accounts that match the specified filter criteria will appear on the report. Use wildcards (* and ?) to establish the filter parameters. Substitute a (?) for any single character in the account number, or an (*) for any number of characters. For example, to include all four-digit accounts beginning with a 1, enter 1??? in the Account Filter box. To include all accounts that end in 02, enter *02.

This option is not available if you selected a Drilldown report type. Select this check box to print a report that includes all the accounts in your consolidated organizations.

This check box is enabled if you select the Print Consolidated Ledgers check box. Select this check box to only print accounts that are common to all your consolidated organizations.

This check box is only available if you defined a custom report for this window in Controller. Select this check box if you want to run a custom report instead of the default report. The drop-down is enabled after you select the check box and you can choose the custom report you want to run.