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.
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.
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.
Dealing with special customer invoicing requirements can be a royal pain! Sometimes it feel like each customer you deal with says “if you don’t invoice me like THIS you aren’t going to get paid”. While QuickBooks is a very flexible software program, sometimes it’s very difficult to meet the requirements of specific customers or clients. Below is a perfect example, submitted by a reader of just how difficult billing requirements can be.
I use QuickBooks Contractor version as a self-employed contractor with a hospital. The problem is I get the job on a P.O. from the hospital, say it’s for $80,000. As I do different stages of the job I bill the hospital for that stage and they send me a check. When I do the next stage the hospital wants the invoice to reflect the original P.O. and the money they have already paid. How do I do that on this software? Jean
____________________________________________________
Jean, I’m pretty certain that you can meet these requirements – it will cause some extra work on your part each time you are ready to bill the hospital for the next stage; but I don’t think it will be a lot of work.
Go ahead and create your invoice as usual – I’m making a BIG assumption here that you take the PO from the hospital and set that up as a QuickBooks Estimate and generate Progress Invoices from your Estimate {but even if you don’t that’s ok}.
Once you are viewing that Invoice in QuickBooks, click the Letters icon at the top and choose Prepare an Invoice Letter
Right click on the image to enlarge it
When the Choose a Letter Template window appears, select Invoice Letter with Details and then click the Next button
Right click on the image to enlarge it
This now sends your Invoice into Microsoft Word and by default provides information about the invoice that you can then modify to meet the invoicing requirements of the hospital.
Right click on the image to enlarge it
For example, I would change the heading called Invoice Amount $720.00 to read Original PO Amount $80,000.00, Invoice Balance $720.00 to read Previous Payments Received $XXX.XX, and add a line that reads Current Payment Due $720.00.
Right click on the image to enlarge it
NOTE: You can edit this letter template and include the changes to the wording – that way all you have to do is enter the amounts for Original PO and Previous Payments. To Edit a letter template go to the Company menu -> choose Prepare Letters with Envelopes -> Customize Letter Templates -> View or Edit Existing Letter Templates -> choose Invoice Templates -> Invoice Letter with Detail.
QuickBooks has a lot of built-in functionality – the problem is finding it! We hope you found this QuickBooks tip for dealing with special invoicing requirements to be helpful. If so please take a moment to leave a comment or share it on your favorite social network.
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.
