An ecommerce platform payout is rarely equal to the sales you made during the same period. The platform may subtract processing fees, refunds, chargebacks, or other adjustments, and it may hold part of your funds in reserve. To reconcile payouts accurately, connect the activity in the platform’s reports to the deposit in your bank account, then record each component in the right place. A consistent process helps you spot errors and understand your actual sales and cash flow.
Choose the Right Reports
Start with the payout or settlement report for the specific deposit you are reconciling. Record its payout ID, date, gross sales, refunds, fees, adjustments, reserve activity, and net payout. Use the report’s transaction or order detail when you need to investigate a total. Avoid relying only on a dashboard’s current summary, which may change as transactions are updated.
Match the report to the bank deposit using the payout ID or net amount, then confirm the deposit date. The platform’s payout date and your bank’s posting date may differ because of processing times, weekends, or bank holidays. Keep the report and any supporting transaction details with your bookkeeping records so you can trace the entry later.
Calculate the Net Deposit
Rebuild the payout from its components. A common calculation is gross sales minus refunds, platform and payment processing fees, chargebacks, and other deductions, adjusted for reserve funds released or withheld. The result should equal the net payout shown in the report. Check the platform’s definitions because it may group taxes, shipping, discounts, or adjustments differently.
Compare that net amount with the bank deposit. If the figures do not match, check for multiple payouts combined into one bank entry, deposits split across dates, currency conversion, or a payout still in transit. Do not force a difference into a general expense account. Identify its cause, document it, and correct the related entry.
Record Sales and Deductions
Record sales and related activity separately from the cash deposit. Depending on your bookkeeping setup, you may use a clearing account to track amounts due from the platform. Post gross sales to the appropriate income accounts, record refunds as reductions to sales, and classify platform and processing fees as expenses. Record chargebacks and other adjustments according to their nature and your accounting method.
When the platform pays you, clear the amount due against the bank deposit and account for any deductions shown in the payout report. A clearing account makes it easier to see whether funds remain in transit or whether an entry is missing. Keep sales tax collected for tax authorities separate from business revenue, and follow your accountant’s guidance on the correct accounts and timing.
Track Refunds and Reserves
Refunds may appear in a payout long after the original sale. Use the refund transaction date and platform details to connect the amount to the order, while recording it in the period required by your accounting method. Review whether the platform has also returned any related processing fee; fee treatment varies, so use the report rather than assuming the original charge was fully reversed.
A reserve is money the platform withholds or releases under its payout terms. Track withheld funds separately from fees and expenses because a reserve is not necessarily a cost. When the platform releases funds, reconcile the release to the bank deposit and the reserve balance. At month-end, investigate any remaining balance and retain the report explaining why those funds are still held.
Reconcile each payout to its detailed platform report, verify that the net amount reaches the bank, and keep sales, fees, refunds, and reserves distinct in your records. Repeat the process regularly and investigate differences while the transaction details are easy to access. For help setting up a clear payout workflow, contact Crescent Ledger.