E-commerce Bookkeeping for Peninsula Operators
E-commerce Bookkeeping Solutions
If you run an online store, your books break in ways that a brick-and-mortar business’s
books don’t. Revenue shows up in three or four different systems. Merchant processors
deposit net of fees, and the fees never get booked. Sales tax collected in fifteen states
sits untracked until it’s a problem.
I’ve spent the last three years cleaning up exactly these messes.
Platforms I work with regularly
What usually breaks
Revenue counted twice: once from the gateway’s daily deposit, once from the sales
channel’s import. This is the most common E-commerce bookkeeping error, and it makes
your P&L look 20–30% bigger than reality.
Merchant fees not booked: net deposits hit the bank, but the gross-to-net delta
never becomes an expense.
Sales tax not separated: sales tax collected from customers gets booked as revenue,
which inflates top line and creates a liability that nobody is tracking.
Refunds not matched: customer refunds show up as “Uncategorized” because the
original sale was in a different period.
Inventory and COGS: either untracked or tracked wrong, so gross margin is
meaningless.
How I fix it
Discovery first: I map your full revenue stack, channels, processors, integrations, banks.
Then I build the reconciliation so that each channel’s sales summary reconciles cleanly to
the processor’s payout, which reconciles to the bank deposit.
|
A2X, if you’re using it, gets
configured correctly. If you’re not, I’ll tell you whether it’s worth adding.
Before We Talk
The 20-minute call is more useful when I know what we’re looking at. The booking form asks three things: your sales channels, your monthly order volume, and whether you’re already using A2X or a similar integration tool. Takes two minutes; saves us ten on the call.
Book a call to review your E-commerce stack
