Mortgage underwriters almost always ask for two to three months of bank statements before they sign off on your loan. It is one of the most routine parts of a mortgage application — and one of the slowest. A lender spots something on page 41 of a 60-page PDF: a $4,500 deposit on the 12th, a recurring payment they cannot identify. They email you a “quick clarification.” Then the waiting starts.
There is a straightforward way to shrink that cycle: convert Citibank statement PDF to Excel before you build your application package. A clean, searchable spreadsheet lets you filter, sort, and annotate every line item, so when the underwriter asks where that $4,500 came from, you answer in minutes with the exact row highlighted — not days later with a shrug.
What mortgage underwriters actually look for in your statements
Underwriters are not reading your statements for fun. They are checking three things: can you afford the payment, is your money where you say it is, and is anything in the account a hidden risk? Here is what they zero in on:
- Large or unusual deposits. Anything that is not your normal payroll — a $9,000 transfer from a friend, a $15,000 gift — triggers questions. Lenders want deposits “seasoned,” meaning the money has sat in your account for 60 to 90 days. A fresh, unexplained lump sum right before closing is a red flag.
- Recurring debts. Car payments, minimum credit card payments, student loans, and any other monthly obligations feed directly into your debt-to-income ratio. Miss one in your application and the underwriter will find it in your statements.
- Reserves. Most lenders want to see two to six months of mortgage payments left over after closing, sitting in liquid accounts like checking and savings.
- Overdrafts and NSF fees. A pattern of negative balances or non-sufficient-funds fees suggests the account cannot comfortably carry a mortgage payment.
- Income consistency. Your deposits should line up with the pay stubs and W-2s you submitted. Gaps or mismatches invite scrutiny.
Knowing this list in advance is half the battle. If you can see your own statements the way an underwriter sees them, you can fix problems — or prepare explanations — before the lender finds them. For a broader walkthrough of how lenders use these documents, see our guide to bank statements for loans and visas.
Step 1 — Download your Citibank statements as PDFs
Before converting anything, grab clean copies of your statements from Citibank. The general process:
- Sign in to citi.com (Citibank online banking) with your User ID and password.
- Open the Statements section of your account dashboard.
- Select the account you will use for the mortgage application — usually your primary checking account, plus savings if you are showing reserves.
- Choose the statement period. Download each of the last two to three months, or whatever your loan officer requested.
- Download each statement as a PDF and save it with a clear filename, like citi-checking-2026-07.pdf.
Download the complete statement — every page, including the summary pages. Lenders routinely reject partial statements. And keep these original PDFs: most lenders want the bank-issued originals alongside anything you prepare, so the Excel file is a working document, not a replacement. If you bank with Citi and want more statement tips, our Citibank page covers the essentials.
Step 2 — Convert Citibank statement PDF to Excel online
This is the part that saves you hours. Instead of retyping hundreds of transactions by hand — or squinting at PDFs on your phone — convert each statement to a spreadsheet:
- Open the Convert Statement converter in your browser — there is nothing to install.
- Upload your Citibank statement PDF. If the PDF is password-protected, enter the password when prompted; it is only used in your own browser to open the file.
- Convert the statement to Excel (.xlsx) format (CSV and OFX are available too).
- Download the spreadsheet, then repeat for each month’s statement.
The free tier converts up to 8 pages at no cost, which covers a typical monthly statement. No software to install, no account needed to try it — your PDF is processed in your browser session. Because the result is a real spreadsheet, every date, description, and amount becomes sortable, filterable, and searchable. That $4,500 deposit the underwriter asked about? Type the amount into Excel’s search box and you have it in two seconds.
Step 3 — Build a mortgage-ready workbook your loan officer will love
A raw export is useful; a prepared workbook is persuasive. Spend twenty minutes on these moves before you send anything:
- Highlight your income. Use a color fill on every payroll deposit so your recurring income jumps off the page. Then compare the totals against your pay stubs — the numbers should match exactly.
- Annotate one-off transfers. Add a “Notes” column and explain anything unusual in plain language: “Transfer from my savings for the down payment,” “Reimbursement from my employer.” Underwriters love borrowers who explain first.
- Flag large deposits early. If any deposit is over roughly half your monthly income and is not payroll, assume the lender will ask. Gather the paper trail now — gift letters, transfer receipts — and note the source in your spreadsheet.
- Check the 60–90 day seasoning. Sort by date and confirm that your down payment and closing-cost funds have been sitting in the account for at least two to three months. Money that arrived last week needs an explanation.
- Redact before you share. Before sending your workbook to anyone other than your lender — a mortgage broker, an assistant, a co-borrower — mask full account numbers. Keep the unredacted version for the lender, who needs complete statements. Our data security best practices walk through safe handling step by step.
- Add a one-page summary sheet. Total deposits, total withdrawals, recurring monthly debts, and average balance per month. Loan officers deal with hundreds of files; a summary makes yours the easy one.
The goal is simple: when the underwriter’s follow-up questions arrive, you answer from your spreadsheet in minutes instead of digging through PDFs for days. For more on assembling the full paperwork package, read our bank statement guide for home loans.
Frequently asked questions
Do mortgage lenders accept Excel files instead of original PDF statements?
Usually not as a replacement. Most lenders require the original bank-issued PDFs — complete, with every page — and treat your Excel workbook as a supporting working document that speeds up their review. Always confirm with your loan officer before you submit, and never let the numbers in your spreadsheet differ from the originals.
How many months of statements will my lender ask for?
Two to three months is standard for most conventional and FHA loans — that is exactly why the 60-to-90-day “seasoning” window matters so much. If the underwriter spots anything unusual, they may ask for additional months, so having your statements converted and organized in advance keeps you ahead of the request.
My Citibank statements are password-protected. Can I still convert them?
Yes. When you upload the PDF, you will be prompted for the password, which is used only in your own browser to unlock the file for conversion. If you have forgotten the password, reset it in Citibank online banking before downloading — the statement PDF password is set by Citi, not by the converter.
Is it safe to convert bank statements online?
Reasonable caution is smart with any financial document. Use a converter that works in your browser with no software to install, redact full account numbers before sharing files with anyone besides your lender, and delete local copies from shared computers. Our data security best practices article covers the full checklist.
A mortgage application moves at the speed of its paperwork. Convert your Citibank statements to Excel today, build a workbook that answers questions before they are asked, and give your loan officer the easiest file in the pile — or see pricing if you have more than 8 pages to convert.