Solved

Employee hour reports in QB

Posted on 2010-08-12
5
1,149 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
ID: 33427126
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
ID: 33428832
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
ID: 33433414
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
ID: 33433879
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
ID: 33434414
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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Enterprise level Accounting Solution 5 53
Quickbooks 2015 Premier on two computers 17 46
returning to accepting  transactions in QB15 2 45
Expenses withheld from rent. 1 58
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…
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.
In this video I am going to show you how to back up and restore Office 365 mailboxes using CodeTwo Backup for Office 365. Learn more about the tool used in this video here: http://www.codetwo.com/backup-for-office-365/ (http://www.codetwo.com/ba…

864 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

24 Experts available now in Live!

Get 1:1 Help Now