A QuickBooks for contractors tip about receiving and applying joint checks from a general contractor to pay a lower tier subcontractor or material supplier for work completed or materials on a construction project.
Quite frequently, in the construction industry, a contractor will receive a joint check from a General Contractor to pay their lower tier subcontractors or material suppliers for work completed and/or materials delivered to the construction project’s job site.
Unlike many high-end construction accounting packages, QuickBooks doesn’t have a way to handle this automatically — or easily.
This QuickBooks for contractors tip provides what we consider to be a best practice when a situation like this arises.
Problem:
Your company, Sam Subcontracting, received a $10,000.00 joint check from Joe’s General Contracting; which is made out to both your company AND O’Fallen Gravel {your Vendor/Material Supplier} who delivered sand, gravel, and crushed rock to a jobsite. The $10,000.00 was included in your most recent invoice totaling $45,000.00 that you sent to Joe’s General Contracting AND you have a $10,000.00 invoice from O’Fallen Gravel in Accounts Payable. Amy, your bookkeeper, isn’t sure how to correctly receive this payment against your own Accounts Receivable AND correctly apply this payment to your Accounts Payable.
Solution:
When Amy is ready to receive the payment against the invoice issued to Joe’s General Contracting AND record the payment to O’Fallen Gravel, she should do the following:
- Verify that she has a special “Clearing” Account in her QuickBooks Chart of Accounts that is a “Bank” type – if one does not exist she should create it by going to the Lists menu -> Chart of Accounts -> Account -> New -> Type = Bank -> Continue -> Account Name = Clearing -> Save & Close.
Right click on the image to enlarge it
- Click the Receive Payment icon on the QuickBooks Home Page – OR – from the Customers menu -> choose Receive Payments. Received From = Joe’s General Contracting -> Amount = $10,000.00 -> Date = Current Date -> Pmt. Method = Check -> Check # = Check Number -> Memo = Joint Check issued to O’Fallen Gravel -> Deposit to = CLEARING ACCOUNT. Click Save & Close.
Right click on the image to enlarge it
- The balance in the Clearing Account should now be $10,000.00.
- Click the Pay Bills icon on the QuickBooks Home Page – OR – from the Vendors menu -> choose Pay Bills. Choose the O’Fallen Gravel bill -> Method = Check -> Select Assign check number -> Account = CLEARING ACCOUNT.
Right click on the image to enlarge it
- Click Pay Selected Bills.
- In the Assign Check Numbers window – enter the number of the check that you received from Joe’s General Contracting.
Right click on the image to enlarge it
- Click OK
- The balance in the Clearing Account should be 0.
Make sure that you also have the proper Lien Waive and Release forms.
We hope you found this QuickBooks tip to be useful — if so please take a moment to leave a comment, share it on your favorite social media site or click the +1 button below.
A QuickBooks for contractors tip about issuing joint checks to a subcontractor and a lower tier subcontractor or material supplier for payment for work completed on a construction project.
Quite frequently, in the construction industry, a contractor needs to issue a joint or two-party check to a subcontractor and a lower-tier subcontractor or material supplier for work completed and/or materials delivered to the construction project’s job site.
Unlike many high-end construction accounting packages, QuickBooks doesn’t have a way to handle this automatically — or easily.
This QuickBooks for contractors tip provides what we consider to be a best practice when a situation like this arises.
Problem:
Joe’s General Contracting, Inc. needs to issue a $10,000.00 joint check to Sam Subcontractor AND O’Fallon’s Gravel for sand, gravel, and crushed rock which was delivered to a jobsite. Sam Subcontractor is one of Joe’s regular subcontractors and is already in the QuickBooks Vendor List; O’Fallon’s Gravel is not a normal supplier and is not setup in the Vendor list. Sarah, Joe’s bookkeeper isn’t sure how she should handle a joint check.
Solution:
When Sarah is ready to write the joint or two-party check, she should follow these steps:
- Edit Sam Subcontractors Vendor record in QuickBooks and in the Print on Check as field, she should add AND O’Fallon Gravel. She should also edit the Billed From Address so that it to displays Sam Subcontractor AND O’Fallon Gravel. Clicking the OK button to save her changes.
Right click on the image to enlarge it
- From the Write Checks window, select Sam Subcontractor, enter the dollar amount. In the Memo field type in Joint Check issued to Sam Subcontractor AND O’Fallon Gravel and then job cost as usual.
Right click on the image to enlarge it
- Print just this check.
- Immediately go back to Sam Subcontractors Vendor record and delete all references to O’Fallon Gravel, click OK to save the changes.
- Customize the columns to display in the Vendor Center to include the memo field.
Right click on the image to enlarge it
Make sure that you also have the proper Lien Waive and Release forms.
We hope you found this QuickBooks tip to be useful — if so please take a moment to leave a comment, share it on your favorite social media site or click the +1 button below.
Each Friday, here on the QuickBooks for Contractors blog, we will be offering a free QuickBooks related eBook, offering tips, tricks, and training – so stayed tuned, visit often or sign up to have our posts delivered daily via email.
This week’s eBook provides information and tips for setting up a system to track Subcontractors Workers Compensation and General Liability Insurance expiration dates.
When a contractor works on a construction project and he/she hires subcontractors; one of the things that he is required to keep on file is a CURRENT copy of each subcontractors Worker’s Compensation Insurance Policy and a copy of their General Liability Insurance.
Keeping track of expiration dates and making sure that you always have a copy of the current policy on hand, can be a daunting task.
A reader wrote to ask the following question:
I have a vendor (subcontractor) whose general liability insurance expired. In QuickBooks I was able to produce a check for them. How do I QuickBooks to notify me that their insurance has expired?
Answer:
Unlike some of the more costly construction specific software programs out there, QuickBooks wasn’t designed to prevent us from generating a check to a Vendor/Subcontractor whose General Liability or Worker’s Compensation insurance has expired.
The QuickBooks Premier (or Enterprise) Contractor edition does have a “section” in the Additional Info tab of the Vendor Record where you can enter an expiration date for both Worker’s Comp and General Liability insurance – and if you enter dates in these fields you will get a warning when using a vendor whose insurance has expired – however, it will not prevent you from writing the check, entering the bill, or creating a purchase order.
In other versions of QuickBooks Pro, Premier, or Enterprise; you can create “Custom Fields” to use in the Vendor record – but they will not produce even a warning.
There are several things that you can do – but none of them will automatically “warn” you before the Subcontractors insurance does expire OR prevent you from writing them a check after it has expired.
One thing that you can do is have your Vendors/Subcontractors request a Certificate of Insurance from their insurance company, listing you as a Certificate Holder. That way you receive a Certificate showing the policy period AND you would also be notified if the coverage was canceled or if it expired.
Even having access to this information directly from the Vendors insurance agent isn’t enough if you don’t have a policy and/or procedure in place for tracking this.
While QuickBooks won’t do anything automatically for you, it will provide you with tools (date tracking, report generation, letter creation, Reminders, and To Do Notes) to implement a good system for tracking this information.
Request our FREE eBook – “QuickBooks Tips & Techniques – Setting Up & Tracking Subcontractors Worker’s Comp Insurance”.
This FREE 13-page eBook will provide you with complete instructions for setting up and maintaining a system for tracking expiration dates of Subcontractors Worker’s Comp AND General Liability Insurance.
ASA (American Subcontractors Association) of Arizona Shows Leadership in Securing Prompt Pay of Retainage & Final Payment.
(from Contractor Power Newsletter)
ALEXANDRIA, Va. — A new law (S.B. 1375) signed by Arizona Gov. Jan Brewer (R) on May 11, 2010, adds requirements for timely payment of retainage and final payments to the state’s prompt payment statute for construction. The law, supported by the American Subcontractors Association of Arizona and its allies representing a broad range of the state’s construction industry, establishes a payment cycle according to which non-residential project owners, prime contractors, and subcontractors normally will have to pay retainage and final payments for properly completed construction services and materials, or else pay a penalty of 1.5-percent interest per month.
The governor of Arizona has signed into law the most significant construction legislation improving subcontractor rights within the last 10 years, said ASA of Arizona President Jeff Banker, Banker Insulation Inc., Chandler, Ariz. ASA of Arizona was proud to have a leading role in helping shape the new law and the future of construction in Arizona.
The law, which applies to projects for which contracts, plans or specifications are distributed on or after Jan. 1, 2011, will require prime contractors to submit timely applications for payment according to the project’s billing cycle (normally 30 days). Unless stated otherwise in the construction plans, project owners will have to approve within 14 days, and pay within 7 days after that, proper invoices for retainage that subcontractors submit at substantial completion of their work. The law will also establish a 21-day cycle for project owners to pay prime contractors proper invoices for final payment. It will limit owners withholding of such payments to 150 percent of the reasonable costs to complete any work that is under dispute.
Prime contractors and subcontractors will have seven days from receipt of retainage and final payment to pay their subcontractors and material suppliers, except when reasons for withholding are detailed in a written notice. The law will entitle subcontractors to written notifications of retainage releases by owners once subcontractors request such notifications. It will specifically protect subcontractors from wrongful withholding for defective work or materials that are not their fault. Where subcontractors are not at fault, the law says, The Contractor shall nevertheless pay any subcontractor or material supplier … within 221 days after payment would otherwise have been made by the owner.
ASA of Arizona and its allies worked hard throughout this long legislative process to prevent damage to existing prompt payment rights and to enact these beneficial payment reforms, said ASA of Arizona Advocacy Chairman Richard Usher, Hill and Usher Insurance & Surety, Phoenix, Ariz. The volume of Arizona construction is down dramatically in all market segments, which makes protecting payment rights and getting paid promptly as important as ever to subcontractor prosperity and survival.
Founded in 1966, ASA amplifies the voice of, and leads, trade contractors to improve the business environment for the construction industry and to serve as a steward for the community. ASA’s vision is to be the united voice dedicated to improving the business environment in the construction industry. The ideals and beliefs of ASA are ethical and equitable business practices, quality construction, a safe and healthy work environment, and integrity and membership diversity.
ASA Contact: David Mendes
(703) 684-3450, Ext. 1335
dmendes@asa-hq.com
Tracking retainage is a common function of percentage-of-completion contract billing using AIA Forms G-702 & G-703. To learn more about AIA Billing and how to complete forms G-702/G-703, click here.
