E-commerce Seller Templates
Organize marketplace sales, refunds, fees, shipping, ad spend, inventory notes, payouts, and monthly seller finance review.
Best for: online sellers, marketplace businesses, product shops, and side-hustle owners who need a monthly finance packet for seller activity.
Important: This template organizes seller records. It does not determine sales-tax obligations, nexus, income-tax treatment, inventory accounting, or marketplace reporting requirements. Confirm tax and accounting treatment with qualified professionals.
Marketplace payouts usually combine sales, refunds, fees, shipping, reserves, and adjustments. This pack helps you separate the activity so bank deposits make more sense.
What this template helps you do
The E-Commerce Seller Finance Pack helps you organize monthly seller activity by channel. It gives you a place to summarize gross sales, refunds, fees, shipping, advertising, inventory notes, platform payouts, and questions for your bookkeeper or tax professional.
The main value is the payout review. A bank deposit from a marketplace rarely equals gross sales. The pack helps you explain the difference and keep the monthly story together.
Before you start
- Save a clean copy and create one working file for the year or one file per month, depending on your volume.
- Download monthly reports from each marketplace, payment processor, and shop platform.
- Gather payout reports, fee reports, refund reports, shipping reports, ad spend reports, inventory purchase records, and sales-tax notes.
- Create a monthly folder for seller reports.
- Decide whether you are tracking by marketplace, product line, brand, or store.
Template sections explained
| Section | Use it for |
|---|---|
| Seller Setup | Enter the store name, month, sales channels, currencies if relevant, and person preparing the packet. |
| Channel Sales Summary | Record gross sales, discounts, returns, refunds, and net sales by channel. |
| Marketplace Fees | Track platform fees, payment processor fees, listing fees, referral fees, subscription fees, and other selling costs. |
| Shipping and Fulfillment | Summarize shipping income, postage, carrier charges, fulfillment fees, packaging, and adjustments. |
| Advertising | Record ad spend by platform and campaign summary where useful. |
| Payout Reconciliation | Compare payout reports to bank deposits and explain differences such as reserves, timing, fees, and refunds. |
| Inventory Notes | Record purchases, stockouts, damaged inventory, adjustments, and questions for accounting review. |
| Monthly Review | Summarize the month, open questions, missing reports, and action items. |
Step-by-step tutorial
- Set up channels. List every sales channel used during the month, such as your website, marketplace stores, payment processors, wholesale orders, or local sales.
- Enter gross sales and refunds. Use platform reports as the source. Do not rely only on bank deposits because payouts usually net multiple items together.
- Record seller fees. Enter fees by category so you can understand what each channel costs to operate.
- Add shipping and fulfillment activity. Record shipping income separately from postage, labels, carrier fees, packaging, fulfillment costs, and shipping refunds.
- Record advertising costs. Enter spend by platform. If you track campaign details elsewhere, summarize totals here and link to the source report in your notes.
- Review payout deposits. For each payout, compare the platform payout report to the bank deposit. Note timing differences, reserves, withheld amounts, fees, or adjustments.
- Add inventory notes. Record inventory purchases, major stock changes, write-offs, damaged items, or counting notes so your accountant has context.
- Flag tax and compliance questions. Use the notes area for sales-tax questions, nexus questions, missing forms, marketplace-collected tax questions, and unusual transactions.
- Save monthly reports. Export the completed pack as a PDF and save it with the raw marketplace reports.
- Compare month over month. Use the summary to see whether fees, refunds, ad spend, or shipping costs are changing in ways that need attention.
How to review a payout mismatch
A payout may include sales from one month and deposit in the next month.
Marketplace, processor, referral, and subscription fees may be deducted before deposit.
Refunds and chargebacks can reduce a payout that otherwise looks like sales income.
Some platforms hold or release reserves, creating differences between activity and cash received.
Monthly review checklist
- Every active sales channel has a report saved.
- Gross sales, refunds, fees, shipping, and advertising are not mixed together.
- Payout totals are compared to bank deposits.
- Inventory purchases and adjustments are noted.
- Sales-tax and marketplace-tax questions are flagged for review.
- Final reports are saved in the monthly seller finance folder.
Common mistakes to avoid
- Using bank deposits as sales. Deposits often equal net payouts, not gross sales.
- Ignoring refunds and chargebacks. These can distort revenue and customer-service analysis.
- Combining shipping income and shipping expense. Track them separately for a clearer picture.
- Forgetting platform fees. Seller fees can materially affect profit.
- Not saving source reports. The template summary is strongest when backed up by platform exports.
FAQ
Can I use this for more than one marketplace?
Yes. Set up each channel separately so totals can be reviewed by platform.
Should I track inventory units in this pack?
Use the inventory notes area for summary-level review. If you need detailed inventory accounting, use a dedicated inventory system or ask an accountant.
Can this help with sales-tax review?
It can organize questions and marketplace data, but it does not determine sales-tax registration, nexus, or filing requirements.
How often should I update it?
Monthly is best for most sellers. High-volume sellers may update weekly or after each large payout batch.
What if my payout report does not match the bank deposit?
Use the payout reconciliation section to investigate timing, fees, refunds, reserves, and adjustments.
When to ask for help
Ask a bookkeeper or accountant if marketplace deposits are difficult to reconcile, inventory changes affect financial statements, sales-tax questions arise, refund volume changes significantly, or profit margins do not look right after fees and shipping costs.
Was this tutorial helpful?
Your feedback helps improve the KanderBooks tutorial library.