EvoQ Install & Use Instructions


Important: The EvoQ application will only export Evolution data to QuickBooks 2004 and later client versions.

QuickBooks must be open on the computer where EvoQ is running. In addition, the company that will receive the import data must be selected in QuickBooks, otherwise import will fail.

The Evolution QuickBooks interface provides two distinct capabilities of exporting Evolution data into QuickBooks. They are:

Important: The optimal interface with QuickBooks by the EvoQ application is when Account Numbers are assigned to accounts in QuickBooks – to setup Account Numbers, please consult your Accountant for direction (see the below links to QuickBooks support).

http://support.quickbooks.intuit.com/support/Articles/HOW13386

http://support.quickbooks.intuit.com/support/pages/inproducthelp/core/qb2k12/contentpackage/core/chart_of_accounts/task_account_number.html

EvoQ Installation

  1. Please browse to http://www.paydayhcm.com/ 
  2. Click the “Clients” button at the top of the page
  3. Click the “Secure Transfer / Download Files” bullet point
  4. Click the “Download Files” option – this link opens http://www.paydayhcm.com/clientdownloads.php
  5. Click the “EvoQ” bullet point
  6. Click the EvoQ-x-x-x-x.msi.zip link and save
  7. Unzip the contents to obtain the EvoQ setup files:
  1. EvoQ_x.x.x.x.msi
  2. qbsdk130.exe
  1. (or for versions prior to QuickBooks 2013, QBFC7_0Installer.exe)
  1. QBXMLRP2Installer.exe (additional SDK files for QuickBooks 2004-2005)
  1. Double-click the EvoQ_x.x.x.x.msi file and accept the defaults to install the utility
  1. You must manually select (double-click) the .exe to install the client library after the EvoQ installation finishes:
  1. qbsdk130.exe (for QuickBooks 2013 version)
  2. QBFC7_0Installer.exe (for versions prior to QuickBooks 2013)
  1. Note3: for QuickBooks 2004-2005 you will need to install QBXMLRP2Installer.exe file after EvoQ installation is done
  1. Double-click the Evolution QB Export icon on the desktop (or, navigate in Windows 7 to launch the utility: Start / <type> Evolution QB Export)

Note: QuickBooks needs to be open and will prompt to grant permission to Evolution QB Export to make changes to QuickBooks company; if using “multi-user” mode, change to “single-user” mode

  1. From the Connection Settings tab, enter the following values: (Example 1a)

Note: select the question button,, to display additional help information. (Example 1b)

API adapter address: evo.paydayhcm.com 

Evolution Username: Evolution/EvoQ userid – provided by Payday 

Evolution Password: Evolution/EvoQ password – provided by Payday 

Save password checkbox: check to save password for future logins

Example 1a –Connection Settings

Example 1b – Help Information

Important: QuickBooks must be open on the computer where EvoQ is running. In addition, the company that will receive the import data must be selected in QuickBooks, otherwise import will fail.

Export Evolution GL to QuickBooks

Parsing the GL Tag field of GL Export

The GL Tag must contain either the Account Numbers or Account Full Names depending on the Treat Evolution GL Tags as setting (Example 2). If an account is a subaccount of another account, its full name appears as ParentAccountName:SubAccountName. The account hierarchy may have more than two levels and full names would appear as GrandParentAccountName:ParentAccountName:SubAccountName, depending on the number of levels.

The Assign Class option allows the user to export a QuickBooks Class field and to define the Delimiter that distinguishes the Class and Account. In this instance, the Evolution GL tags must be formatted as follows:

<class>< delimiter ><account>

where <account> is an account number or account full name and <class> is a class full name.

If a class is a subclass of another class, its full name would appear as:

ParentClassName:ClassName OR

GrandParentClassName:ParentClassName:ClassName or longer, depending on the number of levels in the class hierarchy.

Example:

BR20:DP20-DT5 is an example of the Evolution GL Tag format string that generates GL tags in the form of <ParentClass>:<Class>-<Account>.

For importing the GL tags, the user should check the Assign Class checkbox and set the delimiter to

-.

Export/Import

Navigate to the GL Export tab and select one of the following options: (Example 3a or 3b)

Direct Connection: permits the creation of a QuickBooks GL export directly from Evolution.

Example 2 – Evolution GL Tags

Note1: Select the Clear check box to set the transaction status in QuickBooks to clear.

Note2: Once processing has completed, the Print Journal and Print Log buttons become active.


Example 3a – GL Export Tab – Direct Connection

File: permits the creation of a QuickBooks GL export directly from a fixed length text file, saved with a .txt extension, or a .csv file.

Note: The txt or csv export file can be created by running the Evolution General Ledger Rapid Export (S348) report. The report must be run by the Service Bureau on an Evolution client that does not have EvoRemote installed in their environment.

Note1: Select the Clear check box to set the transaction status in QuickBooks to clear.

Note2: Once processing has completed, the Print Journal and Print Log buttons become active.

Example 3b – GL Export Tab – File

Example 4 – Processing Message Box

Note: once the Log tab is selected, select the error message to view details of the error message.

Export Evolution Payrolls to QuickBooks

Important: QuickBooks must be open on the computer where EvoQ is running. In addition, the company that will receive the import data must be selected in QuickBooks, otherwise the import will fail.

Direct Connection: permits the creation of a QuickBooks check export directly from Evolution.

Note: once processing has completed, the Print Checks and Print Log buttons become active.

Example 5 – Check Export Options



Example 6a – Check Export Tab – Direct Connection

Example 6b – Check Export Tab – File

File: permits the creation of a QuickBooks check export directly from a fixed length text file, saved with a .txt extension, or a .csv file. (Example 8)

Note: A csv export file can be created by running the Evolution EvChecks EE Export (S1910) or the Evolution EvChecks Agency Export (S1911) report. The reports must be run by the Service Bureau on an Evolution client that does not have EvoRemote installed in their environment.

Note: once processing has completed, the Print Checks and Print Log buttons become active.

Example 7 – Check Export Options

Example 8 – Check Export Tab – File

View the Log File

The Log file is viewed by selecting the Log tab.

To view details of a message contained in the Log, select the message and view the content in the Details and Context section of the log.

Send debug log by e-mail button: select this option to create an email message which attaches the log file to the email. The email will be sent, with AES encryption, to Andrei Babyuk of iSystems for further analysis of the error.

Pack debug log and open folder button: select this option to compress the log file and save to a To Send subdirectory, with AES encryption, underneath the location of the respective iSystems utility being run for later analysis of the log file.

Note: Packed Log files are located in the following locations of the user’s computer:

Example 9 – Log Tab

        9/11/14 - Payday