Skip to content
GraviPointThe Centre of Productivity
  • AI AgentNew
  • Pricing
  • Community
Log inGet started free
TemplatesRetail & E-commerceE-commerce OperationsMarketplace Fees and Payout Reconciliation

SpreadsheetE-commerce OperationsFree

Marketplace Fees and Payout Reconciliation

Break each order into referral, fulfilment and refund deductions, then reconcile expected payouts with what reached your bank.

Shown with sample data

Colour

Marketplace Fees and Payout Reconciliation

Break each order into referral, fulfilment and refund deductions, then reconcile expected payouts with what reached your bank.

Gross sales
$283.86
Marketplace fees
$84.50
Fee share of sales
30%
Refunds
$47.98
Net proceeds
$151.38
Unexplained difference
-$10
Deposits minus expected
Settlements to investigate
1
Expected payout by settlement
  • 1–14 Oct$4.63
  • 15–28 Oct$11.11
  • 29 Oct–11 Nov$50.05

How to use it

  1. 1Export the order and transaction report for each settlement period from your seller dashboard.
  2. 2Add each order with price, shipping charged, referral fee rate, fulfilment fee and any refund.
  3. 3On the Payouts sheet, enter advertising, subscription and other account fees and the bank deposit for each settlement period.
  4. 4Investigate any period where the difference is more than your rounding tolerance.
  5. 5Use the fee share KPI to check whether each channel is still profitable.

In this workbook

  • About
  • What’s included
  • How to use
  • Questions
  • Related resources

About this template

Marketplaces pay you a net amount after dozens of deductions, and errors hide in the gap. The Orders sheet takes each order’s item price, shipping charged, referral fee rate, fulfilment fee and any refund and calculates the referral fee, net proceeds and the share of revenue lost to fees. The Payouts sheet totals proceeds per settlement period, subtracts advertising and account-level fees to give the expected payout, and compares it with the actual bank deposit so every difference is flagged for investigation.

Who it’s for

  • Monthly bookkeeping for marketplace sellers
  • Checking settlement reports against bank deposits
  • Understanding true fee rates by product
  • Spotting missing reimbursements and fee errors

What’s included

  • Orders sheet: Each order with its fees and net proceeds.
  • Payouts sheet: Expected payout vs bank deposit per settlement.
  • Settings sheet: Reconciliation tolerance.

How to use it

  1. 1Export the order and transaction report for each settlement period from your seller dashboard.
  2. 2Add each order with price, shipping charged, referral fee rate, fulfilment fee and any refund.
  3. 3On the Payouts sheet, enter advertising, subscription and other account fees and the bank deposit for each settlement period.
  4. 4Investigate any period where the difference is more than your rounding tolerance.
  5. 5Use the fee share KPI to check whether each channel is still profitable.

Tips

  • Reconcile every settlement as it lands; disputes and reimbursement claims usually have time limits.
  • Referral fee rates vary by category and price band, and some marketplaces charge a minimum fee per item; check the current fee schedule.
  • When an order is refunded, many marketplaces return the referral fee minus an administration fee; record any refunded fees as a negative fee if your report shows them.
  • Keep the original settlement reports with this workbook for your accountant.

Questions

Why doesn’t my marketplace payout match my sales?

Payouts are net of referral fees, fulfilment fees, advertising, subscription fees, refunds, reserves held back and sometimes taxes collected on your behalf. Timing also matters: settlement periods rarely line up with calendar months.

What is a referral fee?

The commission a marketplace charges on each sale, usually a percentage of the total price including shipping. Amazon, for example, charges a category-specific percentage, often around 8–15%.

What should I do if the deposit is lower than expected?

Check for reserves held back, chargebacks, adjustments and storage or long-term fees not yet entered. If the difference remains, open a case with seller support with the order IDs and settlement ID.

Related searchesmarketplace payout reconciliationamazon settlement reconciliationmarketplace fees calculatoramazon fees spreadsheetecommerce payout reconciliationseller fees tracker

Details

Format
Spreadsheet
Category
E-commerce Operations
Sheets
3
Setup
10 min
Level
Advanced
Price
Free

Download a copy

Downloads need a free account.

SpreadsheetE-commerce OperationsFree

Marketplace Fees and Payout Reconciliation

Break each order into referral, fulfilment and refund deductions, then reconcile expected payouts with what reached your bank.

A free account keeps your copy safe so you can come back to it. Have one? Log in

Download a copy

Downloads need a free account.

Details

Format
Spreadsheet
Category
E-commerce Operations
Sheets
3
Setup
10 min
Level
Advanced
Price
Free

Your copy is private to you.

More e-commerce operations templates

View all
E-commerce Profit Calculator2 sheets

Listings analysed

8

Average net margin

21%

Losing money

1

Entries by channel
3
2
2
1
Own storeAmazonEtsyeBay
SpreadsheetE-commerce Operations

E-commerce Profit Calculator

True profit per order after product cost, shipping, marketplace and payment fees, ads and returns.

10 min setupPreview

Customer Order Form

Take product orders online: customer details, items and quantities, delivery or collection, and payment choice.

Full name *

Email *

Phone *

Place order
FormE-commerce Operations

Customer Order Form

Take product orders online: customer details, items and quantities, delivery or collection, and payment choice.

10 min setupPreview
Product Catalogue with Margins2 sheets

Products

7

Average margin

64%

Low-margin products

1

ABCD
1ProductCategoryVariantSupplier
2Organic cotton teeApparelBlack / MGreenThread
3Heavyweight hoodieApparelGrey / LGreenThread
4Canvas tote bagAccessoriesNaturalBagCo
5Embroidered capAccessoriesNavyCapWorks
Products
SpreadsheetE-commerce Operations

Product Catalogue with Margins

SKUs with cost, price, margin, markup, stock and status for every product.

10 min setupPreview

Practical guides and new resources, monthly.

One short email with new templates, calculators and how-tos. Unsubscribe any time.

GraviPointThe Centre of Productivity

Find the right resource. Make it work for you. Get things done with spreadsheets, documents, forms and calculators you can use right in your browser.

support@gravipoint.com
  • @gravipoint
  • @GraviPoint
  • GraviPoint
  • 𝕏@gravipoint

Templates

  • All templates
  • Budgets & expenses
  • Invoices & billing
  • Project management
  • HR & people
  • Inventory & stock
  • Sales & CRM
  • Financial calculators

Popular

  • Monthly budget
  • Invoice
  • Employee shift schedule
  • Weekly timesheet
  • Project plan & Gantt chart
  • Inventory tracker
  • Expense report
  • Mortgage calculator

Solutions

  • Individuals & households
  • Freelancers & consultants
  • Founders & startups
  • Small business owners
  • Teams & operations
  • Students & educators

Company

  • About
  • Features
  • Pricing
  • Community
  • Journal
  • Contact
© 2026 GraviPoint. All rights reserved.
  • Privacy
  • Terms
  • Help centre
  • FAQ