The Retail Stores Bookkeeping Playbook for Ontario Owners | Ledgerive
Home / Knowledge Base / Retail

The Retail Stores Bookkeeping Playbook for Ontario Owners

POS reconciliation, inventory, HST, gift cards and payroll: a step-by-step system for keeping your store's books clean, compliant and useful.

Summary

Retail bookkeeping in Ontario is harder than it looks: hundreds of daily transactions, card fees, refunds, inventory, gift cards and several HST rates all have to land correctly in your books. This playbook gives store owners a complete system, starting with CRA business number (BN) registration and HST setup, then covering POS reconciliation, inventory and cost of goods sold, payroll and the KPIs that show whether your store is really profitable. It closes with a daily-to-annual checklist you can follow from tomorrow.

Ontario's independent retailers, from boutiques on Queen Street West and Ottawa's ByWard Market to hardware stores, pharmacies and gift shops in towns across the province, face the same bookkeeping problem. Sales happen all day across cash, debit, credit, e-transfer and online orders, while money arrives in the bank in batches, minus fees, days later. Inventory moves constantly, and the HST on a children's sweater differs from the HST on a candle.

When the books fall behind, owners lose sight of what matters: which products actually make money, how much inventory is walking out the door, and whether there is enough cash to cover the next supplier order and the HST payment. Many only discover problems at year-end, when the accountant asks for an inventory count nobody took.

This playbook fixes that with a practical system built for Ontario retail. We use a running example throughout: a single-location gift and home decor boutique with $1.2 million in annual sales, three full-time and six part-time staff, and a mix of in-store and online sales.

Behind on your store's books?

Get monthly retail bookkeeping with POS reconciliation, inventory tracking and HST filing, at a fixed monthly fee quoted in writing.

1. Why Retail Bookkeeping Is Different

A consultant might issue twenty invoices a month. A retail store can process that many sales before lunch. Retail books have to handle:

  • High transaction volume across several payment methods that settle on different schedules.
  • Inventory, which is often the store's largest asset and the main driver of cost of goods sold (COGS).
  • Several HST treatments for different product categories, plus point-of-sale rebates.
  • Card processing fees that are often deducted before deposits reach the bank.
  • Returns, exchanges and gift cards, each with its own accounting and tax rules.
  • Shrinkage from theft, damage and errors that only shows up when you count.
  • Strong seasonality, with the holiday quarter often producing a third or more of annual sales.

2. BN Registration and CRA Setup

Every retail bookkeeping system starts with the correct CRA registrations. Your CRA business number is a nine-digit identifier the Canada Revenue Agency uses for all your federal tax accounts. Each obligation runs through a program account attached to it, shown as your BN plus two letters and four digits (for example, 123456789 RT0001).

BN registration is done through the CRA's Business Registration Online service, by phone or with Form RC1. Ontario corporations generally receive a business number automatically when incorporating through the Ontario Business Registry. Sole proprietors still need a BN once they register for HST or hire staff. Register before opening day so you can claim input tax credits on your fit-out, fixtures and opening inventory.

CRA program accounts for an Ontario retail store
AccountPurposeRetail note
RT (GST/HST)Collect HST on sales, claim input tax creditsMandatory once taxable sales exceed $30,000 over four consecutive quarters
RP (Payroll)Remit source deductions, CPP and EINeeded from your first employee, including part-time staff
RC (Corporate income tax)T2 returns and instalmentsApplies if the store operates through a corporation
RM (Import-export)Importing goods into CanadaNeeded if you import inventory directly from foreign suppliers

Your HST filing frequency depends on annual taxable sales: $1.5 million or less can file annually, over $1.5 million up to $6 million quarterly, and over $6 million monthly. Many retailers choose to file more often than required, since smaller, regular payments are easier on cash flow than a single large annual bill.

3. A Retail Chart of Accounts

A generic chart of accounts lumps all sales into one line, which hides the information retailers need most. Structure yours around how your store actually makes money:

Key accounts for a retail chart of accounts
SectionRecommended accounts
RevenueSales by category (e.g. home decor, gifts, apparel), online sales, shipping income, discounts and returns as contra accounts
Cost of goods soldPurchases by category, freight-in, duties, inventory adjustments, shrinkage
Current assetsInventory, card processor clearing, cash float, undeposited funds
Current liabilitiesHST payable, gift card liability, customer deposits and layaways, payroll liabilities
Operating expensesWages, rent and CAM, card processing fees, POS software, packaging, marketing

