USAA · Excel

Convert a USAA statement PDF to Excel

To convert a USAA statement PDF to Excel, download the PDF from My Documents, upload it, check that it balances, then download a CSV that opens in Excel: one row per transaction, debits negative and credits positive, with the details USAA prints under each row and its running balance. Free preview, no sign-up.

Files deleted after 1 hourNever stored or used for trainingBalance check on every file
Processed in memory, never stored
No statement handy? See the result on a fictional one first:

1. Download the PDF from USAA

  1. Log on at usaa.com, or open the USAA Mobile App.
  2. Go to My Documents (on usaa.com it's under your profile). To see statements older than 18 months, select Filter and widen the Delivery date range.
  3. Open the statement, then use the Menu icon to download the PDF.

2. Upload and verify

Utilly reads every transaction, then checks that opening balance + transactions = closing balance. You'll see Balanced ✓ or exactly how far off it is, before you pay anything.

3. Import into Excel

  1. Download the CSV from your results page. It's formatted for Excel.
  2. Open it in Excel. Dates and amounts come through as real dates and numbers, so you can sort, filter and pivot right away.
  3. Save as .xlsx if you want to keep formulas or formatting.

About USAA statements

USAA checking statements open with an Activity Summary (Beginning Balance, Deposits/Credits, Withdrawals/Debits, Ending Balance), then list every transaction under Transactions with Debits, Credits and Balance columns and no sign on the amounts. Utilly signs each row by its column, joins the lines printed under each row (the ACH company, the Zelle name and reference, the ATM location), skips the "continued on next page" footers and the Beginning and Ending Balance rows, keeps USAA's running balance and checks the total against the Beginning and Ending Balance.

Works with USAA checking and savings statements. Layout tested: Debits and Credits columns, details on the lines under each row.

Why Excel?

Excel is the fastest way to review a statement, tag categories, or hand a clean transaction list to your accountant.

Short answer: download the statement PDF from My Documents, upload it above, and check that it shows Balanced ✓. You get a CSV that opens in Excel with one row per transaction, debits negative and credits positive, the ACH, Zelle and ATM details USAA prints under each row joined into the description, and USAA's running balance beside each row.

How to convert a USAA statement PDF to Excel

  1. Download the PDF: log on at usaa.com or in the USAA Mobile App and go to My Documents (on usaa.com it's under your profile). Open the statement, then use the Menu icon to download it. For statements older than 18 months, select Filter and widen the Delivery date range. Use the downloaded PDF if you can: it reads exactly, while a scan of a printout is read with OCR and a phone photo needs saving as a PDF first.
  2. Upload it above. Utilly reads the Transactions table, signs each amount by its Debits or Credits column, and checks Beginning Balance + credits − debits = Ending Balance. The preview shows Balanced ✓, or exactly how far off it is, before you pay anything.
  3. Download the CSV and open it in Excel. Dates and amounts come in as real dates and numbers.
  4. Save as .xlsx (File → Save As → Excel Workbook) if you want to keep formulas or formatting.

What we read on a USAA statement

A USAA checking statement names the product at the top right ("USAA CLASSIC CHECKING", the account number and the Statement Period), opens with an Activity Summary and a fees table, then lists every transaction under Transactions with Date, Description, Debits, Credits and Balance.

On the statementIn the Excel file
Activity Summary: Beginning Balance, "11 Deposits/Credits", "16 Withdrawals/Debits", Service Charges and ATM Service Fee, Ending Balance; then the Total Overdraft (OD) Fees and NSF Fees tableNot rows. Beginning Balance and Ending Balance are the two numbers the balance check uses.
An amount under Debits, printed without a minus signNegative: ACH WITHDRAWAL and ACH PAYMENT, USAA DEBIT (a Zelle payment sent), ATM WITHDRAWAL, WITHHOLDING TAX.
An amount under CreditsPositive: ACH DEP, USAA CREDIT (a Zelle payment received), ATM REBATE, INTEREST PAID.
The lines under each row: the company ("VENMO CASHOUT"), a masked account number ("***********4276"), the Zelle name and reference, the ATM terminal and locationJoined onto the row's description: "ACH DEP 090126 SAMPLE PAYROLL DIR DEP ***********1180".
An ATM REBATE row with the withdrawal it refunds under it ("$82.50 ATM W/D DEMO MART 12 MAIN on 09/08")Kept in the rebate's description. Only the rebate's own amount (under Credits) is counted; the withdrawal is its own row.
The Balance columnKept in the Balance column, as printed.
The Beginning Balance and Ending Balance rows at the top and bottom of the tableNot transactions. They're checked against the Activity Summary.
"continued on next page>>>", the form number and "Page 1 of 4" at the bottom of a page; the repeated header and "Transactions(continued)" at the top of the nextSkipped, never joined onto the last row of the page.
Dates printed as "03/02" with no yearFull dates (2023-03-02), the year taken from the Statement Period. On a statement that runs from December into January, December rows get the earlier year.
Interest Paid Information, IMPORTANT INFORMATION and TERMS AND CONDITIONS after the tableSkipped.

What this is based on: test statements built in USAA's layout above, with made-up names and transactions (a checking statement with ACH deposits and withdrawals, Zelle payments both ways, ATM withdrawals with an ATM rebate, a credit card payment and interest, running onto a second page; plus a statement from December into January with withholding tax), and one public sample USAA Classic Checking statement posted as an example file: all 27 of its rows were read and it balanced to the cent. That sample was made in a design program, so it may not match a statement USAA issues in every detail, and we don't link to it because it shows a person's name and address. We haven't run a real customer's USAA statement through it yet, and savings, Performance First and business checking statements and USAA credit card statements haven't been tested. The balance check tells you straight away whether yours read correctly.

What the Excel file looks like

Date,Description,Amount,Balance
2026-09-01,ACH DEP 090126 SAMPLE PAYROLL DIR DEP ***********1180,1980.40,4290.95
2026-09-02,USAA DEBIT Zelle: SAMPLE PERSON 3700000001,-60.00,4230.95
2026-09-08,ATM WITHDRAWAL 090826 6011090826 DEMO MART 12 MAIN ST AUSTIN TX,-82.50,3955.45
2026-09-10,ACH PAYMENT 091026 USAA CREDIT CARD PAYMENT ***********9001,-450.00,3530.45
2026-09-14,ATM REBATE $82.50 ATM W/D DEMO MART 12 MAIN on 09/08,2.50,3232.95
2026-09-30,INTEREST PAID,0.04,3790.57
ColumnContents
DateYear first (2026-09-01), so Excel reads it as a date whatever your regional settings.
DescriptionUSAA's transaction type and the lines under it, in one cell. The masked account numbers stay as USAA prints them.
AmountNegative for ACH withdrawals and payments, Zelle payments sent, ATM withdrawals and withholding tax; positive for ACH deposits, Zelle payments received, ATM rebates and interest. =SUM() over the column equals Ending Balance minus Beginning Balance.
BalanceUSAA's running balance after the row, as printed.

Rows keep the statement's order, which for USAA is date order. Want money in and money out in two columns, like the statement? Use =MAX(C2,0) and =MAX(-C2,0).

How far back USAA statements go

You needWhere to get it
A statement from the last 18 monthsMy Documents shows it by default. Open it and download it from the Menu icon.
An older statementIn My Documents, select Filter and extend the Delivery date range. USAA says how long each document stays available varies, so save the ones you need.
A statement that has expiredUSAA says it may be able to research and retrieve an expired document, though there may be a fee: call 877-632-3002.
A month with no statementUSAA sends a statement monthly when there's activity on the account; when the only activity is interest, it may send one quarterly.
Copies of cleared checksYour account's transaction history has check images for the past 18 months (Advanced Search, Category "Checks").

Sources: USAA: Managing Online Documents FAQs (Filter and Delivery date range for documents beyond 18 months; download from the Menu icon; availability varies by document; expired documents, possible fee, 877-632-3002), USAA: Tax FAQ (My Documents under your profile; check images for the past 18 months), USAA Federal Savings Bank Depository Agreement and Disclosures (monthly statements when there's activity, quarterly when the only activity is interest). Checked Oct 29, 2026.

QuickBooks and Quicken files for USAA

If USAA's own transaction download covers the dates you need, use it. For months you only have as statements, for statements a client sent you as PDFs, or when you want every row tied to the statement's Ending Balance, start from the PDF. The same Utilly conversion that gives you Excel also includes:

You useDownload
Quicken Classic for WindowsThe QIF (File → File Import → QIF File). See bank statement PDF to QIF.
QuickBooks Online or a Desktop version with Web ConnectThe .QBO, or the 3-column QuickBooks Online CSV. See USAA to QuickBooks.
QuickBooks Desktop without Web ConnectThe .IIF (File → Utilities → Import → IIF Files).
XeroThe Xero CSV or the OFX. See USAA to Xero.

One credit covers every format of that statement. If a download or a bank feed already brought in some of the same dates, start the PDF months where that stopped so nothing comes in twice.

Common problems

ProblemWhat to do
No transactions foundThe PDF is probably a scan or a photo. Download the statement again from My Documents.
"This PDF is password protected"Save a copy without the password, or download the statement again, and upload that.
Not balancedYou see the difference before paying. A difference equal to one amount on the statement usually means that row couldn't be read; check it against the PDF. If a paid conversion is wrong and we can't fix it, we refund it.
The ATM REBATE description mentions a bigger amountThat's the withdrawal the rebate refunds, printed under the rebate. Only the rebate's own amount is in the Amount column.
A savings, business checking or USAA credit card statementTry it: the balance check tells you straight away whether it read correctly. Those layouts haven't been tested yet.
You need several months in one sheetConvert each statement on its own so each gets its own balance check, then paste the rows into one sheet. Every file has the same columns.

Catching up on months of statements? See catch-up bookkeeping from bank statements, and check any statement's totals with the free bank statement balance checker. Other banks: bank statement PDF to Excel, Chase statement to Excel, Bank of America statement to Excel, Wells Fargo statement to Excel, Capital One statement to Excel, U.S. Bank statement to Excel, Citibank statement to Excel, PNC statement to Excel, Truist statement to Excel, Navy Federal statement to Excel, Citizens statement to Excel, Regions statement to Excel, Huntington statement to Excel, or Ally statement to Excel.

Pricing

Preview any statement free, and your first 3 full statements are free with your email. A $9 pack unlocks 5 full statements in every format, with no expiry and no subscription. Bookkeepers with many clients can go unlimited for $19/month. See pricing.

FAQ

Questions

Can I convert a USAA statement PDF to Excel for free?

You can preview every statement free: we show the balance check and the first 5 transactions with no sign-up. Unlocking the full file costs one credit ($9 for 5 statements).

Why not just copy and paste from the PDF?

Copying from a PDF usually scrambles columns, merges descriptions and drops minus signs. Utilly keeps each transaction on one row with a signed amount, and the balance check tells you nothing was missed.

Is my statement stored?

No. The PDF is read in memory and never written to disk, and extracted results are deleted after 1 hour. We never use your data for AI training.

Do scanned statements work?

Yes, as a PDF of up to 10 pages. A scan has no text layer, so Utilly reads it with OCR (text recognition running on our server; the file isn't sent anywhere else) and then runs the same balance check, so a misread digit shows up as a difference instead of slipping into your books. A PDF downloaded from online banking is still the most reliable. Phone photos (JPG or PNG) need saving as a PDF first.

What if it doesn't balance?

You'll see exactly how far off it is before paying. If a paid conversion is wrong and we can't fix it, email support@version1.io for a refund.

How far back can I get USAA statements?

My Documents opens on the last 18 months. USAA's help says to select Filter and extend the Delivery date range to see older documents. How long each document stays available varies, and for an expired one USAA says it may be able to research and retrieve it, sometimes for a fee (877-632-3002). Download the statements you need while they're there.

USAA prints amounts without a minus sign. How do debits come out?

Negative. A USAA statement puts each amount in a Debits or a Credits column, unsigned. Utilly signs each row by its column: ACH withdrawals and payments, USAA DEBIT (Zelle sent), ATM withdrawals and withholding tax negative; ACH deposits, USAA CREDIT (Zelle received), ATM rebates and interest positive. The total is then checked against the Beginning and Ending Balance.

What happens to the lines under each transaction?

They're joined onto that row's description, so "ACH DEP 090126" with "SAMPLE PAYROLL DIR DEP" and a masked account number under it becomes one cell, and a Zelle row keeps the name and reference. An ATM REBATE row keeps the withdrawal it refunds ("$82.50 ATM W/D ... on 09/08") in its description; that amount isn't counted again. The "continued on next page" note and the page footer are left out.

Why didn't I get a statement this month?

USAA's deposit agreement says it sends a statement monthly when there's activity on the account, and when the only activity is interest it may send one quarterly. So a quiet savings account can have three months on one statement; convert it the same way and each row keeps its own date.

Can I download USAA transactions instead of converting the PDF?

If USAA's own transaction download covers the dates you need, use it. Start from the PDF for months you only have as statements, for statements a client sent you, or when every row should tie to the statement's Ending Balance. The same conversion includes a .QBO and an .IIF for QuickBooks, a QIF for Quicken Classic for Windows, and a Xero CSV.

Related guides

More bookkeeping tools