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.
| Account | Purpose | Retail note |
|---|---|---|
| RT (GST/HST) | Collect HST on sales, claim input tax credits | Mandatory once taxable sales exceed $30,000 over four consecutive quarters |
| RP (Payroll) | Remit source deductions, CPP and EI | Needed from your first employee, including part-time staff |
| RC (Corporate income tax) | T2 returns and instalments | Applies if the store operates through a corporation |
| RM (Import-export) | Importing goods into Canada | Needed 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:
| Section | Recommended accounts |
|---|---|
| Revenue | Sales by category (e.g. home decor, gifts, apparel), online sales, shipping income, discounts and returns as contra accounts |
| Cost of goods sold | Purchases by category, freight-in, duties, inventory adjustments, shrinkage |
| Current assets | Inventory, card processor clearing, cash float, undeposited funds |
| Current liabilities | HST payable, gift card liability, customer deposits and layaways, payroll liabilities |
| Operating expenses | Wages, 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:
| Item | Amount |
|---|---|
| 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:
Gross margin by category: example boutique
Store average is 45%; seasonal stock drags margin down through markdowns
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:
| Treatment | Rate charged | Examples |
|---|---|---|
| Standard taxable | 13% | Home decor, adult clothing, electronics, candles, most general merchandise |
| Ontario point-of-sale rebate | 5% (8% Ontario portion rebated) | Children's clothing and footwear, children's car seats, diapers, books, print newspapers |
| Prepared food rebate | 5% on qualifying items | Prepared food and beverages totalling $4.00 or less |
| Zero-rated | 0% | 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:
Where each sales dollar goes: example boutique
$1.2 million in annual sales; net profit before owner tax
- 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.
Share of annual sales by quarter
Plan inventory purchases and HST reserves around the Q4 peak
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
| Frequency | Tasks |
|---|---|
| Daily | Close out POS, count cash drawer, record overs and shorts, file receipts |
| Weekly | Match processor deposits to POS reports, enter supplier bills, run a cycle count |
| Monthly | Reconcile all bank and card accounts, review category margins, reconcile gift card liability, close the books |
| Quarterly | File HST if on a quarterly cycle, review aged inventory, update cash flow forecast |
| Annually | Full 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.
10. Frequently Asked Questions
Does a retail store in Ontario need a CRA business number?
What is the best accounting software for a retail store in Canada?
How should a retail store track inventory for tax purposes?
Do I charge HST on everything I sell in Ontario?
How much does bookkeeping cost for a small retail store in Ontario?
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.