GovCon 360Dec 11 · ArlingtonDetails
Back to Blog

QuickBooks & GovCon· · 9 min read

DCAA Compliance Without Migrating Your Accounting Data

If you are on QuickBooks Online, you do not have to move your books to a new system to meet DCAA's accounting system criteria. What DCAA actually tests, where each requirement can live while QuickBooks Online stays your ledger, and when a migration does make sense.

DCAA Compliance Without Migrating Your Accounting Data

When a small government contractor starts preparing for DCAA (the Defense Contract Audit Agency, which audits contractors for the Department of Defense), the first plan on the table is often a new accounting system: export the books, rebuild the chart of accounts, move the history, retrain the team. For a company whose bookkeeping already works, that is a large project, and it is usually not what the audit asks for.

This guide is for owners and bookkeepers who keep their books in QuickBooks Online and want to know how to get to a DCAA-ready accounting system without migrating their data.

The short answer

DCAA does not require any particular software. It evaluates whether your accounting system, meaning your books plus your procedures, meets the criteria of the SF-1408 (the government's preaward survey form for a contractor's accounting system). Most of those criteria are about how your books are organized, which QuickBooks Online can handle. The gaps are on the labor side: daily timekeeping, labor cost by contract, and indirect rates. You can close them by adding tools that connect to QuickBooks Online and post back to it, so QuickBooks Online stays your ledger and nothing has to be migrated.

On QuickBooks Desktop? The same approach works, with one move first: from QuickBooks Desktop to QuickBooks Online. That is a change of version, not of system. Intuit's migration tool moves your accounts and balances, customers and jobs, classes, items and transactions, and your chart of accounts keeps its structure. A few things need a plan, such as paycheck detail and memorized reports. Moving From QuickBooks Desktop to QuickBooks Online as a Government Contractor covers what moves, what doesn't and how to set up contracts before the cutover.

An auditor tests what your system can show, not where it runs. Keep the ledger you have, and add what it cannot do on its own.

"The minimum is that whatever procedure or process they have follows the SF-1408. So it doesn't matter if they're using QuickBooks and Excel or QuickBooks and WiseCost or [Deltek]."

Brian Wendroff, CPA, Co-founder of WiseCost and Managing Partner at Wendroff & Associates, CPA

DCAA's position on software is covered in Is There Such a Thing as DCAA-Approved Software?

What a migration involves

A migration means replacing your general ledger with a new one, usually a GovCon ERP (enterprise resource planning software that runs accounting, projects and timekeeping in one system). Moving to it typically includes:

  • The chart of accounts, rebuilt in the new system's structure.
  • Opening balances and open items, such as unpaid invoices and bills, carried over and reconciled.
  • History, either moved or kept in the old system for reference, which matters because auditors can ask about prior years.
  • Reports and integrations, such as payroll, bank feeds and payment apps, set up again.
  • People, since your bookkeeper and your outside CPA have to learn the new system.

Each of those steps takes time and can introduce errors, and none of them is an SF-1408 criterion.

Where each requirement lives if you stay on QuickBooks Online

What the SF-1408 asksWhere it can live without migrating
Direct costs kept apart from indirect costsQuickBooks Online chart of accounts, with accounts grouped by cost pool (fringe, overhead, G&A)
Costs accumulated by contractQuickBooks Online Projects or Classes, one per contract
Exclusion of unallowable costsSeparate QuickBooks Online accounts for costs the government will not pay, such as entertainment
Costs posted at least monthlyA monthly close in QuickBooks Online
A timekeeping system that identifies labor by contractA timekeeping tool with daily entry, approvals and an audit trail, connected to QuickBooks Online
A labor distribution that reconciles to payrollA journal entry posted to QuickBooks Online each pay period, charging labor cost to each contract
Indirect costs allocated with a consistent methodIndirect rates calculated from the QuickBooks Online accounts in each pool

G&A (general and administrative) is the pool for costs of running the company as a whole. How to set the accounts up is covered in our GovCon chart of accounts for QuickBooks.

The first four rows are bookkeeping. The last three are where QuickBooks Online needs help:

"We can set up the correct chart of accounts in QuickBooks. So that's the fundamental part. And classes... which means to separate different projects. This is what QuickBooks can do. What QuickBooks cannot do is the labor distribution itself, the whole calculation, as well as the indirect rate calculation, and the profit and loss by contract."

Sarah Sun, CPA, Sr Manager at Wendroff & Associates, CPA

