Citi Bank Statement Format Guide: Checking, Savings and Card Layouts

ClearlyLedger converts Citi checking, savings, and credit card PDF statements into clean Excel and CSV files for bookkeeping, tax, lending, and finance review. The Citi profile handles multiple account sections, card-statement variants, international wire references, foreign transaction context, and balance verification before export.

Last updated 2026-06-05

Citi statement formats

Citi deposit statements can include linked checking and savings sections on the same PDF, while Citi credit card statements use a different charge and credit layout.

ClearlyLedger detects the statement type and separates account sections so checking, savings, and card activity do not collapse into one ambiguous ledger.

International wires and card details

Citi statements often include international wire references, foreign transaction notes, merchant details, and exchange-rate context on continuation lines.

The Citi profile preserves those references where possible while normalizing dates, descriptions, debits, credits, and balances for Excel or CSV review.

Exports for US accounting workflows

Use Excel when reviewing Citi statements for tax prep, lending packs, cash-flow analysis, or card spend review. Use CSV when importing into QuickBooks Online, Xero, or another accounting workflow.

ClearlyLedger checks the extracted rows against printed balances and section totals before export, helping catch missing rows or sign errors early.

Related workflows

Continue from this guide into the matching converter, accounting import, security, or country hub pages so crawlers and readers can follow the full workflow.

Frequently asked questions

How do I convert a Citi statement to Excel?

Upload the Citi PDF to ClearlyLedger. The Citi profile is detected automatically, account sections are normalized, balances are verified, and the statement is exported to Excel.

Can I convert Citi statements to CSV?

Yes. ClearlyLedger exports Citi transactions to CSV with date, description, reference, debit, credit, and balance columns for accounting imports and reconciliation.

Does it support Citi credit card statements?

Yes. Citi credit card layouts are handled separately from deposit-account statements so charges, payments, credits, and FX rows stay clear.

Does it preserve wire and foreign transaction references?

Yes. Wire, ACH, card, merchant, and foreign transaction context is preserved where possible for review and reconciliation.

What this page covers

Citi Bank Statement Format Guide: Checking, Savings and Card Layouts explains how ClearlyLedger converts bank statement PDFs into spreadsheet-ready data while preserving transaction dates, descriptions, debit amounts, credit amounts and balances. The page is written for accountants, bookkeepers, finance teams and business owners who need reliable Excel or CSV output instead of manual copy-paste.

How ClearlyLedger verifies output

The converter checks extracted rows against statement balances wherever the PDF provides enough information. That means opening balance plus credits minus debits should reconcile to the closing balance before you use the exported file in bookkeeping, tax preparation, lending review or account reconciliation.

Supported exports and privacy

ClearlyLedger exports clean Excel and CSV files for spreadsheet review and accounting workflows. Source PDFs are processed securely, are not used to train AI models, and are deleted after processing according to the site's data-retention policy. The same conversion workflow supports recurring close, tax, lending and reconciliation review.

Accuracy workflow

The extraction flow separates statement chrome from transaction rows, normalizes date and amount formats, preserves long descriptions, and flags rows that need human review. The goal is not only to create a spreadsheet, but to create an audit-friendly file that can be filtered, sampled, and reconciled before it enters QuickBooks, Xero, Excel, or a lender review pack.

Who this helps

Accountants use ClearlyLedger when clients send historical PDFs instead of bank feeds. Bookkeepers use it for monthly close and catch-up work. Finance teams use it for reconciliation, cash-flow analysis, loan applications, tax preparation, and multi-bank review where manual copy-paste would be slow and error-prone.

What to review before using the export

Before importing the file into accounting software, review the statement period, opening and closing balances, any low-confidence rows, and the first and last transaction on each page boundary. These checks catch the mistakes most common in PDF extraction: repeated headers, skipped wrapped descriptions, subtotal rows, sign reversals, and dates that were inferred from a statement period rather than printed on every row.

For client work, keep the original PDF beside the exported spreadsheet during review. The PDF remains the source document, while the Excel or CSV file becomes the working ledger used for filtering, coding, reconciliation, and upload into downstream bookkeeping systems.

Related ClearlyLedger resources

Use these canonical pages to compare formats, verify data handling, and move from PDF extraction into accounting review.

Loading interactive converter… Try ClearlyLedger free