cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Level 3

Is there an easy way to analyse payroll expenses by employee?

I'm looking at my total payroll expenses for the year just ended, on 30/4/20. Has anyone worked out an easy way to analyse this by employee? I can drill down from the P&L and see the individual pay journals, but can't tell which journal relates to which employee.

 

In QB desktop, payroll used to put this in the 'name' field on the pay journals, but QBO does not do this.

 

I can see a reference to the employee name in the memo box on the journal, but I can't bring this item into a report AFAICS.

 

Has anyone found a way to do this? Would be really handy for many reasons, e.g. need to split directors from non-directors for the CT600 corporation tax computations.

 

Solved
Best answer July 24, 2020

Accepted Solutions
Highlighted
Level 3

Is there an easy way to analyse payroll expenses by employee?

I am on standard payroll unfortunately. My solution was:

 

1. Run the Payroll Details Report (Gross to Net) report for each of the 12 months

2. Save the 12 .csv files into a temp folder

3. Open a command prompt in the temp folder

4. Execute 'copy *.csv combined.csv' to concatenate the 12 files into a single file

5. Then you have a file for the year you can manipulate in Excel - either sort by employee name or use the SUMIF function to analyse by employee

6. Check the total gross pay reconciles to the general ledger!

 

This was so easy in a single step using the Employee Earnings Summary report in QB desktop payroll. I know QBO standard payroll is cheap as chips, but can Intuit please give us some usable reports rather than just hard-coded csv files that can't be customised by date range or anything else?

View solution in original post

3 REPLIES 3
Highlighted
QuickBooks Team

Is there an easy way to analyse payroll expenses by employee?

Hi there, rjwbailey

 

For now, we're unable to run a report where the memo of the journal entry will show up. 

 

If you're using the Advanced Payroll subscription, you'll want to run the Pay Run Audit Report. This will basically give you the full pay run details for a given pay run. It includes earnings, super payments, bank payments, leave and deductions.

 

Just go to the Reports menu and look for Pay Run Audit Report

 

Let me share these articles with you that can provide some of our quick guides when running payroll in QuickBooks Online:

 

Let me know if you need anything else. 

Highlighted
Level 3

Is there an easy way to analyse payroll expenses by employee?

I am on standard payroll unfortunately. My solution was:

 

1. Run the Payroll Details Report (Gross to Net) report for each of the 12 months

2. Save the 12 .csv files into a temp folder

3. Open a command prompt in the temp folder

4. Execute 'copy *.csv combined.csv' to concatenate the 12 files into a single file

5. Then you have a file for the year you can manipulate in Excel - either sort by employee name or use the SUMIF function to analyse by employee

6. Check the total gross pay reconciles to the general ledger!

 

This was so easy in a single step using the Employee Earnings Summary report in QB desktop payroll. I know QBO standard payroll is cheap as chips, but can Intuit please give us some usable reports rather than just hard-coded csv files that can't be customised by date range or anything else?

View solution in original post

Highlighted
Moderator

Is there an easy way to analyse payroll expenses by employee?

Thank you for the solution you've provided to analyse your employees' payroll expenses, rjwbailey. This workaround will surely help other users here as well.

 

I want you to know that your voice matters and I appreciate that you took a moment of your time to provide us with additional feedback. Yes, QuickBooks Desktop offers more standard reports that can be customized as needed which isn't offered in QuickBooks Online.

 

For now will take this as a product suggestion. This might be added to any feature updates. After all, added features in QBO are largely the results of feedback provided by users. I would recommend visiting our Blog site. From there, you'll be updated with the features and enhancements that our developers are currently working on.

 

I'm also adding these links about viewing reports and reports and accounting for QBO for your guide:

 

Tag me in a comment below if you need more assistance.