Free Template

US GAAP P&L Template

A profit and loss template structured to US GAAP presentation standards. Includes revenue recognition aligned with ASC 606, cost of revenue, gross profit, operating expenses broken out by function (R&D, S&M, G&A), operating income, other income/expense, income tax provision, and earnings per share calculation. Designed for US companies that need a clean, auditable income statement for both internal planning and SEC reporting. For guidance on GAAP-aligned budgeting, see [US GAAP Budgeting Best Practices for 2026](/blog/us-gaap-budgeting-best-practices-2026).

What's included

Everything in this template

  • Full US GAAP income statement structure with standard subtotals
  • Revenue section supporting ASC 606 disaggregation by type and timing
  • Operating expense breakdown by function (R&D, Sales & Marketing, G&A)
  • Stock-based compensation expense allocation across functions (ASC 718)
  • Income tax provision with effective rate and deferred tax summary
  • Basic and diluted EPS calculation

Template preview

See the structure

fx=Revenue - CostOfRevenue - OpEx - OtherExpense - IncomeTax
Line Item
Q1
Q2
FY Total
Revenue
$12,500k
$13,800k
$53,200k
Cost of Revenue
($4,375k)
($4,830k)
($18,620k)
Gross Profit
$8,125k
$8,970k
$34,580k
Operating Expenses
($6,250k)
($6,624k)
($25,520k)
Operating Income
$1,875k
$2,346k
$9,060k

Step by step

How to use this template

1

Enter revenue by stream

Populate revenue lines by product or service type. The template supports ASC 606 disaggregation by revenue type (subscriptions, professional services, licenses) and recognition timing (over time vs. point in time).

2

Populate cost of revenue

Enter direct costs including hosting, customer support, implementation costs, and any amortization of capitalized software. The gross margin formula updates automatically.

3

Break down operating expenses by function

Enter R&D, Sales & Marketing, and G&A expenses. Each function includes sub-lines for salaries, stock-based compensation (ASC 718), depreciation, and other costs.

4

Add tax provision and EPS

Enter the income tax provision using your estimated effective rate. The template calculates both basic and diluted EPS using your share count inputs.

5

Review and compare to prior periods

Check auto-calculated gross margin, operating margin, and net margin percentages. Enter prior year figures for year-over-year variance analysis.

Watch out

Common mistakes to avoid

Omitting stock-based compensation from operating expenses, understating true cost structure

Using the 21% statutory federal rate instead of the blended effective rate including state taxes

Not separating restructuring charges and other one-time items from recurring operating expenses

Budgeting bookings instead of ASC 606 recognized revenue

Build this in Grove FP in minutes

Import this template directly into Grove FP and start planning. No credit card required.

FAQ

Frequently asked questions