Overview Tour
For QuickBooks®
The Translator Tool is available when you need assistance retrieving your check issuance information from QuickBooks®. Once created, the file is uploaded via KeyNavigator to be used with Account Reconciliation services (ARP) and with Positive Pay.
Installing Translator Tool
You must login as an Administrator (or user with Administrator rights). To access the translator tool, click on the 'gear' icon in the Quicklinks segment of the Dashboard.
Installing Translator Tool
On the Customize Your Quicklinks modal window, scroll down to the Specialized Services segment and select File Translator. Then select the Done button.
Installing Translator Tool
Now you will see File Translator appear under the Quicklinks segment on the Dashboard. Select the File Translator quicklink.
Installing Translator Tool
Select the Download button to launch the Save As or Run box. You can choose either.
Installing Translator Tool
The installation welcome screen appears. Select Next to continue.
Installing Translator Tool
Follow the instructions in the Automated Business Banking Setup Wizard and subsequent modal windows. For detailed instructions, please reference the Translator Tool User Guide.
Using Translator Tool
Double click on the Key File Translator shortcut on your desktop to launch the tool. Enter your User ID and Password.
Using Translator Tool
At the main page, select the arrow next to File Translator to expand the menu. Then select Register Setup to view the accounts setup in the ARP Translator Tool. You can assign starting and ending check numbers in your initial file.
Using Translator Tool
Select Retrieve Check Issue Data to import checks from the QuickBooks® Check Register. Choose the account to import data from, using the dropdown menu. Select Retrieve Check Issue Data at the bottom when ready.
Using Translator Tool
The Retrieval Validation Results page displays all data pulled 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. Selecting 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, select Accept Checks and the number of checks that have been accepted will be displayed.
Using Translator Tool
The Create Bank File page displays the file that will be exported. Select Browse at the bottom to choose a location to save the file.
Using Translator Tool
Select Export at the bottom to create the file in Key's format. A window will be displayed with File Created followed by the name of the file. Select OK to go back to the ARP File Translator page. The exported file is ready to be sent to Key.
