The QuickBooks integration allows for cross communication between Alvys TMS and the QuickBooks software, where transactions are sent directly from Alvys to QuickBooks and vice versa.
Pre-requisites
In order to successfully complete the QuickBooks Desktop integration, the following is required of the tenant prior to starting the integration:
QuickBooks Desktop and QuickBooks Web Connector installed on the computer
An existing QuickBooks Desktop account (company file)
An Admin user login credentials for said QuickBooks Desktop account
Tenant’s Chart of Accounts created in QuickBooks
The integration is best done by an accounting user in the tenant's organization because they will need knowledge of the company's Chart of Accounts in order to map the accounts to the various type of transactions within the Alvys TMS.
Setup
Navigate to the Management Page https://app.alvys.com/#/manage/company-profile
Select the Integrations tab
Select Accounting in the list of Integration types
Click on the ✏ icon on the QuickBooks Desktop option to open the dialog box
Select the Subsidiary you wish to add the integration to and click Save
Click on the QuickBooks link and the QuickBooks Download webpage will open in a new tab. The user will have to answer a few questions and enter account information prior to downloading the QuickBooks Desktop client.
Download and install the QuickBooks Connector. This is how the Alvys TMS and the QuickBooks Desktop client will send and receive the various transactions.
Sometimes the QuickBooks Connector is automatically installed when installing the QuickBooks Desktop client.
Open QuickBooks Desktop client. Select the Company Name that you would like to integrate with Alvys.
If there is only one company, it is automatically selected and the user is moved to the login screen.
Next, you will be prompted to enter your admin login credentials.
Navigate back to Alvys to continue the integration. Download the QWC file and save it in a known location.
Open the QuickBooks Desktop client. Select File > App Management > Update Web Services.
This opens up the Web Connector. Click Add an Application. This opens another window, navigate to the location of and select the QWC file downloaded in Step 10 and click Open.
Adding the application takes a while to be completed. Please do not close the application while the process is running. Once the process is completed, a new popup will appear to Authorize New Web Service.
Once the process is complete, a new popup will appear to Authorize New Web Service. Select OK.
Select one of the options from “Do you want to allow this application to read and modify this company file?”. Click the checkbox and then Continue.
Yes, prompt each time: whenever a transaction is being sent from Alvys, a prompt will appear in the QuickBooks client which would need to be approved. Yes, whenever this QuickBooks company file is open: transactions will only be sent from Alvys when the QuickBooks client is open. Yes, always; allow access even if QuickBooks is not running (Recommended): transactions will be sent to QuickBooks once triggered in Alvys as long as the computer is on. Transactions not processed are in a queue until the computer is turned on. However, they will only remain in the queue for seven (7) days, after which they would need to be triggered again from Alvys to be processed. If the last option is selected, a confirmation screen will appear after which a user will have to be selected from the Login as dropdown menu.
Important: Select Yes, always; allow access even if QuickBooks is not running
Click Done. The Company will appear in the QuickBooks Web Connector window (Step 12). Select the Company/Application and you will be prompted to enter a password. Navigate back to Alvys to get the password (Step 5). Click OK after entering the password.
Select Auto-Run and adjust the Every-Min interval if needed. Every-Min is the interval at which the queue will be read to update QuickBooks with the transactions from Alvys.
Click Update Selected and wait for the process to complete.
Navigate to Alvys, refresh the page and proceed to completing the Account Settings (see next section).
Account Settings
The QuickBooks Desktop integration allows for generic and very detailed configuration of which transactions are sent to QuickBooks, how they are sent and to which accounts.
Select the account type(s) that you wish to map for. Then click Next.