Ecommerce Accounting Guide for Online Businesses by KP Accounting

An ecommerce store reports $150,000 in monthly platform sales.

At first glance, the business appears to be growing quickly. However, the amount deposited into its bank account is much lower after accounting for:

• Customer discounts
• Returns and refunds
• Sales tax
• Credit-card processing fees
• Shopify fees
• Amazon referral and fulfillment fees
• Advertising
• Shipping
• Chargebacks
• Inventory purchases
• Marketplace reserves

The business may have strong sales and still face a cash shortage.

That happens because platform sales, payouts, accounting revenue, profit, taxable income, and cash flow are different financial measurements.

A Shopify payout is not necessarily revenue. It is a net transfer after the platform processes multiple additions and deductions.

An Amazon deposit is not necessarily total sales. It may reflect product sales, refunds, fees, reimbursements, reserves, advertising charges, and other settlement activity.

Inventory purchases also do not always become an immediate operating expense. The cost of products sold must generally be matched with the related sales through an appropriate inventory and cost-of-goods-sold process.

This is why online retailers need specialized ecommerce bookkeeping.

Reliable ecommerce accounting helps owners understand:

• What customers purchased
• What platforms collected
• What marketplaces deducted
• What remains in reserves
• How much inventory was sold
• What each product actually earned
• Which sales channels are profitable
• What sales tax is owed
• How much cash is available
• What the business may owe in income taxes

This guide explains the essential accounting systems Shopify merchants, Amazon sellers, direct-to-consumer brands, and multichannel online retailers need to build financially sustainable businesses.

Is Your Store Growing Faster Than Your Accounting System?

Strong online sales can hide shrinking margins, unreconciled fees, inventory problems, and sales tax exposure.

KP Accounting helps Shopify, Amazon, and multichannel sellers organize their financial records and understand what their businesses actually earn.

Review My Ecommerce Accounting

What Is Ecommerce Accounting?

Ecommerce accounting is the process of recording, reconciling, analyzing, and reporting the financial activity of online stores and marketplaces. It includes sales, payouts, refunds, platform fees, payment-processing costs, sales tax, inventory, cost of goods sold, shipping, advertising, payroll, cash flow, and tax planning.

Ecommerce accounting connects data from several systems, including:

• Online storefronts
• Marketplaces
• Payment processors
• Banks
• Credit cards
• Inventory platforms
• Shipping providers
• Fulfillment companies
• Payroll systems
• Sales tax software

The purpose is not merely to copy store sales into accounting software.

It is to create financial records that accurately explain:

• Revenue
• Fees
• Inventory
• Liabilities
• Profit
• Cash flow

Ecommerce accounting includes:

• Recording online sales
• Reconciling platform payouts
• Tracking marketplace fees
• Recording refunds and chargebacks
• Separating sales tax
• Tracking inventory
• Calculating cost of goods sold
• Recording shipping income and expense
• Monitoring advertising costs
• Preparing financial reports
• Forecasting cash flow
• Planning taxes

Ecommerce Accounting vs. Standard Small-Business Accounting

Ecommerce accounting is also different from:

Store analytics: Measures sales activity, customer behavior, and marketing performance.

Marketplace reports: Show transactions and fees within a specific platform.

Payment dashboards: Show money processed or transferred.

Inventory software: Tracks units and stock movement.

Sales tax software: Helps calculate, monitor, or file sales tax based on configured data.

None of these tools automatically replaces the accounting ledger.

Why Ecommerce Bookkeeping Is Different

Ecommerce bookkeeping is more complex because online businesses process high transaction volumes across multiple stores, marketplaces, currencies, and payment gateways. Bank deposits are usually net settlements rather than gross sales, requiring sellers to separate fees, refunds, taxes, reserves, chargebacks, discounts, and timing differences.

High transaction volume

An ecommerce company may process hundreds or thousands of orders each month.

Recording every order manually can become inefficient. However, summarizing transactions incorrectly can distort financial statements.

A good system balances:

• Accurate platform summaries
• Complete fee recording
• Reliable settlement reconciliation
• Manageable transaction volume

Multiple sales channels

A seller may operate through:

• Shopify
• Amazon
• Walmart Marketplace
• eBay
• Etsy
• TikTok Shop
• Wholesale channels
• Physical retail
• Subscription platforms

Each channel may have different:

• Fees
• Settlement schedules
• Refund processes
• Tax reporting
• Currency treatment
• Inventory systems

Multiple payment processors

A Shopify store may accept payments through:

• Shopify Payments
• PayPal
• Stripe
• Klarna
• Shop Pay
• Other gateways

Each processor must be reconciled separately because the Shopify sales report alone may not explain every bank deposit.

