Fraud Blocker Skip to main content

Xero Accountant | Xero Migration | Xero Support | Xero Training | Crypto Accounting

+44 0203 488 6202

info@ecloud-experts.com

SCHEDULE A MEETING
Get a quote
Contact
QuickBooks Online

Archives

Why Your Ecommerce Sales Do Not Match Your Xero Bank Deposits

ecommerce Xero reconciliation

Running an ecommerce business involves more than accepting orders and receiving money. Sales can come through Shopify, Amazon, eBay, Etsy, WooCommerce and other platforms. Payments may then pass through Shopify Payments, PayPal, Stripe, Klarna or another payment provider before reaching your bank. This creates a common accounting problem. The sales shown on your ecommerce platform rarely match the deposits appearing in your bank account. This does not always mean money is missing. In most cases, the difference is caused by fees, refunds, timing, taxes or several transactions being grouped into one payout. Effective ecommerce Xero reconciliation helps you explain every difference and keep your sales, fees, taxes and bank balances accurate. Struggling to match your ecommerce sales with your Xero deposits? Book a free consultation with eCloud Experts and let our specialists find and correct the differences. Why Ecommerce Sales and Bank Deposits Are Different Your ecommerce platform normally reports the gross value of customer orders. Your bank normally receives the net amount released by the payment provider. A simple example might look like this: Transaction Amount Gross customer sales £10,000 Refunds £500 Payment processing fees £280 Chargebacks £100 Net bank deposit £9,120 The £9,120 deposit is correct, but it does not match the £10,000 sales figure. If the full bank deposit is recorded as sales in Xero, revenue will be understated by £880. Refunds, fees and chargebacks will also be missing from the accounts. That is why ecommerce accounting should not be based only on the money entering the bank. 1. Payment Processing Fees Are Deducted Before Payout Payment providers usually charge a fee for processing each transaction. Some providers deduct these fees before sending the remaining money to your bank. For example: Payout activity Amount Customer payments £2,500 Processing fees £75 Amount deposited £2,425 Your ecommerce store reports £2,500 in sales, while the Xero bank feed shows a deposit of £2,425. Both figures may be correct. The £75 difference should normally be recorded separately as a payment processing expense. Recording only the bank deposit as sales would understate both your income and expenses. 2. Several Orders Can Be Combined Into One Deposit Payment providers rarely send one bank deposit for every customer order. They often combine several orders into one daily, weekly or scheduled payout. One deposit of £4,700 might include: Trying to match the £4,700 directly against one sales invoice will not work. The deposit must be matched to the group of transactions included in that particular payout. Good ecommerce Xero reconciliation connects each bank deposit to its supporting payout report. 3. Payout Dates Do Not Always Match Sales Dates A customer may place an order on Friday, but the payment might not reach your bank until Tuesday. The delay may be caused by: This timing difference becomes more noticeable at the end of a month or financial year. For example, sales recorded on 30 September may appear in the bank on 2 October. The sales belong to September, even though the money arrived in October. If you compare sales reports and bank deposits using only the same date range, the totals may appear incorrect. 4. Refunds Can Reduce Later Payouts Refunds do not always reduce the payout connected to the original order. A refund may be deducted from a later payout. Imagine that a customer placed an order in May and received a refund in June. The June bank deposit may be lower because it includes the refund for the May sale. This can make current sales look lower than they really are if the refund is not recorded separately. Refunds should normally be tracked against the correct sales period, payment provider and tax treatment. 5. Chargebacks Create Additional Differences A chargeback happens when a customer disputes a payment through their bank or card provider. The payment provider may deduct the following amounts from your available balance: If the business wins the dispute, some or all of the money may be returned in a later payout. Chargebacks can therefore affect more than one bank deposit. They should not simply be treated as a reduction in current sales without reviewing the supporting transaction. 6. VAT Can Make Sales Reports Confusing Ecommerce reports may display figures in different ways. One report may show sales including VAT, while another shows sales excluding VAT. You may also have separate amounts for: Comparing a gross sales report with a net bank deposit will produce an obvious difference. The correct VAT treatment depends on where the business and customer are located, the type of goods or services sold and the applicable tax rules. Ecommerce businesses selling across different countries may need additional review. If VAT is mapped incorrectly, the bank may still reconcile while the VAT return remains wrong. A green reconciliation button is helpful, but it is not an accounting qualification. 7. Discounts and Gift Cards Affect the Amount Collected Discounts reduce the amount paid by the customer, but your sales reports may display the original product value and the discount separately. Gift cards create another complication. Selling a gift card may create a liability rather than immediate product revenue. Revenue may be recognised when the customer uses the gift card, depending on the accounting treatment adopted. If gift card sales and redemptions are both recorded as normal revenue, sales may be counted twice. Your reconciliation process should distinguish between: 8. Marketplace Fees May Be Taken From the Payout Amazon, eBay, Etsy and similar marketplaces may deduct several charges before releasing money. These can include: A marketplace statement may therefore contain far more than sales and payment fees. Posting the net deposit directly to sales hides these costs and understates revenue. It also makes it difficult to understand the true cost of selling through each marketplace. 9. Currency Conversion Can Change the Final Amount International ecommerce businesses may accept payments in several currencies. The amount paid by the customer can differ from the amount deposited because of: For example, a customer may pay 1,000 euros, but your payment provider may