Document Guide

Convert Citibank Statements to Excel

Handles Citibank's multi-account summary page and per-account transaction detail sections automatically — no manual copy-paste from checking, savings, or Citi Priority tables.

Citibank statements — especially Citi Priority and Citigold combined statements — open with an Account Summary page listing each linked account (checking, savings, sometimes a linked credit card) with its own beginning and ending balance, followed by separate transaction detail blocks per account. That structure trips up generic PDF-to-table tools because they treat the whole document as one table and merge balances across accounts. pdfexcel.ai reads each account section separately, maps the Trans Date, Description, Debits, Credits, and Balance columns correctly per block, and outputs one row per transaction in Excel or CSV, ready for reconciliation or bookkeeping software.

Who This Is For

  • Small business owners with Citibank Business Checking or Citi Priority accounts who need transaction data in Excel for reconciliation
  • Bookkeepers and accountants managing clients with multiple linked Citi accounts on a single combined statement
  • Freelancers and consultants tracking incoming payments and wire transfers listed in Citibank statement detail sections
  • Anyone preparing loan, mortgage, or visa applications that require several months of Citibank transaction history in spreadsheet form

When This Is Relevant

  • Monthly reconciliation across checking, savings, and money market sub-accounts on one Citi statement
  • Tax season, when 12 months of PDF statements need to become one combined spreadsheet for a bookkeeper or CPA
  • Loan or mortgage underwriting requests asking for transaction-level Excel exports, not just PDF copies
  • Migrating historical Citibank transaction data into QuickBooks, Xero, or a budgeting spreadsheet

Supported Inputs

  • Digital Citibank PDF statements downloaded from Citi Online or the Citi Mobile app
  • Scanned paper copies of older Citibank statements
  • Photos of printed Citibank statements taken with a phone camera
  • PNG or JPEG screenshots of statement pages

Expected Outputs

  • Excel (.xlsx) file with one row per transaction, including date, description, debit/credit amount, and running balance
  • CSV file formatted for import into accounting tools, matching common bank-feed column expectations (Date, Description, Amount, Balance)

Common Challenges

  • The Account Summary page lists Checking, Savings, and sometimes a linked credit card side by side with separate beginning/ending balances — tools that treat the page as one flat table often merge these into a single incorrect balance
  • Wire transfer and ACH descriptions in the transaction detail wrap across two or three lines; naive table extraction splits them into extra blank rows instead of keeping them as one transaction
  • Scanned or faxed Citibank statements with slightly skewed pages shift the Debits and Credits columns out of alignment, causing amounts to land in the wrong column
  • Citi Priority and Citigold statements use a different column order (Credits before Debits) than basic Citibank checking statements, so a fixed template built for one layout misreads the other

How It Works

  1. Upload one or more Citibank statement PDFs (or photos/scans) to pdfexcel.ai
  2. The AI identifies the Account Summary page and each per-account transaction detail section separately, rather than reading the document as one continuous table
  3. Fields are mapped per account block: Trans Date, Description, Debits, Credits, and Balance — you can adjust or add custom fields if your statement layout differs
  4. Review the extracted rows on screen, then export to Excel (.xlsx) or CSV, or set up a recurring pipeline for monthly statements

Why PDFexcel.ai

  • Recognizes multi-account summary layouts instead of collapsing checking and savings balances into one table
  • Custom field selection lets you pull only what you need — for example just Date, Description, and Amount for a bookkeeping import
  • Batch processing handles a full year of monthly Citibank statements in one run instead of uploading each PDF separately
  • OCR support means older scanned or photographed Citibank statements can be converted, not just digital exports

Limitations

  • Very old or heavily formatted Citibank statement templates with nested sub-tables may require a manual review pass after export
  • Handwritten annotations or notes added to a printed statement before scanning are not reliably recognized
  • Statements with redacted account numbers or amounts (e.g., for sharing with third parties) may produce missing values in those fields
  • Accuracy depends on scan quality — a skewed or low-resolution photo of a statement page can misalign columns and requires straightening or a clearer rescan before upload

Example Use Cases

  • A bookkeeper reconciling three linked Citi Priority accounts each month exports all transactions to one Excel workbook instead of retyping balances from the summary page
  • A small business owner preparing a loan application converts 12 months of Citibank Business Checking statements into a single CSV for the lender
  • An accountant handling year-end tax prep batch-converts a client's Citibank statements from PDF into Excel to speed up categorization
  • A freelancer tracking incoming client wires pulls just the Description and Amount fields from monthly Citibank statements into a running spreadsheet

Frequently Asked Questions

Does this handle Citibank statements with multiple linked accounts on one PDF?

Yes. Citi Priority and Citigold statements often combine checking, savings, and sometimes a credit card summary on one Account Summary page followed by separate transaction sections. The AI processes each account block separately rather than merging balances into one table.

Will the exported Excel file separate checking transactions from savings transactions?

Yes, transactions are extracted per account section as they appear in the original statement, so checking and savings rows are not mixed together in a way that loses which account each transaction belongs to.

Can I convert a scanned or photographed Citibank statement, not just a digital PDF?

Yes, OCR is used for scanned documents and photos. That said, a skewed or blurry photo can cause column misalignment (Debits vs. Credits), so a straight, well-lit scan gives more reliable results.

What format should I use to import Citibank data into QuickBooks or Xero?

Export as CSV with Date, Description, and Amount columns — this matches the general bank-feed CSV format most accounting tools expect (Banking → File Upload → CSV, then map columns during import). Excel (.xlsx) is better if you want to review or edit the data first.

Ready to extract data from your PDFs?

Upload your first document and see structured results in seconds. Free to start — no setup required.

Get Started Free

Related Resources