The amount arriving in your bank from a payment provider is a settlement. It can be reduced by refunds, fees, disputes or reserves and may relate to transactions from a different period. Recording that deposit as sales can misstate both revenue and expenses.
For an Irish online business, a reliable process connects the order or invoice, the payment-provider balance and the bank deposit. Those are three views of activity, not three separate sales.
Quick answer
Use the sales records to establish revenue and any VAT liability. Use payment-provider reports to explain collections, deductions and unsettled funds. Use the bank statement to confirm the payout arrived. Reconcile the differences rather than forcing the totals to match.
Separate the three records
| Record | Main question it answers |
|---|---|
| Sales or order ledger | What did the business sell, refund or credit? |
| Payment-provider account | What was collected, deducted, reserved or transferred? |
| Bank statement | Which settlements actually arrived? |
An order date, capture date, payout date and bank receipt date can differ. Choose a consistent reporting period and document the cut-off.
Shopify expressly distinguishes payment balance activity from accounting revenue. Its payment activity report supports reconciliation but should not be substituted for the sales ledger.
Worked example: from customer charges to bank deposit
This is a simplified invented example. Assume all included goods are subject to 23% VAT, the original sales and refunds occur in the same reporting period, and the business recognises those sales in that period. Actual rates and recognition depend on the transactions.
| Settlement item | Amount |
|---|---|
| Customer charges including VAT | €12,300 |
| Refunds including VAT | (€1,230) |
| Illustrative processing fees | (€250) |
| Amount retained pending settlement | (€820) |
| Bank payout | €10,000 |
The arithmetic is €12,300 − €1,230 − €250 − €820 = €10,000.
But revenue is not €10,000. Under these assumptions:
- Sales excluding VAT: €10,000.
- Refunds excluding VAT: €1,000.
- Net revenue: €9,000.
- Output VAT after the refunds: €2,070.
- Processing expense: €250.
- Provider balance awaiting settlement: €820.
The €250 is an assumed fee, not a Stripe or Shopify tariff. This example does not determine the VAT treatment of processing fees; check the supplier invoice and applicable rules separately.
How a clearing account helps
A payment-provider clearing account explains money between customer collection and bank settlement. In the example, customer charges increase the account by €12,300. Refunds reduce it by €1,230, fees by €250 and the bank transfer by €10,000, leaving €820.
Posting the payout moves value from clearing to bank. It does not create another sale. The remaining balance should agree to evidence of unsettled or reserved funds.
If €820 later reaches the bank, clear that balance without recording revenue again.
Use the right provider reports
For automatic Stripe payouts, the payout reconciliation report connects settlement batches with underlying activity. Stripe directs users with manual payouts to its Balance report; instant payouts require reconciliation against transaction history.
Shopify provides individual payout details and exports. Use those records alongside the order ledger and bank statement, checking currency and date coverage.
Do not assume every Shopify shop uses a separate direct Stripe account. Shopify Payments and an independently connected provider may have different reports. Map the actual payment routes before building the ledger.
Common mistakes to check
Counting the same sale twice
An integration posts the order as revenue, then a bank rule posts the payout as revenue again. Match the deposit to clearing instead.
Recording only net deposits
This hides fees and may understate sales and VAT. Reconstruct the underlying activity.
Treating reserves as expenses
Funds withheld temporarily may remain an asset, subject to recoverability and the contract. Investigate rather than writing them off automatically.
Mixing currencies
Reconcile each provider currency first, then account for conversion and exchange differences. A euro bank deposit may not equal the original foreign-currency amount.
Losing the month-end cut-off
Sales captured near month-end may settle later. Retain a schedule of unsettled balances instead of moving sales into the bank receipt month simply to make the reconciliation easier.
A monthly reconciliation routine
- Export complete sales, credits and payment activity.
- Reconcile order totals to the sales ledger.
- Explain provider movements by category and currency.
- Match each payout to bank receipt evidence.
- Support remaining provider balances and reserves.
- Review VAT coding, exceptions and any duplicate postings.
Revenue requires detailed VAT records that support the transactions and liability. The provider's net payout alone does not supply that full record.
Frequently asked questions
Can software automate the reconciliation?
Yes, where the connection and mapping are suitable. Test refunds, fees, reserves and cut-off differences before trusting an automated result.
Does every online sale carry Irish VAT at 23%?
No. The example makes a narrow assumption. Product, customer location, business status and cross-border rules can change the treatment. See our VAT registration guide and seek advice on the actual sales.
Get help with e-commerce bookkeeping
Stratancy assesses platform volumes, currencies, exports and connectors before agreeing the work. Explore our bookkeeping service and retail and e-commerce support, or request an assessment.