Net settlements

Marketplaces and processors commonly deposit a net amount after subtracting:

• Refunds
• Processing fees
• Marketplace commissions
• Fulfillment fees
• Chargebacks
• Advertising
• Reserves
• Other adjustments

Recording the deposit as sales understates both revenue and expenses.

Returns and refunds

Returns affect:

• Revenue
• Inventory
• Payment processor balances
• Shipping costs
• Fulfillment fees
• Customer credits
• Cash flow

The accounting system should distinguish a product return from:

• A refund without return
• A chargeback
• A discount
• A store credit
• A damaged inventory write-off

Sales tax

Sales tax may be collected by:

• The seller
• Shopify on the seller’s behalf
• A marketplace facilitator
• A third-party checkout provider

Collected sales tax is generally tracked as a liability rather than operating revenue.

Inventory

Product sellers must account for:

• Purchases
• Freight
• Duties
• Manufacturing
• Packaging
• Damaged goods
• Returned products
• Shrinkage
• Ending stock

These factors directly affect gross profit.

Gross Sales vs. Net Sales vs. Payouts vs. Profit

Gross sales represent sales before reductions. Net sales reflect discounts, returns, and refunds. A payout is the cash transferred after platform activity. Gross profit subtracts cost of goods sold, while net profit subtracts operating expenses. Cash flow measures the actual movement of money.

Gross Sales

Gross sales represent the total value of product sales before reductions such as:

• Discounts
• Returns
• Refunds
• Promotional allowances

Gross sales do not automatically equal cash received.

Net Sales

Net Sales = Gross Sales − Discounts − Returns − Refunds

Net sales provide a clearer picture of revenue retained after customer-facing sales adjustments.

Platform Payout

A platform payout is the amount transferred to the business’s bank account.

A simplified formula is:

Payout = Customer Collections − Fees − Refunds − Chargebacks − Tax Withheld or Remitted ± Other Adjustments

Actual payout calculations vary by platform, processor, jurisdiction, and report configuration.

Gross Profit

Gross Profit = Net Sales − Cost of Goods Sold

Gross profit shows how much remains after the cost of products sold.

Net Profit

Net Profit = Gross Profit − Operating Expenses

Operating expenses can include:

• Advertising
• Platform subscriptions
• Payroll
• Professional fees
• Insurance
• Office expenses
• Software
• Non-inventory shipping costs

Cash Flow

Cash flow represents money moving into and out of the business.

A store can report profit but still have low cash because it:

• Purchased future inventory
• Repaid debt
• Paid sales tax
• Built a marketplace reserve
• Paid suppliers before receiving customer cash
• Made large owner distributions

Taxable Income

Taxable income may differ from accounting profit because of:

• Depreciation
• Inventory treatment
• Entity structure
• Tax elections
• Nondeductible items
• Timing rules
• State adjustments

Ecommerce Payout Reconciliation Explained

Payout reconciliation matches platform sales, taxes, discounts, refunds, fees, chargebacks, reserves, and adjustments with the amount deposited into the bank. It prevents net deposits from being incorrectly recorded as revenue and helps identify missing transactions, duplicated entries, and timing differences.

Payout Reconciliation Workflow

1. Record gross sales.
2. Record discounts.
3. Record refunds and returns.
4. Separate sales tax.
5. Record processing fees.
6. Record marketplace fees.
7. Record chargebacks.
8. Record reserves and other adjustments.
9. Identify pending settlement amounts.
10. Match the expected net payout with the bank deposit.
11. Investigate differences.
12. Close the settlement period.

Hypothetical Payout Example

Assume a platform processes the following activity:

Net bank payout

$22,650

The $22,650 deposit should not simply be recorded as sales.

The accounting entry must preserve:

• Sales
• Shipping income
• Discounts
• Refunds
• Sales tax liability
• Fees
• Chargebacks
• Net cash

Otherwise, revenue and expenses may both be understated.

Shopify Accounting Explained

Shopify accounting records and reconciles store sales, Shopify Payments payouts, third-party gateways, shipping, discounts, refunds, gift cards, store credits, sales tax, chargebacks, fees, financing, and pending balances. Shopify reports provide essential data, but they should be reconciled with processors, bank accounts, and the accounting ledger.

Shopify financial activity may include:

• Product sales
• Shipping collected
• Discounts
• Refunds
• Shopify Payments fees
• Third-party payment fees
• Sales tax
• Gift-card sales
• Gift-card redemptions
• Store credits
• Chargebacks
• Financing deductions
• Currency conversion
• Pending payouts

Shopify Payments

Shopify Payments may transfer net amounts after:

