Skip to content

Monthly Financial Reports Government Contractors Need

Monthly financial reports give government contractors the data to catch compliance problems before DCAA does. Eight reports, pulled every month, keep indirect rates accurate, contracts profitable and the accounting system audit-ready.

Close the books quarterly and the drift is invisible until it is expensive. Overhead runs above the provisional rate for months, every cost-plus voucher goes out at the lower rate, and the gap surfaces at year-end settlement as money owed back. The same drift shows up in a monthly variance report in period three, while a rate revision under FAR 42.704(c) (Overhaul 42.504(c)) still fixes it.

The indirect rate variance problem is rarely discovered during the DCAA audit. It surfaces at year-end, when the actual rates are computed for the ICS and the gap against provisional billing rates is large enough to create a six-figure settlement. That gap was visible at month three, if anyone was running the variance analysis.

CohnReznick and Deltek publish KPI frameworks aimed at firms running Unanet or Costpoint. The guidance on monthly financial reports government contractors need is written for that tier, and the 5-to-20-person firm on QuickBooks has to translate it. Same discipline, different tools. Eight reports, pulled monthly with supplemental calculations, provide the monitoring that keeps small GovCon bookkeeping operations profitable and compliant.

Why Is Monthly Financial Monitoring Required for Government Contractors?

Monthly is not a best practice someone invented. It is written into the accounting system clause. DFARS 252.242-7006(c)(11) requires “Interim (at least monthly) determination of costs charged to a contract through routine posting of books of account”. The same clause requires proper segregation of direct from indirect costs at (c)(2), accumulation of direct costs by contract at (c)(3), and reconciliation of subsidiary ledgers to the general ledger at (c)(6).

Those four criteria together move the monthly close out of bookkeeping preference. A contractor determining contract costs quarterly is not meeting (c)(11), and (c)(11) is one of the criteria an accounting system is judged against.

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.

What Monthly Financial Reports Do Government Contractors Need to 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 describes 2.0 as “a healthy ratio”, meaning current assets cover current liabilities twice over. Below 1.0 you owe more than you hold in liquid assets, which is arithmetic rather than opinion. The 1.5 warning line below is our own trigger, not theirs.

4. Cash Flow Statement

Government contracts pay slowly, and the arithmetic is worth doing rather than estimating. Roughly 30 days of cost accumulation, 10 days for month-end close and invoice preparation, then a payment clock that runs to the later of 30 days after the billing office receives a proper invoice and 30 days after the government accepts [FAR 32.904(b)(1)]. That is about 70 days when nothing goes wrong, and longer whenever acceptance lags or a voucher comes back.

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. We use under 45 days for firm-fixed-price and under 75 for cost-plus as working targets. They are practice thresholds, not regulatory ones.

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(c).
G&A 18.0% 19.6% +1.6 pts Monitor. Flag if trend continues.

FAR 42.704(c) (Overhaul 42.504(c)) lets billing rates be revised prospectively or retroactively by mutual agreement, at either party’s request, “to prevent substantial overpayment or underpayment”. If agreement cannot be reached, the contracting officer determines them unilaterally.

Size the exposure against the allocation base, not the contract value. An overhead rate applies to direct labor. A 13.3-point variance carried for a full year on $675,000 of direct labor is roughly $90,000 of overbilling to hand back at settlement. On $1.5M of direct labor the same variance is closer to $200,000.

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-reimbursement contracts, spending near the funded ceiling triggers written notice under the Limitation of Funds clause [FAR 52.232-22] when the costs you expect to incur in the next 60 days, added to all costs previously incurred, will exceed 75% of the amount so far allotted. Check your own clause before relying on those figures: the prescription at FAR 32.706-2(b) lets the contracting officer set the period anywhere from 30 to 90 days and the threshold anywhere from 75 to 85 percent. 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 walks through gross margin, current ratio, actuals to budget, ledger reconciliation and profit review, describing them as a few of the “financial, system, and contract KPIs” worth watching monthly. Deltek adds DSO. The table below consolidates those into one scorecard for small firms, with the targets marked where they are ours rather than theirs.

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 an enterprise 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 on the trigger described above, with the period and the percentage set by your contract rather than fixed at 60 days and 75%.

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.

  1. Reconcile bank and credit card statements. Verify every transaction posted to the general ledger.
  2. Process and approve all timesheets. Verify signatures, supervisor approvals, and correct job assignments. DFARS 252.242-7006(c)(9) and (c)(10) require a timekeeping system that identifies labor by cost objective and a labor distribution system that charges direct and indirect labor to the right objectives.
  3. Process and approve expense reports. Match receipts. Verify direct/indirect coding and contract assignment.
  4. Post adjusting journal entries. Record prepaid amortization, accrued revenue, accrued payroll, and depreciation.
  5. Reconcile accounts receivable. Match the A/R subledger to the balance sheet. Follow up on invoices past 60 days.
  6. Reconcile accounts payable. Verify the A/P subledger matches the balance sheet.
  7. Review work-in-progress. Reconcile WIP balances and subcontractor costs to project records.
  8. Update the fixed asset register. Record acquisitions, disposals, and monthly depreciation.
  9. Reconcile payroll and benefits. Verify payroll totals match the general ledger. Accrue wages for partial pay periods.
  10. Reconcile the general ledger. Every balance sheet account must be supported by a schedule.
  11. Calculate actual indirect rates. Divide year-to-date pool costs by allocation bases. Compare against provisional rates.
  12. Review contract-level profitability. Analyze margin by contract. Flag variances against estimates.
  13. Prepare financial statements. Generate the P&L, balance sheet, cash flow, and comparatives.
  14. 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 supports a DCAA-adequate accounting system for small contractors when configured with proper class tracking, job costing, and cost pool structure. 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 the true cost of the work by whatever your combined indirect load happens to be, which on a three-pool structure is routinely more than half again the direct cost.

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. When the variance is material, request a mid-year revision from the contracting officer under FAR 42.704(c) (Overhaul 42.504(c)). Revision is by mutual agreement at either party’s request, and the contracting officer sets the rates unilaterally if no agreement is reached.

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 45 days for FFP, under 75 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?

The DCAA Pre-Award Accounting System Adequacy Checklist requires contractors to capture all expenses at least monthly. DFARS 252.242-7006 requires accounting systems to segregate direct and indirect costs accurately. Monthly monitoring is the standard interval in practice to maintain that segregation without errors compounding across quarters. 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 monthly. FAR 42.704(c) allows mid-year revision by mutual agreement. Size the exposure against the allocation base: a 13-point overhead variance carried for a year on $675,000 of direct labor is about $90,000 to repay at settlement.
  • 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.

Next in your learning path · Foundation Direct vs Indirect Costs: The Classification Guide Every Government Contractor Needs
Joseph Kamara, CPA

Joseph Kamara CPA

Founder, Amerifusion Bookkeeping

Former KPMG financial auditor. Former Senior Manager for IS Assurance and Third-Party Risk Management at BDO Dallas (SOC 1/2, HITRUST, HIPAA). Former Senior Technology Risk Manager at Stryker. Specializing in DCAA-compliant accounting systems for government contractors.

Need help with DCAA compliance?

Book a free DCAA Readiness Call to see how Amerifusion can protect your next audit.

Book Your DCAA Readiness Call
Certified Intuit ProAdvisor, Gold tier DCAA Compliant CPA Oversight