Spend Over £25,000 In HM Revenue & Customs
HM Revenue and Customs
@ukgov.financial_transactions_data_hmrc
HM Revenue and Customs
@ukgov.financial_transactions_data_hmrc
The spreadsheets below set out monthly details of HMRC’s and Revenue and Customs Digital Technology Services Limited (RCDTS) spending with suppliers covering transactions over £25,000. RCDTS was closed in 2023. A list of abbreviations and terms used by HMRC when recording spend with suppliers, can be found : https://www.gov.uk/government/publications/hmrc-glossary-of-terms-used-in-departmental-spending-over-25000-pages
Publisher name: HM Revenue and Customs
Last updated: 2025-05-01T04:00:24Z
CREATE TABLE november_2019_return (
"department_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" DOUBLE,
"amount" DOUBLE,
"description" VARCHAR,
"supplier_postcode" VARCHAR,
"supplier_type" VARCHAR,
"contract_number" VARCHAR,
"project_code" VARCHAR,
"expenditure_type" VARCHAR
);CREATE TABLE november_2019_return_rcdts (
"department_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" DOUBLE,
"amount" DOUBLE,
"description" VARCHAR,
"supplier_postcode" VARCHAR,
"supplier_type" VARCHAR,
"contract_number" VARCHAR,
"project_code" VARCHAR,
"expenditure_type" VARCHAR
);CREATE TABLE november_2020_return (
"department_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" BIGINT,
"amount" DOUBLE,
"description" VARCHAR,
"supplier_postcode" VARCHAR,
"supplier_type" VARCHAR,
"contract_number" VARCHAR,
"project_code" VARCHAR,
"expenditure_type" VARCHAR
);CREATE TABLE november_2020_return_rcdts (
"department_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" BIGINT,
"amount" DOUBLE,
"description" VARCHAR,
"supplier_postcode" VARCHAR,
"supplier_type" VARCHAR,
"contract_number" VARCHAR,
"project_code" VARCHAR,
"expenditure_type" VARCHAR
);CREATE TABLE november_2021_return (
"department_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" DOUBLE,
"amount" DOUBLE,
"description" VARCHAR,
"supplier_postcode" VARCHAR,
"supplier_type" VARCHAR,
"contract_number" VARCHAR,
"project_code" VARCHAR,
"expenditure_type" VARCHAR
);CREATE TABLE november_2021_return_rcdts (
"department_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" DOUBLE,
"amount" DOUBLE,
"description" VARCHAR,
"supplier_postcode" VARCHAR,
"supplier_type" VARCHAR,
"contract_number" VARCHAR,
"project_code" VARCHAR,
"expenditure_type" VARCHAR
);CREATE TABLE october_2019_return (
"department_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" DOUBLE,
"amount" DOUBLE,
"description" VARCHAR,
"supplier_postcode" VARCHAR,
"supplier_type" VARCHAR,
"contract_number" VARCHAR,
"project_code" VARCHAR,
"expenditure_type" VARCHAR
);CREATE TABLE october_2019_return_rcdts (
"department_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" DOUBLE,
"amount" DOUBLE,
"description" VARCHAR,
"supplier_postcode" VARCHAR,
"supplier_type" VARCHAR,
"contract_number" VARCHAR,
"project_code" VARCHAR,
"expenditure_type" VARCHAR
);CREATE TABLE october_2020_return (
"department_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" BIGINT,
"amount" DOUBLE,
"description" VARCHAR,
"supplier_postcode" VARCHAR,
"supplier_type" VARCHAR,
"contract_number" VARCHAR,
"project_code" VARCHAR,
"expenditure_type" VARCHAR
);CREATE TABLE october_2020_return_rcdts (
"department_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" BIGINT,
"amount" DOUBLE,
"description" VARCHAR,
"supplier_postcode" VARCHAR,
"supplier_type" VARCHAR,
"contract_number" VARCHAR,
"project_code" VARCHAR,
"expenditure_type" VARCHAR
);CREATE TABLE october_2021_return (
"department_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" DOUBLE,
"amount" DOUBLE,
"description" VARCHAR,
"supplier_postcode" VARCHAR,
"supplier_type" VARCHAR,
"contract_number" VARCHAR,
"project_code" VARCHAR,
"expenditure_type" VARCHAR
);CREATE TABLE october_2021_return_rcdts (
"department_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" DOUBLE,
"amount" DOUBLE,
"description" VARCHAR,
"supplier_postcode" VARCHAR,
"supplier_type" VARCHAR,
"contract_number" VARCHAR,
"project_code" VARCHAR,
"expenditure_type" VARCHAR
);CREATE TABLE october_2024_return (
"department_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" BIGINT,
"amount" DOUBLE,
"description" VARCHAR,
"supplier_postcode" VARCHAR,
"supplier_type" VARCHAR,
"contract_number" VARCHAR,
"project_code" VARCHAR
);CREATE TABLE september_2019_return (
"department_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" DOUBLE,
"amount" DOUBLE,
"description" VARCHAR,
"supplier_postcode" VARCHAR,
"supplier_type" VARCHAR,
"contract_number" VARCHAR,
"project_code" VARCHAR,
"expenditure_type" VARCHAR
);CREATE TABLE september_2019_return_rcdts (
"department_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" DOUBLE,
"amount" DOUBLE,
"description" VARCHAR,
"supplier_postcode" VARCHAR,
"supplier_type" VARCHAR,
"contract_number" VARCHAR,
"project_code" VARCHAR,
"expenditure_type" VARCHAR
);CREATE TABLE september_2020_return (
"department_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" BIGINT,
"amount" DOUBLE,
"description" VARCHAR,
"supplier_postcode" VARCHAR,
"supplier_type" VARCHAR,
"contract_number" VARCHAR,
"project_code" VARCHAR,
"expenditure_type" VARCHAR
);CREATE TABLE september_2020_return_rcdts (
"department_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" BIGINT,
"amount" DOUBLE,
"description" VARCHAR,
"supplier_postcode" VARCHAR,
"supplier_type" VARCHAR,
"contract_number" VARCHAR,
"project_code" VARCHAR,
"expenditure_type" VARCHAR
);CREATE TABLE september_2021_return (
"department_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" DOUBLE,
"amount" DOUBLE,
"description" VARCHAR,
"supplier_postcode" VARCHAR,
"supplier_type" VARCHAR,
"contract_number" VARCHAR,
"project_code" VARCHAR,
"expenditure_type" VARCHAR
);CREATE TABLE september_2021_return_rcdts (
"department_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" DOUBLE,
"amount" DOUBLE,
"description" VARCHAR,
"supplier_postcode" VARCHAR,
"supplier_type" VARCHAR,
"contract_number" VARCHAR,
"project_code" VARCHAR,
"expenditure_type" VARCHAR
);CREATE TABLE september_2022_return (
"department_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" DOUBLE,
"amount" DOUBLE,
"description" VARCHAR,
"supplier_postcode" VARCHAR,
"supplier_type" VARCHAR,
"contract_number" VARCHAR,
"project_code" VARCHAR,
"expenditure_type" VARCHAR
);CREATE TABLE september_2022_return_rcdts (
"department_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" DOUBLE,
"amount" DOUBLE,
"description" VARCHAR,
"supplier_postcode" VARCHAR,
"supplier_type" VARCHAR,
"contract_number" VARCHAR,
"project_code" VARCHAR,
"expenditure_type" VARCHAR
);CREATE TABLE september_2024_return (
"department_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" DOUBLE,
"amount" DOUBLE,
"description" VARCHAR,
"supplier_postcode" VARCHAR,
"supplier_type" VARCHAR,
"contract_number" VARCHAR,
"project_code" VARCHAR,
"expenditure_type" VARCHAR
);CREATE TABLE spend_over_25_000_in_hm_revenue_customs (
"department_family" VARCHAR,
"entity" VARCHAR,
"date" VARCHAR,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" BIGINT,
"amount" VARCHAR,
"description" VARCHAR,
"supplier_postcode" VARCHAR,
"supplier_type" VARCHAR,
"contract_number" VARCHAR,
"project_type" VARCHAR,
"expenditure_type" VARCHAR,
"unnamed_14" VARCHAR -- Unnamed: 14
);Anyone who has the link will be able to view this.