E-commerce Sellers: Accounting Software for Multi-Channel Books

Accounting Software for E-commerce Sellers: Reconcile Shopify, Amazon, and Etsy Payouts to Real COGS and Sales Tax

If you sell on Shopify, Amazon, Etsy, eBay, or Walmart, your bookkeeping pain is not data entry - it's reconciliation. Each platform deposits a net payout that already has fees, refunds, chargebacks, marketplace-collected sales tax, and shipping label costs netted out. Your bank shows one number; your gross sales are a different number; your taxable income is a third number. On top of that, you need to track inventory cost per SKU so COGS hits the P&L in the period the unit actually sold, not when you bought the case from your supplier. FreshLedger Pro is a Windows desktop double-entry system built for sellers who want to own their books and stop paying a monthly SaaS bill that scales with their order count. You import a CSV from each channel, map the columns once, and reconcile the payout to gross sales, fees, refunds, and sales tax in a single journal entry.

Why FreshLedger fits E-commerce Sellers

Four FreshLedger Pro capabilities map directly to how an e-commerce seller actually closes the month. First, CSV/OFX/QFX/QBO import handles any platform. Shopify Payments payout reports, Amazon Settlement reports (the long one with 30+ transaction types), Etsy's monthly statement, PayPal activity, Stripe balance transactions - they all download as CSV. You map columns to accounts once per channel, save the mapping, and reuse it every month. The import creates a split journal entry: debit cash for the net payout, credit gross sales, debit merchant fees, debit refunds, credit sales tax payable. That's the entry your CPA actually wants to see. Second, inventory is tracked at unit cost. When you receive a PO from your supplier, you enter quantity and landed cost (product + freight + duty allocated per unit). When a sale imports, FreshLedger relieves inventory at average cost or FIFO and posts COGS to the period of the sale. Your gross margin on the P&L is real, not a guess. Third, sales tax liability is a real GL account, not a spreadsheet. Marketplace-facilitated tax (Amazon, Etsy, eBay collect and remit for you in most states) is tracked separately from tax you collected on your own Shopify store and still owe to the state. When you file your state return, the liability account is the number. Fourth, MACRS depreciation handles the warehouse side of the business. The forklift, the shelving, the label printers, the laptop, the leasehold improvements on your fulfillment space - all of it goes on the asset register with the right class life (5-year for computers, 7-year for office furniture, 15-year for qualified improvement property), the right convention (half-year or mid-quarter per IRS Pub 946), and Section 179 or bonus depreciation elected per asset where it makes sense.

How you'll actually use it

Workflow 1: Monthly Shopify reconciliation. On the first of the month, download the Shopify Payments payout CSV and the orders export. Import the payout CSV into FreshLedger - the saved mapping splits the deposit into gross sales (credit 4000-Sales), processing fees (debit 6100-Merchant Fees), refunds (debit 4900-Refunds), and sales tax collected (credit 2200-Sales Tax Payable). Open the orders export, run the inventory relief routine: each SKU sold is matched to its on-hand cost layer, COGS posts to 5000, inventory credits out of 1300. Total time once the mapping is built: about 20 minutes for a store doing $50K/month. Workflow 2: Amazon settlement close. Amazon's settlement report is denser - FBA fees, storage fees, long-term storage fees, removal fees, advertising charges, reserves. Import the settlement CSV. The mapping splits across roughly a dozen accounts: 4000-Sales, 6110-Amazon Referral Fees, 6120-FBA Fulfillment Fees, 6130-Storage Fees, 6200-PPC Advertising, 1310-Amazon Reserve (asset, since it's your money they're holding), 2200-Sales Tax Payable (marketplace-collected, tracked but not owed by you). The reserve account reconciles to Amazon's reported reserve balance at month end. Workflow 3: Year-end inventory and depreciation close. Run a physical count, enter shrinkage adjustments against 5100-Inventory Shrinkage. Run the depreciation schedule: FreshLedger calculates current-year MACRS for every asset on the register. The $4,200 label printer you bought in Q2 took half-year convention, 5-year class, and you elected Section 179 to expense the full amount - it shows on Form 4562 line 6 with the carryforward calculated if your business income limited the deduction. Print the depreciation schedule and hand it, plus a backup of the company file, to your CPA's free Accountant Edition.

Industry-specific accounting handled

