<aside> 💰

Know what every product costs you, what every client bought and which products actually sell. Enter your products and collections once, then log each client order after their ordering appointment.

</aside>

📊 1. Collection Scorecard

Which collections clients choose and what each one brings in: clients, total sales, average sale, highest sale and wall art rate. Rename the rows to match your collections. The numbers fill in on their own.

Collection Scorecard

🖼️ 2. Products & Pricing

Enter each product's retail price, lab cost, framing or finishing, and packaging and shipping. Total COGS, Profit, Margin and Markup calculate automatically. Times Sold, Revenue Earned and Profit Earned count up as you log orders, so you can see your best sellers at a glance. Sort by any column to rank them. The starter products are examples, so rename, delete or add your own.

Products & Pricing

✏️ 3. Client Orders

This is where you type. One row per client, after their ordering appointment. Enter the total sale, pick the Collection Purchased, and link every product they bought in Products Purchased. Product cost of goods, gross profit and margin fill in automatically. Link their Inquiry to connect the sale to its lead source.

Client Orders

<aside> 💡

Bought two of the same product? Link it once, and add the second one's cost to Other Costs. Every order should have a Collection Purchased, even if it's "No collection / à la carte", so the Collection Scorecard adds up to all your sales.

</aside>