QuickBooks Desktop Conversion Instructions

As we complete our online banking conversion, you will need to modify your QuickBooks settings to ensure that your data connectivity transfers smoothly to the new platform.

QuickBooks Windows Web Connect

Before November 13, 2020:

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

Prior to downloading your transactions, we recommend you execute a filter and select the time frame for the data that you wish to download. If you require assistance, please reach out to our Customer Experience Team at (877) 820-2265.

On or After November 18, 2020:

1. Deactivate online banking connection for accounts connected to Macatawa Bank.
   1. Choose Lists menu > Chart of Accounts.
   2. Right-click the first account you want to deactivate and choose Edit Account.
   3. Click the Bank Feeds Settings tab in the Edit Account window.
   4. Select Deactivate All Online Services and click Save & Close.
   5. Click OK for any alerts or messages that may appear with the deactivation.
   6. Repeat steps for any additional accounts that you need to deactivate.
2. Reconnect online banking connection for accounts that you deactivated.
   1. Log in to Macatawa Bank’s online banking site and download your transactions to a QuickBooks (.qbo) file. Note: 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.
      
      Important: 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

Before November 13, 2020:

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

Prior to downloading your transactions, we recommend you execute a filter and select the time frame for the data that you wish to download. If you require assistance, please reach out to our Customer Experience Team at (877) 820-2265.

On or After November 18, 2020:

1. Deactivate online banking connection for accounts connected to Macatawa Bank.
   1. Choose Lists > Chart of Accounts.
   2. Select the first account you would like to deactivate and choose Edit > Edit Account.
   3. Select 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 dialog boxes that may appear with the deactivation.
   6. Repeat steps for any additional accounts that apply.
2. Reconnect online banking connection for accounts that apply.
   1. Log in to Macatawa Bank’s online banking site and download your transactions into to a QuickBooks (.qbo) file.
      
      Important: 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.
      
      Important: 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.