U.S. Bank statement to Excel
Drop a U.S. Bank PDF below and get a spreadsheet with the columns split the way the statement prints them. The file stays in your browser.
Drop your U.S. Bank PDF statement here
or click to choose a file · nothing is uploaded
Import straight into accounting software
A CSV leaves you at the door of QuickBooks or Quicken; these formats walk in, with each transaction carrying an id so a re-import can't duplicate it. The plain .ofx is the same file without the Intuit tag, for GnuCash, Moneydance and anything else that reads a bank feed.
QuickBooks (.qbo)Quicken (.qfx)Plain .ofxWhat a U.S. Bank statement looks like
| Columns | Date · Description · Ref Number · Amount |
|---|---|
| Amounts | one amount column carries both, with money out negative |
| Date format | MMM D |
U.S. Bank prints a reference number between the description and the amount. It is a real column, not part of the description, and keeping it separate is what lets you match a transaction back to the bank's records later.
How U.S. Bank writes its transaction lines
U.S. Bank puts a reference number in its own column between the description and the amount, which is unusual: most banks either bury it in the description text or leave it off the statement entirely. Keeping it separate is worth doing, because it is what lets you match a converted row back to the bank's own records in a dispute.
What to check afterwards
The reference number is a genuine column, not part of the description. If it ends up merged into the description text, the gap between them was too narrow to detect. Widen your check by looking at a row with a short description.
How the conversion works, why scans are refused, and how to confirm for yourself that nothing is uploaded: read the details.
Where to download your U.S. Bank statement PDF
The Statements section inside online banking, listed per account. U.S. Bank keeps PDFs for several years and the download is one file per cycle.
Got several cycles to combine? Merge the converted files into one sheet, then check for duplicate rows where the cycles overlap.
U.S. Bank statement questions
Should I keep the reference number column?
Yes. It is the only field that ties a row back to the bank's record of the transaction. If you are converting for bookkeeping you can hide the column, but deleting it costs you the audit trail.
The reference number ended up inside the description. What went wrong?
The gap between the two columns was too narrow to detect on the rows the converter sampled. Check a row with a short description, where the gap is widest, to confirm whether the split held elsewhere.