Ecommerce Bookkeeping

Ecommerce Bookkeeping

Ecommerce bookkeeping that opens up every marketplace payout

What reaches your bank from a marketplace is what was left after fees, refunds, shipping and ad charges were taken out. I record the sales behind each payout in full, book every deduction where it belongs and match the result to the deposit, so your margin is real.

  • Payouts broken into their parts
  • Fees and refunds visible
  • Inventory cost separated
Shop owner wrapping a customer order
Payout explainedsales, fees and refunds

Why deposits are not sales

An online seller who books bank deposits as income is recording a number the marketplace has already reduced. Sales look smaller than they were, selling fees and advertising never show as costs, and refunds vanish. The profit total may even come out close, but nothing above it can be trusted or compared.

It also causes trouble with tax. Reported sales on the platform’s year end form will not match the books, and someone has to explain the gap.

What I track in your books

Settlement or payout report

The marketplace’s own statement for each payout, listing sales, fees, refunds and other charges.

Gross sales

The full value customers paid, before the platform took anything.

Selling and payment fees

Commissions, payment processing and subscription charges, each on its own expense line.

Refunds and returns

Money returned to customers, recorded against sales so net revenue is right.

Cost of goods sold

What you paid for the stock that was sold, separated from stock still on the shelf.

Sales tax collected by the marketplace

Tax the platform collects and pays for you, kept out of your income.

How the work runs

  1. Chart of accounts for online selling

    Sales by channel, a fee account per platform, refunds, shipping and cost of goods.

  2. Clearing account per channel

    Each platform gets a holding account so payouts can be matched exactly.

  3. Payouts recorded from reports

    Every payout is entered from its settlement report with sales, fees and refunds in full.

  4. Purchases and stock

    Supplier payments are coded to inventory or cost of goods according to how you track stock.

  5. Month end

    Bank, card and clearing accounts are reconciled and you get a Profit and Loss by channel.

Selling on more than one platform? Each channel is tracked separately, so you can see which one actually earns after its own fees and refunds.

Reports you receive

  • Profit and Loss by sales channel
  • Fees as a share of sales per platform
  • Refunds by month
  • Cost of goods and gross margin
  • Reconciliation reports
FAQ

Questions from owners in this industry

Which platforms can you work with?

Any platform that provides a settlement or payout report, which includes the major marketplaces, store builders and payment processors.

Do I need a connector app?

Not necessarily. For lower volumes I record from the settlement reports directly. At higher volumes a connector can help, and I’ll tell you if it is worth paying for.

My past months were booked from deposits. Can you redo them?

Yes. I re enter the period from the settlement reports and reconcile it.

Work with me

Selling online?

Tell me which platforms you sell on, roughly how many orders a month and how your books are kept now. I’ll review what you have and send a fixed price.

  • Free review of your file
  • Fixed quote before any work
  • Margin you can trust by channel

Tell me where your books stand

A few details are enough. I’ll reply with what I see and a fixed quote.

Your details stay private. I reply within one business day.