Free Profit and Loss Statement Template

A profit and loss statement template is a ready-made document that shows money coming in (revenue) and going out (expenses) over a specific period—revealing whether you made or lost money.

A profit and loss statement template simplifies tracking income and expenses so you focus on what the numbers mean, not just what they are. It helps you spot trends, prepare for tax season, and make decisions based on facts.

This free template includes sections for company name, reporting period, revenue (sales, other income), gross profit, operating expenses (rent, utilities, wages, etc.), and net income or loss.

This template comes in Excel format. Excel includes built-in formulas that calculate automatically when you input your numbers. It's easy to save, update, and create charts that turn your data into insights.

Start with your business name and time period (monthly, quarterly, etc.). Gather all income sources—every sale, service, and side gig. List the direct costs that made those sales happen. Then add every other expense from rent to professional development. The template calculates everything and shows whether you made or lost money.

It depends on your business needs. Most small businesses update monthly, while seasonal businesses focus on quarterly comparisons. Everyone needs an annual version for growth tracking. Update as often as you make big decisions.