Bank Statement Conversion for Ecommerce Payouts

Why a payout never matches your sales

The deposit Shopify, Amazon, or another platform sends to your bank is a net number: gross sales minus processing fees, minus refunds, minus any chargebacks or reserves held for the period. Recording that lump sum as revenue understates your sales and hides your fees, and splitting a net deposit into its real parts is the single biggest source of misstatement in ecommerce books. The bank statement is where those net payouts actually land, so it is the anchor for the reconciliation. Converting it to a CSV turns each payout into a row you can match and tie out, instead of a figure buried on a PDF page.

Match the bank deposit to the settlement report

Every processor payout should correspond to one deposit in your bank, and the reliable way to pair them is by amount first, then date. With the statement in a CSV you can sort the deposits and line each one up against the platform's report, Shopify's Finances Summary, Payouts, and Transactions, or Amazon's Settlement Report, which carries the breakdown behind that number. Find the deposit whose amount equals the payout's net total, confirm the date is within a day or two, and you have a matched pair. Sorting the converted deposits makes that match a quick lookup rather than a hunt through statement pages.

Gross up: split the net into its parts

Once a deposit is matched to its settlement report, you record it with the gross-up method so the books show the real activity. Book the full gross sales as revenue, record the processing fees as an expense, and record refunds and chargebacks against sales, which leaves exactly the net amount that hit the bank. Done this way, your revenue reflects what customers actually paid, your fees are visible as a cost, and the net still ties to the bank deposit you matched. The converted statement is what confirms that final net figure so the grossed-up entry reconciles instead of drifting.

Timing: payout dates vs deposit dates

Timing is where reconciliations go sideways. Platforms settle on their own schedules, Amazon typically every 14 days and Shopify on a rolling basis, and the bank deposit then lags the payout date by a day or two depending on your bank. A payout near a month-end can post to the next month at the bank, so a converted CSV that you can sort by date keeps that straddling deposit in the right period. Matching on amount first sidesteps the date drift, and then confirming a plausible date range catches the rare case where two payouts are the same amount.

Multi-platform sellers and privacy

Many sellers run more than one channel, so the bank statement carries payouts from several processors mixed together. A converted CSV lets you filter by the payout descriptor to group each platform's deposits before matching them to that platform's report, which keeps a multi-channel reconciliation orderly. Because these are live business records, statements are processed to build the CSV and then deleted automatically, with nothing retained on a server afterward. For a seller or their bookkeeper reconciling several months or channels at once, bulk conversion turns a stack of statements into matchable deposits in one pass.

Frequently Asked Questions