Convert NatWest CSV to QBO / QFX / OFX
Drop your NatWest CSV or Excel export below and get a NatWest → QuickBooks/Quicken/Xero file in seconds. Private — nothing leaves your browser.
Advanced — bank identifiers (for "file not recognized" issues)
QuickBooks/Quicken use INTU.BID to recognize the file. Pick your bank above to autofill, or paste your own.
Free: up to 25 transactions per file. Pro (one-time $29): unlimited.
How to export your transactions from NatWest
NatWest Online Banking lets you download statements/transactions in CSV/Excel, QIF, OFX, and Quicken/Money formats. EXPORT STEPS: Log in to NatWest Online Banking (web, not just the app) > select the account > 'Statements' or 'View transactions' / 'Download transactions' > choose the date range and the format (Excel/CSV, OFX, QIF, Quicken 2004+ / Money). CSV LAYOUT (NatWest): columns are typically Date, Type, Description, Value, Balance, Account Name, Account Number - NatWest uses a SINGLE signed Value (negative for debits). Dates are UK DMY (DD/MM/YYYY). A header row is present. QuickBooks model: in the UK QuickBooks Online uses Open Banking bank feeds for NatWest, NOT US-style Web Connect, so there is no credible INTU.BID to make QBO accept an uploaded file. Supported file path is QBO 'Manually upload transactions' (CSV). Page value: 'NatWest gives CSV/OFX/QIF - here's how to map the signed Value column and DD/MM dates into QuickBooks (Open Banking feed is the alternative).'
Once you have the file, drop it into the converter above. LedgerBridge auto-detects the date, amount and description columns — adjust the mapping if needed, choose QBO for QuickBooks (or QFX for Quicken, OFX for Xero), and download.
Tips for NatWest files
- Choose DD/MM/YYYY as the date format if auto-detect guesses wrong.
- If withdrawals come in as positive numbers, tick “Flip amount sign”.
- For credit-card exports, set the account type to Credit card.
- If QuickBooks rejects the file, open Advanced and confirm the INTU.BID — selecting “NatWest” in the bank dropdown autofills it.
FAQ
How do I export a CSV from NatWest?
NatWest Online Banking lets you download statements/transactions in CSV/Excel, QIF, OFX, and Quicken/Money formats. EXPORT STEPS: Log in to NatWest Online Banking (web, not just the app) > select the account > 'Statements' or 'View transactions' / 'Download transactions' > choose the date range and the format (Excel/CSV, OFX, QIF, Quicken 2004+ / Money). CSV LAYOUT (NatWest): columns are typically Date, Type, Description, Value, Balance, Account Name, Account Number - NatWest uses a SINGLE signed Value (negative for debits). Dates are UK DMY (DD/MM/YYYY). A header row is present. QuickBooks model: in the UK QuickBooks Online uses Open Banking bank feeds for NatWest, NOT US-style Web Connect, so there is no credible INTU.BID to make QBO accept an uploaded file. Supported file path is QBO 'Manually upload transactions' (CSV). Page value: 'NatWest gives CSV/OFX/QIF - here's how to map the signed Value column and DD/MM dates into QuickBooks (Open Banking feed is the alternative).'
Is my NatWest data uploaded anywhere?
No. The conversion happens entirely in your browser. Your statement and account number never leave your device — safe even for client confidentiality requirements.
Will the file import into QuickBooks?
Yes. We generate a valid OFX 1.0.2 (SGML) document with the correct header and identifiers. Convert a small file free first to confirm it imports cleanly, then unlock unlimited.