1 min read

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

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.

Sage 100 Tips and Tricks

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 

Mike is and expert on Sage 100 ERP with over 25 years in the accounting software industry. Mike is also a Sage Certified Trainer and a recognized leader in the design, implementation and support of ERP systems, including Sage. 

Specialties

Sage 100 ERP (formerly Sage MAS90/200), Sage 100 Fund Accounting (formally MIP Non Profit Software), Sage Grant ManagementSage Online Fundraising, QuickBooks Enterprise and Point of Sale VAR.

 

Sage 100 ERP (formerly MAS90) v 4.5: How to Fix Crystal Report Error

Sage 100 ERP (formerly MAS90) v 4.5: How to Fix Crystal Report Error

Question: Mike, we recently upgraded to Sage 100 ERP (formerly MAS90)version 4.5 and are now getting a Crystal Error: Failed to load the Crystal...

Read More
Sage 100 ERP (Sage MAS 90) v.4.5: How to Create New Check Form Code

Sage 100 ERP (Sage MAS 90) v.4.5: How to Create New Check Form Code

Question: Mike, we recently upgraded to Sage 100 ERP version 4.5 (formerly MAS 90 MAS 200) and now when we try to print an Accounts Payable check...

Read More
Sage 100 Payroll Reports 2019 Federal Changes

Sage 100 Payroll Reports 2019 Federal Changes

2019 Sage 100 Payroll Reports and Tax Table Updates Every year there are important changes to Sage 100 payroll reports. You get tax table updates...

Read More