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.
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.
QuickBooks 2012 has both good and bad pop-up messages – just like any other version of QuickBooks, but there is nothing more annoying than having an ad pop-up when you are working in QuickBooks. Let’s be honest, getting rid of the message is another mouse click that you have to make and if messages and ads are popping up frequently we get into the habit of not reading what they have to say and miss something that could very well be important. This article discusses how you can turn off most of them in QuickBooks 2012.
Ok, I get it – Intuit is a business that makes it’s money selling software and services to it’s customers; but as a customer/business owner I have already purchased the software and probably have the services that I need already in place; so to be honest I get really annoyed with pop-up messages and ads. I bet you do also.
To be fair, there are actually some good pop-up messages in QuickBooks – for example:
- those that prompt or remind you to add a class to a transaction when you’ve forgotten and you’ve turned on the class tracking feature
- the one that warns you when you are posting a transaction directly to Retained Earnings – which is something that you really do NOT want to do
- the warnings that appear when you accidentally select a date that is 90 days in the past or 30 days in the future
- the warning that will appear if you enter duplicate bill numbers for the same vendor
- the warning that will appear if you enter a check number, invoice number, estimate number, etc. that has previously been used
For the most part messages & pop-ups can be controlled through settings in the Preferences section {Edit menu -> Preferences}; where you will find both personal and company preference settings. Only the QuickBooks Administrator can make changes to the settings in the Company Preferences tab when they are logged into QuickBooks in single-user mode; yes, another inconvenience but one that is well worth the effort. I highly recommend that the QuickBooks Administrator take the time to check out the Company Preference tab for each of the 22 different sections and choose which types of messages should and should not appear.
Individual users also have some control over what messages appear. For experienced users, I recommend that they to to the Edit menu -> choose Preferences and:
- select Desktop View -> My Preferences tab and uncheck the Show Getting Started Window
- select General -> My Preferences tab and uncheck the Bring back all one-time messages, Turn off pop-up messages for products and services, and Show ToolTips for clipped text
- select Sales & Customers -> My Preferences and uncheck the Show Payment toolbar on Receive Payments and Sales Receipts forms if your company does not wish to add Intuit credit card or eCheck processing
- select Service Connections -> My Preferences and uncheck Give me the option of saving a file whenever I download Web Connect data and If QuickBooks is run by my browser, don’t close it after Web Connect is done – if you do not use Online banking
Many pop-up windows and messages have a “Don’t show this again” checkbox option, checking this option instead of just clicking the OK button will rid you of the annoying box for good; so taking a minute or so each time a window pops up can help you to make informed decisions and rid you of wasted mouse clicks later. I know, sometimes it’s just “easier” at the moment to click the OK button just to get rid of the window – but that is a bad habit to get into.
Some advertising messages, you just can’t get rid of, for example the Do More with QuickBooks block on the Home page, but you can close it.
In QuickBooks 2012, Intuit has added a new “advertising” message to printed Employee Pay Stubs – you’ll now find a Powered by Intuit logo on each pay stub that you print for your employees. I found this to be quite annoying. Only the QuickBooks Administrator can remove this logo by going to the Edit menu -> Preferences -> Payroll & Employees -> Company Preferences -> Pay Stub & Voucher Printing -> and uncheck the Print Intuit logo option.
Are you annoyed with pop-up messages and ads? If so please take a moment to leave a comment or share this article with others on your favorite social networking site.
Best practices and tips for installing a QuickBooks 2012 upgrade on a computer that already has an existing version of QuickBooks in place.
Remember, QuickBooks MUST be installed using a Standard User Account when you are running Windows Vista or Windows 7 AND you use QuickBooks integrated 3rd party programs – see Windows, QuickBooks & 3rd Party Apps – The Struggle Within.
If you have Intuit do the upgrade, DO NOT let the Intuit rep install the new version from within your computer’s Administrator account and DO NOT let them choose the “upgrade” option when they do the installation. Also, make sure that your computer IT person is aware of the requirements and best practices – many do not.
Make sure that you watch and understand what is being done to your computer – don’t let others simply do “whatever”
Installing/upgrading QuickBooks is a fairly straightforward task, but that doesn’t mean that there aren’t some things that can trip you up along the way. Below are some “best practice tips”, based on technical support calls from our customers, that will help you to ensure a smooth installation/upgrade:
PLAN AHEAD and make sure that everything is in order – DO NOT install the new version of QuickBooks 2012 on the day that you need to run payroll, do billing, or perform any intensive task that requires access to your computer/company data file.
- Perform some basic file maintenance in your current QuickBooks version – backup your file, rebuild the data, check the current file size and number of database file fragments.
- If you use 3rd party integrated applications, make sure that you contact the software developer (if they haven’t already contacted you) about compatibility with and update procedures for working with QuickBooks 2012 – Gold and Silver Developers {those who have applications listed on the Intuit Marketplace} did not have access to a final release copy of QuickBooks 2012 until 9/12/2012; for other developers – well they might have access to the new version today.
- Start with the computer that houses your QuickBooks data file – paying close attention to the following screens.
- On the “Choose Installation Type” window select the “Custom and Network Option“
- On the “Custom and Network Options” window, select whatever the current settings are on your computer
- On the Upgrade or Change Installation Location window, choose the Change the install location option. This installs QuickBooks 2012 in a new folder and when the installation is complete you will have BOTH your current {old} QuickBooks version and the new QuickBooks 2012 version installed on the computer.
- When the installation is complete, you’ll be prompted to reboot your computer. After the reboot, start QuickBooks 2012 and open your company file.
- Rebuild your data file, check your file size and number of database file fragments.
- Install the new version of QuickBooks on each of your other computers; repeating Steps 4, 5, 6, and 7.
Once the new version of QuickBooks is installed and running properly on all of your computers, remove the old version by going to your Control Panel -> choosing Add/Remove Programs {Windows XP} OR Programs & Features {Windows Vista & 7}, find the old version in the list of programs and choose Uninstall or Remove.
We hope that you’ve found these best practices and tips for installing a QuickBooks upgrade to be helpful. If so please take a moment to leave a comment or share it on your favorite social network.
