cancel
Showing results for 
Search instead for 
Did you mean: 
dfasolo
Level 1

FTE Calculations

Does QuickBooks have reports that can be run to calculate the full time equivalent numbers we need for the PPP calculations?

5 Comments
SashaMC
Moderator

FTE Calculations

Thank you for sharing your concerns with the Quickbooks Community,dfasolo. To better assist you, could you tell me the version of Quickbooks you are using (i.e. Online or Desktop)? This report can be achieved by running a payroll summary report. This report would show the hours for each employee during a specific period. Depending on the payroll subscription you may have, I have recommended this link on how to run a payroll summary report. If you need any additional assistance, please leave a comment below.

SBConst
Level 1

FTE Calculations

I am running Quickbooks Enterprise 2019 Contractor edition.  We need the FTE hours calculations in order to complete the PPP loan forgiveness report.  It would be great it Quickbooks would set up a template for what is required and make it available to the users.

ZackE
QuickBooks Team

FTE Calculations

Hello, SBConst.
 

Quickbooks has an exact template to meet your needs! You’ll want to run a Total Hours a Worked by Employee Report, which pulls the information from your books to generate that document. Here’s how:
1. In the menu bar at the top, go to Reports, Employees & Payroll, then Payroll Item Detail.
2. Hit Customize Report.
3. Open the Display tab. In the Columns list, pick Qty.
4. In the Total By area, click on Employee.
5. Access the Filters tab and tick Payroll Item in the Filter list.
6. Choose the specific item associated from the drop-down menu. If there's more than one type of hourly payroll item, go with the Multiple payroll items option.
7. Select Ok.
8. Adjust the date range as needed.
 

Now you''ve produced a total hours worked by employee report which will display the FTE hours worked by an employee on a full-time basis.
 

Here's a few resources that may come in handy while seeking forgiveness for your PPP loan:


You can reach out to me here if you have any questions. Enjoy the rest of your day!

VictoriaLaguna
Level 1

FTE Calculations

Hi 

 

I have a question about FTE calculations report. So FTE report is requested weekly for the January 1st 2020 and weekly at the end of covered period that for me is October 16th, 2020. My payroll is biweekly so how do i do my final calculations ? Just the export the report in excel and adjust it manually ? 

Thank you,

Victoria 

JasroV
QuickBooks Team

FTE Calculations

Nice to have you join this thread, Victoria.

 

You can consider running the Payroll Item Detail report and export it to Excel. Then run the Payroll Summary report for reference for your FTE calculations. This report shows you the hours for each employee during the time period. Let me show you how.

 

  1. Go to the Reports menu in your QuickBooks Desktop (QBDT) software.
  2. Select Employees & Payroll.
  3. Click Payroll Item Detail.
  4. Adjust the date if necessary.
  5. Click the Excel drop-down menu and select Create New Worksheet.
  6. Open the Excel file and adjust the calculations.
  7. Then run the Payroll Summary report (repeat steps 1-2).

 

With this, I’d recommend working with your accountant for advice in making those changes. This way, we can ensure your FTE is properly recorded. If you’re not affiliated with one, you can visit our ProAdvisor page and look for one from there.

 

Also, I'm attaching these articles that you read for future reference in managing reports and the total hours worked by your employees:

 

 

Keep me in the loop if you need further assistance with your PPP calculations. I’ll be around to help you. Have a good one!

Need to get in touch?

Contact us
Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
Sign In / Sign Up