How do I set up ecommerce bookkeeping for matching processor fees and recording inventory purchases?

Here’s a practical way to set up ecommerce bookkeeping so you can match processor fees correctly and record inventory purchases cleanly.

1) Set up the right accounts first

You’ll usually want these accounts in your chart of accounts:

Bank / clearing accounts

• Merchant clearing account (for Stripe/PayPal/Amazon/etc. payouts)
• Checking account

Income accounts

• Sales revenue
• Sales returns/refunds (optional but recommended)
• Shipping income (if you charge customers separately)
• Discounts/sales promotions (optional)

Expense accounts

• Merchant processing fees
• Inventory purchases / COGS
• Freight-in / shipping on inbound inventory (if you capitalize it into inventory or track separately)
• Duties/import fees (if applicable)
• Packaging supplies (if material)

Balance sheet accounts

• Inventory
• Accounts payable
• Sales tax payable (if you collect sales tax)
• Prepaid expenses if needed

---

2) Use a clearing account for processor payouts

This is the easiest and cleanest method.

Why?

Processors usually deposit:

• gross sales
• minus transaction fees
• minus refunds/chargebacks
• minus reserves or adjustments

If you book the deposit directly to revenue, your sales and fees get muddied. Instead:

Workflow

1. Record the sale gross
   • Debit: Processor clearing account
   • Credit: Sales revenue
2. Record processor fees
   • Debit: Merchant processing fees
   • Credit: Processor clearing account
3. Record refunds/chargebacks
   • Debit: Refunds/returns
   • Credit: Processor clearing account
4. Record the net payout when it hits the bank
   • Debit: Checking account
   • Credit: Processor clearing account

The clearing account should ideally reconcile to zero after all related entries are posted for that payout period.

---

3) Match processor fees to payouts

There are two common ways:

A. Record fees per order

Best if your accounting/software integration provides transaction-level detail.

Example:

• Customer order: $100
• Processor fee: $3
• Net payout: $97

Entries:

• Dr Processor clearing $100
• Cr Sales revenue $100

Then:

• Dr Merchant processing fees $3
• Cr Processor clearing $3

Then when payout arrives:

• Dr Checking $97
• Cr Processor clearing $97

B. Record fees as a batch per payout

Best for higher volume ecommerce stores.

For a payout statement covering many transactions:

• Total gross sales = $5,000
• Fees = $175
• Refunds = $100
• Net payout = $4,725

Entries:

• Dr Processor clearing $5,000

• Cr Sales revenue $5,000

• Dr Merchant processing fees $175

• Cr Processor clearing $175

• Dr Refunds/returns $100

• Cr Processor clearing $100

• Dr Checking $4,725

• Cr Processor clearing $4,725

This keeps your bank reconciliation much cleaner.

---

4) Record inventory purchases correctly

Inventory should usually be recorded as an asset first, not an immediate expense, if you’re using accrual accounting.

When you buy inventory:

If you buy 100 units for $10 each:

• Dr Inventory $1,000
• Cr Cash or Accounts Payable $1,000

When you pay freight/import to bring inventory in:

Depending on your policy:

• Either add it to inventory cost:
  • Dr Inventory
  • Cr Cash/AP
• Or track it separately if you expense it differently, but many businesses capitalize inbound freight into inventory cost.

When inventory is sold:

Move the cost out of inventory into cost of goods sold:

• Dr Cost of Goods Sold
• Cr Inventory

Example: If those 100 units sold and unit cost was $10:

• Dr COGS $1,000
• Cr Inventory $1,000

---

5) Best practice: keep inventory purchases separate from operating expenses

Don’t put product purchases into “Supplies” or “Office expense” unless they are truly consumables.
For ecommerce, product you intend to resell should go to:

• Inventory when purchased
• COGS when sold

This is important for:

• accurate gross profit
• correct inventory valuation
• cleaner tax reporting

---

6) If you buy inventory on credit

Example:

• Inventory received: $2,500
• Vendor invoice due later

Entry:

• Dr Inventory $2,500
• Cr Accounts Payable $2,500

When you pay the vendor:

• Dr Accounts Payable $2,500
• Cr Checking $2,500

---

7) How refunds and returns affect inventory

If you refund a customer and the item comes back in resellable condition, you may need to:

1. Reverse part of revenue/COGS
2. Put the item back into inventory

Example:

• Refund sale amount: $50
• Product cost: $20
• Item returned in good condition

Entries:

• Dr Sales returns/refunds $50

• Cr Cash/processor clearing $50

• Dr Inventory $20

• Cr COGS $20

If the item is damaged or unsellable, it may go to:

• shrinkage
• write-off
• inventory loss expense

---

8) Simple monthly close routine

A good ecommerce monthly bookkeeping process looks like this:

1. Import all processor payout statements
2. Post sales gross to processor clearing
3. Post fees, refunds, chargebacks, reserves
4. Reconcile payout deposits to the bank
5. Record inventory purchases and vendor bills
6. Book COGS from inventory system or periodic counts
7. Reconcile inventory balance to your inventory report
8. Review gross margin and processing fee rate

---

9) Example month-end flow

Sales

• Gross sales: $20,000
• Refunds: $1,000
• Processor fees: $700
• Net payouts to bank: $18,300

Inventory purchases

• Bought inventory: $8,000 on credit
• Paid inbound freight: $400 cash

Entries

Sales

• Dr Processor clearing $20,000
• Cr Sales revenue $20,000

Refunds

• Dr Refunds/returns $1,000
• Cr Processor clearing $1,000

Fees

• Dr Merchant processing fees $700
• Cr Processor clearing $700

Payout

• Dr Checking $18,300
• Cr Processor clearing $18,300

Inventory purchase

• Dr Inventory $8,000
• Cr Accounts payable $8,000

Freight

• Dr Inventory $400
• Cr Checking $400

---

10) Tools that help

If you use:

• QuickBooks Online
• Xero
• A2X
• Link My Books
• inventory tools like Cin7, Katana, Skubana, NetSuite

these can automate:

• payout reconciliation
• fee categorization
• inventory sync
• COGS posting

---

11) Common mistakes to avoid

• Booking net payouts directly to sales revenue
• Expensing inventory purchases immediately
• Ignoring processor fees or bundling them into sales
• Not reconciling clearing accounts monthly
• Forgetting sales tax payable
• Not tracking refunds/chargebacks separately
• Not capitalizing inbound freight when appropriate

If you want, I can give you:

1. a sample chart of accounts for an ecommerce business,
2. QuickBooks journal entry examples, or
3. a step-by-step workflow for Shopify + Stripe + QuickBooks.