How Bookkeeping Supports Job-Cost & Gross Profit Measurement at Paul’s Perfect Projects, LLC
If you haven’t already read them, you’ll probably want to visit Part I and Part II of this “Tale of 4 Companies: A Job-Cost & Gross Profit Percentage Drama” before starting the following “Part III”. In Part III, Paul & Dave have just returned from lunch and are continuing their meeting…
When Dave and Paul returned from lunch, Paul checked the new notes waiting for him on his desk. “A slight change in scheduling,” he announced. “It turns out that our bookkeeper, Rhonda, has an appointment and needs to leave by 1:30, so I’ll ask her to stop in to talk to us before she leaves for her appointment.” Paul glanced at his watch and said he’d be right back.
Dave pulled out his notes, and looked again at the report they had started to review before lunch.
He focused on the section surrounded by the red box and blue number 2. When he compared Estimated Cost to Actual Cost, he noticed that all but two line items within the General Conditions and Design & Engineering stages showed unfavorable dollar and percentage differences. He highlighted the subtotals in yellow and thought to himself “Hmmmm. I wonder what they did when they saw these numbers?” He also questioned exactly what was included in the Labor “Actual Cost” amounts, so he grabbed another highlighter off the table and marked those numbers in green.
At that point, Paul walked in with Rhonda. After introducing Rhonda as “Our numbers person – someone we couldn’t live without!” he quickly filled Rhonda in on Dave’s dilemma and what he’d shared so far. “I asked you to this meeting because I’m hoping that you’ll be willing to share some of your insights – from the bookkeeping and accounting perspective – with Dave. He’ll probably have a few questions of his own to throw into the mix. So please, just be open and let him know some of your thoughts about the process…”
Making Changes to Rhonda’s (Prior) QuickBooks Accounting System
Rhonda turned to Dave and said, “Hi – nice to meet you! OK, well, when Paul initially talked with me about bringing someone in to help revise our QuickBooks accounting system, I really wasn’t totally on board with that idea. I was pretty much self-taught in bookkeeping and QuickBooks. Our outside tax accountant showed me how to make entries into QuickBooks right after I first came to work here, and I’d been using it that way ever since. I made sure that income and costs were assigned out to jobs, our bank accounts were reconciled, and our Accounts Payable and Receivable reports were right. Our tax preparers seemed to be just fine with what I was giving them so my first response was ‘If it ain’t broke, why try to fix it?’”
Then she smiled. “But of course, I was used to just looking at it from my perspective of ‘Get the data IN and get the bookwork DONE!’“
“Then Paul spent a little more time with me and explained that he thought we should be doing much better financially than we were, and that he and the job supervisors just weren’t able to see some of the detailed information that they needed in order to hit our profitability targets. I gave it some thought and decided that I needed to be willing to do whatever was needed to move the entire company ahead. So I jumped on board. In this day and age, I think you have to be flexible and open to new ways of doing things. And I remember thinking ‘Who knows? Maybe I’ll have some fun learning a few new ways of doing things.’”
For the PDF version, please click the following:
A Tale of 4 Companies-eBook
Accounting Changes Help Meet Company Job-Cost and Gross Profit Goals
Dave nodded, “Sounds like you’ve got a great team player here, Paul!” Paul nodded in agreement, “Yup, we do.”
Rhonda continued. “So the first big transition for me was that I learned how Items in QuickBooks worked, and how they link to cost and income accounts.We did have to make a mental shift. It took a little while to remember that we needed to enter job costs and income using Items rather than accounts. But once we got that part under control, there really wasn’t any more work involved.”
“Of course, since Items track detailed costs, there were more of them to choose from, so we organized and grouped them into a logical flow. Then we set up some ‘cheat sheets’ we could use to make it easy to enter those Items. QuickBooks also has a feature that can automatically recall the last account or item you used with a transaction and specific vendor. So by the time we got a couple of months of data entered, day-to-day entries started to work very smoothly.”
“We’d already worked out our labor burden percentages and had been adding them into our job costs, but we weren’t tracking labor by the type of task being performed. We found out that kind of tracking would require us to use QuickBooks Service Items, so we created and distributed an abbreviated list of Service Item “work codes” to our employees. Paul let them know that they needed to record the type of work they were performing for each job on their timesheet. That information now gets entered into QuickBooks as part of the time-collection process.”
Tracking Time by Task Helps Meet Job-Cost and Gross Profit Goals
Dave was curious. “So how did your employees and staff feel about that change?”
Rhonda lifted her eyebrows and looked to Paul to answer the question. He picked up the ball. “Well, they weren’t overjoyed about it, but we had several meetings, discussed the reasons for the changes, and asked for their support and cooperation. We also gave them a few weeks to get used to the idea before implementing. Then we set up coaching and feedback meetings to help the few people who were having a hard time making the transition.”
“In a couple of cases we had to refer to our policy of ‘This is how we do things here, and if it doesn’t match up with your philosophy, then we may not have a good fit.’ There were one or two people who decided to move on, but time-tracking wasn’t their only issue, so it was probably for the best.”
Rhonda added, “It was really important for us to have that kind of support come from the top of the company. I was able to tell anyone who gave me a hard time about their time sheet entries that they should speak with their supervisor. I haven’t gotten any direct grumbling for quite some time now! So I think the time collection system is working pretty well at this point. With that piece in place, our supervisors review time and job assignments for accuracy and can make changes before the payroll is processed. The whole system is integrated so, after supervisory approval, payroll gets assigned to job costs based on time and activity.”
“I’ve been looking at this report,” said Dave, “and I highlighted the line items for actual labor costs in green – right here in this red box. Exactly what’s included in that number?”
Rhonda leaned in to take a quick look. “You’ve highlighted the actual labor cost. It includes the employee’s hourly pay – both regular and overtime. It also includes all of the employer’s payroll taxes AND the labor burden costs we’ve determined should be assigned for each employee. So the amounts you’re seeing on this report for labor costs are all-inclusive.” “Ah,” said Dave. “Pretty impressive.”
For the PDF version, please click the following:
A Tale of 4 Companies-eBook
How Does a Comprehensive Job-Costing System Impact Accounting Workloads?
Dave continued. “One more question. So compared to before – is there more work, or less work, from an accounting perspective?”
Rhonda laughed, “Well, after we made the changes – which required a big push and a stretch of late nights and weekends, it’s probably about the same. In some ways, it feels like there’s more data entry on the front end of a job – for instance we’re using detailed Estimates and Purchase Orders in QuickBooks – but on the tail end of the process, we can convert time sheets into payroll, estimates into invoices, and purchase orders into bills without having to track down project managers to find out what jobs or Items to use. So that saves a lot of time and frustration.”
“It’s also much faster and easier to provide the reports that management wants to see without having to create a lot of time-consuming spreadsheets, and hand-prepared reports. Our ProAdvisor also shared a lot of other time-saving features we didn’t even know about – like keystroke shortcuts, embedded document storage, memorized transactions, and memorized reports. Those features are handy, and help reduce busy-work.”
“We’re also using the Month-End Closing Procedures for QuickBooks so that we’re sure we have a clean set of books each month. That way, our December 31st year-end is pretty much a standard month-end closing, so we’re done with the bulk of the year-end work by mid-January.”
She glanced at her watch. “Ooops. I’m really sorry we had to make this so brief, but I’ve got to run if I’m going to make it to my appointment on time. If you think of any other questions, please feel free to get in touch. Paul has my contact info.”
As she prepared to leave, Dave stood up to shake her hand. “I think you did a great job of giving me a birds-eye view about what kinds of things change from the accounting and bookkeeping perspective. I also appreciate finding out how you and Paul handled asking employees to track the tasks that they’re working on. It sounds like you’ve been a key-player in making great progress on your job-costing system and it seems like you’ve helped to create a great ‘team environment’ atmosphere here at Paul’s Perfect Projects. Thank you so much for sharing!“
Next Blog Posting:
Part IV – How Estimators and Supervisors Focus on Job-Costs & Meeting Gross Profit Goals at Paul’s Perfect Projects, LLC. Project managers and Estimators discuss how they create and review Estimates, and then use the Estimate vs. Actual reports as projects get underway. Read Part IV…
Learn more about our construction accounting and manufacturing program classes and discover our job-cost support products!