Truist statement to Xero: download, convert and import

Xero can take Truist data three ways: a bank feed (going forward), a file download for recent activity, and PDF statements for older months (imported directly where Xero offers that, or converted to CSV). Catch-up and clean-up work usually needs the last two.

1. Recent activity: the Truist download

In Truist online banking (use a desktop browser), open the account's transaction activity and use the download or export option, then pick a date range and file type. Truist's small-business online banking page says you can download or print up to 18 months of account history. The formats and how far back you can go vary by account, so check your online banking. For bank downloads, Xero recommends OFX, QFX or QuickBooks files where offered, or CSV otherwise, so pick a Quicken (QFX/OFX) option if it is offered, or CSV otherwise. The date range on offer is shown in the download dialog and is usually shorter than the statement archive.

2. Older months: PDF statements

Open the statements section of online banking and save each monthly PDF. For months older than online banking shows, request copies from Truist (a fee may apply, so check Truist's current fee schedule first). Save one PDF per statement period and name it by account and period (for example 4821_2025-03.pdf) so a missing month is obvious.

In Xero organizations in the US and Canada (not on the Xero Ledger plan), you can import a PDF statement directly through Import a statement. Xero lists Truist among the banks whose selected statement types have validated PDF extraction, sets limits (English, 35 MB, 100 pages, at least 200 DPI, no password), and still recommends OFX over PDF where the bank offers it (Xero Central, Import a PDF bank statement). Otherwise, or if you want to check every month before it goes in, convert each PDF to CSV as below.

3. Shape the CSV for Xero

• Xero's bank statement CSV needs at least Date and Amount, plus a payee or description. Download Xero's own template from the import screen and match its columns.
• Use one signed Amount column: money into the account positive, money out negative.
• Keep one date format throughout the file, and choose the matching format in Xero's import step.
• Delete summary rows (totals, balance lines, rewards tables). They are not transactions.

Truist-specific things to watch

• Truist formed from the BB&T and SunTrust merger. Older statements for converted accounts can have a legacy BB&T or SunTrust layout, and pre-conversion history may not appear in Truist digital banking at all. Ask the client for their saved PDFs before requesting copies.
• If several accounts are printed on one combined statement, split out each account's section and tie each one out separately. Never import two accounts into one Xero bank account.
• If you reuse a CSV template from an earlier download, compare the header row first. Bank export layouts change from time to time.

4. Tie out before you import

1. For each statement: opening balance + all amounts = closing balance.
2. Chain the periods: each closing balance must equal the next opening balance.
3. If a month doesn't tie, find the gap now. It is much harder to find after the lines are reconciled in Xero.

5. Import into Xero

1. In Xero go to Accounting → Bank accounts, open the account's menu and choose Import a statement.
2. Upload the file, map the columns and check the preview.
3. If a bank feed is already connected, import only dates before the feed started, or you will get duplicate statement lines.
4. Reconcile the imported lines, then compare Xero's statement balance with the PDF's closing balance.

Troubleshooting: see Xero bank statement import errors. For QuickBooks instead, see Truist to QuickBooks. Need months older than your Xero bank feed? See importing older transactions into Xero.

Bank menus change; labels here were accurate to our knowledge in Oct 2026, so check your bank's help pages if something differs.