How to see hours worked in Job Site report after Payroll is submitted?

I have the 50 Accounting CA version, that allows me access to Job Sites/Time Cards/etc.  I recently learned about the Job Site feature; where you can allocate hours worked and materials purchased to a particular project that we have on the go.  Currently I do a manual one in Excel, so this sounded great to me.  I set up the project in Job Site, but I was told the only way to allocate hours into a project is through the Payroll Cheque Run feature.  I submitted the payroll early last week on Thursday morning due to the holiday, but now that I have my time cards for Thursday, I need to allocate the hours and was told I cannot because the payroll was already submitted.  This seemed odd to me that I could allocate material from months ago to any project, but that I couldn't allocate hours from last week.  I was told by a few people, and even some reps from Simply, that I could not do that.  But I found a way (adjust paystub for that employee, click 'paycheque' tab, and click 'allocate to Job Site'.  So I put the hours in for Thursday afternoon without a problem.

Today, however, when I tried to do the reports on the project I put the hours to, it doesn't show there are any hours.  If I go to the "Enhanced View" and look at Job Sites, it shows me there are expenses for the project (which would be the hours I submitted since I didn't have material for that project yet), but it doesn't tell me WHAT the expense is and I can't figure out how to view it in a report to show those hours I applied. (EDIT: I don't use Enhanced View as a report.  I stated I used it to look at Job Sites, which shows me there are amounts in the job, but when I view reports such as "hours by employee", it says there are none.)

Can anyone help me out with this?

  • 0

    You can allocate hours in Paycheques if you have the correct settings.  Setup, Settings, Project/Job Site, Allocation.  Change Payroll to Hours.

    The Reports, Project/Job Site, Hours by Employee report is, I believe, a Premium and Higher report.  You didn't tell us what version you are using but if you have Pro, then you cannot get that report.

    TWaye2016 said:
    If I go to the "Enhanced View" and look at Job Sites, it shows me there are expenses for the project (which would be the hours I submitted since I didn't have material for that project yet), but it doesn't tell me WHAT the expense is and I can't figure out how to view it in a report to show those hours I applied.

    "Enhanced View" is not a report so I can't tell what report you are running.  However, expenses for a project are never hours.  Expenses are always money.  So let's break down the journal entry for payroll.  The reports should be showing you wish G/L account is allocated to, so I am not sure why you don't see them.

    Payroll entry journal entries (and almost any other journal entry) can be seen on the Report menu before posting.  This shows the expenses are the Wages/Salaries, Company EI Expense, Company CPP expense, sometimes WSIB/WCB expense, etc.  This is all money.

    Let's say you pay someone $20/hour and pay them 40 hours in a week and allocate that all to one project.

    $800 plus any vacation pay is allocated to the Wages/Salaries expense based on the 40 hours.

    $11.22 is allocated to the EI Expense account.

    $36.27 is allocated to the CPP Expense account. etc.

    If instead you allocated 10 hours to one project and 30 hours to another, then 25% of the above dollar amounts would be allocated to the expense accounts mentioned for Project 1 and 75% would be allocated to the same expense accounts for Project 2.

    Hope this helps