Standard reports list

For a list of standard reports, go to File
, then Print Reports
. The following tables give a summary of the purpose and contents of each report. For an explanation of the various report options, read the Fields and buttons
section of the Print Reports screen help topic.

You can use the application's Report Designer to customize any standard report or to create new firm-level or client-level reports.

note

If a predefined version of a report has been modified and you want to restore it to the default settings, you can choose File > Restore Default from the Report Designer for the selected report.

Depending on your own security profile, you may not be able to access some of the reports listed.

Only staff members who are in security groups with access to the Report Designer are automatically granted access to new reports. You will need to update other security groups to grant permission to access new reports. To do that for each applicable security group:

Go to Setup
, then File Information
.

Choose either Security Groups
or Client Security Groups
.

Select the Reports
tab.

You can go to File
, Page Setup
, then the
Report
tab to select page setup options. The options you select here will modify related options in the Print — Options and Print Reports screens (which you can reach from the File
menu). For details, read our help topic: Making report options available at print time.

To view and print a report:

Select File
, then Print Reports
.

In the Print Reports screen, select one of the reports under a category in the available Reports frame.

note

You can choose from the following categories:Firm
, Accounting, Accounts Payable, Accounts Receivable, Payroll, Workpapers, Financial Statements, and Letters.

Use the Select
button.

Firm reports

Firm reports enable you to include information for multiple clients in a single report.

