Pizza Shop / Pizzeria

The Pizza Shop / Pizzeria tracks Products and Pricing - menu item, category, unit price, unit cost, margin per unit, units sold, revenue, cost of goods, and gross profit for every item. Change a price and the margin and totals update.; Daily Sales Log - date, menu item, quantity, unit price, unit cost, amount, cost of goods, and channel for every sale. Unit price and unit cost are pulled from sheet 1 by formula.; Expenses - rent, utilities, labor, marketing, packaging, software and fees, and other costs, with a monthly cost for each.; Monthly P and L - revenue, cost of goods, rent, utilities, labor, marketing, packaging, software and fees and other expenses by month, Jan-Dec, with net profit and margin. Revenue and cost of goods are formulas from the Sales Log.; Dashboard - total revenue, units sold, transactions, average sale value, gross profit and margin, expenses, net profit and margin, best and weakest products, revenue by product, costs by category, and units by product..

The included example shows: 12 products; 930 units sold in 66 transactions; total revenue 7,563.00.

Yes. The workbook works in Microsoft Excel and in Google Sheets (upload the .xlsx file to Google Drive to open it in Sheets). It is an instant digital download from Etsy — no physical item is shipped.