Convert a Truist statement PDF to Excel

How to convert a Truist statement PDF to Excel

1. Download the PDF: sign in to Truist Online Banking (or the Truist mobile app), open Documents, pick the account and open the statement, then save the PDF. Use the downloaded PDF, not a scan of a paper statement: scans don't work yet.
2. Upload it above. Utilly reads the Checks, Other withdrawals, debits and service charges, and Deposits, credits and interest sections and checks previous balance − checks − withdrawals + deposits = new 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, in the statement's order.
4. Save as .xlsx (File → Save As → Excel Workbook) if you want to keep formulas or formatting.

What we read on a Truist statement

A Truist checking statement opens with "Your account statement", the product name and account number (for example TRUIST BRIGHT CHECKING) and an Account summary. The transactions follow in three sections, each with its own DATE and AMOUNT($) columns and a "Total … = $" line: Checks, Other withdrawals, debits and service charges, and Deposits, credits and interest. There's no running balance next to the rows.

What this is based on: test statements built in Truist's older and newer checking layouts above, with made-up names and transactions, plus 19 Truist Bright Checking statements from January 2024 to October 2025 that a homeowners' association posts publicly: 200 of 200 rows read, including 11 checks, and all 19 balanced. Before this page, our reader balanced none of them. We don't link to them because they contain people's details. We haven't run every Truist statement style through it: Truist business checking, savings and money market statements, statements with several accounts, older BB&T and SunTrust statements and Truist credit card statements haven't been tested, and a scanned statement won't read. That's why the balance check runs on every file: if yours doesn't balance, you see the difference before paying.

What the Excel file looks like

Date,Description,Amount,Balance
2026-09-04,Check 1187,-240.00,
2026-08-28,ZELLE PAYMENT TO Sample Lawn Care PAYMENT ID BBT400112233,-85.00,
2026-09-08,INTERNET PAYMENT PAYMENTS Sample Electric Co 4100200300,-132.47,
2026-09-25,MAINTENANCE FEE,-12.00,
2026-08-29,TRUIST ONLINE TRANSFER ONLINE FROM ****4471,1500.00,
2026-09-10,MOBILE DEPOSIT,84.00,

Want money in and money out in two columns again? Use =MAX(C2,0) and =MAX(-C2,0). Want the month in date order rather than section by section? Sort the sheet by the Date column.

How far back Truist statements go

Sources: Truist: Wealth online & mobile banking (Disclosure 4: how long paperless statements are available by product, and where to check), Truist: Quicken Desktop Deactivate & Reactivate Guide (Truist Online Banking - DC, registering a data file under Profile → Preferences), Truist: Business Deposit Accounts Fee Schedule (effective June 5, 2026: Direct Connect fees). Checked Oct 27, 2026.

QuickBooks and Quicken files for Truist

Truist connects to Quicken and QuickBooks Desktop through Direct Connect: in Quicken you pick "Truist Online Banking - DC", and Truist's guide has you register the data file in Truist Online Banking under Profile → Preferences, in the Quicken and QuickBooks tiles. Truist's business fee schedule lists Direct Connect at $9.95 a month for Quicken and $14.95 a month for QuickBooks on business accounts. If a connection covers the dates you need, use it. For months that only exist as statements, or the statements a client sent you, start from the PDF. The same Utilly conversion that gives you Excel also includes:

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

Common problems

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, or PNC statement to Excel.