Monthly Profit and Loss Template: Track Revenue and Expenses Month by Month (2026)
A 12-month P&L grid with rolling totals, month-over-month change calculations, and seasonal pattern analysis. Pre-filled with realistic e-commerce data showing Q4 holiday spike and January dip.
12-Month P&L: E-Commerce Business 2025
Example data. Revenue range $34K-$72K/month with Q4 seasonal spike. All amounts in USD.
| Line Item | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Total |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Revenue | |||||||||||||
| Product Sales | $38,500 | $34,200 | $41,000 | $39,800 | $43,500 | $42,000 | $44,800 | $46,200 | $51,000 | $62,500 | $72,000 | $58,400 | $573,900 |
| Total Revenue | $38,500 | $34,200 | $41,000 | $39,800 | $43,500 | $42,000 | $44,800 | $46,200 | $51,000 | $62,500 | $72,000 | $58,400 | $573,900 |
| Cost of Goods Sold | |||||||||||||
| Inventory Cost | $21,175 | $18,810 | $22,550 | $21,890 | $23,925 | $23,100 | $24,640 | $25,410 | $28,050 | $34,375 | $39,600 | $32,120 | $315,645 |
| Gross Profit | $17,325 | $15,390 | $18,450 | $17,910 | $19,575 | $18,900 | $20,160 | $20,790 | $22,950 | $28,125 | $32,400 | $26,280 | $258,255 |
| Gross Margin % | 45.0% | 45.0% | 45.0% | 45.0% | 45.0% | 45.0% | 45.0% | 45.0% | 45.0% | 45.0% | 45.0% | 45.0% | 45.0% |
| Operating Expenses | |||||||||||||
| Total Opex | $9,200 | $9,200 | $9,200 | $9,200 | $9,800 | $9,200 | $9,800 | $9,200 | $9,800 | $12,500 | $14,000 | $11,000 | $122,100 |
| Net Income | $8,125 | $6,190 | $9,250 | $8,710 | $9,775 | $9,700 | $10,360 | $11,590 | $13,150 | $15,625 | $18,400 | $15,280 | $136,155 |
| Net Margin % | 21.1% | 18.1% | 22.6% | 21.9% | 22.5% | 23.1% | 23.1% | 25.1% | 25.8% | 25.0% | 25.6% | 26.2% | 23.7% |
5 Things to Check Every Month
Is this month up or down vs last month? Is it up vs same month last year? Both comparisons matter. A January dip after December is expected - but a January dip vs the prior January is a warning sign.
Your gross margin percentage should be relatively stable unless you changed pricing or supplier costs. A declining gross margin means your direct costs are eating more revenue - investigate immediately.
Compare each expense category to your budget or prior period. Which categories grew as a percentage of revenue? Salary creep and software subscription growth are the most common culprits.
Look at the last three months of net income. Is the trend up, flat, or down? A single bad month is noise. A declining 3-month average is a signal that requires action.
Net income is not cash. Check whether revenue is recognized before cash is received (if you invoice) or if large expenses were prepaid (insurance, annual software). Note these timing differences.
Monthly Action Calendar
Review the full prior year P&L. Set revenue and expense targets for the new year. Reconcile annual totals against your tax accountant's figures.
Q1 review: is the year starting as planned? This is also the time to make your first quarterly estimated tax payment if you are self-employed. Use Q1 net income to estimate the full year.
Mid-year review. Are you on track to hit annual targets? If not, what needs to change? July is early enough to make adjustments that will meaningfully affect the year-end result.
Q3 review and year-end planning. For businesses with Q4 seasonality (retail, e-commerce), this is when to finalize holiday inventory and marketing budgets. For all businesses, review tax strategy before December 31.
Final expense timing decisions: accelerate or defer expenses based on your tax situation. Ensure any year-end bonuses, equipment purchases, or prepayments are made before the close of the fiscal year.