Free Profit & Loss Template
Track monthly revenue, cost of goods sold, operating expenses, gross profit, operating profit and net profit with automatic annual totals and margin calculations using this free Excel spreadsheet.
What's Included in the Profit & Loss Template?
The workbook contains three primary worksheets designed to work together.
P&L Dashboard
Monthly P&L
Setup & Instructions
Track Revenue, COGS & Operating Expenses
The spreadsheet includes commonly used categories. You can adapt category names to your own needs.
Revenue & Cost of Goods Sold
- Product Sales
- Service Revenue
- Other Revenue
- Inventory / Materials
- Direct Labor
- Shipping / Delivery
- Other COGS
Operating Expenses
- Payroll & Wages
- Rent / Lease
- Utilities
- Insurance
- Marketing & Advertising
- Software & Subscriptions
- Professional Services
- Office Supplies
- Repairs & Maintenance
- Vehicle & Transportation
- Bank & Payment Processing Fees
- Licenses & Permits
- Telephone & Internet
- Travel & Meals
- Taxes & Fees
- Other Operating Expenses
How to Use the Profit & Loss Template
- 1Download and open the Excel workbook.
- 2Review the revenue, COGS, and operating expense categories.
- 3Enter revenue amounts for each month.
- 4Enter cost of goods sold for each month.
- 5Enter operating expenses for each month.
- 6Review gross profit, operating profit, and net profit.
- 7Use the Dashboard to review annual totals and margins.
- 8Update the workbook regularly as financial results change.
How Profit Is Calculated
Gross profit shows what remains after the direct cost of what you sold. Operating profit shows what remains after ordinary operating costs are also deducted. Net profit and its margin are calculated automatically in the template.
What Is a Profit & Loss Statement?
A profit and loss statement summarizes a business's revenue, cost of goods sold, and operating expenses over a specific period to show whether the business generated a profit or a loss. It moves from revenue down to gross profit, operating profit, and net profit, giving owners a structured view of where money came from and where it went. A P&L is a reporting tool, not a guarantee of future performance.
Gross Profit, Operating Profit & Net Profit
Gross profit is revenue minus the direct cost of producing or delivering what you sold. Operating profit is gross profit minus the ordinary costs of running the business, such as rent, payroll, software, and marketing. Net profit is the amount remaining after all of those costs and expenses are deducted. Each figure answers a different question about how the business performed.
Monthly vs. Annual P&L
Reviewing a P&L monthly helps you spot trends — a slow sales month or an unexpected cost — before they compound. Maintaining an annual view at the same time keeps the full-year picture visible so seasonal patterns and yearly totals stay clear. This template supports both: monthly entries roll up into annual totals automatically.
Profit & Loss vs. Cash Flow
A P&L shows revenue minus costs and expenses over a period. A cash flow statement tracks the actual movement of cash into and out of the business. A business can report a profit on a P&L while still experiencing cash-flow pressure because the timing of customer payments and outgoing expenses may not match when revenue and costs are recorded. Many businesses use both reports together.
Download the Free Profit & Loss Spreadsheet
Use this template to track monthly revenue, costs, and expenses, and monitor gross profit, operating profit, and net profit throughout the year.
Related Business Tools & Templates
Profit & Loss Template FAQ
What is a profit and loss statement?+
A profit and loss statement (P&L) summarizes a business's revenue, costs, and expenses over a specific period to show whether the business generated a profit or a loss. It typically moves from revenue to cost of goods sold, gross profit, operating expenses, operating profit, and net profit.
Is this profit and loss template free?+
Yes. The Profit & Loss Template is free to download and use. No signup, email, account, or payment is required.
What is the difference between gross profit and operating profit?+
Gross profit is revenue minus cost of goods sold. Operating profit is gross profit minus operating expenses such as rent, payroll, software, and marketing. Operating profit shows what remains after the ordinary costs of running the business are deducted.
What is net profit?+
Net profit is the amount remaining after cost of goods sold and operating expenses are deducted from revenue. The template calculates net profit and net profit margin automatically.
How do I create a monthly profit and loss statement?+
Enter your revenue, cost of goods sold, and operating expenses for each month. The spreadsheet automatically calculates gross profit, operating profit, net profit, and the corresponding margins, then rolls the monthly figures into annual totals.
What expenses should be included in a P&L?+
Include cost of goods sold (direct costs such as materials, inventory, and direct labor) and operating expenses (rent, payroll, utilities, insurance, marketing, software, professional services, and other overhead). Include the categories that reflect how your business records costs.
How often should I update my profit and loss statement?+
Most small businesses update their P&L monthly so they can spot trends early. The template supports monthly entries that roll up into an annual summary, so you can review both month-to-month and full-year performance.
Does the spreadsheet calculate profit margins automatically?+
Yes. The workbook calculates gross profit margin, operating profit margin, and net profit margin from the figures you enter, along with annual totals.
Can I customize the expense categories?+
Yes. The category names are editable so you can adapt them to your business. Add, rename, or remove revenue and expense categories to match your operations.
Does this replace accounting software?+
No. This template is an organizational and educational tool. It does not replace accounting, bookkeeping, or tax software. For formal financial reporting, use dedicated accounting software and consult qualified professionals.
Can service businesses use this template?+
Yes. Service businesses can use the same structure. If you have little or no inventory, you can leave cost of goods sold categories at zero or repurpose them for direct service-delivery costs.
Is a P&L the same as a cash flow statement?+
No. A P&L shows revenue minus costs and expenses over a period. A cash flow statement tracks the actual movement of cash into and out of the business. A business can show a profit on a P&L while still experiencing cash-flow pressure because of the timing of payments.
This template is provided for general educational and organizational purposes only. It is not accounting, tax, legal, investment or financial advice. Businesses should review their individual financial and reporting requirements with qualified professionals when appropriate.