Contact Info
Canada
How can an ERP consultant help Canadian importers and traders?
For Canadian importers and cross-border traders, an ERP consultant designs how customs broker data and charges flow into landed cost, how GST/HST, PST and QST are determined by province and customer type, how CAD and USD are handled side by side, and how French documents are produced for Quebec. I map the trade, test platforms on it and oversee implementation independently.
Last reviewed by Vikas Saroj
I work remotely with Canadian trading companies: importers landing goods from Asian and European suppliers, distributors moving product between provinces, and businesses that buy from or sell into the United States almost daily. A typical setup is QuickBooks or Sage 50 for the books, a stock spreadsheet or add-on, and a customs broker who sees the shipment data before the accounting team does.
Canadian trade has its own combination: federal GST or HST plus provincial PST or QST that depends on where goods go and whether the buyer is reselling them, CBSA import accounting handled with your broker, and a constant exposure to the US dollar. Quebec customers may also expect French-language documents.
I map how your goods, taxes and currencies actually move, then help you select and implement an ERP built around that.
What I Do
Canadian traders usually come to me when broker invoices, provincial tax questions and USD balances have turned month end into a reconstruction exercise.
I define the item and shipment data your customs broker needs, including classification and origin, and how their invoices for duty, GST and fees are matched back to the purchases they relate to.
Tax rules by province of destination and customer type, including registered resellers who should not be charged PST, captured as requirements and tested against your accountant's guidance.
Purchases in US dollars costed into Canadian-dollar inventory, USD bank accounts reconciled and revalued, and exchange differences kept away from the product margin your buyers rely on.
Sales to US customers priced in dollars, with origin information recorded for CUSMA claims where they apply and commercial invoices generated from the order rather than typed again.
Invoice, packing slip and statement templates in English and French for Quebec customers, with product descriptions held in both languages where your customers or regulations call for it.
Demos scripted around your shipments and tax scenarios, a fit-gap agreed with process owners, and steady oversight of the implementer from UAT through cutover to the first GST return.
What to Measure
An ERP for trading should make these numbers available without a spreadsheet. I design the data model and reports around them from the start.
Platform Fit
How I Work
How shipments, tax and dollars move
Import walkthrough with broker
Provinces you ship to
Customer exemption records
USD exposure today
Requirements and fit testing
Tax determination matrix
Landed cost and FX rules
Scripted platform demos
Fit-gap sign-off
Implementation and cutover
Implementer coordination
Open orders and USD balances
UAT on tax scenarios
First GST return review
For most Canadian importers, the customs broker is the hinge of the whole process. The broker classifies goods, submits release and accounting data to CBSA, pays duty and GST on your behalf or through your own account, and invoices you for all of it plus fees. The CARM client portal now gives importers direct visibility of their own account, which makes clean in-house data more valuable than it used to be.
The ERP's job is to hold that data where the business can use it. On each item: the classification your broker advised, country of origin and any preference claimed. On each shipment: the supplier invoice, bill of lading, broker transaction reference and the separate duty, GST and fee amounts. Then duty becomes part of landed cost, GST paid at import goes to the input tax credit account, and broker fees follow your costing policy.
I usually find all of these posted as a single freight expense. Splitting them is a decision I agree with your accountant and record in the requirements before configuration starts, together with how late broker invoices are treated when some of the stock has already been sold.
Sales tax in Canada is layered. Federal GST applies everywhere, harmonized provinces combine it into HST, and other provinces add their own PST or, in Quebec, QST. The tax on an invoice depends on where goods are delivered and what they are, and for a trading company it also depends heavily on who is buying. A retailer or distributor buying for resale may be exempt from PST when they provide their registration details, while an end user in the same province is not.
That makes customer tax records a core part of the design. I write requirements for capturing each customer's province, tax registrations and exemption status, for determining tax by ship-to province, and for reviewing exemptions periodically. I also check how the platform treats transfers between your own warehouses in different provinces.
Reporting then has to support each return you file, which your accountant confirms. My aim is an ERP that produces those figures directly, without an export to a spreadsheet and a set of manual adjustments. The Canadian ERP consulting page covers sales tax design for other industries too.
Most Canadian traders feel the US dollar in two directions. Suppliers in Asia often invoice in USD, and US customers expect USD pricing. Many businesses hold a USD bank account to net the two, which is sensible but makes the accounting harder: payments in USD, receipts in USD, inventory valued in CAD, and exchange differences at every step.
The design decisions I get agreed are the rate source and update frequency, how realized and unrealized gains and losses are posted, how USD bank accounts are revalued, and how margin is reported so currency swings do not distort product profitability. I test each one with a purchase paid weeks after receipt and a US sale collected into the USD account.
Selling into the US brings its own documents: commercial invoices with origin statements where you claim CUSMA treatment, and in some cases US sales tax obligations depending on how and where you sell. I flag those for your advisors rather than guess. If you also distribute domestically through depots or routes, the distribution ERP page is worth reading alongside this one, and ERP for multi-currency goes deeper into FX handling.
QuickBooks and Sage 50 are the starting points I see most in Canadian trading companies, often with a separate inventory tool and a folder of broker invoices saved as PDFs. The move to ERP usually follows a second warehouse in another province, a jump in US sales, a lender asking for better inventory reporting, or simply a month end that takes too long.
Migration focuses on open purchase orders and deposits, goods in transit with broker charges to date, opening stock at landed cost in CAD, open CAD and USD receivables and payables at the right rates, and customer tax records including exemption details. Historic transactions normally remain in the old system for lookup.
I compare platforms on your own scenarios: a USD purchase with a late broker invoice, a sale to a PST-exempt distributor, a Quebec customer needing a French invoice, a US customer billed in USD. As an independent advisor I have no platform to push, and I stay involved alongside the implementer you choose. Sessions run remotely and are placed in your head office hours. See the Canada overview and the main trading ERP page for more.
Tell me about your business and current systems. I’ll suggest the most sensible first step.
Book a Consultation
Not sure which ERP you need?
Share your business requirements with me and I will help you understand the right process, architecture and platform before implementation.
FAQ
Usually not. Most Canadian importers keep a customs broker who handles submissions to CBSA. The ERP should hold accurate classification and origin data, send it to the broker in a consistent format, and record the broker's transaction references and charges against the right purchases. A direct connection is rarely worth the effort unless you file entries yourself.
Through customer tax settings: each customer record holds its province, registrations and exemption status, and the ERP applies the right tax by ship-to province and customer type. The design work is collecting and maintaining those records properly. I define the fields and review process, and your accountant confirms the rules for each province you sell into.
Yes, all the platforms I evaluate support foreign-currency bank accounts. What needs care is the rate source, revaluation at period end, and how gains and losses are reported so they do not distort product margins. I agree those rules with your accountant and test them with real past transactions during UAT.
Yes. I include bilingual invoice and statement templates, French product descriptions and customer language preferences in the requirements, then check how each platform handles them during demos. Template quality varies between platforms and implementers, so I review French layouts with your team well before go-live.
Workshops, requirement sessions and design reviews are held online at times that suit your head office, with recordings for teams in other provinces. Shared process maps and a single decisions log keep everyone aligned between sessions, so the project keeps moving without needing extra meetings across time zones.
Every business is different. Share where you are today and what you want to fix, and I’ll tell you honestly whether and how I can help.
Book a Consultation
Insights
Book a Consultation
Book a consultation to talk through your processes, systems and goals. I’ll reply with practical next steps - no obligation.
