How to Record Ecommerce and Stripe Sales Without Invoices (UK)

Do ecommerce sales need an invoice?

A sale still needs to appear in your business records even when you did not create a traditional invoice for the customer. HMRC says self-employed businesses should keep records of all sales and income, all business expenses and VAT records where registered. Evidence can include sales invoices, till records, receipts, platform exports and bank information.

Retail and consumer sales often start with a checkout receipt or platform order rather than an invoice. VAT-registered retailers have additional invoice and record-keeping rules, including circumstances where a customer asks for a VAT invoice. The practical lesson is simple: the absence of an Experi invoice does not mean the sale can be omitted from your records.

Sale, payment and payout are different events

Most double counting happens because three related events are treated as three lots of income. They are not.

Stripe's balance reports separate charges, refunds, disputes, adjustments and fees from payouts. That is why a bank deposit alone is not a reliable sales figure: it may combine many orders and already have several deductions applied.

Keep the sale components visible

Recording only the net cash received hides what actually happened. A useful transaction record keeps the commercial components separate:

• Sale value: the value of the goods or services sold.
• Discount: the reduction applied to the customer's order.
• Refund: money returned after a sale.
• Processor or marketplace fee: the cost withheld by the platform.
• Tax: VAT or other sales tax recorded with its evidence and treatment.
• Settlement: the amount and currency that reached the processor balance or bank.

This is a management reconciliation, not a universal tax formula. The accounting and VAT treatment can differ by scheme, timing and who is legally making the supply.

Individual orders or daily summaries?

Low-volume stores usually benefit from one record per order. You retain the clearest audit trail, can trace individual refunds and have less ambiguity when a customer queries a purchase.

High-volume sellers may prefer a daily summary grouped by channel, currency and VAT treatment. HMRC retail-scheme guidance describes daily gross takings as a record of supplies, not simply the cash in hand or the payout received that day. If you use summaries, retain the platform detail behind each total.

Use one method for each source and period

Never import individual orders for Monday and then also add Monday's full webshop total. Label the platform account, recording method and covered dates. A repeatable rule such as "Shop A, GBP, daily summaries from 1 August" is easier to review than deciding row by row.

A safe CSV import checklist

1. Export the source data for a precise date range.
2. Identify a stable external transaction ID for every order or summary.
3. Map dates deliberately, distinguishing sale, refund and payout dates.
4. Keep currencies explicit, including original and settlement values.
5. Preview before saving so invalid rows cannot enter reporting.
6. Review duplicates against prior imports and Experi invoices.
7. Confirm the batch total only when it reconciles to the source.

VAT and multi-currency need evidence, not guesses

A platform may show tax collected, but that does not remove the need to understand the transaction. Check the customer location, supply date, VAT rate, marketplace role and any scheme you use. Experi can carry VAT information into reporting when enough information is recorded; it cannot decide an uncertain tax position for you.

For foreign-currency sales, preserve the original amount and currency as well as the GBP or portfolio value used for reporting. If the conversion is missing, mark the record for review instead of quietly treating dollars or euros as pounds.

How Other Sales fits with invoices and bank reconciliation

Use an Experi invoice when the sale originated as an invoice. Use Other Sales when the revenue came from a webshop, card terminal, Stripe or marketplace without an Experi invoice. Both can feed Financials, while a later payout or bank deposit is matched as settlement rather than created as fresh income.

The result is a cleaner chain: source sale, commercial adjustments, processor settlement and bank deposit. Each event has one job, so revenue remains complete without being counted twice.