Skip to content
Tutorials Center
My learning

Topics

Lesson 35 of 36 ยท Projects and Practice

Project: A Retail Month with Inventory and Sales Tax

Practice a retail month in QuickBooks: buying stock, selling with sales tax, processor deposits with fees, COGS and gross margin, with runnable calculators to check each step.

In this second project you keep the books of a small shop for one month. Retail adds three things a service business does not have: inventory, sales tax and payment-processor deposits. Use the steps in QuickBooks Online Plus (inventory tracking on) or on paper, then check yourself with the stand-ins.

QuickBooks cannot run on this site. The TryIts are JavaScript stand-ins; all names, prices and the sales tax rate are invented for the exercise.

The business: Corner Candle Co.

Corner Candle sells candles from a small shop and takes card payments through a processor that deposits sales minus a fee. Sales tax is 8% on candles (illustrative). On June 1:

  • Checking: 6,000. Inventory: 0. Owner's equity: 6,000.

Items: Soy candle (cost 5.00, price 14.00, reorder point 20) and Gift set (cost 12.00, price 30.00, reorder point 8).

Events

  1. Jun 2: Buy 100 soy candles at 5.00 and 30 gift sets at 12.00 from a supplier on a bill (net 30). Shipping of 40 is included in the invoice.
  2. Jun 10: Week 1 sales through the card processor: 40 soy candles and 8 gift sets, with 8% sales tax collected.
  3. Jun 12: The processor deposits the net amount: total received minus a 2.9% fee on the total collected (illustrative).
  4. Jun 20: Week 2 sales: 35 soy candles and 10 gift sets, plus the same tax and fee treatment.
  5. Jun 25: Pay the supplier bill.
  6. Jun 30: Remit the sales tax collected (in practice on the return due date set by your agency).

Plan in QuickBooks

  • Create two Inventory items with cost, price, SKU, initial quantity zero and reorder points. Turn on sales tax and mark both items taxable.
  • Event 1: a Bill with item lines; add shipping either as a separate line (to the Inventory Asset or a Freight expense according to your accountant) or spread into the item cost.
  • Events 2 and 4: Sales receipts, one per day or per week, to the processor. Each increases Undeposited Funds, income, and Sales Tax Payable, and reduces inventory.
  • Events 3 and 4: Bank deposits that group the receipts, with a negative line for the Processor fees expense.
  • Event 5: Pay bills. Event 6: a Sales tax payment from the Sales tax center.
  • At month end: reconcile checking, run the P&L, Inventory valuation summary and Sales tax liability report.
flowchart LR
    A["Bill: stock bought"] --> B["Inventory Asset"]
    C["Sales receipt"] --> D["Sales income + Sales Tax Payable"]
    C --> E["COGS from inventory"]
    C --> F["Undeposited Funds"]
    F --> G["Bank deposit minus processor fee"]
    B --> E

Each sale touches income, tax, inventory and cash.

Check the numbers

JS Inventory, COGS and gross margin

Press Run (or Ctrl + Enter) to see the console output here.

No output.

The shipping of 40 raises the bill; in this simplified stand-in it is not spread over items, so the inventory value after sales is slightly lower than your QuickBooks Inventory Asset if you capitalized shipping. Decide your treatment and stay consistent.

JS Sales tax, processor fee and the bank deposit

Press Run (or Ctrl + Enter) to see the console output here.

No output.

Use these results to test your QuickBooks file: Sales tax payable should match the second TryIt's total, and each bank deposit should match the processor's payout.

Questions to answer

  1. After event 6, what balance should Sales Tax Payable have? (Zero, if you remitted everything.)
  2. What is the balance of Undeposited Funds after the deposits? What does a non-zero amount indicate?
  3. Did the processor fee affect Cost of Goods Sold or operating expenses? (Expenses; it is not part of the cost of the goods.)
  4. Which items are closest to their reorder point, and how does the reorder point help? See Inventory and Cost of Goods Sold.
  5. Which accounts would a physical count adjust?

Check your understanding

Quick check ยท 4 questions

of 4 answered You scored / 4 ยท perfect!

  1. 1. Where does the cost of the candles sold go at the time of sale?

    The cost of units sold leaves inventory and becomes COGS, matching the sale.
  2. 2. How do you record the processor's fee?

    Adding a negative fee line to the deposit makes the total match the bank amount and records the expense.
  3. 3. The sales tax you collected is...

    Collected tax belongs to the government and sits in Sales Tax Payable.
  4. 4. Why group sales receipts into a bank deposit?

    Grouping mirrors how the money arrives at the bank, which makes matching and reconciling straightforward.

Summary

  • Retail bookkeeping links bills, inventory, sales receipts, processor deposits and sales tax.
  • COGS is recorded when stock is sold; fees and tax are separate from cost of goods.
  • Use calculators to cross-check Sales Tax Payable, deposits and gross margin.
  • Reconcile, review inventory valuation and remit tax at month end.

Next: Practice: Bookkeeping Challenges