Reconcile Adyen in QuickBooks Online — Complete Fee Matching

🥦

Reconcile Complete

QuickBooks Journal Entries Format
valid rows

Reconcile your Adyen settlements in QuickBooks Online. Track Interchange++ fees, match batch settlements, and close your books accurately.

Free preview — then from $5. Save with bundles.
Free preview before you pay
Files never leave your browser
No account needed to start

Download Sample

Sample Adyen Settlement Details Report

Download

Adyen → QuickBooks Reconciliation Questions

Will this work with my Adyen report?

Yes, as long as you use the Settlement Details Report from Customer Area → Reports. This report includes all the fee breakdown columns we need.

What's the difference between gross and net settlement?

Gross settlement is the total transaction amount, while net settlement is what you actually receive after Adyen deducts fees, chargebacks, and refunds.

Can I automate Adyen fee recording?

Yes. Export Adyen's Settlement Details Report, upload it to our converter, and get QuickBooks journal entries with complete Interchange++ fee breakdowns. No subscription or API setup required.

How Adyen → QuickBooks Reconciliation Works

1

Export from Adyen

Reports → Settlement details → Download CSV

2

Upload and Configure

Upload Settlement Details Report CSV and choose Journal Entry format

3

Preview and Download

Review converted data, download Quickbooks Online-ready file

4

Import to QuickBooks Online

Settings ⚙️ → Import Data → Journal Entries → Upload CSV

Discrepancies are highlighted with clear match and mismatch indicators — review differences at a glance.

Common Journal Entry Import Errors

Issues you might encounter when importing Settlement Details Report data to Journal Entry - and how we solve them

Journal Entry Out of Balance

One or more journal entries don't balance — debits don't equal credits

Check for rounding errors in fee calculations or missing transactions in the batch. Each journal entry must have total debits = total credits.

Missing Batch Number

Settlement rows don't have a Batch Number, making it impossible to group transactions

Ensure you're using the Settlement Details Report (not Transaction Report). The tool will group by date if batch numbers are missing.

Fees Don't Match Net Amount

Gross - Total Fees ≠ Net, indicating data corruption or missing fee columns

Verify your export includes all fee columns: Commission, Markup, Scheme Fees, Interchange. Re-export from Adyen if columns are missing.

Multiple Fee Accounts Required

Split Interchange++ option is enabled but only one fee account is configured

When splitting fees, you need separate expense accounts for Processing Fees (Commission + Markup) and Interchange Fees (Scheme + Interchange). Configure both accounts in processing options.

Multiple Currencies in One Batch

A single batch contains transactions in different currencies, which breaks accounting rules

Process each currency separately. Filter your Adyen report by currency before converting, or split your export into separate files per currency.

Why Adyen Reconciliation Is Challenging

Interchange++ Pricing Complexity

Adyen's Interchange++ pricing means every transaction has different fees based on card type, region, and scheme. Processing fees include Commission, Markup, Scheme Fees, and Interchange — each varying per transaction. Without proper tracking, you lose visibility into your actual payment processing costs.

How This Tool Helps

We convert Adyen Settlement Detail Reports into proper Journal Entries: - Gross amounts credited to Revenue - Processing fees (Commission + Markup) debited to Fees expense - Interchange (Scheme + Interchange) debited to Interchange expense - Net amount debited to Bank (matches deposit) Each batch settlement becomes a balanced journal entry for easy bank reconciliation.

Field Mapping

How Adyen Settlements fields map to Quickbooks Online Journal Entry

Adyen Settlements Source Value Quickbooks Online Journal Entry Target Value Note
Batch Number 12345 → JournalNo 12345 Batch identifier prefixed with ADYEN-
Creation Date 2025-01-15T14:30:00+00:00 → JournalDate 01/15/2025 Settlement date formatted as MM/DD/YYYY
Gross Credit 100.00 → Credits 100.00 Sales income (revenue account)
Commission 1.50 → Debits 1.50 Processing fees expense (Commission + Markup)
Markup 0.50 → Debits 0.50 Processing fees expense (Commission + Markup)
Scheme Fees 0.20 → Debits 0.20 Interchange fees expense (Scheme + Interchange)
Interchange 1.00 → Debits 1.00 Interchange fees expense (Scheme + Interchange)
Net Credit 96.80 → Debits 96.80 Bank deposit (net amount after all fees)

