Bookkeeping for E-commerce
The payout is not the whole sale.
Why it’s different
E-commerce bookkeeping gets complicated in the space between the checkout page and the bank account. An online store may show gross sales while the marketplace or payment processor sends a smaller payout after fees, refunds, chargebacks, shipping adjustments, reserves, discounts, or other deductions. Add a second sales channel and the accounting can become difficult to follow very quickly.
Marketplace and processor payouts are reconciled, not guessed
Tied back to the underlying records so fees, refunds, and other adjustments aren’t mistaken for ordinary sales or expenses.
Refunds and chargebacks stay separate from normal expenses
Keeping that activity distinguishable makes the sales record easier to follow.
Multi-channel sales don’t become duplicate revenue
Monthly review helps identify deposits or sales that were imported twice before they accumulate across months.
Product purchases, shipping, and fulfillment costs remain readable
Kept organized within the bookkeeping scope, while formal inventory valuation is confirmed separately when the business requires it.
Vendor bills and receivables can stay visible
Supplier invoices and any wholesale or B2B customer invoices stay organized when AP/AR support is included.
Why e-commerce bookkeeping gets messy
The storefront, marketplace, processor, and bank can all show different numbers for the same period without any of them necessarily being wrong. One system may show gross orders. Another may show net payouts. Refunds can settle days later. A chargeback can reverse money after the original sale. Marketplace or processor fees can be deducted before the deposit ever reaches the bank.
If the bookkeeping records only the net payout as sales, important pieces of the transaction can disappear. If an integration imports every order while the bank feed also creates income, the opposite problem can happen and sales may be duplicated. The bookkeeping process needs to reconcile the records rather than simply accept whatever each feed creates.
The bookkeeping work that matters for online sellers
Marketplace and processor payouts are reconciled, not guessed
An online seller may receive payouts from a website processor, one or more marketplaces, and other payment channels. Where the available reports provide enough detail, the books can preserve the distinction between gross sales activity and the amounts deducted before settlement — an accounting file that explains the bank deposit instead of treating the deposit itself as the explanation.
Refunds and chargebacks stay separate from normal operating expenses
A refund or chargeback shouldn’t quietly become a generic expense simply because money left the account. Keeping that activity distinguishable makes the sales record easier to follow and helps prevent net payouts from obscuring what actually happened during the month. The bookkeeping role is to record the financial activity consistently, not to decide refund policy or dispute strategy.
Multi-channel sales don’t have to become duplicate revenue
A business may sell through its own website and one or more marketplaces at the same time, each exporting orders differently, and accounting integrations can create duplicate or inconsistent entries when they aren’t configured carefully. Monthly review and reconciliation helps identify deposits or sales that were imported twice, transfers mistaken for revenue, and missing fees before they accumulate across several months.
Product purchases, shipping, fulfillment, and operating costs remain readable
Online sellers spend money in several places before a product reaches the customer: suppliers, shipping carriers, packaging, fulfillment providers, storage, software, marketplace fees, merchant fees, and advertising. Product purchases and inventory-related records can be kept organized within the bookkeeping scope, while formal inventory valuation or inventory-adjusted cost-of-goods-sold treatment is confirmed separately when the business requires it.
Vendor bills and receivables can stay visible
Some online businesses pay suppliers after an invoice rather than at checkout. When AP/AR support is included, open vendor bills and payment status can be kept organized, and businesses that also sell wholesale or invoice corporate customers can keep those open invoices and incoming payments visible.
Catch-up work can fix integrations and old payout problems
E-commerce books often become messy through automation rather than a lack of it: duplicated orders, payouts posted as sales on top of imported sales, processor fees omitted, or marketplace deposits that don’t tie out. Catch-up bookkeeping and cleanup can bring the file current before ongoing monthly bookkeeping begins.
QuickBooks Online and NetSuite bookkeeping for e-commerce
Many online sellers also use separate storefront, marketplace, payment, fulfillment, advertising, shipping, and inventory systems. The accounting file should summarize the financial activity coming from those tools without pretending to replace the systems that run the store. If the existing file already has useful sales-channel, product, fee, or expense categories, we can work with that structure; if years of app connections have made the file difficult to read, cleanup can simplify the bookkeeping structure.
Balanced On Time Books works on a recurring monthly close: bank and credit-card accounts reconciled, transactions reviewed and categorized, payout and bookkeeping questions resolved, and the agreed financial statements delivered on schedule, with the standard being to close the books by the 10th each month. That creates a cleaner accounting record during the year and gives the CPA or tax professional a better starting point when tax work begins.
Bookkeeping is not sales-tax or inventory accounting
E-commerce can create separate sales-tax, inventory, cross-border, and tax-reporting obligations. Balanced On Time Books keeps the books organized within the agreed engagement, but does not prepare or file tax returns or provide sales-tax, customs, VAT, GST, or legal advice. If the business needs perpetual inventory accounting, formal inventory valuation, inventory-adjusted COGS, advanced subscription revenue recognition, or marketplace tax filings, that scope should be confirmed with the appropriate CPA or specialist rather than implied by ordinary monthly bookkeeping.
Cincinnati and New York City e-commerce bookkeeping
Balanced On Time Books is based in Cincinnati and building a presence in New York City, though e-commerce bookkeeping was remote-friendly long before either office existed. A seller’s actual location matters less than the platforms behind the business — the marketplace, the payment processor, the shipping carrier, and the accounting software — and all of that can be reviewed and reconciled through QuickBooks Online or NetSuite without an in-person visit, whether the seller runs one storefront or several across different platforms.
A store based in Cincinnati, a brand based in New York City, or a seller somewhere else entirely gets the same monthly bookkeeping: payouts matched to the underlying sales, fees and refunds separated out, and the books closed on a consistent schedule regardless of where the inventory ships from or which warehouse or fulfillment partner is actually handling it.
Who this can be a fit for
This service can fit independent online stores, direct-to-consumer brands, marketplace sellers, small multi-channel retailers, and subscription or recurring-order sellers operating within a straightforward cash-basis scope. It’s especially useful when marketplace payouts don’t match the books, processor fees are missing, or several sales channels are creating duplicate entries. For a business with both physical and online sales, the Retail page covers store-level bookkeeping.
Bookkeeping for subscription and recurring-order e-commerce businesses
A growing number of online sellers run on recurring orders rather than one-time purchases — subscription boxes, replenishment programs, membership-style storefronts. On a cash basis, subscription revenue is recorded as it actually lands in the bank each billing cycle, rather than through a formal deferred-revenue schedule that spreads a single payment across the months it’s meant to cover. That keeps the books matched to what QuickBooks Online or NetSuite can actually show as cash movement, which is what cash-basis bookkeeping is built around.
Recurring-billing platforms such as Shopify Subscriptions, Recharge, and Bold settle in batches, and the payout deposited to the bank rarely matches the sum of any single day’s charges. Balanced On Time Books reconciles these payouts the way it reconciles marketplace and processor deposits generally, tying each batch to the underlying charges, platform fees, and any holdbacks so the deposit in the bank ties out to what the books show as revenue.
Subscription businesses also generate a steady stream of refunds, mid-cycle cancellations, and failed-payment retries, and each needs to be recorded the same way every time so months stay comparable to one another. A consistent method is applied for these transactions and reconciled against the bank alongside the regular payouts.
E-commerce bookkeeping questions
Do you work with sellers on more than one marketplace at once?
Yes. The bookkeeping approach applies to sellers on a single storefront as well as businesses spread across several marketplaces and processors at the same time.
Can you clean up QuickBooks when payouts and sales don’t match?
Yes. QuickBooks Online setup and cleanup is offered, including reconciling old marketplace payouts and resolving duplicate or missing entries from integrations.
Do you handle sales-tax filing or perpetual inventory accounting?
No. Balanced On Time Books does not prepare or file sales-tax, customs, or income-tax returns, and formal inventory valuation or inventory-adjusted COGS would need a separately scoped accounting engagement.
Can you reconcile payroll or contractor payments for the business?
Payroll support is available within the described scope, reconciled against the books once the business approves it.
What if our integrations have been creating duplicate entries for months?
That’s a common catch-up scenario. Tell us which platforms and processors are involved and how far behind the books are, and we’ll talk through the work, usually within about 30 minutes during the stated callback window.
Can you reconcile subscription or recurring-billing payouts from Recharge, Bold, or Shopify Subscriptions?
Yes. These payouts are reconciled against the bank the same way we handle other marketplace and processor deposits, matching batched deposits to the underlying charges, fees, and refunds so revenue is recorded consistently month to month.
We sell internationally and receive marketplace deposits in foreign currency. Can you handle that?
Deposits are recorded based on what actually lands in the bank account, in the amount and currency the bank shows. We don’t perform currency-conversion accounting or manage multi-currency ledgers beyond what QuickBooks Online or NetSuite handles automatically, so this works best when the bank account settles in a single currency.
How do you categorize payments to affiliates or influencers?
Affiliate and influencer payouts are recorded as a distinct expense category, separate from advertising and marketing spend generally, so the business can see what referral-based sales are actually costing it. We don’t determine worker classification for anyone paid through this channel — that decision stays with the business.
Want this handled for your business?
Fill out a few details for a personal callback, usually within 30 minutes.