Shopify & WooCommerce Bookkeeping — How to Reconcile Your Online Store in South Africa

Running an e-commerce business in South Africa is exciting — but the bookkeeping behind it is more complex than most store owners realise. Between payment gateway fees, refunds, chargebacks, inventory movements, and VAT obligations, there are multiple layers where things can go wrong — and often do.

This guide is written for South African Shopify and WooCommerce store owners who want to understand how to keep clean books, stay SARS compliant, and actually know whether their store is profitable.

Why E-commerce Bookkeeping Is Uniquely Tricky

Unlike a traditional business that invoices clients and receives payment directly, an online store typically processes hundreds or thousands of small transactions through a payment gateway. The money that arrives in your bank account is almost never the same as your gross sales — it's net of gateway fees, sometimes net of refunds, and often delayed by payout cycles.

This creates a reconciliation challenge: matching what Shopify or WooCommerce reports as sales to what actually lands in your bank account. Get this wrong and your books won't balance — and you'll likely be under- or over-declaring VAT.

Step 1: Understand Your Payment Gateway Flow

The first thing to map out is exactly how money flows from a customer's purchase to your bank account. A typical South African e-commerce flow looks like this:

1. Customer pays R1,000 on your Shopify store
2. Payment gateway (e.g. PayFast, Peach Payments, PayGate) processes the payment
3. Gateway deducts its fee (typically 2-3.5%) — say R30
4. Gateway pays out R970 to your bank account, usually every 1-2 days or weekly

Your books need to record the full R1,000 as revenue, and the R30 as a bank charge or payment processing fee. Many store owners only record the R970 — which understates revenue and can cause VAT miscalculations.

Step 2: VAT on Online Sales

If your online store's turnover exceeds R1 million per year, you must register for VAT and charge 15% VAT on sales to South African customers. This is non-negotiable — SARS does not have a special exemption for online businesses.

VAT on Shopify

Shopify allows you to configure tax settings for South Africa. Once registered for VAT, you should set Shopify to charge 15% VAT on all sales to South African addresses. Your Shopify reports can then provide VAT-inclusive and VAT-exclusive sales figures for your VAT201 submissions.

International Sales

If you sell to customers outside South Africa, those sales are generally zero-rated for VAT purposes — meaning you charge 0% VAT. However, you still need to report them correctly on your VAT return. Keep records of where each order was shipped to.

Step 3: Handling Refunds and Returns

Refunds are a normal part of e-commerce but need careful bookkeeping treatment. When you issue a refund, the original sale should be reversed — including the VAT component. Many store owners simply record refunds as expenses, which is incorrect and overstates your costs.

In your accounting software, refunds should be processed as credit notes against the original sales invoice (or as a negative sales entry), not as separate expense transactions.

Step 4: Inventory and Cost of Goods Sold

Knowing your gross profit — not just your revenue — is essential for any product-based business. This requires tracking your inventory properly:

• Opening stock value at the start of each period
• Purchases during the period (at cost)
• Closing stock value at the end of each period
• Cost of Goods Sold (COGS) = Opening stock + Purchases − Closing stock

Without proper COGS tracking, you won't know your true gross margin — and you can't make good decisions about pricing, promotions, or product mix.

Step 5: Reconciling Shopify/WooCommerce to Your Bank Statement

Every month, your accountant should perform a reconciliation that confirms:

• Total sales per your e-commerce platform match total sales in your accounting software
• Total gateway payouts received in your bank account are fully accounted for
• Gateway fees are correctly recorded as expenses
• Refunds are correctly reversed against sales
• Opening and closing stock figures are updated

This reconciliation is your financial health check for the period. If it doesn't balance, there's a bookkeeping error somewhere that needs to be found.

Tools That Help

Both Shopify and WooCommerce have integrations with Xero and QuickBooks that can automate much of this process. When set up correctly, sales, refunds, and fees can be imported automatically — reducing manual data entry and the risk of errors. However, these integrations still need to be configured correctly and reviewed regularly.

How TrueBalance Helps E-commerce Businesses

We set up and manage the full bookkeeping function for South African online stores — from configuring your accounting software to integrate with Shopify or WooCommerce, to monthly reconciliations, VAT submissions, and management accounts that show your true profitability. We speak e-commerce fluently.