Ecommerce Bookkeeping Checklist

Ecommerce bookkeeping checklist becomes expensive when the business only notices the weakness under deadline pressure. In South Africa that usually means a problem with payment gateway reconciliations, refunds, and gross-margin review shows up just as Shopify questions, management decisions, or month-end sign-off need a clean answer.

Ecommerce bookkeeping should tell the financial truth about an online business, not just record busy trading activity.

So the checklist needs to review the full route from the storefront to the bank.

The six checkpoints every ecommerce month should cover

1. Store sales report

Confirm the gross sales, discounts, taxes, and returns shown by the platform.

2. Payment gateway statement

Review how the store activity became merchant settlements, fees, chargebacks, and payout timing differences.

3. Bank receipts

Confirm what actually landed in the bank and whether it matches the net payouts expected.

4. Refund and return handling

Make sure the commercial impact of returns and refunds is visible in the bookkeeping.

5. Fee analysis

Merchant, delivery, app, and platform costs should be separated well enough to explain margin movement.

6. Stock and cost-of-sales review

Where stock matters, the bookkeeping should at least support a meaningful review of stock movement and gross margin.

A working ecommerce month-end table

That table is often enough to expose weak online-bookkeeping habits quickly.

The payout reconciliation checklist

Every month, verify:

1. total sales per platform
2. total gateway fees
3. total refunds and reversals
4. total net payouts
5. actual bank receipts

If those five numbers do not tell a coherent story, management should not trust the margin yet.

The fee and margin checklist

Look for:

• merchant fees recorded in the wrong category
• delivery costs blended into sales adjustments
• app and platform charges buried in general overhead
• refunds that are visible operationally but vague in the books

These are the quiet ways ecommerce margin gets distorted.

The stock-control checklist

Bookkeeping does not replace stock management, but it should support better stock review.

Ask:

• are stock-related purchases easy to identify?
• are cost-of-sales figures stable enough to explain?
• do gross margin swings line up with real operational changes?
• are shrinkage or damaged goods visible anywhere in the finance discussion?

If not, the month-end finance story is incomplete.

The exception log template

The point is not perfection. The point is making the unknowns visible before management decisions are made.

Store-to-bank reconciliation detail

Ecommerce bookkeeping should avoid treating bank deposits as the sales record. The bank only shows what settled after the platform, gateway, refunds, fees, chargebacks, and timing differences have already changed the number.

A cleaner monthly reconciliation follows this order:

1. start with gross sales from the store platform
2. separate discounts, refunds, and returns
3. agree gateway activity to the payout statement
4. identify merchant fees and chargebacks
5. match net payouts to bank receipts
6. record timing differences that will settle after month-end

This order helps management understand whether a payout difference is a bookkeeping error, a gateway timing item, or a real commercial issue.

VAT checks for online stores

VAT becomes harder when online sales include different product types, delivery fees, marketplace transactions, or mixed local and export activity. The bookkeeping should not leave those questions until the VAT201 deadline.

Review monthly:

If VAT support is weak, use the VAT reconciliation checklist before the next filing cycle. Online trading can create many small VAT differences that become hard to explain if they are left for months.

Stock and margin evidence

Stock does not need to be perfect for bookkeeping to be useful, but the month-end should give management a credible margin story. If the business sells products, the bookkeeping should connect purchasing, sales, stock movement, and gross margin.

Ask:

• are supplier purchases classified by product or stock category where useful?
• are damaged goods, shrinkage, and write-offs visible?
• do sales spikes agree to stock movement?
• do refunds distort margin reporting?
• are freight, packaging, and marketplace fees separated well enough?

The goal is not a full inventory system inside the ledger. The goal is to stop bookkeeping from hiding the reasons margin moved.

Marketplace and gateway complexity

Some ecommerce businesses trade through more than one channel. Shopify, WooCommerce, Takealot, PayFast, Paystack, Stripe, and bank deposits may each tell a slightly different story.

Where there are multiple channels, create a channel summary:

This keeps the bookkeeping from blending separate trading routes into one vague revenue number. It also makes it easier to compare service scope against the bookkeeping package comparison.

Monthly ecommerce review rhythm

The ecommerce close should happen while trading patterns are still fresh. If the review waits too long, refund spikes, fee changes, stock shortages, and payout timing differences become harder to explain.

Start with the store report, then review gateway statements, bank receipts, refunds, fees, and stock-related costs. Any unexplained difference should be recorded with an owner and a target resolution date. That prevents the same payout difference from rolling into the next month.

Management should also look for commercial signals, not only accounting errors. A rise in refunds, a change in merchant fees, a delivery-cost spike, or a margin swing may point to operational issues that the bookkeeping is simply making visible.

The goal is a month-end that helps the business adjust trading decisions before another full cycle passes.

When automation needs review

Online stores often rely on integrations between the store, gateway, bank, and accounting system. Those integrations save time, but they still need review.

Check whether imported sales are duplicated, whether refunds reverse correctly, whether gateway fees are split out, and whether payout timing differences are treated consistently. Also confirm that VAT settings still match the business's current registration status and product mix.

Automation should reduce manual capture, not remove review. If an integration posts the wrong pattern for several months, the cleanup can be more expensive than manual checking would have been.

Keep a short change log when integration settings are changed. Record the date, the setting changed, the person who approved it, and the first month reviewed after the change. That makes later payout or VAT differences easier to trace.

What this checklist should improve

Used properly, it should improve:

• payout confidence
• fee visibility
• margin clarity
• month-end decision quality

So this page supports ecommerce bookkeeping services. The service explains the delivery model; this page gives the working control points.

When the checklist shows you need specialist support

If the business cannot reliably connect sales, payouts, refunds, and the bank, the bookkeeping process is too weak for the trading model.

That usually means the business needs stronger monthly control, not just another report export.

The review should focus on the few numbers that drive trust: gross sales, refunds, fees, payouts, bank receipts, and margin. If those cannot be reconciled, the store is trading faster than the finance process can explain.

Use this page with

• ecommerce bookkeeping services
• bookkeeping documents checklist
• month-end bookkeeping checklist
• ecommerce bookkeeping mistakes that kill margin

The better the checklist works, the easier it becomes to explain where gross margin is really going each month.