Format Citizens Bank CSV for QuickBooks

Stop manually editing your Citizens Bank spreadsheets before every import. The core issue is that citizens Bank exports Credits before Debits and some branches produce Quicken format by default, causing split-amount columns to be swapped when mapped by position. This tool maps Credits and Debits by exact header name regardless of column order so deposits and withdrawals are never swapped.

LedgerMatch works with Google Sheets™ for spreadsheet-based bank reconciliation. Send your bank and ledger data from a spreadsheet, match transactions, and review exceptions without connecting your bank account.

Read the Citizens Bank CSV CSV format guide

Add to Chrome — it’s free · Included with all plans Install Google Sheets™ add-on Install for Microsoft Edge