4. POS and Bank Reconciliation

The most important retail habit is reconciling your point-of-sale reports to actual bank deposits. Whether you use Shopify POS, Square, Lightspeed, Clover or Moneris, record the full sale in your books, then match the net deposit:

Bank deposit = Gross sales + HST collected โˆ’ Refunds โˆ’ Card processing fees
Example: reconciling one day of card sales
ItemAmount
Gross card sales before tax$4,000
HST collected (13%)$520
Refunds processed (including HST)โˆ’$113
Card processing feesโˆ’$112
Expected bank deposit$4,295

If you only record the $4,295 deposit as sales, you understate revenue, misstate HST and lose sight of what card fees cost you. Use a clearing account for each processor, and investigate any difference that doesn't clear within a few days. Count cash drawers daily and record overs and shorts separately so patterns stand out.

5. Inventory and Cost of Goods Sold

Gross margin is only as accurate as your inventory. Most modern POS systems support a perpetual inventory system that reduces stock with every sale. Combine it with:

  • Accurate receiving. Record purchases at landed cost, including freight, duties and brokerage.
  • Cycle counts. Count a different section each week so the whole store is checked every quarter.
  • A full year-end count. Inventory is generally valued at the lower of cost and net realizable value to calculate COGS for tax.
  • Shrinkage tracking. Book the difference between system and counted stock to a separate shrinkage account.
  • Dead stock review. Flag items unsold for 6 to 12 months for markdown or write-down.

Gross margin should be tracked by category, not just for the store as a whole. In our example boutique, the categories look very different:

Category margins guide buying decisions: shifting floor space toward candles and gifts and buying seasonal stock more tightly could lift overall margin by several points. This is the same per-product thinking we apply in our financial modeling services.

6. HST Rules Every Ontario Retailer Must Know

Ontario's HST rate is 13%, but not everything on your shelves is taxed the same way. Set up separate tax codes in your POS for each treatment:

Common HST treatments in Ontario retail
TreatmentRate chargedExamples
Standard taxable13%Home decor, adult clothing, electronics, candles, most general merchandise
Ontario point-of-sale rebate5% (8% Ontario portion rebated)Children's clothing and footwear, children's car seats, diapers, books, print newspapers
Prepared food rebate5% on qualifying itemsPrepared food and beverages totalling $4.00 or less
Zero-rated0%Basic groceries, prescription drugs and certain medical devices
  • Gift cards: HST is generally not charged when a gift card is sold. Record it as a liability, then recognize the sale and HST when the card is redeemed.
  • Input tax credits: Claim the HST you pay on inventory, rent, fixtures and supplies, and keep invoices showing the supplier's business number.
  • Online sales: Sales shipped to other provinces are taxed at the destination province's rate, so configure your e-commerce platform accordingly.

7. Payroll for Retail Staff

Retail payroll is complicated by part-time staff, variable hours, holidays and turnover. Key Ontario requirements to build into your process:

  • Vacation pay of at least 4% of wages for employees with under five years of service, rising to 6% at five years.
  • Public holiday pay under the Employment Standards Act, including premium pay for staff who work the holiday.
  • Source deductions for CPP, EI and income tax, remitted through your RP account on time.
  • Records of Employment (ROEs) issued when seasonal or part-time staff leave.
  • Employer Health Tax once Ontario payroll exceeds the exemption for eligible employers.
  • T4 slips issued and filed by the end of February each year.

8. Retail KPIs and Seasonality

Clean books turn into decisions when you track a handful of retail KPIs every month. For our example boutique:

45%
Gross margin (sales โˆ’ COGS รท sales)
3.2x
Inventory turnover (COGS รท average inventory)
1.5%
Shrinkage as a share of sales

Where each sales dollar goes: example boutique

$1.2 million in annual sales; net profit before owner tax

8% net profit
  • Cost of goods sold55%
  • Wages & payroll costs15%
  • Rent & occupancy10%
  • Card & POS fees2.5%
  • Marketing3%
  • Other operating costs6.5%
  • Net profit8%

