EN
Marketplace

How to Find a Marketplace Payout Difference? A Course on Expected Payout, Deduction Items, Order Matching, Dispute Files and Accounting Entries

How do you find a marketplace payout difference? The expected payout formula, deduction items, order matching and dispute files: an 8-lesson guide with worked examples.

Contents 14 sections
  1. What will you be able to do by the end of this training?
  2. Lesson 1: What is a payout difference and why does it occur?
  3. Lesson 2: How is the expected payout calculated?
  4. Lesson 3: How do you compare it with the actual payment?
  5. Lesson 4: How is the payout difference split into items?
  6. Lesson 5: How do you match order by order?
  7. Lesson 6: How do you set a tolerance and prepare a dispute file?
  8. Lesson 7: How is the accounting entry for a payout difference kept?
  9. Lesson 8: How do you monitor the payout difference?
  10. What are the most common mistakes when looking for a payout difference?
  11. How does NetKasam make payout tracking easier?
  12. Mini quiz: Test what you have learned
  13. Conclusion: Compare the payment with the amount you expected
  14. Frequently Asked Questions About Marketplace Payout Differences

The payment that reaches your marketplace account is almost always lower than the sales amount you see in the panel. Most of that gap is expected deductions: commission, shipping, service fees and returns. The real question is whether the remaining difference is correct. A business that does not compare the payment with the amount it expected can lose a wrongly applied commission rate or an unreflected return for months without noticing.

This article is not a narrative but an 8-lesson practical course. We will answer how to find a marketplace payout difference through a one-week payment period: calculating the expected payout, comparing it with the actual payment, classifying the difference items, matching order by order, the dispute file, the accounting entry and the tracking indicators. At the end there is a mini quiz and an answer key. Commission rates and deduction items vary by marketplace and by your contract, so all figures are sample values chosen to show the method. Follow the same steps with your own marketplace's payment report.

What will you be able to do by the end of this training?

In short: You will calculate the expected payout for one payment period, compare it with the actual payment, split the difference into items and prepare a dispute file.

Course mapSix steps to finding the payout difference
  1. 01
    CollectGet the period's list of delivered orders and returns.
  2. 02
    CalculateWork out the expected payout with the deduction items.
  3. 03
    CompareFind the difference from the actual payment.
  4. 04
    ClassifySplit the difference into items such as commission, shipping and returns.
  5. 05
    MatchInvestigate the unexplained difference order by order.
  6. 06
    DisputeNotify the marketplace with evidence and close the record.

The 8 lessons of the course: (1) what a payout difference is, (2) calculating the expected payout, (3) comparing with the actual payment, (4) classifying the difference, (5) matching order by order, (6) tolerance and the dispute file, (7) the accounting entry, (8) tracking indicators.

Lesson 1: What is a payout difference and why does it occur?

In short: The payout is the amount the marketplace owes the seller after deductions. The payout difference is the gap between the payout you calculated and the payment actually received.

The difference comes from three places. The first is a data difference: the commission rate, shipping desi or return amount in your records differs from the marketplace's records. The second is a timing difference: an order was not included in this period's payment and slipped to the next period. The third is an error: the marketplace applied a wrong rate or did not pass back the commission on a return. The first two look like a difference but are not errors; the third is your money.

We covered the general commission and payment arrangement between you and the marketplace in the article how marketplace commission and payout are calculated. This article focuses on finding the difference between what is calculated and what is paid. To see your net profit by channel, you can also read the article how to calculate net profit on a marketplace.

Lesson 2: How is the expected payout calculated?

In short: Expected payout = delivered sales − commission − shipping deduction − service and campaign deductions − returns and cancellations.

FormulaExpected payout and payout difference
  1. Expected payout = Delivered sales − Commission − Shipping deduction − Service deductions − Returns and cancellations
  2. Payout difference = Expected payout − Actual payment
  3. Difference rate = Payout difference ÷ Expected payout

