United States · Bank statement

Convert Citibank Bank Statement to Excel, CSV or QBO

Convert Citibank Bank Statement to Excel, CSV or QBO

Citibank, N.A. · Member FDIC · Official site

Citibank, N.A. · Member FDIC · Official site

Turn your Citibank PDF statement into Excel, CSV, or QBO in seconds with Docubrew. Built for US bookkeepers and accountants who are done re-keying transactions by hand. No broken columns, no manual cleanup.

Turn your Citibank PDF statement into Excel, CSV, or QBO in seconds with Docubrew. Built for US bookkeepers and accountants who are done re-keying transactions by hand. No broken columns, no manual cleanup.

Files never leave your computer

Rule-based parsing

Excel, CSV and QBO

No per-page limits on desktop

Convert your Citibank PDF

The Problem

Why bookkeepers keep a converter handy

Why bookkeepers keep a converter handy

Bank feed sync failure illustration

The Feed Breaks, or Misses Things

You're closing a client on Friday and the Citibank feed stops syncing, or it drops a pending charge that posted later at a different amount. The PDF is the actual record. The feed is only an approximation.

Manual transaction entry illustration

Still Typing Transactions by Hand?

A client hands over a year of Citibank PDFs and you start re-keying into a spreadsheet. It takes hours, and one missed digit throws off the whole reconciliation. Most tools that fix this make you upload sensitive client data to someone else's servers. You shouldn't have to choose between speed and where your clients' data ends up.

How it works

Convert a Citibank statement to Excel, CSV or QBO in three steps

Convert a Citibank statement to Excel, CSV or QBO in three steps

Docubrew turns a Citibank PDF into clean, structured data in three steps.

Docubrew turns a Citibank PDF into clean, structured data in three steps.

1

Uploading a Citibank PDF statement to Docubrew

Upload your Citibank PDF

Drag in a single monthly statement, or batch several at once.

1

Uploading a Citibank PDF statement to Docubrew

Upload your Citibank PDF

Drag in a single monthly statement, or batch several at once.

2

Selecting pages from a Citibank statement

Select the Pages You Need (Optional)

Preview every page and pick only the ones with transactions. Skip cover pages, disclosures, and summaries so you only export the data that matters.

2

Selecting pages from a Citibank statement

Select the Pages You Need (Optional)

Preview every page and pick only the ones with transactions. Skip cover pages, disclosures, and summaries so you only export the data that matters.

3

Downloading the converted CSV file

Download in the format you need

Get an Excel workbook, a CSV or a QBO file with debits and credits in their own columns and wrapped descriptions reassembled. A preview step lets you check the rows before anything reaches your books.

3

Downloading the converted CSV file

Download in the format you need

Get an Excel workbook, a CSV or a QBO file with debits and credits in their own columns and wrapped descriptions reassembled. A preview step lets you check the rows before anything reaches your books.

Citibank format

From a Citibank PDF to clean Excel, CSV or QBO file

Citibank statements are built to be read by people, not parsed by software, which is exactly why copy-paste falls apart. Docubrew is built around the Citibank layout so the data lands clean.

Citibank-Account-Statement.pdf

Synthetic example of a Wells Fargo bank statement in PDF format
Synthetic example of a Wells Fargo bank statement in PDF format

This is an example bank statement with no real data.

Citibank-Account-Statement.csv

Date,Description,Amount Subtracted,Amount Added,Balance
04/15,Deposit from Employer ABC Industries,,2950.00,4195.67
04/16,Zelle Transfer to Marcus Lee Ref # f9KpL2mN8r3,120.00,,4075.67
04/17,Shell Oil 574328 Houston TX,48.76,,4026.91
04/18,Kroger #841 Birmingham AL,67.23,,3959.68
04/18,Starbucks Store 03245 Birmingham AL,6.15,,3953.53
04/19,Online Transfer from Savings Ref # OT19A2K7,,500.00,4453.53
04/20,Netflix.com 866-579-7172 CA,15.49,,4438.04
04/20,Spotify USA New York NY,10.99,,4427.05

01

Separate Amount Subtracted and Amount Added columns

Citibank lists debits and credits as two distinct columns rather than one signed amount. Docubrew preserves that structure in the CSV.

01

Separate Amount Subtracted and Amount Added columns

Citibank lists debits and credits as two distinct columns rather than one signed amount. Docubrew preserves that structure in the CSV.

02

Descriptions that wrap across multiple lines

A single transaction (merchant, location, and category) often spans two or three lines in the PDF. Docubrew stitches them back into one description field.

02

Descriptions that wrap across multiple lines