• Payment-processing fees
• Refunds
• Chargebacks
• Adjustments
• Negative balances

The payout date may differ from the order date, creating timing differences between sales reports and bank activity.

Third-Party Payment Gateways

Payments processed through PayPal, Stripe, or another gateway should be reconciled separately.

A Shopify order report may show the sale, while the related cash is held and paid by another processor.

Gift Cards

Selling a gift card is generally not treated the same as selling merchandise.

The business receives cash but may also create an obligation to provide goods or services later. Gift-card balances should therefore be tracked separately, subject to applicable accounting and unclaimed-property rules.

Shopify Payout Reconciliation Workflow

1. Retrieve Shopify sales and finance reports.
2. Separate gross sales, discounts, refunds, shipping, and taxes.
3. Record Shopify processing fees.
4. Match Shopify Payments payouts to bank deposits.
5. Reconcile PayPal and other gateways independently.
6. Review pending payouts.
7. Review chargebacks and negative balances.
8. Track gift cards and store credits.
9. Compare Shopify reports with accounting records.
10. Resolve differences before monthly close.
11. Shopify analytics are useful operational tools, but they should not automatically be treated as the accounting ledger.

Amazon Seller Accounting Explained

Amazon seller accounting records product sales, refunds, referral fees, FBA charges, storage, advertising, reimbursements, reserve balances, shipping credits, sales tax, inventory adjustments, and settlement deposits. Amazon bank deposits must be reconciled with settlement reports because deposits represent net activity rather than gross sales.

Amazon financial activity may include:

• Product sales
• Shipping credits
• Promotional rebates
• Customer refunds
• Referral fees
• FBA fulfillment fees
• Storage fees
• Inbound placement or transportation costs
• Return-processing fees
• Advertising
• Reimbursements
• Inventory adjustments
• Account-level reserves
• Chargebacks
• Sales tax
• Currency conversion
• Marketplace-specific fees

Amazon Settlement Reports

Amazon settlement reports summarize financial activity over a settlement period.

The settlement can include:

• Orders
• Refunds
• Amazon-initiated charges
• Credits
• Reimbursements
• Reserves

The amount deposited into the bank is the net result of these activities.

Amazon Reserves

Amazon may reserve part of a seller’s balance to cover potential obligations such as:

• Refunds
• Claims
• Chargebacks

Reserved amounts may represent receivables or restricted platform balances rather than immediate cash.

Amazon Settlement Reconciliation Workflow

1. Retrieve the settlement report.
2. Identify product sales.
3. Separate shipping and other income.
4. Record refunds.
5. Categorize referral fees.
6. Categorize FBA and storage fees.
7. Record advertising charges.
8. Record reimbursements and credits.
9. Separate sales tax.
10. Record reserve activity.
11. Match the net settlement to the bank.
12. Investigate unresolved differences.
13. Reconcile inventory activity.
14. Review profitability after fees and cost of goods sold.
15. Recording only the Amazon deposit can understate revenue and expenses and make gross margins unreliable.

Shopify Accounting vs. Amazon Seller Accounting

Shopify gives merchants more direct control over the storefront, customers, payment gateways, and checkout settings. Amazon controls more of the marketplace transaction and combines many fees, reserves, reimbursements, and fulfillment charges within settlement reports. Both require platform-level reconciliation, but the reports and fee structures differ.

Reconciliation

Store plus each gateway

Settlement-level reconciliation

Multichannel Ecommerce Accounting

Multichannel ecommerce accounting consolidates sales, fees, refunds, taxes, inventory, and payouts from multiple platforms into one reliable financial system. The main risks are duplicate sales imports, inconsistent fee categories, timing differences, shared inventory, multiple currencies, and incomplete marketplace tax records.

A multichannel seller may receive data from:

• Shopify
• Amazon
• Walmart Marketplace
• Etsy
• eBay
• TikTok Shop
• Wholesale portals
• Subscription systems
• Physical stores

Common multichannel challenges

• Duplicate transactions
• Different payout schedules
• Different order dates and settlement dates
• Channel-specific fees
• Shared inventory
• Returns processed on different systems
• Marketplace-facilitated tax
• Multiple currencies
• Inconsistent SKU names
• Unclear product profitability

Multichannel Reconciliation Checklist

Reconcile each platform independently.

Reconcile every payment gateway.

Maintain consistent account categories.

Map SKUs consistently.

Eliminate duplicate imports.

Separate marketplace and direct-channel tax.

Reconcile shared inventory.

Review currency conversion.

Match returns with inventory movement.

Prepare channel-level profit reports.

Confirm all deposits reached the bank.

Review clearing-account balances.

A centralized chart of accounts should preserve meaningful platform detail without creating hundreds of unnecessary accounts.

