MIP Toolbox

ADP to MIP Formatter — User Guide

Back to the tool

ADP to MIP Formatter

The ADP to MIP Formatter converts an ADP payroll export into MIP-ready journal entry rows. Each payroll column beyond the first two (Employee Name and Employee ID) is mapped to an ADP Code, GL Code, and Debit/Credit flag using a Column Mapping Template. Columns marked "Delete" are skipped, and blank or zero values are dropped. The output is a single sheet you can import into MIP.

ADP input

CSV or Excel (.xlsx)

Mapping file

Excel only (.xlsx)

Output

Single .xlsx ("ADP to MIP")

First two columns

Employee Name, Employee ID

Step 1.Upload the ADP Export File

Upload your ADP payroll export (CSV or Excel). The first sheet is read automatically. The tool expects the first two columns to be the employee name and employee ID; every column after that is treated as a payroll amount to be mapped.

Step 2.Upload the Column Mapping Template

Upload an Excel mapping file that defines the rules for each payroll column. The tool matches columns by header name (case-insensitive) and looks for these fields:

  • Indicator — "Keep" to include the column, "Delete" to skip it.
  • ADP Code — written to the output's ADP Code column.
  • GL Code — written to the output's GL Code column.
  • Debit/Credit — "D" for Debit, "C" for Credit. The payroll amount goes into the matching Debit Amount or Credit Amount column.
  • ADP Column — the header name in the ADP file this rule applies to (defaults to the first column of the mapping file).

Columns not listed in the mapping file, or marked "Delete", are skipped. Rows where both ADP Code and GL Code are blank, or where the payroll amount is blank or zero, are also skipped.

A preview of the first 10 mapping rules appears after upload so you can confirm they loaded correctly.

Step 3.Additional Options (Optional)

Enter optional session metadata that is appended to every output row when filled in:

  • Session ID — written to a "Session ID" column.
  • Session/Document/ Effective — written to a "Session/Document/ Effective" column (e.g. 01/31/2025).
  • Session/Document Description — written to a "Session/Document Description" column.

Step 4.Process, Review & Download

Click Process File. The tool reads the ADP rows, applies the mapping, and builds one output row per non-zero payroll amount. Each output row contains Employee Name, Employee ID, ADP Code, GL Code, and the amount in either the Debit Amount or Credit Amount column, plus any session columns you filled in.

The results panel shows the total number of output rows and a preview of the first 50 rows. Click Export (or Download Processed File) to save the full result as adp_to_mip_processed.xlsx.

If the Process button is disabled, make sure both the ADP file and the mapping file are uploaded.

Tips

  • The first two columns of the ADP file must be Employee Name and Employee ID — everything after that is mapped.
  • Use "Delete" in the Indicator column to exclude columns you don't want in the output (e.g. informational totals).
  • Only non-zero amounts produce output rows, so totals and zero-balance lines are automatically dropped.
  • Mapping headers are matched case-insensitively, so "GL Code", "gl code", and "GLCODE" all work.
  • Use Restart to clear both files, the session fields, and the results and start over.
Open ADP to MIP Formatter