To reconcile Mercari payouts to a P&L, match every sold order to one SKU and its cost basis, then record sale price, fees, shipping and net proceeds as separate lines. Only then compare your order-level net totals to the bank deposits, and log any refund or cancellation as its own adjustment.
The reason to do it by order: Mercari deposits are lump sums. A transfer of $412.60 tells you nothing about which jacket made money and which one lost it. If you only check that the deposit "looks right," a $14 partial refund on one order can hide inside a good week for months.
What a Mercari payout actually contains
A payout is a batch of order proceeds minus whatever came out along the way. For each order, you need these pieces on separate lines:
- Item price the buyer paid.
- Buyer-paid shipping, if the listing used buyer-pays shipping. Check this against what you set; it is your pass-through, not revenue you keep.
- Selling fee Mercari deducted. Use the fee shown on the order, not a remembered percentage, because fee rules change.
- Payment processing or other deductions shown on the order detail.
- Shipping label cost, if you bought it and it was not folded into the buyer's charge.
- Net proceeds credited to your balance.
Pull these from each order's detail screen or the sales export, whichever you trust. Record them as they appear. Do not recompute them from a fee formula you assume is current.
The order-by-order reconciliation: 7 steps
Run this weekly, or at least before each withdrawal from your Mercari balance. It takes about 20 to 30 minutes for 40 orders once your SKUs are clean.
- Export or list every sold order for the period. Include order date, order ID, item title, and status (completed, cancelled, refunded).
- Assign each order a SKU. Match by title and the SKU on your bin label. If an order can't be matched to a SKU, flag it now; it has no cost basis and will distort your margin.
- Attach the cost basis. Pull the per-item cost from your sourcing log (haul cost allocated by expected value, plus tax and mileage if you include them).
- Enter the order lines. Sale price, buyer-paid shipping, selling fee, other deductions, label cost.
- Compute net proceeds per order and compare to the figure Mercari shows. A difference of even $0.50 means a missed deduction or a typo.
- Sum net proceeds for the payout window and compare to the actual bank deposit (or the balance withdrawn). Explain any gap with a named adjustment, such as a refund, a held order, or a prior-period carryover.
- Calculate profit per item: net proceeds minus cost basis minus packaging and any unreimbursed postage. Mark the order reconciled.
[Screenshot placeholder: FlipDesk Reconcile view showing a Mercari order with SKU, cost basis, fee lines, and a matched/unmatched flag.]
A worked example: three orders, one deposit
These numbers are an illustration, not a statement of current Mercari fee rates. Replace them with the figures on your own orders.
| Order | Sale price | Fees and deductions | Label cost not covered | Net proceeds | Cost basis | Profit |
|---|---|---|---|---|---|---|
| A: wool coat, Very Good | $68.00 | $7.50 | $0.00 | $60.50 | $14.00 | $46.50 |
| B: denim jacket, Good | $42.00 | $4.60 | $3.00 | $34.40 | $9.00 | $25.40 |
| C: knit sweater, Excellent | $30.00 | $3.30 | $0.00 | $26.70 | $6.50 | $20.20 |
| Total | $140.00 | $15.40 | $3.00 | $121.60 | $29.50 | $92.10 |
If the deposit is $121.60, the week is reconciled. If it is $115.60, you are $6.00 short and it is not noise. Look for a refund, a held order, or a deduction you did not log. Without the order-level table, you would see only a total and guess.
Now the profit view: $92.10 on $29.50 of cost is a healthy week. But if the knit sweater later gets a partial refund, the per-order record tells you exactly which line to adjust.
What to do when a partial refund or cancelled order breaks the match
Most mismatches come from two events. Handle each with its own adjustment line rather than editing the original order.
Partial refund
Say the buyer of order C reports a small snag and you agree to refund $8.00. Your net proceeds drop. Depending on how Mercari treats the fee on the refunded part, the fee may or may not come back, so read the order detail instead of assuming.
- Leave the original order lines intact.
- Add a refund line dated when the refund posted, for example -$8.00, and record any fee credit as a separate positive line.
- Recompute net proceeds and profit. Order C goes from $20.20 profit to roughly $12.20 if no fee comes back.
- Tag the reason: condition mismatch, shipping damage, or goodwill.
The reason tag matters. If three of ten refunds trace to a grade the buyer disagreed with, that is a listing-condition problem, not bad luck. Describing the garment against the five factors (Fabric Condition, Structural Integrity, Cosmetic Appearance, Functional Elements, Odor & Cleanliness) and using the same tier words every time (NWT, NWOT, Excellent, Very Good, Good, Fair, Poor) makes those disputes easier to spot and fewer in number. We will not promise it removes them.
Cancelled order
A cancelled order has no payout, but it still leaves traces: possibly a label you bought, packaging, and an item that must go back to active inventory.
- Mark the order cancelled and zero out revenue and fees (confirm nothing was charged).
- Log any sunk label or supply cost as an expense against that SKU.
- Return the SKU to active status and relist, or delist from other platforms if you crosslist.
A cancelled order that stays marked "sold" is how inventory counts and P&L drift apart.
Where mismatches usually come from
When your order total and deposit disagree, check these in order. Each is quick.
- Timing. An order completed on the 30th may pay out in the next window. Carry it over with a note.
- Held or pending funds. Orders not yet released are in your balance but not your deposit.
- Partial refunds you did not log. Search order status for anything other than completed.
- Shipping label differences. Buyer-paid shipping versus the actual label cost, especially if the package was heavier than listed.
- Multiple items in one order. Bundles need the sale price split by item to give each SKU its own profit.
- Withdrawal fees or transfer deductions, if your payout method has them. Book them as a finance expense, not against a SKU.
Keep a tiny "unexplained" bucket with a hard cap, such as $5 per period. If you exceed it, stop and investigate instead of rounding.
How Mercari fees belong in your P&L
For a Mercari fees in P&L reseller setup, treat selling fees as a cost of sale on each order, not as a monthly lump. That keeps per-item margin honest and lets you compare platforms: the same coat earns a different net on Mercari than on eBay or Poshmark, and you only see it if fees sit on the order line.
Use consistent categories so your records survive tax season:
- Revenue: item price (and buyer-paid shipping, per your accountant's guidance).
- Cost of goods sold: the SKU's cost basis.
- Selling fees: Mercari fee and processing deductions.
- Shipping expense: labels and packaging.
- Refunds and adjustments: contra-revenue lines, dated when they posted.
This is operational bookkeeping, not tax advice. Ask your accountant how to treat buyer-paid shipping and sales tax in your jurisdiction.
Make it routine, not a quarterly rescue
Match Mercari sales to cost basis weekly. A 40-order batch at 30 minutes is manageable; 400 orders after three months is a weekend you will not get back. Keep the SKU on every order, keep refunds as separate dated lines, and review the unexplained bucket each time.
FlipDesk Reconcile pairs each marketplace order with its SKU and cost basis, flags unmatched payouts, and keeps refunds as their own adjustments. Try it on one week of Mercari orders and see how many deposits match on the first pass.