Spreadsheet: 24061d1214077261-formula-to-pull-pivot-data-into-static-report-formula-to-fix
Sheet: data

Company | Account | Description | YTD Bal/Activity (Actual) | Cat Code | Cat Code Description
2 | ACCOUNT# | ACCOUNT NAME | -1000000 | 500 | Fee1
8 | ACCOUNT# | ACCOUNT NAME | -666664 | 500 | Fee1
9 | ACCOUNT# | ACCOUNT NAME | -925051.97 | 504 | Fee2
9 | ACCOUNT# | ACCOUNT NAME | -829735.92 | 504 | Fee2
9 | ACCOUNT# | ACCOUNT NAME | -590570.12 | 504 | Fee2
9 | ACCOUNT# | ACCOUNT NAME | -544171.87 | 504 | Fee2
8 | ACCOUNT# | ACCOUNT NAME | -540319 | 504 | Fee2
8 | ACCOUNT# | ACCOUNT NAME | -469692.16 | 504 | Fee2
7 | ACCOUNT# | ACCOUNT NAME | -440189.5 | 504 | Fee2
8 | ACCOUNT# | ACCOUNT NAME | -383996.18 | 504 | Fee2
9 | ACCOUNT# | ACCOUNT NAME | -327300.51 | 504 | Fee2
7 | ACCOUNT# | ACCOUNT NAME | -300407 | 504 | Fee2
7 | ACCOUNT# | ACCOUNT NAME | -293568.5 | 504 | Fee2
9 | ACCOUNT# | ACCOUNT NAME | -285304.41 | 504 | Fee2
8 | ACCOUNT# | ACCOUNT NAME | -274497.85 | 504 | Fee2
8 | ACCOUNT# | ACCOUNT NAME | -233029.25 | 504 | Fee2
8 | ACCOUNT# | ACCOUNT NAME | -198502.11 | 504 | Fee2
8 | ACCOUNT# | ACCOUNT NAME | -179466.64 | 504 | Fee2
9 | ACCOUNT# | ACCOUNT NAME | -173320.67 | 504 | Fee2
8 | ACCOUNT# | ACCOUNT NAME | -163035.44 | 504 | Fee2
7 | ACCOUNT# | ACCOUNT NAME | -159312.39 | 504 | Fee2
8 | ACCOUNT# | ACCOUNT NAME | -143854.47 | 504 | Fee2
8 | ACCOUNT# | ACCOUNT NAME | -137628.71 | 504 | Fee2
8 | ACCOUNT# | ACCOUNT NAME | -95000 | 504 | Fee2
8 | ACCOUNT# | ACCOUNT NAME | -74926.67 | 504 | Fee2
7 | ACCOUNT# | ACCOUNT NAME | -59953 | 504 | Fee2
8 | ACCOUNT# | ACCOUNT NAME | -53333.36 | 504 | Fee2
8 | ACCOUNT# | ACCOUNT NAME | -38881 | 504 | Fee2
7 | ACCOUNT# | ACCOUNT NAME | -4658 | 504 | Fee2
9 | ACCOUNT# | ACCOUNT NAME | -1412.64 | 504 | Fee2
8 | ACCOUNT# | ACCOUNT NAME | -575000 | 505 | Fee3
9 | ACCOUNT# | ACCOUNT NAME | -701137.29 | 507 | [NAME]
8 | ACCOUNT# | ACCOUNT NAME | -345589 | 507 | [NAME]
9 | ACCOUNT# | ACCOUNT NAME | -455725.76 | 512 | Comm1
8 | ACCOUNT# | ACCOUNT NAME | -148059.09 | 512 | Comm1
8 | ACCOUNT# | ACCOUNT NAME | -124301.51 | 512 | Comm1
9 | ACCOUNT# | ACCOUNT NAME | -52956.02 | 512 | Comm1
9 | ACCOUNT# | ACCOUNT NAME | -45758.07 | 512 | Comm1
9 | ACCOUNT# | ACCOUNT NAME | -41608.34 | 512 | Comm1
8 | ACCOUNT# | ACCOUNT NAME | -35710.5 | 512 | Comm1
8 | ACCOUNT# | ACCOUNT NAME | -25654 | 512 | Comm1
9 | ACCOUNT# | ACCOUNT NAME | -16752.63 | 512 | Comm1
8 | ACCOUNT# | ACCOUNT NAME | 1297.8 | 512 | Comm1
8 | ACCOUNT# | ACCOUNT NAME | 16678.63 | 512 | Comm1
8 | ACCOUNT# | ACCOUNT NAME | 33003.84 | 512 | Comm1
1 | ACCOUNT# | ACCOUNT NAME | -126000 | 531 | Recov1
1 | ACCOUNT# | ACCOUNT NAME | -697852.08 | 542 | Recov2
2 | ACCOUNT# | ACCOUNT NAME | -141986.78 | 542 | Recov2
8 | ACCOUNT# | ACCOUNT NAME | -126769.81 | 542 | Recov2
9 | ACCOUNT# | ACCOUNT NAME | -105767.37 | 542 | Recov2
9 | ACCOUNT# | ACCOUNT NAME | -94015.4 | 542 | Recov2
8 | ACCOUNT# | ACCOUNT NAME | -84871.7 | 542 | Recov2
9 | ACCOUNT# | ACCOUNT NAME | -59715 | 542 | Recov2
9 | ACCOUNT# | ACCOUNT NAME | -43497 | 542 | Recov2
7 | ACCOUNT# | ACCOUNT NAME | -41922 | 542 | Recov2
7 | ACCOUNT# | ACCOUNT NAME | -41919 | 542 | Recov2
7 | ACCOUNT# | ACCOUNT NAME | -37264 | 542 | Recov2
2 | ACCOUNT# | ACCOUNT NAME | -31127.25 | 542 | Recov2
8 | ACCOUNT# | ACCOUNT NAME | -30516.96 | 542 | Recov2
8 | ACCOUNT# | ACCOUNT NAME | -30006 | 542 | Recov2
2 | ACCOUNT# | ACCOUNT NAME | -26217 | 542 | Recov2
9 | ACCOUNT# | ACCOUNT NAME | -22482.32 | 542 | Recov2
2 | ACCOUNT# | ACCOUNT NAME | -19646 | 542 | Recov2
2 | ACCOUNT# | ACCOUNT NAME | -18666.64 | 542 | Recov2
8 | ACCOUNT# | ACCOUNT NAME | -16670 | 542 | Recov2
9 | ACCOUNT# | ACCOUNT NAME | -15714 | 542 | Recov2
2 | ACCOUNT# | ACCOUNT NAME | -14463 | 542 | Recov2
7 | ACCOUNT# | ACCOUNT NAME | -13932 | 542 | Recov2
2 | ACCOUNT# | ACCOUNT NAME | -12999.78 | 542 | Recov2
8 | ACCOUNT# | ACCOUNT NAME | -10000 | 542 | Recov2
9 | ACCOUNT# | ACCOUNT NAME | -8751 | 542 | Recov2
8 | ACCOUNT# | ACCOUNT NAME | -4998.2 | 542 | Recov2
8 | ACCOUNT# | ACCOUNT NAME | -3710 | 542 | Recov2
2 | ACCOUNT# | ACCOUNT NAME | -2913 | 542 | Recov2
8 | ACCOUNT# | ACCOUNT NAME | 7578 | 542 | Recov2
8 | ACCOUNT# | ACCOUNT NAME | 15147 | 542 | Recov2
8 | ACCOUNT# | ACCOUNT NAME | 15147 | 542 | Recov2
8 | ACCOUNT# | ACCOUNT NAME | 15147 | 542 | Recov2
8 | ACCOUNT# | ACCOUNT NAME | 15147 | 542 | Recov2
8 | ACCOUNT# | ACCOUNT NAME | 15147 | 542 | Recov2
1 | ACCOUNT# | ACCOUNT NAME | -20000 | 543 | Recov3
1 | ACCOUNT# | ACCOUNT NAME | -4959.97 | 543 | Recov3
1 | ACCOUNT# | ACCOUNT NAME | -2629.6 | 543 | Recov3