Jewelry Business

The Jewelry Business tracks Products and Pricing - piece, category, unit price, unit cost, margin per unit, units sold, revenue, cost of goods, and gross profit for every piece. Change a price and the margin and totals update.; Daily Sales Log - date, piece, 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, materials and supplies, marketing, packaging, software and fees, and other costs, with a monthly cost for each.; Monthly P and L - revenue, cost of goods, rent, utilities, materials, 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; 75 units sold in 39 transactions; total revenue 3,001.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.