Security State Bank & Trust statement to QuickBooks or Xero: QBO, QFX, OFX and CSV exports, eStatements and tie-out
Xero's list names Security State Bank & Trust. In the FDIC's BankFind records (checked 2 Nov 2026) only one active US bank has exactly that name, the one at ssbtexas.com, but many unrelated banks are called Security State Bank or a close variant. This guide covers Security State Bank & Trust at ssbtexas.com, which says it was founded as Security State Bank in Fredericksburg, Texas in 1941, added "and Trust" to its name in 1962, and serves the Hill Country, Central and North Texas (Security State Bank & Trust: Who We Are). If your client's statement comes from a different Security State Bank, the menus and terms below won't apply, though the tie-out steps still do. Here's what this bank's public pages say, and don't, about getting an account's history into QuickBooks or Xero.
What the bank's pages say
- Export from the transactions page. The bank's Quicken/QuickBooks Quick Tips sheet says that in Online Banking you click the Export icon on the right of the transactions page, and lists five report types: Spreadsheet (xsl), Spreadsheet (csv), Microsoft OFX (ofx), Quicken (qfx) and Quickbooks (qbo) (Security State Bank & Trust: Quicken/QuickBooks Quick Tips, file created Oct 2025).
- Connecting QuickBooks or Quicken. The same sheet tells Quicken users to search for Security State Bank & Trust, and QuickBooks users to search for either Security State Bank & Trust or the same name followed by DC (Quick Tips).
- Statements. The personal and business checking pages both list free electronic or paper statements (Security State Bank & Trust: Checking, Business Checking). The bank's Electronic Fund Transfer Disclosure lists obtaining a copy of a statement and eStatements among the internet and mobile banking services, and says accounts with EFT activity get a monthly statement, and every account gets one at least quarterly (Security State Bank & Trust: Electronic Fund Transfer Disclosure and Agreement).
- Business extras. The Mobile and Online Banking page lists, for business banking, adding and removing subusers or changing their permissions, viewing payment activity and two years of statement history, ACH origination with dual control and NACHA import for ACH batches (Security State Bank & Trust: Mobile and Online Banking). The help guide has a video on adding, editing and removing users for business accounts and managing what they can do (Security State Bank & Trust: Mobile/Online Guide). Ask the client to set you up as your own user rather than sharing their sign-in.
- Business checking fees. The Business Checking page lists Simply Free Business Checking with no monthly fee, Business Interest Checking at $10 a month unless the balance stays at $1,000, and Commercial Business Checking at $12 a month with an earnings credit that can offset fees. The first two include 1,000 free monthly transaction items; Commercial Business Checking doesn't. Every business checking account includes Overdraft Coverage PLUS at $30 for each overdraft covered, with an opt-in Overdraft Transfer at $7 each (Security State Bank & Trust: Business Checking). Expect those charges as lines on the statement when you tie out.
- Treasury services. The Treasury Solutions page lists ACH and wire processing, remote deposit capture, payroll cards, purchasing cards and positive pay (Security State Bank & Trust: Treasury Solutions). Batched ACH and remote deposits may show as single totals on the statement, so match them to the client's own batch reports.
Where the bank's pages don't line up
- Five export types or one. The Quick Tips sheet lists CSV, OFX, QFX, QBO and a spreadsheet export (Quick Tips), while the Electronic Fund Transfer Disclosure, in a file titled October 2021, lists only downloading account information into Quicken (Electronic Fund Transfer Disclosure). The Quick Tips sheet is newer; check the Export menu for what's offered today.
- A spreadsheet labelled xsl. The Quick Tips sheet labels the first spreadsheet option "xsl", not the usual xls Excel extension (Quick Tips). Check the file you actually get, and use the CSV option for imports.
- Two QuickBooks names. The sheet gives QuickBooks users two names to search for, one ending in DC, but doesn't say what DC means or which one to pick (Quick Tips). Ask the bank before you connect.
- Two years of what. The Mobile and Online Banking page puts "two years of statement history" in the business list under payment and bill management, next to viewing payment activity (Mobile and Online Banking). It doesn't say whether that means account statements, and the personal list and the Electronic Fund Transfer Disclosure give no period at all (Electronic Fund Transfer Disclosure).
- A fee schedule that isn't there. The Business Checking page says the cost of services on Commercial Business Checking is determined monthly "based on this fee schedule" (Business Checking), but the page shows only the comparison table, and no fee schedule appears in the bank's public sitemap. Ask for the analysis fee schedule if you need to check the service charge line.
What the bank's pages don't say
- How far back the transactions export reaches, what columns the CSV holds, and whether the QBO export is meant for QuickBooks Online, QuickBooks Desktop or both.
- How to turn on eStatements or where they sit in online banking, how long personal eStatements stay online, and what happens to access after an account closes.
- How long a business has to report a statement error. The Electronic Fund Transfer Disclosure gives 60 days after the first statement showing the problem (Electronic Fund Transfer Disclosure), but its rules are written for consumer accounts, and no business deposit agreement is posted. Ask for the account agreement and work to its deadline.
- What paper copies of old statements or account research cost; no fee schedule is posted.
- Anything about Xero.
QuickBooks Online
- Intuit's manual upload takes a PDF or image statement in English, or a QBO, QFX or CSV file. A list file must be 350 KB or less, with 3 columns (Date, Description, Amount) or 4 (Date, Description, Credit, Debit), up to 1,000 lines per upload (Intuit: manually upload transactions into QuickBooks Online, updated Aug 24, 2026). Intuit says the file should start at least one day before your oldest QuickBooks transaction in that account (Intuit). If a feed or an earlier file already brought in some of a period, upload only the dates it missed, or see duplicate transactions after a bank upload.
- The bank's sheet lists QBO, QFX and CSV exports. Check the file against the rules above before you upload it; the bank doesn't describe the CSV columns, so open it first and trim it to Intuit's layout if needed.
- To connect an account, Intuit's steps are in Intuit: connect bank and credit card accounts to QuickBooks Online. A connection doesn't reach back past what the bank holds online, so fill older months from statements.
- For QuickBooks Desktop, Intuit describes Web Connect as a .QBO file you download from your bank and import (Intuit: set up bank accounts for Bank Feeds in QuickBooks Desktop), and says you can't download the same transactions into a company file more than once (Intuit: download bank feed transactions in QuickBooks Desktop, updated Aug 5, 2026). The bank's sheet doesn't say whether its QBO export is Web Connect; for periods with only a PDF, see can QuickBooks Desktop import a PDF bank statement.
Xero
- "Security State Bank & Trust" is on Xero's US list of banks with validated PDF extraction (checked 2 Nov 2026). Xero says it can extract data from selected statement types from these banks, so test one statement and check every line before a full catch-up. Xero recommends OFX over PDF when your bank offers it, and the bank's Quick Tips sheet lists an OFX export, so for months the export reaches, that is the first route to try. Xero's PDF import is for US and Canada organizations, not the Xero Ledger plan; files must be English, 35 MB or less, up to 100 pages, at least 200 DPI, not password protected, one file per bank account (Xero Central: import a PDF bank statement).
- If you build a CSV instead, Xero needs at least Date and Amount, with money in positive and money out negative in one column, and no opening or closing balance columns (Xero Central: import a bank statement in CSV format).
- Xero treats lines matching ones already in Xero as duplicates and won't import them (Xero Central), but don't rely on that; import only the periods the account doesn't already have.
More detail: how to import bank statements into Xero from a PDF and closed bank account statements into QuickBooks or Xero.
Which route for which months
- Months the export reaches: export QBO for QuickBooks or OFX for Xero, one account at a time, then tie the file to that month's statement.
- Older months: save every eStatement online banking shows now, since the pages don't say how long they stay online or what happens after an account closes.
- Anything online banking can't reach: ask the bank for copies, and ask what they cost first, since no fee schedule is posted.
- Commercial Business Checking: expect a monthly service charge line set by the earnings credit, and ask for the analysis statement if the amount needs explaining.
Tie out each statement before you import
- Beginning balance + deposits − withdrawals = ending balance on the statement, to the cent, using the statement's own period dates.
- Chain the statements: each ending balance equals the next statement's beginning balance, and each period starts the day after the last one ended. Accounts on a quarterly cycle will have longer periods.
- If one statement covers more than one account, tie out each account on its own, and import one file per account.
- Spot-check the first and last days of the period and the largest few items against the statement.
The full method is in check a bank statement PDF is complete before you import it. Our free tie-out checker runs in your browser and shows the row where a CSV stops balancing. Then reconcile one statement at a time, oldest first; if QuickBooks says the beginning balance is off, see beginning balance doesn't match.
Client also banks with Frost Bank? See Frost Bank statement to QuickBooks or Xero. Or Prosperity Bank? See Prosperity Bank statement to QuickBooks or Xero. Or SouthStar Bank? See SouthStar Bank statement to QuickBooks or Xero.
Where LedgerReady fits
For Security State Bank & Trust, the export covers months online banking still reaches, but the public pages give no history period and nothing about Xero, so the statements are the record for catch-ups and for any month the export can't reach. If you'd rather not convert and check each statement yourself, LedgerReady turns digital statement PDFs into a QBO file, a Xero CSV, a plain CSV and a tie-out sheet showing every statement matches its opening and closing balance. It costs $15 per statement-month, and we aim to deliver within 12 hours. Tie-out guarantee: if the output doesn't reconcile to the statement's opening and closing balances and we can't fix it, you don't pay for that statement.
Skip the manual work
We turn statement PDFs into QBO, Xero and CSV files plus a tie-out sheet. $15 per statement-month, $149 for a 12-month catch-up. Prefer to check it yourself? Our tie-out checker runs in your browser. See how pros do catch-up.
Bank menus change; labels here were accurate to our knowledge in Oct 2026, so check your bank's help pages if something differs.