E-commerce sellers live with a specific set of accounting and tax rules. Inventory must be tracked under IRC Section 471 unless you qualify for the small-business taxpayer exception under Section 471(c) (under the inflation-adjusted gross receipts threshold, currently around $30M). Even if you qualify to expense inventory as non-incidental materials and supplies, most lenders and serious CPAs still want a real perpetual inventory and COGS calculation. Cost methods - FIFO, weighted average, or specific identification - must be applied consistently; LIFO is rare in e-commerce and requires Form 970. Sales tax post-Wayfair is the other big one. You have economic nexus in any state where you cross the threshold (commonly $100K in sales or 200 transactions, varies by state). Marketplace facilitator laws shift the collection burden to Amazon, Etsy, eBay, and Walmart in most states, but you still report those sales on your state return as gross sales with a marketplace deduction. Direct sales through your own Shopify or WooCommerce store remain your responsibility to collect and remit. For entity tax, most e-commerce sellers are S-corps or single-member LLCs filing Schedule C. COGS flows to Form 1125-A (for 1120-S) or Schedule C Part III. Section 179 and bonus depreciation elections happen on Form 4562. Contractors paid $600+ for services (photographers, VAs, designers) get 1099-NEC.

The pricing math for E-commerce Sellers

A seller doing $30K-$500K/year in revenue typically pays $30-$70/month for a cloud bookkeeping subscription plus $20-$50/month for an inventory or channel-sync add-on. Call it $80/month conservatively - $960/year, every year, forever, with price increases. FreshLedger Pro is $799 one-time. If you run payroll for yourself as an S-corp owner or for a warehouse employee, the optional payroll tax table update is $99/year - only needed in years you actually run payroll. Year one: $799 (or $898 with payroll). Year two onward: $0, or $99 if you need fresh payroll tables. By year three you're ahead by roughly $2,000, and the gap widens every year. You also keep working if you cancel nothing, because there is nothing to cancel.

Frequently asked questions

Does FreshLedger Pro connect directly to Shopify or Amazon?

No. There is no live API integration with sales channels. The workflow is: download the payout or settlement CSV from Shopify, Amazon Seller Central, Etsy, eBay, PayPal, or Stripe, then import it into FreshLedger. You map the columns to GL accounts the first time and save the mapping; subsequent imports are a few clicks. For most sellers this takes 15-30 minutes per channel per month. If you want fully automated channel sync with no CSV step, a tool like A2X feeding into a cloud ledger is a better fit than FreshLedger.

How does FreshLedger handle inventory and COGS for a multi-SKU store?

Inventory is tracked per SKU at unit cost using FIFO or weighted average - you pick the method and apply it consistently, as the IRS requires. When you receive a purchase order, you enter quantity and landed cost (you can allocate freight and duty across units). When sales import, the system relieves inventory at the appropriate cost layer and posts COGS to the sale period. At year end you run a physical count and post shrinkage adjustments. The result is a real gross margin on your P&L and a defensible inventory number on the balance sheet.

How do I handle marketplace-collected sales tax versus tax I collect myself?

Use separate GL accounts. Marketplace-facilitated tax (Amazon, Etsy, eBay, Walmart collect and remit in most states) posts to a tracking account that nets to zero - you record it as collected and immediately as remitted by the marketplace. Tax you collect on your own Shopify or WooCommerce store posts to 2200-Sales Tax Payable as a real liability that you remit on your state return. When you file, the liability account balance is the number you owe. Both flows are captured in your CSV import mapping once you set it up.

Can my CPA review my books at year end?

Yes. FreshLedger Pro includes a free Accountant Edition for your CPA. You send them a backup of your company file, they open it in Accountant Edition, make adjusting journal entries (depreciation true-ups, accrual adjustments, owner distributions, M-1 book-to-tax differences), and send the file back. They can also export trial balance, general ledger, and the depreciation schedule directly to whatever tax prep software they use. No subscription, no per-user fee for the accountant.

I'm an S-corp owner taking a reasonable salary. Does FreshLedger handle that?

Yes, with the $99/year payroll tax table update. You set yourself up as an employee with a W-4 (2020 or later version), run payroll on whatever schedule you want, and FreshLedger calculates federal withholding, Social Security, Medicare, and federal unemployment. It produces the numbers for Form 941 quarterly and Form 940 annually, and W-2s at year end. State withholding and SUTA are supported for most states. The $99 update is only required in years you actually run payroll - if you skip a year, you skip the fee.