[Reports & Analytics (CLASSIC)] Standard Report - Taxes Summary Lite (DRAFT)

October 02, 2026 17:32

Purpose

The Taxes Summary Lite Report provides a streamlined, supplier-focused view of payroll tax calculations and withholdings. This lightweight version of the full Taxes Summary Report groups tax data by supplier and state, making it ideal for quick reviews, client reporting, and FFCRA tax credit tracking.

Why It Matters

For staffing companies managing multiple clients, this report streamlines tax reporting by organizing data at the supplier level, providing clear subtotals. The built-in FFCRA tax credit calculations help you track pandemic-related tax relief benefits, ensuring accurate credit claims and reducing manual calculation time. This focused view accelerates client billing reconciliation, streamlines quarter-end reviews, and ensures clean data exports for client tax reporting requirements.

Efficiency Drivers

Supplier-Focused Organization: Tax data automatically groups by supplier with clear subtotals, eliminating the need to manually segment data for multi-client operations.
Built-In FFCRA Calculations: Automatic computation of FFCRA Sick Leave, Emergency FMLA, and employer tax credits (Medicare and FICA) saves calculation time and reduces errors in claiming pandemic-related tax relief.
Streamlined Output: Lighter data structure than the full Taxes Summary Report makes this ideal for quick checks, client presentations, and situations where detailed employee-level data isn't needed.
State-Level Grouping: Tax information organized by state within each supplier simplifies multi-state tax reporting and helps identify jurisdiction-specific obligations at a glance.

Common Use Cases:

Client Tax Reporting: Generate clean, supplier-specific tax summaries for client billing packages or quarterly reports
FFCRA Credit Verification: Quickly review qualified wage amounts and calculate available tax credits for pandemic-related leave
Multi-Client Operations: Review tax obligations across multiple staffing clients without getting overwhelmed by employee-level detail
Quick Tax Validation: Verify tax calculations at a high level before diving into detailed reports
Quarter-End Client Reviews: Provide clients with summarized tax information for their records
State Tax Obligation Tracking: Identify tax liabilities by state for clients operating in multiple jurisdictions

Special Logic

Report Organization:

Supplier Separation: The report displays one supplier per page, with all tax information for that supplier grouped together
Two Summary Levels:
- Supplier Total: Shows total amounts under different tax names for the specific supplier (displayed at the bottom of each supplier section)
- Grand Total: Shows cumulative amounts across all suppliers in the report (displayed at the very end)

Excluding Unposted Payroll Batches:

The Exclude Unposted Batch parameter controls whether payroll batches that have been processed but not yet posted (no Posted Date) are included in the report. When set to True, unposted batches are removed from the results regardless of which Date Type (Check Date or Accounting Period Date) is selected – useful when determining daily or period-end tax liability (for example, Form 941 deposits) so totals reflect only finalized, posted payroll data. When set to False (default), the report includes all batches within the selected date range, matching prior report behavior.

FFCRA Tax Credits Display: When "Show FFCRA Tax Credits" is set to True, a separate summary box appears above each supplier's tax totals showing:

FFCRA - Sick Leave (total qualified sick leave wages)
FFCRA - Emergency FMLA (total qualified FMLA wages)
FFCRA MED ER CREDIT (1.45% of qualified wages - Medicare employer portion)
FFCRA FICA ER CREDIT (6.2% of qualified wages - Social Security employer portion)
Total (sum of all FFCRA tax credits available)

These credits represent the employer's ability to offset payroll tax deposits with qualified leave wages paid under FFCRA/ARPA provisions.

Parameters

Parameter Name	Options	Description & Use Case
Supplier	All available Suppliers	Select specific client(s) or "All" to include all suppliers. Use individual supplier selection when generating client-specific tax reports.
Branch	All available Branches	Filter by branch location within the selected supplier. Note: Only branches belonging to the selected supplier will appear in the list. Use when clients need branch-level tax reporting.
Date Type	Accounting Period Date, Check Date	Choose the date that determines which paychecks are included: • Check Date = When checks were issued (most common for tax remittance timing) • Accounting Period Date = When wages were earned (for accrual-based accounting)
Start Date	Calendar date selector	Beginning of reporting period. Typically set to the first day of the quarter or year you're reviewing.
End Date	Calendar date selector	End of reporting period. Together with Start Date, defines your tax reporting timeframe.
Show FFCRA Tax Credits	True, False	Set to True to display pandemic-related tax credit calculations above supplier totals. Use this when claiming FFCRA/ARPA employer tax credits on Form 941. Set to False for standard tax reporting without FFCRA details.
Show Local Taxes	True, False	Set to True to include local/municipal tax jurisdictions in the report. Set to False to show only federal and state taxes. Use True when working with clients in areas with local income taxes (PA, OH, IN, etc.).
Exclude Unposted Batch	True, False	Set to True to exclude payroll batches that have been processed but not yet posted (no Posted Date) from the report, regardless of the Date Type selected. Use this when determining daily or period-end tax liability (for example, Form 941 deposits) so totals reflect only finalized, posted payroll data. Set to False (default) to include all batches within the selected date range, matching prior report behavior.

