How to Convert a Citi Bank Statement to Excel

TL;DR: For recent Citi activity, use the download in online banking. For older months, official records, or statements someone emailed you, convert the PDF with a statement-aware converter and verify that the opening balance plus every transaction equals the closing balance. Citi card and bank statements behave differently, so set your signs before combining them.

Citi is one of those banks where people often have both a bank account and one or more credit cards, sometimes on the same login and sometimes on a combined relationship statement. That's handy for day-to-day banking. It makes conversion a little more involved, because you have to be clear about which account each row belongs to and which way the signs point.

We'll walk through our approach for both checking and credit cards, with the checks and cleanup steps we use on every Citi job.

What you can get from Citi

Like other large US banks, Citi offers:

• Monthly PDF statements for each account or relationship. Bank statements typically show a summary of balances and then itemized activity. Card statements show the previous balance, payments, purchases, fees, interest and new balance.
• Downloadable activity from online banking for recent transactions, in spreadsheet formats and formats designed for personal finance or accounting software.

The download is great for current activity. The statement is what you need for older periods and for any third party who wants proof.

Finding the statements

Since Citi's site is updated from time to time, here's the general route:

1. Sign in to Citi online or the mobile app.
2. Select the account.
3. Look for Statements or Statements & Documents.
4. Choose the period and download the PDF.

Citi keeps several years of statements online for most accounts. If you need older ones, customer service can help.

If your checking and savings come on one relationship statement, you'll see separate sections for each account inside one PDF. That matters for verification, as we'll see.

Downloading recent activity

When the period you need is recent:

1. Open the account's activity.
2. Look for a download or export link.
3. Pick the date range and format (CSV works everywhere).
4. Save and open in Excel.

Expect columns such as status, date, description, debit and credit, though the exact layout varies by account type. Card exports and bank exports don't always match, so check the headers each time.

Two notes. First, filter out pending items if you're matching to a statement; they may change or disappear. Second, the export won't give you an opening balance. If you need to reconcile, take it from the statement.

Converting Citi PDF statements

Our usual workflow with SheetStatement:

1. Upload the PDF or several at once.
2. The converter extracts transactions into rows: date, description, debit, credit and balance where shown.
3. For relationship statements, it tags each transaction with its account.
4. It checks each account's math against the opening and closing balances.
5. Review anything flagged.
6. Export Excel, CSV, or an accounting format.

The Citi bank page lists the layouts we've tested.

Verify before you trust it

The point of conversion is to save time, and the point of verification is to make sure you didn't save time by losing data.

For a bank account:

opening balance + deposits − withdrawals = closing balance

For a credit card:

previous balance + purchases + fees + interest − payments − credits = new balance

In Excel, with a signed Amount column (positive in, negative out for bank accounts), put the opening balance in a cell and add =opening+SUM(Amount). Compare with the closing balance. For a card, use a signed amount where purchases are positive.

If the statement prints a running balance on each line, go further and check every row. In a helper column, compute the running balance yourself, and in another column compare it with the statement's balance using =ROUND(calc-stmt,2)=0. The first FALSE is where the problem starts.

Our free balance checker runs these checks without formulas.

Relationship statements

If the PDF covers several accounts, check each one separately. A combined check across accounts can't work, since each account has its own balances. Filter by account, run the formula, repeat.

Cleanup steps that matter

Dates

Citi statements usually print dates in a short format. Make sure the converted dates are real Excel dates with the correct year, especially for statements that cross December and January. Sort by date and look at both ends.

Signed amounts

If you have Debit and Credit columns, add =[@Credit]-[@Debit] as a signed Amount. Formulas, pivots and imports all get easier.

Descriptions

Card descriptions often include the merchant, a city and a state, and sometimes a reference number. Keep the original, and add a cleaned Payee column. For recurring merchants, a mapping table is worth building: one column with the raw text pattern, one with the clean name.

Categories

Add a Category column and fill it with a lookup on keywords. See our guide to Excel formulas for categorizing transactions for formulas that scale beyond a handful of IFs.

Combining checking and cards

If you want one view of your money, combine accounts carefully:

1. Add an Account column to each table.
2. Choose one sign convention for the combined view. We use "money out negative, money in positive" from your perspective. For cards, that means flipping the card's purchase sign. Keep the original signed value in its own column so each account still verifies.
3. Tag card payments from checking as transfers. They appear on both statements.
4. Build a pivot by month and category, excluding transfers.

This gives you real spending and income without double counting. We see people skip step 3 more than any other, and then wonder why their spending looks twice as high in the month they paid off a card.

A worked example

Here's an invented Citi card statement:

• Previous balance: 2,105.77
• Payments: −2,105.77
• Credits: −45.00
• Purchases: 1,388.20
• Fees: 0.00
• Interest: 0.00
• New balance: 1,343.20

After conversion, we sum purchases: 1,388.20. Payments: −2,105.77. Credits: none found. Our calculated new balance is 1,388.20, which is 45.00 more than the statement.

A 45.00 difference with "Credits: −45.00" on the summary is obvious in hindsight: the refund is missing. On the PDF, the credit is listed in the payments and credits section, under the payment, with a merchant name. The converter had grouped it with the payment line. We split it out, and the statement balances.

The general lesson: compare your sums against each summary line, not just the final balance. A difference that equals one of the summary lines tells you exactly which section to look at.

Missing transaction or missing statement?

When you work through many months, two different problems look similar at first: a transaction missing from one statement, and an entire statement missing from the set. They need different fixes, so it's worth telling them apart quickly.

A missing transaction shows up inside one statement: that statement doesn't balance on its own. The opening balance plus your rows doesn't reach the closing balance. The fix is inside that PDF.

A missing statement shows up between statements: each statement balances perfectly on its own, but one statement's opening balance doesn't equal the previous statement's closing balance. No amount of row-level checking will find it, because nothing is wrong with the rows you have. The fix is to get the missing PDF.

We add a continuity check to every multi-month workbook. In a small table with one row per statement, put the opening and closing balance from each PDF, then a column with =B3=C2 (this month's opening equals last month's closing). Any FALSE means a gap. It's one of the cheapest checks in bookkeeping and it catches a surprising number of incomplete client folders.

Turning a year of Citi data into a summary

Once your statements are converted, verified and categorized, a year-end summary takes minutes:

1. Add a Month column with =TEXT([@Date],"yyyy-mm").
2. Insert a pivot table from the combined table.
3. Put Category in rows, Month in columns, and Sum of Amount in values.
4. Filter out the Transfer category.
5. Add a grand total column.

For a household, this shows where money went each month. For a sole proprietor, it's a starting point for the conversation with your tax preparer, alongside the statements themselves. We'd stress "starting point": categories in your spreadsheet are your own labels, and whether something is deductible is a question for a qualified professional, not the spreadsheet. Our guide to bank statements for tax preparation explains what preparers usually find helpful.

If you want a visual, a stacked column chart by month from the pivot is enough. Fancy dashboards look impressive and are rarely maintained; a single pivot and chart that you refresh every month will serve you better.

Keeping the process repeatable

The first Citi conversion takes the longest, because you're deciding on columns, categories and checks. After that, make it boring on purpose. Keep a template workbook with the check formulas already in place. Keep a categories sheet that grows over time. Name files consistently. The second month should take a fraction of the time of the first, and by month six it should be routine.

Getting Citi data into accounting software

QuickBooks Online and Desktop

Use a QBO (Web Connect) file for the cleanest import. It carries the account type and a unique ID for each transaction, so QuickBooks can detect duplicates if you import overlapping periods. Our QuickBooks converter exports QBO and IIF. If you're unsure which to use, read QBO vs IIF vs CSV.

For credit cards, import into a credit card account in QuickBooks, not a bank account. After import, check that a purchase increased the card balance and a payment reduced it.

Xero

Import a CSV with a single signed amount column into the matching bank or card account. Our Xero converter produces a file that maps directly. If Xero complains about the file, check the date format first; it's the usual culprit.

Other tools

Most other accounting and budgeting tools accept CSV. Keep the columns simple: Date, Description, Amount. Our CSV formats explainer covers the variants.

