Convert a Citibank Statement PDF to Excel

Citibank statement layout, the multi-account combined statements, and how to split them into per-account data you can actually use.

Citibank frequently issues a single combined statement covering several accounts — a checking account, a savings account, sometimes a money market account, all in one PDF. That is convenient to receive and awkward to convert.

One PDF, several account contexts

Each account in a combined statement has its own opening balance, its own transaction list and its own closing balance. Merged into one flat table without an account identifier, the result is meaningless: the balance column jumps between accounts and reconciles against nothing.

The fix is an Account column, so every row carries the account it belongs to and you can filter, split, or verify each account independently. The converted file does not add one — it is the table Citibank printed — but it keeps every row in the order Citibank printed it, so each account's rows sit together and the column takes a minute to add.

Verifying a multi-account statement

Verification has to run per account, not across the whole file. Each account's opening balance, transactions and closing balance form their own chain. Summing every debit in a combined statement and comparing against one total is meaningless.

Label each account's rows Add an Account column and fill it down from the first row of each account's section, before sorting anything.
Check that account's chain Filter to it, then run from its opening balance through its transactions to its closing balance.
Compare that account's totals Against the totals Citibank prints for that account specifically.
Repeat per account Each is an independent verification.

Citi credit card statements

Citi cards are a separate case: no running balance, and transactions grouped by cardholder on multi-card accounts. Verification compares against the printed purchase and payment totals rather than chaining balances.

What the Citibank export contains

In the file	What you get
Citibank's own columns	Every heading as printed, in the same order. No Account column is added
Row order	Exactly as printed, so each account's rows stay together under its section
Dates	Exactly as printed, with nothing reformatted
Descriptions	In full, with continuation lines joined into one cell
Amounts and balances	Each figure in the column Citibank printed it in
A Completeness sheet	The rows checked against the balances printed beside them, and the statement's own totals where it prints them

Why the account has to come from the section header

Nothing on an individual transaction row identifies which account it belongs to. The only signal is the section header above it, which names the account and states its opening balance.

So the account is contextual, not intrinsic, and what preserves it is order. The converted file keeps every row where Citibank printed it, so you can label each block by the section it came from on the PDF. A tool that re-sorts rows by date before you see them has interleaved the accounts, and that cannot be undone.

Frequently asked questions

Can I export each account to its own file?

Yes, once each block of rows is labelled. The rows come through in printed order, so each account's rows are contiguous: copy each block to its own sheet, or add an Account column and filter on it.

Can I add the account column myself afterwards?

Yes, as long as the rows are still in printed order, which the converted file keeps. Label each block by the section it came from on the PDF before you sort anything.

Does it handle Citigold combined statements?

Yes. Those typically cover more accounts, which makes labelling each block before totalling more important, not less.

Convert a statement now

Bank Statement PDF to Excel, or see every format. More in the guides.