Bill Aging Reports: Part 4/5

Step-by-step guide for updating, organizing, and formatting bill review and Comp 1 Bill Aging Reports in Excel, including tips for copying, pasting, renaming tabs, and ensuring data accuracy.

March 17, 2026 By Jessica Esslinger

In this guide, we'll learn how to update and organize weekly billing and summary reports using spreadsheet tools. The process includes copying data from previous reports, renaming files and tabs, adjusting dates, and ensuring information for clients like Penn National, CEP, and Prime is accurate and well-formatted.

You'll also see how to use features like Paste Special, sorting, and formatting to keep your reports clear and consistent.

Let's get started

Okay. Now that we have finished, I will select all of these and quickly make them the same size.

Step #5: Click on "$ % 950808" — Click on "$ % 950808"

I like the comma; remove decimals.

Step #6: Double-click on "500-00" — Double-click on "500-00"

Next, write "Summary" below this section.

This is bill review.

Step #10: Right-click on "1 Summary" — Right-click on "1 Summary"

So... Oop, oop.

Step #12: Right-click on "1" — Right-click on "1"

Step #13: Click on "Insert" — Click on "Insert"

This is Penn National, this is CEP, and this is called Prime.

Step #16: Drag "10-14 Days" — Drag "10-14 Days"

I will rename this tab to Summary.

Step #23: Double-click on "Sheet6" — Double-click on "Sheet6"

Step #25: Click on "14 MANAGEABILITY" — Click on "14 MANAGEABILITY"

I will bold this entire row, this entire column, and then this part is done.

Step #27: Click on "BIU" — Click on "BIU"

Step #29: Click on "« Α Α = =" — Click on "« Α Α = ="

Now comes the easy part.

Step #32: Click on "Continue" — Click on "Continue"

We will go back to the 311 folder.

Step #35: Click on "MAI - Bill Aging Reports" — Click on "MAI - Bill Aging Reports"

We're going to grab this file.

Step #36: Double-click on "03.11.26" — Double-click on "03.11.26"

Step #37: Click on "( Main )" — Click on "( Main )"

Open it.

Step #38: Double-click on ")" — Double-click on ")"

First, save a copy of the file into your 317 folder.

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

Step #41: Click on "HSave a Copy" — Click on "HSave a Copy"

Step #42: Double-click on "This PC" — Double-click on "This PC"

Step #43: Click on "HR & Accounting - Documents" — Click on "HR & Accounting - Documents"

Step #44: Double-click on "3- ManageAbility" — Double-click on "3- ManageAbility"

Step #45: Double-click on "Aging" — Double-click on "Aging"

Step #46: Double-click on "Aging" — Double-click on "Aging"

We will rename it 317.

Step #47: Double-click on "03.11.26" — Double-click on "03.11.26"

Click Save.

Next, copy last week's sheet, update the tab date, and change the date at the top. Then, delete those items.

Step #50: Right-click on "03.11.2" — Right-click on "03.11.2"

Step #51: Click on "Move or Copy ..." — Click on "Move or Copy ..."

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

Step #54: Double-click on "03.11.26 ( 2 )" — Double-click on "03.11.26 ( 2 )"

Step #57: Click on "03/11/26" — Click on "03/11/26"

Step #60: Drag "#CEP_CLEARCOV" — Drag "#CEP_CLEARCOV"

Step #61: Drag "MGY_Audit 1" — Drag "MGY_Audit 1"

Same process applies here for the Comp 1 Bill Aging Report.

Step #62: Click on "C1-03.11.26" — Click on "C1-03.11.26"

Step #63: Right-click on "C1-03.11.26" — Right-click on "C1-03.11.26"

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

I will move and copy it, rename it to today's date, update the date above, and then continue.

Step #65: Double-click on "OK" — Double-click on "OK"

Step #66: Double-click on "C1-03.11.26" — Double-click on "C1-03.11.26"

Step #67: Drag "C1-03.11.26" — Drag "C1-03.11.26"

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

