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

Allocating Salaries to Jobs and including the allocation on the job invoice.

We use full service intuit payroll and 2019 premier contractor's edition. I would like to run an unbilled cost on a job and see the pay allocation so that it could be invoiced to our customer. 

For instance I know 50% of a superintendents time went to one job, 25% to another, and 25% to another. I made a journal entry moving the wage and taxes paid by the employer to the jobs according to the percentage above. I did create an item code for labor but the JE does not ask for an item number just an account. The JE does however ask for a job and whether it is billable or not billable, which I entered. If I run a unbilled expenses on the job it doesn't show up for billing. This has got to be a common issue. 

8 Comments 8
HoneyLynn_G
QuickBooks Team

Allocating Salaries to Jobs and including the allocation on the job invoice.

I can help you get the report you need, @LisainKC.

 

I appreciate the detailed information you've provided. You can run and customize the Unbilled Costs by Job report to get the unbilled cost on a job and its pay allocation. It also provides the posting account specific for each item.

  1. On the top menu, click Reports.
  2. Choose Jobs, Time & Mileage.
  3. Select Unbilled Costs by Job.
    1.JPG
  4. Customize the date range.
  5. Click Refresh.
    2.JPG

For additional reference, I'm attaching here some related articles:

That should keep you going today, LisainKC. Keep me posted on how these steps work out for you. I'm still here to offer more help if you have further questions. Wishing you all the best!

LA4
Level 1

Allocating Salaries to Jobs and including the allocation on the job invoice.

Thank you for responding! I ran the report according to your instructions yet the journal entry is still not showing up. It has the job on the JE and it is marked as billable. Do you think it has anything to do with the account? 

HoneyLynn_G
QuickBooks Team

Allocating Salaries to Jobs and including the allocation on the job invoice.

Hello again, LA4.

 

I appreciate you trying my suggestion and keeping me posted on its result.

 

I recorded a journal entry under a job and marked it as billable. It was added on my Unbilled Costs by Job report regardless of what account is associated. Please take note that only the credit transaction will show on the report and that the list of transactions is determined by the date range you select.


1.JPG2.JPG

I advise checking the JE transaction and making sure the date is correct. I'll appreciate it too if you can add some screenshots of the JE and report. That way I can better understand your issue.

 

I'll be keeping an eye out for your response and look forward to getting to the bottom of this. Take care and have a good one.

LisainKC
Level 1

Allocating Salaries to Jobs and including the allocation on the job invoice.

Ok I messed around with it a little more. My JE debited 50% to job A, 25% to job B and 25% to job C. The unbilled job report showed the two 25% allocations but used job A as the source. However, it did not show the allocation for job A. This is a head scratcher. What it is telling me is in order to correctly record the allocation I will have to make 3 separate journal entries, which is less than ideal.

I really appreciate you trying to solve this with me, but it appears to be a bug. 

LisainKC
Level 1

Allocating Salaries to Jobs and including the allocation on the job invoice.

Why would it just show a credit? If the original payroll entry is a 

 

Dr. to wages

Cr. to Cash

 

To allocate the wage to a job you would then

Dr the job

Cr. Wages (see above)

 

The amount that would show up on the unbilled job report should be the Dr. to the job. 

 

 

RCV
QuickBooks Team
QuickBooks Team

Allocating Salaries to Jobs and including the allocation on the job invoice.

Hi there, LisainKC.

 

Cases like this, it would be best to consult your accountant to help you review the journal entry you've created for tracking the job cost. Then, verify with them the right account and job costing item you'll need to enter to reflect it in the Unbilled Costs by Job report. The details of your job item will determine the preciseness of your job reports.

 

On the other hand, you can use QuickBooks Desktop's Job Costing tools to have an accurate record of your job costs. For the steps and details, you can check out this article: Tracking job costs in QuickBooks Desktop.

 

You can always visit the Community if you need anything else.

 

LisainKC
Level 1

Allocating Salaries to Jobs and including the allocation on the job invoice.

Thank you very much for trying to help solve this issue. I am actually an accountant and not a bookkeeper. I've just not had much experience with this version of Quickbooks. I didn't know about the report you pointed out to me which is very helpful; however, I'm confident that this is a bug because all three of the allocation lines are using the same account. The fact that two of the three are showing up doesn't make sense. Also, I do know from other journal entries I've made on other versions that it is only programmed to pick up the description on the first line so I'm sure that this is the problem as well. It is a programming issue that really should be fixed. I will call them and hopefully get someone to talk to me. 

Thank you again for helping QB users out on the community forum!!

JanyRoseB
QuickBooks Team

Allocating Salaries to Jobs and including the allocation on the job invoice.

Thanks for getting back to the QuickBooks Community, @LisainKC.

 

Allow me to join in this thread and help provide some additional information.

 

If you've already processed the recommended steps provided by my colleagues and the issue persist, let's rebuild and verify the data in QuickBooks Desktop to remove the empty or damaged information from the file. 

 

Here's how to rebuild the data: 

  1. At the top menu bar, click File.
  2. Select Utilities, and choose Rebuild Data.
  3. Click OK if you receive a prompt to backup your company file.
  4. Your computer may display the message QuickBooks is not responding. However, as long as you can see your mouse cursor to move, Rebuild is still ongoing. Wait for it to complete.
  5. Click OK when you get the message Rebuild has completed and process the next troubleshooting steps.

To verify the data in QuickBooks, you can follow the detailed steps in this article: Resolve data damage on your company file.

 

If the same thing happens, I encourage you to contact our QuickBooks Desktop Support Team. They have additional tools to pull up your account and do a remote session.

 

Here's how you can can contact our customer support:

  1. Select QuickBooks Desktop Help from the Help menu.
  2. You can also press F1 on your keyboard to bring up the same Help Panel. 
  3. In order to route you to the correct support expert, we need to know what type of question you have.
  4. Click Continue.
  5. We’ll provide you a few options. You choose which one is best for you.

Please let me know how it goes. If there's anything else I can do for you, please let me know. I'll be around to help you out.

Need to get in touch?

Contact us