General Ledger + Converter in one subscription.
See pricingBY BANK · U.S. BANK
To convert a U.S. Bank statement to Excel, download the PDF from the documents area at usbank.com, upload it to the ZeraBooks bank statement converter and download Excel or CSV. U.S. Bank prints dates like “Jan 6” with no year and withdrawals with a trailing minus; ZeraBooks writes full dates and signed amounts, and proves the ending balance.
7-day trial · card required, nothing charged for 7 days · 1,000 pages a month from $79/month billed annually
STEP 1 · DOWNLOAD
Use the full website on a computer: some downloads aren’t in the mobile app. The full walk-through is in Download your U.S. Bank statements.
Larger businesses on SinglePoint use that separate site and its statements or reports area instead.
Statements are kept with your other documents.
Business card statements are in the same place: pick the card account in the dropdown.
U.S. Bank keeps up to 7 years online. Take the PDF, not a CSV or Quicken file, so the balances come with it.
Try it on your own documents. One-week free trial, both apps included.
HOW U.S. BANK LAYS IT OUT
A U.S. Bank checking statement typically opens with a one-row account summary, then lists transactions by kind, each block with its own total. Three things set it apart from most banks: the dates, the signs and the card groups.
| Part of the statement | What it holds | In the converted file |
|---|---|---|
| Statement period | Often mid-month to mid-month, such as Dec 22 through Jan 21 | The source of the year for every row |
| Account Summary | Beginning Balance on the first day, each block’s total, Ending Balance on the last day | Used for the proof, not rows |
| Deposits / Credits | Deposits and incoming transfers, with Date, Description of Transaction, Ref Number and Amount | Rows, positive |
| Card Withdrawals | Debit card purchases, grouped under each card number with a subtotal | Rows, negative, with a Card column such as “Card ••0412” |
| Other Withdrawals | ACH payments, transfers out and fees, printed with a trailing minus | Rows, negative |
| Balance Summary | Date and ending balance, only for days the balance changed | Not rows |
Layouts differ between U.S. Bank products and years, and some statements are a Uni-Statement covering more than one account. ZeraBooks Convert splits a statement with several accounts and proves each against its own balances.
WORKED EXAMPLE
Pinecrest Auto Detailing is a fictional customer with Silver Business Checking ending 2219. Its statement runs Dec 22, 2025 through Jan 21, 2026, so the same page prints “Dec 29” and “Jan 2” with no year on either. Two debit cards are on the account. Here are the rows as ZeraBooks Convert lists them, with the Card column it adds for debit card spending, and dates written the way every download writes them:
| Date | Description | Card | Type | Amount |
|---|---|---|---|---|
| 12/24/2025 | Mobile Check Deposit | Deposit | 1,200.00 | |
| 12/29/2025 | Debit Purchase Chemical Guys | Card ••0412 | Withdrawal | -312.48 |
| 01/02/2026 | Debit Purchase Shell Oil | Card ••0412 | Withdrawal | -61.20 |
| 01/06/2026 | Electronic Deposit From Square Inc | Deposit | 2,764.35 | |
| 01/09/2026 | Debit Purchase Home Depot | Card ••7781 | Withdrawal | -145.90 |
| 01/15/2026 | Electronic Withdrawal To State Farm | Withdrawal | -286.00 | |
| 01/21/2026 | Maintenance Fee | Fee | -10.00 | |
| Beginning balance 3,845.10 + rows | 6,993.87 |
The proof: 3,845.10 + 3,964.35 − 519.58 − 296.00 = 6,993.87, the Ending Balance on Jan 21 that U.S. Bank printed. Card 0412’s two purchases also add up to its printed subtotal of 373.68. December rows get 2025 and January rows get 2026, because the year comes from the statement period, not from today. Steps for a spreadsheet are in convert a bank statement to Excel.
WHAT GOES WRONG
Each of these breaks a total without any error message.
Excel either leaves it as text or guesses the current year. On a statement that crosses New Year, half the rows land in the wrong year and a December close comes out short.
Withdrawals print as “286.00-”. Many spreadsheets read that as text or as a positive 286, so money out adds to the balance instead of taking from it.
Each card group ends with a subtotal line. Paste the block and every card’s spending is counted twice.
Dec 22 to Jan 21 doesn’t match a calendar month. For month-end books, keep the statements in order; the opening of each must equal the closing of the one before.
CSV, QUICKEN OR QUICKBOOKS
THE OTHER DOWNLOADS
From the full website, U.S. Bank lets you download transactions as CSV, Quicken or QuickBooks files. They usually carry no opening or closing balance, so nobody can show the month is complete. For books, a loan file or an audit, convert the statement PDF.
THE PDF ROUTE
ZeraBooks reads the Beginning and Ending Balance from the account summary and marks the statement Proven only when every row ties to them. Then pick QuickBooks-ready for QuickBooks Online’s bank upload; see bank statement to CSV for the import files.
MORE BANKS
Up to 7 years online, from the documents area at usbank.com. For older months, ask U.S. Bank.
U.S. Bank statement periods don’t always follow the calendar month. That is fine: upload each statement as it is, in order. ZeraBooks takes each row’s year from the statement period and checks each statement on its own balances.
Yes. Upload it to the same page; it is proven as previous balance plus charges minus payments equals the new balance, with each cardholder checked against their printed total. See credit card statement to Excel.
No. ZeraBooks has no bank feeds and never asks for your U.S. Bank sign-in. You download the PDF and upload it.
Convert comes with the ZeraBooks subscription: 1,000 pages a month for $79 a month billed annually or $149 monthly, after a 7-day trial. See ZeraBooks pricing.
ONE-WEEK FREE TRIAL
Proven against the ending balance, 1,000 pages a month from $79 a month billed annually. Other banks: TD Bank, Citi and Wells Fargo. The subscription also includes AI bookkeeping for the books themselves.
Last updated November 5, 2026 · Written by Damin Mutti, founder of ZeraBooks