q 1. QBLink-it Login - Add one or more names and Passwords to access QBLink-it. The Default name is "ADMIN" and the password is blank.

q 2. To Add, Edit or Remove users click on the  button.

a. Click on the  button to add additional users. Then enter the Name and Password.

b. Highlight a user and then click on the  button to make changes to an existing user.

c. Highlight a user and then click on the  button to remove an existing user.

  

2. QBLink-it SQL Database Login - QBLink-it uses an SQL database to store the data imported Encompass before it is Exported into QuickBooks. You can setup your own SQL database or if you do not have SQL you can add tables to the Encompass Database. If you are going to add tables you will need to know the login information. The Encompass login default is showen below in the picture. You will need to know your Encompass database password in order to create the tables. If you do not know it you can contact Ellie Mae tech support and request it.

After you have entered the login information click on the  button to create or update the Tables.

q 3. Encompass Login - Enter an Encompass Admin login and server name. QBLink-it uses the same hierarchy as Encompass so using an ADMIN login will assure that all loan files will be accessible. 

After you have entered the login information click on the  button. If you get an error open the \DMCC\QBLINKIT folder and run the "CreateConfig.exe", then try again.

q 4. TPI Program Path - Click on the  button and locate the TPI program file. The Default location is \program files\01 Transaction Pro Importer 3.0\ folder. When the TPI version is changed make sure to change this path. 

q 5.  button - TPI will create a Log file each time a posting is processed. if you would like to view a log file just click on this button and select the Log. If you would like to export the log information into Excel just click on the "Use Excel;" button on the bottom of the window. 

q 6.   button - The Log files from TPI will be saved in the "\DMCC\QBLinkit\TPI LOG Files" folder. If you would like to Delete the LOG files click on this button.

q 7.  - This box should always be check unless you only want to add data to the QBLink-it database without positing it to QuickBooks.

q 8. QuickBooks Account to use as a Clearing Account" - When posting General Journals, if the Total Credits and Total Debts do not balance the difference will be added to a "Clearing Account" in QuickBooks. Create an Account in QuickBooks and add the same name in this box. 

q 9. REF NO. - Enter the starting Numbers for General Journal, Bills, Invoices or Deposit Posting - Each time a posting is started, QBLink-it will create a unique REF NO. for each loan file.

QBLink-it comes with one of the QuickBooks Transactions Types unless more than one of the Transaction Types have been purchased. If you would like to order additional Transaction Type options please contact us. The options are: 1) Bills; 2) Invoices (including Credit Card Information) and 3) Deposits. These options can be added at anytime buy contacting us at: mike@delmarcc.com or calling 858-485-6842.