SOP: ADP Invoice Download and Company Cost Allocation Breakdown

Learn the complete ADP invoice process for splitting invoices between companies, including how to generate, save, and break down invoices using Reports and Analytics, Excel, and pivot tables.

April 10, 2026 By Jessica Esslinger

In this guide, we'll learn how to split an ADP invoice between companies and prepare a breakdown for reporting. We will cover how to locate and save the invoice, use Excel to organize the data, and update the necessary details for accurate records. This process helps ensure each company receives the correct invoice allocation.

Let's get started

You did great. For this video, we will go over the ADP invoice process for splitting between companies.

Step #1: Click on "Process ▾" — Click on "Process ▾"

There are some more -isms. First, go to Reports to look it up.

Step #2: Click on "Process ▾" — Click on "Process ▾"

Step #3: Click on "Reports & Analytics ▼" — Click on "Reports & Analytics ▼"

Nope. Just kidding, this is already bad.

Step #4: Click on "Process ▾" — Click on "Process ▾"

What am I doing? Go to Reports and Analytics, then select Billing and Invoice Management. The invoice is usually generated between this week and next week.

Step #5: Click on "Reports & Analytics ▼" — Click on "Reports & Analytics ▼"

Step #6: Click on "Billing & Invoice Management" — Click on "Billing & Invoice Management"

It will be generated here. It's just this large one. Then, save it as a PDF in your files. I have my files saved.

Step #10: Click on "Payroll" — Click on "Payroll"

It’s in Payroll Master, under ADP Invoices 2026. Then I save it here.

Step #11: Double-click on "1- ADP Invoices" — Double-click on "1- ADP Invoices"

Step #12: Double-click here — Double-click here

While we're here, I'll grab the last invoice breakdown Excel sheet.

Step #13: Click on "716420048 Breakdown" — Click on "716420048 Breakdown"

Step #14: Double-click on "Invoice 716420048 Breakdown" — Double-click on "Invoice 716420048 Breakdown"

I'm going to open it because it's just copying and pasting from the previous one.

I am going to save it.

Step #16: Click on "File" — Click on "File"

Hold on.

This is the last one. Next, go to Reports and Analytics, then All Standard Reports. There is a Monthly Employee Count report that I have already set up.

Step #21: Click on "Reports & Analytics ▼" — Click on "Reports & Analytics ▼"

Step #22: Click on "All Standard Reports" — Click on "All Standard Reports"

Step #23: Click on "■ Monthly Employee Count" — Click on "■ Monthly Employee Count"

Go to it and click Edit Run.

All you need to change is the start date, which was last month, 3/1.

Step #25: Click on "Edit / Run" — Click on "Edit / Run"

Well, for...

Last month would be 3/1 to 3/31, but I haven't received the invoice yet, so I'll just use 2/1 to 2/28.

Step #32: Double-click on "<" — Double-click on "<"

For example, we will run the report.

Once it's done running, view it as an XLSX file.

When you do that, I save it as the breakdown.

Mm-hmm. This is a very bad video.

When I get it, it will come out looking like this with the employee count.

Step #42: Click on "Raw" — Click on "Raw"

Step #43: Drag "1 Company Code Month Home Department Employee Count Department" — Drag "1 Company Code Month Home Department Employee Count Department"

Okay.

Next, I'll open the previous worksheet and copy and paste a quick crosswalk here.

Step #46: Drag "Crosswalk Department" — Drag "Crosswalk Department"

Then I'll go to tab number one.

I will enter the invoice total and reenter the invoice number.

Step #49: Click on "713526786" — Click on "713526786"

Step #50: Click on "713526786" — Click on "713526786"

Then I copy and paste into company code, company, month, home department, and count.

Step #51: Click on "6Y7" — Click on "6Y7"

Step #52: Click on "Company Code" — Click on "Company Code"

Step #53: Click on "Company" — Click on "Company"

Step #54: Click on "January" — Click on "January"

Step #55: Click on "Month Home Departme Home Department" — Click on "Month Home Departme Home Department"

Step #56: Click on "HAA Commercial" — Click on "HAA Commercial"

Step #57: Click on "21.00" — Click on "21.00"

If I delete these, you can see that all of this auto-populates automatically.

Yeah.

Okay. For the detail, I right-click, select Move and Copy, choose Create Copy, and move it to the new spreadsheet. I repeat the same steps for Summary.

Step #60: Click on "Detail" — Click on "Detail"

Step #61: Right-click on "Detail" — Right-click on "Detail"

Step #62: Click on "Move or Copy" — Click on "Move or Copy"

Step #64: Click on "Cancel" — Click on "Cancel"

Step #65: Click on "Summary" — Click on "Summary"

Step #66: Right-click on "Summary" — Right-click on "Summary"

Right-click, select Move or Copy, then choose Create Copy. Place it in the new spreadsheet.

Step #67: Click on "Move or Copy" — Click on "Move or Copy"

Step #68: Click on "Create a copy" — Click on "Create a copy"

Step #69: Click on "INV_713526786 Breakdown.xlsx" — Click on "INV_713526786 Breakdown.xlsx"

Step #70: Click on "Cancel" — Click on "Cancel"

Next, click on the pivot table. Go to Pivot Table Analyze, then select Change Data Source. When prompted, choose the data source from the tab labeled "one" and select all the data there.

Step #73: Click on "PivotTable Analyze" — Click on "PivotTable Analyze"

Step #74: Click on "Source" — Click on "Source"

Step #75: Click on "..." — Click on "..."

I’ll do that for both summary and detail. Then, I’ll click Pivot Table Refresh, and all my numbers will update.

Step #76: Click on "Cancel" — Click on "Cancel"

Step #77: Click on "Detail" — Click on "Detail"

Step #79: Click on "13 CompOne Administrators Total" — Click on "13 CompOne Administrators Total"

Step #80: Click on "PivotTable Analyze" — Click on "PivotTable Analyze"

And then- Wait. Let me go back. Would you like me to repeat that part? No. Okay.

No, that's still good. The only thing I'll double-check is that the grand totals are all the same here.

Step #81: Click on "9,273.15" — Click on "9,273.15"

Step #82: Click on "Summary" — Click on "Summary"

Step #83: Click on "9,273.15" — Click on "9,273.15"

Step #84: Double-click on "1" — Double-click on "1"

Sometimes I forget to update the invoice date and invoice number here. Just update those, then I'll select these three tabs and save them as one PDF.

Step #85: Double-click on "9,273.15" — Double-click on "9,273.15"

Step #86: Click on "Summary" — Click on "Summary"

Step #88: Click on "713526786" — Click on "713526786"

Step #89: Click on "02/13/26" — Click on "02/13/26"

Step #90: Click on "Summary Accessibility : Good to go" — Click on "Summary Accessibility : Good to go"

Type "Ctrl + P"

I'll send that out with the PDF I just saved.

Here is the invoice breakdown from ADP and the invoice I just created.

Step #95: Click on "Invoice Breakdown" — Click on "Invoice Breakdown"

Step #96: Click on "03.21.26 - Invoice Breakdown" — Click on "03.21.26 - Invoice Breakdown"

Step #97: Click on "Invoice 716420048" — Click on "Invoice 716420048"

Step #98: Double-click on "Invoice 716420048" — Double-click on "Invoice 716420048"

Okay. That all makes very good sense. That was a terrible video, but glitter will help us.