Car Care Products Profit and Loss Template: Line by Line

Lines Every Month Should Have

Use the same lines every month so one period can be compared with the next. For a New Zealand store registered for GST, prepare the operating statement excluding GST where appropriate: GST in New Zealand is charged at a rate of 15% (Inland Revenue (Te Tari Taake), GST) (Source: Inland Revenue (Te Tari Taake)).

The statement should run from trading income to the result that remains after running costs:

• Product sales
• Less: discounts and promotions
• Less: refunds and returns
• Equals: realised revenue
• Less: cost of goods sold (the product cost of units sold)
• Equals: gross profit and gross margin
• Less: shipping and fulfilment, payment processing fees, advertising, wages, rent, software subscriptions, and other operating overheads
• Equals: net profit and net margin

A Filled-In Monthly Statement

This filled-in monthly statement uses consistent NZD labels and shows how each subtotal is calculated. Amounts are presented excluding GST, so the operating result is not distorted by tax collected or paid.

Delivered product sales are the month's completed sales before refunds. Cost of goods sold (COGS) is the product cost attached to those sales, so gross profit is $27,900 ($46,500 − $18,600). Operating expenses cover advertising, transaction fees, fulfilment, wages, storage and administration. Keep owner drawings, loan principal repayments and asset purchases outside this operating statement unless your accounting policy specifically treats them as expenses.

How to Fill It In

Choose one accounting basis and keep it unchanged across months. An accrual P&L records the sale when the order is delivered and the cost when the goods are sold; a cash-basis P&L records money when it moves. Accrual reporting usually gives a cleaner view of monthly trading, but either basis can work if applied consistently. For a GST-registered New Zealand store, remove GST from sales and costs before entering them; GST is charged at 15% (Inland Revenue, GST) (Source: Inland Revenue (Te Tari Taake)).

Start with Shopify’s order report, then reconcile it to each payment provider and the bank settlement. Do not treat the provider’s payout as sales: it is usually sales collected, less refunds, chargebacks and processing fees. Match delivered orders to the month, and exclude cancelled orders. Record discounts as a reduction of sales, not as a marketing expense. Record refunds against sales; if returned stock is saleable, reverse its cost of goods sold, while damaged or unsellable returns may require a stock write-off.

Allocate costs according to what they relate to. Product purchase cost and inbound freight belong in inventory and become cost of goods sold when the item sells. Payment fees, outbound fulfilment freight, storage, advertising, software and wages are operating expenses. This separates gross margin, the economics of the products, from net profit after running the store, making each measure useful for a different decision.

How to Read the Result

Read the result from top to bottom. Revenue shows the value of orders recognised for the month. Gross profit is revenue less the cost of the products sold, so it shows whether pricing and product costs leave enough margin before overheads. Operating profit then subtracts expenses such as advertising, wages, rent, software and fulfilment. Net profit is what remains after the other costs included in the statement, such as interest and tax provisions where applicable.

The computed lines in the worked example are subtotals, not additional income. Check each one by repeating its arithmetic: revenue minus cost of goods equals gross profit; gross profit minus operating expenses equals operating profit; and the remaining listed costs produce net profit. A positive net profit does not necessarily mean the bank balance increased. A P&L is the right report for judging monthly trading performance and margin. Use a cash-flow report to see when money actually entered or left the bank, including stock payments and loan movements. Use a balance sheet to check what the store owns, owes and has invested in at a specific date.

Common Bookkeeping Gaps

A missing supplier invoice understates both payables and costs. Search supplier statements and match each invoice to the month the goods were received. Do not code every stock purchase straight to expenses: a $2,300 purchase of polish and accessories is inventory first, while only the cost of units sold belongs in the month’s cost of goods sold. Keep GST treatment consistent; New Zealand’s GST rate is 15% (Inland Revenue, GST) (Source: Inland Revenue (Te Tari Taake)).

Refunds are another common gap. A returned $180 order should reduce realised revenue and be included in refund reporting, rather than remaining as a sale with an unexplained bank withdrawal. Check payout imports for duplicates: if one Shopify payout appears twice, revenue or fees can be overstated even when the bank balance is correct.

Separate personal spending from store costs, and assign business expenses to clear categories such as advertising, freight, software or merchant fees. Finally, investigate timing differences: a December ad invoice paid in January, or goods received before the supplier invoice arrives, should be recorded according to the accounting basis used for the P&L. ORVX can show delivered-order revenue, refund value, product costs and profitability, helping expose gaps between sales, payouts and stock movement.

Turn Each Line Into an Action

Use each change as a review trigger rather than a verdict. A lower product margin calls for a product- and collection-level check: separate price changes, discounts, product mix, supplier costs and returns before changing the range. A higher fulfilment cost calls for an order-size, packaging and carrier review. Payment fees should be checked against transaction volume, refunds and the provider’s fee structure.

Labour and overheads need a different response. Compare labour hours with orders and sales before changing staffing; review rent, software, insurance and other fixed commitments when overheads rise. A P&L supports these operating decisions, but it does not show available cash: receivables, tax payments, loan repayments and timing can change the bank balance. It also does not show inventory value or dead stock, so review the stock position separately before treating unsold goods as cash.

• Act on product margin when unit economics or collection mix changes; validate costs and returns first.
• Act on fulfilment cost when cost per order rises; check packaging, carrier charges and order size.
• Act on payment fees when fees per transaction change; reconcile refunds and payment-provider statements.
• Act on labour when labour cost per order changes; compare hours, order volume and service needs.
• Act on overheads when recurring costs rise; review the specific contract or commitment, not just the total.

A useful monthly P&L is consistent before it is elaborate: every sale, refund, product cost and overhead needs one clear place. Review it with the cash-flow report and balance sheet so a profitable month is not mistaken for cash available to spend.