Truist Bank Statement to Excel: A Practical Guide

TL;DR Download the monthly statement PDF from Truist online banking (not a printed activity page), convert it to a one-row-per-transaction spreadsheet, and prove it's complete by checking that the opening balance plus every transaction equals the closing balance. Then clean up descriptions, tag transfers, and save a CSV copy if you're importing into QuickBooks, Xero or Wave. A transaction download from online banking is fine for recent activity, but the PDF statement is the version your accountant, lender or auditor will treat as the record.

Truist was formed when BB&T and SunTrust merged, and plenty of customers still have older statements from both legacy banks sitting in a downloads folder alongside newer Truist ones. That mix is one reason getting Truist data into Excel can feel harder than it should: you may be dealing with three different layouts for the same account history.

This guide walks through the whole job: which file to start from, how to convert it, how to check the result, and how to shape it for a spreadsheet or accounting software. Truist updates its online banking screens from time to time, so we describe the steps in general terms rather than listing exact button names.

Which Truist file should you start from?

There are usually two ways to get transaction data out of a bank, and Truist is no different.

The transaction download. Online banking typically lets you export recent activity in a spreadsheet-friendly format such as CSV, and sometimes in formats meant for personal finance or accounting software. This is quick, and if all you need is last month's spending in a spreadsheet, it may be all you need. The limits are the usual ones: the date range available for download can be shorter than your statement history, pending items can sneak in, and a download doesn't carry the opening and closing balances that make a statement checkable.

The PDF statement. The monthly statement is the official record for the period. It has the opening balance, the closing balance, every posted transaction and the fees and interest for the cycle. It's what a mortgage lender, an auditor, a tax preparer or a court will ask for. It's also usually available further back than the transaction download.

As a rule of thumb:

If you're unsure, use the PDF. You can always check a download against it, but you can't easily check a download against nothing. Our guide on how to get old bank statements covers what to do if the months you need aren't showing online.

To find statements, sign in to Truist online banking or the app, open the account, and look for the statements or documents area. Download each month as a PDF and save it with a predictable name, such as truist-checking-2026-03.pdf. That small habit saves a lot of confusion later when you have twelve files open.

What a Truist statement contains

Truist statements follow the general pattern of most US bank statements. Expect to see:

• An account summary near the top with the statement period, the opening balance, totals for deposits and withdrawals, and the closing balance.
• Transaction sections, often split by type, such as deposits and credits, checks, and other withdrawals or debits, each with its own subtotal.
• A daily balance section on many checking statements, listing the ledger balance at the end of each day with activity.
• Fees and interest for the cycle, and on some accounts year-to-date totals.
• Disclosures and notices at the end, which aren't transactions at all.

Credit card statements look different: a payment summary, a list of payments and credits, a list of purchases, any fees and interest charged, and the new balance and minimum payment.

The split into sections matters for conversion. If you copy and paste section by section, you end up with a spreadsheet grouped by type instead of by date, and the order of transactions on a busy day gets lost. A good conversion merges the sections back into one chronological list and keeps the section as a hint (deposit, check, withdrawal) that helps with categorizing later.

Converting the PDF to Excel

You have three realistic options.

Option 1: copy and paste

Select the text in your PDF viewer, paste into Excel, and fix it up. This works for a short statement with a handful of transactions, and it's free. It gets painful quickly: columns merge into one cell, multi-line descriptions split across rows, amounts come through as text, and the year often isn't printed next to each date. If you go this route, use Excel's Text to Columns or TEXTSPLIT to separate the fields, then convert the amounts with VALUE or NUMBERVALUE.

Option 2: Excel's built-in PDF import

Recent desktop versions of Excel can import data from a PDF through Power Query (Get Data, then From File, then From PDF). It detects tables on each page and lets you choose which to load. For a statement with clean tables, it can do a reasonable job. For statements where the transaction sections are laid out as text rather than true tables, it may split one transaction across rows or miss sections. Our Power Query guide for bank statements explains how to tidy what it gives you.

Option 3: a dedicated converter

A bank statement converter is built for this layout problem. SheetStatement's PDF bank statement to Excel converter reads the statement, merges the sections into one chronological ledger, fills in the year for each date from the statement period, and checks that the transactions add up to the closing balance before you export. You can download Excel, CSV, or files shaped for QuickBooks and Xero.

