Spreadsheet: 89656d1289415703-sumif-not-working-the-way-i-want-2011-budget-wip-trimmed
Sheet: DataNew

AccountRange | EntityRange | Account Number | Description | Finance Statement Type | Closed Account | Beginning Balance | JAN | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEP | OCT | NOV | DEC | ACTUAL ENTITY | Asci | FinalEntity | FinalAccount |  | JAN
 |  | 1195-o01 | INV - PAINT & SUNDRIES | B | N | -3653.75 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3653.75 | 0 | 0 | 0 |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | -0.62 | -0.62 | -0.62 | -9.65 | -31.33 | -31.33
 |  | 1200-o01 | ACC INV - PAINT & SUNDRIES | B | N | -9189.64 | 3442.19 | 3081.53 | -3205.79 | 5.579999999999927 | 0 | 1825.2 | 0 | 0 | 4040.93 | 0 | -1776.47 | -6318.679999999999 |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0.62 | 0.62 | 0.62 | 9.65 | 31.33 | 31.33
 |  | 1203-o01 | INV ADJ - PAINT & SUNDRIES | B | N | -40.24 | 1.700000000000003 | -9.149999999999999 | -0.730000000000004 | 0 | 0 | 0 | 0 | 0 | 48.42 | 0 | -15.17 | -6.090000000000003 |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | -5.86 | -52.73 | -347.79 | -354.14 | -354.14 | -354.14
 |  | 5001-o01 | COGS ADV - PAINT & SUNDRIES | P | N | 0 | -1.7 | 9.15 | 5.180000000000001 | 12.71 | 0 | 0 | 0 | 0 | -25.34 | 0 | 15.17 | 6.090000000000003 |  |  |  |  |  | 0 | 0 | 0 | 0 | -41.44 | -41.44 | -41.44 | -41.44 | -41.44 | -41.44 | -41.44 | -41.44
 |  | 1195-o02 | INV - TOOLS | B | N | 6130.07 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -6130.07 | 0 | 0 | 0 |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7.28 | 7.19 | 7.19 | 7.19
 |  | 1200-o02 | ACC INV - TOOLS | B | N | -12954.4 | 6631.469999999999 | -623.29 | -1736.31 | -1960.949999999999 | 0 | -1074.620000000001 | 0 | 0 | 11718.1 | -22.8 | -4224.48 | 324.6100000000006 |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | -0.01 | -0.01 | -0.01 | -0.01 | -0.01 | -0.01 | -0.01
 |  | 1203-o02 | INV ADJ - TOOLS | B | N | -10.93 | -110.64 | -33.76000000000002 | -45.34999999999999 | 0 | 0 | 0 | 0 | 0 | 200.68 | 0 | -15.81 | -68.75 |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | -0.03 | -0.04 | -0.04 | -0.05 | -0.05 | -0.05
 |  | 5001-o02 | COGS ADV - TOOLS | P | N | 0 | 110.64 | 33.76000000000001 | 12.56 | 7.039999999999992 | 0 | 0 | 0 | 0 | -164 | 0 | 15.81 | 68.75 |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0.03 | 0.03 | 0 | 0 | 0 | 0
 |  | 1195-o03 | INV - ELECTRICAL SUPPLIES | B | N | -410.26 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 410.26 | 0 | 0 | 0 |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 217.26 | -80.09 | -80.09 | -80.09 | -80.09
 |  | 1200-o03 | ACC INV - ELECTRICAL SUPPLIES | B | N | -4308.58 | 250.3899999999999 | 267.3200000000002 | -1072.91 | 55.07999999999993 | 0 | 0 | 0 | 0 | 4808.7 | 0 | -204.2299999999996 | 4690.85 |  |  |  |  |  | 0 | 0 | 0 | 0 | -3554.44 | -3653.75 | -3653.75 | -3653.75 | -3653.75 | -3653.75 | -3653.75 | -3653.75
 |  | 1203-o03 | INV ADJ - ELECTRICAL SUPPLIES | B | N | -31.71 | -12.1 | -4.079999999999998 | -3.159999999999997 | 0 | 0 | 0 | 0 | 0 | 51.05 | 0 | -8.280000000000001 | -5.68 |  |  |  |  |  | 0 | 0 | 0 | 0 | 8469.52 | 6998.3 | 4824.28 | 8059.3 | 3493.05 | -1094.49 | -1865.22 | -1865.22
 |  | 5001-o03 | COGS ADV - ELECTRICAL SUPPLIES | P | N | 0 | 12.1 | 4.08 | 7.289999999999999 | 7.080000000000002 | 0 | 0 | 0 | 0 | -30.55 | 0 | 8.280000000000001 | 5.68 |  |  |  |  |  | 0 | 0 | 0 | 0 | -1.57 | -2.86 | -4.5 | -7.01 | -7.67 | -18.98 | -34.18 | -34.18
 |  | 1195-o04 | INV - 04 UNKNOWN | B | N | -1635.75 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1635.75 | 0 | 0 | 0 |  |  |  |  |  | 0 | 0 | 0 | 0 | 1.57 | 2.86 | 4.5 | 7.01 | 7.67 | 18.98 | 34.18 | 34.18
 |  | 1200-o04 | ACC INV - 04 UNKNOWN | B | N | -865.66 | -2164.48 | 2124.41 | -3325.89 | 0.2100000000000364 | 0 | 1557.22 | 0 | 0 | 2674.19 | 36.9 | 483.7899999999991 | 9686.02 |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 35.89 | 35.91 | 4.04 | 91.34 | 48.52 | 91.39 | 91.39
 |  | 1203-o04 | INV ADJ - 04 UNKNOWN | B | N | -112.87 | -53.04999999999998 | 20.00999999999999 | -2.400000000000006 | 0 | 0 | 0 | 0 | 0 | 148.31 | 0 | -31.36 | -12.21000000000001 |  |  |  |  |  | 0 | 0 | 0 | 0 | 7921.98 | 936.41 | 1675.59 | 7372.46 | 7284.47 | -9054.53 | -9224.55 | -9224.55
 |  | 5001-o04 | COGS ADV - 04 UNKNOWN | P | N | 0 | 53.05 | -20.01 | 11.05 | 26.06 | 0 | 0 | 0 | 0 | -70.15 | 0 | 31.36 | 12.21000000000001 |  |  |  |  |  | 0 | 0 | 0 | 0 | -29.05 | -34.68 | -105.36 | -83.1 | -84.91 | -73.63 | -62.18 | -62.18
 |  | 1195-o05 | INV - BUILDERS HARDWARE | B | N | -208.83 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 208.83 | 0 | 0 | 0 |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 1200-o05 | ACC INV - BUILDERS HARDWARE | B | N | -3110.97 | 1108.9 | 286.3499999999999 | -912.1800000000001 | -163.3499999999999 | 0 | 99.13999999999987 | 0 | 0 | 2692.11 | 0 | 300.0700000000002 | 747.2600000000002 |  |  |  |  |  | 0 | 0 | 0 | -39.45 | -39.46 | -39.46 | -39.46 | -39.46 | -39.46 | -39.46 | -39.46 | -39.46
 |  | 1203-o05 | INV ADJ - BUILDERS HARDWARE | B | N | -165.31 | -12.85999999999999 | -0.3800000000000239 | -4.189999999999998 | 0 | 0 | 0 | 0 | 0 | 182.74 | 0 | -7.97999999999999 | -5.210000000000008 |  |  |  |  |  | 0 | 0 | 0 | 0 | -743.72 | -410.26 | -410.26 | -410.26 | -410.26 | -410.26 | -410.26 | -410.26
 |  | 5001-o05 | COGS ADV - BUILDERS HARDWARE | P | N | 0 | 12.86 | 0.3800000000000008 | 7.33 | 29.07 | 0 | 0 | 0 | 0 | -49.64 | 0 | 7.97999999999999 | 5.210000000000008 |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | -1.96 | -1.96 | -1.96 | -1.96 | -1.96 | -1.96
 |  | 1195-o06 | INV - HOUSEHOLD GOODS | B | N | 38.88 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -38.88 | 0 | 0 | 0 |  |  |  |  |  | 0 | 0 | 0 | 0 | 1283.02 | -5675.86 | -6159.66 | -5473.21 | -6342.05 | -8795.2 | -7427.9 | -7427.9
 |  | 1200-o06 | ACC INV - HOUSEHOLD GOODS | B | N | -3004.51 | -728.9899999999998 | 1315.09 | -373.1900000000001 | 0 | 0 | 0 | 0 | 0 | 2791.6 | 0 | -258.6700000000001 | -296.1300000000001 |  |  |  |  |  | 0 | 0 | 0 | 0 | -0.45 | -0.49 | -7.23 | -9.69 | -14.79 | -17.75 | -26.03 | -26.03
 |  | 1203-o06 | INV ADJ - HOUSEHOLD GOODS | B | N | 14.64 | -13.96 | -8.78 | -1.35 | 0 | 0 | 0 | 0 | 0 | 9.45 | 0 | -0.8800000000000026 | -4.739999999999998 |  |  |  |  |  | 0 | 0 | 0 | 0 | 0.45 | 0.49 | 7.23 | 9.69 | 14.79 | 17.75 | 26.03 | 26.03
 |  | 5001-o06 | COGS ADV - HOUSEHOLD GOODS | P | N | 0 | 13.96 | 8.779999999999998 | 3.690000000000001 | -2.84 | 0 | 0 | 0 | 0 | -23.59 | 0 | 0.8800000000000026 | 4.739999999999998 |  |  |  |  |  | 0 | 0 | 0 | -414.05 | -662.14 | -648.85 | -648.85 | -648.85 | -648.85 | -648.85 | -648.85 | -648.85
 |  | 1195-o07 | INVENTORY | B | N | 154.58 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -154.58 | 0 | 0 | 0 |  |  |  |  |  | 0 | 0 | 0 | 0 | -2237.91 | -1635.75 | -1635.75 | -1635.75 | -1635.75 | -1635.75 | -1635.75 | -1635.75
 |  | 1200-o07 | ACC INVENTORY | B | N | 2260.33 | 15987.85 | 20270.48 | 2102.179999999993 | 5.67000000000553 | -2436.240000000005 | -466.0499999999956 | 0 | 0 | -37724.22 | 0 | 673.3800000000001 | -608.7000000000003 |  |  |  |  |  | 0 | 0 | 0 | 0 | 12.89 | -5.69 | 15.52 | -150.14 | -123.17 | -137.41 | -137.39 | -137.39
 |  | 1203-o07 | INV ADJ | B | N | -124.61 | -17.33 | -15 | -10.22999999999999 | 0 | 0 | 0 | 0 | 0 | 167.17 | 0 | -50.59999999999999 | -3.640000000000001 |  |  |  |  |  | 0 | 0 | 0 | 0 | 2733.68 | -8566.04 | -9110.46 | -8404.5 | -8966.16 | -11035.47 | -10443.24 | -10443.24
 |  | 5001-o07 | [NAME] | P | N | 0 | 17.33 | 15 | 60 | 7.689999999999998 | 0 | 0 | 0 | 0 | -100.02 | 0 | 50.59999999999999 | 3.640000000000001 |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -0.22 | -0.22 | -0.22
 |  | 1195-o08 | INV - AUTOMOTIVE | B | N | -73.59 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 73.59 | 0 | 0 | 0 |  |  |  |  |  | 0 | 0 | 0 | 0 | -0.06 | 1.67 | 0.98 | 39.72 | 38.28 | -69.3 | -100.66 | -100.66
 |  | 1200-o08 | ACC INV - AUTOMOTIVE | B | N | -3896.27 | 5760.65 | 11589.73 | -1169 | 0 | 0 | 20.84999999999854 | 0 | 0 | -12305.96 | 163.87 | -229.02 | -179.4000000000001 |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.22 | 0.22 | 0.22
 |  | 1203-o08 | INV ADJ - AUTOMOTIVE | B | N | -79.74 | -7.710000000000008 | -4.849999999999994 | 6.75 | 0 | 0 | 0 | 0 | 0 | 85.55 | 0 | -34.88999999999999 | -13.67 |  |  |  |  |  | 0 | 0 | 0 | 0 | 0.06 | -1.67 | -0.98 | -39.72 | -38.28 | 69.3 | 100.66 | 100.66
 |  | 5001-o08 | COGS ADV - AUTOMOTIVE | P | N | 0 | 7.71 | 4.850000000000001 | 0.1099999999999994 | 20.9 | 0 | 0 | 0 | 0 | -33.57 | 0 | 34.88999999999999 | 13.67 |  |  |  |  |  | 0 | 0 | 0 | 0 | -1333 | -208.83 | -208.83 | -208.83 | -208.83 | -208.83 | -208.83 | -208.83
 |  | 1195-o09 | INV - MISCELLANEOUS | B | N | -109.82 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 109.82 | 0 | 0 | 0 |  |  |  |  |  | 0 | 0 | 0 | 0 | 2.33 | -1.91 | -11.68 | -105.31 | -111.38 | -152.12 | -160.14 | -160.14
 |  | 1200-o09 | ACC INV - MISCELLANEOUS | B | N | -7104.34 | 325.9400000000005 | 765.7399999999998 | 223.4099999999999 | 0 | 0 | 317.9099999999999 | 0 | 0 | 5471.34 | 22.42 | -159.8399999999992 | -1792.860000000001 |  |  |  |  |  | 0 | 0 | 0 | 0 | -342.65 | 38.88 | 38.88 | 38.88 | 38.88 | 38.88 | 38.88 | 38.88
 |  | 1203-o09 | INV ADJ - MISCELLANEOUS | B | N | 75.61 | -10.72 | -18.54 | -0.8400000000000034 | 0 | 0 | 0 | 0 | 0 | -45.51 | 0 | -4.390000000000001 | 2.129999999999995 |  |  |  |  |  | 0 | 0 | 0 | 0 | -47.63 | -561.32 | -340.8 | 334.74 | -78.43 | -2449.71 | -2334.33 | -2334.33
 |  | 5001-o09 | COGS ADV - MISCELLANEOUS | P | N | 0 | 10.72 | 18.54 | 0.9799999999999969 | 0.7200000000000024 | 0 | 0 | 0 | 0 | -30.96 | 0 | 4.390000000000001 | -2.129999999999995 |  |  |  |  |  | 0 | 0 | 0 | 0 | 21.63 | 21.51 | 21.43 | 21.39 | 21.33 | 20.26 | 19.38 | 19.38
 |  | 1200-o0M | ACC INV - MISC CULL SKU | B | N | -3.18 | 0 | 0 | -0.009999999999999787 | 0 | 0 | 0 | 0 | 0 | 3.19 | 0 | 0 | 0 |  |  |  |  |  | 0 | 0 | 0 | -873.1 | 7.05 | 284.58 | 284.58 | 284.58 | 284.58 | 284.58 | 284.58 | 284.58
 |  | 1195-o10 | INV - LUMBER AND BUILDING MATE | B | N | 576.4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -576.4 | 0 | 0 | 0 |  |  |  |  |  | 0 | 0 | 0 | 8.87 | 15.6 | 28.87 | 38.03 | 46.04 | 63.92 | 67.62 | 75.19 | 75.19
 |  | 1200-o10 | ACC INV - LUMBER AND BUILDING | B | N | 4265.28 | 5952.14 | 2751.559999999999 | 883.3100000000013 | 0 | 0 | 0 | 0 | 0 | -13852.29 | 0 | 178.6399999999999 | 5453.42 |  |  |  |  |  | 0 | 0 | 0 | -4.05 | -4.23 | -10.95 | -15.21 | -19.65 | -22.26 | -27.73 | -33.31 | -33.31
 |  | 1203-o10 | INV ADJ - LUMBER AND BUILDING | B | N | 63.85 | 0 | -0.980000000000004 | 3.520000000000003 | 0 | 0 | 0 | 0 | 0 | -66.39 | 0 | 3.809999999999995 | -0.1699999999999946 |  |  |  |  |  | 0 | 0 | 0 | -1034.99 | -705.86 | -836 | -836 | -836 | -836 | -836 | -836 | -836
 |  | 5001-o10 | COGS ADV - LUMBER AND BUILDING | P | N | 0 | 0 | 0.98 | -3.52 | 22.23 | 0 | 0 | 0 | 0 | -19.69 | 0 | -3.809999999999995 | 0.1699999999999946 |  |  |  |  |  | 0 | 0 | 0 | 278.43 | 11.93 | 329.52 | 76.83 | 26.98 | -95.77 | -321.24 | -111.5 | -111.5
 |  | 1195-o11 | INV - Benjamin Moore | B | N | -790.2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 790.2 | 0 | 0 | 0 |  |  |  |  |  | 0 | 0 | 0 | 0.24 | 2.76 | 4.03 | 4.29 | 5.51 | 5.85 | 5.85 | 8.2 | 8.2
 |  | 1200-o11 | ACC INV - [NAME] | B | N | 1943 | -150.6700000000001 | -97.81999999999994 | 50.26999999999998 | 0 | 0 | 0 | 0 | 0 | -1744.78 | 0 | -64.38999999999987 | -189.5700000000002 |  |  |  |  |  | 0 | 0 | 0 | -375.26 | 380.43 | 356.16 | 356.16 | 356.16 | 356.16 | 356.16 | 356.16 | 356.16
 |  | 1203-o11 | INV ADJ - Benjamin Moore | B | N | 620.37 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -620.37 | 0 | 0 | 0.01999999999998181 |  |  |  |  |  | 0 | 0 | 0 | 63.22 | 44.46 | -66.08 | -69.01 | 324.3 | 376.98 | 88.89 | 75.65 | 75.65
 |  | 1200-o14 | ACC INV | B | N | 22.7 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -22.7 | 0 | 0 | 0 |  |  |  |  |  | 0 | 0 | 0 | -2.6 | -3.08 | -3.08 | -3.1 | -6.27 | -6.38 | -6.41 | -6.57 | -6.57
 |  | 1195-o16 | INV - MILLWORK | B | N | -1027.83 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1027.83 | 0 | 0 | 0 |  |  |  |  |  | 0 | 0 | 0 | 2.6 | 3.08 | 3.08 | 3.1 | 6.27 | 6.38 | 6.41 | 6.57 | 6.57
 |  | 1200-o16 | ACC INV - MILLWORK | B | N | 474.3 | 0 | -13.21000000000004 | -4.689999999999998 | 0 | 0 | 0 | 0 | 0 | -456.4 | 0 | -9.259999999999991 | -15.44999999999999 |  |  |  |  |  | 0 | 0 | 0 | -4169.83 | -3683.83 | -3991.07 | -3991.07 | -3991.07 | -3991.07 | -3991.07 | -3991.07 | -3991.07
 |  | 1203-o16 | INV ADJ - MILLWORK | B | N | 6.26 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -6.26 | 0 | 0 | 0 |  |  |  |  |  | 0 | 0 | 0 | 245.66 | 1093.15 | 161.37 | 372.48 | 748.03 | -2658.45 | -6336.8 | -7863.66 | -7863.66
 |  | 1200-o20 | ACC INV - BUILDERS HARDWARE | B | N | 0 | 0 | -0.57 | 0 | 0 | 0 | 0 | 0 | 0 | 0.57 | 0 | 0 | 0 |  |  |  |  |  | 0 | 0 | 0 | -14.57 | -19.08 | -22.33 | -29.36 | -34.98 | -41.3 | -41.49 | -41.9 | -41.9
 |  | 1195-o50 | INV - ELECTRICAL SUPPLIES | B | N | 136.72 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -136.72 | 0 | 0 | 0 |  |  |  |  |  | 0 | 0 | 6.19 | 192.51 | 192.51 | 715.14 | 1299 | 2570.43 | 2708.6 | 2196.96 | 2155.38 | 2155.38
 |  | 1200-o50 | ACC INV - ELECTRICAL SUPPLIES | B | N | -106.72 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 106.72 | 0 | 0 | 0 |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 620.35 | 620.35 | 620.35 | 620.35 | 620.35 | 620.35
 |  | 1203-o50 | INV ADJ - ELECTRICAL SUPPLIES | B | N | -30 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 30 | 0 | 0 | 0 |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | -620.35 | -620.35 | -620.35 | -620.35 | -620.35 | -620.35
 |  | 1195-o56 | INV - RENTAL SALES | B | N | -0.05 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.05 | 0 | 0 | 0 |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 27.24 | 22.7 | 22.7 | 22.7 | 22.7 | 22.7
 |  | 1200-o56 | ACC INV - RENTAL SALES | B | N | -17.06 | -1.330000000000002 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 18.39 | 0 | -0.02999999999999936 | -4.94 |  |  |  |  |  | 0 | 0 | 0 | -1440.86 | -1337.32 | -1408.48 | -1408.48 | -1408.48 | -1408.48 | -1408.48 | -1408.48 | -1408.48
 |  | 1195-o57 | INV - AUTOMOTIVE | B | N | 272.85 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -272.85 | 0 | 0 | 0 |  |  |  |  |  | 0 | 0 | 0 | 203.78 | 0 | 220.24 | 156.66 | 48.66 | 27.06 | 36.75 | 426.16 | 426.16
 |  | 1200-o58 | ACC INV - Propane | B | N | 13.12 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -13.12 | 0 | 0 | 0 |  |  |  |  |  | 0 | 0 | 0 | 0 | 635.65 | 1000.4 | 977.32 | 958.82 | 950.71 | 499.01 | 499.01 | 499.01
 |  | 1195-o71 | INV - GARDEN CENTER | B | N | -476.18 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 476.18 | 0 | 0 | 0 |  |  |  |  |  | 0 | 0 | 0 | 56.55 | 97.84 | 6.52 | -38.57 | 40.32 | 171.07 | 62.2 | -12.83 | -12.83
 |  | 1200-o71 | ACC INV - GARDEN CENTER | B | N | 46.07 | 314.89 | 795.9099999999999 | -264.7699999999999 | 0 | -253.1700000000001 | -35.75 | 0 | 0 | -603.18 | 0 | -5.700000000000017 | 271.93 |  |  |  |  |  | 0 | 0 | 0 | -1.37 | -3.89 | -4.53 | -5.92 | -8.79 | -9.59 | -11.91 | -15.41 | -15.41
 |  | 1203-o71 | INV ADJ - GARDEN CENTER | B | N | -0.17 | -2.55 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2.72 | 0 | 0 | -0.14 |  |  |  |  |  | 0 | 0 | 0 | 1.37 | 3.89 | 4.53 | 5.92 | 8.79 | 9.59 | 11.91 | 15.41 | 15.41
 |  | 5001-o71 | COGS ADV - GARDEN CENTER | P | N | 0 | 2.55 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -2.55 | 0 | 0 | 0.14 |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 1195-o72 | INV - HILLMAN | B | N | 768.53 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -768.53 | 0 | 0 | 0 |  |  |  |  |  | 0 | 0 | 0 | 0 | 327.28 | -32.2 | 233.89 | -106.72 | -106.72 | -106.72 | -106.72 | -106.72
 |  | 1200-o72 | ACC INV - HILLMAN | B | N | -722.33 | 464.09 | -57.05000000000001 | -270.3 | 0 | 0 | 0 | 600 | 0 | -14.41 | -688.04 | 6.330000000000041 | 2.189999999999941 |  |  |  |  |  | 0 | 0 | 0 | 0 | -30 | -30 | -30 | -30 | -30 | -30 | -30 | -30
 |  | 1203-o72 | INV ADJ - HILLMAN | B | N | -31.02 | -20.42 | -28.34 | 250.99 | 0 | 0 | 0 | 0 | 0 | -171.21 | 0 | 0 | -14.41 |  |  |  |  |  | 0 | 0 | 0 | 0 | -0.01 | -0.05 | -0.05 | -0.05 | -0.05 | -0.05 | -0.05 | -0.05
 |  | 5001-o72 | COGS ADV - HILLMAN | P | N | 0 | 20.42 | 28.34 | -785.79 | 67.28999999999996 | 0 | 0 | 0 | 0 | 669.74 | 0 | 0 | 14.41 |  |  |  |  |  | 0 | 0 | 0 | 44.97 | 0 | 44.97 | 44.97 | -19.18 | -67.12 | -9.58 | -9.58 | -9.58
 |  | 1195-o76 | INV - feed | B | N | 21.34 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -21.34 | 0 | 0 | 0 |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 13.12 | 13.12 | 13.12 | 13.12 | 13.12
 |  | 1200-o76 | ACC INV - feed | B | N | 83.78 | -22.04 | -33.06 | -22.04 | 0 | 0 | 0 | 0 | 0 | -6.64 | 0 | 253.15 | -110.22 |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.61 | 0.61 | 0.61 | 0.61
 |  | 1203-o76 | INV ADJ - feed | B | N | -0.08 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.08 | 0 | 0 | 0 |  |  |  |  |  | 0 | 0 | 0 | -62.22 | -62.22 | -62.22 | -62.22 | -62.22 | -62.22 | -62.22 | -62.22 | -62.22
 |  | 1200-o77 | ACC INV - PAINT & SUNDRIES | B | N | -28.52 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 28.52 | 0 | 0 | 5.080000000000002 |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 1200-o78 | ACC INV - [NAME] | B | N | 2145.09 | -131.9800000000002 | -262.3799999999999 | 338.23 | 0 | 0 | 0 | 0 | 0 | -2088.96 | 0 | 827.0500000000002 | -254.96 |  |  |  |  |  | 0 | 0 | 0 | 0 | -372.83 | -476.18 | -476.18 | -476.18 | -476.18 | -476.18 | -476.18 | -476.18
 |  | 1203-o78 | INV ADJ - Benjamin Moore | B | N | 8.32 | 0 | 0 | 4.41 | 0 | 0 | 0 | 0 | 0 | -12.73 | 0 | 0 | 0 |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | -2.77 | 50.96 | 17.66 | 52.06 | -220.16 | -225.86 | -225.86
 |  | 5001-o78 | COGS ADV - Benjamin Moore | P | N | 0 | 0 | 0 | -4.41 | 0 | 0 | 0 | 0 | 0 | 4.41 | 0 | 0 | 0 |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -0.03 | -0.03 | -0.03 | -0.03
 |  | 1200-o95 | ACC INV - CLEARANCE ITEMS | B | N | -7.03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7.03 | 0 | 0 | 0 |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | -0.15 | -0.15 | -0.15 | -0.15 | -0.15 | -0.15 | -0.15
 |  | 1200-oCI | Inventory - Consignment | B | N | 22394 | -1300 | 850 | 0 | -650 | -14847 | 0 | 0 | 0 | -6447 | -161.17 | 272 | -189 |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | -7.16 | -471.16 | 253.84 | 1753.15 | 1486.89 | 1486.89
 |  | 1200-oGF | INVENTORY | B | N | -380.93 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 380.93 | 0 | 0 | 0 |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 12.54 | 39.76 | 39.76 | 24.69 | -59.15 | 271.16 | 271.16
 |  | 1195-oST | INVENTORY | B | N | -339.89 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 339.89 | 0 | 0 | 0 |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | -0.08 | -0.08 | -0.08 | -0.08 | -0.08 | -0.08
 |  | 1200-oST | ACC INV | B | N | -354.24 | -13.28999999999996 | -28.86000000000001 | 22.77999999999997 | 0 | 0 | -9.870000000000005 | 0 | 0 | 383.48 | 0 | 0 | 0 |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0.08 | 0.08 | 0.08 | 0.08 | 0.08 | 0.08