Matching Marketplace Payout Reports to Your Bank Feed
A small online shop noticed that its payout totals never matched the amounts in the bank account. The difference was not a mystery. It was a set of fees, refunds and reserves that had been taken before the money moved. Anyone who sells products online will face the same gap sooner or later. This article describes a monthly routine for matching payout reports against a bank feed so that nothing quietly drifts out of view.
The goal is not perfect accounting for a hobby store. The goal is to know, each month, where the money went and why it went there. Many shops that sell wellness goods also deal with payment holds and chargebacks, which makes the matching job harder than it looks. A steady method keeps the books honest and gives you clear answers when a question arrives from a bank or a platform.
Start With the Payout Report, Not the Bank Line
Download the payout report for the same period as your bank statement. Readers may also want to visit LIT Market. Look first at the total paid out, then at the list of deductions that appear before that total. Each deduction should carry a label such as fee, refund, adjustment or reserve.
Many sellers find it easier to build a short summary with four columns: gross sales, fees, refunds and net payout. Keep the summary in the same folder as the reports so the two can be compared quickly. When the net payout is matched to a bank deposit, mark the row as reconciled and note the deposit date beside it. If a label is unfamiliar, write it down as a question rather than guessing what it means.
Using a Bank Feed Without Losing Detail
A bank feed shows deposits as single lines, which can hide a lot of activity. One deposit may combine dozens of orders, several refunds and a reserve release. Compare that single line with the payout report line by line before you accept it. If the amounts differ, search for the smallest difference first, because a missing small fee often explains the rest of the gap.
You can also visit Go And Grow Online for more reading. Place those two records side by side in your spreadsheet. A clear split makes it obvious when a platform changed a rule or when a refund was processed later than expected. Timing differences are the most common source of confusion, so label them as timing rather than as errors.
Handling Holds, Reserves and Chargebacks
Payment holds are temporary, but they still affect cash flow. For a related read on this site, see Editorial Notes for Results Posts Mixed With Garden. Do not treat held money as spent or as lost. Record it as money that is expected but not yet available, so the picture stays accurate for the month.
A held amount that appears in one report but not in the bank feed is not an error by itself. It is a timing gap that still needs a line in your summary. Check the held amount again on the next report before deciding that anything is missing. Chargebacks deserve their own tab, with the order number, the amount, the reason given by the customer’s bank and the date the platform reported it. Store any evidence you sent in the same folder.
A Monthly Close That Takes an Hour
Set a fixed time once each month to run the match. Start with the payout reports, move to the bank feed and finish with the list of holds and chargebacks. Mark anything still open at the end of the session with a clear note about what is missing. An honest open item is more useful than a rushed match that hides a gap.
Share the finished summary with whoever handles your taxes or your bookkeeping. They can see the same numbers you saw, which saves time on both sides. A calm monthly routine turns a confusing pile of statements into a short list of answers that anyone can follow.
Keeping the Summary Honest
A reconciliation is only as good as the notes behind it. Leave the open items in plain sight until someone resolves them, rather than burying them inside a total. Add a short paragraph at the top of each summary that explains any unusual month in plain words, so a future reader does not need to guess. Over several months the notes become a useful map of how your sales really behave, and that map is worth more than any single perfect month. Keep the finished summaries in one folder, in date order, so the whole history can be reviewed in a single sitting.