Standard reports list

Show expandable text

We moved!

Help articles have been migrated to the new Help and Support. You can find help for your products and accounts, discover FAQs, explore training, and contact us!

What follows is a list of standard reports available from the File > Print Reports screen and includes a short explanation of the purpose and contents of each report. For an explanation of the various report options, see the Fields & buttons section of the Print Reports screen topic.

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

Notes

Firm reports

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

To view and print a Firm report, choose File > Print Reports. In the Print Reports screen, click one of the reports under Firm in the available Reports frame and then click the Select button.

Client Check Counts Lists the client ID, client name, number of Payroll Checks, Vendor 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

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

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 Setup > Chart of Accounts screen, 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 Setup > Clients screen. This report provides your clients with an easy way to check the accuracy of their information.
Client Information - Workpapers Lists client information from the Setup > Clients screen. 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.

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

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

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

To view and print a Payroll report, choose File > Print Reports. In the Print Reports screen, click one of the reports under Payroll in the available Reports frame and then click the Select button.

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

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 Setup > Employees > Personal screen. 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, and 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, see 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: 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: 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. (See also: 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

To view and print workpapers reports, choose File > Print Reports. In the Print screen, click one of the reports under Workpapers in the available Reports frame and then click the Select button.

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

To view and print Financial Statements, choose File > Print Reports. In the Print screen, click one of the statements under Financial Statements in the available Reports frame and then click the Select button.

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

To view and print letters, choose File > Print Reports. In the Print screen, click one of the Letters under Letters in the available Reports frame and then click the Select button.

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.

Was this article helpful?

Thank you for the feedback!