Why Reconcile Adyen → QuickBooks First?

Interchange++ Tracking

Complete fee visibility: Commission, Markup, Scheme, Interchange.

Batch Aggregation

One journal entry per settlement batch for clean books.

Bank Reconciliation Ready

Net amounts match Adyen deposits exactly.

PSP Reference Tracking

Adyen transaction IDs preserved in memos.

Chargeback Handling

Chargebacks tracked separately with correct accounting.

Multi-Currency

Handle settlements in multiple currencies.

Data Transformation

Each settlement batch creates multiple journal entry lines (debits and credits) that balance to zero

Input Adyen Settlement Batch

One row per settlement batch containing gross sales and fee breakdown

Key columns: Batch Number, Creation Date, Gross Credit, Net Credit
1:N — One input row creates multiple output rows
Output Journal Entry Lines 4-6 rows per input

Multiple balanced lines for proper double-entry accounting

DR Bank Deposit Net amount deposited to bank (what actually hits your account)
DR Processing Fees Adyen Commission + Markup tracked as expense
DR Interchange Fees Scheme Fees + Interchange tracked as expense
CR Sales Income Gross sales revenue before fees
All journal entries are balanced (total debits = total credits)

Secure Adyen → QuickBooks Reconciliation

Local Processing Engine

Your Adyen → QuickBooks files stay on your device. Processing happens client-side, nothing leaves your machine.

Zero Server Storage

Your Adyen → QuickBooks files are never cached, logged, or stored anywhere. Every session is ephemeral.

Privacy-First Architecture

Designed for data sovereignty. No third-party trackers or analytics touch your Adyen → QuickBooks files.

More credits - more savings

Buy bundles and get up to 60% off. Perfect for recurring monthly conversions.

Frequently Asked Questions

You can, but free scripts and AI often miss edge cases that break real-world data: missing SKUs, currency formatting quirks, tax calculation errors, or date format mismatches. We have battle-tested validators specifically designed for accounting software imports that catch these issues before they corrupt your books. Plus, you get instant browser-based conversion without installing Python or managing dependencies.
It depends on your needs. Splitting gives detailed visibility (useful for cost analysis) but creates more expense accounts. Combining into one account is simpler for most businesses.
Each journal entry is named with the Batch Number. Find this number in your bank deposit description or Adyen's payment report to match entries.
Process each currency's settlement separately and set the appropriate bank account for each. This keeps multi-currency accounting clean.
Chargebacks are debited to your sales account (reducing revenue) along with any chargeback fees debited to expenses.
Yes, as long as you use the Settlement Details Report from Customer Area → Reports. This report includes all the fee breakdown columns we need.
Use Adyen's Settlement Details report to view each batch separately, then match each batch amount to your QuickBooks bank deposits by comparing batch IDs and settlement dates.
Settlements can take 2-3 business days to appear after the batch closes. Verify your payout frequency in Adyen settings and check that the deposit is matched to the correct date in QuickBooks.
Gross settlement is the total transaction amount, while net settlement is what you actually receive after Adyen deducts fees, chargebacks, and refunds.
Record each currency's transactions separately using Adyen's multi-currency reports. Track exchange rate differences as gains or losses in a dedicated account.
Yes. Export Adyen's Settlement Details Report, upload it to our converter, and get QuickBooks journal entries with complete Interchange++ fee breakdowns. No subscription or API setup required.

Adyen → Quickbooks Online Data Ecosystem

All available data flows from Adyen to Quickbooks Online

Adyen Settlement Details Report Adyen settlement/payout reports with fees, charges, refunds, and batch information
→
Quickbooks Online Journal Entry Double-entry accounting with debits/credits
Batch Number → JournalNo Creation Date → JournalDate Gross Credit → Credits
Professional accounting, fee tracking, aggregated imports Current tool

Also available as

This platform pair is available in 1 other hub

Learn More:

vs Blue Onion Labs vs Leapfin vs Synder vs A2X vs Amaka vs Congrify vs Optimus Tech vs Ledge