Standard Report - Cash Requirement

This report outlines the liabilities and cash needed to process payroll, helping ensure accurate and timely payroll management.

Understanding payroll cash requirements is crucial for financial planning and maintaining sufficient liquidity for payroll obligations.

Efficiency Drivers:

• Group By Options: Customize the report by staffing company, branch, or none to better analyze payroll costs.
• Detailed Sections: Breaks down earnings, deductions, taxes, net pay, and employer contributions to provide a comprehensive view of payroll expenses.

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
   
   

Actionable Insights:

• Monitor Tax Liabilities and Adjustments: Stay updated on changes, like new taxes, to ensure compliance and avoid unexpected costs.
• Review Payroll Deductions Regularly: Ensure deductions and contributions are accurate for both employees and employers.

Leveraging the Cash Requirement Report enables better financial planning, accurate payroll processing, and compliance with tax regulations.