FOR E-COMMERCE

Run your e-commerce business on numbers, not guesses

Track inventory costs, sales tax, and profitability across channels.

Last reviewed 2026-05-11

Built for E-commerce

Multi-Channel Reconciliation

Automatically import and reconcile transactions from Shopify, Amazon, WooCommerce, eBay, Walmart, and TikTok Shop into a single ledger.

True Product Profitability

Calculate per-SKU margins by factoring in COGS, shipping, packaging, marketplace fees, returns, and advertising spend.

Sales Tax Nexus Tracker

Monitor your sales volume by state and alert you when you approach economic nexus thresholds requiring new tax registrations.

Inventory Valuation Engine

Track inventory costs using FIFO, LIFO, or weighted average methods with automatic adjustments for damaged, returned, or obsolete stock.

Amazon Settlement Parser

Break each biweekly Amazon payout into gross sales, FBA fees, referral fees, refunds, reimbursements, and chargebacks — posted as discrete entries instead of one mystery deposit.

Ad Spend ROAS by Channel

Pull Meta, Google, and TikTok ad spend in alongside per-channel revenue so contribution margin and ROAS are visible on every dashboard.

Financial Challenges for E-commerce

  • Reconciling sales, fees, refunds, and payouts from multiple platforms like Shopify, Amazon, and Etsy
  • Calculating true product profitability after shipping, packaging, marketplace fees, and return costs
  • Managing multi-state sales tax obligations that change as you cross nexus thresholds
  • Tracking inventory valuation accurately using FIFO or weighted average across multiple warehouses
  • Reconciling Amazon FBA settlement reports where one biweekly payout covers thousands of orders, fees, and reimbursements
  • Handling chargebacks, A-to-z claims, and gift cards in a way that does not corrupt your revenue or COGS
  • Accounting for inventory in transit, 3PL warehouses, and FBA all at once

E-commerce businesses generate enormous volumes of financial transactions across multiple platforms, each with its own fee structures, payout schedules, and reporting formats. A single Shopify store selling on Amazon, Etsy, and a few wholesale accounts can produce thousands of line items per month that need to be reconciled, categorized, and reported accurately. Add in returns, chargebacks, gift cards, multi-state sales tax, FBA inventory sitting in a warehouse in Pennsylvania you have never visited, and ad spend across three platforms, and the books quickly become impossible to keep accurate by hand.

FiscalInsights cuts through the complexity with automated multi-channel reconciliation. Our platform pulls transaction data from all your selling channels, matches payouts to bank deposits, and calculates true product-level profitability after all fees, shipping costs, returns, and advertising. You will see exactly which products and channels are driving profit and which are quietly losing money once everything below revenue is correctly assigned. For brands running a hybrid DTC plus marketplace model, the platform consolidates everything into a single set of P&Ls and a single sales-tax view.

The chart of accounts for an e-commerce business needs careful structure. Revenue should be split by channel so contribution margin is meaningful. COGS should pull straight from a perpetual inventory system so it matches each sale. Direct selling costs — payment processor fees, marketplace referral fees, FBA fulfillment, shipping, packaging — belong above the gross-margin line so you can see real product economics. Advertising and marketing typically sit just below gross margin in a contribution-margin layout that DTC brands love. On the balance sheet, you need inventory accounts split by location (warehouse, FBA, 3PL, in transit), deferred revenue for gift cards and pre-orders, and a sales tax payable account per state. FiscalInsights ships a DTC and marketplace template and our AI extends it as new channels and SKUs appear.

AI bookkeeping changes the e-commerce workflow in three important ways. First, settlement reports from Shopify, Amazon, and Stripe are decomposed automatically into the right ledger accounts the moment they arrive — no more month-end scramble to figure out what was in that Amazon biweekly deposit. Second, COGS is recognized at the exact moment of sale using your chosen valuation method, so gross margin is always live, and inventory shrinkage shows up as soon as a cycle count finds it. Third, the system continuously checks nexus exposure across every state and flags newly created obligations days after they happen, not months later when penalties have started accumulating. Scale your store confidently knowing your numbers are always accurate, audit-ready, and decision-ready.

Metrics E-commerce Should Track

