Redstone - 5 Tips for Government Contractors Using Quickbooks.jpg

For most small businesses - and especially for those in the early stages of their life cycle - Quickbooks is an excellent option and an almost fundamental starting point when considering an accounting software from which to grow your company. It is cost effective, easy to use, and given its popularity and presence in the market, training resources are readily available. But is it a viable option for Government Contractors?

According to the Small Business Association (SBA), nearly 25% of all government contracts each year are awarded to small businesses. That’s great news for small businesses – and even better, when properly implemented, Quickbooks software is perfectly capable of passing a DCAA pre-award audit (i.e. an accounting system adequately designed to accumulate and report costs on cost-type contracts). Sure, you’ve heard stories of government contractors sinking tens of thousands of dollars into multifaceted ERP systems that can tell you how many Direct Labor hours you’ll have left on ACRN 0109 AB on Tuesday April 20th, 2021, but that’s typically a long-term solution for a mature contractor with large, complex government contracts. But for purposes of an initial foray into government contracting, Quickbooks is perfectly acceptable and adequate, if you know it’s limitations.

Here are a few tips that will help keep your books in good standing in the eyes of DCAA while you continue to expand your presence in the government contracting world: 

1. Always enter your bills into the ‘Enter Bills’ module

While it is tempting to simply use the ‘write checks’ function to pay a bill in Quickbooks in order to save time, doing so will compromise the accrual based reporting requirement for government contracts. Quickbooks’ ‘write checks’ function will allocate the expense to the month in which the check was written, instead of the month in which the expense should be allocated according to accrual-based accounting.

2. Prepare labor accruals on a monthly basis

Similar to the ‘write checks’ issue above, Quickbooks allocates labor cost on a cash basis – by default, all labor is allocated to the month in which your payroll is paid rather than the month in which the work was performed. An adjusting journal entry should be made at month end (and subsequently reversed in the following month) to allocate labor cost to the appropriate period.

3. Prepare PTO accruals on a monthly basis

Your PTO expense reflected on the P&L should be the sum of each employee’s total accrued hours, multiplied by their respective hourly rates. By default (again), the amount that shows up on the P&L in Quickbooks is based on the number of PTO hours used, not accrued.

4. Prepare revenue accruals on a monthly basis

Revenue recognition from a Quickbooks perspective is always based on billing – and the period in which revenue is recognized is driven solely by the date that you enter on the invoice in Quickbooks. An adjustment should be made each month based on your internal revenue recognition policies and procedures.

5. Reconcile your Direct Costs on the P&L to your Direct Costs on the P&L by Job

The P&L by Job report is easily one of Quickbooks’ most useful tools for Government Contractors. It is essentially a consolidated snapshot of each individual project broken down by cost element and profitability. However, it is also one of the most commonly inaccurate reports – and the solution is simple: For every transaction you enter into Quickbooks that should be allocated to a project (including journal entries) be sure to select the appropriate project in the ‘Customer: Job’ field.

Acceptable Accounting Systems for Government Contractors

In summary, there are potentially acceptable (adequate) accounting systems which won’t break the bank, but keep in mind that there is nothing which is categorically a “DCAA approved accounting software” (DCAA does not issue a “seal of approval” or otherwise endorse a particular product).   A product might work, but only if it’s properly designed/installed and used correctly and regularly.    

Contact Us for a Consultation

Written by Cory Scott

Background Mr. Scott is a seasoned government contracts and accounting professional with almost a decade of experience working with small businesses and not-for-profit organizations to meet regulatory expectations for contracts and grants with the U.S. Government. In Cory’s career thus far he has held diverse roles that frequently challenged him to learn and quickly adapt to changing conditions and rapidly establish new and compliant processes to meet contract expectations. He has served as a project controller responsible for Antarctic expeditions at a well-known educational not-for-profit, Controller and independent consultant to multiple small businesses, as well as roles with responsibilities in the areas of contracts administration and purchasing. Professional Experience Prior to joining Redstone GCI Cory worked a variety of roles with both for-profit and not-for-profit organizations working with the U.S. Government. These roles spanned contracts administration, accounting and compliance functions. His prior experience includes working with many small businesses to establish DCAA compliant accounting, timekeeping and purchasing systems. In his prior roles he was responsible not only for the implementation and operation of accounting systems, but also for the training and education of staff members on compliance expectations and preparation for audits such as DCAA Incurred Cost Audits, Voucher Examinations, Pre/Post Award Accounting System Audits, Labor Floor Checks and many other frequently occurring interactions with auditors from the Defense Contract Audit Agency. In addition to compliance roles, Cory has been responsible for budgeting, proposal pricing, contract administration and traditional accounting functions (AP, AR, Billing, Payroll, et. al). His diverse skillset provides our clients with an excellent resource in the areas of small business accounting, contract administration and not-for-profit grant support. Cory is experienced with a variety of accounting systems including Deltek GCS Premier, Costpoint, QuickBooks and Unanet. Education Cory graduated from the University of Alabama in Huntsville with a BSBA in Accounting and a Master of Accountancy degree.

About Redstone GCI

Redstone Government Consultants are a team of the most senior industry veterans and the brightest new talent in the industry. Many have held senior government positions including leadership roles in the DCAA. Our new talents bring significant accounting and software experience along with fresh perspectives, inspiration and energy to our team. Through our leadership and combined experience, we provide a unique perspective, bringing both government and contractor proficiencies to bear and ensuring rock-solid government compliance for our clients.

Topics: Compliant Accounting Infrastructure, Quickbooks