Convert Truist Statements to Excel and CSV
A Truist statement records the activity in one of your accounts. It arrives as a PDF, and you need the rows in a spreadsheet.
Statements to Sheets reads the transaction lines and returns a CSV with a full date, a description and a signed amount on every row. When the file prints a running balance, it comes through as its own column. The file opens in Excel and imports into Google Sheets and QuickBooks.
Upload your Truist statement to see the first rows before you pay. The first 50 transactions are free.
Why a Truist statement is hard to convert
Bank PDFs are built to be read, not to be parsed. Text that looks like a neat table on screen is a loose set of strings placed at fixed positions. Copy it into a spreadsheet and the description, the date and the amount often land in one cell.
Signs get lost. A deposit and a payment can look alike once the surrounding headings are gone. Your totals are then wrong by twice the amount of every payment you mistook for income.
Years go missing. A statement can show a day and a month on each line and give the year only once. A tool that treats each line alone cannot place a January row that follows a December one.
Summary tables share the page with the transactions. Totals, fee summaries and balance snapshots look like rows to a simple reader, and they inflate every sum you run.
Joint accounts and business accounts add noise. Several people may spend from one account, and a business may log dozens of small card charges a day. A long month can run past a hundred rows, and retyping them is how a stray digit ends up in your books.
About Truist statements
- Customers often keep several years of files, and older files can look different from newer ones.
- Statements come as PDFs, usually monthly, and some customers receive paper copies that they scan.
- People convert them to prepare a tax return, to keep a small business set of books, to document income, or to find a charge they do not remember.
How we convert it
- Amounts get the right sign, so money out is negative and money in is positive.
- Every row gets the full year.
- A Balance column appears only when the file prints one. We never calculate or guess a balance.
- The second line of a wrapped description is not counted as a separate transaction.
- Scanned pages are read with OCR, and sideways pages are turned upright.
Every conversion also checks each page against the page image, and lines that continue a wrapped description are not counted as extra transactions.
The result is a CSV with Date, Description and Amount columns (plus Balance when the statement has one) that opens in Excel and imports into Google Sheets and QuickBooks. You pay per transaction, not per page. See plans and pricing.
What people do with the file
Small business books. Import a year of Truist business activity into QuickBooks and spend your time on the categories instead of on typing.
Tax season. Sort the rows by description to pull out charitable gifts, medical bills or business expenses, and total each group in one pass.
Finding a charge. Search a single sheet for a merchant name across twelve months. That beats opening twelve PDFs one by one.
Shared accounts. When two people spend from one account, a sheet lets each of you filter for your own purchases and settle up at month end.
Long histories. Convert old and new files and keep them in one workbook with the same columns.
Good to know
- Credit card, loan and mortgage statements may be laid out differently from account statements.
- Scans can contain OCR digit errors. Compare totals with the statement.
Questions
Will payments come out as negative numbers?
Yes. Money out is negative and money in is positive, so the Amount column adds up to the net change in the account.
My statement shows only a day and a month on each line. Will the CSV have the year?
Yes. Each row in the CSV gets the full year.
Does it work on a scanned statement?
Yes. Scans are read with OCR, and sideways pages are turned upright. Compare the totals with the paper copy, since a scan can hide a digit.
How do you charge?
The preview is free, and so are the first 50 transactions. After that you pay per transaction, not per page.
Related Guides

Written by
Jeff GoughFounder of Statements to Sheets and Cascade Foundry LLC. Built this tool after converting 300+ pages of printed bank statements into CSV for a friend's QuickBooks catch-up. Read the full story →