On Monthly P&L, fill the yellow cells down each month column, revenue, cost of goods sold, then your operating costs like rent, salaries, marketing and other. Gross profit, gross margin percent, operating profit, net profit and net margin percent all work themselves out, and the Full year column totals every month.
The Summary shows the whole year at a glance, with a loss in red and a profit in green. Yellow cells are your only inputs. The premium version adds a dashboard of revenue versus cost of goods and net profit by month with a margin trend, a cost-structure analysis, and a printable A4 profit and loss statement. Opens in Excel, WPS or Google Sheets.