Getting UK tax data with hmrc

Discovery

hmrc_search() searches the dataset catalogue by keyword. hmrc_publications() returns a tidy index of implemented and planned datasets.

# Anything in the catalogue mentioning capital gains
hmrc_search("capital gains")

# Only annual datasets already implemented
hmrc_search(implemented = TRUE, frequency = "annual")

Monthly tax receipts

hmrc_tax_receipts() downloads the monthly HMRC Tax Receipts and National Insurance Contributions bulletin, covering 42 series. HMRC’s monthly table is a rolling window, currently from April 2017 to the most recent published month.

# All 42 series
receipts <- hmrc_tax_receipts()
head(receipts)

Use hmrc_list_tax_heads() to see all available identifiers without downloading data:

hmrc_list_tax_heads()

Filter to specific heads and date ranges:

big_three <- hmrc_tax_receipts(
  tax   = c("income_tax", "vat", "nics_total"),
  start = "2020-01"
)

Inspect the provenance metadata on any result:

m <- hmrc_meta(big_three)
m$source_url    # publication page
m$published_at  # GOV.UK publication time of the edition used

library(ggplot2)

ggplot(big_three, aes(x = date, y = receipts_gbp_m / 1000, colour = description)) +
  geom_line(linewidth = 0.8) +
  scale_y_continuous(labels = scales::label_comma(suffix = "bn")) +
  labs(
    title   = "UK monthly tax receipts",
    x       = NULL,
    y       = "GBP billions",
    colour  = NULL,
    caption = "Source: HMRC Tax Receipts and NICs bulletin"
  ) +
  theme_minimal(base_size = 12) +
  theme(legend.position = "bottom")

VAT

hmrc_vat() covers monthly VAT receipts from April 1973, broken into payments, repayments, import VAT, and home VAT.

# Net VAT: total minus repayments
vat <- hmrc_vat(measure = c("total", "repayments"), start = "2015-01")

# Repayments are recorded as negative (money flowing out of HMRC)
head(vat[vat$measure == "repayments", c("date", "receipts_gbp_m")])

Fuel duties

hmrc_fuel_duties() covers monthly hydrocarbon oil duty receipts from January 1990, broken down into petrol, diesel, other, and total. The provisional column marks months HMRC has not yet finalised.

fuel <- hmrc_fuel_duties(fuel = "total", start = "2010-01")

# Annual totals
fuel$year <- format(fuel$date, "%Y")
aggregate(receipts_gbp_m ~ year, data = fuel, FUN = sum)

Tobacco duties

hmrc_tobacco_duties() covers monthly tobacco duty receipts from January 1991, by product: cigarettes, cigars, hand-rolling tobacco, other, and total.

tobacco <- hmrc_tobacco_duties(product = c("cigarettes", "hand_rolling"),
                               start   = "2015-01")

Corporation Tax

hmrc_corporation_tax() returns annual Corporation Tax receipts broken down by levy type: onshore CT, offshore CT, Bank Levy, Bank Surcharge, Residential Property Developer Tax (RPDT), Energy Profits Levy (EPL), and Electricity Generators Levy (EGL). Covers the latest six financial years.

ct <- hmrc_corporation_tax()
ct[ct$type == "total_ct", c("tax_year", "receipts_gbp_m")]

Stamp duty

hmrc_stamp_duty() returns annual stamp duty receipts by type from 2003-04: SDLT on property, SDLT on new leases, SDRT on shares, stamp duty on documents, and the share and overall totals.

sd <- hmrc_stamp_duty(type = c("sdlt_total", "total"))
tail(sd[, c("tax_year", "type", "receipts_gbp_m")], 6)

R&D tax credits

hmrc_rd_credits() returns annual statistics on R&D tax credit claims and their cost by scheme (SME R&D Relief and RDEC) from 2000-01.

# Cost of R&D credits: SME vs RDEC
rd <- hmrc_rd_credits(measure = "amount_gbp_m")
rd[rd$tax_year == "2023-24", c("scheme", "description", "value")]

Capital Gains Tax

hmrc_capital_gains() returns annual estimates of CGT taxpayers, gains, and tax liabilities from 1987-88 (HMRC CGT Table 1).

# Total CGT receipts over time
cgt <- hmrc_capital_gains(measure = "tax_total_gbp_m")
tail(cgt[, c("tax_year", "value")], 6)

Inheritance Tax

hmrc_inheritance_tax() returns IHT estate counts, tax due, average tax, and effective tax rates (in per cent) by net-estate band for the latest published year of death (HMRC IHT Table 12.1a). It is published about two years after the year of death.

iht <- hmrc_inheritance_tax()
iht[iht$measure == "number_taxed" & iht$estate_band != "Total",
    c("estate_band", "value")]

Patent Box

hmrc_patent_box() returns the annual count of companies electing into the Patent Box and total relief claimed (HMRC Patent Box Table 1) from 2013-14 onwards.

hmrc_patent_box()

Creative Industries reliefs

hmrc_creative_industries() returns annual reliefs across the eight creative industries reliefs (film, high-end TV, animation, children’s TV, video games, theatre, orchestra, museums and galleries).

# Film tax relief over time
hmrc_creative_industries(sector = "film")

# All eight sectors in the latest year
hmrc_creative_industries(tax_year = "2023-24")

Tax gap

hmrc_tax_gap() returns the tax gap from 2005-06 by tax and taxpayer group, as a per cent of theoretical liabilities and in GBP billion. Each June edition revises the whole series.

# Total tax gap over time
total <- hmrc_tax_gap(tax = "Total tax gap")
total[, c("tax_year", "gap_pct", "gap_gbp_bn")]

# Largest components in the latest year
latest <- hmrc_tax_gap(tax_year = "latest")
head(latest[order(-latest$gap_gbp_bn), c("tax", "type", "component", "gap_gbp_bn")])

Income Tax liabilities

hmrc_income_tax_stats() returns Income Tax liabilities by income range (HMRC Table 2.5), including taxpayer counts, total income, tax liabilities, and average tax rates in per cent. The earliest year is outturn from the Survey of Personal Incomes and later years are projections, marked in the estimate column.

it <- hmrc_income_tax_stats(tax_year = "2023-24")
it[, c("income_range", "taxpayers_thousands", "tax_liability_gbp_m", "average_rate_pct")]

Property transactions

hmrc_property_transactions() returns monthly counts of residential and non-residential property transactions by UK nation from April 2005.

prop <- hmrc_property_transactions(
  type   = "residential",
  nation = "uk",
  start  = "2018-01"
)

ggplot(prop, aes(x = date, y = transactions / 1000)) +
  geom_line(colour = "#3B82F6", linewidth = 0.8) +
  scale_y_continuous(labels = scales::label_comma(suffix = "k")) +
  labs(
    title   = "UK residential property transactions",
    x       = NULL,
    y       = "Transactions (thousands)",
    caption = "Source: HMRC Monthly Property Transactions bulletin"
  ) +
  theme_minimal(base_size = 12)

Caching

All downloads are cached in your user cache directory. Each call checks the GOV.UK Content API for the current edition and reuses the cached file unless HMRC has published a new one.

# Inspect the cache
hmrc_cache_info()

# Remove files older than 30 days
hmrc_clear_cache(max_age_days = 30)

# Remove everything and start fresh
hmrc_clear_cache()