Liquor Store Profit Tracker

What's included

• Products and Pricing — product, category, unit price, unit cost, margin per unit, units sold, revenue, cost of goods, and gross profit, for 12 products.
• Daily Sales Log — date, product, quantity, unit price, unit cost, amount, cost of goods, and channel, for 26 sales in October 2026. Unit price and unit cost are pulled from sheet 1 by formula.
• Stock and Inventory — opening stock, stock received, units sold by formula, shrinkage and write-offs, closing stock, reorder point, stock value, and a low-stock status flag by formula, for 12 products.
• Monthly P and L — revenue, cost of goods, rent, staff, utilities, marketing, insurance, supplies 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, transactions, average sale, cost of goods, gross profit and margin, expenses, net profit and margin, stock value, low-stock and out-of-stock counts, shrinkage cost, dead stock value, best and weakest products, revenue by product, costs by category, and units by product.
• Cover and How to Use — start here. Yellow cells are the only ones you edit.

Related templates

This template is a bookkeeping and planning tool only — not tax, legal, or CPA advice. Built by an accountant: B.S. Accountancy, ASU W. P. Carey.