By following this link, you will be leaving UmpquaBank.com. Click Ok to continue or Cancel to remain in UmpquaBank.com

Quicken and QuickBooks—Online Banking Transaction Export Tips

You can export your Personal and Business account transactions for use in Quicken and QuickBooks. The method used to download transactions from our Online Banking platform depends on which version of QuickBooks you’re using and whether you have a Personal or Business account.

Before you begin: It's always a good idea to make a backup of your Quicken/QuickBooks data file before making any changes. We recommend you do so before following the instructions below.

Export your Personal Banking transactions

To define the exact dates for transactions that can be saved as a .qfx file for Quicken or a .qbo file for QuickBooks:

  1. Log into online banking and select the account with transactions to be downloaded.

  2. After choosing filters, select the date range you would like to download and click apply filters.

    Digital Banking QuickBooks

  3. Select the export icon at the upper right corner to choose the file type to download; XLS, CSV, OFX, QFX or QBO.

    Digital Banking QuickBooks File Type

  4. The output file will be restricted to the range of dates selected.

Export your Business Banking transactions

The method used to download transactions from Business Online Banking (BOB) depends on which version of QuickBooks you’re using: QuickBooks Online or QuickBooks Desktop.

 

QuickBooks Desktop

Web Connect is a one-way (i.e. manual) connection between BOB and Quicken or QuickBooks Desktop. Exported transactions are automatically matched with existing transactions, and new ones are added to the register.

While logged into Online Banking:

  1. Mouse over Reports, then click Activity – deposit accounts (or applicable reporting selection)

  2. On the “Search Deposit Account Activity” page, select the accounts, date range, transaction types and Output to: QuickBooks® file

  3. Make any additional desired selections

  4. Click Generate report

  5. If prompted, click the arrow next to Save, and choose Save as

  6. Save the file to a desired location

  7. Open the exported file

  8. In QuickBooks, choose Import new transactions now and click OK

  9. In the dialog window, you should see “Umpqua-Business” information prefilled. Choose Create a new QuickBooks account and key in the name for that account

  10. Click Continue

  11. Click OK to confirm and continue

  12. Tell QuickBooks how to handle downloaded transactions by clicking Transaction List

  13. Select appropriate action(s) for listed transaction(s)

 

QuickBooks Online

“Express Web Connect” is the automated login process your accounting software uses to retrieve your BOB bank account transaction information. It is known by various names based on the accounting program being used.

“Express Web Connect” (EWC) > Quicken Windows

“Quicken Connect” > Quicken Mac

“Automatic Update” > QuickBooks Online

Express Web Connect automates the BOB login process on your behalf and retrieves account transaction information. During aggregation, Quicken or QuickBooks Online logs in to BOB on your behalf. Generally, this happens once a day.

If you’re using QuickBooks Online, Express Web Connect will update your transactions automatically. QuickBooks Desktop doesn’t support Express Web Connect.

 

Direct Connect

Umpqua does not currently support Direct Connect in BOB. Please use one of the methods outlined above to download transactions.

Questions?
Give us a call at
(866) 486-7782
Mon-Fri, 7am-7pm
Sat-Sun, 8am-5pm
or drop us an email.