In the example period, the sales total of delivered orders is ₺120,000. The commission total calculated order by order is ₺14,400 (12% on average), the shipping fee deducted by the marketplace is ₺5,200, service and campaign deductions are ₺1,800, and the amount of orders returned during the period is ₺7,500.

ChartExpected payout in one payment period: ₺91,100
  1. Sales total of delivered orders₺120,000
  2. Commission−₺14,400
  3. Shipping deduction−₺5,200
  4. Service and campaign deductions−₺1,800
  5. Amount of returned orders−₺7,500
  6. Expected payout₺91,100

Prepared with sample values. Calculation: 120,000 − 14,400 − 5,200 − 1,800 − 7,500 = ₺91,100.

Calculate commission not with a single average rate but by order and product category, because the marketplace may apply different rates by category. To set up the expected payout correctly, orders need to be gathered on one screen and the amount of each order recorded. In NetKasam you can see your marketplace orders in a single panel, filter them and report on them (order management).

Lesson 3: How do you compare it with the actual payment?

In short: Compare the net amount in the marketplace's payment report with the expected payout; write the difference both as an amount and as a percentage.

In the example period, the amount deposited into the bank account is ₺88,640. The payout difference is 91,100 − 88,640 = ₺2,460, and the difference rate is 2,460 ÷ 91,100 = 2.7%. If you assume the same difference repeats over four weeks, the amount becomes 4 × 2,460 = ₺9,840. A weekly difference that looks small reaches a serious amount when it repeats regularly.

ItemAmount
Expected payout91.100 ₺
Payment deposited into the bank account88.640 ₺
Payout difference (shortfall)2.460 ₺
Difference rate%2,7
Four-week total of the same difference9.840 ₺

Also verify separately that the payment actually reached the bank account: the marketplace report and the bank statement should show the same amount. For the bank side, use the steps in the article how to do bank reconciliation. The order matters: first check that the payment matches the bank, then check the difference against the expected payout.

Lesson 4: How is the payout difference split into items?

In short: Group the difference by cause: commission rate difference, shipping desi difference, return commission and the unexplained remainder.

In the example, when the ₺2,460 difference is examined order by order, it splits into the following items:

Difference itemAmountReason
Commission rate difference1.150 ₺A category rate different from your records was applied to some products
Shipping desi difference760 ₺The desi measured by the marketplace is higher than the one you entered
Commission on a returned order420 ₺The commission of the returned order was not passed back into the payment
Unexplained130 ₺To be investigated order by order
Total difference2.460 ₺
ChartBreakdown of the payout difference by item
  • Commission rate difference₺1,15046.7%
  • Shipping desi difference₺76030.9%
  • Return commission₺42017.1%
  • Unexplained₺1305.3%

Prepared with sample values. Total: 1,150 + 760 + 420 + 130 = ₺2,460.

The explained difference is 1,150 + 760 + 420 = ₺2,330 and is 94.7% of the total difference (2,330 ÷ 2,460). The unexplained remainder is ₺130, or 5.3%. The goal is to keep the unexplained share as small as possible; the way to do it is to classify the items the same way every period. You can find how desi differences arise in the article how desi is calculated, and shipping invoice checks in the article how to check a shipping invoice.

Recommended readingHow to Do Marketplace Accounting?

Lesson 5: How do you match order by order?

In short: Match every line in the marketplace's payment report to your own records by order number and compare the expected and actual amount line by line.

The total difference does not show the source; the source is at line level. Matching is done in four steps: first, sort the payment report by order number. Then put each order's amount from your own records side by side. Third, check the commission rate, shipping fee and return status on every line. Fourth, flag the orders with a difference and write down the cause.

OrderYour own recordsPayment reportDifferenceReason
Order 1Commission ₺120 (12%)Commission ₺150 (15%)30 ₺Category rate difference
Order 2Shipping ₺28 (3 desi)Shipping ₺36 (4 desi)8 ₺Desi difference
Order 3Return, commission refundedCommission not passed back85 ₺Return commission

Doing this matching by hand for hundreds of orders is hard; filter the order list, export it and do it in a spreadsheet. Having orders in one place and seeing their statuses (delivered, returned) makes it easier to find which order belongs to which period's payment. You can export saved reports and the period-end list to Excel (reports).

