(Payroll) Tax Liability Report

How do I

Tax Liability report shows the employee's gross pay, taxable (adjusted) gross, the amount of tax withheld, and the total tax liability for a specified type of payroll deduction: FICA, FUTA, MEDICARE, and so on. The report lets you see at a glance your payroll tax liabilities; this information can help you fill out employment tax forms and make federal tax deposits.

Note: This report uses payroll formulas to calculate the amounts. You must subscribe to a Sage Business Care plan in order to use payroll formulas to run this report. Otherwise, the report will not show any data. You may run this report for any years in which you had a subscription to a Sage 50 Payroll Solution even if you are not currently subscribed.

Options

Select the Options button to determine the data criteria for the reports you want to see or print. For this report Sage 50 displays the following filter options:

  • Date: You have the choice of All, Range, Today, This Period, This Quarter, This Year, and the week, month, period, quarter, and year to date. If you select range, you can enter a beginning and ending date.

Important! As your range of dates, you must choose dates that fall within the two open payroll years.

  • Sort by: You can sort by employee ID or employee name.
  • Select a filter: First, select a filter on the left. Then, define the options for that filter on the right. The options differ based on the filter selected. Tell me more about the types of filter options.
  • Tax: Select the payroll tax you want to see.
  • State: Choose All to see all state taxes you withhold for your employees. To see withholding taxes for an individual state, select it from the drop-down list.

Note: If you have chosen either All or Federal in the Taxfield, then the Statefield will not be available.

Columns

Select the Columns link to choose which data fields to include and where the columns break on your report. Tell me more about choosing report fields.

Note: We mask the first five digits of Social Security numbers to help guard against unauthorized viewing. You can click Columns and choose to Show the entire number.

Fonts

Select the Fonts link to set the font styles for the heading and body of the report. You can also have the titles of the report show special codes, such as the current period, today's date, an as-of date, and the company name. Tell me more about formatting reports.

What do you want to do next?