Sage 100 ERP (MAS 90): How to Import ADP Payroll to Sage 100 GL

Question: Mike, we own Sage 100 ERP (formerly Sage MAS90); we also use ADP for our Payroll. How can we import the ADP Payroll information into the Sage 100 ERP General Ledger? We spend many hours manually typing this data into Journal Entries now.

Answer: You can import ADP Payroll into Sage 100 ERP, using the General Ledger Data Exchange Utility that is a part of the General Ledger module.

 

First Step:  You will need to ask your payroll company to provide you with a CSV file of the General Ledger data. In the example below we have used the Alternate Exchange Format .

Sage 100 ERP Payroll resized 600

Sage 100 ERP Payroll

Second Step:  You will need to setup the Data Exchange, General Ledger>General Ledger Exchange. This will open up a wizard as shown, and follow comments and screen shots below:

Sage 100 ERP Payroll

Click Next

Sage 100 ERP Payroll 2

Select Import Data, and Click Next:

Sage 100 ERP Payroll

Select Transactions and Click Next:

Sage 100 ERP Payroll6 resized 600

Enter Name and Click Next:

Sage Payroll

Set Duplicate Procedure to: Do not import new entry, Click Next:

Sage 100 ERP Payroll8 resized 600

 

Click Next:

Sage 100 ERP Payroll9 resized 600

Click next:

Sage 100 ERP Payroll10 resized 600

Make sure the file has been saved as a CSV file, set Exchange File Type to CSV, set  Exchange File Name, Click next:

Sage 100 ERP Payroll11 resized 600

 

Select Alternate File Name, click next:

Sage 100 ERP Payroll12.png resized 600

Click Finish:

Sage 100 ERP Payroll13 resized 600

Proceed, and test first, once this is complete then you can go into

General Journal Entry and review the Journal is correct and then Update.

Sage 100 ERP Payroll14 resized 600

You can then do Payroll Journal Entries each period from General Ledger Exchange shown in the second to last screen shot and save many hours in Journal Entry processing.

Written by Mike Renner, Partner WAC Consulting, Owner at Computer Accounting Services 

 

0 replies

Leave a Reply

Want to join the discussion?
Feel free to contribute!

Leave a Reply

Your email address will not be published. Required fields are marked *