Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Connect with and learn from others in the QuickBooks Community.
Join nowHi all,
There are a couple of things that still don't seem to be captured in all the right places on Projects, that I'd like to both chronicle, and get feedback on the workarounds for, particularly in the bookkeeping/accounting capacity. The items are all time cost related, but maybe there's some other things and time is just a symptom of this.
How Time seems to be pulled
For the purposes of costing it seems Time is pulled from payroll. This is an important point to remember, because should there be any amendments to a person's time card, Projects will only list those changes on the Time Activity tab, but not the blue "Costs" bar on the overview.
It's also worth noting that payroll expenses on that time (Employer Taxes), are not assessed at the time sheet level, and so this will not give you the same kind of costing as something properly captured through payroll on the Projects screen.
The Workaround
First off, I did not come up with this workaround, credit goes to Heidi M from the QBO Team and it's helped us get a much better view of our projects cost. The fix is a $0 sum journal entry, putting it back into the project for the sake reporting. My question for bookkeepers is: Should these adjustments be captured in the account they were originally intended for, or should the adjustment accounts remain expressly for these purposes? The steps for the work around are as follow:
The Hourly Cost
This function works wonderfully for straight time pay with additional considerations you plan for at the outset. What it doesn't seem to do, however, is adjust for unique paycodes. I can't verify if it overrides overtime as well.
The issue with this, that I witnessed, was a particular employee gets a special pay rate for certain projects. Let's just say $20/hr for special projects and $15/hr for normal ones. Via payroll, his time is mostly allocated into the correct paycode (There's a small fraction which allocates into overtime that I have to manually move over). I also happened to have set up his Hourly Cost according to his normal pay rate. What seems to be happening is, the Hourly Cost seems to be overriding his Time Activity while leaving payroll unaffected.
To correct this, I have to go into each time entry and adjust it to the correct paycode, but I imagine just deleting his hourly cost should be a sufficient fix for now.
Wow, can't imagine manually allocating cost by project via journal entry in this decade or last two.
As far as I've heard, Journal Entries are pretty commonplace. But in a project capacity, it's really very tedious. At the moment, however, I don't think there's an alternative. Just have to wait for QBO to evolve further.
This is an old post, but I wanted to share how appreciative I am of this advice! I've been looking for a work-around to adjust costs for months. I've had to adjust subsequent payroll hours to get the correct hours under the project, thinking it was cemented as soon as I ran payroll. This is a lifesaver- thank you!!
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.