Convert Zions Bank CSV to QuickBooks (.QBO)
Works with Zions Bank CSV and Excel exports Nothing uploaded
Zions Bank (part of Zions Bancorporation, serving Utah, Idaho, and Wyoming) does offer a QuickBooks Web Connect (.qbo) download for many accounts. When that file imports cleanly, you can skip this page. The trouble is that Zions is also well known for QuickBooks error 102, where the bank feed or the .qbo connection fails and no transactions come through.
When error 102 hits, or when a particular account only gives you a CSV, you still have a reliable path: download the transactions as CSV (Excel) from Zions online banking and convert them. The CSV route does not depend on the live connection that error 102 breaks, so it keeps working while you wait for Zions and Intuit to sort out the feed.
QBO Maker reads your Zions CSV (or Excel file) and produces a valid .QBO in your browser. Nothing is uploaded. Map the date, description, and amount columns, download the .QBO, and import it through Web Connect into QuickBooks Online or Desktop. Start on the converter.
A typical Zions Bank export has columns like Date, Description, Amount, Balance, Check Number, Type and uses MM/DD/YYYY dates. QBO Maker auto-detects these, just confirm the mapping.
How to import Zions Bank statements into QuickBooks
- Export your transactions from Zions Bank online banking as CSV or Excel.
- Open the QBO Maker converter and drop the file in.
- Confirm the auto-detected date, amount (or separate debit/credit) and description columns.
- Choose .QBO as the output and click download.
- In QuickBooks Online: Transactions → Bank transactions → Upload from file, then select the .QBO. In Desktop: Banking → Bank Feeds → Import Web Connect File.
Zions Bank-specific things to watch for
- Zions is associated with QuickBooks error 102, a connection failure on the bank feed or native .qbo. Converting a CSV sidesteps it because no live connection is needed.
- Some Zions accounts export amounts as one signed column; others split debit and credit. Check your file and map accordingly on the conversion screen.
- Sister banks under Zions Bancorporation (for example California Bank & Trust or Amegy) use similar export layouts, so the same mapping usually applies.
- Pending transactions can appear in the export. Convert only posted rows to keep your QuickBooks register matching the statement.
QuickBooks Online vs Desktop
QuickBooks Online: Transactions → Bank transactions → Upload from file → choose your .QBO. QuickBooks Desktop: Banking → Bank Feeds → Import Web Connect File. Desktop is stricter about the bank ID, Zions Bank's routing number is often 124000054, which we prefill when you open the converter from this page.
Frequently asked questions
I keep getting error 102 with Zions Bank in QuickBooks. Does this help?
Yes. Error 102 is a connection problem between QuickBooks and the bank. The CSV-to-QBO route does not use that connection. Download your Zions transactions as a CSV, convert them with QBO Maker, and import the .QBO manually. Your books stay current while the feed is down.
Zions already offers a .QBO download. Why use the CSV?
If the native .qbo imports cleanly, use it. Many Zions customers find it fails (error 102 or an empty result), or a specific account only offers CSV. In those cases the CSV plus QBO Maker is the dependable fallback.
Does this work for other Zions Bancorporation banks?
Generally yes. Banks like California Bank & Trust, Amegy Bank, and Nevada State Bank use comparable export formats. Map the date, description, and amount columns the same way and convert.
Is my data uploaded?
No. The conversion is 100% client-side in your browser. Your Zions transaction file never leaves your computer.
Convert your Zions Bank statement now
Free, in your browser, nothing uploaded. We will prefill the Zions Bank routing number for you.
Open the converter