Troubleshooting Citi conversions

Running balance mismatches start mid-page. A row above the first mismatch is wrong or missing. Compare the PDF line by line around that spot.

Interest or fees missing from a card. They may be in a separate section near the end. Check that section was extracted.

Foreign transaction lines duplicated. If the statement shows the foreign amount on a separate line, remove it and keep the billed amount.

Relationship statement totals don't add up. You're likely checking the accounts together. Split by account.

Scanned statements with misread digits. If the scan is low quality, a 6 can become an 8. The balance check will flag the row. Compare with the image and correct. For better scans, see our notes on OCR for scanned statements.

Password protected PDFs. If someone forwarded you a protected file, you'll need the password before any converter can read it.

When you're converting for someone else

Bookkeepers, tax preparers and family members often work with statements they didn't download. A few habits help:

• Make a list of periods received and look for gaps before converting.
• Confirm the last four digits of the account on each statement match.
• Ask whether there are other accounts (cards, savings) that money moves between. Transfers to accounts you don't have will look like expenses.
• Keep a short log of what you changed during review.

Security and retention

Statements are sensitive. Use a converter that encrypts uploads, deletes them automatically, and doesn't use your data to train models. Our security page explains our approach. Once you've exported, store the files somewhere with access controls, and delete working copies you no longer need.

Our take

Citi is straightforward once you separate accounts and get the signs right. Download for recent activity, convert PDFs for history, check each summary line, and keep the PDFs alongside the spreadsheet. If you'd like to see how the conversion looks on your own statement, the free plan (3 pages a month) is a quick way to try.

Troubleshooting Citi conversions

Card statements and bank statements look completely different. Citi credit card and Citibank deposit account statements have different layouts and sign conventions. Convert them separately and keep them in separate tables, with an Account column if you later combine them.

Interest and fees are in their own section. On card statements, interest charged and fees may appear separately from purchases. Include them in your transaction list, or the totals won't agree with the new balance.

Payments show as negative and purchases positive. That's typical for cards. Pick a convention for your spreadsheet and apply it consistently.

Authorized user charges. If the account has additional cardholders, their charges may be grouped under each card. Add a Cardholder column so you can total by person.

Foreign transactions. Purchases abroad may show both the foreign amount and the USD amount, with a separate foreign transaction fee line where one applies. Use the USD amount, and keep the fee line.

A second worked example: annual spending by category

A reader wanted to know their total annual spending on dining and travel across a Citi card. They converted twelve statements, removed payments and credits from the spending view, and mapped merchant names to categories with a lookup table. A PivotTable by category and month showed dining highest in December and travel in July. It took about 30 minutes, including building the lookup table, which they now reuse every month. Our Excel categorizing guide shows how to build that table.

Mini checklist

1. Card and bank accounts kept separate.
2. Interest, fees and credits included.
3. One sign convention per table.
4. Cardholders labelled where relevant.
5. Each statement's totals checked against its summary.

FAQ

Can I download Citi statements in Excel format?

Statements are PDFs, but Citi online banking lets you download recent activity in spreadsheet-friendly formats. For older periods or an exact match to the statement, convert the PDF.

How do I convert a Citi credit card statement to Excel?

Upload the PDF to a converter that understands card statements, confirm that payments and purchases have opposite signs, and verify that the previous balance plus charges, fees and interest, minus payments and credits, equals the new balance.

What if my Citi statement includes several accounts?

Treat each account section as its own statement. Tag each transaction with its account and check each account's opening and closing balance separately.

Why is my converted Citi statement off by a round amount?

A difference that matches one of the summary lines, such as a credit or a fee, usually means that line was missed or merged into another row. Compare each section total with your sums.

Can I import Citi statements into QuickBooks?

Yes. A QBO file is usually the cleanest option for both QuickBooks Online and Desktop. Import cards into credit card accounts and check a few transactions afterward.

Is the downloaded activity enough for a loan application?

Usually not. Lenders generally ask for official statements. Use downloads for your own analysis and provide PDF statements to third parties.