Monthly financial reports give government contractors the data to catch compliance problems before DCAA does. Amerifusion Bookkeeping manages month-end closes for small GovCon firms running QuickBooks, producing the reports and KPIs that keep indirect rates accurate, contracts profitable, and accounting systems audit-ready.
A 10-person cybersecurity contractor in Huntsville closed their books once a quarter. By September, actual overhead had drifted to 82% against a 65% provisional billing rate. They overbilled $47,000 across three cost-plus contracts without realizing it. The year-end settlement wiped out two months of operating cash. Monthly monitoring would have flagged the 17-point variance in April, when a rate adjustment under FAR 42.704(b) could have corrected the problem before it compounded.
CohnReznick and Deltek publish KPI frameworks for mid-to-large firms running Unanet or Costpoint. Nobody writes about monthly financial reports government contractors in the 5-to-20-person range actually need. The small firm running QuickBooks requires the same discipline with different tools. Eight reports, pulled monthly with supplemental calculations, provide the monitoring that keeps small GovCon bookkeeping operations profitable and compliant.
Why Monthly Financial Monitoring Is Non-Negotiable for Government Contractors
DCAA considers monthly book closing a best practice. The DCAA Pre-Award Accounting System Adequacy Checklist requires contractors to capture all expenses at least monthly. The DFARS Business Systems rules go further: segregate direct and indirect costs monthly for proper contract allocation.
Government contractor financial monitoring connects three things at once: profitability management, cash flow visibility, and compliance readiness. Skip a month, and costs accumulate without scrutiny. Skip a quarter, and the compounding errors become expensive to unwind.
A Warren Averett month-end close checklist identifies 14 steps for government contractors. That checklist targets mid-size firms. The version below distills it into eight reports a small firm’s bookkeeper reviews in a single monthly session.
8 Monthly Financial Reports Government Contractors Must Review
Small government contractors running QuickBooks need eight specific reports each month. Together, these monthly financial reports form a complete picture that satisfies DCAA expectations, surfaces contract-level problems, and keeps indirect rates on target.
1. Profit and Loss Statement (Overall)
Redstone Government Consulting identifies the P&L as the most critical QuickBooks report for government contractors because “your income and costs are the main focus for DCAA when performing an audit.” Run it monthly. Compare against the prior month, last year, and year-to-date budget.
Look for unexpected cost spikes. A $3,000 jump in “Other Direct Costs” might be legitimate. It might also be a misclassified indirect cost in a direct cost account. Monthly review catches misclassifications before they flow into contract billings.
2. Profit and Loss by Customer (Contract)
QuickBooks calls it “Profit and Loss by Customer.” Government contractors call it the contract profitability report. This report breaks revenue and costs by individual contract, showing whether each job is making or losing money.
The P&L by Customer reveals allocation errors the standard P&L hides. Every direct cost must trace to a contract. Every indirect cost must remain untagged. This report verifies the split.
3. Balance Sheet
Redstone’s analysis is direct: “If prepaid expenses, accrued expenses, and accrued wages are not correct on the Balance Sheet, then it would be impossible for the Profit and Loss Reports to be accurate.” The balance sheet validates the P&L.
Track the current ratio (current assets divided by current liabilities). CohnReznick recommends a target of 2.0, meaning you hold twice the assets needed to cover short-term obligations. A ratio below 1.5 signals potential cash pressure. Below 1.0 means you owe more than you hold in liquid assets.
4. Cash Flow Statement
Government contracts pay slowly. A cost-plus contract routinely runs 75 to 90 days from cost incurrence to cash receipt: 30 days of cost accumulation, 10 days for month-end close and invoice preparation, and 30 days of government processing [Prompt Payment Act].
The cash flow statement shows whether operating activities generate enough cash to fund operations between invoice payments. Negative operating cash flow for two consecutive months is a warning. Three months requires immediate action.
5. Accounts Receivable Aging Report
The A/R aging report sorts outstanding invoices into buckets: current, 30, 60, 90+ days. For government contractors, days sales outstanding (DSO) is the KPI to watch. Target under 60 days for firm-fixed-price contracts, under 90 for cost-plus.
An invoice at 90+ days signals a rejected voucher, missing documentation, or contracting officer dispute. Do not let invoices age past 60 days without investigation.
6. Indirect Rate Variance Analysis
This report does not exist in QuickBooks. You build it. Run a P&L filtered by indirect cost classes (fringe, overhead, G&A) to capture actual pool costs year-to-date. Divide each pool by its allocation base. Compare against provisional billing rates.
| Rate Pool | Provisional Rate | Actual YTD Rate | Variance | Action Required |
|---|---|---|---|---|
| Fringe | 36.0% | 34.2% | -1.8 pts | Monitor. Within tolerance. |
| Overhead | 65.0% | 78.3% | +13.3 pts | Request rate adjustment under FAR 42.704(b). |
| G&A | 18.0% | 19.6% | +1.6 pts | Monitor. Flag if trend continues. |
The 10% threshold matters. FAR 42.704(b) allows either party to revise billing rates “to prevent substantial overpayment or underpayment.” A 13.3-point overhead variance left uncorrected for 12 months on a $1.5M cost-plus contract creates an overbilling liability exceeding $90,000 at year-end settlement.
7. Timesheet and Labor Distribution Report
The monthly labor distribution report verifies every hour charged to the correct contract or indirect account. QuickBooks “Time Activities by Employee Detail” provides this data.
Look for employees charging 100% direct with zero indirect time. No employee works 40 billable hours every week. Missing indirect labor (training, admin, PTO) inflates direct costs and understates indirect pools. Both distortions create audit findings.
8. Budget vs. Actual by Contract
Run the “Budget vs. Actual” report in QuickBooks filtered by each contract. The Deltek KPI framework calls this the foundation of project financial management. Compare actual costs against the contract budget, funded amount, and total ceiling.
On cost-plus contracts, spending near the funded ceiling triggers mandatory notification under the Limitation of Funds clause [FAR 52.232-22]. On firm-fixed-price contracts, costs exceeding the price mean the contractor absorbs the loss. Monthly tracking catches overruns at 10%, not at 100%.
GovCon Monthly KPIs: What the Numbers Should Look Like
Monthly financial reports for government contractors produce data. KPIs tell you whether the data signals health or trouble. CohnReznick identifies five financial KPIs every GovCon firm should track. Deltek adds DSO monitoring. The following table consolidates these KPIs into one monthly scorecard for small firms.
| KPI | Source Report | Healthy Target | Warning Threshold |
|---|---|---|---|
| Indirect Rate Variance | Rate Variance Analysis | Within 5% of provisional | Exceeds 10% of provisional |
| Current Ratio | Balance Sheet | 2.0 or higher | Below 1.5 |
| DSO (FFP contracts) | A/R Aging | Under 45 days | Over 60 days |
| DSO (Cost-Plus contracts) | A/R Aging | Under 75 days | Over 90 days |
| Gross Margin by Contract | P&L by Customer | Consistent month-over-month | Swing of 5+ points in a month |
| Budget Consumed (% of ceiling) | Budget vs. Actual | On pace with period of performance | Costs 15%+ ahead of schedule |
| Unallowable Cost Ratio | P&L (unallowable class) | Tracked, documented, excluded | Unallowable costs in direct pools |
CohnReznick stresses that gross margin should be consistent month over month. A sudden margin drop on one contract means costs spiked, revenue recognition changed, or costs are misallocated. The consistency of the number matters more than the number itself.
Build this scorecard in a spreadsheet. One page. Seven KPIs. Red, yellow, green. A 15-person firm does not need a $50,000 analytics platform. It needs discipline, the right reports, and someone who reads them every month.
5 Warning Signs Hidden in Your Monthly Reports
Warning signs hide in line items, ratios, and trends. These five patterns indicate trouble that worsens if left unaddressed.
1. Indirect Rates Climbing While Revenue Stays Flat
Indirect costs are semi-fixed. When a contract ends, the same overhead spreads across a smaller direct labor base. A firm billing $800,000 in direct labor with $520,000 in overhead runs a 65% rate. Lose one contract, drop to $600,000 in direct labor, and the same overhead produces an 87% rate. That 22-point swing affects every active and future proposal.
2. A/R Over 90 Days Without a Documented Dispute
Government invoices aging past 90 days indicate a procedural failure, not a payment failure. The federal government pays its bills. It rejects invoices with documentation errors, rate discrepancies, or missing certifications. An invoice stuck at 90 days likely has a rejection notice in an unmonitored WAWF queue.
3. One Contract Absorbing All Indirect-Type Costs
Check the P&L by Customer for indirect cost leakage. If Contract A shows $40,000 in “supplies” while Contracts B and C show zero, those supplies might be shared resources incorrectly coded as direct costs. DCAA auditors compare cost distribution across contracts. Lopsided patterns trigger questioned costs.
4. Payroll Accruals Missing From the Balance Sheet
If the last pay period ends on the 22nd but the month closes on the 30th, eight days of labor costs are incurred but not reflected in the P&L unless accrued. Missing payroll accruals understate labor costs and distort indirect rates. The fix takes 10 minutes. The problem it prevents takes weeks to untangle.
5. Budget Consumed Ahead of Performance Period
A 12-month contract at month six should have consumed roughly 50% of the budget. If 70% is burned by month six on a cost-plus contract, the contractor must notify the contracting officer or risk working beyond the funded ceiling. The Limitation of Funds clause [FAR 52.232-22] requires written notice when costs reach 75% of the funded amount.
The Small GovCon Month-End Close: A 14-Step Process
Warren Averett published a 14-step month-end close checklist for government contractors. For a small firm, the process takes 4 to 8 hours. Skipping steps creates cumulative errors that surface during incurred cost submissions or DCAA floor checks.
- Reconcile bank and credit card statements. Verify every transaction posted to the general ledger.
- Process and approve all timesheets. Verify signatures, supervisor approvals, and correct job assignments [DCAA timekeeping requirements].
- Process and approve expense reports. Match receipts. Verify direct/indirect coding and contract assignment.
- Post adjusting journal entries. Record prepaid amortization, accrued revenue, accrued payroll, and depreciation.
- Reconcile accounts receivable. Match the A/R subledger to the balance sheet. Follow up on invoices past 60 days.
- Reconcile accounts payable. Verify the A/P subledger matches the balance sheet.
- Review work-in-progress. Reconcile WIP balances and subcontractor costs to project records.
- Update the fixed asset register. Record acquisitions, disposals, and monthly depreciation.
- Reconcile payroll and benefits. Verify payroll totals match the general ledger. Accrue wages for partial pay periods.
- Reconcile the general ledger. Every balance sheet account must be supported by a schedule.
- Calculate actual indirect rates. Divide year-to-date pool costs by allocation bases. Compare against provisional rates.
- Review contract-level profitability. Analyze margin by contract. Flag variances against estimates.
- Prepare financial statements. Generate the P&L, balance sheet, cash flow, and comparatives.
- Lock the period. Close the month in QuickBooks. Archive the report package.
Step 14 is the one small firms skip most often. Locking the period in QuickBooks prevents backdated entries from changing closed financials. An unlocked system means a correction posted in October alters June’s statements without a trail. DCAA expects period integrity.
Where QuickBooks Falls Short (and What to Do About It)
QuickBooks is a DCAA-adequate accounting system for small contractors when configured correctly. But the monthly financial reports government contractors need go beyond its standard output. Three gaps require workarounds.
Indirect rate calculations. QuickBooks does not calculate rates automatically. Build a monthly spreadsheet pulling pool costs from the P&L by class, dividing by the allocation base, and comparing against your provisional billing rates. This 30-minute exercise is the single most valuable monitoring step for any small GovCon firm.
Contract funding tracking. QuickBooks does not track funded versus unfunded contract ceilings. Maintain a contract funding log showing contract value, funded amount, costs to date, and remaining funding.
Fully burdened job cost reports. QuickBooks shows direct costs by job but not the fully burdened cost (direct plus allocated indirect) the government pays on cost-reimbursable contracts. Without a burdened cost report, you understate true cost by 40% to 60%.
Frequently Asked Questions
What monthly financial reports should government contractors review?
Government contractors should review eight core reports monthly: Profit and Loss (overall and by contract), Balance Sheet, Cash Flow Statement, Accounts Receivable Aging, Indirect Rate Variance Analysis, Contract Profitability by Job, Timesheet Labor Distribution, and Budget vs. Actual by Contract. These reports satisfy DCAA month-end close expectations and provide the KPIs needed to manage profitability, cash flow, and compliance across all active contracts.
How do I monitor indirect rate variance in QuickBooks?
Run a Profit and Loss report filtered by indirect cost classes (fringe, overhead, G&A) to capture actual pool costs year-to-date. Divide each pool by its allocation base to calculate actual rates. Compare actual rates against provisional billing rates monthly. If variance exceeds 10%, request a mid-year rate adjustment from the contracting officer under FAR 42.704(b) to prevent substantial overpayment or underpayment at year-end settlement.
What financial KPIs matter most for small government contractors?
The five most critical KPIs for small GovCon firms are indirect rate variance (actual vs. provisional), days sales outstanding (target under 60 days for FFP, under 90 for cost-plus), contract-level gross margin, current ratio (target 2.0 or higher), and budget-to-actual variance by contract. CohnReznick identifies gross margin consistency and current ratio as foundational metrics for monthly review.
Does DCAA require monthly financial reporting?
DCAA considers monthly book closing a best practice and expects contractors to capture all expenses at least monthly per the Pre-Award Accounting System Adequacy Checklist. The DFARS Business Systems rules require accounting systems to segregate direct and indirect costs monthly for proper allocation. An inadequate month-end close process raises red flags during floor checks and accounting system audits.
Can QuickBooks produce the reports a government contractor needs?
QuickBooks produces the core reports (P&L, P&L by Customer, Balance Sheet, A/R Aging, Cash Flow) when configured with proper class tracking and job costing. Redstone Government Consulting identifies three essential QuickBooks reports for government contractors. Indirect rate calculations, contract funding tracking, and fully burdened job cost reports require supplemental spreadsheets or add-ons beyond standard QuickBooks functionality.
Key Takeaways
- Pull eight reports every month. P&L (overall and by contract), balance sheet, cash flow, A/R aging, indirect rate variance, labor distribution, and budget vs. actual. Together they provide the same visibility Deltek gives larger contractors.
- Monitor indirect rate variance against a 10% threshold. FAR 42.704(b) allows mid-year adjustments. A 10-point overhead variance on a $1.5M cost-plus contract creates a $90,000+ settlement liability.
- Lock every closed month in QuickBooks. Period integrity is a DCAA expectation. Unlocked systems allow backdated entries that alter closed statements.
- Build three supplemental tools. Indirect rate spreadsheet, contract funding log, and fully burdened job cost report fill the gap between QuickBooks and GovCon compliance requirements.
- Treat gross margin consistency as a leading indicator. Month-over-month margin swings are the earliest signal of cost misallocation or billing errors on government contracts.
Build Your Monthly Monitoring Discipline
The 5-to-20-person GovCon firm does not fail DCAA audits because its accounting system is inadequate. It fails because nobody reviewed the monthly financial reports government contractors must produce. Financial monitoring is the cheapest compliance investment a government contractor makes: 4 to 8 hours per month, the right eight reports, and someone qualified to read them.
Start with the Compliance Readiness Check to identify gaps in your current monitoring process. Use the Amerifusion indirect rate calculator to model your fringe, overhead, and G&A rates against actuals.
Amerifusion is a CPA-managed bookkeeping firm built for government contractors. We handle month-end closes, indirect rate monitoring, and the financial reporting that keeps small GovCon firms audit-ready year-round. Book a discovery call to get your monthly monitoring in place before the next close.
