Loading...
HomeMy WebLinkAbout20050211Property & Payroll Tax.xlsSummary Other Payroll Tax TY GL Detail Futa TY GL Detail SUTA TY GL Detail FICA TY GL Detail Prop Tax NvsParentRef Journal Date Line # Acct DeptID Act C Type Amount Line Descr R005 PAY0170849 S301 RCLS027 CP011504 PAY0173378 2004-01-01 2004-01-15 2004-02-15 2004-02-01 408130 408131 408134 408120 408139 1412 1411 097 Payroll Taxes:FICA Employer Payroll Taxes:SUI Employer Payroll Taxes:FUI Employer Real Estate Tax Payroll Taxes PAY0175250 2004-03-01 2004-03-15 PAY0177267 2004-04-01 2004-04-15 PAY0179798 2004-05-15 2004-05-01 AP00180881 AP00180882 PAY0181755 PAY0183762 2004-06-15 2004-06-01 2004-06-02 2004-06-03 2004-07-01 2004-07-15 400 2ND HALF OF PROPERTY TAXES 2ND HALF OF PROPERTY TAX 2003-08-15 2003-08-01 PAY0161537 2003-09-15 2003-09-01 PAY0163202 2003-10-15 2003-10-01 PAY0165035 2003-11-01 AP00166042 irrigation tax levy PAY0166755 2003-11-15 2003-12-01 AP00168142 2003-12-04 prop taxes AP00168623 2003-12-10 BOISE KUNA 133005 PROP TAX PAY0169067 2003-12-15 2003-12-31 Month/Date 2003-08 Total 2003-09 Total 2003-10 Total 2003-11 Total 2003-12 Total 2004-01 Total 2004-02 Total 2004-03 Total 2004-04 Total 2004-05 Total 2004-06 Total 2004-07 Total Grand Total PAY0161537 Total PAY0163202 Total PAY0165035 Total PAY0166755 Total PAY0169067 Total PAY0170849 Total PAY0173378 Total PAY0175250 Total PAY0177267 Total PAY0179798 Total PAY0181755 Total PAY0183762 Total CP011504 Total United Water Idaho Test Year Ended July, 2004 Summary of Accounts 408120, 408130, 408131, 408134 & 408139 Property Taxes & Payroll Taxes Month Property Taxes FICA Taxes SUTA Taxes Futa Taxes Payroll Taxes Other Total Payroll Taxes 408120.00 408130.00 408131.00 408134.00 408139.00 ?8?/?1?/?2003 120725.00 23465.76 281.16 15.36 23762.28 144487.28 ?9?/?1?/?2003 120725.00 22969.53 205.07 2.90 23177.50 143902.50 ?10?/?1?/?2003 120725.00 24535.23 68.17 0.00 24603.40 145328.40 ?11?/?1?/?2003 121269.09 25610.21 53.23 0.00 25663.44 146932.53 ?12?/?1?/?2003 121238.11 26917.74 51.14 16.66 26985.54 148223.65 ?1?/?1?/?2004 132707.80 22558.26 315.11 1190.89 227.30 24291.56 156999.36 ?2?/?1?/?2004 132750.00 30491.18 924.48 3092.16 34507.82 167257.82 ?3?/?1?/?2004 132750.00 35015.91 793.59 483.47 36292.97 169042.97 ?4?/?1?/?2004 132750.00 28027.67 580.31 69.07 28677.05 161427.05 ?5?/?1?/?2004 132750.00 22927.25 519.29 54.79 23501.33 156251.33 ?6?/?1?/?2004 144205.68 24732.25 496.89 96.13 25325.27 169530.95 ?7?/?1?/?2004 116100.00 24669.39 445.39 91.39 25206.17 141306.17 1528695.68 311920.38 4733.83 5112.82 227.30 321994.33 1850690.01 9.00 - -0 2004-01 172.00 9.00 - -0 2004-01 55.30 227.30 9.00 227.30 9.00 9.00 - -0 2003-08 7.68 9.00 - -0 2003-08 7.68 15.36 9.00 0.00 9.00 9.00 - -0 2003-09 2.90 2.90 9.00 0.00 9.00 9.00 - -0 2003-12 6.64 9.00 - -0 2003-12 6.84 9.00 - -0 2003-12 3.18 16.66 9.00 0.00 9.00 2004-01 37.78 2004-01 33.75 2004-01 185.89 2004-01 131.87 2004-01 76.72 2004-01 33.89 2004-01 6.60 2004-01 317.19 2004-01 65.73 2004-01 53.51 2004-01 247.96 1190.89 9.00 0.00 9.00 2004-02 225.22 2004-02 295.78 2004-02 61.87 2004-02 52.32 2004-02 224.68 2004-02 294.93 2004-02 61.39 2004-02 52.65 2004-02 178.40 2004-02 277.17 2004-02 61.76 2004-02 52.65 2004-02 37.78 2004-02 33.75 2004-02 197.36 2004-02 130.56 2004-02 123.35 2004-02 32.89 2004-02 14.47 2004-02 30.53 2004-02 33.41 2004-02 152.06 2004-02 135.53 2004-02 21.81 2004-02 32.89 2004-02 5.90 2004-02 11.09 2004-02 96.29 2004-02 117.64 2004-02 13.14 2004-02 32.89 3092.16 9.00 0.00 9.00 2004-03 2.62 2004-03 63.16 2004-03 8.34 2004-03 8.14 2004-03 72.87 2004-03 6.38 2004-03 25.24 2004-03 110.30 2004-03 3.46 2004-03 22.58 2004-03 18.72 2004-03 46.76 2004-03 29.26 2004-03 39.70 2004-03 0.99 2004-03 0.18 2004-03 7.20 2004-03 17.57 483.47 9.00 0.00 9.00 2004-04 4.39 2004-04 9.39 2004-04 0.73 2004-04 38.43 2004-04 4.02 2004-04 9.87 2004-04 2.24 69.07 9.00 0.00 9.00 2004-05 2.44 2004-05 3.63 2004-05 2.44 2004-05 6.34 2004-05 9.63 2004-05 10.63 2004-05 8.92 2004-05 10.76 54.79 9.00 0.00 9.00 2004-06 2.80 2004-06 2.76 2004-06 15.59 2004-06 17.84 2004-06 10.37 2004-06 19.53 2004-06 17.05 2004-06 10.19 96.13 9.00 0.00 9.00 2004-07 3.29 2004-07 6.48 2004-07 3.59 2004-07 20.11 2004-07 18.07 2004-07 5.66 2004-07 16.68 2004-07 17.51 91.39 9.00 0.00 9.00 5112.82 9.00 0.00 9.00 2003-08 0.65 2003-08 4.68 2003-08 28.38 2003-08 12.61 2003-08 8.27 2003-08 14.21 2003-08 28.30 2003-08 8.84 2003-08 5.56 2003-08 11.12 2003-08 19.96 2003-08 57.65 2003-08 15.54 2003-08 13.22 2003-08 8.88 2003-08 27.83 2003-08 15.46 281.16 9.00 0.00 9.00 2003-09 13.88 2003-09 25.94 2003-09 4.10 2003-09 4.86 2003-09 8.13 2003-09 23.96 2003-09 2.85 2003-09 4.86 2003-09 4.82 2003-09 23.18 2003-09 4.86 2003-09 9.87 2003-09 3.22 2003-09 12.05 2003-09 5.67 2003-09 7.04 2003-09 0.83 2003-09 8.55 2003-09 2.59 2003-09 6.94 2003-09 5.02 2003-09 14.02 2003-09 7.83 205.07 9.00 0.00 9.00 2003-10 2.05 2003-10 20.69 2003-10 4.07 2003-10 2.05 2003-10 18.51 2003-10 2.38 2003-10 3.67 2003-10 7.43 2003-10 7.32 68.17 9.00 0.00 9.00 2003-11 2.05 2003-11 17.93 2003-11 2.13 2003-11 2.05 2003-11 17.39 2003-11 2.13 2003-11 6.81 2003-11 2.74 53.23 9.00 0.00 9.00 2003-12 2.05 2003-12 17.36 2003-12 2.13 2003-12 1.85 2003-12 16.95 2003-12 1.95 2003-12 2.32 2003-12 2.07 2003-12 2.39 2003-12 2.07 51.14 9.00 0.00 9.00 2004-01 9.45 2004-01 8.43 2004-01 46.45 2004-01 32.96 2004-01 19.18 2004-01 8.47 2004-01 2.05 2004-01 13.96 2004-01 61.99 2004-01 79.32 2004-01 16.44 2004-01 13.38 2004-01 0.96 2004-01 2.07 315.11 9.00 0.00 9.00 2004-02 56.32 2004-02 73.94 2004-02 15.48 2004-02 13.08 2004-02 56.17 2004-02 73.74 2004-02 15.36 2004-02 13.16 2004-02 55.47 2004-02 75.52 2004-02 15.44 2004-02 13.16 2004-02 32.62 2004-02 74.19 2004-02 8.22 2004-02 3.62 2004-02 9.45 2004-02 8.43 2004-02 49.02 2004-02 34.30 2004-02 33.72 2004-02 8.22 2004-02 9.45 2004-02 8.43 2004-02 48.99 2004-02 34.20 2004-02 9.20 2004-02 8.22 2004-02 9.45 2004-02 8.43 2004-02 49.48 924.48 9.00 0.00 9.00 2004-03 9.45 2004-03 8.43 2004-03 48.99 2004-03 34.17 2004-03 9.20 2004-03 8.54 2004-03 26.95 2004-03 20.49 2004-03 103.75 2004-03 36.94 2004-03 24.32 2004-03 13.53 2004-03 9.45 2004-03 8.43 2004-03 36.63 2004-03 34.08 2004-03 8.95 2004-03 6.75 2004-03 55.13 2004-03 74.29 2004-03 15.36 2004-03 13.88 2004-03 9.60 2004-03 13.20 2004-03 3.00 2004-03 3.00 2004-03 55.43 2004-03 72.80 2004-03 15.54 2004-03 13.31 793.59 9.00 0.00 9.00 2004-04 103.75 2004-04 24.60 2004-04 17.04 2004-04 15.59 2004-04 13.87 2004-04 84.25 2004-04 56.76 2004-04 74.05 2004-04 6.39 2004-04 8.43 2004-04 36.63 2004-04 34.09 2004-04 3.28 2004-04 7.10 2004-04 4.31 2004-04 8.70 2004-04 37.62 2004-04 33.59 2004-04 3.41 2004-04 6.85 580.31 9.00 0.00 9.00 2004-05 4.31 2004-05 6.16 2004-05 37.62 2004-05 32.95 2004-05 3.41 2004-05 6.90 2004-05 4.31 2004-05 3.86 2004-05 37.24 2004-05 28.46 2004-05 3.41 2004-05 6.90 2004-05 59.24 2004-05 80.14 2004-05 18.28 2004-05 13.89 2004-05 60.85 2004-05 78.79 2004-05 18.73 2004-05 13.84 519.29 9.00 0.00 9.00 2004-06 6.98 2004-06 4.31 2004-06 3.86 2004-06 30.95 2004-06 28.64 2004-06 3.41 2004-06 6.99 2004-06 3.17 2004-06 3.86 2004-06 23.97 2004-06 28.52 2004-06 3.41 2004-06 61.38 2004-06 84.55 2004-06 15.37 2004-06 14.14 2004-06 64.20 2004-06 79.95 2004-06 15.33 2004-06 13.90 496.89 9.00 0.00 9.00 2004-07 3.86 2004-07 21.67 2004-07 28.51 2004-07 3.41 2004-07 7.11 2004-07 0.54 2004-07 10.23 2004-07 30.40 2004-07 3.41 2004-07 4.59 2004-07 61.21 2004-07 79.77 2004-07 15.80 2004-07 13.96 2004-07 56.47 2004-07 74.70 2004-07 15.46 2004-07 14.29 445.39 9.00 0.00 9.00 4733.83 0.00 9.00 0.00 9.00 2003-08 -21997.00 2003-08 -1.37 2003-08 366.45 2003-08 326.18 2003-08 1117.21 2003-08 1276.63 2003-08 985.47 2003-08 318.33 2003-08 366.45 2003-08 326.18 2003-08 1583.42 2003-08 1273.57 2003-08 985.47 2003-08 318.33 2003-08 2318.35 2003-08 2993.68 2003-08 599.06 2003-08 507.92 2003-08 2312.45 2003-08 3158.22 2003-08 596.86 2003-08 517.90 2003-08 23216.00 23465.76 9.00 0.00 9.00 2003-09 -23216.00 2003-09 1229.35 2003-09 985.43 2003-09 318.33 2003-09 366.45 2003-09 326.18 2003-09 1697.65 2003-09 1199.55 2003-09 432.12 2003-09 318.33 2003-09 366.45 2003-09 326.18 2003-09 1569.72 2003-09 1273.57 2003-09 985.43 2003-09 318.33 2003-09 366.45 2003-09 326.18 2003-09 1162.65 2003-09 2237.74 2003-09 2967.04 2003-09 610.50 2003-09 509.08 2003-09 2215.27 2003-09 3242.64 2003-09 589.35 2003-09 516.80 2003-09 2212.23 2003-09 2937.10 2003-09 601.64 2003-09 512.79 2003-09 13465.00 22969.53 9.00 0.00 9.00 2003-10 16562.00 2003-10 -13465.00 2003-10 366.45 2003-10 326.18 2003-10 1778.29 2003-10 1201.71 2003-10 432.12 2003-10 318.33 2003-10 366.45 2003-10 326.18 2003-10 1778.29 2003-10 1224.18 2003-10 432.12 2003-10 327.89 2003-10 2197.87 2003-10 3042.69 2003-10 599.93 2003-10 527.34 2003-10 2115.53 2003-10 2945.37 2003-10 599.62 2003-10 531.69 24535.23 9.00 0.00 9.00 2003-11 -16562.00 2003-11 366.45 2003-11 326.82 2003-11 1750.59 2003-11 1202.53 2003-11 432.12 2003-11 318.33 2003-11 366.45 2003-11 326.82 2003-11 6150.16 2003-11 1199.55 2003-11 432.12 2003-11 318.33 2003-11 2153.90 2003-11 2824.69 2003-11 603.80 2003-11 516.67 2003-11 2174.56 2003-11 3031.80 2003-11 602.69 2003-11 511.83 2003-11 16562.00 25610.21 9.00 0.00 9.00 2003-12 -16562.00 2003-12 576.08 2003-12 577.58 2003-12 2106.93 2003-12 1271.96 2003-12 493.92 2003-12 318.33 2003-12 366.45 2003-12 326.82 2003-12 1550.79 2003-12 1271.63 2003-12 512.61 2003-12 318.33 2003-12 3001.66 2003-12 689.86 2003-12 507.10 2003-12 2410.75 2003-12 3391.01 2003-12 733.08 2003-12 551.58 2003-12 2214.27 2003-12 20289.00 26917.74 9.00 0.00 9.00 2004-01 -20289.00 2004-01 363.89 2004-01 324.41 2004-01 1786.36 2004-01 1267.10 2004-01 740.51 2004-01 325.93 2004-01 366.45 2004-01 380.90 2004-01 1588.82 2004-01 1263.46 2004-01 435.25 2004-01 318.33 2004-01 2388.89 2004-01 3047.36 2004-01 633.62 2004-01 514.06 2004-01 2135.95 2004-01 2843.40 2004-01 630.19 2004-01 509.38 2004-01 20983.00 22558.26 9.00 0.00 9.00 2004-02 -20983.00 2004-02 2171.32 2004-02 2842.34 2004-02 596.66 2004-02 502.66 2004-02 2166.38 2004-02 2834.27 2004-02 592.11 2004-02 505.82 2004-02 2139.42 2004-02 2901.78 2004-02 595.58 2004-02 505.82 2004-02 363.89 2004-02 324.41 2004-02 1902.20 2004-02 1254.48 2004-02 2844.49 2004-02 316.37 2004-02 138.33 2004-02 363.89 2004-02 324.41 2004-02 1884.56 2004-02 1318.37 2004-02 6012.57 2004-02 316.37 2004-02 363.89 2004-02 324.41 2004-02 1883.75 2004-02 1314.80 2004-02 427.46 2004-02 316.37 2004-02 11125.00 30491.18 9.00 0.00 9.00 2004-03 -11125.00 2004-03 363.89 2004-03 324.41 2004-03 1883.75 2004-03 1313.35 2004-03 427.46 2004-03 328.42 2004-03 1030.76 2004-03 783.74 2004-03 4175.45 2004-03 1412.73 2004-03 1223.57 2004-03 517.51 2004-03 363.89 2004-03 324.41 2004-03 1883.75 2004-03 1310.21 2004-03 427.46 2004-03 259.67 2004-03 2125.40 2004-03 2855.73 2004-03 592.11 2004-03 533.38 2004-03 367.20 2004-03 504.90 2004-03 114.75 2004-03 114.75 2004-03 2137.60 2004-03 2798.35 2004-03 599.05 2004-03 511.26 2004-03 14532.00 35015.91 9.00 0.00 9.00 2004-04 -14532.00 2004-04 2189.11 2004-04 2846.10 2004-04 601.22 2004-04 532.37 2004-04 3240.15 2004-04 3982.56 2004-04 945.78 2004-04 654.16 2004-04 363.89 2004-04 324.41 2004-04 2935.66 2004-04 1310.39 2004-04 427.46 2004-04 273.27 2004-04 376.29 2004-04 334.52 2004-04 1697.23 2004-04 1290.80 2004-04 441.84 2004-04 263.46 2004-04 17529.00 28027.67 9.00 0.00 9.00 2004-05 -17529.00 2004-05 334.60 2004-05 1697.67 2004-05 1283.77 2004-05 442.03 2004-05 265.47 2004-05 376.43 2004-05 334.60 2004-05 1697.67 2004-05 1288.09 2004-05 442.03 2004-05 265.47 2004-05 376.43 2004-05 2283.77 2004-05 3080.01 2004-05 704.08 2004-05 533.85 2004-05 2345.28 2004-05 3027.98 2004-05 722.10 2004-05 531.92 2004-05 18423.00 22927.25 9.00 0.00 9.00 2004-06 -18423.00 2004-06 376.43 2004-06 334.60 2004-06 1697.67 2004-06 1290.85 2004-06 442.03 2004-06 268.92 2004-06 376.43 2004-06 334.60 2004-06 1697.67 2004-06 1286.81 2004-06 442.03 2004-06 268.53 2004-06 2366.19 2004-06 3247.86 2004-06 593.24 2004-06 543.33 2004-06 2473.40 2004-06 3072.72 2004-06 591.50 2004-06 534.44 2004-06 20916.00 24732.25 9.00 0.00 9.00 2004-07 -20916.00 2004-07 376.43 2004-07 334.60 2004-07 1697.67 2004-07 1285.86 2004-07 442.03 2004-07 273.62 2004-07 376.43 2004-07 334.60 2004-07 1659.77 2004-07 1358.32 2004-07 442.03 2004-07 276.47 2004-07 2387.09 2004-07 3119.31 2004-07 609.90 2004-07 536.61 2004-07 2483.07 2004-07 3099.60 2004-07 596.74 2004-07 549.24 2004-07 23346.00 24669.39 9.00 0.00 9.00 311920.38 0.00 9.00 Page 9.00 - -0 2003-08 1.00 120725.00 120725.00 9.00 0.00 9.00 9.00 - -0 2003-09 1.00 120725.00 120725.00 9.00 0.00 9.00 9.00 - -0 2003-10 1.00 120725.00 120725.00 9.00 0.00 9.00 9.00 - -0 2003-11 1.00 544.09 9.00 - -0 2003-11 1.00 120725.00 121269.09 9.00 0.00 9.00 9.00 - -0 2003-12 51.00 472.77 9.00 - -0 2003-12 41.00 40.34 9.00 - -0 2003-12 1.00 120725.00 121238.11 9.00 0.00 9.00 9.00 - -0 2004-01 1.00 132750.00 9.00 - -0 2004-01 4.00 -42.20 132707.80 9.00 0.00 9.00 9.00 - -0 2004-02 1.00 132750.00 132750.00 9.00 0.00 9.00 9.00 - -0 2004-03 1.00 132750.00 132750.00 9.00 0.00 9.00 9.00 - -0 2004-04 1.00 132750.00 132750.00 9.00 0.00 9.00 9.00 - -0 2004-05 1.00 132750.00 132750.00 9.00 0.00 9.00 9.00 - -0 2004-06 1.00 132750.00 9.00 - -0 2004-06 188.00 1870.50 9.00 - -0 2004-06 17.00 9585.18 144205.68 9.00 0.00 9.00 9.00 - -0 2004-07 1.00 116100.00 116100.00 9.00 0.00 9.00 1528695.68 3057391.36 9.00 0.00 9.00