Standard Report - Cash Requirement

Overview

Updated 06/16/2021

Report Description
Parameters
Report Fields
    Group By Parameter
Troubleshooting

Report Description

Details liabilities and the amount of cash needed to process payroll.

Parameters

Parameter Name	Options	Explanation
Date Type	Check Date, Accounting Period Date	Paycheck’s Accounting Period or Week Worked.
Group By	Staffing Company, Branch, None
Start Date
End Date
Branch	All available branches

Report Fields

Section: Employee Earnings
Field Name	Explanation
Pay Code	Show taxable transaction type associated with W2 employees
Amount	Sum itempay of taxable transaction type for those transactions which is isw2=1 and itempay<>0
Section: Agency Earnings
Pay Code	Show the transaction type in which the employee had worked.
Amount	Sum itempay of each transaction type for those transactions which is isw2=0 and itempay<>0.
Section: On Time Adjustments
Pay Code:	Show non-taxable transaction type associated with the w2 employee.
Amount:	Sum itempay of nontaxable transaction type for those transactions which is isw2=1 and itempay<>0
Section: Deductions
Deduction Name	Show the transaction type in which deduction has been cut off.
Amount	Sum of deduction amount that has been deducted from paychecks.
Section: Tax Liability
Tax Name	Show the tax name
Amount	Sum of employee tax amount that has been cut off from paychecks.
Section: Net Pay
Columns	Employee Net Pay, 1099 Employee Net Pay, Agency Net Pay, Deduction Agency Net Pay.
Amount	Sum of the net amount of checks for each column type like .
Section: Employer Contributions
Contribution Name	Show the transaction type in which the benefit has been cut off.
Amount	Sum of Benefit amount that has been deducted from paychecks.
Section: Worker Compensation
Worker Comp	Sum of Worker Comp Cost. See Wc Code Tab (Worker's Compensation) to learn more on how Avionte calculates worker comp Cost.
Section: Employer Taxes
Pay Code	Show the tax name.
Amount	Sum of employer taxes amount that has been cut off from paychecks.

Group By Parameter

• Staffing Company
  • Shows data based on supplier. And shows supplier text box in design.
• Branch
  • Shows data based branch. And shows both supplier and branch text boxes in design.
• None
  • Shows data based on nothing.  And hides both supplier and branch text boxes in design.

Troubleshooting

A recent Tax has been added for Minnesota clients:

• Minnesota Federal Loan Assessment (MN FEDERAL LOAN ASSMNT)
  
  
  
  

This is used for informational purposes only.  This Tax can be inactivated.

1. Click on Admin Tools
   
   
   
   
2. Click on Employer
3. Click on the appropriate Employer/Supplier
   
   
   
   
4. Click on Tax Tab
   
   
   
   
5. Click on Tax Staffing Supplier Tab
6. Find the MN FEDERAL LOAN ASSMNT Tax
7. Click the checkbox for IsActive
8. Click Save
   
   

Back to Top