Federal grant management is easier when the financial records are reviewed every month.

 

For many awardees, reconciliation becomes stressful because it is treated as a reporting deadline task. The team waits until the SF-425 is due, a drawdown needs support, a closeout deadline arrives, or an agency asks a question.

 

By then, the records may be difficult to clean up.

 

Payroll may not tie to timekeeping. Drawdowns may not match ledger activity. Vendor invoices may be missing. Indirect costs may not be updated. Budget categories may drift. Support files may be scattered across emails, spreadsheets, accounting software, and payment systems.

 

Monthly grant reconciliation helps prevent that.

 

At Peter Witts CPA PC, we help federally funded organizations, SBIR/STTR awardees, and grant recipients build monthly reconciliation processes that connect ledger activity, payroll, timekeeping, drawdowns, budget categories, indirect costs, and documentation.

 

Why Monthly Grant Reconciliations Matter

 

A federal grant reconciliation compares the financial activity in your accounting records to the approved award budget, drawdown activity, supporting documents, and reporting requirements.

 

The goal is to make sure the award records are accurate, complete, and ready for management review.

 

Monthly reconciliations help awardees:

• Confirm costs are recorded to the correct grant
• Compare actual spending against the approved budget
• Reconcile payroll to timekeeping
• Review drawdowns against expenditures
• Track indirect costs
• Identify missing invoices or support
• Monitor remaining funds
• Prepare for SF-425 reporting
• Reduce closeout stress
• Strengthen audit readiness

The monthly process does not need to be overly complicated. It needs to be consistent.

 

Start With the Approved Award Budget

 

Every reconciliation should start with the approved award budget.

 

The approved budget is the baseline for tracking grant activity. It shows the categories, amounts, restrictions, and assumptions the awardee should use to monitor spending.

 

Before reviewing monthly activity, confirm:

• Total approved award amount
• Budget period or project period
• Approved budget categories
• Direct labor budget
• Fringe or benefit assumptions
• Consultant and subcontractor budgets
• Materials and supplies
• Equipment
• Travel
• Other direct costs
• Indirect cost treatment
• Cost share or matching requirements, if applicable
• Restrictions or prior approval requirements

Do not rely only on the original proposal budget. The approved award may differ from what was submitted.

 

Reconcile Ledger Activity by Award

 

The general ledger should show costs by award, project, grant, or cost center.

 

Each month, review ledger activity for the grant and confirm that costs were posted correctly.

 

Review:

• Revenue or grant income entries
• Direct labor
• Fringe benefits
• Materials and supplies
• Consultants
• Subcontractors or subawards
• Travel
• Equipment
• Other direct costs
• Indirect costs
• Unallowable costs
• Adjusting entries
• Reclassifications
• Drawdown or payment entries

Look for costs charged to the wrong project, duplicate entries, missing costs, unusual transactions, or entries outside the period of performance.

 

A clean ledger is the foundation for accurate reporting.

 

Reconcile Payroll to Timekeeping

 

Payroll is often one of the largest grant cost categories, so it should be reconciled every month.

 

Payroll records show what employees were paid. Timekeeping records show which grant, project, or activity benefited from the labor.

 

Monthly payroll reconciliation should confirm:

• All timesheets were submitted
• Timesheets were approved
• Project codes were used correctly
• Direct and indirect labor were separated
• Founder or executive time was documented
• Payroll registers match labor distribution reports
• Labor distribution matches general ledger entries
• Fringe or benefit costs were calculated correctly
• Non-award activity was excluded from direct grant labor
• Corrections or adjustments were documented
• If payroll does not tie to timekeeping, the grant’s labor records may not be ready for drawdowns, reporting, or review.

 

Review Labor Distribution

 

Labor distribution is where payroll becomes grant accounting.

 

A labor distribution report should show how payroll costs were allocated across awards, projects, direct labor accounts, indirect labor accounts, and non-award activity.

 

Each month, review:

• Employee names
• Pay periods
• Hours by project
• Direct labor charges
• Indirect labor charges
• Non-award labor
• Fringe allocation
• Payroll cost allocation
• General ledger tie-out
• Corrections or transfers

Labor distribution helps support budget-to-actual reporting, indirect rates, drawdowns, invoices, and closeout.

 

Reconcile Drawdowns to Actual Costs

 

Grant drawdowns should be reconciled to actual costs and immediate cash needs.

 

Depending on the agency and award terms, funds may be requested through the Payment Management System or another payment process. Awardees should understand whether draws are based on advance needs, reimbursements, or other agency-specific requirements.

 

Monthly drawdown reconciliation should compare:

• Cash requested
• Cash received
• Cash disbursed
• Actual grant expenditures
• General ledger costs
• Payroll and vendor payments
• Indirect costs
• Refunds or adjustments
• Remaining authorized funds
• Remaining cash on hand

The company should be able to trace drawdowns to accounting records and supporting documentation.

 

Reconcile PMS Activity to Accounting Records

 

