eCommerce Bookkeeping Services: A Complete Guide for Ontario Online Sellers (with Real Journal Entry Examples)
eCommerce bookkeeping services specialize in tracking, reconciling, and reporting financial transactions for online sellers across platforms like Shopify, Amazon, and Etsy. Unlike traditional bookkeeping, eCommerce accounting handles platform fees, multi-channel payouts, inventory cost of goods sold (COGS), and sales tax compliance. Ontario sellers face an additional layer: HST/GST registration requirements, CRA record retention rules, and cross-border tax obligations for US sales.
This guide covers real journal entry examples for 8 transaction types, Ontario HST registration thresholds, CRA audit-proofing requirements, and a software stack comparison for eCommerce sellers at every revenue stage. Acctax has provided eCommerce bookkeeping services to Ontario online sellers for 17 years, keeping books accurate, compliant, and CRA-ready.
What Is eCommerce Bookkeeping?
eCommerce bookkeeping is the systematic recording, categorizing, and reconciling of all financial transactions generated by an online store. We separate gross platform sales from net bank deposits, reconciling settlement reports from Shopify, Amazon, and eBay to produce CRA-ready books for Ontario online sellers.
Sales & Payouts
Capturing gross revenue across all platforms and matching settlement reports to actual bank deposits to account for refunds and reserves.
Fee & Expense Tracking
Categorizing platform fees, transaction fees, FBA fees, and advertising costs as distinct expense lines for maximum tax deductibility.
Inventory & COGS
Valuing inventory using FIFO or weighted average methods and recording the cost of goods sold (COGS) per unit to monitor true margins.
Tax Compliance
Collecting, tracking, and remitting HST/GST in Ontario and managing US sales tax obligations for your cross-border orders.
Financial Reporting
Producing accurate profit and loss statements, balance sheets, and cash flow reports for CRA compliance and scaling decisions.
Data Reconciliation
Recording every dollar that flows through your business, including shipping income, refunds, and payment processor adjustments.
Under the Income Tax Act, Ontario eCommerce businesses must retain financial records for a minimum of 6 years. Accurate bookkeeping is a legal and tax obligation for incorporated sellers.
Why eCommerce Bookkeeping Is Different
Traditional retail records simple sales and expenses. eCommerce introduces a more complex reality: a Shopify store might record $100.00 in gross sales but receive a net deposit of $97.10 after transaction fees. Without platform-specific reconciliation, your books will overstate revenue and understate expenses.
| Factor | Traditional Retail | eCommerce |
|---|---|---|
| Income Sources | Single POS system | Multiple platforms (Shopify, Amazon, Etsy) |
| Deposit Structure | Full gross amount deposited | Net payout after fees, refunds, reserves |
| Inventory Location | Single physical location | Multiple fulfillment centers (FBA, 3PL) |
| Sales Tax | Ontario HST only | HST + US State Sales Tax (Nexus) |
| Currency | CAD only | CAD + USD + Multi-currency payouts |
Multi-Platform Income
Revenue arrives from Shopify, Amazon, and eBay simultaneously, each with unique fee structures and payout cycles.
Settlement Reports
Platform payouts bundle sales, fees, refunds, and reserves into a single net figure that must be reverse-engineered.
Multi-Currency
USD sales require conversion to CAD at the Bank of Canada exchange rate on the specific transaction date.
Ontario eCommerce sellers using Amazon FBA or Shopify face these factors simultaneously. General bookkeeping lacks the platform-specific logic required to reconcile these correctly.
Key Components of eCommerce Bookkeeping
eCommerce bookkeeping consists of 7 interconnected components. Each feeds into the next: accurate sales recording enables correct payout reconciliation, which drives precise COGS calculation and tax filing. Weakness in any one component creates errors across all downstream reports.
| Component | Description | Why It Matters |
|---|---|---|
| Sales Recording | Capturing gross revenue from every platform at the time of sale. | Prevents revenue overstatement; ensures accrual basis accuracy. |
| Payout Reconciliation | Matching platform settlement reports to actual bank deposits. | Identifies unrecorded fees, refunds, and reserves. |
| Fee Tracking | Categorizing FBA fees, transaction fees, and ad spend as distinct lines. | Maximizes deductible expenses; reduces taxable income. |
| Inventory & COGS | Valuing inventory using FIFO or weighted average costing per unit. | Produces accurate gross margins; satisfies CRA requirements. |
| Sales Tax Management | Tracking Ontario HST (13%) and US sales tax for cross-border orders. | Prevents CRA penalties for late or incorrect remittances. |
| Multi-Currency | Converting USD/foreign transactions to CAD at Bank of Canada rates. | Meets CRA reporting standards; prevents book distortions. |
| Financial Reporting | Producing monthly P&L, balance sheets, and cash flow reports. | Enables accurate tax filing and informed business decisions. |
Reconciliation Intensity
Amazon FBA bi-weekly settlements bundle hundreds of transactions. Shopify sellers using multiple processors (PayPal, Stripe) receive staggered payouts that must be synced.
Inventory Standards
Under Canadian accounting standards, you must use FIFO or weighted average costing. LIFO is strictly not permitted by the CRA.
Automated Accuracy
Our services manage all 7 components monthly, ensuring your filings stay accurate without the daily manual workload of cross-platform tracking.
We handle the complex interplay between these 7 components so your business remains CRA-compliant while you focus on scaling your store.
Common eCommerce Bookkeeping Mistakes (and How to Avoid Them)
eCommerce sellers make 6 recurring bookkeeping mistakes that distort financial reports, trigger CRA penalties, and erode profit margins. Each mistake stems from applying traditional retail accounting logic to a multi-platform, multi-currency, high-volume online business.
| Mistake | Consequence | Solution |
|---|---|---|
| Recording net deposits as gross revenue | Understates platform fees as expenses; overstates net income; incorrect tax basis | Record gross sales and fees separately using platform settlement reports |
| Ignoring platform fee categories | Lumps FBA fees, transaction fees, and advertising costs into a single “bank charge” expense line; loses the deductible expense detail | Create separate expense accounts for each fee type in QuickBooks Online or Xero |
| Using the cash basis instead of the accrual basis | Mismatches revenue and expenses across reporting periods; distorts the monthly P&L; inaccurate COGS calculation | Switch to accrual basis accounting; record sales when they occur, not when deposits arrive |
| Skipping inventory reconciliation | Overstates or understates COGS; incorrect gross margin; CRA audit risk on inventory valuation | Perform monthly inventory counts; reconcile physical stock against QuickBooks or Xero records |
| Missing HST registration deadline | CRA assesses HST owing from the date the $30,000 threshold was crossed, plus interest and penalties | Monitor cumulative revenue monthly; register for HST before crossing $30,000 in annual taxable sales |
| Failing to retain platform reports | Cannot substantiate income or deductions during a CRA audit; settlement statements accepted as primary source documents | Download and archive all platform settlement reports, FBA fee statements, and payment processor records monthly |
Recording net deposits as gross revenue is the most common mistake among new e-commerce sellers. Shopify Payments, Amazon, and PayPal all deposit net amounts after deducting fees and refunds. Booking the deposit figure as revenue means your books never reflect true gross sales or true expenses.
Missing the HST registration threshold carries the steepest financial consequence. The Canada Revenue Agency requires Ontario businesses to register for HST once taxable revenues exceed $30,000 in any single calendar quarter or over four consecutive quarters. CRA calculates HST owing from the date the threshold was crossed, regardless of whether the seller was aware of the obligation.
Incorporating your eCommerce business changes your bookkeeping structure, fiscal year-end, and filing requirements. Incorporated sellers face additional compliance obligations that make correct bookkeeping practices even more critical from day one.
Cash vs. Accrual Accounting: Which Method Is Right for Your eCommerce Business?
Accrual basis accounting is the correct method for most e-commerce businesses. Accrual accounting records revenue when a sale occurs and expenses when they are incurred, regardless of when cash moves. Cash basis accounting records revenue only when a deposit arrives and expenses only when payments leave the bank account.
The gap between these two methods creates significant problems for e-commerce sellers. A Shopify sale made on March 28 may not be deposited until April 3. Under the cash basis, that sale appears in April. Under accrual, it appears in March, where it belongs. Monthly profit and loss statements under the cash basis are unreliable for multi-platform sellers with bi-weekly or monthly payout cycles.
| Factor | Cash Basis | Accrual Basis |
|---|---|---|
| Revenue recorded | When the deposit arrives in the bank | When a sale occurs on the platform |
| Expenses recorded | When payment leaves the bank | When an expense is incurred |
| Inventory/COGS | Not tracked accurately | Matched to units sold |
| Monthly P&L accuracy | Low (payout timing distorts results) | High (matches revenue to period) |
| CRA compliance | Acceptable for very small sellers | Required for incorporated businesses |
| Best for | Sole proprietors under $30,000 revenue | Incorporated & Multi-platform sellers |
| Software support | QuickBooks Online, Xero (both support) | QuickBooks Online, Xero (both support) |
Use Cash Basis IF:
You are an unincorporated sole proprietor with annual eCommerce revenue under $30,000 and sell on a single platform with no inventory
Use Accrual Basis IF:
You are incorporated, carry inventory, sell on multiple platforms, exceed $30,000 in annual revenue, or plan to apply for business financing.
Incorporated Ontario eCommerce businesses are required to use accrual basis accounting for corporate tax filing (T2). According to CPA Canada, accrual basis accounting aligns with Canadian generally accepted accounting principles (GAAP) and produces financial statements that accurately reflect business performance.
Sellers who incorporate mid-year often need to restate earlier cash basis records under accrual, which requires professional bookkeeping. Incorporating your eCommerce business changes your bookkeeping structure, fiscal year-end, and filing requirements significantly.
Real Journal Entries for Common eCommerce Transactions
eCommerce bookkeeping requires a separate journal entry for every distinct financial event: the sale, the fee, the refund, the deposit, the inventory purchase, and the tax collected. Booking the net bank deposit as a single entry misses all the details that CRA auditors and your P&L require.
The 8 journal entries below cover the most common eCommerce transactions. Each entry follows accrual basis accounting and applies directly to Ontario sellers using QuickBooks Online or Xero.
| Transaction | Debit | Credit | Amount |
|---|---|---|---|
| Shopify Sale (Gross) | Accounts Receivable | Sales Revenue | $100.00 |
| Platform Fee | Merchant Fee Expense | Accounts Receivable | $2.90 |
| Refund Issued | Sales Returns | Accounts Receivable | $20.00 |
| Net Deposit Received | Cash | Accounts Receivable | $77.10 |
| Inventory Purchase | Inventory | Cash | $500.00 |
| COGS at Sale | Cost of Goods Sold | Inventory | $10.00 |
| HST Collected | Cash/Receivables | Sales Revenue + HST Payable | $113.00 |
| HST Paid on Expense | Software Expense + HST Recoverable | Cash | $56.50 |
Shopify records a sale at gross value when the transaction occurs, not when the payout arrives. This is the accrual basis principle applied to e-commerce: revenue belongs to the period in which the sale happens.
Journal entry: Shopify sale of $100
Represents the amount Shopify owes your business before fees and refunds are deducted.
Records the full gross sale. Both accounts are necessary because the deposit you receive will be less than $100 after Shopify deducts its fees.
Platform Fees and Payment Processor Fees
Platform fees reduce accounts receivable before the net deposit reaches your bank. A $100 sale on the Basic plan via Shopify Payments results in a net deposit of $96.80 (2.9% = $2.90 + $0.30 flat fee = $3.20 total deduction), not $97.10. Amazon deducts referral fees, FBA fulfillment fees, and storage fees directly from settlement payouts.
Merchant Fee Expense is a fully deductible business expense. Recording fees separately from revenue ensures your P&L shows true gross revenue and true operating costs, rather than a single understated net figure.
Customer Refunds and Returns
Refunds reverse a portion of previously recorded revenue. A refund does not create a new expense; it reduces the gross sales figure for the period in which it is processed.
Sales Returns is a contra-revenue account. It sits against Sales Revenue on your P&L, reducing net sales without touching your expense accounts. This separation lets you track refund rates by platform and identify product or fulfillment issues.
Inventory Purchase and Cost of Goods Sold (COGS)
Inventory purchases are recorded as assets, not expenses, at the time of purchase. The cost moves from the Inventory asset account to the Cost of Goods Sold expense account only when a unit is sold.
HST Collected and Paid (Input Tax Credits)
HST collected from Ontario customers is a liability, not revenue. The 13% HST collected on each sale belongs to the CRA and must be remitted on your GST/HST return.
Net Deposit Reconciliation
Net deposit reconciliation matches the actual bank deposit to the individual components recorded in your books: gross sales, minus fees, minus refunds, plus or minus reserves.
The $77.10 deposit represents a $100 gross sale, minus a $2.90 Shopify Payments fee, minus a $20.00 refund. Payout reconciliation is where most errors surface. Shopify, Amazon, and Etsy each arrive on different schedules. Reconciling each report line by line is the foundation of CRA-ready books.
Our eCommerce tax preparation services build directly on accurate payout reconciliation to maximize deductions, optimize HST/GST filings, and ensure cross-border compliance with CRA requirements.
Ontario HST/GST: What Online Sellers Must Know
Ontario eCommerce sellers collect and remit HST at 13% on taxable sales to Ontario customers. HST (Harmonized Sales Tax) combines the federal GST (5%) and Ontario provincial sales tax (8%) into a single remittance to the CRA. Every incorporated Ontario eCommerce business, and every unincorporated seller who crosses the $30,000 revenue threshold, carries HST obligations.
Missing any one obligation triggers CRA penalties, interest charges, and potential audit exposure.
The $30,000 HST Threshold
Ontario eCommerce sellers must register for HST once taxable revenues exceed $30,000 in a single calendar quarter or across four consecutive calendar quarters. Registration is required before making the sale that crosses the threshold, not after the quarter closes.
The Canada Revenue Agency defines this $30,000 figure as the “small supplier threshold.” Sellers below this threshold are not required to collect HST, but may register voluntarily to claim Input Tax Credits on business expenses.
3 Situations Requiring Immediate Registration:
Taxable revenues exceed $30,000 in one calendar quarter (Jan-Mar, Apr-Jun, etc.)
Cumulative taxable revenues across any four consecutive quarters exceed $30,000
Revenue is below $30,000, but the seller wants to reclaim HST paid on business inputs
Digital product sellers and sellers using platforms like Etsy or Shopify who ship exclusively to US customers still face HST obligations on Canadian sales. Platform revenue from all Canadian customers counts toward the $30,000 threshold, regardless of which platform generated the sale.
CRA Penalty Warning: CRA calculates HST owing from the date the threshold was crossed. A seller who crossed $30,000 in August but did not register until November owes HST on all taxable sales from August onward, plus interest on late remittances.
Filing Frequencies and Deadlines
HST filing frequency depends on annual taxable revenue. CRA assigns one of three filing frequencies at registration: annual, quarterly, or monthly. Sellers can request a more frequent filing schedule than CRA assigns.
| Filing Frequency | Annual Revenue Threshold | Filing Deadline |
|---|---|---|
| Annual | Under $1,500,000 | 3 months after the fiscal year-end |
| Quarterly | $1,500,000 to $6,000,000 | 1 month after each quarter-end |
| Monthly | Over $6,000,000 | 1 month after each month-end |
Ontario eCommerce sellers with rapid revenue growth often start on annual filing and transition to quarterly as revenue scales. CRA notifies sellers of filing frequency changes, but sellers are responsible for monitoring their own revenue thresholds.
4 HST filing deadlines apply to Ontario eCommerce businesses:
- Annual filers: HST return due 3 months after fiscal year-end; payment due the same date
- Quarterly filers: HST return and payment due 1 month after each quarter closes
- Monthly filers: HST return and payment due 1 month after each month closes
- New registrants: First HST return covers the period from registration date to the end of the assigned filing period
Input Tax Credits (ITCs) for eCommerce Expenses
Input Tax Credits (ITCs) reduce the net HST remittance on each GST/HST return. ITCs represent the HST your business paid on eligible operating expenses. Ontario eCommerce sellers reclaim ITCs by reporting HST paid on the same return that reports HST collected.
eCommerce businesses claim ITCs on 7 common expense categories:
US-billed platform fees (Amazon seller fees billed in USD from a US entity) do not carry Canadian HST. ITCs apply only to expenses where HST was actually charged and paid. Sellers must retain the original invoice or receipt showing the HST amount to support each ITC claim.
According to the Canada Revenue Agency, ITC claims require supporting documentation retained for a minimum of 6 years from the end of the tax year in which the claim was made.
HST compliance checklist for Ontario eCommerce sellers:
- Register for HST before crossing $30,000 in taxable revenue
- Collect 13% HST on all taxable sales to Ontario customers
- Track HST collected in a dedicated HST Payable liability account
- Track HST paid on expenses in a dedicated HST Recoverable asset account
- File GST/HST returns on your assigned frequency (annual, quarterly, or monthly)
- Retain all invoices, receipts, and platform reports for 6 years
- Reclaim eligible ITCs on every return to reduce net remittance
Selling Across Borders: US Sales Tax & Multi-Currency Accounting
Ontario eCommerce sellers shipping products to US customers face two additional compliance layers: US sales tax obligations and multi-currency accounting requirements. These obligations exist independently of Canadian HST. Collecting and remitting Canadian HST correctly does not satisfy US sales tax requirements, and vice versa.
Cross-border eCommerce accounting covers 3 distinct areas: US economic nexus thresholds by state, USD transaction recording in CAD books, and foreign exchange gain or loss reporting for CRA purposes.
US Sales Tax Nexus Thresholds
Economic nexus is the obligation to collect and remit US state sales tax based on sales volume or transaction count in a given state, regardless of physical presence. Every US state that imposes sales tax has established its own economic nexus threshold following the 2018 US Supreme Court decision in South Dakota v. Wayfair.
Ontario eCommerce sellers trigger economic nexus in a US state when sales to customers in that state exceed the state’s threshold within 12 months.
Economic nexus thresholds for the 5 highest-volume US states for Canadian eCommerce sellers:
| US State | Revenue Threshold | Transaction Threshold | Sales Tax Rate |
|---|---|---|---|
| California | USD $500,000 | No transaction threshold | 7.25% (base) + local |
| Texas | USD $500,000 | No transaction threshold | 6.25% (base) + local |
| New York | USD $500,000 | 100 transactions | 4% (base) + local |
| Florida | USD $100,000 | 200 transactions | 6.0% |
| Washington | USD $100,000 | No transaction threshold | 6.5% (base) + local |
Most US states set their economic nexus threshold at USD $100,000 in annual sales or 200 transactions, whichever comes first. Ontario sellers on Amazon FBA face nexus exposure in every state where Amazon stores its inventory in a fulfillment center, regardless of the seller’s own sales volume in that state.
3 US sales tax obligations apply once nexus is established:
- Registration: Register for a sales tax permit in each nexus state before collecting tax
- Collection: Charge the correct combined state and local sales tax rate on each order shipped to that state
- Remittance: File state sales tax returns and remit collected tax on the state’s assigned schedule (monthly, quarterly, or annually)
Amazon FBA sellers face the most complex nexus exposure among Ontario eCommerce sellers. Amazon’s fulfillment network spans over 200 US fulfillment centers across more than 40 states. Storing inventory in an Amazon fulfillment center creates a physical nexus in that state, separate from and in addition to economic nexus thresholds.
According to the Tax Foundation, 45 US states and the District of Columbia impose state sales tax. Ontario sellers shipping to all 50 states face potential nexus obligations in up to 45 jurisdictions simultaneously.
Handling USD Bank Accounts and Exchange Rates
USD transactions require conversion to CAD in your Canadian accounting records. CRA requires Ontario businesses to report all income and expenses in Canadian dollars, using the Bank of Canada exchange rate on the date of each transaction.
3 exchange rate methods apply to Ontario eCommerce businesses:
- Transaction-date rate: The Bank of Canada noon rate on the exact date of each transaction; the most accurate method and the one CRA prefers for audit purposes
- Average annual rate: The Bank of Canada average rate for the full calendar year; acceptable for businesses with low USD transaction volume
- Average monthly rate: The Bank of Canada average rate for the calendar month; a practical middle ground for sellers with moderate monthly USD volume
QuickBooks Online and Xero both support multi-currency accounting. QuickBooks Online automatically pulls Bank of Canada exchange rates for USD transactions when the multi-currency feature is enabled. Xero supports over 160 currencies and updates exchange rates daily.
Foreign exchange gain or loss arises when the CAD value of a USD receivable changes between the invoice date and the payment date. CRA requires Ontario businesses to report foreign exchange gains as income and deduct foreign exchange losses as business expenses.
4 bookkeeping requirements apply to Ontario sellers with USD bank accounts:
Maintain a separate USD bank account in QuickBooks Online or Xero, distinct from CAD operating accounts
Record each USD transaction at the Bank of Canada rate on the transaction date
Reconcile the USD bank account separately from the CAD bank account each month
Calculate and record foreign exchange gain or loss at the end of each fiscal year
| Currency Scenario | CRA Requirement | Bookkeeping Action |
|---|---|---|
| USD sale to a US customer | Report in CAD at transaction-date rate | Convert at the Bank of Canada noon rate on the sale date |
| USD Amazon payout | Report in CAD at the deposit date rate | Convert at the Bank of Canada noon rate on the deposit date |
| USD supplier payment | Report in CAD at the payment date rate | Convert at the Bank of Canada noon rate on the payment date |
| Year-end USD balance | Report foreign exchange gain or loss | Compare the year-end CAD equivalent to the opening balance |
CRA Audit-Proof Your eCommerce Books
CRA audits of eCommerce businesses focus on 3 areas: unreported income from platform payouts, incorrect HST remittances, and unsupported expense deductions.
Ontario online sellers face higher audit exposure than traditional retailers because multi-platform income is harder to reconcile and easier to misreport, intentionally or otherwise.
Audit-proofing eCommerce books requires a proactive documentation framework, not a reactive response to a CRA letter. The sections below cover record retention rules, documentation standards, and the specific red flags that trigger CRA reviews for online sellers.
The 6-Year Record Retention Rule
CRA requires Ontario businesses to retain all financial records for a minimum of 6 years from the end of the last tax year to which the records relate. For eCommerce sellers, this 6-year obligation covers every document that supports income, expenses, and tax remittances reported on filed returns.
The Canada Revenue Agency defines “records” broadly for eCommerce businesses. Platform settlement reports, payment processor statements, and FBA inventory reports all qualify as primary source documents under CRA guidelines.
eCommerce sellers retain 8 categories of records for 6 years:
Shopify payout summaries, Amazon bi-weekly settlement statements, Etsy payment deposits, eBay managed payments reports
Stripe, PayPal, and Square transaction histories with gross sales, fees, and refunds itemized
All CAD and USD operating account statements showing deposits and withdrawals
Purchase invoices, FBA inventory reports, stocktake records, and shrinkage documentation
All supplier invoices, shipping receipts, software subscription confirmations, and advertising invoices showing HST paid
GST/HST returns filed, HST collected by period, ITC claims with supporting invoices, and CRA correspondence
If the business employs staff, all payroll records, including T4 slips and remittance confirmations
T2 corporate tax returns, financial statements, and shareholder loan documentation for incorporated sellers
Documentation Standards That Satisfy CRA Auditors
CRA auditors verify eCommerce income by cross-referencing 3 primary sources: platform settlement reports, payment processor records, and bank statements. All 3 must reconcile to the same gross revenue figure reported on the T2 corporate tax return and GST/HST returns.
A CRA-ready eCommerce documentation standard covers 5 requirements:
Shopify sellers export monthly order reports and payout summaries directly from the Shopify admin. Amazon sellers download bi-weekly settlement reports and monthly FBA inventory reports from Seller Central. Etsy sellers export monthly payment deposits and fee statements from the Etsy seller dashboard. Each report requires archiving in its original format, not just the summarized figures entered into QuickBooks or Xero.
Red Flags That Trigger a CRA Review for eCommerce Sellers
CRA identifies eCommerce audit candidates using 6 risk indicators that appear in filed tax returns, HST returns, and third-party platform data. Ontario online sellers who trigger multiple indicators in the same tax year face significantly higher audit probability.
CRA’s third-party data program obtains transaction data directly from payment processors and e-commerce platforms operating in Canada. Shopify, PayPal, and Stripe provide CRA with transaction data for Canadian sellers upon request. Ontario eCommerce sellers cannot rely on unreported platform income going undetected.
CRA audit-proofing checklist for Ontario eCommerce sellers:
Proactive audit defense requires monthly reconciliation, not year-end cleanup.
- Download and archive all platform settlement reports monthly
- Reconcile every bank deposit to its corresponding platform settlement report
- Maintain itemized expense records with HST amounts for all deductions
- Apply a consistent inventory costing method (FIFO or weighted average) every year
- File GST/HST returns on time and remit correct amounts on your assigned frequency
- Retain all records digitally for a minimum of 6 years from the end of each tax year
- Report all platform income, including USD sales converted to CAD at Bank of Canada rates
- Register for HST before crossing $30,000 in taxable revenue
Our CRA audit support for eCommerce sellers provides professional representation if CRA initiates a review, and proactive audit-proofing as part of a monthly bookkeeping engagement.
Platform-by-Platform: Bookkeeping for Amazon, Shopify, Etsy & More
eCommerce platforms generate different financial data structures, fee models, and settlement schedules. Bookkeeping for a Shopify store requires different reconciliation processes than bookkeeping for an Amazon FBA business. Each platform demands platform-specific knowledge to record transactions correctly and produce CRA-ready books.
Ontario eCommerce sellers operating across multiple platforms face the combined complexity of all platforms simultaneously. The 7 platform guides below cover the specific bookkeeping requirements, common errors, and reconciliation processes for each major selling channel.
Amazon FBA Bookkeeping
Complexity: HighAmazon FBA bookkeeping covers 4 distinct financial layers: referral fees, FBA fulfillment fees, inventory management across multiple fulfillment centers, and multi-state US sales tax nexus.
Amazon’s bi-weekly settlement reports bundle all 4 layers into a single net deposit, requiring line-by-line reconciliation against Seller Central reports.
Shopify Bookkeeping Services
Complexity: MediumShopify bookkeeping requires seamless integration between the Shopify store, payment processors (Shopify Payments, Stripe, PayPal), and accounting software. Each payment processor generates a separate payout on its own schedule.
Shopify store owners need payout reconciliation across multiple processors, accurate COGS tracking, and HST collection setup for Ontario customers.
Etsy Seller Bookkeeping
Complexity: MediumEtsy bookkeeping covers listing fees, transaction fees (6.5%), offsite advertising, and multi-currency payouts for Canadian sellers. Etsy deposits net payments after deducting fees, requiring gross-up entries to record true revenue.
eBay Seller Bookkeeping
Complexity: MediumeBay bookkeeping covers final value fees (3% to 15%), promoted listing costs, managed payments settlement reconciliation, and cross-border sales to US customers. eBay’s managed payments system consolidates all proceeds into a single payout.
WooCommerce Accounting
Complexity: HighWooCommerce accounting requires direct integration between WordPress, payment gateways (Stripe, PayPal, Square), and accounting software. It does not generate native settlement reports like Shopify.
Dropshipping Bookkeeping
Complexity: LowDropshipping presents a unique COGS challenge: the seller pays suppliers per order rather than holding inventory. Inventory asset accounts are not used because no physical stock is held.
Bookkeeping for Retail (Omnichannel)
Complexity: ExpertOmnichannel retail bookkeeping unifies inventory, sales, and financial reporting across online and physical stores. Ontario retailers face inventory valuation challenges: the same SKU exists in both channels and must be tracked as a single asset.
From Our Practice: 17 Years of eCommerce Bookkeeping Experience
Acctax has provided eCommerce bookkeeping services to Ontario online sellers since 2007. Across 17 years, our team has worked with Shopify store owners, Amazon FBA sellers, Etsy creators, multi-channel retailers, and dropshipping businesses at every stage of growth.
The 2 case studies below are drawn from real client engagements, anonymized to protect confidentiality.
The Amazon Seller Who Saved $12,000 in Missed ITCs
An Ontario Amazon FBA seller approached Acctax after 2 years of self-managed bookkeeping. The seller operated a mid-sized private label business generating approximately $480,000 in annual gross revenue across Amazon Canada and Amazon US. Books were maintained on a cash basis using a single spreadsheet, with Amazon bi-weekly deposits recorded as gross revenue figures.
The seller had never claimed Input Tax Credits on eCommerce operating expenses. Platform subscription fees, software tools (QuickBooks Online, A2X), shipping supplies, and professional services had all been recorded as net expenses, with no HST amounts separated and tracked. Two full tax years of ITC claims sat unclaimed.
The Acctax 4-Step Process:
- Bookkeeping cleanup: Restated 24 months of cash basis records under accrual basis accounting, separating gross Amazon sales, fees, and advertising into correct accounts.
- ITC identification: Reviewed every expense invoice from the past 2 years, identifying HST paid on eligible Canadian-billed expenses.
- HST return amendments: Filed amended GST/HST returns for both tax years, claiming $12,000 in previously unclaimed ITCs.
- Systems setup: Implemented QuickBooks Online with A2X integration for automated settlement import and monthly reconciliation.
CRA processed the amended returns and issued a $12,000 refund within 8 weeks. The seller’s ongoing monthly bookkeeping cost is fully offset by ITC recoveries identified each quarter.
Every dollar of HST paid on eligible Canadian business expenses is recoverable. Sellers who record net expenses without separating HST amounts leave ITC claims on the table permanently once the 4-year amendment window closes.
The Shopify Store That Faced a CRA Audit and Won
A Kitchener-based Shopify seller received a CRA audit notification 14 months after filing their second corporate T2 return. The business generated $320,000 in annual Shopify revenue across 3 product categories, with additional sales through Etsy and a small wholesale channel. CRA requested 3 years of financial records within 30 days.
The seller’s previous bookkeeper had recorded Shopify net deposits as gross revenue. Platform fees and processing charges had never been recorded as separate line items. Reported gross revenue was $43,000 lower than the sum of Shopify gross order values—a discrepancy flagged by CRA’s third-party data program.
The Acctax 3-Step Process:
- Records reconstruction: Reconciled 36 months of Shopify reports, Etsy deposits, and wholesale invoices against bank statements, restating gross revenue correctly.
- CRA correspondence: Prepared a complete audit response package, explaining the bookkeeping methodology change from net deposit recording to gross revenue recording.
- HST verification: Reconciled 3 years of HST returns against restated revenue, confirming correct collection with no additional tax owing.
CRA accepted the audit response package in full. No penalties were assessed. The revenue discrepancy was fully explained by the fee separation methodology. The audit closed within 11 weeks.
A CRA audit is manageable with complete, reconciled records. Monthly reconciliation, maintained consistently, is the only reliable audit defense against platform data discrepancies.
Software and Tools for eCommerce Bookkeeping
eCommerce bookkeeping software falls into 2 categories: core accounting platforms and integration apps. Core accounting platforms (QuickBooks Online, Xero) store the general ledger, produce financial reports, and manage HST filings. Integration apps (A2X, Dext Commerce, Plooto) connect eCommerce platforms to the core accounting system, automating data entry and reducing manual reconciliation work.
QuickBooks Online vs. Xero for eCommerce
QuickBooks Online and Xero are the 2 leading cloud accounting platforms for Ontario eCommerce businesses. Both support multi-currency accounting, HST filing, inventory tracking, and integration with eCommerce apps.
| Factor | QuickBooks Online | Xero |
|---|---|---|
| Starting Price (CAD) | From $25/month (Easy Start) | From $20/month (Starter) |
| Multi-Currency Support | Available on Plus and Advanced plans | Available on all plans |
| Inventory Tracking | Available on Plus and Advanced plans | Available on all plans via app |
| HST Filing | Built-in GST/HST return preparation | Built-in GST/HST return preparation |
| Bank Feeds | Supports major Canadian banks | Supports major Canadian banks |
| App Integrations | A2X, Dext Commerce, Shopify, Amazon | A2X, Dext Commerce, Shopify, Amazon |
| Reporting Depth | Strong; 65+ built-in reports | Strong, customizable report builder |
| User Limit | Varies by plan (1 to unlimited) | Unlimited users on all plans |
Suits Ontario eCommerce sellers with complex inventory management needs. The Plus and Advanced plans include built-in inventory tracking with FIFO costing, purchase order management, and COGS calculation.
Suits Ontario eCommerce sellers with multiple team members, international sales across many currencies, and a preference for a flexible app ecosystem. Xero’s unlimited user model ensures collaborative access.
According to Xero’s 2023 Small Business Insights report, Canadian small businesses using cloud accounting software reconcile books 3 times faster than businesses using desktop or spreadsheet-based systems.
Essential Apps: A2X, Dext Commerce, Plooto
A2X
Automates the import of platform settlement reports (Shopify, Amazon, Etsy, eBay, Walmart). Each period imports as a mapped journal entry with gross sales, fees, and refunds recorded as separate line items. A2X pricing starts at USD $29/month.
Dext Commerce
Captures and categorizes receipts and supplier invoices. Extracts supplier name, date, amount, and HST automatically. Satisfies CRA digital record retention requirements. Pricing starts at approximately $25/month CAD.
Plooto
Automates accounts payable. Processes CAD and USD supplier payments directly from QBO or Xero, matching payments to bills automatically. Pricing starts at $25/month CAD.
Recommended Software Stack
| Business Stage | Core Platform | Integration Apps | Monthly Cost (Approx. CAD) |
|---|---|---|---|
| Early Stage (<$100K) | QuickBooks Online Simple Start | A2X (single platform) | $40–$60/month |
| Growth Stage ($100K–$500K) | QuickBooks Online Plus or Xero | A2X + Dext Commerce | $80–$120/month |
| Scale Stage (>$500K) | QuickBooks Online Advanced or Xero | A2X + Dext + Plooto | $130–$200/month |
When to DIY vs. Hire an eCommerce Bookkeeper
DIY bookkeeping suits Ontario eCommerce sellers who meet all 5 conditions: single platform, under 100 orders per month, no physical inventory, revenue below $30,000, and incorporated less than 1 year. eCommerce bookkeeping becomes unmanageable and financially risky as platform count, transaction volume, and compliance obligations grow.
The DIY Threshold
Appropriate when all 5 conditions apply simultaneously:
- Single platform: Selling on one platform only (Shopify, Etsy, or Amazon) with a single payment processor.
- Low volume: Fewer than 100 orders per month across all channels.
- No inventory: Dropshipping model or digital products only; no physical stock to value.
- Below HST threshold: Annual taxable revenue below $30,000.
- New Corporation: No prior T2 returns filed; no bookkeeping backlog.
Professional Required
Hire a professional if any ONE condition applies:
- Annual revenue exceeds $30,000 (HST registration required).
- Selling on 2 or more platforms with separate payout schedules.
- Holding physical inventory requiring COGS tracking and valuation.
- Receiving USD payments requiring CAD conversion and FX reporting.
- Behind on bookkeeping by 3 or more months.
- Facing a CRA audit, HST review, or late filing notice.
- Applying for financing requiring reviewed financial statements.
The Cost Comparison: DIY vs. Professional Bookkeeping
| Factor | DIY Bookkeeping | Professional Bookkeeping |
|---|---|---|
| Monthly time cost | 8–20 hours/month for multi-platform sellers | 0 hours (fully managed) |
| Software setup | Self-configured; errors common | Correctly configured from the start |
| Reconciliation | High error rate without platform-specific knowledge | Platform-specific reconciliation expertise |
| HST compliance | High risk of missed registration or incorrect remittance | CRA-compliant filings on schedule |
| Audit readiness | Low without structured documentation | Audit-ready records maintained monthly |
| Year-end tax | Requires significant cleanup before filing | Clean books delivered to tax preparer |
| ITC recovery | Commonly missed without HST tracking setup | Maximized on every return |
| Monthly cost | $40–$200/month (software only) | Varies by volume and services |
Time cost is the most underestimated DIY factor. A multi-platform seller on Shopify, Amazon, and Etsy spends 15 to 20 hours per month on bookkeeping. At an opportunity cost of $50/hour, that represents $750 to $1,000 in foregone business activity every month.
The break-even point occurs when the combined value of time saved, ITC recoveries, and penalty avoidance exceeds the fee. For sellers over $100,000 in revenue, professional bookkeeping delivers positive ROI from month one.
4 signs that DIY bookkeeping is creating financial risk:
Get Ontario eCommerce Bookkeeping That’s CRA-Ready
Acctax provides eCommerce bookkeeping services to Ontario online sellers across Shopify, Amazon FBA, Etsy, eBay, WooCommerce, and multi-channel operations. Our team has delivered accurate, CRA-compliant books to Ontario eCommerce businesses for 17 years.
Ontario eCommerce sellers choose Acctax for 4 reasons:
We reconcile Shopify payouts, Amazon settlements, Etsy deposits, and eBay managed payments with knowledge that general bookkeepers lack.
Every engagement includes monthly reconciliation and HST compliance review, producing books that satisfy auditors without reactive cleanup.
We manage registration, filing, and ITC recovery, including cross-border compliance for US sales tax obligations.
Working with Ontario sellers since 2007 across every major platform and every stage of business growth.
Our eCommerce Bookkeeping Services
Delivered as a comprehensive monthly managed service.
Monthly Bookkeeping Includes:
- Platform reconciliation: Shopify, Amazon, Etsy, eBay, and WooCommerce reports reconciled against bank statements.
- Payout reconciliation: Matching every payout to deposits and resolving variances for CRA audit trails.
- COGS & Inventory: FIFO or weighted average costing with year-end inventory valuation for T2 filing.
- HST Management: Tracking in dedicated accounts and filing on your assigned CRA frequency.
- Multi-currency: USD to CAD conversion at Bank of Canada rates with FX gain/loss reporting.
- Financial Reporting: P&L, Balance Sheets, and Cash Flow reports delivered within 10 business days.
- Software Management: QBO/Xero setup, A2X integration, and Dext Commerce expense capture.
- Year-end Prep: Clean, reconciled books delivered to your tax preparer or prepared directly by Acctax.
Book a Free Consultation with Our Team
Acctax serves Ontario eCommerce sellers across Kitchener, Waterloo, Cambridge, and the broader Ontario region. Our bookkeeping engagements are fully remote, with secure document sharing, cloud-based accounting access, and monthly reporting delivered digitally.
Free Consultation
A 30-minute call to assess your current books, identify compliance gaps, and recommend the correct service level for your business.
Cleanup Bookkeeping
A fixed-fee engagement to restate and reconcile historical records for sellers who are behind or preparing for a CRA audit.
Monthly Managed
An ongoing engagement covering all platform reconciliations, HST management, financial reporting, and year-end preparation.
Kitchener
Sellers trust Acctax to keep books CRA-ready while businesses grow, focusing on HST compliance and startup scalability.
Waterloo
Innovators and Shopify partners rely on bookkeeping that scales, supporting financing applications and data-driven decisions.
Cambridge
From established retailers to Amazon FBA entrepreneurs, we deliver local expertise with platform-specific knowledge.