How do I track fees from Shopify, Amazon, and PayPal?
The biggest mistake is recording only what hits your bank account. When you sell $500 worth of products and receive a $462 deposit, your books need to show $500 in revenue and $38 in fees. Recording just the $462 understates your actual sales and hides what you’re really paying these platforms.
Each platform provides reports that break down exactly what happened. Shopify has payout reports under Settings that show gross sales, refunds, and fees for each payout cycle. Amazon Seller Central has Settlement Reports that detail every referral fee, FBA fee, and storage charge. PayPal transaction reports show the fee taken from each payment.
Create separate expense accounts for platform fees. At minimum, have one account for payment processing fees and another for marketplace fees. Some businesses break it down further by platform. The right level of detail depends on how much you’re selling and whether you need to compare costs across channels.
When you record a payout, the entry should debit your bank account for the deposit amount, debit your fee expense account for the fees withheld, and credit revenue for the gross sale amount. This keeps your books accurate and ensures you’re capturing every fee as a deductible expense.
If you’re processing significant volume, apps like A2X, Synder, or Link My Books connect your platforms directly to QuickBooks and automate this breakdown. They pull settlement data and create the proper journal entries with gross sales and itemized fees. The monthly cost usually pays for itself in time saved and accuracy gained once you’re past a few hundred transactions per month.
Reconcile on the same schedule as your payouts. Shopify and PayPal typically pay out daily or weekly. Amazon settles every two weeks. Match your fee tracking to that rhythm so you’re not trying to reconstruct months of transactions at once.
The fees add up faster than most e-commerce sellers expect. Between payment processing, referral fees, fulfillment charges, and subscription costs, you might be paying 15% to 30% of gross revenue to these platforms. Tracking fees properly is the only way to know your real margins and make informed decisions about which channels are actually profitable.
If your current books just show net deposits without the fee breakdown, a Richmond bookkeeper can help you set up the right account structure and either configure automation tools or establish a manual process that captures everything correctly going forward.
Greater Richmond's Small Business Bookkeeper
The Next Step:
A Short Conversation
Fifteen minutes to tell us what you're dealing with. We'll let you know how we can help and give you a clear price quote.
More Questions
What payroll taxes do Virginia employers need to pay?
Virginia employers pay federal FICA and unemployment taxes plus Virginia unemployment insurance. Budget roughly 8% to 10% of wages for the employer portion. Virginia keeps it simpler than many states with no state disability or paid leave taxes.
Read answerHow do I handle overtime pay correctly?
Non-exempt employees must receive 1.5 times their regular rate for hours worked over 40 in a workweek. The tricky parts are calculating the regular rate correctly and making sure employees are classified properly.
Read answerShould I track material costs separately from labor costs?
Yes. Separating materials from labor lets you see where your money actually goes on each job. Combined tracking hides whether you're losing money on materials, labor, or both.
Read answerWhat financial numbers should I review before hiring?
Review your cash reserves, monthly revenue trends, profit margins, and the true cost of employment before hiring. You need enough cash to cover several months of payroll and consistent revenue to support the ongoing expense.
Read answerWhich QuickBooks plan is right for my small business?
The right plan depends on user count, inventory needs, and whether you track project costs. Most small businesses do fine with Simple Start or Essentials. Plus is worth it only if you manage inventory or need job-level profitability.
Read answerWhat forms do I need when I hire a new employee?
Every new hire needs a W-4 for federal withholding and an I-9 to verify work authorization. Virginia also requires a VA-4 for state withholding and new hire reporting within 20 days.
Read answer
