R&D Tax Credit Worksheet for Manufacturing Companies
Manufacturers do qualifying research more often than they think: new part designs, process development, tooling and automation trials, and material testing can all count. This worksheet lets an engineering manager and controller list spend by project, apply a realistic qualifying percentage and see a first estimate of the federal credit.
| Project | Qualifying activity | Expense type | Total spend | Qualifying % (%) | Estimated QRE | |
|---|---|---|---|---|---|---|
$111,600 | ||||||
$24,500 | ||||||
$63,900 | ||||||
$26,000 | ||||||
$53,900 | ||||||
$24,960 |
Replace the sample rows with your own projects. Under the alternative simplified credit the standard rate is 14% of QREs above 50% of the average of the prior three years' QREs, or 6% of current QREs when a prior year is missing. Wages must be for qualified services such as direct research, direct supervision or direct support. Document technological uncertainty and the process of experimentation for each project. Not tax advice.
Pull prototype and engineering costs from your ERP
Optional: see how project and work order data can be summarised automatically for an R&D credit study.
Optional. The tool and every export work without this. No spam.
How to use the worksheet
Add one row per project and expense type. Enter the total spend, then the percentage that relates to qualified activity based on time records, engineering logs or interviews. The worksheet computes the estimated qualified research expense for each row and totals it. Replace the sample rows, export to Excel and share it with your tax advisor, who will refine the percentages and prepare the credit calculation and supporting study.
What generally qualifies
The credit rests on the four-part test in Section 41: the work must aim to develop a new or improved function, performance, reliability or quality, rely on principles of engineering or science, address technical uncertainty, and involve a process of experimentation. For manufacturers, qualified expenses include wages for staff doing the work, supplies consumed in it, and a portion of contract research. Routine quality control, cosmetic changes and production after commercial release usually do not qualify.
- Wages for engineers, technicians and supervisors doing qualified work
- Supplies used up during experimentation, not general overhead
- Contract research limited to 65 percent of amounts paid
- Rental of computers used in qualified research
Reading the credit estimate
The worksheet shows the simplest case, a 6 percent credit on current QREs when there are no prior-year QREs, and a second illustration of the 14 percent over 50 percent of the prior three-year average method. Your real result depends on your actual history, entity type, the corporate rate reduction election and other limits. Use the estimate to decide whether a formal study is worth doing, not as a filing figure.
Common mistakes and ERP notes
The biggest errors are claiming whole departments instead of the qualified portion, missing contemporaneous records, and including production work after the design is final. Your ERP can help: project accounting, work orders for prototype builds and labor reporting by engineering order give a data trail. In Infor SyteLine, SAP, Epicor and Oracle, tagging engineering projects and prototype work orders makes the supplies and labor easy to extract at year end.
Frequently Asked Questions
Does a manufacturer qualify for the R&D credit?
Often yes, if it develops new or improved products, processes or tooling and faces technical uncertainty resolved through experimentation. Routine production, quality inspection and cosmetic changes do not qualify. A project-level review is the only reliable way to tell, and documentation matters as much as the work.
What is the difference between 6 percent and 14 percent?
Under the alternative simplified credit, 14 percent applies to QREs above half of the prior three-year average. If you have no QREs in one of the three prior years, the method uses 6 percent of current QREs instead. Your advisor will choose the method that gives the best result.
Are contract researchers included?
Yes, but only 65 percent of amounts paid for qualified research performed on your behalf, with additional conditions on who bears the risk and who owns the results. Keep the contract, the statement of work and proof of payment with the project file.
Do I need a formal study?
For a meaningful claim, yes. Most advisors prepare a study that documents each project against the four-part test and ties spend to ledgers and payroll. The worksheet helps you decide whether the potential credit justifies the cost of that study.
Netray can pull prototype work orders, engineering labor and project costs from your ERP so your tax advisor starts with structured data instead of a blank spreadsheet.
Related Tools
Section 179 Equipment Deduction Calculator
Estimate the Section 179 deduction for new CNC machines and plant equipment, including the phase-out and the taxable income limit.
Country & TaxTexas Franchise Tax Margin Calculator
Estimate Texas franchise tax by comparing the four margin methods, apportioning to Texas receipts and applying the no tax due threshold.
Costing & FinanceMACRS and Bonus Depreciation Fixed Asset Tax Worksheet
List new machines and estimate first year tax deduction from Section 179 expensing, bonus depreciation and the MACRS first year rate.
Country & TaxTexas Manufacturing Sales Tax Exemption Checklist
Walk through the registration, qualifying-use, documentation and ERP tax-code steps that support the Texas manufacturing exemption on plant purchases.
More Costing & Finance tools
See all- Manufacturing State Incentive Readiness Assessment
- SAP QM Inspection Effort and Cost Calculator
- SAP Standard Cost Estimate BOM Rollup Calculator
- Legacy ERP Retirement Cost and Payback Calculator
- JD Edwards World Month-End Close Procedure Template
- Distributor Customer Credit Application Template
- Distributor Customer Profitability Worksheet
- Distributor GMROI and Inventory Turns Calculator
- Vendor Early Pay Discount Worksheet
Keep exploring
Free tools
- Qualified Research Expense Wage Allocation WorksheetEstimate qualified wages by employee using the share of time spent on qualified research activities, with a project column for support.
- Order Credit Hold Release ChecklistA step by step checklist for deciding whether to release, partially release or keep a sales order on credit hold.
- UAE VAT Tax Invoice and Tax Credit Note TemplateFill-in UAE tax invoice layout with supplier and customer TRN, line items, 5% VAT and AED totals, plus a matching tax credit note block.
ERP fixes and how-tos
- How to Apply a Credit Memo in JobBOSSCreate and apply a customer credit memo against an invoice in JobBOSS: the process, the accounting effect, returned goods, tax and common mistakes.
- How to Release a Customer Order from Credit Hold in SyteLineFind why a SyteLine customer order is on credit hold, see who is authorized to release it, and set credit limits and days-past-due rules so it stops recurring.
- Oracle Fusion Tax Configuration: Regimes, Taxes, Rates, Rules and How to Test ThemHow to configure Oracle Fusion Tax: party and configuration owner options, regimes, taxes, statuses, rates, rules, and how to test with the Tax Simulator.
Runs with your ERP
- Vertex with Infor LN: sales and use tax and VAT calculationHow Vertex indirect tax software works with Infor LN, SyteLine, M3 and other Infor ERPs for sales and use tax and VAT, with setup steps, pitfalls and AI use.
- Vertex O Series and Infor CloudSuite: sales tax and VAT calculationHow Vertex O Series indirect tax is configured in Infor CloudSuite for sales, use and VAT calculation, with data flows, setup, pitfalls and a private AI layer.
- Vertex Cloud with SAP Business ByDesign: embedded indirect taxHow Vertex Cloud works inside SAP Business ByDesign: embedded US and Canada indirect tax, activation through scoping, data flows, pitfalls and AI review.
Guides
- SyteLine Tax Engine Configuration and Setup GuideConfigure the tax calculation engine in Infor SyteLine with tax codes, tax groups, jurisdiction setup, exemption handling, and tax reporting for compliance.
- How to Configure Tax Calculation in SyteLineComplete guide to configuring tax calculation in Infor SyteLine. Set up tax codes, tax rates, tax exemptions, and integration with external tax engines for manufacturing.
- SyteLine AR and Credit Management Configuration GuideConfigure accounts receivable and credit management in Infor SyteLine including credit limits, aging analysis, collections workflows, and dunning letters.
AI on your ERP
- AI for ERP Credit Management: Limits, Holds and Exposure Without SpreadsheetsAI on your ERP for credit limit reviews, order hold triage and exposure questions. Read-only by default, role-aware and deployable on-prem.
- AI for SAP S/4HANA Sales and Distribution (SD) That Explains Orders, Pricing and BlocksAI for SAP S/4HANA SD: order status, delivery and billing blocks, pricing explanations and credit holds in plain English. Read-only, on-prem option.
Integrations
- How to add Microsoft Teams to Sage 100Add Microsoft Teams to Sage 100: adaptive card approvals, credit hold and PO alerts, Entra ID sign-in, and a bridge that works with an on-prem Sage server.
- How to add Microsoft Teams to Epicor Prophet 21Connect Epicor Prophet 21 to Microsoft Teams: adaptive card approvals for POs and credit holds, inventory alerts and order lookups, with Entra ID auth.