Lesson 6: How do you set a tolerance and prepare a dispute file?

In short: Set a tolerance for small differences, and prepare a dispute file with order evidence for differences that exceed the tolerance or keep recurring.

In the example, the tolerance can be set as ₺10 per order and 1% of the expected payout per period. Because the total difference is 2.7%, the period tolerance is exceeded and a review is needed. A tolerance directs your time to large differences instead of chasing every cent; however, if the same kind of small difference keeps recurring (for example in the same category every month), it should be investigated even if it is under the tolerance.

Dispute file sectionContents
SummaryPeriod, expected payout, actual payment and total difference
Order listNumber, amount and item of the orders with a difference
EvidenceRate in the contract, product category, measured desi, return record
RequestThe disputed amount (in the example, the explained ₺2,330) and the correction requested

The channel and time limit for a dispute vary by marketplace and contract; verify this in the marketplace seller panel and in your contract. A correction that comes as a result of the dispute appears as a separate line in the next payment; match that line too so that the difference is closed. For the justification of return-related differences, the document structure in the article how to issue a return invoice helps.

Lesson 7: How is the accounting entry for a payout difference kept?

In short: Track the marketplace as a customer account: a sale creates a receivable, deductions and payment close that receivable, and the remaining difference stays open until the dispute is resolved.

Sales made to the marketplace are recorded as a receivable in the marketplace account, while payments and deductions are recorded as a decrease in that account. At period end, the account balance shows the open payout difference. In the example the balance is ₺2,460, and the disputed ₺2,330 and the unexplained ₺130 are tracked separately. The finalized part of the difference (for example, a dispute the marketplace does not accept) is recorded as an expense; confirm with your certified public accountant (mali müşavir) which account and which tax treatment to use.

The method of closing the account against the marketplace is the same as the steps in the article how to find and close account reconciliation differences. In NetKasam, customer account tracking is included in the free bookkeeping software (customer account tracking). For invoicing orders, see the article how to invoice orders in bulk.

Lesson 8: How do you monitor the payout difference?

In short: Track five indicators in every payment period: difference rate, unexplained difference, open dispute amount, collection time and the difference breakdown by item.

IndicatorHow it is calculatedSample value
Difference ratePayout difference ÷ Expected payout%2,7
Unexplained rateUnexplained difference ÷ Total difference%5,3
Open dispute amountTotal of disputes not yet resolved2.330 ₺
Payment delayDays between the expected and the actual payment day2 days
Item breakdownCommission, shipping, return share%46,7 / %30,9 / %17,1

Item breakdown percentages: 1,150 ÷ 2,460 = 46.7%; 760 ÷ 2,460 = 30.9%; 420 ÷ 2,460 = 17.1%; the remaining 5.3% is unexplained. Because the largest item is commission, checking your products' category matching and the contract rate first is the highest-return job.

Takeaways from the exampleFour numbers from the payout difference example
  • ₺2,460payout difference for one period
  • 2.7%as a share of the expected payout
  • 94.7%of the difference explained
  • ₺9,840four-week total of the same difference

Update the indicators the same day after each payment period; when the difference is found within a week, the evidence for a dispute is still fresh. To compare marketplaces with one another, you can add the payout difference rate as an extra row to the table in the article how to measure profitability by sales channel.

Recommended readingHow to Decide Whether to Join a Marketplace Campaign? A Course on Break-Even Sales Units, Offer Comparison, Commission Discounts, Post-Campaign Drop and Inventory Clearance

What are the most common mistakes when looking for a payout difference?

  1. Never checking the payment. The deposited amount looks sufficient, so the difference goes unnoticed.
  2. Calculating with an average commission. Category differences get lost in the average.
  3. Counting a period shift as an error. An order that slipped to the next period looks like an underpayment.
  4. Confusing the bank difference with the report difference. First verify that the payment reached the bank.
  5. Not matching by order number. Even when totals agree, line errors can cancel each other out.
  6. Not keeping evidence for the dispute. Without the desi measurement, category and return record, the dispute is weak.
  7. Leaving the difference unrecorded. The account balance does not reflect reality.

