QuickBooks desktop conversion for Treasury Management customers

As your former bank completes its system conversion to Simmons Bank, you will need to modify your QuickBooks settings to ensure the smooth transition of your data. To complete these instructions, you will need your new online banking login credentials for Simmons Bank Treasury Management.

It is important that you perform the following instructions exactly as described and in the order presented. If you do not, your service may stop functioning properly. This process should take 15–30 minutes.

Click the link below that matches your product and connectivity.

• QuickBooks Windows Direct Connect
• QuickBooks Mac Direct Connect
• QuickBooks Windows Web Connect
• QuickBooks Mac Web Connect
• QuickBooks Windows Bill Pay

 

---

 

QuickBooks Windows Direct Connect

1. Backup QuickBooks Windows Data File & Update.
   1. Choose File > Back Up Company > Create Local Backup.
   2. Download the latest QuickBooks Update. Go to Help > Update QuickBooks Desktop.
2. Deactivate online banking connection for all accounts connected to your previous bank.
   1. Choose Lists menu > Chart of Accounts.
   2. Right-click on the first account you would like to deactivate and choose Edit Account.
   3. Click the Bank Feeds Settings and click Save & Close.
   4. Click OK for any alerts or messages that may appear with the deactivation.
   5. Repeat steps for any additional accounts that apply.
3. Reconnect online banking connection for accounts that apply.
   1. Choose Lists menu > Chart of Accounts.
   2. Right-click on an account you would like to activate and choose Edit Account.
   3. Select Set Up Bank Feeds on the bottom of the popup screen and select Yes in the dialog box that will appear.
   4. Enter Simmons Bank in the search field, choose Simmons Bank – Treasury Management and select Continue.
   5. Enter your online banking login credentials.
   6. Ensure you associate the accounts to the appropriate accounts already listed in QuickBooks. Link to your existing accounts in the drop-down options labeled Select Existing or Create New.
      1. Do NOT select 'Create New Account' unless you intend to add a new account QuickBooks. If you are presented with accounts you do not want to track in this data file, choose Do Not Add to QuickBooks.
   7. After all accounts have been matched, click Next and then click Done.

 

---

 

QuickBooks Mac Direct Connect

1. Backup QuickBooks Windows Data File & Update.
   1. Choose File > Backup.
   2. Download the latest QuickBooks Update. Go to QuickBooks > Check for QuickBooks Updates.
2. Deactivate online banking connection for all accounts connected to your previous bank.
   1. Choose Lists > Chart of Accounts.
   2. Click the first account you would like to deactivate and choose Edit > Edit Account.
   3. Choose Online Settings in the Edit Account window.
   4. In the Online Account Information window, choose Not Enabled from the Download Transactions list and click Save.
   5. Click OK for any alerts or messages that may appear with the deactivation.
   6. Repeat steps for any additional accounts that apply.
3. Reconnect online banking connection for accounts that apply.
   1. Choose Banking > Online Banking Setup.
   2. Type Simmons Bank in the search field and choose Simmons Bank – Treasury Management, then click Next and follow the instructions in the setup screen.
   3. Select Yes, my account has been activated for QuickBooks Online Services in the Online Banking Assistant window. Click Next.
   4. Enter your online banking login credentials.
   5. For each account you wish to download into QuickBooks, click Select and Account to connect to your existing account’s registers.
   6. Click Next, and then click Done.
   7. Repeat this step for each account that you have connected to this institution.

 

---

 

QuickBooks Windows Web Connect

1. Backup QuickBooks Windows Data File & Update.
   1. Choose File > Back Up Company > Create Local Backup.
   2. Download the latest QuickBooks Update. Go to Help > Update QuickBooks Desktop.
2. Deactivate online banking connection for all accounts connected to your previous bank.
   1. Choose Lists menu > Chart of Accounts.
   2. Right-click on the first account you would like to deactivate and choose Edit Account.
   3. Click the Bank Feeds Settings and click Save & Close.
   4. Click OK for any alerts or messages that may appear with the deactivation.
   5. Repeat steps for any additional accounts that apply.
3. Reconnect online banking connection for accounts that apply.
   1. Log in to your Simmons Bank Treasury Management site and download your transactions to a QuickBooks (.qbo) file. This can be found by choosing an account and then the download icon above the transactions listing.
      1. Take note of your last successful upload. Duplicate transactions can occur if you have overlapping transaction dates in the new transaction download.
   2. In QuickBooks, choose File > Utilities > Import > Web Connect Files. Locate your saved Web Connect file and select to import.
   3. In the Select Bank Account dialog select Use an existing QuickBooks account.
      1. Do NOT select Create a new QuickBooks account unless you intend to add a new account to QuickBooks.
   4. In the drop-down list, choose your QuickBooks account(s) and click Continue. Confirm by selecting OK.

 

---

 

QuickBooks Mac Web Connect

1. Backup QuickBooks Windows Data File & Update.
   1. Choose File > Backup.
   2. Download the latest QuickBooks Update. Go to QuickBooks > Check for QuickBooks Updates.
2. Deactivate online banking connection for all accounts connected to your previous bank.
   1. Choose Lists > Chart of Accounts.
   2. Click the first account you would like to deactivate and choose Edit > Edit Account.
   3. Choose Online Settings in the Edit Account window.
   4. In the Online Account Information window, choose Not Enabled from the Download Transactions list and click Save.
   5. Click OK for any alerts or messages that may appear with the deactivation.
   6. Repeat steps for any additional accounts that apply.
3. Reconnect online banking connection for accounts that apply.
   1. Log in to your Simmons Bank Treasury Management site and download your transactions to a QuickBooks (.qbo) file. This can be found by choosing an account and then the download icon above the transactions listing.
      1. Take note of your last successful upload. Duplicate transactions can occur if you have overlapping transaction dates in the new transaction download.
   2. In QuickBooks, choose File > Import > From Web Connect. Use the import dialog to import your saved Web Connect file.
   3. In the Account Association window, click Select an Account to choose the appropriate existing account register.
      1. Do NOT select “NEW” under the action column unless you intend to add a new account to QuickBooks.
   4. Click Continue and OK for any dialog boxes that require action.

 

---

 

QuickBooks Windows Bill Pay

Only complete these tasks if you currently initiate Bill Payments from within QuickBooks Windows.

1. Cancel Existing Bill Payments.
   1. Open the Register of the account you made the payment from.
   2. Choose Company > Chart of Accounts.
   3. Double-click the proper account.
   4. In the register, locate the transaction to be canceled.
   5. Click the transaction to be deleted.
   6. Choose Edit > Cancel Payment.
2. Re-create Your Bill Payments.
   1. If you need help re-creating payments, choose Help > QuickBooks Help. Search for Pay a Vendor Online and follow the instructions.