Spreadsheet: 889285d1740062281-simple-lookup-giving-me-problems-today-sample-mmh
Sheet: 2025

 |  | Detailed Trial Balance | Detailed Income Statement |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Gross Profit
 |  | Month 1 |  | 2025
 |  |  |  |  |  |  | 2025-01-31 00:00:00 | 2025-02-28 00:00:00 | 2025-03-31 00:00:00 | 2025-04-30 00:00:00 | 2025-05-31 00:00:00 | 2025-06-30 00:00:00 | 2025-07-31 00:00:00 | 2025-08-31 00:00:00 | 2025-09-30 00:00:00 | 2025-10-31 00:00:00 | 2025-11-30 00:00:00 | 2025-12-31 00:00:00 | YTD |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | YTD
 |  |  |  |  | REVENUE: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | REVENUE:
 |  |  |  |  | New |  | 625717.08 | 0 | 0 | 55555555 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 56181272.08 |  | New |  | 0.3257223684118332 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.9774639215091876
 |  |  |  |  | Used |  | 43000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 43000 |  | Used |  | 0.02238401713712023 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.0007481309530521948
 |  |  |  |  | Service |  | 715130.21 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 715130.21 |  | Service |  | 0.3722671366491253 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.01244211733869108
 |  |  |  |  | Parts |  | 391272.42 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 391272.42 |  | Parts |  | 0.2036801989433141 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.006807511825061365
 |  |  |  |  | Rental |  | 125282.5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 125282.5 |  | Rental |  | 0.06521687504607594 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.002179714328506084
 |  |  |  |  | Allied |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | Allied |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  | Labor Sublet |  | 3973.58 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3973.58 |  | Labor Sublet |  | 0.002068480995714377 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 6.913391145184048e-05
 |  |  |  |  | Other Revenue |  | 16637.75 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 16637.75 |  | Other Revenue |  | 0.008660922816816793 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.0002894701340498641
 |  |  |  |  | Total Revenue |  | 1921013.54 | 0 | 0 | 55555555 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 57476568.54 |  | Total Revenue |  | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1
 |  |  |  |  | [NAME]: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]:
 |  |  |  |  | New |  | 602497.6 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 602497.6 |  | New |  | 0.9628914077269555 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.01072417155563986
 |  |  |  |  | Used |  | 17694.82 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 17694.82 |  | Used |  | 0.4115074418604651 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.4115074418604651
 |  |  |  |  | Service |  | 258290.73 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 258290.73 |  | Service |  | 0.3611800010518364 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.3611800010518364
 |  |  |  |  | Parts |  | 235675.92 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 235675.92 |  | Parts |  | 0.6023320529466402 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.6023320529466402
 |  |  |  |  | Rental |  | 70605 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 70605 |  | Rental |  | 0.5635663400714386 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.5635663400714386
 |  |  |  |  | Allied |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | Allied |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  | Labor Sublet |  | 2691.75 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2691.75 |  | Labor Sublet |  | 0.677411804971839 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.677411804971839
 |  |  |  |  | Other Revenue |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | Other Revenue |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  | Total [NAME] |  | 1187455.82 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1187455.82 |  | Total [NAME] |  | 0.6181402656849571 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.02065982451916222
 |  |  |  |  | GROSS PROFIT: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | GROSS PROFIT:
 |  |  |  |  | New |  | 23219.47999999998 | 0 | 0 | 55555555 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 55578774.48 |  | New |  | 0.03710859227304453 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.9892758284443601
 |  |  |  |  | Used |  | 25305.18 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 25305.18 |  | Used |  | 0.5884925581395349 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.5884925581395349
 |  |  |  |  | Service |  | 456839.48 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 456839.48 |  | Service |  | 0.6388199989481635 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.6388199989481635
 |  |  |  |  | Parts |  | 155596.5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 155596.5 |  | Parts |  | 0.3976679470533598 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.3976679470533598
 |  |  |  |  | Rental |  | 54677.5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 54677.5 |  | Rental |  | 0.4364336599285614 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.4364336599285614
 |  |  |  |  | Allied |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | Allied |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  | Labor Sublet |  | 1281.83 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1281.83 |  | Labor Sublet |  | 0.3225881950281611 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.3225881950281611
 |  |  |  |  | Other Revenue |  | 16637.75 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 16637.75 |  | Other Revenue |  | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1
 |  |  |  |  | Total Gross Profit |  | 733557.7199999999 | 0 | 0 | 55555555 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 56289112.72 |  | Total Gross Profit |  | 0.3818597343150428 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.9793401754808377