EasyPay Payroll Interface
If you are interested in licensing this additional module, please contact Spectra Marketing.
To setup the General Ledger for EasyPay Import:
1. Set up a Company for each Bank you use to issue payroll cheques.
2. Set up departments in EasyPay to correspond to SPECTRA department/ building ID numbers (maximum of 6 characters). If new departments set up in SPECTRA have more than 6 characters they will have to be cross-referenced. The interface will allow you to match general ledger department numbers.
3. Select GL from the toolbar or from the drop down menu under Periodic/General Ledger.
4. Select G/L
5. Edit accounts. Enter the necessary account numbers for all departments under all tabs. Sub accounts cannot be used. The clearing account should be the Bank G/L Account.
To prepare for the Import
1. Do payroll as per EasyPay guidelines
2. If using Spectra MICR cheque interface, select the Viceroy 150 Detailed cheque format.
3. On the next screen, be sure to tick "Print Company Name and Address On Cheques".
4. Click on the Setup button at the bottom of the above screen.
Select "Laser printer" and set both the top and left margins to zero.
The Font should show Courier New 12 pt. If not already selected, click on the Font Setup Button and select Courier New 12 pt. Click on OK to return to the previous screen.
5. Select the reporting option to "Send report to a text file". You will be prompted for a file name and folder location. Accept the default name of REPORT.PRN.
6. Close the pay period only after you have successfully printed the cheques in SPECTRA.
7. Go to the G/L and Create Entries. It is not necessary to enter a fiscal period, as the posting will be done by transaction date. Enter your transaction date (will default to current date). No entry is required for Source Code or Reference.
8. Enter range – enter the specific payroll periods. If defaults are accepted by tabbing through the fields, entries will post for the entire year.
9. Destination Folder: The program will create a file called GLIMPORT.DEL. The screen will display where this file has been created. Make a note of it (e.g. C:\Easydata\Spectra).
In SPECTRA
Go to Banking – Start a Task – EasyPay Payroll Interface – Import/Process G/L Entries
Select Bank and click on Process (!) button.
Find the file GLIMPORT.DEL in the folder you noted above and click Open.
A message will display when the posting is completed.
Go to Banking – Start a Task – EasyPay Payroll Interface – Import/Print Pay Cheques
Select Bank and click on Process (!) button. Find the file called REPORT.PRN (located in the same folder as GLIMPORT.DEL) and then click open. A message will display "Import of Payroll cheques completed. You can print the cheques now." Click on OK to continue.
