Standard reports list

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.

This topic lists the 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

Special information for standard reports

Refer to the following guides for a detailed report comparison between most of the reports in the CS Professional Suite Accounting (CSA) and Accounting CS.

Accounting CS Report Options Comparison with Write-Up CS and Trial Balance CS (PDF)

Accounting CS Payroll Report Options Comparison with Payroll CS (PDF)

Workpapers CS Report Options Comparison with Engagement CS (PDF)

Top of page

Firm reports

Firm reports in 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.

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.

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.

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.

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.

Lists the client's impound banking activity with amounts that have been funded or withdrawn, per client. 

Lists the description, type, date, amount, and total of the impound write-off activity for a selected client in a specified period.

Lists all open liabilities for impound accounts, for each (funded) client.

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.

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.

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.

Lists information for the firm staff, including ID and name, SSN, business address, business phone, and the total staff count.

Lists all tickmarks that are set up for the firm in the Tickmarks screen.

Top of page

Accounting reports

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

Lists all account groupings that are set up for the selected client in the Account Groupings screen.

Lists account numbers and balances for general ledger accounts, grouped together by account grouping code and subcode.

Lists all account segments for the selected client.

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.

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.

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.

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.

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.

Lists client information from the Setup > Clients screen. This report provides your clients with an easy way to check the accuracy of their information.

Lists client information from the Setup > Clients screen. This report provides your clients with an easy way to check the accuracy of their information.

Lists account numbers and balances for GL accounts and groups them together by account grouping code and subcode.

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.

Displays balance information with a column for each subsidiary (segment code).

Lists balances for a selected basis type for each GL account. The detailed version of the report breaks the information into each posting period.

Lists account balances and corresponding adjusting entries for a selected basis type.

Lists deposit transactions for the date or range of dates and bank accounts specified and optionally includes distribution detail for each deposit.

Lists general ledger account balances for the Balance Sheet, Income Statement, and Changes in Account Balances to help with financial statement preparation and review.

Lists the beginning balance, current amount, period end amount, and year-to-date adjusted balances for the client's transactions.

Lists the beginning balance, current amount, period end amount, and year-to-date adjusted balances for the client's transactions, grouped by posting periods.

Lists the beginning balance, current debit and credit amounts, period end amount, and year-to-date adjusted balances for the client's transactions.

Lists all transactions entered in the Actions > Enter Transactions screen, grouped by journal for a specified date range.

Lists payment transactions for the date or range of dates and bank accounts specified and optionally includes distribution detail for each payment.

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.

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.

Lists detailed information for tax code adjustment data entered in the Actions > Enter Tax Code Adjustments screen for a specified year.

Lists all transactions entered in the Actions > Enter Transactions screen for a specified date range.

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.

Displays balance information with a column for each segment code combination.

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.

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.

Lists account balances for a selected basis type and their corresponding adjusting entries.

Lists all vendor transactions for the specified date or range of dates.

Top of page

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.

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.

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.

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.

Lists general ledger account balances affected by payable transactions based on the date or range of dates and accounting method specified.

Top of page

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.

Lists open invoice 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.

Lists all customer transactions for the specified date or range of dates.

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).

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.

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.

Lists sales information from customer transactions for the date or range of dates specified. The detailed version of the report includes additional transaction information.

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.

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.

Top of page

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.

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.

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.

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.

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.

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.

Lists the amount of cash that is needed for each payroll run. The default report data range is the latest check date.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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 FAQs (PDF).

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.

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.

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.

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.

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.

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.

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.

Lists all open liabilities for accounts for each funded client.

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.

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.

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.

Lists the export content of the payroll journal entry for the selected client.

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.

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.

Lists the following scheduled dates that have been set up for the client: time in, period beginning date, check date, and checks-out date.

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.

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.

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.

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.

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.

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.

Lists vendor checks that have not yet been printed and optionally includes distribution detail for each check.

Lists all vendor transactions for the specified date or range of dates.

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).

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.

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.

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.

Top of page

Workpapers reports

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.

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.

Lists workpapers of engagement binders, including the reference, name, note count, assigned staff, and signoffs.

Financial statements

Top of page

Letters

Top of page

Related topics

Making report options available at print time

Reporting and Report Designer: Procedures

Accounts payable process workflow

Accounts receivable process workflow

Share This