Convert Citizens Bank CSV to QBO / QFX / OFX
Drop your Citizens Bank CSV or Excel export below and get a Citizens Bank → 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 Citizens Bank
IDENTIFIERS UNCERTAIN - confidence low. ofxtools fi.cfg lists three Citizens entries by ofxhome ID only, with NO org/fid populated: [citizens-personal]=ofxhome 527 (Citizens Bank - Consumer), [citizens-biz]=ofxhome 528 (Citizens Bank - Business), [citizens]=ofxhome 664 (Citizens Bank). The exact ORG/FID for the large national Citizens (citizensbank.com / Citizens Financial Group) was NOT confirmed from a credible source, so org is left blank and fid set to '0' (unknown) rather than guessed. DISAMBIGUATION WARNING: 'Citizens Bank' is one of the most reused names in US banking - ofxtools also lists Citizens National Bank (#768), Citizens Bank and Trust (#990), Citizens Federal Credit Union (#991), Citizens Savings Bank (#992), and many more, all DIFFERENT institutions. Pick the ofxhome 527/528/664 family only for the national Citizens (RI-headquartered). INTU.BID not found - left blank. GOOD NEWS for this page: Citizens online banking exports natively in CSV, QBO, QBX, OFX and QIF, so many users can grab a real .QBO and skip conversion. EXPORT STEPS: sign in at citizensbank.com > click the account > use the 'Export' button (or 'Download Account Data' on the account history page) > pick date range and format (CSV/QBO/OFX/QIF). CSV COLUMN LAYOUT: standard Date / Description / Amount, single signed Amount column (debits negative). Date format US MM/DD/YYYY (MDY). Header row present.
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 Citizens Bank files
- Choose MM/DD/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 “Citizens Bank” in the bank dropdown autofills it.
FAQ
How do I export a CSV from Citizens Bank?
IDENTIFIERS UNCERTAIN - confidence low. ofxtools fi.cfg lists three Citizens entries by ofxhome ID only, with NO org/fid populated: [citizens-personal]=ofxhome 527 (Citizens Bank - Consumer), [citizens-biz]=ofxhome 528 (Citizens Bank - Business), [citizens]=ofxhome 664 (Citizens Bank). The exact ORG/FID for the large national Citizens (citizensbank.com / Citizens Financial Group) was NOT confirmed from a credible source, so org is left blank and fid set to '0' (unknown) rather than guessed. DISAMBIGUATION WARNING: 'Citizens Bank' is one of the most reused names in US banking - ofxtools also lists Citizens National Bank (#768), Citizens Bank and Trust (#990), Citizens Federal Credit Union (#991), Citizens Savings Bank (#992), and many more, all DIFFERENT institutions. Pick the ofxhome 527/528/664 family only for the national Citizens (RI-headquartered). INTU.BID not found - left blank. GOOD NEWS for this page: Citizens online banking exports natively in CSV, QBO, QBX, OFX and QIF, so many users can grab a real .QBO and skip conversion. EXPORT STEPS: sign in at citizensbank.com > click the account > use the 'Export' button (or 'Download Account Data' on the account history page) > pick date range and format (CSV/QBO/OFX/QIF). CSV COLUMN LAYOUT: standard Date / Description / Amount, single signed Amount column (debits negative). Date format US MM/DD/YYYY (MDY). Header row present.
Is my Citizens Bank 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.