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.
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.
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.
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:
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.
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.
This payroll tip discusses being prepared for Wage & Hour and IRS Audits – what records have to be kept, how long you need to keep them, etc. From the General Ledger, a complete newsletter for Professional Bookkeepers published by the American Institute of Professional Bookkeepers.
Break out the trusty old metal/wooden file cabinets and wipe off the dust — or maybe it’s time to invest in some virtual file cabinets where documents are scanned in and stored off-site but accessible if you need them. Either way you are in for a shock!
We’ve mentioned previously that the U.S. Department of Labor is making a major push on wage-hour enforcements and that the IRS has also beefed up enforcement efforts – but what we didn’t include at that time was a list of documents that you must keep and how long they have to be kept. When October’s issue of the General Ledger arrived, this information was front page news; and I felt I needed to share it with you. I hope you are sitting down and have had your morning coffee!
Even if your company has never violated one IRS or DOL rule, substantial penalties may apply simply for not maintaining required records. Now is the time to gather or seek copies of the records you are required to keep under federal law. Records may be stored at at company offices; or for multiple locations, in a central office.
Keep for at least 4 years:
The IRS requires employers to keep the following for at least 4 years. NOTE: Because the 4-year period begins at different time, keep the following for at least 5 years.)
|
|
The DOL or IRS (or both) require you to keep the following data. If not in hard copy, it should be available to print.
Keep for at least 3 years:
|
|
Keep for at least 2 years:
Documents that support calculations for the following.
|
|
Keep for at least 4 year
From April 15 following the due date of the return; employment related tax forms and data.
|
|
Vendor and non-employee payments:
|
|
All of this adds up to a LOT of paperwork that you have to keep on hand and accessible. Storage is going to be an issue for most businesses as well as making sure that the stored documents are kept safe – I know that these issues are a concern for me, as like most business owners I only have limited space.
We’ve used QuickBooks since we started our business in 2000, so all of the “detail” is housed in our QuickBooks file; we did have to archive our file at the end of 2006 because it was getting too big and running slow, so we have a backup copy that contains all the detail stored in our safe deposit box at the bank. Our current QuickBooks file contains a summary of that archived information, and I keep that backed up and stored in a several locations – locally on an external hard drive, on a remote (cloud based) location that both my husband and I have access to, and a backup which I keep on my laptop – so my QuickBooks file is pretty safe.
But, the hard copy paper payroll related data – well, right now all of that is stored by year in 3-ring binders; and all of the paper copies of business income and receipts are stored in cardboard file boxes in our attic! If there was a fire – well, we’d loose all that paper data! I guess it’s time that I get my act together and do something about electronic storage for at least all of the payroll related data.
How are you storing all of the information that would be required for a wage-hour or IRS audit?














