Spreadsheet Templates
•
Published on Nov 20, 2026
•
By SheetVault Editorial Team
•
Free .XLSX
Free Small Business Profit & Loss Statement Template for Excel & Google Sheets (Download)
=B2-B3
What Is a Profit & Loss (P&L) Statement?
A P&L statement summarizes a business’s revenues, costs, and expenses over a period, showing the net profit or loss.
Benefits of Using This Template
- Instant financial snapshot for owners and lenders.
- Automatic calculations reduce errors.
- Works in both Excel and Google Sheets.
Step‑By‑Step Setup
- Open the attached workbook and go to the Profit Loss tab.
- Enter your actual numbers in the Amount column (B).
- The Calc column (D) contains formulas that update automatically.
- Review the Net Profit After Tax row to see your bottom line.
Pro Tips
- Copy the sheet for each month and rename the tab (e.g., Jan‑2024).
- Use conditional formatting to highlight negative profit.
- Link the totals to a dashboard for quick KPI tracking.
Download Ready-to-Use Spreadsheet
Instant .xlsx file download with pre-loaded formulas, formatted totals, and clean design.
Download Template (.xlsx)Frequently Asked Questions
Can I add more expense categories?
Yes, insert rows below Operating Expenses and adjust the Net Profit formula to reference the new total range.
Will the formulas work in Google Sheets?
All formulas use standard syntax, so they work identically in Google Sheets without modification.