Sales Are Up. Why Is Profit Down? A Simple Retail P&L Review
Your store sold more this month, but the business feels no better off. Higher sales can be accompanied by deeper discounts, a different product mix or additional operating costs. A monthly profit and loss review helps you see where the difference occurred.
Start with net sales
Use sales after discounts and returns, excluding sales tax collected. If your POS already reports net sales, do not deduct discounts and returns again. Compare budget and actual figures for the same month and business scope.
Separate inventory purchases from cost of goods sold
For a basic inventory-based model, cost of goods sold equals opening inventory at cost plus net purchases and freight-in, less closing inventory at cost. If opening stock is $10,000, purchases are $6,000, freight-in is zero and closing stock is $8,000, COGS is $8,000. Do not also deduct the same purchases as an operating expense.
Use a consistent cost valuation method. The IRS explains the general inventory and COGS calculation in Publication 334; accounting treatment depends on the business. The worksheet is a management view, not a tax return. Use the classifications and figures maintained with your bookkeeper.
Then look at operating expenses
At $20,000 net sales and $8,000 COGS, gross profit is $12,000. If operating expenses total $7,000, operating profit is $5,000. Other income, interest and applicable business income tax expense then lead to net profit or loss. These are illustrative figures, not a target margin.
Check payroll, rent, payment fees, marketing and other costs. A positive actual-minus-budget expense variance means spending was above budget. A positive profit variance means profit exceeded budget. Those signs need different interpretations.
Use the Monthly Profit & Loss Planner
The Excel worksheet lays out budget, actual results and the difference side by side. It includes inventory-based COGS and expense categories with input notes. Save a new copy each month. Enter zero for genuinely absent costs so a missing number is not mistaken for a complete result.
Profit is not the same as cash in the bank. Owner contributions, loan proceeds, owner drawings and loan principal repayments do not belong in operating revenue or expenses simply because money moved. Equipment purchases and depreciation also have different timing.
Takeaway: when sales rise but profit falls, review product costs and operating expenses before assuming the answer is more sales. The P&L Planner is separate from the holiday bundle.
Comments