Skip to the guide
IQ Booksby ReconcileIQ

Banking · Guide 26 of 53

Sales channels: Stripe, PayPal and eBay

A marketplace or payment processor holds your money before it reaches the bank, and the payout that arrives is already net of fees, refunds and tax. Connecting the channel itself is what lets IQ Books book the gross sale, the fee and the refund separately instead of guessing from one lump.

When you sell through Stripe, PayPal or eBay, the money does not go straight to your bank. It sits with the channel, and what eventually lands is a single payout that is already net of commission, payment fees, refunds, and any VAT the marketplace collected on your behalf. If you code that payout as one line of sales, every one of those numbers is wrong — your turnover is understated, your fees never appear as a cost, and your VAT return is built on a figure that was never your sale.

This is the job that sellers usually buy a separate tool for. A sales channel connection does it inside IQ Books: the channel's own activity arrives as lines, each one coded on its own, and the payout is matched to the deposit on your real bank account.

What a channel connection gives you

  • Gross sales, not net. A £15.00 sale with a 69p fee is booked as £15.00 of revenue and 69p of cost, not £14.31 of revenue.
  • Fees where they belong. Commission and payment fees land on an expense account you choose, so you can see what selling actually costs you.
  • Refunds as refunds. A refund reduces sales rather than appearing as a mysterious payment out.
  • Marketplace VAT handled. Where the marketplace collected the VAT and paid it over itself, that is recorded as what it is rather than as your output tax.
  • A clearing balance you can check. The channel account in IQ Books should agree with the balance the channel itself shows you, including money still on hold.

Two shapes of channel

Channels differ in how the money behaves, and IQ Books follows the shape rather than forcing one model on all of them.

  • Balance-style — Stripe and PayPal. There is a running balance, every event moves it, and money leaves in payouts. These behave almost exactly like a bank account, so they use the same pipeline: one IQ Books bank account stands for the channel balance, and each event is a line on it.
  • Payout-style — eBay, and Amazon and Shopify when they arrive. Activity accumulates, some of it on hold, and settles periodically. Lines still land individually so the balance stays honest, but the posting happens per settlement.

What you can connect today

  • Stripe — connected directly with a restricted read key. See Guides → Connecting Stripe.
  • PayPal — connected through the same Open Banking provider as your bank, so it appears in the bank-feed wizard alongside your bank accounts. See Guides → Connecting a bank feed.
  • eBay — connected directly through eBay's own authorisation screen. See Guides → Connecting eBay.
  • Amazon and Shopify — not yet available. Until they are, use the statement route below.

Channels without a feed

If a channel has no connection yet, you are not stuck with a single lump. Download the settlement or transaction report the channel gives you and run it through CodeIQ, which reads eBay, Amazon and PayPal statements directly and will map an unfamiliar export — Etsy, Square and the rest — with your help. It extracts the sales, fees, shipping and refunds as separate entries and posts them back here. See Guides → Coding your bank with CodeIQ.

Getting the pairing right

When a payout leaves the channel and lands in your bank, that is one movement seen twice. IQ Books treats it exactly as it treats a transfer between two of your own bank accounts: the line out of the channel and the deposit into the bank are paired, and neither is income. If a payout has not paired — usually because the bank side has not arrived yet — it waits rather than guessing, and tells you why.

IQ Books by ReconcileIQ

Your books, kept by themselves.

IQ Books is the AI-native UK ledger that does the bookkeeping for you. Bank transactions arrive coded, receipts and bills file themselves from a photo or an email, and the books are reconciled to the statement. RiQ does it, you sign it off. The ledger is free.