Retail ERP Consultant, Canada

Federal and provincial sales tax at every till

In Canada, the tax a shopper pays depends on the province of the store. Some provinces use a harmonized tax, others charge the federal GST with a separate provincial sales tax, and Quebec has its own QST. Certain product categories are treated differently from general merchandise, and the rules for children's clothing, food, books or other items vary between provinces.

For a single-province retailer this is mostly a setup task. For a chain across several provinces, it becomes a design question. Each location must be set to the right province, each item must carry a tax class the POS can interpret province by province, and receipts must show the taxes in the way your advisor confirms. Returns must reverse the tax that was charged on the original sale, even when a customer returns an item to a store in another province.

Tax advice is outside my role. What I produce from your advisor's guidance is a scenario table: product type, store province, sale or return, expected taxes. That table becomes the UAT script. The Canada ERP consultant page covers the finance side of multi-province tax, so this section stays at the register.

French for Quebec stores: receipts, labels and the item master

Retailers selling in Quebec work within the province's language rules, which affect product information, packaging, signage and documents given to customers. Legal counsel confirms the obligations for your business. Making the system meet them on every label and receipt is where I come in.

The foundation is the item master. Every product needs a French name and description held in the ERP, not added at the till or on a printed sticker. Variant attributes such as color and size need French values too. Shelf labels, price tickets, receipts, return slips and gift cards then draw on that data automatically for Quebec stores, while other stores can print English or both.

Customer-facing communications matter as well: loyalty emails, order confirmations for click and collect and any messages printed on receipts. I specify language preference on the customer record and check how each platform handles it.

Training is part of the same requirement. Store staff in Quebec should learn the POS in French, with screens and guides to match. I include French labels and receipts in UAT for every printer model, because a mistranslated or truncated line is easy to miss in a test environment and very visible in a store.

Buying in US dollars and supplying stores across long distances

Many Canadian retailers buy a large share of their merchandise from US suppliers or US-based distributors. Purchase orders are raised in US dollars, goods cross the border with duty and brokerage charges, and the retail price is set in Canadian dollars. If exchange, duty and freight do not reach item cost, margin reports flatter the business and markdown decisions are made on the wrong numbers.

I design landed cost so each receipt carries its real cost in Canadian dollars, and I agree with finance how exchange differences between order and payment are treated. For the ledger treatment of USD payables, see ERP for multi-currency.

Distance is the other Canadian factor. A distribution center in one province may serve stores thousands of kilometers away, and winter weather can delay trucks. Replenishment rules need longer cover for remote stores, shipments are often consolidated, and inter-store transfers within a region can be faster than waiting for the DC. I map lead times store by store and agree the replenishment logic with your planners. Warehouse design itself is covered on my Zoho Inventory page for Canadian sellers.

Interac, gift cards and a store P&L you can trust

Debit through the Interac network remains a common way to pay in Canadian stores, alongside credit cards, mobile wallets and cash. Each tender settles on its own timetable and fee structure. I design the daily close so each store's takings are recorded by tender and matched automatically to processor settlements and bank deposits, leaving finance to investigate only the differences.

Gift cards need careful treatment. Several provinces have consumer rules on gift card expiry and fees, so check current requirements with your advisor before designing the program. In the system, a sold card is a liability until it is redeemed, balances must work in every store and online, and finance needs a report of outstanding balances by issue period.

With tenders and gift cards under control, a store profit and loss becomes realistic. I set store, region and banner dimensions in the chart of accounts, bring in occupancy and labor cost by location, and agree allocation of head office costs with your controller. Payroll usually stays in a dedicated Canadian payroll service, with labor cost fed in by store, so the ERP does not have to take on provincial payroll rules.

Migration and the Canadian retail calendar

A typical starting point is QuickBooks or Sage at head office with a cloud POS, plus spreadsheets for transfers and gift cards. Migration means rebuilding the catalog with bilingual descriptions and variants, verifying barcodes, loading opening stock from a fresh count, and carrying over gift card and loyalty balances so customers notice nothing.

Timing follows the retail year. The holiday season and the sales after it, back-to-school and category-specific peaks such as winter gear or garden season are poor moments for a cutover. I usually recommend a pilot store in a quiet period, with a planned rollout by province or region once issues are fixed. Head office functions such as purchasing and accounting can often move first, giving finance a month or two on the new ledger before stores follow.

I run workshops remotely and schedule them around your head office time zone, with recorded walkthroughs for stores in other provinces. The Canada hub explains the other ways I support Canadian businesses, and ERP data migration describes the migration method in detail.