Inventory Accounting and Cost of Goods Sold

Inventory accounting tracks the cost and quantity of products held for sale. Cost of goods sold represents the cost assigned to products sold during a period. Reliable inventory records are necessary to calculate gross profit, understand product margins, detect shrinkage, and prepare accurate tax and financial reports.

Key Inventory Terms

Beginning inventory: Inventory value at the start of the period.

Purchases: Products acquired or produced for sale.

Landed cost: Product cost plus eligible costs necessary to bring inventory to its sale-ready location and condition.

Ending inventory: Inventory value remaining at the end of the period.

Cost of goods sold: Cost assigned to products sold.

Shrinkage: Inventory lost through damage, theft, errors, or unexplained differences.

Obsolete inventory: Products that can no longer be sold at their expected value.

Cost of Goods Sold Formula

Cost of Goods Sold = Beginning Inventory + Purchases and Eligible Landed Costs − Ending Inventory

Costs that may affect inventory value

Depending on the accounting and tax method, costs may include:

• Product purchases
• Raw materials
• Direct manufacturing
• Inbound freight
• Customs duties
• Import fees
• Product preparation
• Integral packaging
• Certain production overhead

Outbound shipping to customers is often treated differently from inbound freight.

Hypothetical Inventory Example

Inventory component

If the business records all $270,000 of purchases and inbound costs as immediate expenses, it may overstate expenses and understate ending inventory.

Small-business tax rules may permit alternative inventory methods in certain circumstances, but the method must still clearly reflect income and be applied consistently.

Inventory Controls

Conduct regular physical counts.

Reconcile platform quantities.

Reconcile warehouse reports.

Track FBA inventory.

Document damaged goods.

Review obsolete inventory.

Monitor negative stock.

Investigate unexplained adjustments.

Keep unit costs current.

Reconcile returns with sellable stock.

Ecommerce Sales Tax Accounting

Ecommerce sales tax accounting tracks tax collected directly by the seller, tax collected by marketplaces, registrations, filings, remittances, exemptions, and outstanding liabilities. Requirements vary by state, product, sales channel, physical presence, economic activity, and marketplace laws, so there is no single nationwide rule.

Physical Nexus

A seller may create sales tax obligations through physical activity such as:

• Offices
• Employees
• Warehouses
• Inventory
• Fulfillment arrangements
• Other in-state operations

Economic Nexus

States may require remote sellers to register after exceeding state-specific economic activity thresholds.

These thresholds and measurement rules vary.

Inventory Location

Inventory stored in a warehouse or fulfillment network may create state-level considerations.

Amazon FBA sellers should not assume that marketplace storage has no tax or nexus impact.

Marketplace Facilitator Laws

Marketplaces may collect and remit sales tax on facilitated transactions.

However, sellers may still need to address:

• Registration
• Direct-channel sales
• Exemption documentation
• Tax returns
• Reconciliation
• Inventory locations
• Non-marketplace sales
• Income or franchise tax considerations

Shopify Direct Sales

Shopify is a commerce platform, not necessarily the seller of record for all transactions. Sellers remain responsible for determining where registration, collection, filing, and remittance are required.

Sales Tax Is Not Operating Revenue

Sales tax collected from customers is generally recorded as a liability.

A simplified entry separates:

• Product revenue
• Shipping revenue
• Sales tax payable
• Cash or processor receivable

Sales Tax Reconciliation Checklist

Separate seller-collected tax.

Separate marketplace-facilitated tax.

Compare platform reports with tax software.

Compare collected tax with filed returns.

Compare filed returns with remittances.

Review registration status by state.

Review direct-channel thresholds.

Review inventory locations.

Maintain exemption certificates.

Investigate tax overcollection.

Investigate tax undercollection.

Reconcile sales tax payable monthly.

Review New Jersey and Pennsylvania separately.

Are Your Sales Tax Records Matching Your Store and Marketplace Reports?

Sales tax errors often begin with inconsistent platform data, missing registrations, or tax amounts recorded as revenue.

KP Accounting can help ecommerce businesses organize sales tax records and coordinate accounting information for professional review.

Review My Sales Tax Accounting

Returns, Refunds, Chargebacks, Discounts, and Gift Cards

Returns, refunds, chargebacks, discounts, gift cards, and store credits have different accounting effects. Separating them helps sellers measure net sales, processor receivables, liabilities, customer credits, fees, inventory movement, and actual revenue leakage.

Returns and Refunds

Refunds should generally be separated from ordinary operating expenses so management can measure:

• Refund rate
• Product quality problems
• Customer dissatisfaction
• Fulfillment errors

Chargebacks

