Top 10 Thursday features 10 of the most interesting articles that I found the previous week. There is so much news and information available on the web – it’s difficult to read everything and stay up to date. As I read articles on the web – I’ll share some that I feel are important.
General Business:
- Losing focus? 9 ways to concentrate at work
- Why to-do lists set you up for failure
- Have a pet? Perhaps they can help you out at work {sorry this is just a really cute YouTube video}
Bookkeeping, Accounting, Payroll & Taxes
Construction News
- Checking and Documenting Federal Debarment Status of Vendors
- Asphalt group questions life-cycle cost analysis procedures
- Check out the January issue of Construction Digital
Marketing & Social Media
- 8 Easy Ways to Boost Your Website on a Budget
- Easy Tips for Smart Social Media Strategy {YouTube video}
Well, there’s our Top 10 most interesting articles for last week – do you have some interesting news that you’d like to share?
Working with taxable and non-taxable items and customers in QuickBooks sometimes just freaks people out and causes them to over think the entire situation. I’m frequently asked how to do this by people who are setting up our AIA billing program – here’s a question that I received recently.
I am getting ready to set the AIA billing program {Construction Application for Payment Solution} up tomorrow and just have a few questions.
Should the income items each be posted to an income general ledger account? Or will I use the subtotal line to point to an income account? If I have to post each income item to an income account – I will have to do 2 sets of them, one for wholesale (no tax) and one for retail (taxable) and I would like to avoid this if possible. I guess though we will have to post them to an income account…..thoughts?
Should we use the group items to setup our labor and materials for the schedule of values? For example, when we bill the customer- we only want DEMOLITION to show up, but for our purposes we have the DEMOLITION broken into labor and material. It seems like this would be a good place to use group items?
Each of your QuickBooks Items/Cost Codes should be set up and linked to BOTH and Income and an Expense/Cost of Goods Sold Account otherwise you’ll never get any decent job costing reports.
Subtotal Items do not link to either an Income or an Expense Account – they simply add up the numbers above it and display the amount on the Estimate and Progress Invoices that you create.
Unless you want to track Wholesale and Retail Income individually on your Profit & Loss Report, there is no need to create two sets of Items. QuickBooks can handle both taxable and non-taxable customers and sales using the same item list. You’ll just want to make sure that you have two Sales Tax Items – one that actually charges the Sales Tax Rate and one that has a 0% rate for Non-taxable sales.
Below is a YouTube video that demonstrates the procedure and shows you what your Sales Tax Liability Report will look like if you do it correctly.
As for using group items to track labor and materials for a specific cost code, there are a couple of different options that you could use, depending upon the amount of detail that you want to track. But group items are definitely the way to go if you want to job cost more information than you want the customer to see.
I hope you’ve found this article to be informative, if so please take a moment to leave a comment or share it with others on your favorite social media network using the buttons below.
Payment of fringe benefits on prevailing wage jobs frequently cause a lot of confusion – such as the question submitted below from a reader.
My boyfriend is being told that the company he works for will be taking half his pay each week to put in a 401k HALF!!! I wanted to know if this is legal—they say if he doesnt sign the paper he will be fired so it is mandatory. Is this legal? He is in construction and works for a prevailing rate. Thank you very much – Janelle
Hi Janelle
There may be some confusion and/or miscommunication going on here and NOT knowing the full details I can only provide you with basic information.
When an employee works on a prevailing wage job {rate job}, he has to be paid a specific dollar amount that is made up of two pieces – a base hourly rate of pay AND an hourly fringe benefit amount – which is usually comparable to what union employees are making. This rate is also usually more than what he is normally paid when working on other jobs; even when he is performing the same type of work.
Companies that work on prevailing wage jobs have various ways that they can pay the fringe benefit portion:
- If they are a Union Shop, they MUST pay the fringe benefit amount to the Union Hall on behalf of the employee
- If they are a Non-Union shop {which by the sounds is the type of company your boyfriend is working for} they have the option
- To pay the employees an hourly rate that is equal to the base rate PLUS the fringe rate {this means higher taxes for everyone}
- To put the hourly fringe rate into a bona fide plan {like a 401k} on the employees behalf {this means LESS taxes for everyone, the money still belongs to the employee {your boyfriend} but he can’t touch it until he retires {unless there are special provisions in the plan setup}
- To pay a portion of the FULL fringe benefit rate to a bona fide plan and then the balance in cash as part of the employees rate of pay
Yes, this is legal, and while it may “seem or feel” like the company is taking half of his paycheck, in reality he will be getting more money {even though he can’t spend it right away} when the fringe rate is put into a 401k.
More and more companies that work on prevailing wage jobs are opting to use the fringe portion of the prevailing wage to legally purchase bona fide fringe benefits, that they might otherwise not be able to afford to do, for their employees. In addition to putting the fringe dollars into an employee 401k they may also purchase health insurance for their employees and put the balance into a Supplemental Unemployment Benefit Plan {which is then used to pay employees for short work weeks}.
I contacted my good friends Jim Proffitt of Prevailing Wage Contractors Association and Steve Kuzmack of Fringe Benefit Experts and they both feel that companies should take the fringe benefit portion of the prevailing wage and purchase health insurance, establish pension plans, and then put the balance of the fringe money into a Supplemental Unemployment Benefit Plan.
Many companies are not familiar with a Supplemental Unemployment Benefit (SUB) Plan. Unlike a 401k or other pension plan; a SUB Plan pays you when you need it the most, while you’re not working or have missed some time. The SUB Plan can pay employees when they have a short work period, which is defined as working less than 40 hours in a week or less than 173 hours in a month. Short work periods can be caused by layoffs, bad weather, illness, lack of work, equipment down time or any number of reasons.
If you would like more information about Supplemental Unemployment Benefit (SUB) Plans please feel free to contact Jim, Steve, or myself – indicating that you found this information on our blog.
Take a look at this article on my blog that shows the difference between paying the fringe to the employee vs. putting it into a bona-fide plan – http://blog.sunburstsoftwaresolutions.com/2011/05/25/the-benefits-of-paying-prevailing-wage-fringes-to-a-bona-fide-plan/#.Tvx9Mo7330c
I hope you found this article to be helpful, if so please take a moment to either leave a comment or share this information on your favorite social networking site – prevailing wage laws and fringe benefits can be very confusing.
An “audit trail” for Accounts Receivable in QuickBooks is only one of the many complexities faced by government construction contractors. Running any sort of construction business can be difficult – but the amount of paperwork, the level of detail, and the additional requirements for a government contractor can cause 2 and sometimes 3 times the amount for a bookkeeper. Below is a question submitted by a reader named Shirley.
We are a Construction Company and do government contracting. Is it possible to use the Accounts Receivable Summary to track each Project and the invoices when received and when paid. It has been several years since I have used QuickBooks and have never used the Construction Version. We have QuickBooks 2011 Premier Construction.
————————————————————————————-
First, let me say that the Contractor version doesn’t work any differently than the Pro – it just has some built-in construction specific reports and other features that aren’t available in other versions. So your learning curve shouldn’t be difficult at all! That’s the good news 
As for using the Accounts Receivable Summary Report as an audit trail, personally I don’t think I would use that because it wouldn’t give me the detail that I would want – OR – that I “think” you are looking for. The A/R Summary report only shows you how much {total} money is overdue in 30, 60, and 90 day increments. This information may meet your needs if you just need to know how much money is how many days overdue by job.
Right click on the image to enlarge it
My own personal preference, would be to know which invoices were how many days past due; therefore, I would rather run the Accounts Receivable Aging Detail to determine exactly which invoices where outstanding.
Right click on the image to enlarge it
Both of these reports would provide me with information about just a specific job – each could be modified and filtered for a specific job or jobs.
Another very good report, especially if you are concerned about a specific job, is the Customer Open Balance Report {available from the actual QuickBooks job record and choosing Open Balance}.
Another alternative to obtain this information easily, without running and printing reports – would be to customize how job record information is displayed in QuickBook, that way anyone who has access to this type of information can easily see it without having to run, print, and then distribute reports. Remember, it’s all about efficiency and streamlining the workload/work flow. Customizing how information is displayed in the job record let’s you quickly see how much total money is outstanding for a specific job, when invoices were created {dated}, the date you anticipate receiving the money, how many days outstanding the money is, what the invoice was issued for and the open balance.
Right click on the image to enlarge it.
For tracking Vendor costs you could run a Job Cost by Job and Vendor Detail, click the Modify Report button and customize it like the screenshot below:
Right click on the image to enlarge it
QuickBooks can do many things, including provide you with an “audit trail” for Accounts Receivable and Accounts Payable. You just have to get in there an poke around and see what works for you.
While the information provided about may not answer the original question to the 100% satisfaction of the person asking it, based on the information provided it should at least provide you with things to look at and modify to best meet your needs.
If you found this tip to be helpful, please take a moment to leave a comment or share it on your favorite social network.
This QuickBooks tip explains where you can easily access employee payroll forms; including the Federal I-9, W-4, and W-9′s.
Having used QuickBooks for many years, I can remember when needing an I-9 (Employment Eligibility Verification), a W-4 (Employee’s Withholding Allowance Certificate), or a W-9 (Request for Taxpayer Identification Number and Certification) meant a trip to the appropriate website to obtain the most current form – and depending on how busy I was at the moment, that could be a royal pain!
The I-9, Federal W-4, and W-9 are now available to anyone with a current payroll subscription using QuickBooks Pro/Premier 2009-2012 or Enterprise 9.0-12.0 from the Employees menu -> Employee Forms option; you’ll also find a Direct Deposit and Pay Card Authorization form.
Right click on the image to enlarge it.
NOTE: If you don’t see the Employee Forms menu option; choose the Get Payroll Updates option and get the latest payroll update. Restart QuickBooks after the update has been installed.
The forms open in a “fillable”. pdf format, so employees can type in their I-9, W-4, Direct Deposit or Pay Card Authorization information and it will be legible!
You can easily send W-9′s to your vendors as an email attachment {once the .pdf of the W-9 is open and visible, from the File menu -> choose Attach to email}.
You will still need to obtain the current version of the State W-4 from their website and have that on hand.
These are certainly handy forms to have quick access to and will save you from having to worry about whether or not you have a copy of the form, the most current version of the form, or from having to go searching on the internet to download the most current version that is available.
Critical note: You MUST have a .pdf creator/reader installed on your computer in order to open/use these forms. If you currently don’t have a pdf creator/reader, check out Foxit Reader – it’s free!
We hope you’ve found today’s QuickBooks tip to be helpful; if so please take a moment to leave a comment or share this tip with others via your favorite social networking site using the buttons below.
