Importing General Ledger Entries from a Tax Filing Interface (TFI)

  1. An import Security Feature must be selected for the GL Adjusting Journal Entries screen (in Group Security) to enable use of a Tax Filing Interface, such as Paychex or ADP.
    2. Section Item Value
    GLEntriesAdjusting Paychex Yes
    GLEntriesAdjusting ADP Yes
  2. Copy the file from the TFI into a temp directory. You can use the attached template for importing your txt file. Right click and choose "Save As..." (or "Save Target as...") to download a file, RAPID PC sample file or ADP sample file.
  3. From the General Ledger menu, select Adjusting Journal Entries.
  4. Fill in the Date, Journal ID, your initials, Reference, Journal Type (you may want to add RapidPC (ADP) Import) and Notes.
  5. Click the Import Details button. Specify the drive and file name of the RapidPC or ADP file and then click Open. If there are records with invalid data, the system displays each record where errors exist.
  6. The system displays a message when the files are finished importing. Click OK and the adjusting entries table will populate with all the valid entries from this file. You may edit these entries if necessary. In order for the update to be successful the amount left must be $0.00.
  7. Click the General Ledger icon from the GL Main Menu to display the Adjusting Entries General Ledger Update screen.
  8. Click Update to start the General Ledger update, without printing the Adjusting Entries To Post report. Click Update/Print to update Adjusting Entries to the General Ledger and print the Adjusting Entries To Post report. The GL Posting Status dialog box displays to confirm that the debits and credits match. Click Cancel if the update does not balance. Click Commit if the update balances.
  9. By default, the timer in the title bar starts with 8 seconds, after which the commit automatically takes place. A message displays stating that posting was successful. The update can be canceled during those eight seconds.
  10. The eight-second default value can be changed using this Custom Setting:
    11. Section Item Value Module and Purpose
    GLUpdate AutoPostTime # (in seconds) This setting determines how many seconds the system will wait before it will commit a General Ledger update. The default is 8 seconds. If you set a negative Value, the next time you post, the system will display an option to tell WinTeam Don't show this message again. If you select this option and Commit, going forward, the system will automatically post and close the Posting Status box, providing there are no errors.

    For more information see Custom Settings and List of Custom Settings.