Chargebacks can include:

• Reversed customer payment
• Processor fee
• Temporary hold
• Later recovery

The accounting treatment should reflect the actual outcome and timing.

Discounts

Discounts should be tracked separately to measure:

• Promotional effectiveness
• Margin erosion
• Coupon performance
• Channel pricing

Gift Cards and Store Credits

Outstanding balances should be tracked because the business may owe products, services, or refunds in the future.

Ecommerce Fees Sellers Must Track

Ecommerce sellers should record platform, processor, fulfillment, storage, advertising, shipping, currency, and software fees separately rather than hiding them inside net deposits. Proper categorization helps management compare channel profitability, product margins, fulfillment costs, and the true expense of generating sales.

Important fee categories include:

• Payment-processing fees
• Shopify subscriptions
• Shopify apps
• Amazon referral fees
• Amazon FBA fees
• Amazon storage charges
• Aged-inventory fees
• Marketplace commissions
• Advertising charges
• Listing fees
• Returns-processing fees
• Currency-conversion fees
• Fulfillment fees
• Warehousing
• Shipping labels
• Integration software
• Subscription tools

Combining every platform cost into “merchant fees” may simplify bookkeeping but weaken analysis.

A business should be able to determine:

• Total Amazon fee percentage
• Shopify processing expense
• Fulfillment cost per order
• Advertising by channel
• Storage cost
• Returns cost
• Currency conversion cost

Ecommerce Business Expenses and Potential Tax Deductions

Ecommerce businesses may deduct eligible ordinary and necessary expenses when supported by business purpose, documentation, entity structure, accounting method, and current tax law. Inventory, equipment, mixed-use expenses, meals, travel, education, and bad debt require additional analysis and should not automatically be expensed.

Potential expense categories include:

Inventory and cost of goods sold

Product costs may flow through inventory and cost of goods sold rather than being immediately deducted.

Documentation: Supplier invoices, freight records, inventory counts.

Common error: Expensing all purchases when unsold products remain.

Marketplace fees

Referral, listing, marketplace, and fulfillment charges may be business expenses or product-related costs depending on their nature.

Documentation: Settlement reports.

Common error: Recording only net deposits.

Merchant-processing fees

Credit-card and payment processing costs may qualify as business expenses.

Documentation: Processor statements.

Common error: Failing to separate them from revenue.

Websites and subscriptions

Hosting, domains, ecommerce platforms, and apps may qualify.

Documentation: Subscription invoices.

Common error: Continuing unused subscriptions.

Advertising

Search, social, marketplace, influencer, and affiliate campaigns may qualify when business-related.

Documentation: Campaign invoices and agreements.

Common error: Mixing owner-personal promotion with business advertising.

Photography and video

Product photography, editing, and content production may qualify.

Documentation: Vendor invoices and project records.

Common error: Treating substantial equipment purchases as ordinary service expenses.

Packaging

Packaging may be an inventory, product, fulfillment, or shipping cost depending on its nature.

Documentation: Purchase records.

Common error: Applying inconsistent treatment.

Shipping and fulfillment

Outbound shipping, warehouse fulfillment, and delivery expenses may qualify.

Documentation: Carrier and fulfillment statements.

Common error: Failing to offset shipping income and expense correctly.

Contractors and employees

Wages, contractor payments, payroll taxes, and qualifying benefits may be deductible.

Documentation: Payroll reports, contracts, invoices.

Common error: Misclassifying employees.

Professional fees

Accounting, legal, consulting, and tax services may qualify when related to the business.

Documentation: Professional invoices.

Common error: Combining personal and business advice.

Equipment and computers

Equipment may need to be capitalized, depreciated, or handled under applicable expensing provisions.

Documentation: Invoice and placed-in-service record.

Common error: Expensing every large purchase immediately.

Home office

A qualifying home office may be eligible when applicable requirements are satisfied.

Documentation: Measurements, expense records, and evidence of use.

Common error: Claiming shared household space without proper qualification.

Phone and internet

The business-use portion may qualify.

Documentation: Bills and reasonable allocation.

Common error: Claiming full cost despite substantial personal use.

Travel and vehicle expenses

Qualifying business travel and vehicle use may be deductible.

Documentation: Receipts, mileage, purpose, and itinerary.

Common error: Including commuting or personal travel.

Education

Education related to maintaining or improving skills in an existing business may qualify.

Documentation: Course materials and invoices.

Common error: Deducting education that prepares the owner for a new trade.

Business interest

Interest on qualifying business debt may be deductible subject to applicable rules.

Documentation: Loan statements and use of proceeds.

Common error: Deducting personal debt interest.

Ecommerce Cash Flow Management

