Step 6 - Initially Importing your QuickBooks Chart Of Accounts into TeleTracker Online and Activating the QuickBooks Automatic Login Feature for Future Interfaces.

 

EXISTING TELETRACKER ONLINE USERS RECEIVING THE INTIAL QUICKBOOKS UPGRADE ONLY:   In order to ensure that attempts are not made to post one-sided transaction journal entries to your QuickBooks company file, you will notice that any previously empty G/L account fields and/or newly required G/L account fields within TeleTracker Online have been automatically populated with an unfamiliar G/L account number.  These fields have been intentionally populated with account code ‘9999-TELETRACKER SUSPENSE GL CODE’ (or, if your TeleTracker Online chart of accounts already contains this number, TeleTracker Online will automatically decrement this number until it finds the next available, unused number).  When you attempt to initially synchronize your QuickBooks chart of accounts, TeleTracker Online will automatically compare your TeleTracker Online G/L accounts with your QuickBooks chart of accounts and alert the user of any discrepancies.  Therefore, prior to initially importing your QuickBooks chart of accounts, you must create this unfamiliar account ‘9999-TELETRACKER SUSPENSE GL CODE’ within your QuickBooks Company file.  In the unlikely event that your QuickBooks chart of accounts already contains an account number ‘9999’, affected TeleTracker Online transaction journal entries will post to that account, and correction adjustments would have to made manually within QuickBooks.

 

NEW TELETRACKER ONLINE USERS ONLY:  In order to ensure that attempts are not made to post one-sided transaction journal entries to your QuickBooks company file, you will notice that all required G/L account fields within TeleTracker Online have been automatically populated with an unfamiliar G/L account number.  These fields have been intentionally populated with account code ‘9999-TELETRACKER SUSPENSE GL CODE’.  When you attempt to initially synchronize your QuickBooks chart of accounts, TeleTracker Online will automatically compare your TeleTracker Online G/L accounts with your QuickBooks chart of accounts and alert the user of any discrepancies.  Therefore, prior to initially importing your QuickBooks chart of accounts, you must create this unfamiliar account ‘9999-TELETRACKER SUSPENSE GL CODE’ within your QuickBooks Company file.  In the unlikely event that your QuickBooks chart of accounts already contains an account number ‘9999’, affected TeleTracker Online transaction journal entries will post to that account, and correction adjustments would have to made manually within QuickBooks.

 

TeleTracker Online will import your existing chart of accounts from your QuickBooks company file. This process is a one-way exchange of information from QuickBooks to TeleTracker Online. Import your QuickBooks chart of accounts by performing the following steps:

 

  1. Launch QuickBooks and open your company file.

  2. Launch TeleTracker Online and log in.

  3. From the Utilities menu, choose Synchronize QuickBooks.

  4. Verify that you have a current backup of your QuickBooks company file and click the ‘OK’ button in the Synchronize QuickBooks warning box.

  5. Click within the ‘Cutoff Date’ field and select today’s date as the cutoff date.  Note: this field is date sensitive for transactions only.

  6. Click the ‘Clear All’ button.

  7. Click the box to the left of the ‘QuickBooks Chart of Accounts’ data line.

  8. Click the ‘Analyze’ button.  At this point, TeleTracker Online will analyze the corresponding QuickBooks chart of accounts and record the number of new records to import in the ‘# of New Records’ column located on the right-hand side of the screen. 

  9. Answer ‘Yes’ within the ‘Analysis Complete’ message box to print a Batch Audit Report and select your printer.  The Batch Audit Report provides detailed information regarding the data chosen to be synchronized.  Printing this report allows you to maintain an audit trail of each synchronized batch, and also provides an opportunity to review and, if necessary, make changes to your data prior to synchronizing.

  10. After approving the batch, click the ‘Synchronize Now’ button.  Once synchronized, the new records will automatically be imported into your TeleTracker Online General Ledger Accounts.

  11. When TeleTracker Online finishes synchronizing, click the ‘OK’ button in the Synchronizing QuickBooks message box.

  12. Click the ‘OK’ button in the Interfacing with QuickBooks screen.

  13. Once your chart of accounts has been imported, return to QuickBooks and, from the Edit menu, choose Preferences.

  14. In the Preferences window, select ‘Integrated Applications’.

  15. Click on the ‘Company Preferences’ tab and then the ‘Properties’ button.  Select the ‘Allow this application to login automatically’ checkbox and click the ‘OK’ buttons when finished.  Activation of this feature will eliminate the need for your QuickBooks company file to be open during future interfaces.