Gross margin per SKU and per channel
Contribution margin after ad spend
Inventory turnover (annual COGS / average inventory)
Return rate by SKU
Customer acquisition cost (CAC) vs. lifetime value (LTV)

Tax Deductions for E-commerce

Cost of goods sold
The wholesale cost of inventory sold, plus inbound freight and import duties, is deductible against revenue using your elected valuation method.
Marketplace and payment processing fees
Shopify, Amazon referral, eBay final value, Etsy, Stripe, and PayPal fees are all ordinary and necessary business expenses.
Shipping and fulfillment
Outbound shipping, packaging materials, 3PL pick-and-pack charges, and FBA fees are deductible — track them above the gross-margin line.
Advertising spend
Meta, Google, TikTok, influencer fees, and affiliate commissions are deductible the moment incurred regardless of cash timing.
Section 179 equipment
Photography equipment, packing stations, label printers, and warehouse racking can be expensed in the year of purchase.
Inventory write-downs
Obsolete, damaged, or unsellable inventory can be written down to net realizable value when supported by a documented cycle count or disposal record.

Deductions are general guidance per IRS Publication 535. Confirm with your CPA.

Our best-selling SKU had a 38 percent gross margin on paper. After we layered in Amazon fees, return shipping, and storage, it was running 11 percent. We repriced it the next week and the brand finally started compounding cash.

Jenna L., founder of a home-goods DTC brand, Denver CO

FiscalInsights vs QuickBooks for E-commerce

QuickBooks needs three paid add-ons (A2X, Webgility, TaxJar) to do what FiscalInsights ships native — multi-channel reconciliation, per-SKU profitability, and nexus monitoring under one roof.

Read the full comparison →

What does it cost for e-commerce?

Starter
$0/mo
Single user · 50 transactions/mo
Pro
$19/mo
AI bookkeeping + cash flow forecasting
Team
$49/mo
Up to 5 users · multi-entity
Full pricing details →

Frequently Asked Questions

How do I reconcile Shopify payouts with my bank account?

FiscalInsights connects to both Shopify and your bank, then automatically matches payout deposits against the underlying orders. It separates gross sales, processing fees, refunds, and chargebacks into the right accounts so you can reconcile to the penny without manual spreadsheet work. The same logic applies to Amazon, eBay, and Stripe — each platform settlement becomes a clean set of journal entries instead of one mystery deposit.

How do I know if I have sales tax nexus in a state?

Our nexus tracker monitors your sales volume and transaction count by state in real time. When you approach common economic nexus thresholds (often $100,000 in sales or 200 transactions, but the rules vary by state), you get alerts with specific guidance on registration requirements and filing deadlines. The tool also tracks physical nexus triggers like FBA inventory in a new state warehouse, which is one of the most commonly missed nexus events.

What is the best inventory valuation method for e-commerce?

Most e-commerce businesses use FIFO (first in, first out) because it matches the natural flow of goods and is accepted by both GAAP and the IRS. Weighted average is simpler when you buy the same SKU at varying costs and treat the pool as fungible. LIFO is rarely used in retail and is prohibited under IFRS. FiscalInsights supports all three, calculates the tax impact of each method for your situation, and your CPA picks the one to elect on Form 970 if needed.

How does FiscalInsights handle Amazon FBA reimbursements?

Amazon FBA reimbursements (for lost or damaged inventory, overcharged fees, customer returns Amazon kept) are tracked as separate revenue items on each settlement so they do not get buried in net payout. The system also flags reimbursement-eligible events that Amazon has not yet processed — particularly inventory lost in transit and refunded orders where the unit was never returned — which often add up to a meaningful recovery opportunity.

How should I account for Shopify gift cards?

When a customer buys a gift card, the cash you receive is a liability (deferred revenue), not income — you have not yet delivered any goods. Revenue is recognized when the gift card is redeemed against a product order. FiscalInsights tracks the outstanding gift card liability automatically, recognizes breakage on a defensible schedule, and prevents the common bookkeeping error of recording gift-card sales as immediate revenue.

Ready to automate your finances?

Built for e-commerce who want to spend less time on bookkeeping.

Start Free Trial