A single transaction (merchant, location, and category) often spans two or three lines in the PDF. Docubrew stitches them back into one description field.

03

A running balance that isn't printed on every row

Citibank only prints the balance after some transaction lines, not every one. Docubrew extracts the balance exactly as it appears on the PDF.

03

A running balance that isn't printed on every row

Citibank only prints the balance after some transaction lines, not every one. Docubrew extracts the balance exactly as it appears on the PDF.

04

Combined statements

Citibank's Basic Banking and Simplified Banking statements often bundle a checking account and a savings account into a single PDF. Docubrew separates each account into its own clean output.

04

Combined statements

Citibank's Basic Banking and Simplified Banking statements often bundle a checking account and a savings account into a single PDF. Docubrew separates each account into its own clean output.

05

Repeated page headers

The account holder's name, account number, and statement period repeat at the top of every page. Docubrew strips these automatically so they don't show up as extra rows.

05

Repeated page headers

The account holder's name, account number, and statement period repeat at the top of every page. Docubrew strips these automatically so they don't show up as extra rows.

06

Non-transactional sections

Citibank statements include several non-transactional pages, fee schedules and error-resolution notices. Docubrew skips all of these and extracts only the actual transaction rows.

06

Non-transactional sections

Citibank statements include several non-transactional pages, fee schedules and error-resolution notices. Docubrew skips all of these and extracts only the actual transaction rows.

Citibank Facts

Date format

MM/DD on checking & savings statements (no year printed per line)

Statement retention

Up to 24 months online immediately. Older statements available on request

Native export

Statements & Documents offers PDF only, not CSV

Accounts

Citibank accounts we support

Citibank accounts we support

Docubrew has pre-built support for Citibank's main deposit-account types.

Docubrew has pre-built support for Citibank's main deposit-account types.

Personal checking and savings columns

Regular Checking

Savings

Citi Access Account (Simplified Banking)

Citibank® Savings Plus

Business accounts

CitiBusiness Streamlined Checking

CitiBusiness Interest Checking

CitiBusiness® Flexible Checking

Output

What you get: a clean,
structured data in three formats

  • PDF

    PDF

    PDF

  • CSV

    CSV

    CSV

  • CSV

    CSV

    CSV

Docubrew exports an Excel workbook (.xlsx), a CSV, or a QBO file with one row per transaction. Each row carries the fields you actually reconcile against.

Transaction date

Description / payee (reassembled when it wraps)

Amount (debit and credit in separate columns)

Running / ending balance

Check number (when present)

Account number & statement period

One clean output, everywhere you need it

Take .xlsx if you want a workbook that opens straight into Excel, formatting intact. Take CSV for Google Sheets, Xero, FreshBooks, and most accounting software that accepts CSV bank transactions. Take QBO for the QuickBooks bank feed. Whichever you pick, it's a clean import, not a live connection, so you stay in control of what goes into the books.

Get your PDF

How to download your Citibank statement as a PDF

1

Sign in

Sign in to Citibank Online at citi.com (or the Citibank Mobile app).

2

Open Account

Open the account you need from your accounts overview.

3

Statements

Go to Statements & Documents.

4

Select Month

Under Statements, pick the month you need, up to 24 months. Older statements can be requested from the same page.

5

Download & Convert

Download the statement as a PDF, then convert it with Docubrew.

Citibank only offers PDF statements here, so a converter is the reliable way to get statement data into a spreadsheet, especially for older periods.

Who it's for

Built for the people who live in bank statements

Wherever Citibank PDFs pile up, Docubrew turns them into clean, sortable data.

Bookkeepers and firms onboarding a client's year of bank statement PDFs and reconciling faster

Bookkeepers & Firms

Onboard a client's year of Citibank PDFs and reconcile in a fraction of the time.

Bookkeepers and firms onboarding a client's year of bank statement PDFs and reconciling faster

Bookkeepers & Firms

Onboard a client's year of Citibank PDFs and reconcile in a fraction of the time.

Small business owners tracking cash flow from converted bank statement data

Small Business Owners

Clean transaction data for cash-flow tracking without manual entry.

Small business owners tracking cash flow from converted bank statement data

Small Business Owners

Clean transaction data for cash-flow tracking without manual entry.

Structured, sortable bank statement records for tax filing and deductions

Tax Preparation

Structured, sortable records for filing season and deductions.

Structured, sortable bank statement records for tax filing and deductions

Tax Preparation

Structured, sortable records for filing season and deductions.

PDF bank statements turned into analyzable data for year-end and audit support

Year-end & Audit Support

Turn formal PDF statements into analyzable data when native export won't reach back far enough.

PDF bank statements turned into analyzable data for year-end and audit support

