Statements to Sheets logoStatements to Sheets
Built on
Google Cloud

Convert Citibank Statements to Excel and CSV

A Citibank statement is the monthly record of an account at the bank. Customers download it from online banking or receive it in the mail. It lists what came in, what went out and, in many cases, what was left at the end of each day.

Statements to Sheets reads those transaction lines and returns a CSV. Each row has a full date, a description and an amount with the right sign. If the file prints a running balance, it arrives as its own column. Open the result in Excel, or import it into Google Sheets or QuickBooks.

Upload your Citibank statement to see the first rows before you pay. The first 50 transactions are free.

What the conversion looks like

Sample converter output for a statement of this type, with invented data.

As converted

DateDescriptionAmountBalance
06/02/2025Payroll Deposit Example Co1425.003100.00
06/05/2025Example Grocery Purchase-63.403036.60
06/11/2025Example Power Co Payment-88.152948.45
06/18/2025Mobile Check Deposit220.003,168.45
06/27/2025Example Cafe Purchase-12.753155.70

Why a Citibank statement is hard to convert

Signs are easy to lose. A plain copy of the page can give you a number with no sign, and you cannot tell a paycheck from a rent payment. The sign has to be worked out from the statement itself.

Fees and interest matter too. Service charges and interest earned belong in the same sheet, in date order, next to the rest of the activity.

Account holders at a large bank often keep several accounts. A checking account, a savings account and a linked card may all send a PDF in the same week. Each file needs to land in the same shape, or the combined workbook turns into a puzzle.

A wrapped description is a trap for a basic tool. A long merchant name with a city and a reference code can run over two lines, and the second line should not become a transaction of its own.

About Citibank statements

  • The people who ask for a CSV vary a great deal. A student, a freelancer and a retiree can all hold accounts that produce statements.
  • Statements come as PDFs, monthly, and many customers keep a year or more of them. Older months are sometimes scanned from paper.
  • People turn them into rows to follow a budget, to prepare taxes, to document income for a lender or a landlord, or to hand a bookkeeper the records.

How we convert it

  • Deposits are positive. Withdrawals are negative.
  • Every row gets the full year.
  • A Balance column appears only when the file prints one. We never calculate or guess a balance.
  • The second line of a wrapped description is not counted as a separate transaction.
  • Scanned pages are read with OCR, and sideways pages are turned upright.

Every conversion also checks each page against the page image, and lines that continue a wrapped description are not counted as extra transactions.

The result is a CSV with Date, Description and Amount columns (plus Balance when the statement has one) that opens in Excel and imports into Google Sheets and QuickBooks. You pay per transaction, not per page. See plans and pricing.

What people do with the file

Tax preparation. Combine the monthly files into one workbook, filter the deposits, and total your income for the year without retyping a single line.

Proof of income. A landlord or lender may ask for several months of activity. A tidy sheet that shows each deposit is easier to share than a stack of PDFs.

Budgeting. Load the CSV into Google Sheets, tag each merchant with a category, and see where the month went.

Bookkeeping. Import the rows into QuickBooks so a small business does not have to key in its bank activity by hand.

Good to know

  • Credit card and loan statements from the same bank may be laid out differently from account statements.
  • Scans can contain OCR digit errors. Compare totals with the statement.

Questions

Will a withdrawal come out as a negative number?

Yes. Withdrawals are negative and deposits are positive, so the Amount column adds up to the net movement of the account.

Does the CSV include a balance?

Only when your file prints one. The Balance column is copied from the document, and we never work one out ourselves.

Can I convert a scan of a mailed statement?

Yes. Scans are read with OCR, and sideways pages are turned upright. Compare the totals with the paper copy, because a scan can hide a digit.

What does it cost?

The preview is free, and so are the first 50 transactions. After that you pay per transaction, not per page.

Related Guides

Jeff Gough

Written by

Jeff Gough

Founder of Statements to Sheets and Cascade Foundry LLC. Built this tool after converting 300+ pages of printed bank statements into CSV for a friend's QuickBooks catch-up. Read the full story →