background image

QuickBooks Desktop Information For Business Online Banking Transition

As Royal Credit Union completes its system conversion, you will need to modify your QuickBooks settings to ensure that your data connectivity transfers smoothly to the new system. This page contains instructions for using the Web Connect connectivity type on Windows or Mac. Select a link below to go to the information you need:

QuickBooks Windows Web Connect
QuickBooks Mac Web Connect

Instructions For Downloading A Web Connect File From Royal Credit Union Business Online Banking

QuickBooks Windows Web Connect

On Or Before October 26:

Note: these actions can be completed at any time on or before October 26 when it is convenient for you. Once you reconnect to your accounts after the conversion, transactions prior to the conversion date will import normally.

  • Backup QuickBooks Windows Data File & Update.
    • Choose File > Back Up Company > Create Local Backup.
    • Download the latest QuickBooks Update. Choose Help > Update QuickBooks Desktop.
  • Complete a final transaction download and match downloaded transactions.
    • Complete one last transaction update before the change to get all of your transaction history up to date.
    • Accept all new transactions into the appropriate registers. (required)

On Or After October 27:

  • Deactivate online banking connection for Royal Credit Union business accounts.
    • Choose Lists menu > Chart of Accounts.
    • Right-click the first account you want to deactivate and choose Edit Account. You will need to accept all new transactions into the appropriate registers prior to deactivating to avoid receiving an error message.
    • Click the Bank Feeds Settings tab in the Edit Account window.
    • Select Deactivate All Online Services and click Save & Close.
    • Click OK for any alerts or messages that may appear with the deactivation.
    • Repeat steps for any additional accounts that you need to deactivate.
  • Reconnect online banking connection for accounts that you deactivated.
    • Log in to Royal Credit Union's online banking site and download your transactions to a QuickBooks (.qbo) file.
      • You can download your transactions from the account summary page in Royal Credit Union business online banking by choosing the Export option and selecting your desired file type.
      • Note: Take note of your last successful upload. Duplicate transactions can occur if you have overlapping transaction dates in the new transaction download.
    • In QuickBooks, choose File > Utilities > Import > Web Connect Files. Locate your saved Web Connect file and select to import.
    • In the Select Bank Account dialog select Use an existing QuickBooks account.
      • Important: Do NOT select “Create a new QuickBooks account” unless you intend to add a new account to QuickBooks.
    • In the drop-down list, choose your QuickBooks account(s) and click Continue. Confirm by selecting OK.

QuickBooks Mac Web Connect

On Or Before October 26:

Note: these actions can be completed at any time on or before October 26 when it is convenient for you. Once you reconnect to your accounts after the conversion, transactions prior to the conversion date will import normally.

  • Backup your QuickBooks Mac data file & update the application.
    • Choose File > Backup.
    • Download the latest QuickBooks Update. Choose QuickBooks > Check for QuickBooks Updates.
  • Complete a final transaction download.
    • Complete last transaction update before the change to get all of your transaction history up to date.
    • Repeat this step for each account you need to update.
    • Accept all new transactions into the appropriate registers. (required)

On Or After October 27:

  • Deactivate online banking connection for Royal Credit Union business accounts.
    • Choose Lists > Chart of Accounts.
    • Select the first account you would like to deactivate and choose Edit > Edit Account.
    • Select Online Settings in the Edit Account window.
    • In the Online Account Information window, choose Not Enabled from the Download Transactions list and click Save.
    • Click OK for any dialog boxes that may appear with the deactivation.
    • Repeat steps for any additional accounts that apply.
  • Reconnect online banking connection for accounts that apply.
    • Log in to Royal Credit Union's online banking site and download your transactions into to a QuickBooks (.qbo) file.
      • You can download your transactions from the account summary page in Royal Credit Union business online banking by choosing the Export option and selecting your desired file type.
      • Important: Take note of your last successful upload. Duplicate transactions can occur if you have overlapping transaction dates in the new transaction download.
    • In QuickBooks, choose File > Import > From Web Connect. Use the import dialog to import your saved Web Connect file.
    • In the Account Association window, click Select an Account to choose the appropriate existing account register.
      • Important: Do NOT select “NEW” under the action column unless you intend to add a new account to QuickBooks.
    • Click Continue and for any dialog boxes that require action.