Spreadsheet: 386416d1427786139-sumifs-two-criterias-from-different-columns-book100-gk
Sheet: Master Data

 |  |  |  |  | Debtors Balance |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Debtors Summary - Current 30 Days and 60 Days |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | REVENUE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2014-05-01 00:00:00 | 2014-05-01 00:00:00 | 2014-05-01 00:00:00
Customer | Name | Trade Terms | Sector |  | 2014-05-01 00:00:00 | 2014-06-01 00:00:00 | 2014-07-01 00:00:00 | 2014-08-01 00:00:00 | 2014-09-01 00:00:00 | 2014-10-01 00:00:00 | 2014-11-01 00:00:00 | 2014-12-01 00:00:00 | 2015-01-01 00:00:00 | 2015-02-01 00:00:00 | 2015-03-01 00:00:00 | 2015-04-01 00:00:00 | 2015-05-01 00:00:00 | 2015-06-01 00:00:00 |  | 0 to 30 Days | 31 to 60 Days | 61 Days + | 0 to 30 Days | 31 to 60 Days | 61 Days + | 0 to 30 Days | 31 to 60 Days | 61 Days + | 0 to 30 Days | 31 to 60 Days | 61 Days + | 0 to 30 Days | 31 to 60 Days | 61 Days + | 0 to 30 Days | 31 to 60 Days | 61 Days + | 0 to 30 Days | 31 to 60 Days | 61 Days + | 0 to 30 Days | 31 to 60 Days | 61 Days + | 0 to 30 Days | 31 to 60 Days | 61 Days + | 0 to 30 Days | 31 to 60 Days | 61 Days + | 0 to 30 Days | 31 to 60 Days | 61 Days + | 0 to 30 Days | 31 to 60 Days | 61 Days + | 0 to 30 Days | 31 to 60 Days | 61 Days + | 0 to 30 Days | 31 to 60 Days | 61 Days + |  | 2014-05-01 00:00:00 | 2014-06-01 00:00:00 | 2014-07-01 00:00:00 | 2014-08-01 00:00:00 | 2014-09-01 00:00:00 | 2014-10-01 00:00:00 | 2014-11-01 00:00:00 | 2014-12-01 00:00:00 | 2015-01-01 00:00:00 | 2015-02-01 00:00:00 | 2015-03-01 00:00:00 | 2015-04-01 00:00:00 | 2015-05-01 00:00:00 | 2015-06-01 00:00:00
0645301 | WILMAR SUGAR PTY LTD |  | [NAME] |  |  |  | 2267.83 | 5122.71 | 2682.14 | 1329.28 | 2135.11 | 3230.82 | 3920.53 |  |  |  |  |  |  |  |  |  |  |  |  | 2267.83 | 0 | 0 | 4231.51 | 891.2 | 0 | 2688.87 | -6.73 | 0 | 1336.01 | 0 | -6.73 | 2141.84 | 0 | -6.73 | 3237.55 | 0 | -6.73 | 3269.54 | 657.72 | -6.73
1041801 | JALCO - TOLL IN2STORE |  | TOLL |  |  |  | 4010.38 | 883.78 | 883.78 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 2237.07 | 1773.31 | 0 | 0 | 883.78 | 0 | 0 | 0 | 883.78 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
1087601 | TOX FREE AUSTRALIA PTY LTD |  | Tox Free |  |  |  | 2429 | 4912.81 | 3731.91 | 4911.39 | 3532.26 | 3532.26 | 2350.71 |  |  |  |  |  |  |  |  |  |  |  |  | 2429 | 0 | 0 | 4912.81 | 0 | 0 | 3744.3 | -12.39 | 0 | 3675.68 | 1248.1 | -12.39 | 3544.65 | 0 | -12.39 | 3544.65 | 0 | -12.39 | 2363.1 | 0 | -12.39
1088301 | VIP PACKAGING  PTY LTD |  | VIP Packaging |  |  |  | 31183.9 | 31183.9 | 31183.9 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 2625.15 | 28558.75 | 0 | 0 | 2625.15 | 28558.75 | 0 | 0 | 31183.9 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2002201 | TOYOTA MATERIAL HANDLING AUSTRALIA P/L |  | Toyota |  |  |  | 2055.17 | 8339.07 | 3802.9 | 2309.12 | 6303.18 | 4846.73 | 8113.72 |  |  |  |  |  |  |  |  |  |  |  |  | 2055.17 | 0 | 0 | 8339.07 | 0 | 0 | 3802.9 | 0 | 0 | 2309.12 | 0 | 0 | 6303.18 | 0 | 0 | 3222.6 | 1624.13 | 0 | 5696.77 | 2416.95 | 0
2036301 | VIVA ENERGY AUSTRALIA LTD |  | Viva |  |  |  | -1021.46 | -1030.94 | -1030.94 | -1030.94 | -1030.94 | -1030.94 | -1030.94 |  |  |  |  |  |  |  |  |  |  |  |  | 4.82 | -1026.28 | 0 | -0.02 | 0 | -1030.92 | 0 | -0.02 | -1030.92 | 0 | 0 | -1030.94 | 0 | 0 | -1030.94 | 0 | 0 | -1030.94 | 0 | 0 | -1030.94
2055001 | YATES AUSTRALIA |  | Yates |  |  |  | 9444.31 | 19942.36 | 17625.71 | 4973.05 | -15.25 | -15.25 | -15.25 |  |  |  |  |  |  |  |  |  |  |  |  | 7453.45 | 1990.86 | 0 | 12637.41 | 7453.45 | -148.5 | 4988.3 | 12637.41 | 0 | 0 | 4988.3 | -15.25 | 0 | 0 | -15.25 | 0 | 0 | -15.25 | 0 | 0 | -15.25
2075901 | VIRGIN GARDEN PTY LTD |  | [NAME] |  |  |  | 1533.05 | 2830.23 | 1926.99 | 215.88 | 891.06 | 672.34 | 661.67 |  |  |  |  |  |  |  |  |  |  |  |  | 1533.05 | 0 | 0 | 2830.23 | 0 | 0 | 1935.05 | -8.06 | 0 | 223.94 | 0 | -8.06 | 1527.09 | -627.97 | -8.06 | 1308.37 | 0 | -636.03 | 1297.7 | 0 | -636.03
2081801 | WESTCON GROUP PTY LTD |  | Westcon |  |  |  | 1211.6 | 2417.02 | 1435.22 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 1211.6 | 0 | 0 | 2417.02 | 0 | 0 | 1441.4 | -6.18 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2087601 | TOX FREE AUSTRALIA PTY LTD |  | Tox Free |  |  |  | 2402.04 | 4845.1 | 1254.28 | 627.14 | 1881.42 | 1881.42 | 1254.28 |  |  |  |  |  |  |  |  |  |  |  |  | 2402.04 | 0 | 0 | 3045.1 | 1800 | 0 | 1254.28 | 0 | 0 | 627.14 | 0 | 0 | 1881.42 | 0 | 0 | 1881.42 | 0 | 0 | 1254.28 | 0 | 0
0100401 | TOLL GLOBAL FWD-LAV (CYTEC) |  | TOLL |  |  |  | 9329.4 | 12031.23 | 12575.35 | 5483.04 | 12125.24 | 12514.44 | 11967.28 |  |  |  |  |  |  |  |  |  |  |  |  | 5723.28 | 2493.32 | 1112.8 | 7237.88 | 2544 | 2249.35 | 10598.76 | 813.37 | 1163.22 | 5483.04 | 0 | 0 | 9735.46 | 2389.78 | 0 | 2778.98 | 9735.46 | 0 | 8238.82 | 1161.91 | 2566.55
0100404 | TOLL GLOBAL FWD-NSW (CYTEC) |  | TOLL |  |  |  | 8950.66 | 11959.16 | 17281.36 | 31230.2 | 39108.2 | 45890.75 | 58286.98 |  |  |  |  |  |  |  |  |  |  |  |  | 7811.84 | 587.66 | 551.16 | 8587.59 | 2232.75 | 1138.82 | 6304.41 | 8587.59 | 2389.36 | 13948.84 | 6304.41 | 10976.95 | 8806.5 | 13571.5 | 16730.2 | 6782.55 | 8806.5 | 30301.7 | 12396.23 | 6782.55 | 39108.2
0371401 | TOLL ENERGY (WA) |  | TOLL |  |  |  | 11739.59 | 29320.5 | 13557.69 | 18310.77 | 16812.57 | 11505.66 | 23165.89 |  |  |  |  |  |  |  |  |  |  |  |  | 11739.59 | 0 | 0 | 29320.5 | 0 | 0 | 13577.14 | -19.45 | 0 | 18330.22 | 0 | -19.45 | 16832.02 | 0 | -19.45 | 9356.96 | 2168.15 | -19.45 | 18531.83 | 4653.51 | -19.45
0373101 | TOLL TASMANIA - LAUNCESTON |  | TOLL |  |  |  | 1986.35 | 1986.35 | 805.46 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 805.36 | 0 | 1180.99 | 0 | 805.36 | 1180.99 | 0 | 0 | 805.46 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
0830501 | TOLL TASMANIA - HOBART |  | TOLL |  |  |  | -1649.44 | -2191.84 | 0 | 2304.66 | 1162.57 | 2699.81 | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 1252.82 | 0 | -2902.26 | 710.42 | 0 | -2902.26 | 0 | 0 | 0 | 2304.66 | 0 | 0 | 1162.57 | 0 | 0 | 2699.81 | 0 | 0 | 0 | 0 | 0
1042501 | TOLL TASMANIA |  | TOLL |  |  |  | 4039.68 | 2085.12 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 4039.68 | 0 | 0 | 0 | 2085.12 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
1807401 | TOLL MINING - ARCHERFIELD QLD |  | TOLL |  |  |  | 2276.28 | 1126.54 | 1126.54 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 2276.28 | 0 | 0 | 1126.54 | 0 | 0 | 0 | 1126.54 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
1807402 | TOLL MINING - GLADSTONE QLD |  | TOLL |  |  |  | 660.96 | 2690.89 | 7413.29 | 6963.28 | 1312.56 | 3190.93 | 573.93 |  |  |  |  |  |  |  |  |  |  |  |  | 660.96 | 0 | 0 | 2470.57 | 220.32 | 0 | 4722.4 | 2470.57 | 220.32 | 4216.83 | 2746.45 | 0 | 1312.56 | 0 | 0 | 2753.41 | 437.52 | 0 | 573.93 | 0 | 0
2037501 | TOLL NQX FREIGHT SYSTEM |  | TOLL |  |  |  | 15115.44 | 17582.03 | 11510.59 | 13745.61 | 18624.82 | 18824.82 | 4621.73 |  |  |  |  |  |  |  |  |  |  |  |  | 10274.05 | 4841.39 | 0 | 9122.88 | 8459.15 | 0 | 9064.09 | 2446.5 | 0 | 7365.93 | 6379.68 | 0 | 6565.86 | 7365.93 | 4693.03 | 6182.22 | 6565.86 | 6076.74 | 2874.84 | 1746.89 | 0
2038801 | TOLL INTERMODAL - LAVERTON VIC |  | TOLL |  |  |  | 4349.6 | 12799.57 | 3329.98 | 2099.1 | 9799.8 | 9403.44 | 2381.04 |  |  |  |  |  |  |  |  |  |  |  |  | 3317.5 | 1032.1 | 0 | 11537.16 | 1262.41 | 0 | 3329.98 | 0 | 0 | 2099.1 | 0 | 0 | 9012.63 | 787.17 | 0 | 9403.44 | 0 | 0 | 2381.04 | 0 | 0
2043001 | TOLL REMOTE LOGISTICS |  | TOLL |  |  |  | 1266.5 | 838.6 | 417.15 | 1260.05 | 1260.05 | 1681.5 | 417.15 |  |  |  |  |  |  |  |  |  |  |  |  | 1266.5 | 0 | 0 | 838.6 | 0 | 0 | 421.45 | -4.3 | 0 | 1264.35 | 0 | -4.3 | 1264.35 | 0 | -4.3 | 1685.8 | 0 | -4.3 | 421.45 | 0 | -4.3
2047601 | TOLL CS - KNOXFIELD |  | TOLL |  |  |  | 1697.07 | 3956.75 | 2971.08 | 2852.68 | 2303.2 | 3056.96 | 941.64 |  |  |  |  |  |  |  |  |  |  |  |  | 1697.07 | 0 | 0 | 3564.23 | 392.52 | 0 | 1382.36 | 1196.2 | 392.52 | 2858.05 | 0 | -5.37 | 1382.02 | 926.55 | -5.37 | 2130.41 | 0 | 926.55 | 941.64 | 0 | 0
2048904 | TOLL CONTRACT [NAME] |  | TOLL |  |  |  | 7160.48 | 7618.16 | 7618.16 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 7618.16 | -457.68 | 0 | 0 | 7618.16 | 0 | 0 | 7618.16 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2049001 | TOLL GLOBAL FWD-WA |  | TOLL |  |  |  | 2907.85 | 2907.85 | 4609.18 | 3214.3 | 2862.3 | 3557.38 | 3108.37 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 2907.85 | 0 | 0 | 2907.85 | 1701.33 | 0 | 2907.85 | 0 | 1701.33 | 1512.97 | 0 | 0 | 2862.3 | 695.08 | 0 | 2862.3 | 0 | 695.08 | 2413.29
2054101 | TOLL MINING WEST  - WA |  | TOLL |  |  |  | 1668.8 | 3745.26 | 1642.56 | 3391.65 | 5286.45 | 13655.85 | 15616.81 |  |  |  |  |  |  |  |  |  |  |  |  | 1668.8 | 0 | 0 | 2076.46 | 1668.8 | 0 | 1642.56 | 0 | 0 | 1749.09 | 1642.56 | 0 | 3537.36 | 1749.09 | 0 | 10118.49 | 3537.36 | 0 | 5498.32 | 10118.49 | 0
2061601 | TOLL EXTRA (Intermodal) |  | TOLL |  |  |  | 4323.4 | 9589.92 | 7814.55 | 9127.52 | 2655.1 | 2774.43 | 7333.02 |  |  |  |  |  |  |  |  |  |  |  |  | 3802.12 | 521.28 | 0 | 9068.64 | 0 | 521.28 | 1878.17 | 5415.1 | 521.28 | 3191.14 | 0 | 5936.38 | 812.6 | 0 | 1842.5 | 322.48 | 609.45 | 1842.5 | 5490.52 | 0 | 1842.5
2061701 | TOLL INTERMODAL - STEEL LOGISTICS |  | TOLL |  |  |  | 1787.1 | 1111.57 | 2001.73 | 887.9 | 887.9 | 887.9 | 1335.24 |  |  |  |  |  |  |  |  |  |  |  |  | 668.75 | 671.01 | 447.34 | 887.9 | 223.67 | 0 | 890.16 | 887.9 | 223.67 | 890.16 | 0 | -2.26 | 890.16 | 0 | -2.26 | 667.62 | 222.54 | -2.26 | 890.16 | 222.54 | 222.54
2066201 | TOLL CS - COLES EXPRESS - WA |  | TOLL |  |  |  | 2366.25 | 4708.36 | 5629.9 | 7996.15 | 8363.65 | 7245.75 | 4732.5 |  |  |  |  |  |  |  |  |  |  |  |  | 2366.25 | 0 | 0 | 4708.36 | 0 | 0 | 5629.9 | 0 | 0 | 4732.5 | 3263.65 | 0 | 5100 | 0 | 3263.65 | 7245.75 | 0 | 0 | 4732.5 | 0 | 0
2080701 | VIP DRUM RECONDITIONERS PTY LTD |  | VIP Drum |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2039401 | TRANSPACIFIC INDUSTRIES PTY LTD |  | Transpacific |  |  |  | 0 | 0 | 0 | 0 | 1248.5 | 1248.5 | 1248.5 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1248.5 | 0 | 0 | 0 | 1248.5 | 0 | 0 | 0 | 1248.5
2080601 | TRADECOM SERVICES PTY LTD |  | TradeCom |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2035801 | TOLL EXPRESS - ALTONA VIC |  | Toll |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0