Summary of currently loaded spend data for: HM Revenue and Customs

Lastfile: HMRC_201912
File name TotalAmt£ OrigRecs AggRecs     AvgAmt£ MaxAmt£           MinDate       MaxDate     Diff     Comment
HMRC_201101.csv 51,884,636.79 188 0 275,982.11 17,183,005.62 2011-01-05 2011-01-31 26    
HMRC_201102.csv 27,014,394.42 135 0 200,106.63 3,641,756.89 2011-02-01 2011-02-28 27    
HMRC_201103.csv 136,961,734.87 317 0 432,055.95 59,002,463.15 2011-03-01 2011-03-30 29     Large jump in TotalAmt. Jump in AvgAmt
HMRC_201104.csv 147,554,017.63 217 0 679,972.43 59,966,960.77 2011-04-01 2011-04-28 27    
HMRC_201105.csv 122,244,788.81 234 0 522,413.63 61,760,381.67 2011-05-03 2011-05-27 24    
HMRC_201106.csv 229,262,063.37 292 0 785,144.05 56,866,619.02 2011-06-01 2011-06-30 29    
HMRC_201107.csv 63,642,457.09 288 0 220,980.75 17,079,548.30 2011-07-01 2011-07-29 28     Drop in TotalAmt.
HMRC_201108.csv 216,707,599.61 229 0 946,321.40 57,605,528.22 2011-08-01 2011-08-30 29     Jump in TotalAmt. Jump in AvgAmt
HMRC_201109.csv 138,940,773.18 360 0 385,946.59 18,784,637.94 2011-09-01 2011-09-30 29    
HMRC_201110.csv 117,341,332.25 381 0 307,982.50 24,758,506.90 2011-10-03 2011-10-31 28    
HMRC_201111.csv 51,329,899.12 288 0 178,228.82 16,503,955.09 2011-11-01 2011-11-30 29    
HMRC_201112.csv 216,958,030.21 504 0 430,472.28 25,654,361.67 2011-12-01 2011-12-30 29     Large jump in TotalAmt. Jump in AvgAmt
HMRC_201201.csv 128,954,200.36 904 0 142,648.45 26,067,724.44 2012-01-03 2012-01-31 28    
HMRC_201202.csv 120,136,073.01 436 0 275,541.45 27,103,285.44 2012-01-08 2012-02-29 52    
HMRC_201203.csv 152,167,771.98 559 0 272,214.26 34,904,402.34 2012-03-01 2012-03-30 29    
HMRC_201204.csv 138,834,932.25 641 0 216,591.16 16,353,325.25 2012-04-02 2012-04-30 28    
HMRC_201205.csv 174,793,069.05 1000 0 174,793.07 73,966,134.76 2012-05-01 2012-05-31 30    
HMRC_201206.csv 118,746,635.12 364 0 326,227.02 13,787,104.54 2012-06-01 2012-06-29 28    
HMRC_201207.csv 139,066,360.15 387 0 359,344.60 27,953,850.32 2012-07-02 2012-07-31 29    
HMRC_201208.csv 124,247,051.77 1033 0 120,277.88 14,220,770.89 2012-08-01 2012-08-31 30    
HMRC_201209.csv 121,065,728.37 371 0 326,322.72 20,456,808.25 2012-09-03 2012-09-28 25     Jump in AvgAmt
HMRC_201210.csv 118,911,737.20 345 0 344,671.70 21,395,310.40 2012-10-01 2012-10-31 30    
HMRC_201211.csv 114,434,391.77 386 0 296,462.15 14,296,992.36 2012-11-01 2012-11-30 29    
HMRC_201212.csv 189,047,185.41 328 0 576,363.37 65,000,000.00 2012-12-03 2012-12-31 28    
HMRC_201301.csv 65,610,268.21 378 0 173,572.14 22,585,659.41 2013-01-02 2013-01-31 29     Drop in TotalAmt.
HMRC_201302.csv 114,238,701.92 368 0 310,431.26 14,183,951.66 2013-02-04 2013-02-28 24    
HMRC_201303.csv 144,237,911.69 494 0 291,979.58 26,557,902.80 2013-03-01 2013-03-28 27    
HMRC_201304.csv 153,336,248.43 680 0 225,494.48 22,918,209.26 2013-04-02 2013-04-30 28    
HMRC_201305.csv 204,130,099.85 341 0 598,621.99 105,595,435.41 2013-05-01 2013-05-31 30     Jump in AvgAmt
HMRC_201306.csv 112,555,857.91 320 0 351,737.06 27,110,625.69 2013-06-03 2013-06-28 25    
HMRC_201307.csv 121,775,679.82 534 0 228,044.34 24,957,566.18 2013-07-01 2013-07-31 30    
HMRC_201308.csv 124,252,615.36 378 0 328,710.62 21,784,023.47 2013-08-01 2013-08-30 29    
HMRC_201309.csv 115,252,201.54 393 0 293,262.60 26,793,984.73 2013-09-02 2013-09-30 28    
HMRC_201310.csv 107,837,101.14 357 0 302,064.71 19,058,411.66 2013-10-01 2013-10-31 30    
HMRC_201311.csv 117,438,364.91 389 0 301,898.11 27,477,761.86 2013-11-01 2013-11-29 28    
HMRC_201312.csv 118,368,706.20 371 0 319,053.12 26,093,643.68 2013-12-02 2013-12-31 29    
HMRC_201401.csv 112,179,859.02 441 0 254,376.10 24,458,660.69 2014-01-02 2014-01-31 29    
HMRC_201402.csv 115,740,056.83 385 0 300,623.52 19,786,607.98 2014-02-03 2014-02-28 25    
HMRC_201403.csv 168,914,154.62 850 0 198,722.53 29,342,027.32 2014-03-03 2014-03-31 28    
HMRC_201404.csv 127,907,271.57 804 0 159,088.65 31,965,093.05 2014-04-02 2014-04-30 28    
HMRC_201405.csv 139,219,065.45 464 0 300,041.09 24,041,258.11 2014-05-01 2014-05-30 29    
HMRC_201406.csv 152,313,386.93 586 0 259,920.46 43,037,715.46 2014-06-02 2014-06-30 28    
HMRC_201407.csv 116,062,820.90 579 0 200,453.92 17,257,683.18 2014-07-01 2014-07-31 30    
HMRC_201408.csv 133,681,422.58 524 0 255,117.22 16,847,633.53 2014-08-01 2014-08-29 28    
HMRC_201409.csv 127,306,394.09 544 0 234,019.11 25,894,377.74 2014-09-01 2014-09-30 29    
HMRC_201410.csv 103,085,089.13 793 0 129,993.81 11,505,900.28 2014-10-01 2014-10-31 30    
HMRC_201411.csv 119,558,891.49 419 0 285,343.42 23,280,097.82 2014-11-03 2014-11-28 25     Jump in AvgAmt
HMRC_201412.csv 138,212,619.43 528 0 261,766.32 24,476,101.98 2014-12-01 2014-12-31 30    
HMRC_201501.csv 111,053,550.69 497 0 223,447.79 12,953,468.44 2015-01-02 2015-01-30 28    
HMRC_201502.csv 110,027,764.73 435 0 252,937.39 16,646,292.09 2015-02-02 2015-02-27 25    
HMRC_201503.csv 162,836,650.28 779 0 209,032.93 26,584,544.47 2015-03-02 2015-03-31 29    
HMRC_201504.csv 123,720,390.22 689 0 179,565.15 11,721,254.75 2015-04-01 2015-04-30 29    
HMRC_201505.csv 163,052,728.34 516 0 315,993.66 60,415,147.58 2015-05-01 2015-08-05 96    
HMRC_201506.csv 110,355,677.55 620 0 177,993.03 10,642,821.79 2015-06-01 2015-06-30 29    
HMRC_201507.csv 139,396,413.02 563 0 247,595.76 19,295,196.43 2015-07-01 2015-07-31 30    
HMRC_201508.csv 134,915,456.05 526 0 256,493.26 17,735,415.91 2015-08-03 2015-08-28 25    
HMRC_201509.csv 127,940,232.62 621 0 206,022.92 19,534,883.66 2015-09-01 2015-09-30 29    
HMRC_201510.csv 113,719,251.11 496 0 229,272.68 16,890,770.59 2015-10-01 2015-10-30 29    
HMRC_201511.csv 135,106,965.25 455 0 296,938.39 18,238,404.41 2015-11-02 2015-11-30 28    
HMRC_201512.csv 134,966,762.15 593 0 227,599.94 21,739,483.87 2015-12-01 2015-12-31 30    
HMRC_201601.csv 128,648,171.72 463 0 277,857.82 14,155,745.50 2016-01-04 2016-01-29 25    
HMRC_201602.csv 132,024,099.99 548 0 240,919.89 11,957,269.37 2016-02-01 2016-02-29 28    
HMRC_201603.csv 183,060,136.14 832 0 220,024.20 23,720,718.74 2016-03-01 2016-03-31 30    
HMRC_201604.csv 125,217,769.26 601 0 208,349.03 12,912,476.87 2016-04-01 2016-04-29 28    
HMRC_201605.csv 176,674,680.95 533 0 331,472.20 53,419,402.15 2016-05-03 2016-05-31 28    
HMRC_201606.csv 134,577,833.07 555 0 242,482.58 12,144,138.85 2016-06-01 2016-06-30 29    
HMRC_201607.csv 127,166,736.03 588 0 216,269.96 16,360,989.98 2016-07-01 2016-07-29 28    
HMRC_201608.csv 123,195,689.84 531 0 232,006.95 16,830,359.67 2016-08-01 2016-08-31 30    
HMRC_201609.csv 142,733,083.46 575 0 248,231.45 13,585,281.13 2016-09-01 2016-09-30 29    
HMRC_201610.csv 153,999,873.66 536 0 287,313.20 17,419,457.00 2016-10-03 2016-10-31 28    
HMRC_201611.csv 156,765,975.52 555 0 282,461.22 21,995,415.40 2016-11-01 2016-11-30 29    
HMRC_201612.csv 153,539,322.45 590 0 260,236.14 17,645,549.26 2016-12-01 2016-12-30 29    
HMRC_201701.csv 144,858,574.62 504 0 287,417.81 25,475,955.27 2017-01-03 2017-01-31 28    
HMRC_201702.csv 146,098,465.90 1062 0 137,569.18 14,513,096.29 2017-02-01 2017-02-28 27    
HMRC_201703.csv 202,021,359.91 1053 0 191,853.14 18,966,357.45 2017-03-01 2017-03-31 30    
HMRC_201704.csv 136,175,755.44 752 0 181,084.78 40,410,085.32 2017-04-03 2017-04-28 25    
HMRC_201705.csv 177,144,587.95 630 0 281,181.89 36,514,472.06 2017-05-02 2017-05-31 29    
HMRC_201706.csv 145,854,169.48 686 0 212,615.41 14,122,646.26 2017-06-01 2017-06-30 29    
HMRC_201707.csv 117,567,612.72 426 0 275,980.31 12,008,327.18 2017-07-03 2017-07-31 28    
HMRC_201708.csv 119,641,402.60 427 0 280,190.64 32,856,478.14 2017-08-01 2017-08-31 30    
HMRC_201709.csv 140,666,270.05 468 0 300,568.95 19,365,648.63 2017-09-01 2017-09-29 28    
HMRC_201710.csv 117,730,555.33 432 0 272,524.43 14,136,808.99 2017-10-02 2017-10-31 29    
HMRC_201711.csv 99,118,920.14 440 0 225,270.27 14,783,309.96 2017-11-01 2017-11-30 29    
HMRC_201712.csv 131,644,949.41 445 0 295,831.35 18,528,332.97 2017-12-01 2017-12-29 28    
HMRC_201801.csv 125,763,073.91 406 0 309,761.27 16,190,418.59 2018-01-02 2018-01-31 29    
HMRC_201802.csv 105,227,869.46 401 0 262,413.64 10,046,745.01 2018-02-01 2018-02-28 27    
HMRC_201803.csv 146,564,334.44 674 0 217,454.50 19,223,846.50 2018-03-01 2018-03-29 28    
HMRC_201804.csv 113,469,797.05 490 0 231,571.01 16,118,871.24 2018-04-03 2018-04-30 27    
HMRC_201805.csv 140,474,886.53 479 0 293,266.99 20,043,958.22 2018-05-01 2018-05-31 30    
HMRC_201806.csv 118,147,376.00 517 0 228,524.91 15,118,847.63 2018-06-01 2018-06-29 28    
HMRC_201807.csv 117,497,681.85 399 0 294,480.41 17,050,710.41 2018-07-02 2018-07-31 29    
HMRC_201808.csv 115,034,869.00 410 0 280,572.85 18,253,824.57 2018-08-01 2018-08-31 30    
HMRC_201809.csv 118,461,709.02 406 0 291,777.61 17,265,919.80 2018-09-03 2018-09-28 25    
HMRC_201810.csv 116,977,246.00 439 0 266,462.97 18,429,991.71 2018-10-01 2018-10-31 30    
HMRC_201811.csv 117,806,966.18 449 0 262,376.32 24,299,116.91 2018-11-01 2018-11-30 29    
HMRC_201812.csv 150,908,438.34 423 0 356,757.54 23,047,847.69 2018-12-03 2018-12-31 28    
HMRC_201901.csv 120,339,027.70 440 0 273,497.79 19,702,493.79 2019-01-02 2019-01-31 29    
HMRC_201902.csv 122,264,896.10 441 0 277,244.66 15,481,371.40 2019-02-01 2019-02-28 27    
HMRC_201903.csv 185,972,326.56 746 0 249,292.66 23,489,137.33 2019-03-01 2019-03-29 28    
HMRC_201904.csv 149,894,291.00 549 0 273,031.50 23,294,092.54 2019-04-01 2019-04-30 29    
HMRC_201905.csv 140,974,429.71 480 0 293,696.73 25,920,043.19 2019-05-01 2019-05-31 30    
HMRC_201906.csv 152,638,082.67 458 0 333,270.92 21,599,712.38 2019-06-03 2019-06-28 25    
HMRC_201907.csv 135,462,335.25 418 0 324,072.57 20,285,412.30 2019-07-01 2019-07-31 30    
HMRC_201908.csv 117,963,288.96 388 0 304,029.10 18,995,437.50 2019-08-01 2019-08-30 29    
HMRC_201909.csv 128,785,894.36 427 0 301,606.31 23,017,898.94 2019-09-02 2019-09-30 28    
HMRC_201910.csv 149,314,660.68 505 0 295,672.60 23,642,416.14 2019-10-01 2019-10-31 30    
HMRC_201911.csv 128,486,395.10 402 0 319,617.90 27,788,209.02 2019-11-01 2019-11-29 28    
HMRC_201912.csv 149,133,623.32 460 0 324,203.53 30,562,149.35 2019-12-02 2019-12-31 29    

Total amount : £14,364,242,989.65 in 54,336 records from 108 source files (mean= £133,002,250 and 503 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.