Net Matching
Matches deposits
Enter your email to receive a sign-in link
Reconcile Afterpay BNPL settlements with QuickBooks Online bank accounts. Match net payouts to deposits.
Free preview — then from $5. Save with bundles.No subscription required! Our converter transforms Afterpay settlement reports into QuickBooks-ready format for easy reconciliation. Just upload your CSV, convert, and import. For automated API-based syncing, third-party apps offer subscriptions, but our tool works without monthly fees.
Afterpay deducts transaction fees before depositing funds. The deposit amount equals gross sales minus processing fees.
Download settlement statements in CSV format from your Afterpay Merchant Portal to verify reconciliation amounts.
Business Hub → Settlements → Reconciliation Report → Download CSV
Upload Reconciliation 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.
How Afterpay Settlements fields map to Quickbooks Online Bank Transaction
| Afterpay Settlements | Source Value | Quickbooks Online Bank Transaction | Target Value | Note | |
|---|---|---|---|---|---|
Settlement Date |
17/01/2025 |
→ | Date |
17/01/2025
|
Convert to MM/DD/YYYY |
Net Settlement Amount |
145.60 |
→ | Amount |
|
Net after Afterpay fees |
Merchant Reference |
ORD-2025-001 |
→ | Memo |
|
Order reference |
Order ID |
AP-12345678 |
→ | Name |
|
Afterpay order identifier |
Each Afterpay settlement becomes one QBO bank transaction row
One row per order settlement with net amount after fees
Order ID,
Settlement Date,
Net Settlement Amount,
Merchant Fee incl Tax
Single bank transaction line for each settlement
Matches deposits
Settlement 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.
Issues you might encounter when importing Reconciliation 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, Amount, Memo), sometimes 4-column (Date, Amount, Name, Memo).
QBO requires MM/DD/YYYY format for dates
Processor uses MM/DD/YYYY by default. Ensure Afterpay export has valid dates. Check for European date formats (DD/MM/YYYY) which won't import.
Net settlement shows negative values due to high refund activity or fee adjustments
This is normal for refund-heavy periods. Negative amounts appear as withdrawals in QBO. Review fee structure if consistently negative.
No server round-trips. Your Reconcile Afterpay ↔ QuickBooks data is processed entirely in the browser tab.
The moment you close the page, all Reconcile Afterpay ↔ QuickBooks data is wiped from browser memory. No traces left.
Meets GDPR requirements by design — no data processing on external servers, ever.
Buy bundles and get up to 60% off. Perfect for recurring monthly conversions.
All available data flows from Afterpay to Quickbooks Online
This platform pair is available in 1 other hub
Learn More:
Help us improve—what stopped you today?
Enter your email to claim your welcome bonus
SpreadsheetBroccoli