Avyth Moneyby Avyth

Guides by bank

How to convert a Citizens Bank statement to QuickBooks, Excel or CSV

Citizens keeps up to 18 months of statements in Online Banking's Document Center, and it has an Export button for transactions. This page covers getting a statement or transaction file from Citizens, turning it into a clean CSV, Excel, QuickBooks (.qbo) or OFX file with Statement Converter, and importing it into QuickBooks Online or QuickBooks Desktop.

Statement Converter runs in your browser. Your statement is read on your own computer and is never uploaded.

You might not need a converter. Citizens says you can export transactions for Quicken: "You can download transactions from your account by clicking on the account. Then use the "Export" button and select your download criteria and format you need." Its page doesn't list the formats. If Export offers one your software takes, for the months you need, use it. Statement Converter helps with statements you only have as PDFs, with several statements merged into one file, or when you want a tidy spreadsheet.

Step 1: Download your statement from Citizens

Transactions as a file (CSV). Citizens' Online Banking FAQ says: "You can download transactions from your account by clicking on the account. Then use the "Export" button and select your download criteria and format you need." It doesn't list the formats. If CSV is one of them, choose CSV. Statement Converter reads CSV and PDF only, not QFX, OFX or QIF.

How far back: "You can view up to 18 months of transaction history. (12 months of statement activity for personal credit cards)"

Statements. Citizens says: "Up to 18 months of your statements are available online and can be retrieved immediately in Online Banking under the "DOCUMENT CENTER" tab. Simply use the Filter to select the account and timeframe for the statement you are requesting. Statements can be saved or downloaded any time for longer storage needs. If you wish to order a statement older than 18 months, simply click on the "Contact Us" link."

Citizens lists "most deposit, line of credit, and loan accounts" as having statements in the Document Center. Use Online Banking rather than the app: Citizens says "e-statements, transfer set-up and self-initiated services like stop payments are not available using your Citizens Mobile Banking App."

Source: Citizens — Mobile & Online Banking FAQs

Step 2: Convert it with Statement Converter

  1. Open statements.avyth.com/convert and click Choose CSV or PDF statements. Pick your Citizens CSV or PDF file. The free version converts one statement at a time; the paid version takes several at once.
  2. Check the preview. The page tells you how each file was read. If money coming in shows as money going out, click Flip signs for that file.
  3. Under Download as, pick CSV, Excel (.xlsx), QuickBooks (.qbo) or OFX.
  4. If you picked QuickBooks (.qbo), answer Where should QuickBooks put it?

    • New account in QuickBooks: Under This is a:, choose bank account or credit card statement. Then Pick the bank this statement came from: type the entry's name in the search box. Many unrelated banks are also called Citizens: for a bank account, typing just Citizens matches more than a hundred, and the list shows the first 50, so type more of the name. On Intuit's list (checked 2026-09-25), nine entries carry Citizens' own website, citizensbank.com (not look-alikes such as gocitizensbank.com or firstcitizensbank.com). Five of them have plain Citizens names:

      • Citizens, listed for both bank accounts and credit cards (type Citizens; it's shown first).
      • Citizens Credit Card and Citizens Business Credit Card, for credit cards only.
      • Citizens Bank QBDT and Citizens Commercial Banking, for bank accounts only (type Citizens Bank QBDT or Citizens Commercial).

      The other four, Citizens Bank - Mid Atl Cons. Web, Citizens Bank - Mid Atl Bus. Web, Citizens Bank - New Engl Bus. Web and Citizens Bank-Not Your TypicalBank, are bank-account entries with regional or older names. Intuit's list doesn't say what they're for, or which entry Citizens' own downloads use. Use one of those four only if a .qbo you downloaded from Citizens for your account uses it; if you have such a file, the next option copies its exact ID for you.

      The list is Intuit's own, and for a card statement it only shows entries Intuit lists for credit cards. The file carries that bank's QuickBooks ID. If QuickBooks already has an account for this bank with the same account number, the transactions go there, so only convert months you haven't already downloaded from Citizens. Type the same account number each month to keep the months together. If you added several statements, tick the box that says they are all from that bank and one account; otherwise convert them one at a time. If you can't find the bank, click My bank isn't listed. You won't get a .qbo file; download CSV or Excel instead. QuickBooks Desktop only accepts files for banks registered with Intuit, and we won't label your file as another bank.

    • An account I already import into from my bank: if you have a .qbo file from Citizens for that account, choose it. The converter copies its bank ID and account number, so QuickBooks treats the converted file like one from Citizens. That .qbo file is also read in your browser and never uploaded. If you don't have one, use New account in QuickBooks.

  5. Click the download button. Its label names the format you picked, for example Download QuickBooks (.qbo) or Download CSV.

What's free: one statement at a time, converted to CSV. $5 a month: any number of statements together, plus Excel, QuickBooks and OFX.

PDFs need a text layer. A scanned PDF (a picture of a page) can't be read.

Step 3: Import into QuickBooks Online

  1. Open Bank transactions. In the newer QuickBooks layout it's under All apps → Accounting → Bank transactions.
  2. Select the Link account dropdown, then Upload from file.
  3. Choose the .qbo file (or the CSV), pick the QuickBooks account it belongs to, and follow the prompts.

Intuit's limits: files up to 350 KB and 1,000 transactions per upload. If you hit either one, convert fewer months at a time. For a CSV upload, Intuit says the file should have 3 columns (Date, Description, Amount) or 4 (Date, Description, Credit, Debit). Statement Converter's CSV has more columns than that, so the .qbo file is the simpler route.

Source: Intuit — Manually upload transactions into QuickBooks Online

Step 4: Import into QuickBooks Desktop

  1. Go to Banking → Bank Feeds → Import Web Connect Files (or File → Utilities → Import → Web Connect Files).
  2. Select the .qbo file and click Open.
  3. Choose Use an existing account if the account is already in QuickBooks, or Create a new QuickBooks account.

Things to know:

  • Intuit says importing a .qbo file requires you to be signed in to your Intuit account inside QuickBooks Desktop.
  • In our experience (not from Intuit's articles), QuickBooks Desktop rejects a Web Connect file from a bank it doesn't recognize. That's why the converter asks which bank the statement came from and writes that bank's own QuickBooks ID from Intuit's list. It never labels your file as a different bank.
  • In our experience, Desktop can refuse to import into an account that has a live automatic bank feed. If it does, turn that feed off first (Edit Account → Bank Feed Settings → Deactivate All Online Services), or import into a new account.
  • Intuit ended online banking services for QuickBooks Desktop 2023 on May 31, 2026 ("You won't be able to download transactions"). Earlier versions were already unsupported. If you're on 2023 or earlier, plan on a supported version.

Sources: Intuit — Set up bank feeds in QuickBooks Desktop · Intuit — Fix Web Connect import errors · Intuit — Desktop 2023 discontinuation

FAQ

I need a Citizens statement older than 18 months. Citizens says statements older than 18 months can be ordered with the Contact Us link in Online Banking. When you have the PDF, convert it the same way.

There are lots of "Citizens Bank" entries in the bank list. Which is mine? Several unrelated banks share the name. Pick an entry whose website is exactly citizensbank.com (the list shows each bank's website), preferably one of the five with plain Citizens names in Step 2. If you're not sure, My bank isn't listed gives you CSV or Excel instead.

Is my statement uploaded anywhere? No. The file is read and written in your browser. Statement Converter is an independent tool from Avyth LLC. It isn't affiliated with or endorsed by Citizens Bank or Citizens Financial Group, or by Intuit (QuickBooks).

Open Statement Converter →