Excel P&L (Basic) Template (editable)

A streamlined Profit & Loss you can actually use. This P&L (Basic) template captures Revenue, COGS, Operating Expenses, and summarizes Gross Profit and EBITDA—ideal for small businesses and side projects needing a clear monthly overview.
 
Highlights
Monthly columns with Totals and clean subtotals
Classic structure: Revenue → COGS → Gross Profit → Opex → EBITDA
Ready for Actuals vs Budget or Prior Year (add columns as needed)
Print-ready for investors, banks, or internal reviews
 
Great for: freelancers, small teams, early-stage startups.

Quick start (How-to) In P&L sheet, fill monthly values under Revenue, COGS, Operating Expenses. Subtotals and key metrics (Gross Profit, EBITDA) calculate automatically. (Optional) Add a Budget column and a Variance column: =Actual - Budget or % = DIVIDE(Actual-Budget,Budget). Use Data Validation to standardize account names; add a simple chart for MoM trends. Export to PDF for sharing. Tip: Keep a separate Chart of Accounts tab to maintain consistent naming across months.