Net Matching
Matches deposits
Enter your email to receive a sign-in link
Reconcile Klarna BNPL settlements with QuickBooks Online bank accounts. Match net payouts to deposits.
Free preview — then from $5. Save with bundles.Send your Klarna settlement report to QuickBooks, allocate deposits to the clearing account, then download monthly fees and enter them separately as a bill.
A clearing account holds funds from Klarna that are in transit or not yet deposited, tracking the net value of sales minus refunds until payment reaches your bank.
Download monthly fee invoices from your Klarna Merchant Portal Settlements page and enter them as separate bills in QuickBooks.
Merchant Portal → Settlements → Download CSV
Upload Settlement Report Export CSV and choose Bank Transaction CSV (4-Column) format
Review converted data, download Quickbooks Online-ready file
Banking → Select Account → Upload from Computer → Import CSV
Discrepancies are highlighted with clear match and mismatch indicators — review differences at a glance.
Matches deposits
Payout dates
60 seconds
Works with standard CSV exports. No technical setup required.
Upload, convert, download in under a minute.
Pay per use only. No subscriptions or recurring charges.
How Klarna Settlements fields map to Quickbooks Online Bank Transaction
| Klarna Settlements | Source Value | Quickbooks Online Bank Transaction | Target Value | Note | |
|---|---|---|---|---|---|
payout_date |
2025-01-17 |
→ | Date |
01/17/2025
|
Convert to MM/DD/YYYY |
net_settlement_amount |
145.50 |
→ | Credit/Debit |
|
Net after Klarna fees |
merchant_reference |
ORD-2025-001 |
→ | Description |
ORD-2025-001
|
Order reference |
order_id |
KL-12345-ABCDE |
→ | Description |
KL-12345-ABCDE
|
Klarna order identifier |
Your Reconcile Klarna ↔ QuickBooks files stay on your device. Processing happens client-side, nothing leaves your machine.
Your Reconcile Klarna ↔ QuickBooks files are never cached, logged, or stored anywhere. Every session is ephemeral.
Designed for data sovereignty. No third-party trackers or analytics touch your Reconcile Klarna ↔ QuickBooks files.
Each Klarna settlement becomes one QBO bank transaction row
One row per order settlement with net amount after fees
order_id,
payout_date,
net_settlement_amount,
fee_amount
Single bank transaction line for each settlement
Issues you might encounter when importing Settlement Report Export data to Bank Transaction CSV (4-Column) - and how we solve them
QBO expects 3-column format but got 4-column (or vice versa)
Toggle 'use_3col_format' option. QBO bank feeds sometimes require 3-column (Date, Description, Amount), sometimes 4-column (Date, Description, Credit, Debit).
QBO requires MM/DD/YYYY format for dates
Processor uses MM/DD/YYYY by default. Ensure Klarna export has valid dates.
Net settlement shows negative values due to high refund activity
This is normal for refund-heavy periods. In 4-column format, these appear as Debits. In 3-column format as negative amounts.
Buy bundles and get up to 60% off. Perfect for recurring monthly conversions.
All available data flows from Klarna to Quickbooks Online
This platform pair is available in 1 other hub
Help us improve—what stopped you today?
Enter your email to claim your welcome bonus
SpreadsheetBroccoli