Three ways to fill the labor gap

  • QuickBooks Online plus spreadsheets. Time is collected in one tool, allocated to contracts in a spreadsheet based on each person's pay, and the resulting entries are typed into QuickBooks Online. It can work for a very small team, but every pay period depends on formulas that are hard to audit.
  • QuickBooks Online plus a timekeeping app. You get daily entry and approvals. Some apps send hours rather than labor cost, so the distribution of cost to contracts may still happen in a spreadsheet.
  • QuickBooks Online plus a compliance layer. Timekeeping, labor distribution and indirect rates in one tool that reads your QuickBooks Online data and posts the results back as journal entries.

The three approaches are compared in Labor Distribution: Spreadsheet vs. Add-On vs. ERP, and timekeeping tools are compared in Best DCAA Timekeeping Software for Small Government Contractors.

A setup sequence that keeps your data where it is

  1. Organize the chart of accounts by cost pool. Add or rename accounts inside QuickBooks Online. Your history stays where it is.
  2. Create one Project or one Class per contract. Pick one method for contracts and use it consistently.
  3. Connect the timekeeping tool to QuickBooks Online, so employees, contracts and accounts come from your books instead of being typed again.
  4. Start daily time entry with supervisor approval, for every employee, including owners.
  5. Post labor distribution each pay period, as a journal entry that charges each contract its labor cost.
  6. Calculate indirect rates monthly from the pool accounts, and compare them with the rates you bid.
  7. Run one full cycle and review it against the SF-1408 before anyone asks. How to Make QuickBooks Online DCAA-Compliant walks through each step.

When a migration does make sense

Staying on QuickBooks Online is not right for every company forever. A full GovCon ERP becomes worth its cost when the company is large and complex enough to need what it adds, such as many cost-type contracts with detailed reporting, or an in-house accounting team. Jordan Glaze puts the line later than most contractors expect:

"A lot of contractors believe they have to migrate when it's too early. They just need to know what tools they need to add on to QuickBooks... it's time for a company to transition out of QuickBooks when the company has over 10 million or 20 million of revenue. And that's usually about the time when the company would start investing in their own internal accounting team."

Jordan Glaze, Business Development Specialist/Accountant, Wendroff & Associates, CPA

If you are weighing the move, Is Unanet Overkill for a Small GovCon? compares what the SF-1408 tests with what an ERP adds.

How WiseCost fits

If you want to get ready for DCAA without migrating your accounting data, WiseCost is DCAA timekeeping and labor distribution software for small government contractors that keep their books in QuickBooks Online. QuickBooks Online remains your book of record, and WiseCost adds the labor side it lacks:

  • No data migration. Connecting takes about a minute. WiseCost reads your accounts, employees, vendors, classes, customers, projects, items and locations, and the import changes nothing in QuickBooks Online. Later changes in QuickBooks Online reach WiseCost on their own.
  • Daily timekeeping by contract. Employees record time every day against each contract or indirect account, supervisors approve timesheets, and every change keeps an audit trail.
  • Labor cost posted back to your ledger. Labor distribution posts each contract's labor cost to QuickBooks Online as a journal entry, with a reversal if you reopen a posted period.
  • Indirect rates from your books. The Indirect Rate report calculates your rates from the QuickBooks Online accounts you assign to each pool.

WiseCost writes to QuickBooks Online only when you act: the labor distribution journal entries you post, time activities if you send them, and classes, customers, items or accounts if you choose to manage them from WiseCost.

FAQ

No. DCAA does not approve or certify software. It evaluates whether your accounting system, including your procedures, meets the criteria of the SF-1408, such as separating direct and indirect costs, accumulating costs by contract, and supporting labor with timekeeping and a labor distribution.

Keep QuickBooks Online as your ledger and add what it lacks. Organize the chart of accounts by cost pool, use Projects or Classes for contracts, and add a tool that connects to QuickBooks Online for daily timekeeping, labor distribution posted as journal entries, and indirect rate calculation. Your history and balances stay where they are.

No. The SF-1408 criteria are about how your system records and accumulates costs, not about which software holds your history. If your history is in QuickBooks Online, it can stay there, organized by cost pool and by contract from the point you set that structure up.

When the company's size and complexity call for what a GovCon ERP adds, such as many cost-type contracts with detailed reporting or an in-house accounting team. Jordan Glaze of Wendroff & Associates, CPA places that point at over $10 million or $20 million in revenue, when a company usually starts building its own accounting team.

The Bottom Line

You can meet DCAA's accounting system criteria without migrating your books. Organize QuickBooks Online by cost pool and by contract, then add the labor side it lacks: daily timekeeping, labor distribution posted as journal entries, and indirect rates calculated from your accounts. Move to a full ERP when the size of the company calls for it, not because an audit is coming.


Want to keep QuickBooks Online and get DCAA-ready? Take the free DCAA Readiness Self-Assessment, or start a 14-day free trial of WiseCost on your own QuickBooks Online.

Official Sources