Case study — E-commerce

From Financial Chaos to Clarity:

How a Shopify Retailer Finally Understood Their Own Business

Some business owners come to us frustrated. Some come panicked. This client came with books so deeply broken that he had never — not once since launching — been able to look at a P&L and understand whether he was actually making money. That changed in a single Zoom call.

Industry

E-commerce — Shopify retail

Timeline

Full cleanup in under 2 months

Identity

Anonymized at client's request

< 2 months

To fully reconstruct years of broken records

12 accounts

PayPal currency accounts reconciled for the first time

$500,000

In phantom foreign currency entries corrected to $0

01 — The situation

A business flying completely blind

When this client came to PCS, he had been running his Shopify business for years. Revenue was coming in. Orders were shipping. The business looked active from the outside.

But inside the books? It was one of the most complex messes we had seen. His previous accountant had been managing his file — but managing it incorrectly in ways that compounded over time into a serious financial distortion.

He had never once been able to look at his own Profit & Loss report and have it make sense. Not once. In years of business.

02 — What we found

The full diagnosis

1.

Shopify revenue recorded as lump-sum deposits

Every Shopify payout had been recorded as a single revenue entry — one of the most common and damaging e-commerce bookkeeping errors. A payout is a net figure after fees, refunds, and adjustments. Recording it as gross revenue overstates income, understates expenses, and makes margin analysis meaningless.

2.

12 PayPal currency accounts — never reconciled

The previous accountant applied a flat 1:1 exchange rate across all foreign currency transactions. The result: single transactions appeared at values up to $500,000 CAD. Revenues were massively overstated. The balance sheet was fictional.

3.

Wise USD and CAD accounts — completely ignored

Both Wise accounts used for supplier payments and international transfers had never been reconciled in QBO. Transactions were simply not in the books.

4.

COGS and inventory — entirely missing

No cost of goods sold tracking. No inventory valuation. The Gross Margin figure in his P&L was entirely fictional. He had no idea which products were profitable and which were quietly losing money on every sale.

5.

Sales tax — never tracked, never remitted

GST/HST obligations had not been tracked or remitted correctly. Input tax credits on business purchases had not been claimed — creating both a tax exposure and a missed recovery opportunity.

6.

Transactions journalized instead of properly recorded

Rather than using QBO's proper workflows, the previous accountant had been posting manual journal entries — bypassing the audit trail and making it nearly impossible to trace the source of any figure in the financials.

Book Now

03 — The work

What PCS did

We began with a complete diagnostic review and presented the client with a clear scope before a single change was made. No surprises. Full transparency on the work ahead.

Foreign currency reconstruction

every PayPal and Wise transaction reprocessed using actual exchange rates. The $500,000 phantom entries corrected.

Shopify revenue reconstruction

all payouts broken into correct components: gross sales, platform fees, processing fees, refunds, and net revenue.

A2X integration

automated Shopify reconciliation set up going forward, permanently eliminating the lump-sum problem.

COGS and inventory setup

proper structure built in QBO and product costs applied, giving the client a true gross margin figure for the first time.

GST/HST catch-up

correct sales tax obligations identified, catch-up filings prepared, and missed input tax credits recovered.

Chart of accounts restructure

rebuilt to properly separate revenue streams, cost categories, and currency accounts.

Book Now

04 — The moment

When everything changed

When the cleanup was complete, we scheduled a Zoom call to walk the client through his financials.
We opened his Profit & Loss report together.

Since I started this business, this is the first time I've been able to look at a Profit & Loss and actually understand it. The revenue makes sense. The costs make sense. I can finally see if I'm profitable.

This is what we mean when we say clarity changes everything. It is not an abstract promise. It is a specific moment — the first time a business owner looks at their own numbers and sees the truth.