Profitable ecommerce businesses can experience cash shortages because they often pay for inventory, advertising, fulfillment, shipping, payroll, and taxes before receiving or retaining customer cash. Marketplace reserves, delayed payouts, refunds, seasonality, and debt payments can widen the gap between accounting profit and available cash.

Ten Cash Flow Strategies

1. Build a rolling cash forecast.
   Project deposits, supplier payments, payroll, taxes, debt, and advertising.
2. Separate sales tax cash.
   Do not use collected tax as operating cash.
3. Forecast inventory purchases.
   Connect purchase orders with expected sales and lead times.
4. Track contribution margin.
   Know what remains after product, fulfillment, payment, and advertising costs.
5. Review advertising weekly.
   Do not wait until month-end to identify unprofitable campaigns.
6. Monitor payout delays.
   Track processor receivables and marketplace reserves.
7. Maintain a refund reserve.
   Prepare for returns, chargebacks, and seasonal refund patterns.
8. Negotiate supplier terms.
   Longer payment terms can reduce the cash conversion gap.
9. Avoid overstocking.
   Excess inventory locks cash into slow-moving products.
10. Review debt obligations.
    Loan principal reduces cash even when it does not appear as an operating expense.

Financial Reports Ecommerce Businesses Should Review

Ecommerce businesses should review a profit and loss statement, balance sheet, cash flow statement, inventory valuation, channel profitability, SKU profitability, and budget comparison. Together, these reports show sales quality, margins, inventory exposure, processor balances, tax liabilities, and cash requirements.

Profit and Loss Statement

Review:

• Gross sales
• Discounts
• Refunds
• Net sales
• Cost of goods sold
• Gross profit
• Advertising
• Platform fees
• Fulfillment
• Shipping
• Payroll
• Operating profit

Balance Sheet

Review:

• Cash
• Inventory
• Accounts receivable
• Processor receivables
• Amazon reserves
• Sales tax payable
• Gift-card liabilities
• Credit cards
• Loans
• Owner equity

Cash Flow Statement

Cash flow differs from profit because of:

• Inventory purchases
• Debt principal
• Owner withdrawals
• Processor reserves
• Equipment purchases
• Tax payments

Inventory Valuation Report

This report should show:

• Product quantities
• Unit costs
• Total value
• Locations
• Damaged inventory
• Obsolete inventory

Channel Profitability Report

Compare:

• Shopify
• Amazon
• Walmart
• Etsy
• eBay
• TikTok Shop
• Wholesale

Include:

• Net sales
• Fees
• Advertising
• Fulfillment
• Cost of goods sold
• Contribution margin

SKU Profitability Report

A high-volume product can be unprofitable after:

• Discounts
• Advertising
• Returns
• Fulfillment
• Shipping
• Marketplace fees
• Product cost

Budget-versus-Actual Report

Monitor:

• Advertising
• Inventory
• Fulfillment
• Software
• Payroll
• Shipping
• Professional fees

Do You Know Which Products and Sales Channels Actually Make Money?

Revenue dashboards rarely show the full effect of inventory, advertising, refunds, fees, and fulfillment.

KP Accounting helps ecommerce businesses build financial reports that reveal actual margins and cash flow.

Improve My Ecommerce Reports

Ecommerce KPIs Every Online Seller Should Track

Ecommerce KPIs should connect store activity with accounting performance. Sellers need more than traffic, orders, and revenue; they should monitor net sales, gross margin, contribution margin, refund rates, platform fees, fulfillment costs, inventory turnover, cash conversion, tax liabilities, and profit by channel and SKU.

Important KPIs include:

Gross sales: Sales before discounts and returns.

Net sales: Sales after customer-facing reductions.

Average order value: Net sales divided by orders.

Refund rate: Refund value divided by relevant sales.

Chargeback rate: Chargebacks relative to processed transactions.

Cost of goods sold percentage: COGS divided by net sales.

Gross margin: Gross profit divided by net sales.

Contribution margin: Amount remaining after variable product, fulfillment, transaction, and acquisition costs.

Customer acquisition cost: Acquisition spending divided by new customers.

Return on advertising spend: Revenue attributed to ads divided by ad spend.

Platform fee percentage: Platform fees divided by channel sales.

Fulfillment cost per order: Fulfillment costs divided by orders.

Shipping cost per order: Shipping expense divided by orders.

Inventory turnover: Cost of goods sold relative to average inventory.

Days inventory on hand: Estimated days current stock may support.

Operating expense ratio: Operating expenses divided by revenue.

Net profit margin: Net profit divided by revenue.

Cash conversion cycle: Time between paying for inventory and collecting cash.

