Ask any business owner how efficient he thinks his payroll and certified payroll processes are and I'm betting he'll either say "oh they are very efficient" or "they could be better". I attended a really great webinar called "A Tale of Two Payroll Processes" a couple of weeks ago, hosted by CPA Practice Advisor and presented by TSheets. During this webinar I learned some alarming facts that immediately took me back about 15 years to a time when I was doing a ton of payroll and certified payroll processes manually and literally wanted to tear my hair out. Continue reading →
Are you totally overwhelmed & confused in your search for “just the right” time tracking add-on for QuickBooks? I certainly understand! When you go to the Intuit Marketplace (https://marketplace.intuit.com/ ) and click on the option to Search by Business Need and then click on Time Tracking, you’ll find yourself with 51 different time tracking add-on programs to choose from! Little wonder you are overwhelmed and confused. I get that way too. This article provides you with some questions to ask yourself when you are searching for "just the right" time tracking addon for QuickBooks, introduces you to a few of our favorites AND let's you know how you can see these products in action over the next few months. Continue reading →
Intuit, for as many years as I can remember, has offered us a means of exporting various QuickBooks Lists into their own IIF format - so that we can import those lists into a brand new file. However, they have never provided us with a method to quickly and easily remove inactive list elements - before we import that list into the new file. This has caused much grief and aggravation over the years and as we all know; it's a horribly time-consuming task to manually remove those inactive list items. Enter, the QuickBooks IIF Inactive Cleanup Utility! Saving you countless hours (not to mention headaches) caused by scrolling through long IIF files and removing the inactive list elements before you can import them into a new file. Continue reading →
A QuickBooks automatic update for QuickBooks Pro 2013, Premier 2013 (all versions or flavors - Contractor, Manufacturing, Professional Services, etc), and Enterprise 13.0 (all versions or flavors), beginning right around June 3, 2013 with the last round of the update being released today, has created more problems than it fixed for many users and 3rd party developers.
Some users said that the automatic update caused QuickBooks to crash more often and the update also caused many 3rd party desktop add-ons to error out when connecting to QuickBooks or crashed QuickBooks when it attempted to connect.
What's your policy for installing QuickBooks automatic updates?
QuickBooks has no built-in ability to handle stored materials, like many of the more costly construction specific software programs. This causes problems for contractors who need to generate AIA Pay Apps and need to make sure that their books (or accounting data) syncs with their AIA Applications for Payments.
Because the General Contractor allows billing of stored materials on the AIA Payment Application you also need to include the amount of stored materials on your QuickBooks Progress Invoice in order for your accounting records to match your AIA billing records.
Calculating and distributing employee overtime is a burdensome process that many business owners and payroll administrators have to deal with on a weekly basis. Everyone has a different opinion on just "HOW" that overtime is to be calculated and distributed. By everyone, I mean the business owner, the payroll clerk, heck even the Federal and State government. No wonder it's just a problematic situation!
Should I/Do I NEED to upgrade to QuickBooks 2013? When should I purchase QuickBooks 2013? Will the 3rd party add-ons that I use be compatible with QuickBooks 2013? Will QuickBooks 2013 run on my current computer - OR - will I need to buy a new one?
An EEOC Report is really nothing more than than a report that includes how many employees you have that work under specific work/trade classifications by race and gender; including any apprentices or on-the-job trainees.
State agencies can require that you submit an EEOC report on a weekly or monthly basis, if the construction project is funded with State money.
If you perform work on Federal-Aid Highway Construction projects, you may be required to submit monthly reports - using either a Federal or State DOT specific form as well as an Annual Report such as Form FWHA-1391 . Federal-Aid Highway Construction Contractors Annual EEO Report.
Reporting fringe benefits paid in cash on the Federal WH-347 Certified Payroll Report has specific requirements which the built-in QuickBooks report cannot handle. Here is a question from a reader who is using the certified payroll report provided in the QuickBooks Enhanced Payroll subscription asking how cash fringes should be reported because her reports are being rejected because they aren't reporting the cash payment correctly.
This article will explain how any cash paid in lieu of fringe benefits on prevailing wage projects is supposed to be reported on the WH-347 form and why the built-in QuickBooks certified payroll report isn't handling it correctly.
How to "date" a QuickBooks 3rd party developer may seem to be a silly topic for a blog post; but as I reflect on the last 12 years of being one of those "developers" the more I think that the title is appropriate - because in reality dating is a fair way to describe the relationships between Developers, ProAdvisors and QuickBooks users.
In reality, dating is a fair way to compare this relationship. Let's start with mutual respect. Respect for each other, respect for the client, respect for our various corners. The customer isn't "your" client, just as the customer isn't "their" client - the customer becomes "our" customer and each party has a responsibility to them.
Are you being penny wise and dollar foolish over QuickBooks 3rd party apps and their price? Don't be ashamed, it happens to a lot of people. Many times a QuickBooks user will look at the cost of a 3rd party application and think - why should I spend the money on a third party application when I can just as easily do this task using Excel or some other way! This is insane, I've already spent a lot of money just to purchase QuickBooks. Ya, I get it - money is tight and we are all looking for ways to trim unnecessary dollars from our budgets - but are we sometimes being penny wise and dollar foolish? Many times I think that answer is "Yes". Here is a real situation that I was involved in just last week, I was talking with this gal who works for a contractor and she told that she had just spent a total of 7 1/2 hours RE-DOING and RECALCULATING 28 (twenty-eight) AIA billing in Excel for a project that they were working on because of a number of changes that had taking place along the way. Continue reading →
Displaying employee social security numbers and addresses on certified payroll reports, which are ultimately public documents, causes privacy and identity theft concerns for many employers and employees - not to mention confusion over reporting requirements. Read this question submitted by a blog reader and our response. Continue reading →
Quite often an 80040408 error when using QuickBooks and a 3rd party integrated application is the result of installing/using the two programs under the Windows administrator account on a Windows Vista or 7 computer. Learn how to create a new administrator account and change the original account into a standard user account. Continue reading →
The integration between QuickBooks and a third-party application is transparent, the communication between the two programs takes place behind the scenes leaving very little to be seen - often only the end result. Continue reading →
Nancy Smyth, Sunburst Software Solutions, Inc.QuickBooks Construction & Payroll Expert
I've been using and supporting QuickBooks products since the early 1990's. I've worked with thousands of contractors, assisting them with QuickBooks setup, Certified Payroll Reporting requirements, AIA Billing and Weighted-Average Overtime.
QuickBooks is a powerful product, but learning how to use it in your construction business can be difficult. I hope you find resources available here to be helpful.
Top QuickBooks blogs to read in 2018
We've been selected by TSheets as a Top QuickBooks blog to read in 2018!
Search this site
Sign up to receive our latest QuickBooks Tips, Tricks & News via email:
We promise NOT to sell, rent, or otherwise distribute your name and email address!
FREE 30-Day Trials
Request FREE 30-day Trials of QuickBooks add-ons for Certified Payroll, AIA Billing & Payroll Wage Management. Save time and increase accuracy on time-consuming error prone tasks; so you get paid on time!
Certified Payroll Training:
Learn how to complete a Certified Payroll (Prevailing Wage) Report and fulfill your reporting requirements - 2 hour recorded webinar - $99.99. Click here for more info.