Solved

Employee hour reports in QB

Posted on 2010-08-12
5
1,118 Views
Last Modified: 2012-08-13
I am using QB Pro 2009 on Windows XP Pro.  I want to produce a report of hours worked by employees, broken down by employee, over various periods of time - I want to compare to my business' gross income to see if we are being more or less effecient.  We use QB to do our payroll, so employee hours are in there - I just don't know how to generate that particular report.
0
Comment
Question by:Villageac
  • 2
  • 2
5 Comments
 
LVL 11

Expert Comment

by:stlinae
Comment Utility
Need more information s to what you want on the report.  "I want to compare to my business' gross income " compare to what? Do you track time to jobs?

Does the Time by Name report give you what you want? (Reports>Job,Time,Mileage> Time by Name)
0
 

Author Comment

by:Villageac
Comment Utility
I don't track time by jobs - we input our time clock's information - employee, hours worked, into QB and then use QB Payroll service to cut checks.
The job time mileage time by name report gave me nothing on the report - I played with the filters but could not get it to generate anything.
0
 
LVL 2

Expert Comment

by:JackOfAllTrades
Comment Utility
Villageac:

Do you use the "Weekly time sheets" to track time, or do you enter it in when you cut payroll checks?

If you do not use time sheets, the Time by name report is not available.  In order to get hours by employee you could take a payroll summary report and filter it out to include only the Gross pay items.

This is not the prettiest report, but it will give you employees across the top with hours worked and gross pay under each employee in the specified period of time.  You can export it to excel to clean it up.


0
 

Author Comment

by:Villageac
Comment Utility
Is there a way to modify the report to report 1 employee hours over a 3 year time frame broken down by quarter?
I have been running the report as you suggested - but I then have to collate hours by employee by quarter (1 report as you suggested I run, as well as what I have been doing) and make my own spreadsheet from the data each quarter's report generate.  I was hoping I could get QB to do that in 1 report.
0
 
LVL 2

Accepted Solution

by:
JackOfAllTrades earned 500 total points
Comment Utility
Here might be a better way to get that report

Start with a "payroll item detail" report and filter it out as follows....

Under Filter...
Change Payroll Item to "All Gross Pay"
Filter out "Name" to the employee you want


Under Display...
change Total by to "Quarter"
Under Columns check "Qty"
Under Columns uncheck "Wage base" and "Amount"
Set your date range
0

Featured Post

6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

Join & Write a Comment

By Linda Saltz Customized item descriptions from bills DO import into a customer invoice!   This is a wonderful tip for companies that want to use generic items like Hardware, Software, Mileage, Travel in their item list which helps keep the i…
You may need to view past transactions from previous QuickBooks files or other QuickBooks company files when:       1. you are working in another QuickBooks file       2. QuickBooks is closed QuickBooks users who would benefit from this artic…
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now