Year-end & Audit Support

Turn formal PDF statements into analyzable data when native export won't reach back far enough.

Security shield illustration for Docubrew showing client bank statement data stays with the bookkeeper, not on external servers

Trust & Security

Your clients' data stays where it belongs, with you

Local desktop processing

Local Desktop Processing

With the desktop app, everything runs locally on your device. Your clients' bank data never leaves your network.

Secure cloud conversion

Secure Cloud Conversion

Choose the cloud and your files are encrypted on upload and automatically deleted within 24 hours. Nothing is kept after that.

Rule-based deterministic parsing

Same Input, Same Output

Docubrew uses rule-based parsing, so the same statement always produces the same result. No AI, no guesswork, and nothing sent to a model for training.

FAQ

Answers to your questions

How do I convert a Citibank bank statement to Excel, CSV or QBO?

Upload your Citibank PDF statement to Docubrew, let the rule-based parser extract every transaction, and download the result as an Excel workbook, a CSV or a QBO file. On the desktop app the entire process runs on your own computer, so your statement is never uploaded anywhere.

Does Citibank let you download statements to Excel, CSV or QBO?

Official monthly statements are available only as PDF Outside the Statements page, Citibank (Citi) Online may let you download recent transaction activity as CSV, QFX, or QBO, but that's raw activity history rather than the formatted monthly statement, and availability varies by account type. Statements older than the most recent 24 months can be requested online and are typically ready within 24 to 48 hours, then stay available online for a limited time after that. Converting the PDF is the most reliable way to get a full, formatted statement into a clean spreadsheet.

Does Docubrew handle Citibank's separate Amount Subtracted and Amount Added columns?

Yes. Citibank statements list debits and credits in two distinct columns rather than one signed amount, and the running balance isn't printed after every transaction. Convert PDF Statement preserves the Amount Subtracted and Amount Added columns exactly as they appear, correctly classified, and extracts the balance only where Citibank actually printed one on the statement rather than estimating the missing values, so you're not stuck manually reconciling gaps in the balance column.

How accurate is the conversion?

Docubrew is near-perfect on digital (text-layer) PDF bank statements, the kind you download straight from Citibank's website. Every conversion ends with a preview step, so you can check the rows before you download. Nothing reaches your books unseen.

Can it convert scanned Citibank statements?

Docubrew currently processes text-layer (native digital) PDF statements, the kind you download straight from Citibank Online. Scanned and image-based PDF support is on the near-term roadmap. If that's blocking your workflow, contact us at support@docubrew.com and we'll let you know when it ships.

Do you convert Citibank credit card statements?

Not yet. Docubrew currently handles Citibank deposit-account statements, the checking and savings statements you download from Citibank Online. Credit card statement support isn't available at launch. If you need it, contact us at support@docubrew.com so we can gauge demand.

Is it safe to convert my bank statement here?

Yes. The desktop app parses your file entirely on your own machine, so nothing is uploaded or stored. The cloud option encrypts every upload and deletes files automatically within 24 hours.

Does it work with QuickBooks and Xero?

Yes. For QuickBooks you can export a QBO file and upload it straight to the bank feed. For Xero, Sage, FreeAgent, FreshBooks, and most other accounting software, the CSV imports directly. If you would rather work in a spreadsheet first, take the Excel workbook. Either way it is a clean import, not a live connection, so you stay in control of what goes into the books.

Can I convert several Citibank statements at once?

Yes. Batch processing lets you upload dozens of statements in a single run and download each result as its own file. It's built for firms reconciling multiple clients each month, so you're not converting one PDF at a time.

How is this different from other bank statement converters?

Docubrew offers both a desktop app for local processing and an encrypted cloud option. Many converters are cloud-only, and others make you choose desktop or cloud up front. If you need control over where each client's data is processed, that per-job flexibility matters.

More Banks

Convert statements from other banks

Docubrew has pre-built support for the largest US banks, with a fallback parser for most other formats.

Isometric illustration showing Docubrew workflow with PDF bank statements being converted to CSV files

Your Bank Statement Workflow Is About to Get a Whole Lot Easier

Built for bookkeepers, export Excel workbook, CSV and QBO files in seconds.

Isometric illustration showing Docubrew workflow with PDF bank statements being converted to CSV files

Your Bank Statement Workflow Is About to Get a Whole Lot Easier

Built for bookkeepers, export Excel workbook, CSV and QBO files in seconds.

Isometric illustration showing Docubrew workflow with PDF bank statements being converted to CSV files

Your Bank Statement Workflow Is About to Get a Whole Lot Easier

Built for bookkeepers, export Excel workbook, CSV and QBO files in seconds.