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.
There are two possible ways to track retainage (retention) that you owe to your subcontractors; one method utilizes a Sub-Account of Accounts Payable, called Retainage Payable, and the other method utilizes an Other Liability Account, called Retainage Due to Subcontractors. Please review the setup and use of both methods, and choose whichever one seems more appropriate for your use.
You will need to inform your accountant of this at year end, so he or she, may make the necessary Journal Entries.
Method 1: Retainage as an Accounts Payable Sub-Account
Accountants tend to really like this method, but, it is a two-part process for the person actually doing the billing, which means that it’s error prone, simply due to normal day-to-day distractions.
From the Lists menu, choose Chart of Accounts
- From the Chart of Accounts window, click the Accounts button (lower left), and choose New
- Choose Accounts Payable as the Account type
- Enter an Account Number
- In the Name Box, enter Retainage/Retention Payable
- Click on the Subaccount of box, and choose Accounts Payable
- In the Description box, enter Retainage/Retention Payable on Contracts
- Click OK
Deducting Retainage/Retention Payable on a Vendor/Subcontractor Bill
If you have created a Purchase Order for this subcontractor and are now receiving his first progress billing, choose Vendors, and Receive Items with Bill, and if you have not created a Purchase Order, simply choose Enter Bill.
Select the Subcontractor from the drop down list; change the date, enter a Reference Number, the total amount of the bill, select terms, due date, and enter a memo if applicable – select either the Expenses or Item tab, and pull in the appropriate Item Code or Expense account associated with the vendor bill, and select the Customer: job. In the next blank line, again, pull in either the Item Code or Expense Account, enter the retention as a negative amount, in the memo field type in less retainage held, choose the Customer: job from the dropdown list.
Sample 1 below shows a sample bill created from a Purchase Order using the Item tab:
Sample 2 below shows a sample bill created using Enter Bills and the Expenses tab:
Recording Retainage Payable
Select Enter Bills; change A/P Account from Accounts Payable to Retainage/Retention Payable. Select your subcontractor; enter date of original subcontractor invoice, in the Ref. No., input the invoice number followed by, –R to indicate Retainage/Retention, enter amount due, change your terms to reflect when you will pay the retainage, select either the Item Code or the Expense account, and select the job.
Sample 1 shows a bill for retainage entered using the Items tab:
Sample 2 shows a bill for retainage entered using the Expenses tab:
Method 2: Retainage Payable as an Other Liability Account
This is a simple one-step process for the person actually doing the billing, and at the end of the year, the accountant will need to do a Journal entry to move the dollars for tax return purposes.
From the Lists menu, choose Chart of Accounts
- From the Chart of Accounts window, click the Accounts button (lower left), and choose New
- Choose Other Liability as the Account type
- Enter an Account Number
- In the Name Box, enter Subcontractor Retainage/Retention Payable
- In the Description box, enter Retainage Payable on Contracts
- Click OK
Setting up Items to Deduct Retainage Payable
- From the Lists menu, choose Item List
- From within the items List window, click the Item button (lower left), choose New
- In Type box, select Other Charge
- In the Item Name/Number box, type in 92 Less Sub Ret
- In the Description box, type in Less Subcontractor Retainage/Retention
- In the rate box, leave the amount set to 0 (you cannot use percentages in the detail of the bill) in the
- Account box, select the account used for Retainage Payable on Contracts
- Click OK to create the new item
NOTE: If you have different flat rates of retainage (retention) that you use, a separate item can be created for each of them using the rate in the Item Name|Number.
Deducting Retainage Payable on a Vendor/Subcontractor Bill
If you have created a Purchase Order for this subcontractor and are now receiving his first progress billing, choose Vendors and Receive Items with Bill, and if you have not created a Purchase Order, simply choose Enter Bill.
Select the Subcontractor from the drop down list; change the date, enter a Reference Number, the total amount of the bill, select terms, due date, and enter a memo if applicable – select either the Expenses or Item tab, and pull in the appropriate Item Code or Expense account associated with the vendor bill, and select the Customer: job.
Sample 1 shows a deduction for retainage using the Items tab:
Sample 2 shows a deduction for retainage using the Expenses tab:
While this is a much more simple process than Method 1, it will not reduce total expenses or Cost of Goods Sold, on a Profit and Loss Report. You will need to inform your accountant of this at year end, so he or she, may make the necessary Journal entries.
Recommendations:
Create a copy of your actual QuickBooks company data file and experiment with each of these methods to determine which is the right method for your company –and discuss this with your accountant so that they are aware of what you are doing!
Did you find this article helpful? If so please take the time to leave a comment – or share it with your friends.
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.