For awards paid through PMS, payment activity should be reconciled to the accounting records.

 

PMS notes that the cash transaction section of the Federal Financial Report uses drawdowns, refunds, and journal vouchers from PMS, and that cash receipts, cash disbursements, and federal share of expenditures should reconcile before FFR submission.

 

Monthly PMS reconciliation may include:

• PMS drawdown history
• Refunds
• Journal vouchers
• Bank deposits
• General ledger revenue entries
• Cash disbursements
• Grant expenditures
• Federal share of expenditures
• Remaining authorization
• Notes on timing differences

This review helps prevent problems when the awardee prepares the FFR or closeout reports.

 

Review Budget-to-Actual Activity

 

Budget-to-actual reporting is one of the most important monthly grant management tools.

 

A budget-to-actual report should compare the approved budget to actual costs incurred.

 

Each month, review:

• Approved budget by category
• Actual costs incurred
• Remaining budget
• Percentage spent
• Variance amount
• Variance explanation
• Burn rate
• Remaining months in the project
• Remaining work
• Spending trends
• Categories approaching budget limits

This helps leadership see whether spending is aligned with the grant plan.

 

If labor is running ahead of schedule, vendor costs are higher than expected, or indirect costs are drifting, the issue should be visible before reporting or closeout.

 

Review Budget Category Coding

 

Costs should be coded to the correct budget category.

 

This matters because federal reporting, internal management, and closeout may depend on accurate category-level records.

 

Each month, review whether costs were recorded correctly in categories such as:

• Personnel
• Fringe benefits
• Travel
• Equipment
• Supplies
• Contractual or subaward costs
• Construction, if applicable
• Other direct costs
• Indirect costs

If a transaction is coded incorrectly, correct it promptly and document the adjustment.

 

Do not wait until final reporting to clean up categories.

 

Review Indirect Costs

 

Indirect costs should be reviewed monthly, not only at year-end.

 

If the award includes indirect costs, the company should confirm that the amount charged, drawn, or reported is supported by the current rate structure and accounting records.

 

Review:

• Approved indirect rate
• Current indirect rate calculation
• Cost pools
• Allocation bases
• Direct labor or direct cost base
• Fringe treatment
• Overhead or G&A treatment
• Unallowable cost exclusions
• Actual versus proposed rate
• Indirect costs charged to the award
• Indirect costs included in drawdowns
• Supporting schedules

Indirect cost errors can affect reimbursement, reporting, cash flow, and future proposals.

 

Review Consultant and Subcontractor Costs

 

Consultants, subcontractors, vendors, and research partners should be reviewed every month.

 

For each invoice, confirm:

• The invoice matches the agreement
• The period falls within the award period
• The work relates to the approved scope
• Deliverables or services were received
• Costs are within the approved budget
• F&A or indirect costs are calculated correctly, if applicable
• Internal approval was documented
• Payment was recorded
• Remaining partner budget is updated
• Supporting documents are saved

Subaward and partner costs should not be treated like ordinary vendor bills. They should be tied to scope, budget, documentation, and performance.

 

Review Vendor Invoices and Receipts

 

Vendor costs should be supported by source documentation.

 

Each month, review:

• Vendor invoices
• Receipts
• Purchase approvals
• Credit card charges
• Bank payments
• Shipping records, when relevant
• Equipment records, if applicable
• Project purpose notes
• General ledger coding
• Payment status

A receipt alone may not explain why the cost belongs to the award. Add notes when needed so the cost can be understood later.

 

Review Cost Share or Matching Funds, If Applicable

 

If the award includes cost share or matching funds, the reconciliation should include non-federal contributions.

 

Cost share should be tracked with the same discipline as federal funds.

 

Each month, review:

• Required cost share amount
• Source of match
• Costs incurred toward match
• Payroll or invoice support
• Partner contributions
• General ledger coding
• Remaining cost share balance
• Documentation
• Reporting requirements
• Closeout impact

Cost share should be verifiable from the records and should not be reconstructed at the end of the award.

 

Identify Unallowable or Non-Award Costs

 

Monthly reconciliation should also identify costs that should not be charged to the grant.

 

These may include:

• Fundraising costs
• Investor activity
• Sales and marketing activity
• Non-award commercialization activity
• Entertainment
• Costs outside the period of performance
• Costs unrelated to the approved scope
• Unsupported expenses
• Costs requiring prior approval that was not obtained

Unallowable or non-award costs should be coded separately and excluded from drawdowns, invoices, reimbursement requests, and indirect cost calculations when required.

 

Review Prior Approvals and Budget Changes

 

If the grant activity changed during the month, review whether prior approval was required.

 

This may include changes related to:

• Scope of work
• Key personnel
• Subawards
• Equipment
• Foreign components
• Budget category changes
• Cost share
• No-cost extensions
• Carryover
• Significant rebudgeting
• Other agency-specific terms

Any approvals should be saved in the grant file and reflected in the budget-to-actual report.

 

Update Support Files

 

