A profit and loss statement shows whether a business makes money over a period. This template has a Transactions tab for every sale, cost and expense, a Monthly tab that totals each month into gross profit and net profit, and a Dashboard with the year's totals, margins and charts by P&L line.

It comes with sample data for a small shop. Make a copy and replace the sample rows. The formulas, dropdowns and charts update on their own.