Seasonality shapes cash flow as much as profit. The boutique earns over a third of its sales in the fourth quarter, but has to pay for holiday inventory in September and October, before that cash arrives.

A 13-week cash flow forecast, part of our fractional CFO services, helps you time supplier orders and credit line draws. If you are planning a second location, a lender-ready plan from our business plan services makes financing easier. Our guide to business plan services for Ottawa fitness studios and gyms shows how lenders review expansion plans, and our article on financial modeling services in Vaughan explains what a forecast typically costs.

9. The Retail Bookkeeping Calendar and Common Mistakes

Retail bookkeeping calendar
FrequencyTasks
DailyClose out POS, count cash drawer, record overs and shorts, file receipts
WeeklyMatch processor deposits to POS reports, enter supplier bills, run a cycle count
MonthlyReconcile all bank and card accounts, review category margins, reconcile gift card liability, close the books
QuarterlyFile HST if on a quarterly cycle, review aged inventory, update cash flow forecast
AnnuallyFull inventory count, T4s and T4 summary, year-end adjustments, corporate or personal tax filing

Mistakes we see most often

  • Recording net deposits as sales, hiding card fees and misstating HST.
  • One tax code for everything, overcharging HST on rebated items or undercharging on taxable ones.
  • Gift cards booked as revenue when sold rather than when redeemed.
  • No year-end inventory count, leaving COGS and profit as guesses.
  • Mixing personal and business spending on the same card.
  • Missing or wrong CRA business number details on supplier invoices, which can put input tax credits at risk in an audit.
Let us run the playbook for you. Our bookkeeping services cover POS reconciliation, inventory, HST filing and payroll for retailers across Ontario, in QuickBooks Online, Xero or your existing system. Running a professional practice instead? See our guide to financial modeling for law firms in Ontario, or, if you are raising capital to scale, how to build an investor-ready financial model in Toronto.

10. Frequently Asked Questions

Does a retail store in Ontario need a CRA business number?
Most do. A CRA business number (BN) is required to register for HST, which is mandatory once taxable sales exceed $30,000 over four consecutive calendar quarters, and to run payroll for staff. BN registration can be done through the CRA's Business Registration Online service, and Ontario corporations generally receive a BN when they incorporate through the Ontario Business Registry.
What is the best accounting software for a retail store in Canada?
QuickBooks Online and Xero are the most common choices for Canadian retailers because they handle HST and integrate with popular point-of-sale systems such as Shopify POS, Square and Lightspeed. The best fit depends on your POS, inventory complexity and number of locations.
How should a retail store track inventory for tax purposes?
Retailers generally need to value inventory at year-end, commonly at the lower of cost and net realizable value, to calculate cost of goods sold. A perpetual inventory system in your POS, supported by regular cycle counts and a full year-end count, gives the most accurate results.
Do I charge HST on everything I sell in Ontario?
No. Most goods are taxable at 13% HST, but some are zero-rated, such as basic groceries, and Ontario provides a point-of-sale rebate of its 8% portion on items such as children's clothing and footwear, children's car seats, diapers, books and print newspapers, so those are charged 5%. Set up tax codes in your POS for each category.
How much does bookkeeping cost for a small retail store in Ontario?
As a general market range, monthly bookkeeping for a small single-location retailer often costs roughly $300 to $1,500 per month, depending on transaction volume, inventory complexity, payroll and HST filing frequency. Catch-up work is usually quoted separately.

Summary

Strong retail bookkeeping in Ontario starts with a registered CRA business number and the right program accounts, then follows a steady routine: reconcile POS sales to deposits, track inventory at landed cost, apply the correct HST code to every product and treat gift cards as liabilities until redeemed. Add accurate payroll and a monthly KPI review, and your books will show which products make money, how much cash you need for the holiday season and when you are ready to grow.

Get your store's books under control this month

Ledgerive provides fixed-fee retail bookkeeping, HST filing and cash flow support for store owners across Ontario. Book a free 30-minute call or reach us directly.

Disclaimer: The above contents are provided for general guidance only, based on information believed to be accurate and complete, but we cannot guarantee its accuracy or completeness. It does not provide legal advice, nor can it or should it be relied upon. Please contact/consult a qualified tax professional specific to your case.