Convert Citigroup Bank Statement to Excel

Citigroup statement converter — export to Excel XLSX or CSV in minutes

PDF, JPG, PNG, BMP, HEIC, TIFF

Upload your bank statement

Uploading...
Convert bank statement →
Extracting ...

Why convert Citibank PDFs to Excel?

Citi statements may include global wire descriptors, SWIFT references and cross‑border card activity that break when pasted. BankXLSX normalizes fields into clean columns for analysis.

  • Understands fields: Value Date, Post Date, Description, SWIFT/Ref, Debit, Credit, Balance
  • Keeps international characters and currencies intact in text columns
  • OCR support for scanned Citi PDFs
  • Exports to Excel/CSV for multinational close and audit
Accurate parsing

Purpose‑built models trained on North American bank formats deliver clean columns for reconciliation and analytics.

Excel (XLSX) & CSV

Download spreadsheets that match common import templates and pivot‑table workflows.

Secure by design

Secure connections and short‑lived processing. You remain in control of your data.

How to convert Citigroup PDF to Excel

Upload your PDF statements from Citigroup online banking or mobile app.

We parse dates, descriptions, references, debits, credits and running balances with OCR for scans.

Export your results to Excel (XLSX) or CSV and import into your finance stack.

Citigroup bank statement to Excel — keywords & use cases

Popular searches: "convert Citigroup statement to Excel", "Citigroup CSV download", "Citigroup PDF to spreadsheet", "Citigroup reconciliation Excel".

Use cases: month‑end close, audit schedules, cash‑flow analysis, expense review, loan underwriting, diligence, tax prep.

Supported entries: ACH, wires, checks, card settlements, ATM/cash, interest, fees; consistent running balances.

Historical archives and multi‑account workflows supported with bulk conversion.

Citibank formats, fields and normalization

Citibank and CitiBusiness statements may present activity with both a Value Date and a Post Date. BankXLSX preserves both fields and, by default, assigns Post Date to the primary Date column for reconciliation, while Value Date is available as an auxiliary field in the exported workbook.

  • Date handling: ISO‑8601 (YYYY‑MM‑DD) normalized in the XLSX while retaining the original display format for audit.
  • Amounts: strictly typed numeric cells with consistent signs (debits negative, credits positive) to prevent pivot/table surprises.
  • Currency: currency symbols and thousands separators are stripped from numeric fields; currency codes in descriptions (e.g., USD, EUR, GBP) remain in text columns.
  • Balance: running balance is preserved on each row whenever present; interim banners/footers are dropped.

International wires frequently include SWIFT/BIC, intermediary bank refs, and free‑form advice. Our parser keeps these descriptors intact in a dedicated Reference column and a long Description column to avoid truncation.

  • Wire patterns: MT103/MT940 hints, SWIFT/BIC (8–11 chars), and Citi wire advice keywords (OUR/SHA/BEN).
  • ACH addenda: CCD/CTX addenda stored in a separate Text column when available.
  • Card settlements: merchant name, city/country and terminal IDs preserved in Description.
  • Checks: serial numbers mapped to Check Number column for easy matching to AR/AP.

Step‑by‑step reconciliation workflow

  1. Export the Excel (XLSX) file and open the “Transactions” tab.
  2. Sort by Post Date, then filter by Description to group ACH, Wires, Checks and Card.
  3. Create a pivot by Description (rows) and Amount (values, sum) to spot duplicate imports or partial postings.
  4. VLOOKUP/INDEX‑MATCH the Reference column against your ERP payment IDs (e.g., Netsuite/QuickBooks) to auto‑tag cleared items.
  5. Tie beginning and ending balances to the statement header; differences indicate missing or extra lines.
  6. For multi‑currency cards, filter by Description containing currency codes (e.g., “EUR*”) and validate FX impact.
  7. Save the workbook as a monthly reconciliation pack; retain the unmodified export as evidence.

Export columns & data types

Core
  • Post Date (date)
  • Value Date (date, optional)
  • Description (long text)
  • Reference (text)
Financial
  • Debit (number)
  • Credit (number)
  • Amount (signed number)
  • Running Balance (number)
Enrichment
  • Instrument (Wire/ACH/Check/Card/ATM/Other)
  • Check Number (text)
  • Counterparty (text, parsed where available)
  • Notes (text, OCR residue/flags)

Troubleshooting & quality checks

  • Garbled characters: enable “Retain original encoding” in your PDF exporter; our OCR layer also normalizes common diacritics.
  • Missing balance: some Citi PDFs omit running balance on interim pages — BankXLSX computes a validated running balance from Amount when needed.
  • Partial month overlap: when monthly statements overlap by a day, dedupe using Post Date + Amount + Reference key.
  • Scanned PDFs: try the high‑resolution export; OCR quality improves noticeably above 200 DPI.

Compliance, security and auditability

BankXLSX processes files over secure connections and produces immutable exports that are suitable for audit packages. We do not alter numeric values, and we preserve enough contextual text to re‑trace any reconciliation step.

Citigroup statement converter FAQs

Which account types are supported?

Checking, savings, credit card and corporate accounts.

Will the running balance be preserved?

Yes — we keep running balances and validate totals in Excel output.

Can I export to CSV?

Absolutely. Export results as Excel (XLSX) or CSV.

Do you support scanned statements?

Yes, OCR reads scanned or photographed statements with strong accuracy.

Other Bank Statement Converters

ICICI Bank Statement Converter JPMorgan Chase Statement Converter Bank of America Statement Converter Morgan Stanley Statement Converter Wells Fargo Statement Converter Goldman Sachs Statement Converter U.S. Bancorp Statement Converter PNC Financial Services Statement Converter Truist Financial Statement Converter Capital One Statement Converter