Upload any Citi statement PDF — Citigold, Citi Priority, Basic Banking, Citibusiness Streamlined, Citibusiness Flexible, or a Citi credit card statement (Double Cash, Costco Anywhere, Premier, Diamond Preferred) — and get a clean Excel file with one row per transaction, running balance preserved.
Convert your Citi statement — free
Citi consumer and business statements organize transactions into separate columns for Deposits and Withdrawals on the same row band, which means generic PDF tools that scan top-to-bottom miss the structural relationship and produce orphan rows. Multi-account Citi Priority statements bundle checking + savings + Citigold Money Market in one PDF — each ledger needs to be split out per account number for reconciliation.
Citi credit card statements (Double Cash, Costco Anywhere, Premier, Custom Cash) bury the actual purchase list under several pages of rewards summary, statement balance breakdowns, and minimum-payment disclosures. Foreign-transaction-prone cards (Premier, Strata Premier) need both the original currency and USD-converted amount preserved.
PDFExcel handles Citi's Deposits/Withdrawals column structure — both columns merge into a single signed Amount column with Section preserved if you want to filter. Multi-account Citigold and Citi Priority statements split per account number into separate tabs. Running balance reconciles end-to-end against the printed ending balance.
Citi credit card statements skip the rewards-summary pages and extract the purchase list with merchant, category, transaction date, posting date, and amount. Foreign currency charges (common on Premier and Strata Premier) preserve original amount + currency code + USD-converted equivalent. Drop the export into QuickBooks via PDF import, Xero, or your reconciliation worksheet. Built-in OCR handles scanned Citi statements automatically.
The model recognizes Citi's column-split layout (Deposits and Withdrawals as parallel columns) and merges them into a single ledger — and knows that Citi credit card statements have a 'Standard Purchases' section separate from 'Cash Advances' and 'Balance Transfers'.
Generic PDF tools either misread Citi's column structure or skip the multi-account section split. PDFExcel reads Citi's layout natively across consumer, business, and credit card products.
Deposits/Withdrawals columns merged into a signed Amount column. Running balance reconciles to printed ending balance.
| # | Date | Description | Debit | Credit | Running Balance |
|---|---|---|---|---|---|
| 1 | 03/01/2025 | Beginning Balance | $48,210.40 | ||
| 2 | 03/04/2025 | DIRECT DEPOSIT — TECHWAVE INC PAYROLL | $8,420.00 | $56,630.40 | |
| 3 | 03/06/2025 | ACH WITHDRAWAL — CHASE CARD AUTOPAY | $2,184.00 | $54,446.40 | |
| 4 | 03/09/2025 | ZELLE TO L. PARK — RENT 03/2025 | $3,200.00 | $51,246.40 | |
| 5 | 03/12/2025 | ATM WITHDRAWAL — 388 PARK AVE NEW YORK NY | $200.00 | $51,046.40 | |
| 6 | 03/16/2025 | INTEREST CREDIT | $8.42 | $51,054.82 |
Citigold private clients with linked checking + savings + investment accounts, bookkeepers running Citibusiness clients, controllers tracking corporate Citi credit card spend.
Marketing agency on Citibusiness Streamlined Checking. Monthly statement runs 14 pages. Convert to QuickBooks-ready CSV, import in 3 minutes.
Pulls quarterly Citigold statements (linked checking + savings + investment) for HNW client review. Multi-account split lets each ledger reconcile independently.
International T&E spend across 8 cardholders. Foreign-transaction column preservation matches Premier's frequent overseas charges to FX rates for reconciliation.
Yes. The two columns merge into a single signed Amount column (negative for debits, positive for credits). The Section tag is preserved if you want to filter or pivot by Deposits vs Withdrawals.
Yes. Multi-account statements (linked checking + savings + Money Market) split per account number into separate tabs in the output workbook so each ledger is independently reconcilable.
Yes. The first 2-3 pages of credit card statements (rewards balance, statement summary, minimum-payment disclosure) are skipped. Extraction starts at the 'Standard Purchases' section.
Foreign currency charges preserve both the original amount (with currency code) and the USD-converted amount. Useful for international travel reconciliation and FX gain/loss tracking.
Yes. Export as CSV with QuickBooks' standard columns and import via Banking → File Upload. The dedicated QuickBooks PDF import flow pre-formats Citi exports to QBO's exact schema.