Three-way reconciliation across 3 clients: what you buy from Ingram Micro vs what you bill in ConnectWise vs whatβs actually assigned in Microsoft 365 β surfacing unused licenses, dormant accounts and billing gaps.
| SKU | Ingram | ConnectWise | M365 assigned | Active | Unused | Dormant | Bill Ξ | Waste $/mo | Status |
|---|---|---|---|---|---|---|---|---|---|
| Microsoft 365 E5 $57.00/seat | 48 | 38 | 38 | 26 | 10 | 12 | 0 | $1,254 | Unused β reclaim |
| Microsoft 365 E3 $36.30/seat | 53 | 47 | 49 | 31 | 4 | 18 | -2 | $799 | Unused β reclaim |
| Microsoft 365 Business Premium $30.20/seat | 44 | 34 | 34 | 19 | 10 | 15 | 0 | $755 | Unused β reclaim |
| Office 365 E1 $12.30/seat | 39 | 28 | 31 | 19 | 8 | 12 | -3 | $246 | Unused β reclaim |
| Exchange Online (Plan 1) $5.90/seat | 47 | 44 | 43 | 23 | 4 | 20 | +1 | $142 | Unused β reclaim |
Unused = bought from Ingram but not assigned in M365 Β· Dormant = assigned to inactive/disabled/shared accounts Β· Bill Ξ = ConnectWise billed minus M365 assigned (negative = under-billing the client).
| User | Client | Reason | SKU | $/mo | |
|---|---|---|---|---|---|
Charlotte Wilson charlotte.wilson@northwind.example | Northwind Traders | Inactive No sign-in for 184 days | Microsoft 365 E5 | $57.00 | |
Olivia Mitchell olivia.mitchell@northwind.example | Northwind Traders | Inactive No sign-in for 367 days | Microsoft 365 E5 | $57.00 | |
Oscar Cooper oscar.cooper@northwind.example | Northwind Traders | Inactive No sign-in for 129 days | Microsoft 365 E5 | $57.00 | |
Oscar Scott oscar.scott@contoso.example | Contoso Ltd | Inactive No sign-in for 151 days | Microsoft 365 E5 | $57.00 | |
Ethan Patel ethan.patel@contoso.example | Contoso Ltd | Inactive No sign-in for 331 days | Microsoft 365 E5 | $57.00 | |
Ethan Turner ethan.turner@fabrikam.example | Fabrikam Inc | Inactive No sign-in for 108 days | Microsoft 365 E5 | $57.00 | |
Mason King mason.king@fabrikam.example | Fabrikam Inc | Inactive No sign-in for 124 days | Microsoft 365 E5 | $57.00 | |
Mason Carter mason.carter@fabrikam.example | Fabrikam Inc | Inactive No sign-in for 328 days | Microsoft 365 E5 | $57.00 | |
Chloe Young chloe.young@fabrikam.example | Fabrikam Inc | Inactive No sign-in for 304 days | Microsoft 365 E5 | $57.00 | |
Mason Walker mason.walker@fabrikam.example | Fabrikam Inc | Disabled Account disabled β still licensed | Microsoft 365 E5 | $57.00 | |
Amelia Evans amelia.evans@northwind.example | Northwind Traders | Inactive No sign-in for 109 days | Microsoft 365 E3 | $36.30 | |
Harper Cooper harper.cooper@northwind.example | Northwind Traders | Disabled Account disabled β still licensed | Microsoft 365 E3 | $36.30 | |
Henry Baker henry.baker@contoso.example | Contoso Ltd | Inactive No sign-in for 246 days | Microsoft 365 E3 | $36.30 | |
Jack Walker jack.walker@contoso.example | Contoso Ltd | Inactive No sign-in for 247 days | Microsoft 365 E3 | $36.30 | |
Henry Carter henry.carter@contoso.example | Contoso Ltd | Inactive No sign-in for 220 days | Microsoft 365 E3 | $36.30 | |
Oscar Hall oscar.hall@contoso.example | Contoso Ltd | Inactive No sign-in for 147 days | Microsoft 365 E3 | $36.30 | |
Charlotte Brown charlotte.brown@contoso.example | Contoso Ltd | Inactive No sign-in for 287 days | Microsoft 365 E3 | $36.30 | |
Ella Taylor ella.taylor@contoso.example | Contoso Ltd | Inactive No sign-in for 304 days | Microsoft 365 E3 | $36.30 | |
Ava Hall ava.hall@fabrikam.example | Fabrikam Inc | Inactive No sign-in for 198 days | Microsoft 365 E3 | $36.30 | |
Ethan Turner ethan.turner@fabrikam.example | Fabrikam Inc | Inactive No sign-in for 185 days | Microsoft 365 E3 | $36.30 | |
Felix Roberts felix.roberts@fabrikam.example | Fabrikam Inc | Inactive No sign-in for 312 days | Microsoft 365 E3 | $36.30 | |
Sophia Nguyen sophia.nguyen@fabrikam.example | Fabrikam Inc | Inactive No sign-in for 102 days | Microsoft 365 E3 | $36.30 | |
Leo Phillips leo.phillips@northwind.example | Northwind Traders | Inactive No sign-in for 139 days | Microsoft 365 Business Premium | $30.20 | |
Ava Cooper ava.cooper@northwind.example | Northwind Traders | Inactive No sign-in for 328 days | Microsoft 365 Business Premium | $30.20 | |
Felix Nguyen felix.nguyen@northwind.example | Northwind Traders | Inactive No sign-in for 263 days | Microsoft 365 Business Premium | $30.20 | |
Isla Mitchell isla.mitchell@contoso.example | Contoso Ltd | Inactive No sign-in for 220 days | Microsoft 365 Business Premium | $30.20 | |
Olivia Phillips olivia.phillips@contoso.example | Contoso Ltd | Inactive No sign-in for 360 days | Microsoft 365 Business Premium | $30.20 | |
Harper Nguyen harper.nguyen@contoso.example | Contoso Ltd | Inactive No sign-in for 161 days | Microsoft 365 Business Premium | $30.20 | |
Jack King jack.king@contoso.example | Contoso Ltd | Inactive No sign-in for 105 days | Microsoft 365 Business Premium | $30.20 | |
Max Green max.green@fabrikam.example | Fabrikam Inc | Inactive No sign-in for 373 days | Microsoft 365 Business Premium | $30.20 |
| Client | Ingram | Billed | Seats | Reclaimable | Leak |
|---|---|---|---|---|---|
| Contoso Ltd | $2,499 | $2,861 | 74 | $1,189 | $39 |
| Fabrikam Inc | $2,440 | $2,662 | 69 | $1,091 | $47 |
| Northwind Traders | $1,806 | $1,630 | 52 | $916 | $334 |