If you want to try it on a real Truist statement, the free plan covers 3 pages a month. Paid plans are $9, $19 or $39 a month depending on volume, which matters mostly if you're converting a year of statements or working across several clients. There's also a Truist bank page with notes on the layout.

Whichever option you use, aim for this shape:

One row per transaction, real dates, a single signed amount column (money in positive, money out negative), and a running balance if you can get one.

Checking the conversion balances

This is the step people skip and later regret. Before you do anything else with the spreadsheet, prove it's complete.

The test is simple:

Opening balance + sum of all amounts = closing balance

In Excel, if the opening balance is in F1, the closing balance in F2 and amounts in column C:

=ROUND(F1 + SUM(C2:C200) - F2, 2)

The result should be 0. If it isn't, something is missing, duplicated or has the wrong sign.

A running balance check finds the exact row. In E2, enter =F1 + C2, and in E3, =E2 + C3, then fill down. Compare your running balance against the daily balances printed on the statement. The first day where they disagree is where the problem is.

Common causes on bank statements generally:

• A transaction description that wrapped onto two lines was read as two transactions.
• A subtotal line was picked up as a transaction.
• A check from the checks section was missed because it sat in a separate table.
• A refund or reversal was recorded with the wrong sign.

Our balance checker does this test for you if you'd rather not set up the formulas.

Cleaning the data in Excel

Once the numbers tie out, make the data pleasant to work with.

Fix the dates. Make sure the date column contains real Excel dates rather than text. A quick test: =ISNUMBER(A2) should return TRUE. If dates came through as text, DATEVALUE or Power Query's type conversion will fix them.

Trim descriptions. Bank descriptions often carry long reference numbers, card digits and location codes. Keep the original column for your records and add a cleaned one next to it. Something like =TRIM(LEFT(B2, 40)) is a crude but useful start; a lookup table that maps messy merchant strings to clean payee names is better for anything you'll repeat monthly.

Tag transfers. Transfers between your own Truist accounts, payments to your Truist credit card, and moves to savings aren't income or expenses. Mark them before you categorize anything else, or your totals will be inflated on both sides.

Categorize. Add a category column and fill it with a rules table and XLOOKUP. Our guide to Excel formulas for categorizing bank transactions has copy-ready formulas.

Turn it into a table. Select the data and press Ctrl+T. Tables keep formulas consistent as you add months, and they make filters and pivot tables much easier.

For a fuller walkthrough of all of these steps, see how to clean bank statement data in Excel.

Getting Truist data into accounting software

If the spreadsheet is a stepping stone to QuickBooks, Xero or Wave, shape the CSV for the software rather than for humans.

QuickBooks Online accepts a CSV with either three columns (date, description, amount) or four (date, description, credit, debit). Keep one header row, one date format and plain numbers. If you'd rather avoid column mapping, a QBO file is another route. Our guide to importing bank statements into QuickBooks Online covers both approaches, and the bank statement to QuickBooks converter produces either file.

Xero has its own CSV template with specific column names. The Xero CSV import format explainer shows what goes where.

Wave wants a clean CSV with a date, description and amount. See how to import bank statements into Wave.

Two rules apply everywhere. First, import one statement period at a time and reconcile it before moving on. Second, if the account is also connected to a bank feed, only import dates before the feed's first transaction, or you'll create duplicates.

Legacy BB&T and SunTrust statements

If your history goes back before the merger, you'll likely have statements in older BB&T or SunTrust layouts. They're still bank statements with the same basic structure (balances, deposits, withdrawals, checks), so the same approach works. A few things to watch:

• Account numbers may differ between the legacy statement and the Truist statement for what feels like the same account. Note both in your workbook so the history connects.
• The closing balance of the last legacy statement should equal the opening balance of the first Truist statement for that account. If it doesn't, there may be a gap of a few days between statement periods; check whether a transitional statement exists.
• Descriptions changed format. The same merchant may be written differently before and after. If you're using a rules table for categorizing, add both versions.
• Older statements may be scans. If the PDF is an image rather than text, you'll need OCR or an AI-based reader. Our explainer on converting scanned bank statements covers the trade-offs.