How does NetKasam make payout tracking easier?

  • Orders on one screen. You see marketplace and e-commerce orders in a single panel and manage their statuses (order management).
  • Automatic and bulk invoicing. If you wish, orders are invoiced automatically the moment they arrive, or you filter orders and invoice them in bulk (invoice tracking).
  • Customer account tracking. You track the marketplace as a customer account and see the debit and credit balance (customer account tracking).
  • Saved reports. You save the period report and export it to Excel (reports).
  • Bank transactions. You track payments in the bank account and reconcile them.
  • Bookkeeping is free. e-Invoice, customer and supplier accounts, inventory, cash, bank and expense management are free in every plan; see the pricing page for details.

Mini quiz: Test what you have learned

In short: Answer the 5 questions below, then compare with the answer key. 4 or 5 correct shows you have completed the training.

  1. If sales are ₺120,000, commission ₺14,400, shipping ₺5,200, service deduction ₺1,800 and returns ₺7,500, what is the expected payout?
  2. If the actual payment is ₺88,640, how many ₺ is the payout difference?
  3. What percentage is the difference rate (relative to the expected payout)?
  4. If the commission difference is 1,150, the desi difference 760 and the return commission ₺420, how many ₺ is the unexplained difference (total difference ₺2,460)?
  5. If the same difference repeats for four weeks, how many ₺ is the total?

Answer key:

  1. 120.000 − 14.400 − 5.200 − 1.800 − 7.500 = 91.100 ₺.
  2. 91.100 − 88.640 = 2.460 ₺.
  3. 2,460 ÷ 91,100 = 2.7% (approximately).
  4. 2.460 − (1.150 + 760 + 420) = 2.460 − 2.330 = 130 ₺.
  5. 4 × 2.460 = 9.840 ₺.

Frequently Asked Questions About Marketplace Payout Differences

How do you find a marketplace payout difference?

You calculate the expected payout: from the delivered sales, subtract commission, shipping, service deductions and returns. Subtracting the actual payment from this amount gives the payout difference.

Why does a payout difference occur?

The main causes are data such as the commission rate or desi differing between the marketplace and your records, an order slipping into the next payment period, and an incorrect deduction by the marketplace.

Is a payout difference always an error?

No. Period shifts and data differences are not errors. Matching order by order shows which part of the difference is a real error.

How often should the payout difference be checked?

In every payment period. If you find the difference within a week, you still have the evidence needed for a dispute.

Why should I calculate commission order by order?

A marketplace may apply different rates depending on the product category. An average rate hides category differences and makes it harder to find a wrongly applied rate.

Which documents are needed for a dispute?

The difference list, order numbers, the rate in the contract, the product category, the measured desi and the return record. For the dispute channel and deadline, check the marketplace's seller rules.

How is a payout difference tracked in accounting?

The marketplace is tracked as a customer account. A sale creates a receivable, payments and deductions close that receivable, and the remaining difference stays open until the dispute is resolved. Confirm how to record the finalized part with your certified public accountant (mali müşavir).

Should small differences also be investigated?

First set a tolerance. Differences below the tolerance that keep recurring with the same cause should still be investigated, because they may point to a systematic error.

Conclusion: Compare the payment with the amount you expected

The most useful thing you can do today is to calculate the expected payout for the last payment period and compare it with the marketplace's payment report. If there is a difference, split it into commission, shipping and return items; start with the largest item and match order by order. When you repeat the same method every period, the difference shrinks on its own and the amount to dispute becomes clearer.

Bookkeeping Is Now Completely Free

Manage your bookkeeping and e-Invoice operations with NetKasam without paying a thing. Customer and supplier accounts, inventory, collections and more in one panel, completely free.

Start FreeMarketplace Integration

Read similar articles

19 free tools

Commission, shipping, VAT and profit calculations in your browser, no sign-up needed.

All tools