.png)
How to setup the GovBooks Chart of Accounts in QuickBooks Online
Meets the following DCAA requirements: (see all requirements here)
​
-
Requirement 1: Is the accounting system in accord with generally accepted accounting principles applicable in the circumstances?
-
Requirement 2a: Proper segregation of direct costs from indirect costs
-
Requirement 2d: Accumulation of costs under general ledger control
-
Requirement 2h: Exclusion from costs not allowable under FAR 31
​
The chart of accounts is the foundation on which you will build your DCAA compliant accounting system. Like building a house on a weak foundation, your accounting system will not stand up to a DCAA audit without a strong chart of accounts. The chart of accounts is simply a list of general ledger accounts, grouped by their function within the accounting system. Each general ledger account will hold individual transactions based on the type of account.
​
The GovBooks Chart of Accounts is imported into QuickBooks Online (preferred method) or can be manually entered into the chart of accounts screen in QuickBooks Online. From there, it is automatically synced with your GovBooks application.
​​
GovBooks Chart of Accounts in QuickBooks Online
I developed a standard chart of accounts that will pass DCAA audits and is designed for use with QuickBooks Online. Download a free excel-version of the GovBooks Chart of Accounts that you can upload into QuickBooks Online.
Excel-version of GovBooks Chart of Accounts
You can import this excel file into your QuickBooks Online system. Download this version of the GovBooks Chart of Accounts.
The chart of accounts is a listing of general ledger accounts organized by account type. In a typical chart of accounts, you will find a balance sheet section with assets and liabilities, an equity section, and an expense section. The chart of accounts utilized in government contracting has some similarities to the typical chart of accounts utilized by commercial enterprises, and the balance sheet and equity sections are nearly the same, but the similarity ends there.
​
The expense section is very different in government contracting when compared to the expense section of a commercial enterprise. In the expense section of a government contractor’s chart of accounts, you will find that the expense accounts are further divided into standard subsets such as direct costs, fringe benefits, overhead, facilities, general and administrative (G&A), and unallowable expenses. These subsets are utilized to represent cost of sales, intermediate and final indirect expense pools, allocation bases, and expenses segregated from the government contracting business. These subsets are standard to the industry of government contracting and are universally recognized by industry accountants and DCAA auditors alike.
​
Variations and customizations are permitted, as long as the chart of accounts meets DCAA requirements by fairly allocating indirect expenses to cost objectives such as a contract. You may download an excel template of the GovBooks Chart of Accounts and modify it as needed.
How to import the Govcon Chart of Account
​
After you download the GovBooks Chart of Accounts, you can manually enter the new chart of accounts, or to save time, you can import the excel-version into QuickBooks Online by following these steps:
​
Step 1:
​
Download the free GovBooks Chart of Accounts below.
Step 2:
​
In QuickBooks Online, navigate to "Chart of Accounts" and click on the down-arrow on the "New" button and select "Import".
Step 3:
Click on the "Browse" button and select the GovBooks Chart of Accounts that you have downloaded. Then click "Next".
​Step 4:
​
Map the fields from the file to be imported to the QuickBooks Online fields. Then, click on "Next".
Step 5:
​
Review the accounts to be imported. You may unselect any that you don't want imported, change the "Type" or "Detail Type". The click on "Import". Your new GovBooks Chart of Accounts will be uploaded. You may then want to inactivate older accounts.