Step #72: Drag "CITY OF DETROIT PIP" — Drag "CITY OF DETROIT PIP"

I'll leave it so you can see which ones we will do.

Step #74: Click on "Accessibility : Investigate" — Click on "Accessibility : Investigate"

For 317, I will go to our 317.

We will copy and paste below the client, all the way over to zero to two days.

Right-click and select Paste Special. Sometimes, there may be more content than expected from last week. If that happens, press Control Z to undo.

Step #82: Right-click here — Right-click here

I'm going to add two more lines because that's what we'll need.

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

I'm going back, copying, and using Paste Special.

Step #94: Right-click here — Right-click here

Step #95: Click on "L123 Lfx" — Click on "L123 Lfx"

We also need to include Penn National.

Try to go quickly so we don't need to make another video.

Okay, you can see there aren't as many. We'll copy and paste Penn National first, then grab 11, 12, and 2.

Step #100: Drag "28 PENN NATIONAL" — Drag "28 PENN NATIONAL"

Step #101: Click on "05-09 Days 0-2 Days Grand Total" — Click on "05-09 Days 0-2 Days Grand Total"

I will type them in, starting at 10/14. 11, 12, and 2.

I can't remember.

Step #110: Right-click on "WAYNE STATE UNIVERSITY" — Right-click on "WAYNE STATE UNIVERSITY"

Step #112: Click on "472" — Click on "472"

I don't think that's correct, so I'll double-check it.

So, 10/14, 5, and 2.

10/14, 5...

Step #118: Click on "11" — Click on "11"

Step #119: Double-click on "301" — Double-click on "301"

This is wrong. This goes here. I usually sort it in alphabetical order.

Step #123: Right-click on "CITY OF DETROIT PIP" — Right-click on "CITY OF DETROIT PIP"

Step #125: Click on "Custom Sort" — Click on "Custom Sort"

Step #127: Click on "BR INVENTORY" — Click on "BR INVENTORY"

Okay, screw it.

Step #128: Click on "OK" — Click on "OK"

We'll leave it like that.

For CEP, we'll get that from our 317 file.

Step #136: Drag "34 #CEP CLEARCOV" — Drag "34 #CEP CLEARCOV"

Paste Special.

Step #139: Right-click here — Right-click here

I will remove the extra rows.

Step #141: Click on "34" — Click on "34"

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

Do the same for Prime.

Step #146: Click on "47 MGY_Final Review" — Click on "47 MGY_Final Review"

That should be fine.

Step #151: Right-click on "40 BR INVENTORY" — Right-click on "40 BR INVENTORY"

Oops.

Step #152: Right-click here — Right-click here

Step #153: Right-click here — Right-click here

Make sure the days line up, and that the times of 30 and 24 match.

Step #155: Click on "30+ DAYS 24-29 DAYS15-23 DAYS10-14 DAYS 5-9 DAYS" — Click on "30+ DAYS 24-29 DAYS15-23 DAYS10-14 DAYS 5-9 DAYS"

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

Step #158: Click on "30+ DAYS 24-29 DAYS 15-23 DAYS10-14 DAYS 5-9 DAYS" — Click on "30+ DAYS 24-29 DAYS 15-23 DAYS10-14 DAYS 5-9 DAYS"

We will look at that.

They do, so that looks good.

From here, the last step is coming up. We're running out of time again, so there will be several videos for this process.

Step #167: Click on "F 2" — Click on "F 2"

We're going to gather all of the City of Detroit's Comp 1 and FCA.

Step #169: Drag "CITY OF DETROIT PIP" — Drag "CITY OF DETROIT PIP"

We will copy and paste this using Paste Special, and do the same for Comp 1.

Step #173: Click on "C1-03.17.26" — Click on "C1-03.17.26"

Step #174: Right-click on "CITY OF DETROIT PIP" — Right-click on "CITY OF DETROIT PIP"

Step #175: Click on "L123" — Click on "L123"