Truist statement PDF to Excel: post-merger unified layout
Truist only sends statements as PDFs. If you want those transactions in a spreadsheet for taxes, budgeting, or bookkeeping, the file has to be converted first. Here's how to do it for Truist checking, savings, and the post-merger unified layout.
Why this is annoying (the manual way)
Open a Truist PDF in Acrobat or Preview, drag-select rows, paste into Excel. The signed Amount column lands as text in some rows, as a number in others, depending on whether the minus sign sits flush with the digit. Multi-line descriptions wrap to two cells. The "Statement of Account" header repeats on every page and copy-paste keeps every copy. A 12-page statement turns into a long evening of formatting before you can reconcile anything.
The 30-second method with Bank2XL
Bank2XL is a Chrome extension. One drag, one click.
- Install Bank2XL from the Chrome Web Store at bank2xl.app
- Download the Truist PDF from the Statements area in Truist Online Banking
- Click the Bank2XL toolbar icon
- Drag the PDF onto the drop zone
- Click "Convert to Excel"
Free during beta: 10 statements a day, no signup. A typical Truist statement converts in 25 to 45 seconds.
What about Truist format quirks
Truist is the company you get after BB&T and SunTrust merged in late 2019. The full rebrand finished by 2022, and the statement layout settled into the current unified Truist skeleton around 2023. If you have old PDFs from before then, the headers will say BB&T or SunTrust and the columns sit differently. Bank2XL recognizes all three.
- Current Truist statements lead with a "Statement of Account" header, then list transactions under Posting Date, Description, and Amount. The Amount column is signed: positive for deposits, negative for withdrawals. Tools that expect separate debit and credit columns split this incorrectly.
- The "Service Charge Summary" block on personal checking sits inline with the transaction list. Template-based parsers often pull the monthly maintenance fee or overdraft fees twice, once as a transaction and once as a summary line. Bank2XL keeps it as one row.
- Multi-account stapling is common: a household checking, a savings, and a money market account often ship in one PDF. We split them into one sheet per account so the running balances stay separate.
- Legacy BB&T and SunTrust statements still surface for older archives. The column order is different from Truist but the extraction handles both.
When to use the alternatives
- Manual copy-paste. Tolerable for one statement, painful past three.
- Adobe Acrobat Pro Export to Excel. Reasonable on Truist checking, less reliable when the Service Charge Summary lands mid-page.
- Template-based bank converters. Accurate as long as the vendor's Truist template is current. The merger transition broke a lot of these tools for months. We work without per-bank rules, so layout shifts don't drop transactions.
FAQ
Is the upload secure? My statement has my account number on it. The PDF goes to the extraction backend over HTTPS. We process files in memory, the file auto-deletes within 24 hours, and you can opt out in Settings. Details at /data-retention.html. Account numbers are masked in the Excel output by default. We don't train AI on your content or share it.
Does it work on old BB&T or SunTrust statements? Yes. The layout is detected automatically, including the legacy formats. You don't have to flag the file as pre-merger.
Can I batch convert a year of Truist statements? During beta the cap is 10 a day, which fits a 12-month set in two sessions. Each PDF runs as its own conversion in 25 to 45 seconds.
Get started
Install Bank2XL from the Chrome Web Store at bank2xl.app. Free during beta: 10 PDFs a day, no signup. Drop a Truist statement, click Convert, get a clean Excel file back.
Skip the manual cleanup — try Bank2XL free
Drop a PDF, get a clean Excel back. 10 statements per day during beta, no signup, no credit card.