A monthly reconciliation should include documentation cleanup.

 

Support files should be updated as the award is managed, not only when the FFR or closeout deadline approaches.

 

Monthly support files may include:

• General ledger detail
• Payroll registers
• Timesheets
• Labor distribution reports
• Vendor invoices
• Consultant invoices
• Subaward invoices
• Payment confirmations
• Drawdown records
• PMS reports
• Indirect rate schedules
• Budget-to-actual reports
• Cost share records
• Prior approvals
• Agency correspondence
• Reconciliation notes

Organized support files make reporting and closeout much easier.

 

Document Reconciliation Notes

 

Each monthly reconciliation should leave a clear trail.

 

The company should document:

• What was reviewed
• Who reviewed it
• Date of review
• Issues found
• Corrections made
• Open questions
• Pending invoices
• Timing differences
• Prior approval questions
• Follow-up items
• Management review

These notes help explain the award’s financial history if questions arise later.

 

Prepare for SF-425 Reporting

 

Monthly reconciliation helps prepare for SF-425 reporting.

 

The SF-425 Federal Financial Report relies on expenditure and cash activity that should tie to accounting records. NIH states that recipients are responsible for reconciling reports before submission to PMS and the awarding institute or center.

 

Monthly reviews reduce the chance of final-report discrepancies because the records are reconciled throughout the award period.

 

Before reporting, confirm:

• Expenditures tie to the ledger
• Drawdowns tie to PMS
• Cash receipts and disbursements reconcile
• Federal share of expenditures is supported
• Unliquidated obligations are reviewed
• Unobligated balances are understood
• Cost share is supported, if applicable
• Indirect costs are calculated correctly
• Supporting schedules are saved

The best time to prepare for the FFR is every month.

 

Monthly Grant Reconciliation Checklist

 

A practical monthly reconciliation checklist includes:

• Review award budget and terms
• Reconcile general ledger activity by award
• Review payroll records
• Reconcile timesheets to payroll
• Review labor distribution
• Reconcile drawdowns to actual costs
• Reconcile PMS activity to accounting records
• Review budget-to-actual report
• Confirm budget category coding
• Review indirect cost calculations
• Review consultant and subcontractor costs
• Review vendor invoices and receipts
• Track cost share or matching funds, if applicable
• Identify unallowable or non-award costs
• Review prior approvals or budget changes
• Update support files
• Document reconciliation notes
• Prepare for upcoming financial reports
• Review open action items with leadership

This checklist should be customized to the award type, agency, and organization.

 

Common Monthly Reconciliation Mistakes

 

Awardees often run into problems when reconciliation is delayed or incomplete.

 

Common mistakes include:

• Waiting until the FFR is due
• Not reconciling PMS draws to the ledger
• Drawing funds without supporting costs
• Not comparing actual spending to the approved budget
• Payroll not tied to timekeeping
• Labor distribution not reconciled
• Indirect costs not updated
• Subaward invoices not tied to deliverables
• Vendor receipts missing
• Cost share tracked outside the accounting system
• Prior approvals not saved
• Unallowable costs not separated
• Support files scattered across email and folders
• No monthly review notes
• These mistakes are easier to prevent with a consistent monthly process.

 

Questions to Ask Each Month

 

Each month, ask:

• Do ledger costs tie to the award?
• Are costs within the period of performance?
• Are payroll and timekeeping reconciled?
• Are drawdowns supported by actual costs or immediate cash needs?
• Does PMS activity match accounting records?
• Are costs coded to the correct budget categories?
• Are indirect costs calculated correctly?
• Are consultant and subcontractor costs supported?
• Are vendor invoices saved?
• Is cost share tracked, if applicable?
• Are unallowable costs excluded?
• Are prior approvals documented?
• Is the budget-to-actual report current?
• Are records ready for SF-425 reporting or closeout?
• These questions help turn reconciliation into a management routine.

 

Final Thoughts: Monthly Reconciliation Protects the Award

 

Federal grant reconciliation should not be a year-end or closeout project.

 

A monthly process helps awardees connect ledger activity, payroll, timekeeping, drawdowns, budget categories, indirect costs, and support files before problems build up.

 

At Peter Witts CPA PC, we help SBIR/STTR awardees, grant recipients, and federally funded organizations build monthly reconciliation processes that support drawdowns, SF-425 reporting, budget-to-actual visibility, audit readiness, and closeout.

 

Need Help Improving Monthly Grant Reconciliations?

 

If your organization manages federal grants, SBIR/STTR awards, or other federally funded projects, Peter Witts CPA PC can help review your monthly reconciliation process, ledger activity, payroll and timekeeping records, drawdown support, indirect cost schedules, budget-to-actual reports, and documentation files.

 

Backed by 35+ years of government contract accounting experience and first-hand DCAA knowledge, our team helps federally funded organizations maintain cleaner records, stronger reporting support, and better award visibility.

 

Schedule a strategic consultation with Peter Witts CPA PC to improve monthly grant reconciliations.