How to split payroll between your NIH grant and internal R&D in QuickBooks

If your payroll posts to one account with no funding-source split, your quarterly draw request is a guess. Here is how to allocate salary costs between a federal award and internal projects.

A biotech CFO we work with had a problem she noticed every quarter when she sat down to prepare the financial report for her NIH R01 research award. The quarterly draw amount on the report was based on percentages from the original grant budget. What was actually in QuickBooks was a single Salaries Expense account with $287,000 in it. The two numbers had no connection to each other.

The grant budget assumed the Principal Investigator (PI) would spend 20 percent of their time on the award, a research scientist would spend 60 percent, and a lab manager would spend 25 percent. Payroll had been running for eight months. None of it had ever been split by funding source. Draw requests were based on the original budget assumptions, not on what the books actually showed.

When we traced the actual time allocations against the books, the total grant-attributable payroll for the eight months was $11,400 less than what had been drawn. The correction required a reconciliation memo to the program officer and a credit against the next quarterly draw.

Why payroll rarely splits correctly at setup

Most QuickBooks setups for early-stage biotechs have one payroll structure: gross wages go to a single Salaries Expense account, payroll taxes go to a Payroll Tax Expense account, and health benefits go to a Benefits Expense account. When a federal award arrives, nothing in the default structure distinguishes a grant-funded salary dollar from an internally funded one.

No funding-source classes are configured. QuickBooks Classes and Projects are the mechanism for tagging a transaction to a specific funding source. Without a class assigned to each grant award and one for internal R&D, every payroll entry goes into an undifferentiated pool. The books cannot answer “how much of last quarter’s payroll belonged to NIH Award 5R01GM123456?” because the question was never asked at the time of entry.

Effort percentages come from the budget, not from actual time worked. The grant budget might say 20 percent PI effort, but what happened in the actual pay period? The PI may have spent two weeks at a conference and two weeks focused on the award. The overall quarter averaged near 20 percent, but the month-by-month allocation varied. A fixed budget assumption is not the same as documented actual effort.

Payroll taxes and benefits are never split alongside wages. A common error: the wage lines get class-tagged to the grant, but payroll taxes and health benefits remain in their general accounts. Under 2 CFR 200, the Uniform Guidance that governs federal research grants, costs that accompany a salary must be treated the same way as the salary itself. If 40 percent of an employee’s wages are charged to the grant, 40 percent of the associated payroll taxes and benefits should be charged to the grant as well.

Indirect cost calculation is deferred to year-end. Federal grants that include an indirect cost budget component require the rate to be applied consistently throughout the award. When indirect costs are reconciled only once a year, quarterly draw requests are missing that component, and the year-end catch-up entry creates a single large charge to the grant account that does not reflect actual monthly activity.

What one quarter looked like after allocation was set up

Once we established class tracking for the R01 and rebuilt the payroll allocations for the prior eight months, here is what one representative month looked like:

Employee	Monthly salary	Grant effort	Grant wages	Grant fringe
PI	$15,833	20%	$3,167	$728
Research Scientist	$9,167	60%	$5,500	$1,265
Lab Manager	$6,667	25%	$1,667	$383
Monthly grant payroll			$10,334	$2,376

Total monthly grant payroll including fringe benefits: $12,710. Indirect costs at 10 percent of direct payroll: $1,033. Total monthly charge to the NIH award: $13,743.

The original draw request had been using $15,000 per month based on budget assumptions. The documented actual amount was $13,743. Over eight months, that gap produced the $10,056 overage that required correction.

Why the discrepancy matters even when the amount is small

A $10,000 overage on a $600,000 R01 is roughly 1.7 percent of the award. Program officers rarely flag amounts that small, and NIH does not automatically demand repayment for minor quarterly variances. The issue is the documentation.

Under 2 CFR 200 Section 430, the amounts drawn from a federal award must be supported by records that show costs were incurred and that the personnel charged to the award actually devoted the claimed time to it. If a financial reviewer requests supporting documentation for a quarterly draw, the answer must be the actual payroll data from the books, not a budget estimate.

A draw that cannot be tied to the books requires a corrective memo and a revised financial report. In some cases, the variance must be repaid or credited against future draws. The correction process takes more time and attention from the PI than the original allocation setup would have required.

Beyond the current award, compliance findings from one NIH grant appear in the agency’s grants management record for the institution. They affect the company’s position when applying for Phase II awards, renewal cycles, or follow-on funding from other federal agencies.

What good payroll allocation looks like

For life sciences clients with active NIH or NSF awards, we establish funding-source classes in QuickBooks before the first payroll run under the new award.

Each pay period, the bookkeeper collects the effort percentages from either a time tracking system or a supervisor’s written attestation. The payroll journal entry is split by class: wages, payroll taxes, and benefits are each allocated by the same percentage in the same entry. At quarter-end, the grant class report is reconciled to the draw request line by line before the request is submitted.

Indirect costs are calculated monthly against the grant-allocated direct payroll, using either the 10 percent de minimis rate or the company’s negotiated rate agreement with the cognizant federal agency. The monthly indirect charge is posted to the grant class, so the running balance in the books matches the cumulative draw at any point in the award period.

The setup takes one to two hours to configure. The ongoing allocation takes about 20 minutes per pay period. The documentation it produces satisfies the 2 CFR 200 effort certification standard and gives the PI a defensible basis for the effort reports they sign each quarter.

Best practices for biotech payroll under grants

A few practices that keep grant payroll allocation accurate throughout the award period:

Set up QuickBooks Classes or Projects for each active award before the first payroll run under that award. Include the award number and period of performance start date in the class name so the account is unambiguous.
Collect effort percentages at the close of each pay period, not retroactively. A record created at the time of work is always more defensible in a financial review than one reconstructed months later.
Apply the same percentage to wages, payroll taxes, and benefits in the same payroll entry. Do not tag wages to the grant and reconcile fringe separately at year-end.
If you use a payroll processor such as Gusto, ADP, or Rippling, confirm that the processor’s QuickBooks journal entry supports class or project tagging at the line level. Some default integrations post a summary entry only, which does not capture the funding-source split.
Run a grant class report at the end of each month. Compare the running total to the cumulative grant budget for the same period. Variances over 10 percent of the monthly budget are worth understanding before they accumulate across quarters.

Three questions worth asking

If your company has an active federal award and payroll is posting to a single account, three questions to bring to whoever manages the books:

Can you pull a report that shows, by pay period, how much of each employee’s wages and benefits was charged to the NIH award and how much went to internally funded work?
Were the effort percentages recorded at the time payroll was processed, or are they being estimated after the fact to support the draw request?
Does the quarterly draw amount reconcile exactly to the grant class balance in QuickBooks, line by line, before the request is submitted?

If those answers are uncertain, the draw requests are based on estimates, not documentation. The fix is a class setup and payroll allocation workflow. It is straightforward to put in place at any point during the award period, even if prior payroll has to be reallocated retroactively.

If you have an active NIH, NSF, or SBIR award, send us your current chart of accounts and a recent payroll register. We will review whether your allocation setup meets the effort documentation standard and identify what needs to change before the next reporting period.