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.
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.
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.
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.
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 statement | In 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 table | Not rows. Beginning Balance and Ending Balance are the two numbers the balance check uses. |
| An amount under Debits, printed without a minus sign | Negative: ACH WITHDRAWAL and ACH PAYMENT, USAA DEBIT (a Zelle payment sent), ATM WITHDRAWAL, WITHHOLDING TAX. |
| An amount under Credits | Positive: 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 location | Joined 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 column | Kept in the Balance column, as printed. |
| The Beginning Balance and Ending Balance rows at the top and bottom of the table | Not 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 next | Skipped, never joined onto the last row of the page. |
| Dates printed as "03/02" with no year | Full 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 table | Skipped. |
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.
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
| Column | Contents |
|---|---|
| Date | Year first (2026-09-01), so Excel reads it as a date whatever your regional settings. |
| Description | USAA's transaction type and the lines under it, in one cell. The masked account numbers stay as USAA prints them. |
| Amount | Negative 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. |
| Balance | USAA'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).
| You need | Where to get it |
|---|---|
| A statement from the last 18 months | My Documents shows it by default. Open it and download it from the Menu icon. |
| An older statement | In 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 expired | USAA 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 statement | USAA 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 checks | Your 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.
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 use | Download |
|---|---|
| Quicken Classic for Windows | The QIF (File → File Import → QIF File). See bank statement PDF to QIF. |
| QuickBooks Online or a Desktop version with Web Connect | The .QBO, or the 3-column QuickBooks Online CSV. See USAA to QuickBooks. |
| QuickBooks Desktop without Web Connect | The .IIF (File → Utilities → Import → IIF Files). |
| Xero | The 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.
| Problem | What to do |
|---|---|
| No transactions found | The 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 balanced | You 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 amount | That'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 statement | Try 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 sheet | Convert 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.
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.
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).
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.
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.
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.
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.
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.
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.
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.
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.
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.
Step-by-step guide →
Step-by-step guide →
Step-by-step guide →
Step-by-step guide →
Step-by-step guide →
Step-by-step guide →
Step-by-step guide →
Step-by-step guide →
Step-by-step guide →