The spreadsheet below sets out monthly details of HM Revenue & Customs (HMRC) expenditure with suppliers covering transactions that exceed £25,000.
Key points about report contents
Signage of amounts
Invoice amounts are shown as positive (debit) values. Credit Note/Memo amounts are shown as negative (credit) values and are preceded by a minus sign (‘-‘).
Dates shown are Payment dates; in this instance the date when the expense posting to the Trade Creditor account is cleared down by payment.
Amounts and tax
All figures shown are gross amounts paid inclusive of VAT.
Expense type entries
Entries in this column are ‘Material Group’ descriptions defined within HMRC’s ERP (Enterprise Resource Planning) system. This is the greatest level of detail (lowest level of granularity) that any commercial purchase is described in within the ERP system. Although limited by system text field length restrictions, this field information provides the most detailed description of the goods/services purchased and also provides for data collection/comparison/interrogation month-on-month from one period to the next.
Line amounts less than £25,000
HM Treasury Guidance states: ‘If a single invoice has been coded to multiple expense types, and/or expense areas the value shown should be the amount paid against each individual expense types/expense area combination, even where each entry at this level may be less than £25,000.’
In line with this our report discloses paid invoice expenditure where the gross value of the entire invoice is greater than £25,000 and breaks this down into separate invoice lines where more than one expense type/expense area is involved resulting in some entries with line amount less than £25,000.