Loading...
HomeMy WebLinkAbout20230109INT to Staff Attachment - Response to No. 21_Med clearing 2017.xlsDEC NOV OCT SEP AUG JUL JUN MAY APR MAR FEB JAN Account Number Level Of Detail Account Description General Ledger Period Balance General Ledger Balance Posting Edit Code 48.1840.1000 6 Medical 48.1840.1010 Medical TOP 48.1840.1020 Medical employer 48.1840.1110 Dental TOP 48.1840.1120 Dental employer 48.1840.1210 Vision TOP 48.1840.2020 NCLI 48.1840.2100 Contr Life Employer 48.1840.2200 AD & D employee 48.1840.2300 Spouse Life Employee 48.1840.2400 Dependent Life employee 48.1840.4120 LTD Employer paid 48.1840.ID Idaho Workers Comp Total Object Account 1840 Clear out medical expense clearing 48521.5194.29260 48.1840.4020 EAP Employer paid 48.1840.1100 Dental 48.1840.1200 Vision Run trial balance by object for 1840 export results and copy and past in cells A2 through E17 get the balance for 48521.5194.29260, this is where the payroll medical get expensed all year back it out here and distribute in based on SLD % 48.1840.2220 AD & D Employer paid \480991.0191 48501.5194.29200 48501.5194.68000 48501.5194.69000 48503.5194.28700 48503.5194.28800 48503.5194.28850 48503.5194.29080 48503.5194.29200 48504.5194.29200 48504.5194.68000 48504.5194.69000 48505.5194.29100 48505.5194.29120 48506.5194.28130 48506.5194.29200 48507.5194.29200 48508.5194.28660 48508.5194.28700 48508.5194.28780 48508.5194.28850 48508.5194.28900 48508.5194.28930 48509.5194.28700 48510.5194.28410 48510.5194.28631 48510.5194.28700 48510.5194.28870 48510.5194.28871 48510.5194.29200 48513.5194.28410 48514.5194.29030 48514.5194.29200 48518.5194.29010 48518.5194.29030 48519.5194.29030 48520.5194.29120 48521.5194.29200 48521.5194.68000 48527.5194.29200 48533.5194.28700 48533.5194.28800 48534.5194.28740 48534.5194.28750 48534.5194.28790 48534.5194.28870 48534.5194.28871 48534.5194.28920 48534.5194.28930 48534.5194.29020 48534.5194.29030 48535.5194.28750 48535.5194.28780 48535.5194.28790 48535.5194.28800 48535.5194.28870 48535.5194.28920 48535.5194.29020 48535.5194.29120 48536.5194.28631 48536.5194.28700 48536.5194.28740 48536.5194.28760 48536.5194.28790 48536.5194.28800 48536.5194.28870 48536.5194.28890 48536.5194.28900 48536.5194.28920 48536.5194.29030 48536.5194.29250 48538.5194.28700 48538.5194.28740 48538.5194.28750 48538.5194.28790 48538.5194.28800 48538.5194.28870 48538.5194.28871 48538.5194.28920 48538.5194.28930 48538.5194.29020 48538.5194.29030 48538.5194.29120 48538.5194.29250 48539.5194.28700 48539.5194.28740 48539.5194.28750 48539.5194.28760 48539.5194.28790 48539.5194.28800 48539.5194.28870 48539.5194.28890 48539.5194.28900 48539.5194.28920 48539.5194.29250 48541.5194.28700 48541.5194.28800 48542.5194.28630 48542.5194.28700 48542.5194.28740 48542.5194.28780 48542.5194.28790 48542.5194.28800 48542.5194.28870 48542.5194.28890 48542.5194.28920 48542.5194.29020 48542.5194.29030 48542.5194.29120 48542.5194.29250 48543.5194.28560 48543.5194.28630 48543.5194.28631 48543.5194.28700 48543.5194.28740 48543.5194.28760 48543.5194.28870 48543.5194.28890 48543.5194.28900 48543.5194.28920 48545.5194.28740 48545.5194.28750 48545.5194.28780 48545.5194.28790 48545.5194.28870 48545.5194.28920 48545.5194.29020 48545.5194.29030 48545.5194.29250 48546.5194.28700 48546.5194.28740 48546.5194.28780 48546.5194.28790 48546.5194.28800 48546.5194.28870 48546.5194.28920 48546.5194.29020 48546.5194.29030 48546.5194.29120 48546.5194.29250 48547.5194.28630 48547.5194.28631 48547.5194.28700 48547.5194.28740 48547.5194.28760 48547.5194.28790 48547.5194.28800 48547.5194.28870 48547.5194.28890 48547.5194.28900 48547.5194.28920 48549.5194.28436 48550.5194.28700 48550.5194.28740 48550.5194.28780 48550.5194.28790 48550.5194.28870 48550.5194.28890 48550.5194.28900 48550.5194.28920 48550.5194.29250 48552.5194.28700 48552.5194.28740 48552.5194.28780 48552.5194.28790 48552.5194.28800 48552.5194.28870 48552.5194.28871 48552.5194.28920 48552.5194.29020 48552.5194.29030 48552.5194.29120 48552.5194.29250 48553.5194.28700 48553.5194.28740 48553.5194.28780 48553.5194.28790 48553.5194.28800 48553.5194.28870 48553.5194.28920 48553.5194.28930 48553.5194.29020 48553.5194.29030 48572.5194.29030 2017 Medical Clearing -41.55 -761.52 -27771.56 -248757.07 142076.00 491920.10 -23.55 -204.10 -10479.37 -91781.84 9531.14 97321.87 -1234.87 927.22 8157.15 96902.29 -8087.91 -71563.19 -301.04 -38.72 ?12?/?31?/?2017 -2849.28 -24626.09 $2,900.00 -81.06 -705.74 -499.06 -7429.93 3407.31 1470.08 -12779.32 11856.68 48.1840.1000 761.52 48.1840.1010 248757.07 48.1840.1020 -491920.10 48.1840.1100 204.10 48.1840.1110 91781.84 761.52 48.1840.1120 -97321.87 248757.07 48.1840.1210 -927.22 -491920.10 48.1840.2020 -96902.29 204.10 48.1840.2100 71563.19 91781.84 48.1840.2200 38.72 -97321.87 48.1840.2300 24626.09 -927.22 48.1840.2400 705.74 -96902.29 48.1840.4020 7429.93 71563.19 48.1840.4120 -1470.08 38.72 -2900.00 24626.09 705.74 7429.93 ($245,573.36) -1470.08 -2900.00 48501.5194.29200 $1,395.18 5.68E-03 $1,395.18 2.00 48501.5194.68000 $13.06 5.32E-05 $13.06 48501.5194.69000 $8.13 3.31E-05 $8.13 48503.5194.28700 $1,352.32 5.51E-03 $1,352.32 48503.5194.28800 $609.60 2.48E-03 $609.60 48503.5194.28850 $303.18 1.24E-03 $303.18 48503.5194.29080 $314.03 1.28E-03 $314.03 48503.5194.29200 $3,177.29 0.01 $3,177.29 48504.5194.29200 $2,808.72 0.01 $2,808.72 48504.5194.68000 $14.50 5.91E-05 $14.50 48504.5194.69000 $6.78 2.76E-05 $6.78 48505.5194.29100 $280.78 1.14E-03 $280.78 48505.5194.29120 $960.58 3.91E-03 $960.58 48506.5194.28130 $1,544.31 6.29E-03 $1,544.31 48506.5194.29200 $931.02 3.79E-03 $931.02 48507.5194.29200 $979.05 3.99E-03 $979.05 48508.5194.28660 $1,764.03 7.18E-03 $1,764.03 48508.5194.28700 $67.46 2.75E-04 $67.46 48508.5194.28780 $2.52 1.03E-05 $2.52 48508.5194.28850 $1,417.39 5.77E-03 $1,417.39 48508.5194.28900 $33.63 1.37E-04 $33.63 48508.5194.28930 $3,022.24 0.01 $3,022.24 48509.5194.28700 $2,431.44 9.90E-03 $2,431.44 48510.5194.28410 $34.46 1.40E-04 $34.46 48510.5194.28631 $49.88 2.03E-04 $49.88 48510.5194.28700 $1,359.88 5.54E-03 $1,359.88 48510.5194.28870 $51.11 2.08E-04 $51.11 48510.5194.28871 $64.19 2.61E-04 $64.19 48510.5194.29200 $466.90 1.90E-03 $466.90 48513.5194.28410 $3,583.46 0.01 $3,583.46 48514.5194.29030 $7.39 3.01E-05 $7.39 48514.5194.29200 $6,858.19 0.03 $6,858.19 48518.5194.29010 $969.81 3.95E-03 $969.81 48518.5194.29030 $8,228.70 0.03 $8,228.70 48519.5194.29030 $29.56 1.20E-04 $29.56 48520.5194.29120 $665.01 2.71E-03 $665.01 48521.5194.29200 $3,542.85 0.01 $3,542.85 48521.5194.29260 $0.00 0.00 $0.00 48521.5194.68000 $16.81 6.85E-05 $16.81 48527.5194.29200 $399.51 1.63E-03 $399.51 48533.5194.28700 $295.56 1.20E-03 $295.56 48533.5194.28800 $665.01 2.71E-03 $665.01 48534.5194.28740 $340.36 1.39E-03 $340.36 48534.5194.28750 $107.95 4.40E-04 $107.95 48534.5194.28790 $21,222.35 0.09 $21,222.35 48534.5194.28870 $86.64 3.53E-04 $86.64 48534.5194.28871 $72.04 2.93E-04 $72.04 48534.5194.28920 $632.83 2.58E-03 $632.83 48534.5194.28930 $774.35 3.15E-03 $774.35 48534.5194.29020 $575.42 2.34E-03 $575.42 48534.5194.29030 $361.20 1.47E-03 $361.20 48535.5194.28750 $4.04 1.65E-05 $4.04 48535.5194.28780 $40.54 1.65E-04 $40.54 48535.5194.28790 $108.99 4.44E-04 $108.99 48535.5194.28800 $1,410.77 5.75E-03 $1,410.77 48535.5194.28870 $15.70 6.39E-05 $15.70 48535.5194.28920 $2,785.44 0.01 $2,785.44 48535.5194.29020 $4,143.45 0.02 $4,143.45 48535.5194.29120 $1,939.62 7.90E-03 $1,939.62 48536.5194.28631 $2.31 9.40E-06 $2.31 48536.5194.28700 $4,712.11 0.02 $4,712.11 48536.5194.28740 $4,313.10 0.02 $4,313.10 48536.5194.28760 $55.35 2.25E-04 $55.35 48536.5194.28790 $22.17 9.03E-05 $22.17 48536.5194.28800 $1,053.25 4.29E-03 $1,053.25 48536.5194.28870 $1,965.98 8.01E-03 $1,965.98 48536.5194.28890 $244.18 9.94E-04 $244.18 48536.5194.28900 $764.72 3.11E-03 $764.72 48536.5194.28920 $1,950.14 7.94E-03 $1,950.14 48536.5194.29030 $20.91 8.51E-05 $20.91 48536.5194.29250 $60.73 2.47E-04 $60.73 48538.5194.28700 $245.32 9.99E-04 $245.32 48538.5194.28740 $735.44 3.00E-03 $735.44 48538.5194.28750 $100.21 4.08E-04 $100.21 48538.5194.28790 $11,485.03 0.05 $11,485.03 48538.5194.28800 $786.20 3.20E-03 $786.20 48538.5194.28870 $384.47 1.57E-03 $384.47 48538.5194.28871 $99.64 4.06E-04 $99.64 48538.5194.28920 $1,058.14 4.31E-03 $1,058.14 48538.5194.28930 $247.65 1.01E-03 $247.65 48538.5194.29020 $465.86 1.90E-03 $465.86 48538.5194.29030 $2,310.90 9.41E-03 $2,310.90 48538.5194.29120 $886.69 3.61E-03 $886.69 48538.5194.29250 $57.03 2.32E-04 $57.03 48539.5194.28700 $2,066.49 8.42E-03 $2,066.49 48539.5194.28740 $2,880.03 0.01 $2,880.03 48539.5194.28750 $104.83 4.27E-04 $104.83 48539.5194.28760 $121.52 4.95E-04 $121.52 48539.5194.28790 $0.00 0.00 $0.00 48539.5194.28800 $1,312.41 5.34E-03 $1,312.41 48539.5194.28870 $1,530.36 6.23E-03 $1,530.36 48539.5194.28890 $97.92 3.99E-04 $97.92 48539.5194.28900 $766.97 3.12E-03 $766.97 48539.5194.28920 $1,594.85 6.49E-03 $1,594.85 48539.5194.29250 $137.85 5.61E-04 $137.85 48541.5194.28700 $306.65 1.25E-03 $306.65 48541.5194.28800 $665.01 2.71E-03 $665.01 48542.5194.28630 $20.55 8.37E-05 $20.55 48542.5194.28700 $382.23 1.56E-03 $382.23 48542.5194.28740 $445.07 1.81E-03 $445.07 48542.5194.28780 $225.37 9.18E-04 $225.37 48542.5194.28790 $7,057.04 0.03 $7,057.04 48542.5194.28800 $1,530.33 6.23E-03 $1,530.33 48542.5194.28870 $0.23 9.40E-07 $0.23 48542.5194.28890 $9.24 3.76E-05 $9.24 48542.5194.28920 $57.32 2.33E-04 $57.32 48542.5194.29020 $230.68 9.39E-04 $230.68 48542.5194.29030 $2,062.75 8.40E-03 $2,062.75 48542.5194.29120 $1,638.52 6.67E-03 $1,638.52 48542.5194.29250 $10.62 4.33E-05 $10.62 48543.5194.28560 $10.62 4.33E-05 $10.62 48543.5194.28630 $105.76 4.31E-04 $105.76 48543.5194.28631 $107.14 4.36E-04 $107.14 48543.5194.28700 $1,844.99 7.51E-03 $1,844.99 2.00 48543.5194.28740 $2,874.02 0.01 $2,874.02 48543.5194.28760 $25.69 1.05E-04 $25.69 48543.5194.28870 $869.46 3.54E-03 $869.46 48543.5194.28890 $231.11 9.41E-04 $231.11 48543.5194.28900 $755.07 3.08E-03 $755.07 48543.5194.28920 $561.80 2.29E-03 $561.80 48545.5194.28740 $308.03 1.25E-03 $308.03 48545.5194.28750 $0.46 1.88E-06 $0.46 48545.5194.28780 $62.35 2.54E-04 $62.35 48545.5194.28790 $2,890.73 0.01 $2,890.73 48545.5194.28870 $6.93 2.82E-05 $6.93 48545.5194.28920 $87.05 3.55E-04 $87.05 48545.5194.29020 $15.01 6.11E-05 $15.01 48545.5194.29030 $7.62 3.10E-05 $7.62 48545.5194.29250 $0.92 3.76E-06 $0.92 48546.5194.28700 $298.24 1.21E-03 $298.24 48546.5194.28740 $2,508.12 0.01 $2,508.12 48546.5194.28780 $3,566.60 0.01 $3,566.60 48546.5194.28790 $5,316.83 0.02 $5,316.83 48546.5194.28800 $703.44 2.86E-03 $703.44 48546.5194.28870 $153.27 6.24E-04 $153.27 48546.5194.28920 $397.18 1.62E-03 $397.18 48546.5194.29020 $65.58 2.67E-04 $65.58 48546.5194.29030 $3,069.76 0.01 $3,069.76 48546.5194.29120 $1,212.73 4.94E-03 $1,212.73 48546.5194.29250 $29.33 1.19E-04 $29.33 48547.5194.28630 $7.39 3.01E-05 $7.39 48547.5194.28631 $34.41 1.40E-04 $34.41 48547.5194.28700 $2,965.15 0.01 $2,965.15 48547.5194.28740 $2,270.49 9.25E-03 $2,270.49 48547.5194.28760 $83.58 3.40E-04 $83.58 48547.5194.28790 $251.23 1.02E-03 $251.23 48547.5194.28800 $20.69 8.43E-05 $20.69 48547.5194.28870 $1,169.35 4.76E-03 $1,169.35 48547.5194.28890 $553.84 2.26E-03 $553.84 48547.5194.28900 $346.48 1.41E-03 $346.48 48547.5194.28920 $1,475.86 6.01E-03 $1,475.86 48549.5194.28436 $722.16 2.94E-03 $722.16 48550.5194.28700 $2,067.15 8.42E-03 $2,067.15 48550.5194.28740 $2,151.00 8.76E-03 $2,151.00 48550.5194.28780 $90.75 3.70E-04 $90.75 48550.5194.28790 $8.31 3.39E-05 $8.31 48550.5194.28870 $1,279.85 5.21E-03 $1,279.85 48550.5194.28890 $680.48 2.77E-03 $680.48 48550.5194.28900 $385.38 1.57E-03 $385.38 48550.5194.28920 $1,015.98 4.14E-03 $1,015.98 48550.5194.29250 $40.87 1.66E-04 $40.87 48552.5194.28700 $274.87 1.12E-03 $274.87 48552.5194.28740 $2,319.81 9.45E-03 $2,319.81 48552.5194.28780 $1,765.93 7.19E-03 $1,765.93 48552.5194.28790 $5,167.42 0.02 $5,167.42 48552.5194.28800 $685.70 2.79E-03 $685.70 48552.5194.28870 $10.39 4.23E-05 $10.39 48552.5194.28871 $74.81 3.05E-04 $74.81 48552.5194.28920 $202.18 8.23E-04 $202.18 48552.5194.29020 $1,127.35 4.59E-03 $1,127.35 48552.5194.29030 $3,175.83 0.01 $3,175.83 48552.5194.29120 $960.58 3.91E-03 $960.58 48552.5194.29250 $29.44 1.20E-04 $29.44 48553.5194.28700 $304.80 1.24E-03 $304.80 48553.5194.28740 $1,321.72 5.38E-03 $1,321.72 48553.5194.28780 $519.54 2.12E-03 $519.54 48553.5194.28790 $2,632.19 0.01 $2,632.19 48553.5194.28800 $665.01 2.71E-03 $665.01 48553.5194.28870 $0.92 3.76E-06 $0.92 48553.5194.28920 $1.85 7.52E-06 $1.85 48553.5194.28930 $13.05 5.31E-05 $13.05 48553.5194.29020 $110.37 4.50E-04 $110.37 48553.5194.29030 $23.94 9.75E-05 $23.94 48572.5194.29030 $0.00 0.00 $0.00 \480991.0191 $33,849.84 0.14 $33,849.84 2.00 0.01 0.00 $0.00 1.75E-10 $245,573.36 -935.49 -935.49 -32810.32 -32810.32 143235.63 143235.63 -21.24 -21.24 -7098.54 -7098.54 -11250.27 -11250.27 -12.00 -12.00 -3056.40 -3056.40 -3336.67 -3336.67 -5146.12 -5146.12 -644.73 -644.73 -1594.98 -1594.98 -43.12 -43.12 -4385.88 -4385.88 -4323.26 -4323.26 -16089.31 15143.83 48.1840.1000 935.49 48.1840.1010 32810.32 48.1840.1020 -143235.63 48.1840.1100 21.24 48.1840.1110 7098.54 48.1840.1120 11250.27 48.1840.1200 12.00 48.1840.1210 3056.40 48.1840.2020 3336.67 48.1840.2100 5146.12 48.1840.2200 644.73 48.1840.2300 1594.98 48.1840.2400 43.12 48.1840.4020 4385.88 48.1840.4120 4323.26 68576.61 -703.49 -703.49 -32043.70 -32043.70 72952.86 72952.86 -21.24 -21.24 -7051.62 -7051.62 -11845.78 -11845.78 -12.00 -12.00 -3054.02 -3054.02 -3495.40 -3495.40 -5142.43 -5142.43 -643.57 -643.57 -1565.44 -1565.44 -43.12 -43.12 -4584.56 -4584.56 -4591.71 -4591.71 -16397.08 31233.14 48.1840.1000 703.49 48.1840.1010 32043.70 48.1840.1020 -72952.86 48.1840.1100 21.24 48.1840.1110 7051.62 48.1840.1120 11845.78 48.1840.1200 12.00 48.1840.1210 3054.02 48.1840.2020 3495.40 48.1840.2100 5142.43 48.1840.2200 643.57 48.1840.2300 1565.44 48.1840.2400 43.12 48.1840.4020 4584.56 48.1840.4120 4591.71 -1845.22 -703.49 -703.49 -32006.31 -32006.31 75145.20 75145.20 -21.24 -21.24 -7063.62 -7063.62 -11861.66 -11861.66 -12.00 -12.00 -3049.40 -3049.40 -3497.13 -3497.13 -5128.59 -5128.59 -643.56 -643.56 -1528.05 -1528.05 -43.68 -43.68 -4515.28 -4515.28 -4512.20 -4512.20 -15988.92 -32106.98 ($15,429.93) ($31,547.99) 48.1840.1000 703.49 48.1840.1010 32006.31 48.1840.1020 -75145.20 48.1840.1100 21.24 48.1840.1110 7063.62 48.1840.1120 11861.66 48.1840.1200 12.00 48.1840.1210 3049.40 48.1840.2020 3497.13 48.1840.2100 5128.59 48.1840.2200 643.56 48.1840.2300 1528.05 48.1840.2400 43.68 48.1840.4020 4515.28 48.1840.4120 4512.20 558.99 -703.49 -703.49 -31859.62 -31859.62 81283.02 81283.02 -21.24 -21.24 -7018.94 -7018.94 -11310.54 -11310.54 -12.00 -12.00 -3060.16 -3060.16 -3360.71 -3360.71 -5150.28 -5150.28 -645.87 -645.87 -1532.45 -1532.45 -43.68 -43.68 -4322.36 -4322.36 -4425.76 -4425.76 -15410.31 -16118.06 -7594.39 -8302.14 48.1840.1000 703.49 48.1840.1010 31859.62 48.1840.1020 -81283.02 48.1840.1100 21.24 48.1840.1110 7018.94 48.1840.1120 11310.54 48.1840.1200 12.00 48.1840.1210 3060.16 48.1840.2020 3360.71 48.1840.2100 5150.28 48.1840.2200 645.87 48.1840.2300 1532.45 48.1840.2400 43.68 48.1840.4020 4322.36 48.1840.4120 4425.76 7815.92 -240.00 -240.00 -50241.89 -50241.89 79709.43 104449.43 -10795.09 -10795.09 -11673.04 -11673.04 -4664.72 -4664.72 -1632.58 -1632.58 -7740.51 -7740.51 -1023.48 -1023.48 -2442.14 -2442.14 -77.84 -77.84 -3584.30 -3584.30 -4834.03 -4834.03 -14098.44 21208.58 -33338.63 26708.39 48.1840.1000 240.00 48.1840.1010 50241.89 48.1840.1020 -104449.43 48.1840.1110 10795.09 48.1840.1120 11673.04 48.1840.1210 4664.72 48.1840.2020 1632.58 48.1840.2100 7740.51 48.1840.2200 1023.48 48.1840.2300 2442.14 48.1840.2400 77.84 48.1840.4020 3584.30 48.1840.4120 4834.03 5499.81 -338.31 -338.31 -33535.46 -33535.46 71031.59 71031.59 -10.62 -10.62 -7189.44 -7189.44 -12201.75 -12201.75 -6.00 -6.00 -3112.24 -3112.24 -1708.60 -1708.60 -5123.24 -5123.24 -681.16 -681.16 -1639.57 -1639.57 -50.68 -50.68 -3738.81 -3738.81 -5084.18 -5084.18 15798.89 35307.02 48.1840.1000 338.31 48.1840.1010 33535.46 48.1840.1020 -71031.59 48.1840.1100 10.62 48.1840.1110 7189.44 48.1840.1120 12201.75 48.1840.1200 6.00 48.1840.1210 3112.24 48.1840.2020 1708.60 48.1840.2100 5123.24 48.1840.2200 681.16 48.1840.2300 1639.57 48.1840.2400 50.68 48.1840.4020 3738.81 48.1840.4120 5084.18 -3388.47 ($436.62) ($436.62) ($33,541.01) ($33,541.01) $70,821.81 $70,821.81 ($21.24) ($21.24) ($7,149.83) ($7,149.83) ($12,208.94) ($12,208.94) ($12.00) ($12.00) ($3,116.86) ($3,116.86) ($1,721.35) ($1,721.35) ($5,143.68) ($5,143.68) ($675.39) ($675.39) ($1,631.08) ($1,631.08) ($49.56) ($49.56) ($3,763.32) ($3,763.32) ($5,187.95) ($5,187.95) ($14,776.66) $19,508.13 ($18,613.68) $15,671.11 48.1840.1000 $436.62 48.1840.1010 $33,541.01 48.1840.1020 ($70,821.81) 48.1840.1100 $21.24 48.1840.1110 $7,149.83 48.1840.1120 $12,208.94 48.1840.1200 $12.00 48.1840.1210 $3,116.86 48.1840.2020 $1,721.35 48.1840.2100 $5,143.68 48.1840.2200 $675.39 48.1840.2300 $1,631.08 48.1840.2400 $49.56 48.1840.4020 $3,763.32 48.1840.4120 $5,187.95 ($3,837.02) -800.62 -800.62 -33546.55 -33546.55 81600.81 81600.81 -21.24 -21.24 -7166.44 -7166.44 -11639.12 -11639.12 -12.00 -12.00 -3100.24 -3100.24 -1622.74 -1622.74 -5113.46 -5113.46 -670.78 -670.78 -1624.34 -1624.34 -49.56 -49.56 -3558.70 -3558.70 -4916.96 -4916.96 -13761.33 34284.79 -6003.27 42042.85 48.1840.1000 800.62 48.1840.1010 33546.55 48.1840.1020 -81600.81 48.1840.1100 21.24 48.1840.1110 7166.44 48.1840.1120 11639.12 48.1840.1200 12.00 48.1840.1210 3100.24 48.1840.2020 1622.74 48.1840.2100 5113.46 48.1840.2200 670.78 48.1840.2300 1624.34 48.1840.2400 49.56 48.1840.4020 3558.70 48.1840.4120 4916.96 7758.06 -800.62 -1404.62 -33465.30 -33465.30 64851.32 64851.32 -21.24 -21.24 -7179.36 -7179.36 -12789.68 -12789.68 -12.00 -12.00 -3100.24 -3100.24 -1789.40 -1789.40 -5197.46 -5197.46 -675.40 -675.40 -1624.34 -1624.34 -49.56 -49.56 -3882.10 -3882.10 -5363.57 -5363.57 -15400.44 17618.92 48.1840.1000 1404.62 48.1840.1010 33465.30 48.1840.1020 -64851.32 48.1840.1100 21.24 48.1840.1110 7179.36 48.1840.1120 12789.68 48.1840.1200 12.00 48.1840.1210 3100.24 48.1840.2020 1789.40 48.1840.2100 5197.46 48.1840.2200 675.40 48.1840.2300 1624.34 48.1840.2400 49.56 48.1840.4020 3882.10 48.1840.4120 5363.57 -11702.95 ($196.62) ($800.62) ($33,247.92) ($33,247.92) $82,612.54 $82,612.54 ($21.24) ($21.24) ($7,880.04) ($7,880.04) ($11,604.42) ($11,604.42) ($12.00) ($12.00) ($3,097.00) ($3,097.00) ($1,635.69) ($1,635.69) ($5,143.30) ($5,143.30) ($669.63) ($669.63) ($1,604.60) ($1,604.60) ($48.16) ($48.16) ($3,556.73) ($3,556.73) ($4,914.08) ($4,914.08) ($14,028.25) $33,085.36 ($5,047.14) $41,462.47 48.1840.1000 800.62 48.1840.1010 33247.92 48.1840.1020 -82612.54 48.1840.1100 21.24 48.1840.1110 7880.04 48.1840.1120 11604.42 48.1840.1200 12.00 48.1840.1210 3097.00 48.1840.2020 1635.69 48.1840.2100 5143.30 48.1840.2200 669.63 48.1840.2300 1604.60 48.1840.2400 48.16 48.1840.4020 3556.73 48.1840.4120 4914.08 8377.11 ($196.62) ($196.62) ($33,600.53) ($33,600.53) $49,331.13 $49,331.13 ($21.24) ($21.24) ($7,171.05) ($7,171.05) ($13,866.25) ($13,866.25) ($12.00) ($12.00) ($3,105.76) ($3,105.76) ($1,947.59) ($1,947.59) ($5,145.01) ($5,145.01) ($670.78) ($670.78) $0.00 $0.00 ($1,608.80) ($1,608.80) ($47.60) ($47.60) ($4,662.04) ($4,662.04) ($5,836.03) ($5,836.03) ($13,806.79) ($13,806.79) ($42,366.96) ($42,366.96) 48.1840.1000 196.62 48.1840.1010 33600.53 48.1840.1020 -49331.13 48.1840.1100 21.24 48.1840.1110 7171.05 48.1840.1120 13866.25 48.1840.1200 12.00 48.1840.1210 3105.76 48.1840.2020 1947.59 48.1840.2100 5145.01 48.1840.2200 670.78 48.1840.2220 0.00 48.1840.2300 1608.80 48.1840.2400 47.60 48.1840.4020 4662.04 48.1840.4120 5836.03 -28560.17