Report Fields

Field Name	Description	Notes
Supplier Information
Staffing Company	Client/supplier name	Report sections are organized by supplier
FEIN	Federal Employer Identification Number	The supplier's EIN used for payroll tax filing
Tax Grouping
Tax State	State jurisdiction for the tax	Report groups taxes by state within each supplier section
Resident Tax	Resident vs. Non-Resident designation	Appears as a subheading under Tax State; blank if no resident tax distinction applies
Tax Name	Specific tax identifier	Examples: AR SUI ER, CA WH, FICA EE, FICA ER, Federal Income Tax
Wage Calculations
Gross Wages	Total wages earned before any deductions	Full employee compensation for the period
Subject Wages	Wages subject to this specific tax	May differ from Gross due to exemptions, caps, or pre-tax deductions
Taxable Wages	Wages on which tax was actually calculated	Final amount after all adjustments and exclusions
Tax Amount	Total tax calculated and withheld/accrued	The actual liability amount for this tax type
FFCRA Tax Credits (when Show FFCRA Tax Credits = True)
FFCRA - Sick Leave	Total qualified sick leave wages paid	Includes: • FFCRA - Employee (original provision) • FFCRA - ARPA Employee (effective 4/1/21) • FFCRA - Dependent Care • FFCRA - ARPA Dependent (effective 4/1/21)
FFCRA - Emergency FMLA	Total qualified Emergency FMLA wages paid	Includes: • FFCRA - Emergency FMLA (original) • FFCRA - ARPA FMLA (effective 4/1/21)
FFCRA MED ER Credit	Medicare employer tax credit (1.45% of qualified wages)	Credit for employer's share of Medicare tax on FFCRA wages
FFCRA FICA ER Credit	Social Security employer tax credit (6.2% of qualified wages)	Credit for employer's share of Social Security tax on FFCRA wages
Total FFCRA Tax Credit	Sum of all FFCRA credits	Amount that can be used to offset federal payroll tax deposits

Understanding FFCRA Credits:

The FFCRA (Families First Coronavirus Response Act) and ARPA (American Rescue Plan Act) allowed employers to claim refundable tax credits for providing COVID-19 related paid sick leave and family leave. The credits include:

The full amount of qualified leave wages paid
The employer's share of Medicare tax (1.45%) on those wages
The employer's share of Social Security tax (6.2%) on those wages

These credits are claimed on Form 941 and can be used to reduce payroll tax deposits or claimed as refunds.

Actionable Insights

For Client Reporting:

Run the report for a single supplier at the end of each quarter
Set Show FFCRA Tax Credits = False unless the client specifically needs this information
Export to PDF or Excel for clean client deliverables
Use the Supplier Total section as a summary for client invoices or tax documentation

For FFCRA Credit Claims:

Run the report quarterly with Show FFCRA Tax Credits = True
Verify the FFCRA credit totals match your Form 941 worksheets
Cross-reference qualified wage amounts with payroll records
Document which employees received FFCRA leave for audit purposes

For Multi-State Operations:

Review the state groupings within each supplier section
Ensure all states where the client has employees are represented
Check for proper resident/non-resident tax designations
Verify state-specific withholding amounts align with state rate tables

When to Use Taxes Summary Lite vs. Full Taxes Summary:

Use Lite when you need quick supplier-level summaries, client reporting, or FFCRA credit verification
Use Full when you need employee-level detail, deep audit trails, or comprehensive tax reconciliation

Best Practices:

Run this report monthly for each major client to catch discrepancies early
Compare Supplier Totals against client billing to ensure tax charges are accurate
Keep quarterly versions on file for each client to support tax filing questions
Use the Grand Total section when preparing consolidated reports for corporate leadership
Set Exclude Unposted Batch = True before finalizing daily or period-end tax liability figures, so results aren't inflated by processed-but-unposted batches