E-commerce sales can look perfectly healthy inside Shopify or Amazon while the accounting records tell a different story. Sales may be recorded through multiple reports, payment processors, marketplaces, refunds, fees, shipping charges, taxes, and settlement deposits. When these pieces are not recorded and reconciled correctly, the books can show inaccurate revenue, duplicate income, unexplained deposits, incorrect fees, or inventory-related balances.
This guide explains the most common bookkeeping issues found in Shopify and Amazon records, how those issues affect the financial statements, and how a careful cleanup process can trace each amount back to reliable source reports before corrections are made.
What You’ll Learn
⦁ Why Shopify and Amazon sales can differ from the amounts recorded in the books
⦁ How gross sales, refunds, discounts, fees, taxes, and net settlements interact
⦁ How duplicate sales and missing transactions happen
⦁ How to reconcile marketplace settlements to the bank
⦁ How to identify fee, refund, and chargeback discrepancies
⦁ How inventory and cost-of-goods-sold records can become disconnected from sales
⦁ What to check before deleting, editing, or re-entering e-commerce transactions
⦁ A practical cleanup workflow for keeping e-commerce books accurate
INFOGRAPHIC 1 — The E-commerce Sales-to-Bank Flow
Image Generation Prompt: Clean 3D accounting infographic: Customer Order → Shopify/Amazon Sale → Payment or Marketplace Clearing → Fees & Refunds → Net Settlement → Bank Deposit → QuickBooks/Xero. Teal and green accents, navy text, white background, clear arrows, calculator and reconciliation/check icons, premium professional bookkeeping style, no clutter.
1. Shopify or Amazon Sales Are Recorded Using the Wrong Amount
A common e-commerce bookkeeping problem is recording the bank deposit as sales income. Marketplace platforms often separate gross sales from refunds, discounts, processing fees, shipping, taxes, and other adjustments. The amount that reaches the bank may therefore be lower than the original customer sales amount.
Common examples:
⦁ A net Shopify payment is recorded as sales instead of separating the related fees.
⦁ An Amazon settlement is posted directly to income even though the settlement includes fees, refunds, and other adjustments.
⦁ Gross sales are recorded, but the corresponding refunds or marketplace deductions are not recorded.
⦁ A bank deposit is entered as income even though the underlying sale has already been recorded from the e-commerce platform.
INFOGRAPHIC 2 — Gross Sales vs. Net Settlement
Image Generation Prompt: 3D before-and-after accounting visual: GROSS SALES $10,000 → Refunds $500 → Platform/Processing Fees $300 → Other Adjustments $200 → NET BANK DEPOSIT $9,000. Emphasize that the net deposit is not automatically total sales. Teal, green, navy and white palette.
2. Duplicate Sales or Duplicate Payouts Inflate Revenue
Duplicate entries can occur when e-commerce transactions are imported through an integration and then manually entered again from marketplace or bank reports. The same economic activity may appear in more than one data source, but it should not be counted twice.
⦁ Shopify sales are imported automatically and then entered again from a monthly sales report.
⦁ Amazon settlement activity is recorded and the related bank deposit is also categorized as new sales income.
⦁ A CSV upload duplicates transactions already synchronized through an integration.
⦁ The same payout is entered once as a marketplace settlement and again from the bank feed.
INFOGRAPHIC 3 — Duplicate Transaction Detection
Image Generation Prompt: Professional 3D accounting scene with two identical Shopify/Amazon payout records pointing to the same bank deposit, a red DUPLICATE warning, then a green corrected path showing ONE source transaction matched to ONE settlement. Magnifying glass and checkmark; teal/green/navy/white palette.
3. Refunds, Returns, and Chargebacks Are Not Properly Recorded
Refunds and returns reduce the amount ultimately retained from customers, but they may be reported separately from original sales. If refunds are missing, delayed, duplicated, or recorded against the wrong period, revenue can be misleading.
Review:
⦁ Shopify refunds and returned orders
⦁ Amazon refunds and customer returns
⦁ Chargebacks or payment disputes
⦁ Refund-related fees or adjustments
⦁ Refunds recorded twice or not connected to the original sale
Cleanup approach: Compare refund and return reports with the accounting records and settlement reports. Trace unusual refunds to the original order or settlement before making a correction.
INFOGRAPHIC 4 — Sale-to-Refund Relationship
Image Generation Prompt: 3D visual: Customer Order $500 → Sale Recorded $500 → Customer Refund $100 → Net Sales Effect $400, with a separate settlement panel. Clearly label SALE, REFUND, and NET. Green correct flow and one red warning for an unmatched refund.
4. Payment Processing and Marketplace Fees Are Missing or Misclassified
Payment and marketplace platforms may deduct transaction fees, processing fees, selling fees, fulfillment-related charges, advertising charges, or other platform expenses before money reaches the bank. If the bookkeeper records only the net deposit, expenses can be understated and sales may be distorted.
⦁ Fees are included in a net payout but never recorded separately.
⦁ Fees are posted to the wrong expense account.
⦁ Different Amazon fee types are grouped into an unclear account without supporting detail.
⦁ Processing fees are duplicated because both the platform report and bank transaction are recorded independently.
Cleanup approach: Use the platform settlement or transaction report as the supporting source, identify the fee components, and map them consistently to the appropriate accounts.
INFOGRAPHIC 5 — Where Did the Missing Money Go?
Image Generation Prompt: 3D settlement breakdown: Customer Payments $5,000 → Platform Fees $250 → Refunds $300 → Other Adjustments $50 → Bank Deposit $4,400. Show each deduction separately and end with a green reconciliation check. Premium finance design.
5. Bank Deposits Do Not Match Shopify or Amazon Payout Reports
The bank usually receives a settlement or payout rather than each individual customer transaction. Because the platform may combine many orders and deductions into one payout, the bank amount must be reconciled to the corresponding settlement detail.
⦁ Settlement or payout date
⦁ Gross transaction amount
⦁ Refunds and returns
⦁ Platform and payment fees
⦁ Taxes or other adjustments included in the report
⦁ Payout amount actually sent to the bank
⦁ Bank deposit date and amount
INFOGRAPHIC 6 — Payout-to-Bank Reconciliation
Image Generation Prompt: Clean 3D workflow: Shopify/Amazon Settlement Report → Gross Transactions → Refunds → Fees → Adjustments → Net Payout → Bank Deposit. Show matching amounts with a large green check and a red warning branch for a mismatch. Minimal professional finance design.
6. Inventory and Cost of Goods Sold Do Not Agree With E-commerce Sales
E-commerce bookkeeping can look correct on the sales side while inventory and cost of goods sold remain inaccurate. This can happen when sales are recorded without corresponding inventory movement, inventory purchases are expensed incorrectly, or marketplace fulfillment and inventory reports are not considered in the accounting workflow.
Common signs:
⦁ Inventory balance appears unusually high or negative.
⦁ Cost of goods sold does not move reasonably with sales volume.
⦁ Inventory purchases are posted directly to expense when they should be tracked as inventory.
⦁ Shopify/Amazon sales are recorded, but inventory records are not updated consistently.
Cleanup approach: Compare inventory reports, purchase records, sales volume, and accounting inventory/COGS balances. Do not force inventory to a desired number without tracing the underlying transactions and the business’s accounting method.
INFOGRAPHIC 7 — Sales → Inventory → COGS Connection
Image Generation Prompt: Professional 3D flow: Inventory Purchased → Inventory on Hand → Customer Sale → Inventory Decrease → Cost of Goods Sold. Add a Shopify/Amazon order screen and simple inventory dashboard. Green checkmarks for connected records and a red broken-link icon for missing activity.
7. How to Investigate an E-commerce Bookkeeping Problem
Before changing transactions, trace the complete transaction trail.
- Identify the platform: Shopify, Amazon, or another connected sales channel.
- Determine the reporting period and accounting period being reviewed.
- Obtain relevant sales, settlement/payout, refund, fee, and bank reports.
- Compare platform totals with what has been recorded in the accounting system.
- Trace each significant payout to the corresponding bank deposit.
- Check for duplicate imports, manual entries, and bank-feed transactions.
- Review refunds, returns, chargebacks, and fees separately.
- Review inventory and COGS where the bookkeeping workflow includes inventory.
- Document the root cause before making corrections.
- Reconcile again after the correction and review the financial statements.
INFOGRAPHIC 8 — E-commerce Cleanup Workflow
Image Generation Prompt: Premium 3D workflow: COLLECT REPORTS → VERIFY SALES → CHECK REFUNDS → REVIEW FEES → MATCH PAYOUTS → RECONCILE BANK → REVIEW INVENTORY/COGS → CORRECT ROOT CAUSE → RECHECK REPORTS. Clean horizontal flow, teal/green arrows, navy text, white background.
8. A Simple Example: Shopify Sales vs. Bank Deposit
Suppose Shopify reports $8,000 of customer sales during a period. The platform also shows $400 of refunds and $200 of processing fees. The business therefore receives a net amount of $7,400 through the payout.
If the bookkeeper records only the $7,400 bank deposit as sales, revenue may be understated while refunds and processing fees are missing. If the $8,000 sales were already imported and the $7,400 deposit is also categorized as new income, revenue may instead be overstated.
The correct cleanup depends on how the original transactions were recorded. The bookkeeper should trace the platform report, settlement detail, and bank deposit together, then correct the underlying workflow rather than simply forcing the bank deposit to equal sales.
INFOGRAPHIC 9 — Before vs. After Cleanup
Image Generation Prompt: Two-panel 3D comparison. BEFORE: Shopify Sales $8,000, Refunds missing, Fees missing, Bank Deposit $7,400 categorized as Sales. AFTER: Gross Sales $8,000, Refunds $400, Fees $200, Net Payout $7,400, Bank matched and reports reconciled. Red warnings before, green checks after.
9. Checks After the Cleanup
⦁ Sales are recorded from the appropriate source without duplication.
⦁ Shopify/Amazon payouts agree with the related bank deposits.
⦁ Refunds and returns are properly reflected.
⦁ Platform and payment-processing fees are recorded consistently.
⦁ No duplicate sales, payouts, or bank-feed transactions remain.
⦁ Clearing or payment gateway accounts have no unexplained balances.
⦁ Inventory and COGS balances are reviewed when applicable.
⦁ Corrections are supported by platform reports, settlement records, bank statements, or other reliable documentation.
⦁ Financial statements do not show unexpected changes after cleanup.
10. What Bookkeepers Should Avoid
⦁ Do not treat every bank deposit as new sales income without checking its source.
⦁ Do not record both a marketplace payout and its bank deposit as separate sales.
⦁ Do not delete duplicate transactions before confirming which entry is the valid source.
⦁ Do not ignore refunds simply because the original sale was already recorded.
⦁ Do not bury all marketplace deductions in an unexplained account.
⦁ Do not force inventory or COGS to match a target balance without tracing the underlying records.
⦁ Do not make a journal-entry plug simply to make bank or platform totals appear to match.
11. Quick E-commerce Cleanup Checklist
⦁ ☐ Identify all sales channels
⦁ ☐ Confirm reporting period
⦁ ☐ Obtain sales/order report
⦁ ☐ Obtain settlement/payout report
⦁ ☐ Review refunds and returns
⦁ ☐ Review processing/marketplace fees
⦁ ☐ Match payouts to bank deposits
⦁ ☐ Check for duplicate imports
⦁ ☐ Review clearing/payment accounts
⦁ ☐ Review inventory and COGS when applicable
⦁ ☐ Correct the underlying issue
⦁ ☐ Reconcile and review financial statements
⦁ ☐ Document the cleanup
When Shopify or Amazon sales look right but the books do not, the problem is often not a single transaction—it is the connection between orders, refunds, fees, settlements, bank deposits, and accounting records. A reliable cleanup process traces those components back to their source, identifies duplicates or missing activity, corrects the underlying workflow, and then verifies the final numbers.
For e-commerce businesses, accurate bookkeeping is more than recording deposits. It is about making sure every sale, fee, refund, payout, and inventory-related movement is represented correctly so the financial statements can be trusted.
Need help cleaning up your Shopify or Amazon books? Let Accounting Touch review the underlying records and bring your e-commerce bookkeeping back in sync.