How to Import Frost Bank Transactions into QuickBooks (Past the 18-Month Window)

Short answer: Frost Bank supports Direct Connect, so Quicken and QuickBooks can download transactions automatically from an active account. Two limits push people to a manual import: Frost Business Connect keeps only 18 months of history, and the QuickBooks Online connection has gone through stretches of not downloading. For anything older than 18 months, for a dropped feed, or for a bookkeeper with no login, convert the Frost statement PDF to a QBO file and import it under Transactions, Bank transactions, Upload from file in QuickBooks Online, or File, Utilities, Import, Web Connect Files in Desktop.

Frost is the largest Texas-based bank, and it leans commercial, which means the accounts feeding into QuickBooks tend to be busy business accounts with real history behind them. That is exactly where the 18-month ceiling bites. A live feed handles this month fine. A cleanup that reaches back two or three years, or a lender package that needs last year in full, runs out of runway inside online banking.

What Frost actually offers for QuickBooks

Frost supports Direct Connect, the two-way connection type that lets Quicken and QuickBooks pull transactions automatically and, in Quicken, refresh on every One Step Update. For a live feed on an open account, that is the smooth path, and it is worth using when it is available to you. Frost also runs two business platforms: Frost Business Connect for small and mid-market companies, which keeps 18 months of history, and Frost Treasury Connect for corporate clients, which offers more flexible export options. The wrinkle is that not everyone is on the platform they need, and the QuickBooks Online connection specifically has been unreliable for stretches, with a manual Web Connect import offered as the documented workaround.

The 18-month history problem

Business Connect showing 18 months is fine for keeping current and useless for going back. When your books need a period older than a year and a half, the feed and the online export both stop short, and the transactions still exist only in one place: the statement archive. The statements reach much further back than the activity view does, which is the whole reason a conversion step exists.

Upload the statement for the period you need to the Frost Bank statement to QBO converter, choose QBO as the output, and import that file exactly the way you would import one from the bank. QuickBooks cannot tell the difference, because the format is the same: an OFX document carrying dates, descriptions, and signed amounts. What QuickBooks cannot read is the PDF itself, so the conversion is doing the one thing the raw statement cannot do on its own.

Importing Frost transactions into QuickBooks Online

If your Frost feed is live and the period is inside 18 months, let it sync. If the QuickBooks Online connection has stopped, do not wait on it for a close that is due: download or convert the statement, then upload the QBO file under Transactions, Bank transactions, Upload from file, choosing the correct account. The transactions land in the For review tab ready to categorize. Keep each upload under 1,000 transactions and 350 KB, the caps QuickBooks Online enforces, and split a busy year into a couple of files if needed.

Importing Frost transactions into QuickBooks Desktop

QuickBooks Desktop takes a Web Connect file: File, Utilities, Import, Web Connect Files on older versions, or File, Import, From Web Connect on newer ones. Whether the .QBO came from Frost's own download or from converting the statement, the import is identical. Map it to the right Frost account, review the transactions, and accept them. Keep one Frost account per file, since QuickBooks maps a single QBO to a single account.

Keeping duplicates out of the register

Duplicates show up when a live feed and a converted file overlap the same dates. Before a manual import, open the register, find the newest transaction that came from the bank, and start the converted file the day after it. If a Frost Direct Connect feed is running on that account, deactivate it in Bank Feed Settings first, so the feed and the file cannot post the same activity twice. QuickBooks does try to catch duplicates on Web Connect imports, but it matches on amount, date, and reference, so a re-issued description or a shifted posting date will slip past it. If duplicates land anyway, exclude them from the For review tab rather than deleting reconciled entries.

Reconciling the older periods you just brought in

Bringing three years of Frost activity into QuickBooks is only useful if it ties out. Import the periods oldest first and reconcile each month against its statement before moving to the next, so a clean ending balance confirms the period before you build on it. This is the same discipline whether you are doing a tax-year cleanup or preparing a file for a lender, and the sequencing in our guide to catch-up bookkeeping in QuickBooks keeps a multi-year rebuild orderly. If the goal is a loan application, a lender is going to run its own read on the same statements, which is worth knowing when you decide how far back to reconstruct; our note on how lenders verify bank statements covers what they look at.

Does Frost charge for the QuickBooks connection?

Frost includes Direct Connect for connecting Quicken and QuickBooks, which is not a given anymore. Several banks now bill for it: Comerica prices its QuickBooks connection at $10.95 a month, and others have added fees or dropped the method entirely. Fees and availability change and vary by account, so confirm the current terms with Frost before you rely on the feed. If you want the full picture of who charges and who is retiring the connection, see which banks charge for QuickBooks Direct Connect.

Last updated July 2026. Bank connection methods, history windows, and fees change; confirm current details with Frost Bank.