Keep each layout's months together while converting, check each month's balances, and then combine everything into one workbook with a source column that records which statement each row came from.

A worked example

A small landscaping business banks with Truist and has fallen four months behind on its books. The owner has four checking statements and four credit card statements as PDFs, and needs everything in QuickBooks Online before a quarterly tax estimate.

1. Collect the files. Four checking PDFs and four card PDFs, renamed by account and month.
2. Convert. Each statement is converted to a spreadsheet. The checking statements average about 60 transactions a month; the card statements around 35.
3. Check balances. Seven statements tie out on the first pass. One checking month is off by exactly $250.00. The running balance shows the first disagreement on the 14th, where a mobile deposit appears in the statement but not in the spreadsheet, because the line was split by a page break. Adding it brings the difference to zero.
4. Tag transfers. Four payments from checking to the Truist card are tagged as transfers on the checking side, and the matching payments on the card side are tagged the same way.
5. Categorize. A rules table handles fuel, equipment rental, the phone bill and the two regular suppliers. The remaining 40 or so items are categorized by hand.
6. Export and import. Each month is exported as a QuickBooks CSV and imported into the matching QuickBooks account, oldest first.
7. Reconcile. Each month is reconciled in QuickBooks against the statement closing balance.

Total time, including the one problem month, was an afternoon. The step that saved the most time was the balance check in step 3; finding a missing $250 deposit after importing into QuickBooks would have taken far longer.

Troubleshooting

Dates are missing the year. Many statements print dates like 03/05 without a year. Add the year from the statement period. Watch statements that cross December and January, where the year changes partway through.

Amounts are all positive. The conversion has put deposits and withdrawals in separate columns, or lost the signs. Create a single amount column: deposits positive, withdrawals negative. For card statements, decide on a convention (purchases negative, payments positive is common for imports) and stick to it.

Checks have no payee. Statements typically show the check number and amount, not who you paid. Add payees from your checkbook register or the check images if you need them for categorizing.

The daily balances don't match the running balance on some days. Look at the first mismatched day. The difference is usually exactly one transaction amount, which tells you what to look for.

Excel shows amounts as text. Numbers aligned to the left are a giveaway. Use =VALUE(C2) or multiply by 1, or use Data, Text to Columns, Finish to force conversion.

Duplicate rows after combining months. Statements don't overlap, but downloads sometimes do. If you mixed downloads and statements, remove duplicates on date, amount and description, then re-run the balance check.

Keeping it simple every month

Once the backlog is done, the monthly routine is short:

1. Download the new statement PDF when it's ready.
2. Convert it and check that it balances.
3. Tag transfers and categorize.
4. Append it to your workbook or import it into your accounting software.
5. Reconcile.

If you'd like that routine as part of a full monthly close, our month-end close checklist puts it in context.

Ready to convert a Truist statement?

Upload a Truist statement PDF to SheetStatement, review the extracted transactions, confirm the balance check passes, and download Excel or CSV. The free plan handles 3 pages a month, so you can test it on a real statement before deciding whether a paid plan makes sense.

FAQ

Can I download a Truist statement directly as Excel?

Online banking usually offers a transaction download in a spreadsheet-friendly format for recent activity. The monthly statement itself is a PDF. If you need statement periods, older history, or the opening and closing balances, convert the PDF.

How far back can I get Truist statements?

It depends on the account and what online banking shows. If the months you need aren't available online, contact the bank and ask for copies; there may be a fee for older statements.

Will legacy BB&T or SunTrust statements convert the same way?

Yes, the same approach works. Check each month's balances, note any account number changes, and confirm the last legacy closing balance matches the first Truist opening balance.

How do I know the conversion didn't miss anything?

Check that the opening balance plus the sum of all transactions equals the closing balance. If the difference is zero, every transaction is accounted for.

Can I import Truist statements into QuickBooks or Xero?

Yes. Convert the PDF, export a CSV in the layout the software expects (or a QBO file for QuickBooks), import one month at a time, and reconcile each month.

Does converting a statement change the original?

No. The PDF stays as it is. Keep it alongside the spreadsheet, since lenders, auditors and preparers often want both.