Format Truist Bank (BB&T / SunTrust) CSV for QuickBooks

Truist Bank (BB&T / SunTrust) provides CSV exports that do not play nicely with accounting software. Because truist stores check numbers in a separate check number column so check transactions import with a blank description unless the column is explicitly mapped as a reference field, bookkeepers waste hours manually fixing columns every month. This tool maps Check Number as a Reference field and fills Description correctly for all transaction types including paper checks.

LedgerMatch works with Google Sheets™ for spreadsheet-based bank reconciliation. Send your bank and ledger data from a spreadsheet, match transactions, and review exceptions without connecting your bank account.

Read the Truist Bank (BB&T / SunTrust) CSV CSV format guide

Add to Chrome — it’s free · Included with all plans Install Google Sheets™ add-on Install for Microsoft Edge