Home › Blog › Bank Statement Guides › Converting Citibank statement PDFs without losing a transaction
How to fetch Citibank statements, spot layout quirks, convert the PDFs and reconcile each period against its opening and closing balances. Practical steps.
By StatementVerified Editorial · November 5, 2026 · 5 min read · Filed under Bank Statement Guides
Most conversion headaches trace back to the download, not the converter. Grab the wrong Citibank period, pick the transaction export instead of the official statement, or miss the last page, and the spreadsheet built from it will never balance. Citibank, a national bank based in New York, New York, serves urban clients, travelers and people who bank across borders, so its statement archive is where this guide begins, before moving to layout checks and the reconciliation step that proves the numbers survived the move.
The workflow in this guide is built for that reality. It assumes statements arrive in batches, sometimes for card accounts alongside deposit accounts, sometimes for a single account that has fallen behind for a quarter. Each section stays practical: where statements sit, how periods work, what the pages tend to show, how conversion and checking fit together, and which small errors create the biggest clean-up jobs. Nothing here depends on a single software brand, either; the same habits hold whether the final file goes to a spreadsheet, to QuickBooks, to Xero or into a lender package.
Interest and fee rows on cards sit in their own sections on many layouts, sometimes near the end after the transaction list, and they are small enough to overlook and important enough to break a reconciliation. The same goes for payments, which may be listed in a payments section separate from purchases. A card statement is often three or four short lists wearing one coat; convert it as a whole and check each printed subtotal against your rows.
Supplementary and employee cards complicate the picture in a useful way. Spending may be itemised per card holder inside one statement, with a combined balance owed at account level. That per-person detail is gold for businesses dividing costs and for households untangling whose spending is whose, but only if it survives conversion. Before importing, check a supplementary card's rows against its statement section and confirm the detail came through rather than collapsing into account-level totals.
s
,
Before converting, spend one minute reading the statement the way its designer intended. Find the summary first: most large banks open with an account summary showing beginning and ending balances, total deposits and total withdrawals. Then find the transaction list and check whether it runs as one long chronological list or splits into sections such as deposits, card withdrawals, electronic payments and fees. Knowing the structure tells you what the converted rows should look like when they land.
Pay attention to how the statement marks its own sections. Headings inside the transaction list, subtotals at the end of a section and notes about fees each carry information. A converted file flattens all of that into rows, which is the point, but the person checking the import should know which subtotals the original printed, since a section subtotal that differs from the sum of its converted rows points straight at a missed or doubled entry.
After exporting, do a human pass. Filter the spreadsheet for the largest transactions and compare a sample against the PDF. Check that dates sit inside the statement period, that money out carries the sign your accounting system expects and that section oddities, like checks listed out of date order, have not scrambled the sequence. Five minutes of sampling catches category of problem that totals alone cannot, such as two rows swapped or a description attached to the wrong amount.
Think of conversion as translation, not magic. The PDF holds a printed table; the converter rebuilds it as structured rows, reading dates, descriptions and amounts, then proving the rebuild by arithmetic: rows plus opening balance should land on the closing balance. That proof is what separates a statement converter aimed at bookkeepers from a generic file tool, and it is why the check result deserves your attention before the export button gets any.
A mismatch that appears in the same place every month is rarely random. Recurring gaps at a section boundary suggest a part of the layout your routine keeps missing, while gaps that start the month a client changed account types point to a stub statement sitting unconverted in the folder. Keep notes on each failure and its cause; patterns in those notes turn future troubleshooting from detective work into a checklist, and they make excellent training material for anyone who joins the bookkeeping team.
Another quiet culprit is the two-account PDF. Clients occasionally download a combined view or forward a file that contains more than one account's pages. The balance check fails in a way that looks random until someone reads the account labels on each page. Split the file by account, convert each statement separately and the mystery usually resolves. Relatedly, stub statements from an account change can look like errors; treat them as real periods and the chain of balances settles down.
Choose by destination. Excel suits hands-on review and manual categorising, CSV is the universal option most tools accept, and QuickBooks or Xero formats follow those systems' import conventions for dates, signs and fields. Decide once per client and stay consistent across months, because switching formats mid-year invites duplicate imports and sign confusion.
Sign in, open the account, and go to its statements or documents section, then choose the period and download the PDF. The exact labels vary between the app and desktop site, so look for wording such as Statements, Documents, eStatements or Paperless. Always take the official period PDF rather than a screenshot or a printed transaction list, because the PDF carries the opening and closing balances used for reconciliation.
Online archives commonly cover a few years, varying by account type and enrolment in paperless delivery. Start in the archive, then check any paper files the client holds, and allow time for formal requests for older periods. For catch-up projects, list the periods you hold against the periods you need before converting, so gaps surface while there is still time to fill them.
Bank Statement Guides · November 3, 2026
A bookkeeper guide to downloading Bank of America statements, reading the layout and converting PDFs with a balance check before any import. Practical steps.
Bank Statement Guides · November 3, 2026
A bookkeeper guide to downloading Santander Bank statements, reading the layout and converting PDFs with a balance check before any import. Practical steps.
Bank Statement Guides · November 5, 2026
How to fetch TD Bank statements, spot layout quirks, convert the PDFs and reconcile each period against its opening and closing balances. Practical steps.
Convert a statement now and watch the reconciliation check verify it against the statement itself.
Your first conversion is free — no card, no sign-up — and every result is reconciled against the statement itself before you download it.