Report Designer: Options for accounting reports

Alerts and notices
Leave feedback

Internal Employees: Submit feedback

Contact information (optional):

Leave this blank:

Please tell us how we can make this information more helpful.


Characters left:

Change to CS Support service hours

Our Support department is closed on Friday, April 28th for a company event. However, limited Accounting CS phone support is available on that date from 9 AM - 5 PM ET due to the approaching deadline for quarterly payroll tax forms.

Links to our most popular payroll tax processing topics are available in the Alerts and notices section on the right side of most pages.

You can select options on the Report tab of the File > Page Setup dialog to modify related options in the File > Print - Options dialog in the Report Designer and in the File > Print Reports screen.

Select an accounting report in the Report Designer, choose File > Page Setup, and click the Report tab.

See also: Making report options available at print time

Selecting header, footer, and date options

  1. Choose how you want the header or footer to print on the selected accounting report. The drop-down list includes options to print on every page, on the first page only, on all but the first page, or on the first page with alternate on subsequent pages.
  2. Select the date type and specific date options to make them available in the drop-down list for the selected report.

    Note: The type of dates that are available vary based on the report type. For example, accounting reports include standard dates, bank account statement dates, and accounting dates.

Selecting options for accounting reports

The following options for accounting method, filtering and sorting, journal entry treatment, and implied filtering apply to the selected report.

The implied filter is the default setting that can be overridden in the File > Print > Options dialog.

Mark the Accounting method checkbox to create an optional section in the File > Print > Options dialog that enables you to select an accounting basis (Client, Accrual, or Cash) for reports that include accounts payable and/or accounts receivable general ledger activity.

Note: The accounting basis can be set up in the Setup > Clients > Accounts Payable tab and/or the Setup > Clients > Accounts Receivable tab to be used as the default for reports that use the Client basis and reports that depend on a basis, but do not offer the accounting method options at print time.

Mark the Balance basis checkbox to create an optional section in the File > Print > Options dialog that enables you to select a Balance Basis (Adjusted, Report, Tax, and Other).

Note: Basis types that are applied to amounts in a report or financial statement in the Report Designer via the Design Tools frame are not overwritten with the basis that is selected in the Print – Options dialog at print time.

Mark the checkboxes for the data sources to include in the File > Print > Options dialog when you print the selected report.

Note: The Bank Account data source is available by default. All other data sources vary based on the variables that are inserted on the selected report. For example, for a report that includes client variables, the Client checkbox is displayed in the Filtering and Sorting Options section.

Mark the appropriate checkbox for the payroll, accounts payable, and/or accounts receivable journal entry treatment options to include the corresponding summarizing options in the File > Print > Options dialog when you print the selected report. (For example, if you mark the Accounts Payable checkbox, the option to summarize the accounts payable account and the option to summarize accounts payable journal entries on the selected report is available.)

The options you choose here determine the default filtering options that are available at print time in the Filtering and Sorting section of the File > Print > Options dialog for the selected report.

Note: You can override certain implied filtering options in the Filtering and Sorting section of the File > Print > Options dialog when you print the selected report.

For general ledger accounts

  • None. Applies no default filtering so that all general ledger accounts are displayed.
  • Non memo accounts. Filters out memo-type accounts so that only non-memo type accounts are displayed.

For vendor transactions

  • None. Applies no default filtering so that all vendor transactions are displayed.
  • AP transactions only. Filters out payroll-related vendor transactions so that only accounts payable transactions are displayed.
  • PR transactions only. Filters out transactions so that only payroll-related vendor transactions are displayed.

The options you choose here determine the default checks and transactions (based on their status) that are included when you print the selected report.

Note: You can override certain implied filtering options in the Filtering and Sorting section of the File > Print > Options dialog when you print the selected report.

For checks

  • None. Applies no default filtering so that all checks (regardless of status) are displayed.
  • Standard. Filters out voided, deleted, pending, and unprinted checks so that only standard, live checks are displayed.
  • Unprinted. Filters out checks with any status but unprinted so that only unprinted checks are displayed.
  • Pending. Filters out checks with any status but pending so that only pending checks are displayed, meaning checks that originate from a suspended batch in the Actions > Enter Batch Payroll Checks screen.

For transactions

  • None. Applies no default filtering so that all transactions (regardless of status) are displayed.
  • Standard. Filters out voided and deleted transactions so that only standard, live transactions are displayed.

For vendor transactions

  • None. Applies no default filtering so that all vendor transactions (regardless of status) are displayed.
  • Open. Filters out vendor transactions with any status but open so that only open vendor transactions are displayed.
  • Closed. Filters out vendor transactions with any status but closed so that only closed vendor transactions are displayed.
  • Standard. Filters out voided and deleted vendor transactions so that only standard, live vendor transactions are displayed.
  • Pending. Filters out vendor transactions with any status but pending so that only pending vendor transactions are displayed, meaning vendor transactions that are selected to pay in the Actions > Manage Payments screen.

For liabilities

  • None. Applies no default filtering so that all liabilities (regardless of status) are displayed.
  • Open. Filters out liabilities with any status but open so that only open liabilities are displayed.
  • Closed. Filters out liabilities with any status but closed so that only closed liabilities are displayed.
  • Standard. Filters out voided and deleted liabilities so that only standard, live liabilities are displayed.

For customer transactions

  • None. Applies no default filtering so that all customer transactions (regardless of status) are displayed.
  • Open. Filters out customer transactions with any status but open so that only open customer transactions are displayed.
  • Closed. Filters out customer transactions with any status but closed so that only closed customer transactions are displayed.
  • Standard. Filters out voided and deleted customer transactions so that only standard, live customer transactions are displayed.

For payroll checks

  • None. Applies no default filtering so that all payroll checks (regardless of impound status) are displayed.
  • Pending. Filters out payroll checks with any impound status but pending so that only pending impound status payroll checks are displayed.
  • Funded. Filters out payroll checks with any impound status but funded so that only funded impound status payroll checks are displayed.
  • Not applicable. Filters out all payroll checks with an impound status so that only non-impound payroll checks are displayed.

For vendor checks

  • None. Applies no default filtering so that all vendor checks (regardless of impound status) are displayed.
  • Pending or Funded. Filters out non-impound vendor checks so that only vendor checks with a pending or funded impound status are displayed.
  • Not applicable. Filters out all vendor checks with an impound status so that only non-impound vendor checks are displayed.

For payroll liabilities

  • None. Applies no default filtering so that all payroll liabilities (regardless of impound status) are displayed.
  • Pending. Filters out payroll liabilities with any impound status but pending so that only pending impound status payroll liabilities are displayed.
  • Funded. Filters out payroll liabilities with any impound status but funded so that only funded impound status payroll liabilities are displayed.
  • Not applicable. Filters out all payroll liabilities with an impound status so that only non-impound payroll liabilities are displayed.

Related topics

Making report options available at print time

Reporting and Report Designer: Procedures

Standard reports list

Top of page

Share This