Standard reports list (Client Access)

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:

This topic lists the standard reports available from the File > Print Reports screen and includes a short explanation of the purpose and content of each report. For an explanation of the various report options, see the Fields & buttons section of the Print Reports screen topic.

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

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.

Note: These reports are available when you have the Accounting CS license installed.

Provides a reconciliation between the general ledger and the bank statement to enable you to adjust the checkbook register.

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.

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. The detailed version of the report also lists the account classification and tax code columns.

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 deposit transactions for the date or range of dates and bank accounts specified and optionally includes distribution detail for each deposit.

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

Note: These reports are available when you have the Accounting CS license installed.

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.

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 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. It includes 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 Detailed format (with employee data) to speed check entry or the Short Form version (without employee data) 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. The report uses information derived from processed check records.

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. In addition to the report date ranges available for most payroll reports, 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.

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.

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.

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 from the latest check date. The condensed format for this report does not include itemized withholding taxes and company expenses.

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.

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.

Lists detailed information about, and the amount of cash required for, all pending payroll checks in a suspended batch for the purpose of verifying the batch.

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

Financial statements

Note: The following financial statements are available when you have the Accounting CS license installed.

Related topics

Printing reports

Accounts payable process workflow

Accounts receivable process workflow

Share This