Summary of currently loaded spend data for: HM Treasury

Lastfile: HMT_201912
File name TotalAmt£ OrigRecs AggRecs     AvgAmt£ MaxAmt£           MinDate       MaxDate     Diff     Comment
HMT_201101.csv 15,048,748.56 60 0 250,812.48 4,221,742.44 2011-01-04 2011-01-31 27    
HMT_201102.csv 6,613,258.29 49 0 134,964.45 806,214.35 2011-02-02 2011-02-28 26    
HMT_201103.csv 9,145,529.73 77 0 118,773.11 995,230.13 2011-03-01 2011-03-31 30    
HMT_201104.csv 18,432,711.64 58 0 317,805.37 5,139,105.08 2011-04-04 2011-04-28 24     Jump in TotalAmt. Jump in AvgAmt
HMT_201105.csv 11,750,400.41 39 0 301,292.32 2,040,424.85 2011-05-05 2011-05-27 22    
HMT_201106.csv 10,423,017.75 46 0 226,587.34 2,845,120.37 2011-06-01 2011-06-30 29    
HMT_201107.csv 9,589,845.72 42 0 228,329.66 1,700,354.04 2011-07-04 2011-07-29 25    
HMT_201108.csv 10,446,480.43 40 0 261,162.01 3,456,254.95 2011-08-01 2011-08-31 30    
HMT_201109.csv 12,211,254.04 40 0 305,281.35 3,210,210.97 2011-09-02 2011-09-30 28    
HMT_201110.csv 14,867,261.33 29 0 512,664.18 7,182,984.41 2011-10-03 2011-10-31 28    
HMT_201111.csv 11,522,897.40 52 0 221,594.18 2,040,424.86 2011-11-01 2011-11-30 29    
HMT_201112.csv 12,771,791.81 43 0 297,018.41 2,567,198.10 2011-12-01 2011-12-30 29    
HMT_201201.csv 19,086,494.31 57 0 334,850.78 5,183,511.25 2012-01-03 2012-01-31 28    
HMT_201202.csv 12,458,584.18 47 0 265,076.26 1,916,666.67 2012-02-01 2012-02-29 28    
HMT_201203.csv 19,073,573.65 71 0 268,641.88 6,151,860.00 2012-03-02 2012-03-30 28    
HMT_201204.csv 12,754,697.80 51 0 250,092.11 1,770,627.50 2012-04-02 2012-04-30 28    
HMT_201205.csv 7,507,627.95 30 0 250,254.27 1,830,215.10 2012-05-01 2012-05-31 30    
HMT_201206.csv 7,138,299.49 27 0 264,381.46 2,048,590.68 2012-06-01 2012-06-29 28    
HMT_201207.csv 12,488,468.44 44 0 283,828.83 2,186,480.40 2012-07-02 2012-07-31 29    
HMT_201208.csv 13,492,904.40 38 0 355,076.43 2,708,340.50 2012-08-01 2012-08-31 30    
HMT_201209.csv 13,001,353.39 44 0 295,485.30 3,156,081.49 2012-09-03 2012-09-28 25    
HMT_201210.csv 13,725,045.83 48 0 285,938.45 2,829,785.56 2012-10-02 2012-10-31 29    
HMT_201211.csv 7,684,492.18 28 0 274,446.15 1,707,158.90 2012-11-01 2012-11-30 29    
HMT_201212.csv 15,476,892.35 43 0 359,927.73 3,655,977.96 2012-12-04 2012-12-31 27     Jump in TotalAmt.
HMT_201301.csv 13,347,550.09 51 0 261,716.67 3,973,919.29 2013-01-02 2013-01-31 29    
HMT_201302.csv 14,016,827.57 50 0 280,336.55 2,827,835.34 2013-02-04 2013-02-28 24    
HMT_201303.csv 24,008,083.65 68 0 353,060.05 6,319,170.00 2013-03-04 2013-03-28 24    
HMT_201304.csv 11,782,550.59 89 0 132,388.21 2,568,801.00 2013-04-02 2013-04-30 28    
HMT_201305.csv 6,574,370.82 30 0 219,145.69 2,192,336.38 2013-05-02 2013-05-31 29    
HMT_201306.csv 8,980,874.47 33 0 272,147.71 2,121,615.84 2013-06-03 2013-06-28 25    
HMT_201307.csv 11,718,385.06 46 0 254,747.50 2,725,976.16 2013-07-02 2013-07-31 29    
HMT_201308.csv 7,314,712.88 38 0 192,492.44 1,142,295.00 2013-08-01 2013-08-30 29    
HMT_201309.csv 11,745,107.33 50 0 234,902.15 1,629,210.60 2013-09-02 2013-09-30 28    
HMT_201310.csv 13,626,777.72 42 0 324,447.09 2,323,304.40 2013-10-01 2013-10-31 30    
HMT_201311.csv 14,604,220.55 46 0 317,483.06 2,619,306.96 2013-11-01 2013-11-29 28    
HMT_201312.csv 19,929,785.48 48 0 415,203.86 4,412,884.19 2013-09-16 2013-12-31 106    
HMT_201401.csv 19,073,144.37 35 0 544,946.98 5,352,670.08 2014-01-02 2014-01-31 29    
HMT_201402.csv 8,679,046.86 29 0 299,277.48 1,987,938.00 2014-01-20 2014-02-28 39    
HMT_201403.csv 18,400,616.32 76 0 242,113.37 2,874,620.67 2014-03-04 2014-03-31 27     Jump in TotalAmt.
HMT_201404.csv 16,438,416.37 41 0 400,936.98 6,460,740.00 2014-04-01 2014-04-30 29    
HMT_201405.csv 12,896,174.04 36 0 358,227.06 3,828,993.46 2014-05-02 2014-05-30 28    
HMT_201406.csv 10,057,742.06 42 0 239,470.05 3,715,905.60 2014-06-02 2014-06-30 28    
HMT_201407.csv 14,773,247.45 42 0 351,743.99 5,190,291.52 2014-07-02 2014-07-31 29    
HMT_201408.csv 12,585,091.42 39 0 322,694.65 5,013,117.23 2014-08-04 2014-08-29 25    
HMT_201409.csv 16,377,999.92 37 0 442,648.65 6,378,274.43 2014-09-01 2014-09-30 29    
HMT_201410.csv 17,279,486.78 41 0 421,450.90 10,026,884.81 2014-10-01 2014-10-31 30    
HMT_201411.csv 14,277,102.32 37 0 385,867.63 6,628,645.19 2014-11-03 2014-11-28 25    
HMT_201412.csv 17,543,104.65 50 0 350,862.09 9,479,858.06 2014-12-02 2014-12-31 29    
HMT_201501.csv 14,512,506.35 35 0 414,643.04 6,952,903.30 2015-01-05 2015-01-30 25    
HMT_201502.csv 13,771,274.39 52 0 264,832.20 3,468,756.59 2015-02-02 2015-02-27 25    
HMT_201503.csv 21,922,360.50 63 0 347,973.98 2,482,002.70 2015-03-02 2015-03-31 29    
HMT_201504.csv 15,973,835.31 51 0 313,212.46 7,474,175.65 2015-04-01 2015-04-30 29    
HMT_201505.csv 21,458,390.08 43 0 499,032.33 6,602,310.00 2015-05-05 2015-05-29 24    
HMT_201506.csv 15,592,177.91 38 0 410,320.47 4,557,403.12 2015-06-01 2015-06-30 29    
HMT_201507.csv 22,446,650.47 62 0 362,042.75 6,281,887.70 2015-07-01 2015-07-31 30    
HMT_201508.csv 7,769,961.42 30 0 258,998.71 2,796,937.90 2015-06-17 2015-08-28 72     Drop in TotalAmt.
HMT_201509.csv 17,858,446.90 51 0 350,165.63 3,590,832.96 2015-09-01 2015-09-30 29     Jump in TotalAmt.
HMT_201510.csv 18,432,347.13 54 0 341,339.76 7,410,365.94 2015-10-02 2015-10-30 28    
HMT_201511.csv 14,154,994.77 37 0 382,567.43 7,914,232.23 2015-11-03 2015-11-30 27    
HMT_201512.csv 19,349,323.23 55 0 351,805.88 7,723,537.56 2015-08-26 2015-12-31 127    
HMT_201601.csv 23,838,016.73 53 0 449,773.90 5,056,445.96 2016-01-04 2016-01-29 25    
HMT_201602.csv 17,159,035.80 41 0 418,513.07 7,307,736.00 2016-02-02 2016-02-29 27    
HMT_201603.csv 12,018,042.05 76 0 158,132.13 1,887,461.31 2016-03-02 2016-03-31 29    
HMT_201604.csv 15,732,951.87 59 0 266,660.20 6,653,790.00 2016-04-04 2016-04-29 25    
HMT_201605.csv 16,884,188.82 58 0 291,106.70 4,012,801.50 2016-05-06 2016-05-27 21    
HMT_201606.csv 17,145,531.69 40 0 428,638.29 6,464,125.39 2016-06-03 2016-06-30 27    
HMT_201607.csv 18,895,803.42 38 0 497,257.98 7,473,434.11 2016-07-04 2016-07-29 25    
HMT_201608.csv 14,013,098.19 35 0 400,374.23 5,400,000.00 2016-08-02 2016-08-31 29    
HMT_201609.csv 12,037,159.01 27 0 445,820.70 7,447,582.50 2016-09-02 2016-09-30 28    
HMT_201610.csv 29,149,233.23 58 0 502,572.99 7,627,730.95 2016-10-03 2016-10-31 28     Jump in TotalAmt.
HMT_201611.csv 17,075,277.77 40 0 426,881.94 10,493,159.57 2016-11-02 2016-11-30 28    
HMT_201612.csv 23,295,528.34 49 0 475,418.95 10,749,310.03 2016-12-02 2016-12-30 28    
HMT_201701.csv 32,450,053.32 65 0 499,231.59 10,830,397.18 2017-01-04 2017-01-31 27    
HMT_201702.csv 23,734,375.76 54 0 439,525.48 9,986,632.57 2017-02-02 2017-02-28 26    
HMT_201703.csv 32,159,508.58 98 0 328,158.25 8,342,039.80 2017-03-02 2017-03-31 29    
HMT_201704.csv 28,543,706.85 34 0 839,520.79 10,601,118.50 2017-04-12 2017-04-28 16     Jump in AvgAmt
HMT_201705.csv 22,062,987.33 45 0 490,288.61 8,355,325.10 2017-05-03 2017-05-31 28    
HMT_201706.csv 53,184,517.27 71 0 749,077.71 34,897,967.00 2017-06-02 2017-06-30 28     Jump in TotalAmt.
HMT_201707.csv 33,531,204.86 62 0 540,825.88 15,750,000.00 2017-07-04 2017-07-31 27    
HMT_201708.csv 22,602,733.36 48 0 470,890.28 9,996,347.00 2017-08-02 2017-08-31 29    
HMT_201709.csv 32,624,080.32 56 0 582,572.86 12,000,000.00 2017-09-04 2017-09-29 25    
HMT_201710.csv 25,438,128.94 56 0 454,252.30 9,671,617.16 2017-10-03 2017-10-31 28    
HMT_201711.csv 21,286,618.96 57 0 373,449.46 10,872,294.66 2017-11-02 2017-11-30 28    
HMT_201712.csv 27,412,021.00 46 0 595,913.50 10,391,054.64 2017-12-04 2017-12-29 25    
HMT_201801.csv 22,373,395.55 56 0 399,524.92 6,993,299.14 2018-01-03 2018-01-31 28    
HMT_201802.csv 12,612,564.11 45 0 280,279.20 6,000,000.00 2018-02-02 2018-02-26 24    
HMT_201803.csv 18,712,325.69 79 0 236,864.88 7,000,000.00 2018-03-02 2018-03-29 27    
HMT_201804.csv 32,240,600.51 70 0 460,580.01 15,000,000.00 2018-04-04 2018-04-30 26    
HMT_201805.csv 38,659,337.65 70 0 552,276.25 15,000,000.00 2018-04-04 2018-05-31 57    
HMT_201806.csv 21,975,812.39 53 0 414,637.97 13,000,000.00 2018-06-04 2018-06-29 25    
HMT_201807.csv 20,230,981.55 45 0 449,577.37 12,090,000.00 2018-07-03 2018-07-31 28    
HMT_201808.csv 21,341,024.93 46 0 463,935.32 13,000,000.00 2018-08-02 2018-08-31 29    
HMT_201809.csv 20,185,102.05 51 0 395,786.31 13,500,000.00 2018-09-04 2018-09-28 24    
HMT_201810.csv 68,412,901.99 59 0 1,159,540.71 24,833,382.62 2018-10-02 2018-10-31 29     Jump in TotalAmt. Jump in AvgAmt
HMT_201811.csv 26,441,924.74 48 0 550,873.43 13,100,000.00 2018-11-02 2018-11-30 28     Drop in TotalAmt.
HMT_201812.csv 26,745,261.06 56 0 477,593.95 10,200,000.00 2018-12-04 2018-12-31 27    
HMT_201901.csv 15,598,956.52 58 0 268,947.53 5,100,000.00 2019-01-07 2019-01-31 24    
HMT_201902.csv 21,462,961.30 46 0 466,586.12 14,300,000.00 2019-02-04 2019-02-28 24    
HMT_201903.csv 30,394,113.19 72 0 422,140.46 13,500,000.00 2019-03-04 2019-03-29 25    
HMT_201904.csv 38,114,160.30 71 0 536,819.16 11,400,000.00 2019-04-02 2019-04-30 28    
HMT_201905.csv 23,186,312.14 75 0 309,150.83 10,100,000.00 2019-05-02 2019-05-31 29    
HMT_201906.csv 25,744,683.11 52 0 495,090.06 13,100,000.00 2019-06-04 2019-06-28 24    
HMT_201907.csv 24,390,322.09 60 0 406,505.37 13,800,000.00 2019-07-02 2019-07-31 29    
HMT_201908.csv 23,721,841.00 37 0 641,130.84 13,900,000.00 2019-08-02 2019-08-30 28    
HMT_201909.csv 21,018,981.44 44 0 477,704.12 13,000,000.00 2019-09-03 2019-09-30 27    
HMT_201910.csv 78,657,473.27 63 0 1,248,531.32 34,395,202.00 2019-10-02 2019-10-31 29     Jump in TotalAmt. Jump in AvgAmt
HMT_201911.csv 25,629,943.32 52 0 492,883.53 14,000,000.00 2019-04-11 2019-11-29 232     Drop in TotalAmt.
HMT_201912.csv 20,346,891.38 48 0 423,893.57 11,500,000.00 2019-03-12 2019-12-31 294    

Total amount : £2,086,455,993.06 in 5,392 records from 108 source files (mean= £19,319,037 and 49 recs/mth) (Range=2011/01 - 2019/12)

OrigRecs shows the number of records that were in the original source file.
AggRecs shows the number of records if aggregation has been used - similar transactions (eg for the same supplier in the same month with the same expenditure type etc) have been combined together to give a single record with a total amount and the date set to the first of the month. Typically this results in a 70% reduction in the number of records.
AvgAmt shows the average (mean) transaction value per original record in that file. One might expect this value to be roughly constant across files.
MaxAmt shows the value of the single largest transaction in that file. Note that errors may be reversed out by subsequent contrary transactions.
MinDate shows the earliest transaction date in that file. MaxDate shows the highest transaction date. Diff shows the difference in days.
Comment highlights significant potential anomalies - large increases/decreases in Total Amt or Avg Amt.


Acknowledgement: Spend data provided by this department has been re-used under the Open Government Licence.