Citibank Statement to Excel Converter

Converting Citibank Statements to Excel

A Citibank statement often reads more like a summary of your whole banking relationship than the history of a single account. Customers in relationship tiers such as Citigold can receive one PDF that covers a checking account, one or more savings accounts and linked balances, each with its own activity table. That is convenient to read but slow to copy into a spreadsheet, because you have to find where each account starts and keep debits and credits apart. Finlyzers reads the transaction tables and gives you rows you can sort, filter and total.

How a Citibank Statement Is Typically Laid Out

• Relationship or account summary: the first page usually lists each account included in the statement with its balance at the start and end of the period.
• Checking activity: a table with the date, a description, amounts for money out and money in, and a balance.
• Savings activity: savings accounts usually follow with their own, shorter table of transfers, deposits and interest.
• Messages and disclosures: fee notices, interest rate information and legal text, none of which are transactions.

Citi has changed its statement design over the years, and the layout can differ between account packages, so an older statement may not look exactly like a current one.

Statements That Cover Several Accounts

When one PDF covers more than one account, take a moment to confirm which account each block of transactions belongs to before you import anything. A transfer from Citi checking to Citi savings appears twice: once as a debit on checking and once as a credit on savings. If both accounts end up in the same ledger in QuickBooks or Xero, that movement should be recorded as a transfer, not as income on one side and an expense on the other.

Reconciling each account against its own opening and closing balance from the summary page is the simplest way to catch mistakes.

Citi Activity Downloads Versus the PDF Statement

Citi Online usually lets you download recent account activity as a spreadsheet-style file. That works well for the last few months on an account you can still sign in to. You will still need to convert the PDF when:

• the period you need is older than the activity download covers;
• the account has been closed and you can no longer sign in to it;
• a client, tenant or loan applicant sent you the statement as a PDF rather than giving you access;
• a lender, landlord or auditor wants figures that tie back to the official monthly statement.

Reading Citi Transaction Descriptions

Descriptions on US bank statements are short and often truncated. On a Citi statement you will commonly see:

• ACH credits and debits for payroll, tax refunds, insurance premiums and bill payments, usually with the originating company's name.
• Debit card purchases with the merchant name and, often, the city and state.
• Online transfers between your Citi accounts, typically referencing the last digits of the other account.
• Zelle payments sent and received, with the other person's name.
• Interest credited to savings and any monthly service fee.

Keeping the description intact lets you filter on these patterns later, for example to pull out every payroll deposit or every Zelle payment to a contractor.

What You Get in the Spreadsheet

• One row per transaction with Date, Description, Reference, Debit, Credit and Balance columns.
• Wrapped descriptions joined into a single cell when a merchant or transfer note runs onto a second line.
• Running balance checked against the printed balances, so a missed or misread row shows up.
• Multi-page statements processed in one upload.

Common Uses for Converted Citi Statements

Sole proprietors sort business expenses for Schedule C, landlords separate rent deposits for Schedule E, and bookkeepers backfill QuickBooks or Xero when the bank feed does not reach far enough back. The same upload can be downloaded as QBO for QuickBooks, CSV or OFX. If you also bank elsewhere, the Chase and Capital One guides cover those statements.

Converting a Citi credit card statement, such as Double Cash or Custom Cash? Use the credit card converter. For paper statements from a branch or an old file box, try the scanned statement converter.