We Prepare Tax Returns!

We prepare most type of tax returns:

Individual. 

S Corporation.

C Corporation.

Partnership.

Payroll.

Amended.

Gary Bode, CPA is a Master's Degreed, nation wide accountant offering tax and business services. Member of AICPA and NCACPA. Our virtual office provides excellent service to long distance and international clients. Call (910) 399-2705 for a free phone consult.

Client Video Testimonials

Click here to watch some of our clients in their video testimonials!

Client Testimonials

Amended Tax Return and IRS Resolution

I was initially worried about picking someone off the internet but your testimonials sold me so I would more than happy to assist and hopefully the next person will be at ease choosing to utilize your services. I am pleased to write you to let you know I received a response from the IRS in response to the schedule C you assisted with filing. They responded saying the information supplied was sufficient and they have closed discrepancy. I spoke with the IRS and they said no tax is due. I asked even though I did make a $400 profit and they said again no tax liability is showing that the case was closed. I just wanted to thank you again for your assistance with this issue.

Jason Stoltz

Free Consult

Even though Gary enjoys helping colleagues, we no longer provide free consults to other tax preparers. He's happy to consult on an hourly billing basis if our schedule allows.

Pay Your CPA

Enter $ Below



Other Amount:



Your Email Address :



Construction CPA offers tips for QuickBooks Classes | construction accounting with QuickBooks Contractor Edition

Construction CPA, contractor CPA

The tricks to making your construction accounting useful in QuickBooks is planning and consistent data entry. Call for a free consult. Our virtual office makes us easy to deal with, wherever your construction firms operates. (910) 399-2705.

Construction CPAs see lots of non-optimal construction accounting. That’s a shame since construction accounting plays a vital role in getting paid, bonding, taxes and even licensure. Sometimes a poorly designed set of books is the issue. In this post I’ll go over some tips for setting up  Classes in QuickBooks Contractor Edition. Classes just aggregate job data into broad categories. For a clean, simple example let’s assume:

  • The company opened on November 1st 2013.
  • Had four completed jobs during November and  December.
  • Did not have any other jobs in progress on December 31st.
  • A truck is the only overhead expense for 2013.

Let’s say you’re a contractor and think of your business, in broad terms, as residential and commercial.

  • You setup three Classes in QuickBooks Contractor Edition; Commercial, Residential and Overhead.
  • We’re using four  jobs, two commercial (C and D) and two residential (R and S).
  • You used the company’s one truck for all four jobs.
  • You installed 2″ caliper oak trees for each job.
  • The job cost reports for C, D, R and S all  reflect the oak trees properly. The bookkeeping entries look like this: Residential : Job R: 2″ Caliper oak tree.
  • You can run another QuickBooks report showing income and expenses for all Residential jobs, in this case R and S. And then all commercial jobs, C and D.
  • Plus you show the aggregated Commercial and Residential data side by side.
  • The impact of the company truck? Please see below.

Excel based workarounds for QuickBooks contractor edition

As a construction CPA I’ve never seen any construction accounting software that does everything you need. There’s always supplemental spreadsheets required. But in this case we’ll export a QuickBooks class report to Excel and sort out the overhead. Here’s the direct costs of the jobs from the above example:

  • C: $1,000
  • D: $3,000
  • R: $5,000
  • S: $1,000.

So the relative percentage of job costs are C 10%, D 30%, R 50% and S 10%. We’re using job expense as the cost driver to allocate the truck overhead to the four jobs. Other potential cost drivers exist.

Applying the Overhead in construction accounting

I think any construction CPA says application of overhead is the largest problem in construction accounting. Let’s say you had truck expenses of $1,000 in 2013 and that’s the only overhead.  We’re exporting a QuickBooks Contractor report to Excel and fine tuning them.

  • On a Class report for Commercial: you’d add $600 of overhead. (50% + 1o%) x $1,000.
  • On a Class report for Residential: you’d add $400 of overhead. (10% + 30%) x $1,000.
  • On a Job expense report for C: you’d add $100 of overhead. 10% x $1,000.
  • On a Job expense report for D: you’d add $300 of overhead. 30% x $1,000.
  • On a Job expense report for R: you’d add $500 of overhead. 50% x $1,000.
  • On a Job expense report for S: you’d add $100 of overhead. 10% x $1,000.

The tricks for relevant construction accounting?

  • Plan ahead.
  • Think what you’ll want to see in the future. Your construction CPA can help visualize that for you.
  • Setup QuickBooks Contractor Edition to carry out those goals.
  • Recognize that supplemental spreadsheets are normal.
  • Recognize QuickBooks reports can be exported to Excel for fine tuning.
  • Enter accounting data in a timely matter.
  • Enter accounting data in a consistent manner.
  • Don’t over analyze and get mired down with trivia.

Don’t have a Construction CPA?

Consider calling us.  My experience includes being a staff accountant, controller and CFO for construction firms. Our virtual office makes it easy to deal with us from anywhere in the US. (910) 399-2705.

Find me on Google+

Leave a Reply

You can use these HTML tags

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>