To get a Citibank statement to Excel, download the statement PDF from Citi Online, convert it into one row per transaction, and add an Account column whenever the statement covers more than one linked account. Then check each account's beginning balance plus its own lines against that account's ending balance, never the statement as a whole.
Downloading a Citibank statement PDF from Citi Online
Citi Online offers recent statements as PDF files. Sign in, open the statements area for the account, choose the statement date, and download it. Save the file rather than only viewing it, and rename it with the account and month so a folder of Citi statements stays readable.
Which copy to convert
The downloaded PDF is the copy to convert. It holds the characters Citi printed, so amounts come through exactly. A photograph or scan of the paper statement holds only an image, and every digit must be recognised before it can be used. If the paper copy is all you have, it is usually faster to download the PDF for that month than to scan and check a printed one.
Pop-ups and browser settings
Citi's own guide to requesting previous statements notes that the statement opens in a pop-up box, so pop-ups need to be allowed for the site. If you click a statement and nothing happens, that is the first thing to check. The same guide says you can open the PDF to view it straight away or save it to your computer.
A quick look before you convert
Open the PDF and scroll to the end. Confirm the last page shows the ending balance for each account listed on the first page. A statement whose final page did not download fully converts into a sheet that cannot be checked, and it is better to download it again now than to discover the gap later.
Why are some older Citi statements missing from the list?
Citi's guide to requesting previous statements, written for Citi card accounts, says only statements issued after the card was registered for Citi Online are immediately available. Older ones are requested from an Older Statements section, and a request may take 48 to 72 hours. Once a request is ready, it shows as ready for download.
How the request works
The guide lays out the steps. Pick the statement year and month from the drop-down boxes, click Request, and the request appears in a status area marked as processing. To ask for several months, make another request for each one. After two or three days, sign back in, open the statements link, and look in the request status area for the months marked ready.
Plan around the wait
If you need a year of Citi statements for a loan application or a tax question, request the older months first, then convert the recent ones while you wait. Convert each month as it arrives rather than waiting for the full set. A month that fails its balance check is easier to sort out while the PDF is fresh in your downloads folder.
Bank accounts and card accounts
The request guide is about card statements, and Citi's banking accounts may show their history differently in the same online service. If the month you need is not listed for a checking or savings account, look for an option to request older statements within that account's statements page, or contact Citi and ask for a copy.
Citi statements that hold more than one linked account
Some banks print linked accounts, such as a checking account and a savings account held together, in a single combined statement. If your Citi statement lists more than one account on its first page, each account has its own section, with its own beginning balance, its own transaction list and its own ending balance.
Spotting the account boundaries
Look at the first page. A combined statement usually opens with a summary listing every account and its balances. Then, inside the document, each account's section starts with a header naming the account type and the last few digits of its number. Note those headers and the page each one starts on. That short list is your map for the conversion.
Why a single list does not work
A converter that ignores the account headers will give you one long list of transactions from every account, in page order. It looks complete. But a transfer from checking to savings now shows up twice, once going out and once coming in, and the two lines cancel. The checking balance and the savings balance get mixed together, so neither can be checked. You would have rows, but no way to prove they are right.
Card accounts are separate
A Citi credit card is a different statement. Even when you see it in the same online service, its PDF arrives on its own, with charges and payments rather than deposits and withdrawals. Keep it out of the bank account workbook. Card statements from other issuers work the same way, and the guide to converting an American Express statement to Excel covers a card layout in detail.
Splitting each Citi account into its own Excel rows
Add an Account column and fill it from the account header that each line sits under, then split or filter by that column. Every row keeps its link to the account it came from. You can then work with each account alone or view them together without losing track of which is which.
A worked example
The figures below are made-up examples from a two-account statement. The checking account ending 2231 starts the month at 3,150.00. The savings account ending 8890 starts at 10,000.00.
| Account | Date | Description | Amount |
|---|---|---|---|
| Checking 2231 | 2026-10-02 | Example payroll | 2200.00 |
| Checking 2231 | 2026-10-07 | Transfer to savings 8890 | -400.00 |
| Checking 2231 | 2026-10-21 | Example card payment | -1135.60 |
| Savings 8890 | 2026-10-07 | Transfer from checking 2231 | 400.00 |
| Savings 8890 | 2026-10-31 | Interest paid | 4.12 |
Turn the range into an Excel table and filter the Account column to see one account at a time. Or copy each account's rows to its own sheet, named after the account. The second approach is better if you will add months later, because each sheet then grows as a clean history of one account.
Keep the transfer lines
The two 400.00 transfer lines look like a duplicate pair, but each is real for its own account. Delete one and that account's balance check fails by exactly 400.00. When you want a combined view of both accounts, the pair simply nets to zero, which is the correct answer: money moved between your own accounts did not leave you.
How a parser decides
Software that reads statements has to find these boundaries on its own. How a bank statement parser reads a statement explains how it locates headers and tables and joins lines that wrap. FastBankConvert reads the layout of each statement rather than working from a fixed list of banks, and it flags balances that do not add up before you download. It is not open yet; you can sign up on the get started page to hear when it is.
Can one Citi balance check cover every linked account?
No. Check each account on its own: its beginning balance plus its lines must equal its ending balance. A combined check can pass while two accounts are both wrong, if an error in one is offset by an error in the other. Per-account checks catch that. Run a combined check only as an extra.
The per-account check
Using the example above, a small summary table does the job:
| Account | Beginning balance | Sum of lines | Computed ending | Printed ending |
|---|---|---|---|---|
| Checking 2231 | 3,150.00 | 664.40 | 3,814.40 | 3,814.40 |
| Savings 8890 | 10,000.00 | 404.12 | 10,404.12 | 10,404.12 |
The sum for each account comes from =SUMIFS(Amount,Account,"Checking 2231"), with the account name changed for each row. Type the beginning and printed ending balances from the statement. A row where the computed and printed figures differ points to the account with the problem.
Why the combined figure can mislead
Imagine the conversion put the 4.12 interest line under checking instead of savings. Checking would be 4.12 too high and savings 4.12 too low. Added together, they still match the combined total. Only the per-account rows show that something moved. Misplaced lines like this happen when an account header falls at the very bottom of a page and the next lines are read as part of the previous account.
Citi page order and repeated account headers
Two layout details scramble converted Citi rows more than anything else: pages that end up out of order, and account headers that repeat at the top of each continued page. Both are easy to see once you know to look, and both are easier to fix in the PDF than in the spreadsheet.
Pages out of order
Pages fall out of order when someone combines several downloads by hand, or when a scanned statement was fed into the scanner in the wrong sequence. The transactions themselves are fine, but a running balance built in page order jumps around. Put the pages back in date order before converting. The guide on reordering PDF pages before conversion shows how to do that with free tools.
Repeated headers and continued sections
A long account section that spans pages often repeats the account header with a word such as continued. That repeat is useful, because it confirms which account the next lines belong to. It becomes a problem only when a header row, or a balance carried forward from the previous page, is read as a transaction. Filter your sheet for rows with no date or no amount and delete them, checking each one against the PDF first.
Lines that wrap
A long description can wrap onto a second line with no date and no amount. Treat it as part of the line above, not as a new row. If you will be converting statements from more than one bank, turning a PNC bank statement into Excel shows how a different layout handles the same problem of combining several activity sections into one list.