If you use QuickBooks for your accounting and you create your Estimates in Excel instead of within QuickBooks you loose out on job costing capabilities and so much more!
I often see and hear comments such as this as I browse the web or talk with potential customers for our software:
Right now we are using QuickBooks Contractor. It is ok for our accounting software but we are looking for something that works as an overall system for our office – CRM, estimating, job costing, proposals, work tickets and most importantly easy for my guys to use. Right now we are using Excel for Estimates and invoices.
When I see and hear comments like this I get so confused – because QuickBooks does allow you to create Estimates, Proposals, and do Job Costing - so I thought I’d attempt to write a short article to address this.
Creating Estimates in Excel vs. QuickBooks – Pros and Cons:
Excel is REALLY easy to use – anyone can quickly whip up an Estimate, Proposal or a Work Order., you can create some great looking documents that you are proud to hand to your prospective customer. But that is about as far as you can go.
QuickBooks, on the other hand, if set up properly will allow you to create an Estimate, Proposal, Work Order, or an Invoice and perform job costing just by entering vendor bills, writing checks, entering credit card charges, and employee payroll. You then can access all kinds of Job Costing reports and an Actual vs. Estimate Report – which allows you to see the difference between what you thought you’d make on the job vs. what you actually made.
But….QuickBooks requires more work on the front end and then proper training for your employees.
I think I just heard everyone groan! There is no way that I can write a “short” article on the benefits of using QuickBooks to prepare these documents for your business, but I can provide you with some suggestions to get started.
- Is the QuickBooks Estimate function turned on? If not go to the Edit menu -> Preferences -> Jobs & Estimates -> Company Preferences tab -> set “Do You Create Estimates” AND “Do You Do Progress Invoicing” to Yes
- Modify/Customize the built in forms to meet the needs of your company using the Layout Designer, by downloading a pre-built template or by using the Create Form Design option. All of these options are available from the Lists menu -> Templates -> and then clicking the Template button at the bottom of the window.
- Create a FULL list of the services, cost codes and/or products your company uses for billing
- Have a meeting – get EVERYONE involved – take that master list of products and/or services/cost codes and come up with descriptions that EVERYONE can agree on {letting them know that they can “tweak” it more to their liking later}
- Go to the Items List and set up items that correspond to that master list of of the things your company does, creating Group Items or Inventory Assemblies if appropriate
- Create an Estimate, a Proposal, or a Work Order using the entries in your Item List – print it out and see what everyone things of it. If they are happy teach your Estimators how to use the Estimating function
- When entering Vendor bills, writing checks, or entering Credit Card Charges use the Items tab and assign the cost to the job
- Turn on time tracking, enter employee hours by Job, Service Item, and Payroll Item
- Create a Progress Invoice from an Estimate for the current amount that you are billing the customer
- Look at the Estimate vs Actual Report for a specific job and look at the report results
These suggestions are just the tip of the iceburg for taking QuickBooks from plain-Jane accounting to job-costing accounting. Use the search box on our site and enter specific keywords for additional tips.
If you can’t get your Estimators to leave Excel, there is a 3rd party application Transaction Pro Importer – that will import your Excel based Estimate into QuickBooks for you and you can implement some of the other suggestions in this article.
I hope you’ve found this article to be helpful, if so please take a moment to leave a comment or ask a question – or share it on your favorite social networking site if you think others would find it to be useful.
Wishing you all a happy, successful, and prosperous New Year! I hope you all had a wonderful holiday season with family and friends.
The holiday season is wonderful – but it’s a time of short work weeks and lots of non-work related activities – I don’t know about you but in some ways I’m REALLY glad the holiday season is over! But unfortunately, I feel like a need a vacation just to get myself ready to go back to work and deal with the things ahead!
Coming back to work after the Christmas and New Year’s holidays can be tough – there are all the things that we need to catch up on that were set aside because of short work weeks and of course January means getting ready for W-2′s, final quarterlies, taxes, etc.
Perhaps your company is implementing new software to automate time-consuming tasks, workflow procedures for the new year that will help you all get your jobs done quicker and more efficiently, or you are thinking about signing up for some QuickBooks training classes so that you can perform your bookkeeping tasks more efficiently.
What are your goals for the new year?
Do you have a plan?
Do you have a list of things that you want to accomplish this year?
I have a long list of things that I need and want to do this year.
One of the things that I want to do is to offer more QuickBooks training, for our customers and site visitors, through reasonably priced eBooks, pre-recorded and live webinars. I’m also working on updating many of the eBooks that I’ve previously offered here on the blog for free – once the eBooks have been updated and released, I will be selling them for $7.00 to $35.00 – depending on the length and subject matter. I’ll be announcing their release hear on the blog as they are completed.
As a visitor to our site what would you like to see for upcoming training subjects?
Have a great first week back to work!
It’s our last official post for 2011 and we’d like to wish you all the happiest of holidays and say a warm “thank you” for your support and patronage this past year!
Seasons Greetings and Happy Holidays to all of you! I hope each and every one of you have a fantastic holiday season.
I’d like to thank everyone for your support of the QuickBooks for Contractors blog during the past year.
Our office will be closed from Friday, December 23 through Monday, December 26 and again from Friday, December 30 through Monday, January 2, 2012; while we share the holiday season with friends and family.
During this time were also going to do some well deserved maintenance and updates to our main website to prepare for 2012.
When we relaunch on Tuesday January 3, 2012, you’ll find that we’ve been very busy during this time. The Federal WH 347, certified payroll report is due to expire on December 31 and we will be providing information about the new reporting requirements so that you’ll be up to date. Additionally, after a very long delay, the Compliance Monitoring Unit, part of the California Department of Industrial Relations, will go into effect. So there will be information available about this as well.
In addition to these prevailing wage law changes you’ll find that we’ve been busy updating and creating new QuickBooks training materials geared for commercial and government construction contractors. These new materials will be in the form of e-books, pre-recorded videos and live webinars. All which will be reasonably priced.
Until then, have a safe and happy holiday season and be sure to check back next year to see what we’ve been up to!
Payroll is a complex part of every bookkeeper’s job, new requirements for 2012 include showing company paid health insurance premiums on employees W-2′s; making things even more complex. See this question asked by a reader of our blog.
I have a question that I’ve been searching for an answer to, I’ve even asked our Tax Accountant about it. In 2012 it is mandatory that we show the company share of employee health insurance on W-2′s, do you know if there is there a way in QuickBooks to track this on a regular basis, so that it shows on the employees paystubs and then have it flow through onto the W-2 at the end of the year? Thanks, Kathleen S.
——————————————————————–
Answer:
Hi Kathleen,
Yes, you can set QuickBooks up to track employer paid health insurance contributions, have those contribution amounts appear on employee pay stubs and then have the full yearly contribution appear on the employee’s W-2. I’ve been doing this for a long time – thankfully the QuickBooks payroll module is pretty flexible, the hardest part is the setup – and then the maintenance.
Important things to take into consideration prior to setting up QuickBooks to track this information – OR the planning stages:
- Health insurance premiums for all employees are usually paid on a monthly basis in one lump sum made up of a specific amount for each employee based on the type of plan or coverage each employee has. The chances are that you pay your employees more often than that – so you want to set up a method of tracking company contributions for health insurance based on how often you pay your employees – so that the contribution is done automatically for you when you run your payroll rather than having to “remember” to do something once a month.
- Will the company pay 100% of the cost of health insurance or will the employee also pay a portion through a payroll deduction?
- How many pay periods your company actually has during the year.
- When does your company health insurance policy renew?
- Will you also be using/taking credit for company paid health insurance against the full fringe benefit amount that must be paid when employees work on prevailing wage jobs?
We’ve put together a video demonstrating the required QuickBooks setup and a free Excel Spreadsheet for tracking the costs of 100% company paid health insurance.
———————————————————————————————–
Information from the IRS regarding Employer Paid Health Insurance Reporting:
Employer-Provided Health Coverage — Not Taxable; Reporting is Voluntary for All Employers for 2011 and Small Employers for 2012
Starting in tax year 2011, the Affordable Care Act requires employers to report the cost of coverage under an employer-sponsored group health plan. To give employers more time to update their payroll systems, Notice 2010-69, issued last fall, made this requirement optional for all employers in 2011. IRS Notice 2011-28 provided further relief for smaller employers filing fewer than 250 W-2 forms by making the reporting requirement optional for them at least for 2012 and continuing this optional treatment for smaller employers until further guidance is issued. Notice 2011-28 also includes information on how to report, what coverage to include and how to determine the cost of the coverage.
The 2011 Form W-2 is available for viewing on IRS.gov. This is the W-2 that most employees will receive in early 2012. The form includes the codes that employers may use to report the cost of coverage under an employer-sponsored group health plan. {Currently, as of 12/12/2011, you will report Health Insurance Costs in Box 12 of the W-2 using code DD}.
This reporting is for informational purposes only, to show employees the value of their health care benefits so they can be more informed consumers. The amount reported does not affect tax liability, as the value of the employer contribution to health coverage continues to be excludible from an employee’s income, and it is not taxable.
What types of health care coverage must be included in the amount reported on the Form W-2?
A. Employers are required to report the total cost of all “applicable employer-sponsored coverage” provided to an employee. For any employee, “applicable employer-sponsored coverage” is coverage under a group health plan that the employer makes available to the employee that is non-taxable to the employee (or that would be non-taxable if the coverage were employer-provided).
Certain types of coverage are excluded from the definition of applicable employer-sponsored coverage and are not included in the amount reported. These types of coverage are:
- coverage only for accident, or disability income insurance, or any combination of these coverages;
- supplemental liability insurance;
- liability insurance (including general liability insurance and automobile liability insurance);
- workers’ compensation or similar insurance;
- automobile medical payment insurance;
- credit-only insurance; and
- other similar insurance coverage specified in regulations, if the benefits for medical care are secondary or incidental to other insurance benefits.
In addition, employers should not include the following amounts in calculating an employee’s total cost of coverage:
For additional information on this topic, visit these links:
- Affordable Care Act Tax Provisions - http://www.irs.gov/newsroom/article/0,,id=220809, 00.html
- 2011 Form W-2 - http://www.irs.gov/pub/irs-pdf/fw2.pdf
- IR-2011-31 - http://www.irs.gov/newsroom/article/0,,id=237870,00.html
- Notice 2010-69 http://www.irs.gov/pub/irs-drop/n-2010-69.pdf
- Notice 2011-28 http://www.irs.gov/pub/irs-drop/n-11-28.pdf
- Employer-Provided Health Coverage Information Reporting Requirements – Q & A - http://www.irs.gov/newsroom/article/0,,id=237894,00.html
- IRS YouTube Video – Health Care: W-2 Health Insurance Reporting - http://www.youtube.com/watch?v= TFepqFnEj5I&feature= youtu.be
- IRS Webinar - Reporting of Employer Healthcare Coverage on Form W-2 - http://www.irsvideos.gov/ReportingEmployerHealthcareCoverage/
- New Info added 1/3/2012 – IRS Notice 2012-09 – http://www.irs.gov/pub/irs-drop/n-12-09.pdf – Interim Guidance on Informational Reporting to Employees of the Cost of Their Group Health Insurance Coverage
We hope that you’ve found this post informative, if so please take a moment to leave a comment or share it on your favorite social network.
———————————————————————————————————
Update 12/16/2011 – Intuit Releases Payroll Update 21201
Late yesterday afternoon Intuit released Payroll Update 21201, which includes revised tax tables and several form updates. Included in this update is the option for reporting Health Insurance under Code DD on employee W-2′s.
When creating or editing an existing Company Contribution item type for Employer Paid Health Insurance, when you get to the Tax Tracking Type window, from the drop down list, select Health Coverage Cost, as shown in the screenshot below:
Right click on the image to enlarge it
We will be updating our video by the first of the year to reflect the actual selection of the correct tax tracking type.
Strategies for Making the Move to Public Works Construction Projects Seminar – American Subcontractors Association, San Diego branch, January 19, 2012
The current economic situation has dealt a serious blow to both homebuilders and commercial contractors and many are finding themselves make the move to Public Works construction and Prevailing Wage projects. Make the move to Public Works construction will require planning and quite possibly a variety of changes in the way you currently run your existing construction business.
Join industry experts; Steve Kuzmack, President of Fringe Benefit Experts and Nancy Smyth, President of Sunburst Software Solutions, Inc. for an intensive 2 hour session on January 19, 2012; on strategies for lowering labor costs and complying with certified payroll reporting requirements on Federal and/or State funded construction projects.
Learn How:
- To reduce payroll taxes and insurance premiums on your prevailing wage projects.
- “Bona Fide” benefit plans operate and how they decrease labor costs while increasing company profits and enhance employee benefit programs.
- You, the owner, can put more pre-tax money into your personal 401K.
- To smooth out the wage discrepancies between Private and Public Work.
- To save $2.00 – $4.00+ in payroll burden per man hour – based on San Diego Wage Rates.
- Supplemental Unemployment Benefit {SUB} Plans operate – and why your field workers like them.
Learn the Pros and Cons of Paying the TOTAL Hourly Prevailing Wage Rate on Payroll:
- Impact on your company
- Impact on your employees
Learn About Types of “Bona Fide” Fringe Benefit Plans:
- SUB Plan – “Field Workers Get Paid When Not Working” {Holidays, Layoffs, Reduction in Hours}
- Pension Plan – How to Increase Owner and Staff Pre-Tax Contributions
- Health Plan – Make Health Insurance Premiums not only Pre-Income Tax but Pre-Payroll Tax as well
Learn About Bookkeeping, Accounting & Payroll Procedures:
- When you pay the full fringe rate as part of employees hourly rate of pay
- When you pay the full fringe rate to one or more “bona fide” fringe benefit plans
- When you pay a portion of the fringe benefit rate to a plan and the balance in cash
Learn About Certified Payroll Reporting Requirements:
- What is a Certified Payroll Report?
- How do I complete a Certified Payroll Report?
- Are there different requirements for State and Federally funded construction projects?
If you want to get more competitive, grow your company and create more profit; then this seminar is for you.
This event will be held:
January 19, 2012 from 1:30 – 3:30 p.m. at the SMART Safety Office, 9471 Ridgehaven Ct. #C, San Diego, CA 92123. Non-member Price $60.00. Member Price $45.00. Register for the event OR download a seminar flyer.
