Truist CSV to QBO Converter: Convert Truist CSV to QuickBooks

Sign in to Truist online banking on a desktop browser, open the account, and use the download button above the transaction list. Pick your date range and keep the file type set to CSV, which is what Truist recommends. Upload that CSV here. The converter reads the date, description, and amount columns, checks the totals against your file, and returns a .qbo ready to import.

Log in at truist.com, click the account to open the current transactions view, then click the download button. Truist offers the most recent 30 or 60 days as a shortcut, or a custom date range, and the file type defaults to CSV. Save the file and convert it. The download lives on the desktop site rather than the mobile app.

Yes. Since the BB&T merger, Truist charges roughly $15 per month for the automated connection that feeds transactions into QuickBooks Online. Adding the account manually is free, and so is downloading your activity as a CSV. Converting that free CSV into a .qbo gets the same transactions into QuickBooks without the recurring charge, which is why a lot of Truist business customers stopped paying for the feed.

When BB&T and SunTrust accounts moved onto the single Truist platform, the underlying account and routing identifiers changed, and many QuickBooks connections broke and would not re-link. The QuickBooks community has years of reports of Truist transactions not loading. Until the connection is rebuilt, a downloaded CSV converted to a .qbo brings the transactions in without touching the feed at all.

For the direct .qbo download, yes. Truist requires you to switch on the accounting software download in online banking under Profile and Settings before QuickBooks can pull a Web Connect file, which is a step most banks leave on by default. The CSV export needs no such setting, so converting the CSV skips the enrollment entirely.

No. QuickBooks Desktop has no native CSV transaction import. Its only transaction import path is Web Connect, which accepts .qbo files, so a Truist CSV has to be converted first. QuickBooks Online will take a CSV, but it asks you to map columns on every upload and it will not fix Truist date formatting or the split of debits and credits on its own.

Truist CSV exports include columns QuickBooks does not expect, such as the running balance and a separate transaction type. QuickBooks Online accepts either a three column layout of date, description, and amount, or a four column layout that splits credit and debit, and it caps a single upload at 350 KB. The converter drops the extra columns, normalizes the dates, and writes the amounts with the correct sign.

Truist online banking generally shows around 18 months of activity, and the download offers the last 30 days, the last 60 days, or a custom range within that history. The bank feed, when connected, typically reaches back only about 90 days. To rebuild older books, pull the CSV for each range you need and convert each one.

Yes. Truist business checking and Truist One Banking accounts download the same CSV structure as personal accounts, and both convert the same way. Legacy BB&T and SunTrust accounts that now sit on the Truist platform export from the same screen, so their files convert without any extra step.

QuickBooks caps a single CSV upload at 350 KB, roughly 1,000 transactions, which is why a busy quarter fails to upload as a spreadsheet. Intuit applies the same 350 KB ceiling to .qbo, .qfx and .ofx uploads, so a converted file may still need splitting, but a .qbo carries far more transactions inside that budget than a CSV of the same size does. If you are converting several accounts or a full year of history, run them together with the bulk CSV to QBO converter instead of uploading files one by one.

$14.95 a month for the QuickBooks Direct Connect service, per Truist's published fee schedule, with the Quicken equivalent at $9.95. That is a recurring charge for the connection itself and it is separate from your QuickBooks subscription. Over a year it is around $180 to keep a feed running for one business.

Worth knowing before you enroll: the fee buys automation, not accuracy. Direct Connect delivers the same transaction data that sits in the CSV you can download for free, in the same account, on the same day. If you close the books once a month rather than watching the feed daily, converting the export is the cheaper habit and produces an identical .qbo file.

Yes, and the sign convention is the thing to watch. On a credit card account the meaning of a positive amount flips: a purchase increases what you owe while a payment reduces it, which is the opposite of a checking account. The converter reads the account type from the file and sets the signs so QuickBooks does not book every purchase as income.

If you have previously imported a card CSV by hand and watched the balance move the wrong way, that is exactly this problem. More on the card-specific mechanics is on the credit card CSV to QuickBooks page.

Yes. The converter accepts .csv, .txt, .xls, .xlsx and .xlsm, so whichever format Truist online banking hands you will work. Use CSV where you have the choice, because Excel is where date damage happens.

Opening a bank export in Excel and saving it again can rewrite two digit years, turning 00 to 29 into 2000 to 2029 and 30 to 99 into 1930 to 1999, and a workbook passed between Windows and Mac shifts every date by four years and a day because the two default to different date systems. If the file has to go through Excel, import it as text rather than double-clicking it.

Almost always because a live bank feed and a manual import both delivered the same days. A .qbo file protects itself, since every transaction carries a FITID that is unique within the account and QuickBooks skips any FITID it has already seen. What it cannot do is recognize a row the feed already added under a different identifier.

The fix is to pick one channel per period. Either disconnect the Truist feed before importing history, or import only up to the day before the feed's coverage begins. One caution if you are cleaning up: QuickBooks remembers a FITID even after you delete the transaction, so re-importing the file to restore a row you deleted by mistake will not work and you have to re-enter it. The full cleanup routine is on duplicate transactions in QuickBooks Online.

Choose the .qbo route unless you have a specific reason not to. The review queue is what stops a mapping mistake from becoming a journal entry, and on a first import from a new bank that is worth the extra click.

Reconcile the period you just imported before you import the next one. Take the Truist statement ending balance and date, run the reconciliation in QuickBooks, and confirm the difference is zero before moving on. Doing this per period is what turns a mapping error into a ten minute fix instead of a year-end investigation.

If the difference will not clear, the amount itself is usually the clue. A figure evenly divisible by nine points to transposed digits, and a difference that is exactly twice a transaction amount points to a sign that went in backwards. Both are covered in the QuickBooks bank reconciliation discrepancy guide.

Yes. Truist writes the same export structure across personal checking, savings, money market, Truist One Banking and business checking, so anything you can download from online banking converts. Accounts with sparse activity convert fastest, though the interest posting is worth a glance because banks describe it inconsistently between statement and export.