How to Convert a Citi Statement PDF to CSV

Need your Citi transactions in a spreadsheet for taxes, expense reports, or your accountant? The fastest reliable route is to download the statement PDF from Citi and convert it to CSV yourself - no bank login, no third-party connection, and nothing uploaded to a stranger's server.

Citi does offer a download button for recent activity, but it has limits: it usually reaches back only a cycle or two, it skips pending items, and once a statement closes the in-account export is easy to miss. The statement PDF, on the other hand, is always available and is the complete, official record of a billing cycle. This guide shows you exactly where to find your Citi PDFs - on the website and in the Citi Mobile app - and how to turn them into a clean CSV.

The short answer

Download each Citi statement as a PDF from the Statements section of citi.com (or the Citi Mobile app), then run the PDF through a converter that extracts the date, description, and amount of every transaction into spreadsheet rows. To keep your account number and spending private, do the conversion on your own computer rather than uploading the PDF to a free online tool.

Step 1 - Download your Citi statement PDF

You can grab statements from either the website or the app. Both give you the same official PDF.

On citi.com (desktop)

• Sign in at citi.com with your User ID and password.
• From the top menu, open Statements & Documents (on a card account this lives under the account, sometimes labeled just Statements).
• Pick the account and the billing cycle you want. Citi typically keeps several years of statements online.
• Click the statement to open or download it as a PDF. Repeat for each month you need - for a tax year, that's all twelve cycles.

In the Citi Mobile app

• Open the Citi Mobile app and tap the account tile (your Citi card or bank account).
• Tap the menu, then Statements (look under "Account Services" or "Statements & Documents" depending on your app version).
• Select a cycle and tap the PDF / download icon. Save it to Files, or use the share sheet to send it to your computer.

Step 2 - Convert the PDF to CSV

A Citi statement isn't a spreadsheet - it's a formatted document with headers, a payment summary, rewards messaging, and then the transaction table. The goal of conversion is to pull just the transactions into clean rows: date, description, amount (and often a running category). You have a few options:

• Citi's own export. Inside the account, recent activity sometimes offers a "Download" with a CSV/Excel option. Useful for the current cycle, but it rarely covers the older months a return or expense report needs - which is why people fall back to the PDF.
• Manual retyping. Reliable but brutally slow, and one fat-fingered amount throws off your totals. Not worth it for a full year.
• A local PDF parser. Drop the statement PDF into a desktop tool that reads it and lays out each transaction as a row you can export. This is the approach that scales to a whole year of Citi statements without typing.

This is the step Quill was built for: drop in a Citi statement PDF and it parses every transaction locally, then lets you export the result to CSV (or a QuickBooks .QBO file) - all on your own computer, with no bank login.

Step 3 - Check the parsed transactions

Before you export, scan the parsed rows against the PDF. Citi statements have a few quirks worth a glance:

• Payments and credits. Make sure a payment to your Citi card or a returned-item credit is signed correctly (a credit reducing your balance, not counted as spending).
• Merchant names. Citi descriptions can be cryptic - "SQ *" prefixes for Square sellers, "TST*" for Toast restaurants, city/state codes appended to the merchant. The transaction itself is still captured; the label is just terse.
• Cycle boundaries. If you're stitching a tax year together, confirm you haven't double-counted a transaction that appears at the edge of two statements.

Step 4 - Export and put it to work

Once the rows look right, export to CSV. From there your Citi data is portable: open it in Excel or Google Sheets, hand it to your accountant, or import it into your bookkeeping software. If you use QuickBooks, exporting a .QBO file instead lets the transactions import directly without CSV-mapping headaches.

And because a CSV is just transactions, this is also the moment to do something useful with them. In Quill, the same parsed Citi statement can be split into Personal and Business buckets with auto-categorization (and a manual override on any line you disagree with), run through the subscription finder to surface recurring charges you forgot about, or fed into the debt payoff planner if that Citi card carries a balance.

Why the PDF route beats linking your bank

The popular budgeting apps want your citi.com login so they can sync through a third-party connection like Plaid. That hands a middleman standing access to your account and parks your transaction history in someone's cloud indefinitely. Working from the statement PDF inverts that: you already have the file, the conversion happens on your machine, and there's no live connection to revoke. For a one-off export - a tax year, an expense report, a loan application - it's both faster and far more private. For a deeper walkthrough that applies to any bank, see our guide on how to convert a bank statement PDF to CSV.