KeyTotalTreasury logo
Online Help

Translator Tool for QuickBooks®

2.1 Installing the Translator Tool

  1. Log into QuickBooks as the Administrator (or user with administrator rights).
  2. Log into KeyNavigator, and click on the Gear icon in the Quicklinks section on the left side of the screen.

    KeyNavigator dashboard

  3. On the Customize Your Quicklinks screen, scroll down to the Specialized Services section and select File Translator. Then click Done.

    Customize Your Quicklinks

  4. Now you will see File Translator appear under the Quicklinks section. click the File Translator link.

    File Translator

  5. Click the Download button to launch the Save As or Run box. You can choose either.

    Download File Translator

  6. The installation welcome screen appears. Click Next to continue or Cancel to stop the install.

    File Translator installation

  7. The End-User License Agreement screen provides the option to accept or not accept the terms in the license agreement. If you do not accept the terms, the install process will halt, and the system will not be installed.

    End-User License Agreement

  8. Select the I accept the terms in the License Agreement option.
  9. Click Next to continue.
  10. The Ready To Install screen provides you with the opportunity to click Back to review your settings. Click Install to continue. You may click Cancel to halt the installation.

    Ready to Install

  11. A status screen allows you to monitor the installation progress.

    installtion status screen

  12. The system displays a screen notifying you that the installation is complete.

    installation complete screen

  13. The following screen is where you can establish a password for the admin user. This can be changed at a later date if the user wishes.

    The password must be 8-12 characters long and contain at least 2 numerical digits.

    establish admin password

  14. Next, choose either Payee Positive Pay or Standard Positive Pay.

    This cannot be changed without uninstalling or reinstalling the Translator Tool.

    disbursement solution type

    Choose the first option Retrieve the data directly from an account system: QuickBooks and click Next.

    select check issue service

  15. Click on Request Access. The system will ask if you want to allow the ARP Translator Tool to access QuickBooks, even if QuickBooks is not running. Click Yes and Continue. This will put a certificate into QuickBooks that will allow the ARP Translator Tool access to the check register even if QuickBooks is not running.

    connect to QuickBooks

    QuickBooks certificate

  16. You will be prompted to select a user to access QuickBooks, choose the user that has admin rights (most likely the person who is installing the tool.) An Access Confirmation window will open confirming that the changes were made. Click Done to proceed.

    select user access

  17. Once this is complete the following screen will appear with the Company File Location. Click Next.

    Company File Location

  18. Enter in the bank account number that corresponds to the account(s) to which Positive Pay service is being added. Click Next.

    You do not need to enter information for accounts not being added to Positive Pay.

    bank account setup

  19. Next choose Export as the File Delivery Method and click Next.

    File Delivery Method

  20. Now the File Translator Set-up is Complete. Click Finish.

    Key File Translator login

  21. At the main page, click on the arrow next to File Translator to collapse the menu.
  22. Now choose the Register Setup to view the accounts set-up in the ARP Translator Tool. If you want you can assign starting and ending check numbers here.

    Register Setup

  23. Click on Retrieve Check Issue Data to import checks from the QuickBooks Check Register. You can choose the account to import data from, using the drop down menu. Also shown is the last retrieval date/time for each account. Click on Retrieve Check Issue Data at the bottom when ready.

    Retrieve Check Issue Data

  24. Once the data is pulled, the Retrieval Validation Results screen will display all the data that has been pulled in from QuickBooks. At the top is a summary of valid and invalid checks, as well as a file total in dollars and number of checks. Clicking on the Reject Checks button at the bottom will remove the records from the Translator Tool and you can import the data again when ready. This is helpful if you need to narrow down the check range. When ready, choose Accept Checks and the number of checks that have been accepted will be displayed.

    Once data has been accepted into the tool it cannot be deleted without uninstalling and reinstalling the tool.

    Retrieval Validation Results

  25. The Create Bank File screen displays everything that has been accepted into the tool and will be exported in the file. Click on Browse at the bottom to choose a location to save the file.

    This is the file that will be sent to Key and a file extension is NOT required. It is recommended that the file include a Date as part of the file name. Once you have entered a name click OK.

    Create Bank File screen

  26. After a location and name have been chosen, click on Export at the bottom to create the file in Key’s format. A window will display with File Created followed by the name of the file. Click OK to go back to the ARP File Translator screen. The Positive Pay file that was exported is ready to be sent to Key.

    Create Bank File screen

2.3 Troubleshooting

Q: What if I forgot my password and I am locked out?

There are four user IDs available in the translator tool:

  • Admin
  • User1
  • User2
  • User3

When you install the Translator Tool on your computer, you are prompted to set a password for the admin ID. If you forget your admin ID, password, or get locked out, you log on from another ID to reset your admin password.

Steps to reset your password for the admin user ID

  1. Log on to the Key File Translator tool under a different ID.
  2. Enter the password. If this is the first time using this ID, the password will be the same as the user ID.
  3. Click the Log-on button.

    Key File Translator login

  4. You will be prompt to create another password for this ID.

    Key File Translator change password

  5. Select Setup & Preferences.

    Setup & Preferences

  6. Under Passwords tab, the user ID should be admin.
  7. Enter a new password for your admin ID.
  8. Click the Reset button.
  9. You will see a message Password has been updated.
  10. Click the Close button.
Q: If I upgrade or reinstall Quickbooks, how do I set up the Translator Tool?
  1. You can set up the tool to work with your new company profile without uninstalling and reinstalling.
  2. Make sure you are logged into Quickbooks as the Admin in single user mode.
  3. Log into the translator tool, click on Setup & Preferences on the left hand side, then the Accounting System Integration tab.

    Accounting System Integration

  4. Click on Remove Settings to delete the mapping to the old company profile. You will receive a pop up asking you to confirm the changes, click Yes to continue.

     Remove Settings

  5. Now that the old mapping is removed, click on Setup.

    Setup & Preferences

  6. Click Next on the first pop up box.

    Setup & Preferences

  7. Then click on Request Access.

    Request Access

  8. A certificate will pop up and you need to click the second radial button Yes, always allow access even if Quickbooks is not running then Continue.

    QuickBooks certificate

  9. This is your confirmation that the settings have been applied successfully. Click Done.

    access confirmation

  10. You can click on the Accounting System Integration tab again to confirm the company file location is correct.

    If this is not correct then sign into the correct company profile and repeat the steps above.

  11. Now you must assign the correct check register to the account along with check numbers. Double click File Translator in bold on the left to expand the menu then Register Setup.

    File Translator Register Setup

  12. At the bottom click Update Check Register List then choose the appropriate check register name from the drop down list that corresponds to that account number.

    Update Check Register List

  13. Assign a starting and ending check number by double clicking in the text box.

    You can use 1 and 9999999999 as starting and ending.

  14. Click Apply Settings at the bottom then Retrieve Check Issue Data and proceed as normal.

    apply settings