Your online store’s sales total rarely matches the amount deposited in your bank. Payment processors may deduct fees, hold funds, combine transactions, or send refunds separately. To keep your accounts accurate, reconcile the full path from customer order to processor payout and bank deposit—not just the deposit amount. A consistent process helps you spot missing payouts, duplicate entries, and incorrectly recorded fees before they distort your revenue or cash balance.
Start With Complete Sales Records
Choose a reconciliation period, such as a week or month, and export the orders for those dates from each sales channel. Include order number, sale date, gross amount, discounts, tax, shipping, and payment status. Use the order number or another consistent reference to connect each sale with processor activity.
Record sales when the order is completed under your accounting method, then account for tax, discounts, and shipping in the appropriate categories. Check how your store handles canceled orders and unpaid orders so you do not count them as collected sales. Keep the order report and any adjustments with your accounting records.
Match Processor Payouts
Download the payout or balance report from each payment processor. A payout can include many orders, minus fees and refunds, so compare the report’s transaction details with your order records. Match by order reference where available, then confirm that the payout’s gross sales, adjustments, and net amount agree with the underlying transactions.
Track the payout as it moves through your accounts. If the processor sends money to a clearing account before it reaches the bank, record the payout there and match the eventual bank deposit to that transfer. This avoids treating the same sales as income twice. Note payout dates that cross your reporting period and reconcile them in the period when the activity belongs.
Record Fees and Refunds Separately
Enter processor fees as expenses rather than reducing sales by the net amount deposited. For example, if a payout report shows sales of $500, fees of $15, and a deposit of $485, record the $500 in sales, the $15 as a processing expense, and the $485 as the payout. This keeps revenue and payment costs visible.
Record refunds against the original sale or in a clearly labeled refunds-and-returns account, following your accounting setup. Match each refund to the processor transaction and check whether the processor returned any original fee. If a refund appears in a later payout, keep its transaction date and payout date distinct so the timing is clear.
Investigate Differences Before Closing
Compare the processor’s net payout with the related bank deposit. If they differ, look for pending funds, payout holds, currency conversion, chargebacks, reserve adjustments, or a deposit split across bank transactions. Check that the report and bank statement use the same date range and currency before changing any entries.
Keep a short exception list for items you cannot match immediately. Include the amount, date, processor reference, and what you checked; then follow up until each item is resolved. Save order exports, payout reports, refund details, and bank records together. Cart Ledger can help ecommerce businesses build a repeatable reconciliation routine when processor activity is difficult to untangle.
A reliable reconciliation connects each order to its processor activity and each payout to the bank, while recording fees and refunds separately. Use the same reports, references, and review steps each period, and investigate differences rather than forcing a match. If you want support setting up a practical process, contact an ecommerce accounting professional.