Importing ADP Payroll into Quickbooks [SOLVED]

Importing ADP Payroll into Quickbooks

ADP is a payroll service that takes care of paying your payroll expenses on your behalf, both to your employees and to government agencies. ADP allows you to export your payroll data using its general ledger interface. This data can then be imported into QuickBooks, allowing you to include all the data as part of your financial statements.

Exporting from ADP

To add the data to QuickBooks, export it from ADP’s general ledger interface. Click “Define G/L File” and select “Use a Predefined G/L File for Map Assistant.” Then choose QuickBooks from the drop-down menu. You are then prompted to “map” the payroll items; you must identify the corresponding general ledger account name or number for each payroll item. This allows you to seamlessly integrate your payroll data into the general ledger. You can reuse the map each time you export data to QuickBooks. Select the desired pay period and click “Download” to export the data to your computer.

Importing to QuickBooks

After you export the data from ADP, adding the data to your QuickBooks general ledger is a simple process. In QuickBooks, click the “File” menu and select “Import.” Then choose the file that you have just saved to your computer. The data is automatically added to your general ledger, integrating with the pre-existing general ledger accounts. Now you can create any number of financial reports, such as balance sheets and income statements.

Quickbooks Logo

Importing ADP Payroll into Quickbooks