Summary of currently loaded spend data for: Department for Business, Energy & Industrial Strategy

Lastfile: BEIS_201903
File name TotalAmt£ OrigRecs AggRecs     AvgAmt£ MaxAmt£           MinDate       MaxDate     Diff     Comment
BEIS_201608.csv 1,856,784,149.70 2994 0 620,168.39 226,000,000.00 2016-08-01 2016-08-31 30    
BEIS_201609.csv 1,679,069,934.31 2989 0 561,749.73 240,000,000.00 2016-09-01 2016-09-30 29    
BEIS_201610.csv 1,179,700,331.54 3008 0 392,187.61 260,000,000.00 2016-10-01 2016-10-31 30    
BEIS_201611.csv 906,265,743.16 3712 0 244,144.87 97,000,000.00 2016-11-01 2016-11-30 29    
BEIS_201612.csv 1,568,376,388.96 3612 0 434,212.73 227,000,000.00 2016-12-01 2016-12-30 29    
BEIS_201701.csv 1,743,011,107.43 3131 0 556,694.70 290,000,000.00 2017-01-03 2017-01-31 28    
BEIS_201702.csv 1,139,608,072.59 3105 0 367,023.53 87,000,000.00 2017-02-01 2017-02-28 27    
BEIS_201703.csv 19,175,374,596.60 4463 0 4,296,521.31 16,984,597,346.80 2017-03-01 2017-03-31 30     Large jump in TotalAmt. Jump in AvgAmt
BEIS_201704.csv 2,117,652,259.88 1424 0 1,487,115.35 644,000,000.00 2017-04-01 2017-04-01 0     Large drop in TotalAmt.
BEIS_201705.csv 1,572,164,651.36 1429 0 1,100,185.20 662,000,000.00 2017-05-01 2017-05-01 0    
BEIS_201706.csv 2,169,006,260.26 1324 0 1,638,222.25 690,000,000.00 2017-06-01 2017-06-01 0    
BEIS_201707.csv 1,924,981,271.68 1398 0 1,376,953.70 532,000,000.00 2017-07-01 2017-07-01 0    
BEIS_201708.csv 1,681,280,936.09 1142 0 1,472,224.99 772,000,000.00 2017-08-01 2017-08-01 0    
BEIS_201709.csv 3,206,489,492.74 2732 1062 1,173,678.44 1,621,094,654.00 2017-09-01 2017-09-01 0    
BEIS_201804.csv 1,908,705,226.31 3376 1325 565,374.77 446,000,000.00 2018-04-01 2018-04-01 0    
BEIS_201805.csv 1,898,310,992.29 3473 1182 546,591.13 755,000,000.00 2018-05-01 2018-05-01 0    
BEIS_201806.csv 1,864,020,944.85 3245 1219 574,428.64 522,000,000.00 2018-06-01 2018-06-01 0    
BEIS_201807.csv 1,411,050,685.64 3178 1206 444,005.88 686,000,000.00 2018-07-01 2018-07-01 0    
BEIS_201808.csv 1,741,732,665.36 3260 1145 534,273.82 646,000,000.00 2018-08-01 2018-08-01 0    
BEIS_201809.csv 1,708,888,828.28 2670 1041 640,033.27 552,500,000.00 2018-09-01 2018-09-01 0    
BEIS_201810.csv 1,877,082,096.03 3436 1122 546,298.63 617,000,000.00 2018-10-01 2018-10-01 0    
BEIS_201811.csv 1,505,182,316.43 3701 1105 406,696.11 500,000,000.00 2018-11-01 2018-11-01 0    
BEIS_201812.csv 2,065,357,199.69 3761 1102 549,151.08 551,000,000.00 2018-12-01 2018-12-01 0    
BEIS_201901.csv 1,591,236,658.77 3712 1221 428,673.67 298,000,000.00 2019-01-01 2019-01-01 0    
BEIS_201902.csv 1,714,557,179.78 3791 1201 452,270.42 434,000,000.00 2019-02-01 2019-02-01 0    
BEIS_201903.csv 1,989,306,799.22 5432 1566 366,219.96 448,000,000.00 2019-03-01 2019-03-01 0    

Total amount : £63,195,196,788.95 in 49,228 records from 26 source files (mean= £2,430,584,492 and 1,893 recs/mth) (Range=2016/08 - 2019/03)

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.