Business

Online selling: reconciling payout reports with orders

The payout from an online marketplace rarely equals the sum of the orders it covers. A simple reconciliation explains the difference line by line.

Editorial illustration for Online selling: reconciling payout reports with orders

Why the numbers differ

A seller completes ten orders in a week and expects the payout to match their total. It does not. Fees have been deducted, a refund has reduced one order, a shipping adjustment has appeared, and one payment has been held back. Without a reconciliation, the difference is a mystery, and errors in your favour or against you pass unnoticed.

What to compare

Take the platform’s payout report for the period and your own list of orders. For each order, check the sale price, the platform fee, any shipping or handling charge, any refund and the net. Sum the nets and compare with the credited amount.

ItemUnits
Orders completed10,400
Platform fees-1,250
Shipping adjustments-300
One refund-900
Expected payout7,950

If the credit differs from the expected figure, look for held amounts, timing differences or errors.

Common reasons for a gap

Several ordinary causes recur. An order may fall into the next payout period. A reserve may be held pending delivery. A fee may be charged that you did not anticipate. A refund may be taken from a later payout than the original sale. Each is easier to check when your own list is complete.

  • Timing: orders paid in the next period
  • Reserves: amounts held until delivery
  • Fees: new or changed charges
  • Refunds: deducted in a later payout

Record sales and payouts separately

Keep two views. One is the list of sales, which shows what the business earned. The other is the list of payouts, which shows what reached the account. The first drives performance analysis; the second drives cash planning. Reconciliation connects them.

In the app, record the payout credit as income, with a note listing the orders it covers. Optionally record fees and refunds as expenses in their own categories.

Reconcile on a schedule

Do this weekly or at each payout. A short routine takes a few minutes if kept current and hours if left for months. Mark each order as paid when its payout arrives, and list unpaid orders at the end of the month. Old unpaid orders deserve a query to the platform.

Spotting fees that creep

Keep a column for fee percentage in your reconciliation table. If it rises from one period to another, investigate. Changes can result from new charges, changed categories or different shipping rules. Early detection allows you to adjust prices or switch approaches.

Inventory and cash together

If you hold stock, reconcile the units sold with the units remaining. A mismatch can point to unrecorded sales, returns or losses. Linking the stock count to the payout report completes the picture of the business and prevents money from leaking quietly through the gaps.

Keep a list of recurring causes of mismatch, such as a fee type or a shipping rule, with a brief note on how each is recognised. After a few cycles, most differences can be explained at a glance, and genuine errors stand out clearly.

If your volumes are small, a monthly reconciliation may be enough. As orders grow, move to weekly. The right frequency is the one that catches problems before they pile up.

Cross-check the totals against your marketplace’s annual summary, if one is provided. If your records and the summary differ, find out why before the figures are needed elsewhere. Small unexplained gaps tend to grow if ignored.

Also record any chargebacks or disputes, with their dates and outcomes. They affect payouts in ways that are hard to remember later, and a clean note saves time when you review the quarter.

Keep the evidence

Save the payout reports and order records together. If a question arises with the platform, a clean trail with dates and amounts makes your case.

SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports