QuickBooks® WebConnect

Quickbooks logoQuickbooks Web Connect is, simply put, a way you can download your business account transactions directly from Online Banking or Corporate Cash Management and import them into QuickBooks. This technology downloads up to 18 months of account data into your check register and matches any transaction you’ve already entered into your register.

Regent Bank is listed in the Financial Institution Directory as Regent Bank Online.

***View/Export up to 18 Months of Account Transactions***

With Online Banking or Corporate Cash Management you have full access to view and/or export up to 18 months of your account history to financial management tools such as QuickBooks®, QuickenTM, Microsoft® Money or Microsoft® Excel.  You can also access up to 24 months of your fully imaged account statements.

Online Banking Clients: To View and/or Export up to 18 months of account history – Log In and choose an account for which you would like to receive transaction activity. Click All Transactions from the Transactions menu. Select the From date and the To date of the data you would like to view/export. Click on View Transactions to see to see transaction history complete with images of checks and deposit tickets or click Export Transactions to export account history to QuickBooks (.IIF, .QBO).  Then follow the directions below based on your software type.

Corporate Cash Management Clients: To View and/or Export up to 18 months of account history – Log In and choose an account for which you would like to receive transaction activity.  From the Transactions box, click Transaction Archive.  Select the From date and the To date of the data you would like to view/export. Click on View Transactions to see transaction history complete with images of checks and deposit tickets or click Export Transactions to export account history to QuickBooks (.IIF, .QBO). Then follow the directions below based on your software type.

Windows:

  1. A Windows dialog may appear that asks whether you would like to Save or Open the file, select Open.
  2. If this is your first time downloading with Web Connect for this account, a dialog box will appear stating “You are about to download transactions for the following account.” The box will include account information, such as the Account Number and Account Type.
  3. You will be asked whether you would like to “Use an existing QuickBooks account” or if you would like to “Create a new QuickBooks account.”
    • Use an existing QuickBooks account:
      If you already have the account set-up in QuickBooks, and you would like to add on to the existing transaction activity, you should select this option.
    • Create a new QuickBooks account:
      If you have not set-up this account in QuickBooks, or if you would like to start a new file for an existing account, you should select this option. After selecting this option, follow the steps for setting up the new account. You will receive all transactions that fall within the From and To dates you selected in Step 2.
  4. When QuickBooks confirms that the Web Connect data has been successfully downloaded to QuickBooks, select O.K.
  5. Repeat these steps for each account you would like to download into QuickBooks.

Mac:

  1. File is automatically downloaded to your “downloads or desktop”.
  2. You can double click on the .qbo file or go to the File menu in QuickBooks, select “Import from Web Connect Files“, double click on the .qbo file located in your desktop or downloads. This will import the transactions into your register.
  3. Repeat these steps for each account you would like to download into QuickBooks.

QuickBooks and Quicken are registered trademarks of Intuit Inc. Microsoft Money and Microsoft Excel are registered trademarks of Microsoft Corporation.