Payout reconciliation difference: Unresolved difference between expected and actual settlements.

Sales tax payable: Collected tax not yet remitted.

Revenue by channel: Sales generated by each platform.

Profit by SKU: Profit contribution by individual product.

Benchmarks should be evaluated against the company’s:

• Product category
• Channel
• Pricing
• Growth stage
• Fulfillment model
• Historical results

Fifteen Ecommerce Accounting Mistakes to Avoid

The most common ecommerce accounting mistakes include recording net payouts as sales, ignoring processor clearing accounts, treating sales tax as revenue, failing to reconcile Shopify and Amazon, expensing all inventory purchases, combining fees, and measuring success through revenue without considering margins or cash flow.

1. Recording net payouts as sales

Problem: Bank deposits are classified as revenue.

Impact: Revenue and fees are understated.

Prevention: Reconcile platform settlements.

2. Ignoring processor clearing accounts

Problem: Pending processor balances are not tracked.

Impact: Timing differences appear as errors.

Prevention: Use and reconcile clearing accounts.

3. Treating sales tax as revenue

Problem: Collected tax increases reported sales.

Impact: Revenue and liabilities are misstated.

Prevention: Record tax payable separately.

4. Failing to reconcile Shopify payouts

Problem: Shopify reports do not match the bank.

Impact: Fees, refunds, and pending payouts are missed.

Prevention: Reconcile each payout.

5. Failing to reconcile Amazon settlements

Problem: Only deposits are recorded.

Impact: Sales and Amazon fees are understated.

Prevention: Use settlement reports.

6. Ignoring refunds and chargebacks

Problem: Reductions are buried in processor activity.

Impact: Net sales and customer issues are unclear.

Prevention: Track them separately.

7. Expensing every inventory purchase

Problem: All purchases become immediate expenses.

Impact: Profit and inventory are misstated.

Prevention: Apply an appropriate inventory method.

8. Failing to count inventory

Problem: Records are never compared with actual stock.

Impact: Shrinkage and errors remain hidden.

Prevention: Perform regular counts.

9. Ignoring cost of goods sold

Problem: Sales are reported without product cost.

Impact: Gross margin is meaningless.

Prevention: Calculate COGS consistently.

10. Combining all platform fees

Problem: Referral, advertising, storage, and fulfillment fees use one account.

Impact: Channel profitability cannot be analyzed.

Prevention: Use meaningful fee categories.

11. Mixing personal and business spending

Problem: Owner expenses enter the books.

Impact: Profit and tax records become unreliable.

Prevention: Maintain separate accounts.

12. Ignoring multistate sales tax exposure

Problem: Sellers assume marketplaces handle everything.

Impact: Registration or filing obligations may be missed.

Prevention: Review every channel and state.

13. Reviewing finances only at tax time

Problem: Reports are prepared annually.

Impact: Margin and cash problems continue unnoticed.

Prevention: Close the books monthly.

14. Measuring success through revenue alone

Problem: Growth is evaluated only by sales.

Impact: Shrinking margins remain hidden.

Prevention: Track gross and contribution margin.

15. Using analytics as the accounting ledger

Problem: Store dashboards replace bookkeeping.

Impact: Liabilities, fees, cash, and inventory may be incomplete.

Prevention: Maintain a reconciled accounting system.

Best Ecommerce Accounting Software

The best ecommerce accounting system depends on transaction volume, sales channels, inventory, currencies, payroll, integrations, and reporting needs. Core accounting platforms store the ledger, while connector tools summarize marketplace activity. Inventory, payroll, and sales tax platforms serve separate functions.

Software should be evaluated based on:

• Supported platforms
• Transaction volume
• Settlement summaries
• Inventory
• Currency
• Clearing accounts
• Sales tax mapping
• User access
• Reporting
• Audit trail
• Data export
• Support

Software does not eliminate the need for:

• Correct setup
• Monthly reconciliation
• Inventory counts
• Sales tax analysis
• Professional review

Shopify and Amazon Monthly Accounting Workflow

A Shopify and Amazon monthly close should reconcile every store, payment gateway, marketplace settlement, refund, fee, sales tax balance, bank account, inventory report, and cost-of-goods-sold calculation before management reviews channel and product profitability.

Monthly Close Workflow

1. Import or summarize Shopify sales.
2. Reconcile Shopify Payments.
3. Reconcile PayPal and other gateways.
4. Import or summarize Amazon settlements.
5. Reconcile Amazon deposits.
6. Record refunds.
7. Record chargebacks.
8. Separate sales tax.
9. Record platform and processor fees.
10. Reconcile processor clearing accounts.
11. Update inventory.
12. Calculate cost of goods sold.
13. Reconcile bank accounts.
14. Reconcile credit cards.
15. Review sales tax payable.
16. Prepare financial statements.
17. Review channel profitability.
18. Review SKU profitability.
19. Update tax forecasts.
20. Update cash flow forecasts.