Report name	Description
Client Check Counts	Lists the client ID, client name, number of Payroll Checks, Vendor Checks, Employee Self-Service Checks, and the Total number of checks per client for all clients within the firm.
Client List	Lists general information about each client set up in the Setup > Clients screen for the firm. The information includes client ID, client name, EIN/SSN, Business Address, and Business Phone.
Engagement Binder Status	Lists engagement binders for all clients in the firm, including the name, type, status, period end date, report release date, completion date, and days remaining.
Impound Bank Account Reconciliation Worksheet	Lists beginning and ending impound bank account balances in transit item detail (for example, checks/deposits that did not clear in prior reconciliations) as well as the cleared and uncleared item detail in the current or finalized reconciliations for each impound bank account.
Impound Client Activity	Lists the client's impound banking activity with amounts that have been funded or withdrawn, per client.
Open Impound Liabilities (Condensed or Detailed)	Lists all open liabilities for impound accounts, for each (funded) client.
Payroll Processing Schedules	Lists detail for each processing schedule currently set up in the application, including due-in date, due-out date, pay dates, time-entry method, pay frequency, client ID and name, and processor ID.
Payroll Tracking Summary	Lists detail for payrolls processed each month by processor, including the totals for each processor. This information is based on the Payroll Tracking portlet that is available in the Firm Dashboard and/or Staff Dashboard.
Sales Tax (Condensed or Detailed)	Lists sales tax information by client for each applicable tax entity (including invoice reference, total sales, non-taxable sales, tax-exempt sales, taxable sales, taxable delivery and discount amounts, net taxable sales, and sales tax due.
Engagement Binder Status	Lists the type of engagement, status, and period end date of all engagement binders. For audit engagements, this report also lists the report release date, completion date, and days remaining in the audit.
Staff List	Lists information for the firm staff, including ID and name, SSN, business address, business phone, and the total staff count.
Tickmark List	Lists all tickmarks that are set up for the firm in the Tickmarks screen.

Accounting reports

Report name	Description
Account Grouping List	Lists all account groupings that are set up for the selected client in the Account Groupings screen.
Account Groupings	Lists account numbers and balances for general ledger accounts, grouped together by account grouping code and subcode.
Account Segments	Lists all account segments for the selected client.
Adjusting Journal Entries	Lists adjusting journal entries for the date or range of dates specified; optionally includes sections for adjusting, reclassifying, tax adjustment, other, potential, and/or tax code journal entries. This report provides a list of all journal entries , but not other types of transactions such as, checks, deposits, payroll checks, and so forth .
Bank Account Reconciliation Transmittal	Provides a reconciliation between the general ledger and the bank statement to enable the client to adjust the checkbook register. note By default, this report includes information such as general ledger, bank summary information, adjustment details and the corresponding description. To exclude them, you can use the Report Designer to make these sections optional. For any user-defined additional information, you can also add new sections or regions as needed.
Bank Account Reconciliation Worksheet	Lists the cleared, open, adjusted transaction information, and totals for the reconciliation of a selected checkbook. note By default, this report includes statement summary information, cleared item detail, bank summary information, open item detail, book summary information, and adjustment item detail. You can exclude any of these regions by clearing the appropriate checkboxes in the Regions to Include section of the Print Reports screen for this report.
Bank Account Register	Lists bank account activity for the date or range of dates and bank account specified and optionally includes the beginning account balance along with a running balance. This report provides a view of the Enter Transactions screen in "bank account" mode and is useful for troubleshooting an unreconciled amount on the bank reconciliation that is caused by a difference between the running bank balance and the General Ledger.
Chart of Accounts (Condensed or Detailed)	Lists information about all accounts set up for the client in the Chart of Accounts screen, which you can reach from the Setup menu. You will get infrmation such as account number, type, and account description. This report provides is useful when you want to import a Chart of Accounts via the spreadsheet import for a new client that requires the same Chart of Accounts as other clients that are set up in the application.
Client Information - Accounting	Lists client information from the Clients screen, which you can reach from the Setup menu. This report provides your clients with an easy way to check the accuracy of their information.
Client Information - Workpapers	Lists client information from the Clients screen, which you reach from the Setup menu. This report provides your clients with an easy way to check the accuracy of their information.
Consolidated Account Groupings	Lists account numbers and balances for GL accounts and groups them together by account grouping code and subcode.
Consolidated Adjusting Journal Entries	Lists adjusting journal entries for the date or range of dates specified. The report optionally includes sections for eliminating, tax adjustment, potential, and/or tax code journal entries.
Consolidated Subsidiary Trial Balance	Displays balance information with a column for each subsidiary (segment code).
Consolidated Trial Balance (Condensed or Detailed)	Lists balances for a selected basis type for each GL account. The detailed version of the report breaks the information into each posting period.
Consolidated Trial Balance Worksheet	Lists account balances and corresponding adjusting entries for a selected basis type.
Deposit List	Lists deposit transactions for the date or range of dates and bank accounts specified and optionally includes distribution detail for each deposit.
Financial Statement Worksheet	Lists general ledger account balances for the Balance Sheet, Income Statement, and Changes in Account Balances to help with financial statement preparation and review.
General Ledger	Lists the beginning balance, current amount, period end amount, and year-to-date adjusted balances for the client's transactions.
General Ledger - Period Subtotals	Lists the beginning balance, current amount, period end amount, and year-to-date adjusted balances for the client's transactions, grouped by posting periods.
Journals	Lists all transactions entered in the Actions > Enter Transactions screen, grouped by journal for a specified date range.
Payment List	Lists payment transactions for the date or range of dates and bank accounts specified and optionally includes distribution detail for each payment.
Tax Code Groupings	Lists the account number and balances that are itemized by the tax code and M-3 tax code. Balances that can be displayed include, unadjusted, adjusted, and tax basis amounts with their corresponding adjusting and tax journal entries for the year. This report enables you to see which tax codes are assigned to which account balances prior to export to UltraTax CS or GoSystem Tax RS.
Tax Code Worksheet	Lists information that can be used to review tax return information for 1120, 1120S, and 1065 clients prior to integrating with a tax application. The format of this report is similar to how information is displayed on a tax return.
Tax Reconciliation Worksheet (Condensed or Detailed)	Lists detailed information for tax code adjustment data entered in the Actions > Enter Tax Code Adjustments screen for a specified year.
Transaction List	Lists all transactions entered in the Actions > Enter Transactions screen for a specified date range.
Trial Balance (Condensed or Detailed)	Lists balances for a selected basis type for each general ledger account. The detailed version of the report breaks the information into each posting period.
Trial Balance (Segmented)	Displays balance information with a column for each segment code combination.
Trial Balance Variance - Five Year Comparison	Compares balances for five years and displays the variance by amount and/or percentage. If you choose to include the Account Grouping region, you may include core accounts, only core accounts, and subcodes in the report.
Trial Balance Variance - Two Year Comparison	Compares balances for two years and displays the variance by amount and/or percentage. If you choose to include the Account Grouping region, you may include core accounts, only core accounts, and subcodes in the report.
Trial Balance Worksheet	Lists account balances for a selected basis type and their corresponding adjusting entries.
Vendor Activity (Condensed or Detailed)	Lists all vendor transactions for the specified date or range of dates.

Accounts Payable reports

To view and print an accounts payable report, choose File > Print Reports. In the Print Reports screen, click one of the reports under Accounts Payable
in the available Reports frame and then click the Select button.

Report name	Description
Aging Schedule (Condensed or Detailed)	Lists open payable aging information for the amounts that are currently due, 1 month overdue, 2 months overdue, 3 months overdue, and over 3 months overdue based on the as of date, discount treatment, aging basis, and period definition specified.
Cash Requirements (Condensed or Detailed)	Lists payable transactions for the date or range of dates specified and displays the amount of cash required for each transaction. Note that this report includes only those payables that are selected in the Manage Payments screen.
Payable and Payment List (Condensed or Detailed)	Lists payable and payment transactions for the date or range of dates specified. The detailed version of the report includes additional transaction information, and optionally includes distributions and applied payments.
Purchases Journal (Condensed or Detailed)	Lists general ledger account balances affected by payable transactions based on the date or range of dates and accounting method specified.

Accounts Receivable reports

Report name	Description
Aging Schedule (Condensed or Detailed)	Lists open payable aging information for the amounts that are currently due, 1 month overdue, 2 months overdue, 3 months overdue, and over 3 months overdue based on the as of date, discount treatment, aging basis, and period definition specified.
Customer Activity (Condensed or Detailed)	Lists all customer transactions for the specified date or range of dates.
Customer List (Condensed or Detailed)	Lists information from the Customers screen for all or selected customers. The condensed version of the report includes only the customer ID, name, EIN/SSN, address, phone, and the customer count (optional).
Invoice and Payment List (Condensed or Detailed)	Lists invoice and payment transactions for the date or range of dates specified. The detailed version of the report includes additional transaction information, and optionally includes items, shipping, sales tax, and applied payments.
Invoice Item List (Condensed or Detailed)	Lists general setup information from the Invoice Items screen for all or selected invoice items. The condensed version of the report includes only the item ID, description, type, price, cost, and tax status.
Sales (Condensed or Detailed)	Lists sales information from customer transactions for the date or range of dates specified. The detailed version of the report includes additional transaction information.
Sales by Item (Condensed or Detailed)	Lists sales information from customer transactions by item for the date or range of dates specified. The detailed version of the report includes additional transaction information.
Sales Tax (Condensed or Detailed)	Lists sales tax information by sales tax item, including total sales, non-taxable sales, taxable sales, taxable shipping, net taxable sales, and sales tax due. The detailed version of the report includes additional transaction information.

Payroll reports

The following payroll reports can be printed on a per-client basis.

Report name	Description
1099 Activity	Lists all 1099 activity per 1099 item for each vendor and provides an audit trail for transaction activity. For details about processing 1009's, see 1099 form setup and processing.
Accruable Benefits	Lists year-to-date information on accruable benefits, such as vacation time and sick time for each employee. note To exclude inactive employees from the report, filter by Status , select is in the Method field, and then select Active in the Selected field.
Allocated Tips	Lists all variables and factors that were used when tips were allocated to the employees during the selected year. The comprehensive report includes the following information for the client: gross tipped sales, required percentage, required tip declaration, indirect tips reported, direct tips required, direct tips reported, and the total amount of tips allocated. The report includes the following information for each employee: ID, name, sales or hours worked, percentage of the total sales/hours, tips required, tips reported, shortfall amount, shortfall percentage, and the amount of tips allocated. note To exclude inactive employees from the report, filter by Status , select is in the Method field, and then select Active in the Selected field.
Average Full-Time Employees Worksheet	Lists the number of full-time employees, the number of full-time equivalent employees, and the total number of full-time employees for each month included in the selected date range, as well as the average number of full-time employees across the selected date range. This worksheet provides useful information for Affordable Care Act reporting purposes.
Average Hours Worksheet	Lists the average number of hours worked for all or selected employees, including the beginning date of the measurement period, the ending date of the measurement period, the number of weeks or months in the measurement period, the number of hours worked, and the average number of hours worked per week or month. This worksheet provides useful information for Affordable Care Act reporting purposes.
Cash Requirements and Deposits	Lists the amount of cash that is needed for each payroll run. The default report data range is the latest check date.
Check List	Lists all payroll and vendor checks for the period that you specify, for all checkbooks or for a selected checkbook. This information is useful for a manual checkbook reconciliation and can include one line for each processed check and a count of the included checks.
Client Information	Lists the information entered for the client in the Setup > Clients screen. In addition to general information, you can choose to include bank account information, federal tax information, and state tax information.
Data Entry Worksheet	Provides a method to gather and verify employee check data from your client. You can use the regular format (with employee data) to speed check entry or the Short Form version (without employee data, available in the Accounting CS Library) to use as an input sheet when adding new employee records. note To exclude inactive employees from the report, filter by Status , select is in the Method field, and then select Active in the Selected field.
Deduction Register	Lists amounts for each deduction item and employer contribution for a selected client on an employee-by-employee basis for the specified date or range of dates. note When the Deduction Register report is selected in the File > Print Reports screen, you can mark the Remaining Balance Details checkbox (in the Sections to Include section) to include a column that shows the deduction amount remaining for each employee.
Depository Totals	Lists summary information on payroll tax amounts - federal depository amounts (including both the employees' withholdings and the employer's expense amounts); unemployment taxes; company matching amounts; state tax withholding amounts; and/or local tax withholding amounts.
EFTPS Payment Worksheet	Provides a summary of information to use for payment of federal business taxes through the Electronic Federal Tax Payment System (EFTPS). The worksheet contains information required on the form, such as the EIN number, PIN, tax form number, filing month and year, payment amount, Social Security amount, Medicare amount, and federal withholding amount excluding earned-income credit. The worksheet also provides fields for entering the settlement date and the EFT acknowledgement number for your records.
EFTPS Phone Payment Worksheet	Provides a summary of information to use when you are making a phone payment for federal business taxes through the Electronic Federal Tax Payment System (EFTPS). The worksheet contains information that you must enter into the phone system for the specific form, such as the EIN number, PIN, tax form number, filing month and year, payment amount, Social Security amount, Medicare amount, and federal withholding amount excluding earned-income credit. The worksheet also provides fields for entering the date and time of the call, the settlement date, and the EFT acknowledgement number for your records.
Employee Affordable Care Act Information	Provides a report of the data currently contained within the 1095-C Part II: Offer and Coverage and 1095-C Part III: Self-Insured dialogs of the Personal Screen (which you can reach from the Setup, the Employees menu). This report provides useful information for Affordable Care Act reporting purposes.
Employee Change History	Lists changes made to employee records within the date range that you select. The report displays the information category, field, previous value, and updated value for all changes to the employee record. Two additional custom date ranges are available for this report: Between last print runs : displays events that occurred between the latest check printing date and the prior check printing date. Since last payroll : displays events that occurred between the latest check printing date and the current system date and time.
Employee Check Record	Lists detailed information for payroll checks that are arranged by month for each employee. The report also provides month-to-date, quarter-to-date, and year-to-date check totals as well as monthly company totals.
Employee Earnings	Lists information about earnings for all or for selected employees, including month-to-date, quarter-to-date, and year-to-date earnings detail. You may choose to sort by Employee ID, Employee Name, or Employee SSN. Amounts are automatically included for all of an employee's pay items, deduction items, and withholding items. In addition, you can choose to display missing W-2 information at the end of the report. This will list employees that have missing, invalid, duplicate, or "applied for" social security numbers and incomplete or missing address information. This report provides useful information for W2 and year-end processing. For details, read our help topic: Payroll year-end processing tips. note To exclude inactive employees from the report, filter by Status , select is in the Method field, and then select Active in the Selected field.
Employee List (Condensed or Detailed)	Lists basic setup information from the Employees screen for all selected employees. The condensed format for this report displays only the employer information, employee ID and name, SSN, home address, home phone, birth date, and hire date. note Note: To exclude inactive employees from the report, filter by Status , select is in the Method field, and then select Active in the Selected field.
FICA Tip Credit Summary	Lists detailed information to help calculate the FICA tip credit for employer Social Security and Medicare taxes paid on employees using special type Tipped Wages pay items. The following details are included in the report for each employee: hours, overtime hours, actual wage, minimum wage, reported tips, tips required to meet the minimum wage, excess wages, and the FICA credit amount.
Garnishment Register	Lists case details and amounts for each garnishment item for a selected client on an employee-by-employee basis for the specified date or range of dates.
Local Payment Form	This form can be used as a replacement payment form, for individual or multiple clients, that can be sent to local tax agents that are not included automatically by the application. The report includes the client's federal EIN, the period end date, the client's address, the total tax due amount for the tax agent, and a blank signature line with a blank date. In the Filtering and Sorting section, you will need to use the filtering fields to select the specific tax agent for whom you want to print the payment form.
Local Tax Worksheet	Lists detailed information about wages and withholdings for localities for a selected client on an employee-by-employee basis, based on check records in the data range specified. This worksheet includes the SSN, employee name, taxable wages for the locality, and the withholding tax.
New Hire List	Lists information on new hires, including employer information, new hire count, employee ID, employee name, employee SSN, home address, hire date, added date, and reported confirmation. note Note: To exclude inactive employees from the report, filter by Status , select is in the Method field, and then select Active in the Selected field.
Open Liabilities (Condensed or Detailed)	Lists all open liabilities for accounts for each funded client.
Payroll Department Summary	Lists detailed information for each unique pay date as well as month-to-date totals per payroll department. The report also provides month-to-date, quarter-to-date, and year-to-date totals across all locations and departments. For information on and examples of the automatic allocation of payroll item amounts, please refer to the Location/Department allocation of payroll items and taxes topic.
Payroll Item List (Condensed or Detailed)	Lists general setup information from the Setup > Payroll Items screen for all or selected payroll items. The condensed version of the report displays only the description, report description, and calculation type.
Payroll Journal (Condensed or Detailed)	Lists detailed information for all or selected payroll checks for the specified date or range of dates. The condensed format for this report does not include sales, company expenses, or direct deposit distributions.
Payroll Journal Entry	Lists the export content of the payroll journal entry for the selected client.
Payroll Journal with Detailed Hours	Lists detailed information for all or selected payroll checks for the specified date or range of dates. It includes detailed hours for regular, overtime, double time, and accruable benefits used.
Payroll Journal with Taxable Wages	Lists detailed information for all or selected payroll checks for the specified date or range of dates. It includes itemized withholding taxes with the corresponding taxable wages. This report provides useful information for 941, W2 and year-end processing.
Payroll Schedules	Lists the following scheduled dates that have been set up for the client: time in, period beginning date, check date, and checks-out date.
Payroll Tax Summary (Condensed or Detailed)	Lists the client totals for the various payroll taxes, which are calculated based on information derived from the employee earnings records. The following amount columns are included in the detailed version of the report for each employee and for the company as a whole: tax type, rate; wage limit; quarter-to-date gross taxable wages, taxable wages, and tax; and year-to-date gross taxable wages, taxable wages, and tax. This report provides useful information for 941, W2 and year-end processing.
Preprocessing Summary	Lists detailed information about, and the amount of cash required for, all pending payroll checks in a suspended batch for the purpose of verifying information in the batch.
State Employer Tax Worksheet	Lists detailed information about wages for state employer taxes for a selected client on an employee-by-employee basis, based on check records in the data range you specify. This worksheet includes the SSN, employee name, gross taxable wages, taxable wages, and excess wages for the state employer tax.
State Tax Worksheet	Lists detailed information about wages and withholdings for state taxes for a selected client on an employee-by-employee basis, based on check records in the data range you specify. This worksheet includes the SSN, employee name, taxable wages for the state tax, and the withholding tax. This report provides useful information for state form processing.
Tax Deposits	Lists tax deposit information for all tax items, enabling you to view the upcoming deposits that are required and those that have already been made for a specified date range.
Unprinted Payroll Checks	Lists payroll checks that have not yet been printed and includes the following items for each check: pay description, hours and amounts, itemized withholding taxes and amounts, and itemized deductions and amounts.
Unprinted Vendor Checks	Lists vendor checks that have not yet been printed and optionally includes distribution detail for each check.
Vendor Activity (Condensed or Detailed)	Lists all vendor transactions for the specified date or range of dates.
Vendor List (Condensed or Detailed)	Lists information from the Setup > Vendors screen for all or selected vendors. For the detailed version of the report, you may optionally include the vendor count, 1099 properties, distributions, and/or payment preferences. The condensed version of the report includes the vendor ID, name, EIN/SSN, address, phone, and the vendor count (optional).
W-2 Verification	Lists W-2 information by box number for all or selected employees for the specified year. The report provides a method to verify W-2 information prior to processing W-2 forms.
Wage Register	Lists hours and amounts for each pay item for a selected client on an employee-by-employee basis for the specified date or range of dates.
Workers' Compensation (Condensed or Detailed)	Lists all workers' compensation calculations that were created during data entry of check information. This report enables employers to review calculations made in the application that can be provided to Workers' Compensation insurers during annual audit procedures. For more information, read our help topic: Workers' compensation, overview. The detailed version of the report includes a comprehensive list of the following variables and factors used in the calculation of premiums: employee name, WC code, gross wages, excluded wages, OT/DT premium, subject amount, WC rate, premium amount, and adjust premium amount. The condensed version of the report includes the following items: employee name, WC code, subject amount, WC rate, and premium amount.

Workpapers reports

Report name	Description
Engagement Binder List	Lists engagement binders in a tree structure, similar to how they appear in the Engagement Binders Tree portlet, including the note count, workpaper staff assignments, and signoffs for each workpaper.
Notes List	Lists notes for engagement binders, folders, and workpapers, including the staff who created or replied, the date and time, the assigned staff, and the status.
Workpapers List	Lists workpapers of engagement binders, including the reference, name, note count, assigned staff, and signoffs.

Financial statements

Report name	Description
Account Analysis	Provides two-year comparison statements (one that includes a percentage column, and one that does not).
Balance Sheets	Lists assets for the current year, current year-prior year, current year-two column, and current year-summary statements.
Cash Flow statements	Lists cash flow information for different categories of activity in different periods.
Footnotes	Provides a template that you can use to include notes about such items as accounting policies and/or other notes that are associated with the compiled statements for your client.
Income statements	Lists income comparisons for various periods, budget variances, percent comparisons, and multi-trend analyses.
Retained Earnings statements	Lists retained earnings and budget amounts for various combinations of periods, current year and/or prior years.
Standard Financial Ratios	Provides an analysis of the current client based on four standard ratios.

Letters

Report name	Description
Compilation Letters	This template letter can be used as a notification and confirmation to the client that the related statements have been compiled in compliance with applicable accounting standards and official accounting services and institutions.
Form Filing Instructions	This template document provides reporting instructions for financial reports and statements.
Review Letters	This template letter is a confirmation of review in compliance with applicable accounting standards and official accounting services and institutions, with a description of the scope of the review.

This article applies to:

Product: Accounting CS
Subject: Reports

Recommended Products

Recommended Products

Recommended Products

Recommended Products

Who We Serve

Services

Platforms

Media Solutions

About

Recommended Products

Recommended Products

APIs by industry

Use case library

Related sites

United States Support

International support

New releases

Join a TR community

Free trials & demos

Standard reports list

Firm reports

Accounting reports

Accounts Payable reports

Accounts Receivable reports

Payroll reports

Workpapers reports

Financial statements

Letters

This article applies to:

Related content