Free Profit & Loss Statement Template

This profit and loss template is designed for:

• Small business owners who want to track monthly and annual profitability without a full accounting system
• Freelancers and self-employed professionals who need to see their income versus expenses at a glance
• Startup founders building their first financial reporting process
• Entrepreneurs preparing financial documents for investors, lenders, or tax professionals
• Side business operators who want to understand if their side income is actually profitable after costs

The template is particularly valuable for businesses that want to monitor their gross profit margin regularly — one of the most important indicators of business health and pricing effectiveness.

Follow these steps to complete your profit and loss statement:

• Step 1 — Enter your revenue. List every income source. For product businesses, this is your total sales. For service businesses, it is your total fees charged. Choose and label one accounting basis in the Period row: cash basis generally records receipts and payments; accrual basis records earned revenue and incurred expenses. Keep that basis consistent across all months. The sheet does not convert between methods.
• Step 2 — Enter cost of goods sold (COGS). These are the direct costs of producing your product or delivering your service. Include materials, direct labour, and production costs.
• Step 3 — Calculate gross profit. The template automatically calculates: Gross Profit = Revenue − COGS. This shows how much money remains before operating costs.
• Step 4 — Enter operating expenses. List all business overhead: rent, utilities, marketing, employee salaries (include owner payroll only where appropriate for the entity; sole-proprietor draws belong outside the P&L), software subscriptions, professional services, and insurance.
• Step 5 — Calculate net profit. Operating Profit = Gross Profit − Operating Expenses. Net Profit = Operating Profit − the Interest and tax row. Enter only amounts attributable to this business P&L; personal income tax and owner draws are not sole-proprietor expenses. Loan principal repayments are cash outflows, not P&L expenses.
• Step 6 — Review each month. Compare the three columns on the Profit & Loss sheet. To extend it, copy the whole Month 3 column to the right, rename the heading, replace the sample inputs, and check that relative formula references moved correctly. There is no separate monthly summary tab.

• Gross Profit = Revenue − COGS
• Operating Profit = Gross Profit − Total Operating Expenses
• Net Profit = Operating Profit − the combined Interest and tax row
• Net Margin = Net Profit ÷ Revenue × 100

• All entered amounts follow one chosen accounting basis for the period and should stay consistent each month.
• Each month has its own column. Copy a whole month column to extend the worksheet, then check the formula references.
• The template includes a simplified P&L structure for management planning, not full statutory reporting.

• This template does not include depreciation schedules, impairment, revenue recognition edge cases, or advanced tax allocations.
• Principal repayments, draws, and capital investments are cash-oriented and should be handled separately from P&L expenses.
• The combined Interest and tax row is entered manually. At zero or negative revenue, margins show N/A. Review the profit amount; an undefined margin is not a 0% margin.

• Mixing personal and business expenses. Keep a dedicated business bank account to avoid misclassifying personal spending as business costs, which inflates your expenses and understates profit.
• Forgetting irregular income. Record irregular receipts consistently with your selected accounting basis. Do not spread a cash receipt over several months merely to make the results look smoother.
• Confusing cash flow with profit. An accrual P&L can show revenue before a client pays. Even a cash-basis P&L differs from a bank balance because borrowing, principal repayments, asset purchases, and owner withdrawals need separate treatment.
• Omitting depreciation. The sheet does not calculate depreciation. Ask your accountant whether an asset purchase should be capitalized, depreciated, or expensed under the applicable reporting method; enter an appropriate period amount without double counting the purchase.
• Not separating gross and net profit. Tracking only net profit can hide problems. If your gross profit is shrinking while net profit holds, your COGS is rising — a pricing or supplier problem you need to address.
• Only reviewing annually. Businesses that only check their P&L at tax time miss months of correctable issues. Review monthly to catch problems early.