Monthly Ecommerce Close Checklist

• All platforms recorded
• All gateways reconciled
• All settlements matched
• Refunds categorized
• Chargebacks reviewed
• Sales tax separated
• Inventory updated
• COGS recorded
• Bank accounts reconciled
• Credit cards reconciled
• Processor balances supported
• Gift cards supported
• Tax liabilities reviewed
• Reports prepared
• Variances explained

When Should an Ecommerce Business Hire a CPA?

An ecommerce business should consider professional accounting support when its transaction volume, inventory, channels, processors, currencies, sales tax registrations, payroll, financing, or reporting needs become difficult to manage reliably. Complexity is usually a better trigger than revenue alone.

Common triggers include:

• Selling through multiple platforms
• Rapid transaction growth
• Growing inventory
• Amazon FBA activity
• Several payment processors
• Multistate sales tax registrations
• International sales
• Foreign currency
• Employees
• Significant advertising spend
• Debt or outside financing
• Tax notices
• Unreconciled platform balances
• Preparing for investment
• Preparing for sale
• Entity restructuring
• Cash flow pressure despite revenue growth

How KP Accounting Helps Ecommerce Businesses

KP Accounting helps Shopify, Amazon, and multichannel sellers reconcile payouts, organize fees and refunds, account for inventory, prepare reliable reports, plan taxes, manage payroll, analyze budgets, and forecast cash flow. The goal is stronger financial visibility, better tax readiness, and more informed business decisions.

Ecommerce Bookkeeping

KP Accounting can help create:

• Reconciled payouts
• Organized fees
• Clear refund records
• Supported processor balances
• More reliable monthly closes
• Better tax readiness

Shopify Accounting

Support can include:

• Recording sales
• Separating sales tax
• Recording refunds
• Tracking shipping
• Categorizing fees
• Reconciling Shopify Payments
• Reconciling third-party gateways

Amazon Seller Accounting

Support can include:

• Settlement reconciliation
• Fee categorization
• Refund tracking
• Reserve tracking
• Reimbursement recording
• FBA reporting
• Marketplace profitability

Inventory and Cost of Goods Sold

Structured inventory support can provide:

• More reliable gross margin
• Better inventory visibility
• Consistent cost treatment
• Improved product profitability analysis

Financial Reporting

Reports can provide clearer insight into:

• Channels
• Products
• Margins
• Inventory
• Sales tax
• Cash flow
• Debt
• Operating expenses

Budget Analysis

Budget reporting can improve control over:

• Advertising
• Fulfillment
• Software
• Payroll
• Shipping
• Inventory purchases

Tax Planning

Tax planning can support:

• Estimated payments
• Documentation
• Entity analysis
• Inventory decisions
• Equipment purchases
• Year-end planning

Payroll Services

For ecommerce businesses with employees, KP Accounting can assist with:

• Payroll processing
• Payroll liability tracking
• Financial statement coordination
• Employee cost reporting

CPA Consulting

CPA consulting can support decisions involving:

• New channels
• Inventory expansion
• Financing
• Hiring
• Entity structure
• Warehousing
• Business growth
• Potential sale

KP Accounting serves ecommerce businesses in Somerville, New Jersey; Allentown and Walnutport, Pennsylvania; and other communities throughout New Jersey and Pennsylvania.

FAQs

Build a Stronger Financial System for Your Ecommerce Business

Ecommerce growth should not be measured through sales dashboards alone.

A financially reliable online business must understand:

• Why payouts differ from sales
• Why sales differ from profit
• Why profit differs from cash
• How inventory affects gross margin
• How marketplace fees affect channel performance
• How refunds and chargebacks affect revenue
• Why sales tax belongs outside operating income
• Which products and channels actually create value

KP Accounting helps Shopify sellers, Amazon businesses, and multichannel retailers improve ecommerce bookkeeping, payout reconciliation, inventory accounting, financial reporting, tax planning, budgeting, payroll, and cash flow oversight.

Schedule an Ecommerce Accounting Consultation

Editorial Disclaimer

This article provides general educational information and does not constitute individualized tax, legal, sales tax, payroll, inventory, nexus, or financial advice. Sales tax obligations, inventory treatment, deduction eligibility, entity treatment, and filing requirements depend on the seller’s facts, platforms, inventory locations, states, business structure, and current federal, New Jersey, Pennsylvania, and other applicable laws. Ecommerce businesses should consult qualified professionals before acting.