Guidance

How to complete a bank and building society interest return

Find out how to complete and submit a return using the HMRC spreadsheet or electronic flat text file (EFTF).

HMRC requires UK banks and building societies to annually submit information about interest paid or credited.

Schedule 23 of the Finance Act 2011 places a legal obligation on you to submit data:

  • by the due date
  • using one of the ways suggested in the format and structure section of this guide

If you submit data in the wrong format, your return is classed as outstanding until it’s correctly submitted. You can receive a penalty of up to:

  • £1,000 a day if you do not comply
  • £3,000 for an incorrect return

This guidance will help you to format and submit your return correctly. You can refer to the Bank and building society interest returns guidance for background information and to find out more about who to include in your return.

Format and structure (sub-returns, batches, labelling)

Choose the format for your return

Bank and building society interest (BBSI) returns can be formatted in one of the following ways:

Your return is made up of all the data you hold on ‘reportable persons’. Depending on the size and structure of your organisation, this data can be organised into:

  • sub-returns
  • batches

Sub-returns

If you’re submitting a lot of data, your return can be made up of one or more sub-returns.

As an example, bank A has 5 branches and each branch produces a BBSI return. These are called sub-returns and together they make up bank A’s bank and building society interest return.

You can choose how to format of a sub-return — either spreadsheet or text file — but mixed formats are not acceptable.

Sub-returns produced across different sites

Sometimes the data for a single sub-return is produced at more than one site. If each site then submits the data separately, HMRC will assume the first submission received is the complete sub-return.

To prevent this you should either:

  • split the sub-return into separate sub-returns (one from each site) and request unique sub-return numbers for each site
  • collate all the data centrally to make sure it’s submitted together as one sub-return

Sub-return number requests and updates

You need to tell us by 31 January each year about:

  • additional sub-return numbers needed to make your return
  • existing sub-return numbers no longer needed

You can tell us about your tax period sub-return by sending an email to: da.enquiries@hmrc.gov.uk.

Incomplete sub-returns

If you identify any omissions from a sub-return after submission, you should tell HMRC immediately by emailing da.enquiries@hmrc.gov.uk.

Do not resubmit the complete return containing the omitted items as this could result in some data being captured twice.

You must include:

  • your reference
  • the submission number
  • the year
  • details of what has been omitted

Additional batches

HMRC may ask you to submit an additional batch. If this happens, you should email tpi.c@hmrc.gov.uk and confirm that you’re submitting additional data that was omitted from an earlier submission. You must include:

  • your reference
  • the submission number
  • the year

You should make sure the batch number you provide relates to what you’re submitting.

Batches

If a sub-return contains too much data for the spreadsheet or electronic flat text file, it can be split into batches. For example, a sub-return could be made up of 2 spreadsheets to accommodate all the data. This means the data has been split into 2 batches.

Labelling your data

HMRC needs the correct information to process your data correctly.

All files must be labelled as follows:

  • HMRC reference
  • sub-return number
  • batch number for that reference/sub number/year
  • total number of batches submitted for that reference/sub number/year
  • year

You should also:

  • make sure each file has its own name, so we can identify it
  • avoid zipping files together or in groups

If you do not label files correctly your return can be rejected or queried.

Labelling example

Bank A has the HMRC ref A9876/03 and is submitting 2 batches for 2021. The files (batches) would be labelled as follows:

HMRC reference Sub-return number Batch number Total batches Year
Batch 1 A9876 03 001 002 2021
Batch 2 A9876 03 002 002 2021

If the return just contains a single batch, it would be labelled as follows:

HMRC reference Sub-return number Batch number Total batches Year
Batch A9876 03 001 001 2021

Using the HMRC spreadsheet for your return

Use the latest HMRC spreadsheet in the format provided

This is the only spreadsheet you can use to complete a return. HMRC will not accept reformatted versions. Do not:

  • change any data entry field formats or the original file format
  • copy onto a blank Excel spreadsheet (this can impact processing)
  • overwrite the original data entry field format (to paste data use the ‘Paste special’ option and select ‘Values’)

Always use the most current version of the spreadsheet.

Identify errors in the data to avoid a failed return

HMRC uses data quality software to check that the content of your return follows the prescribed format. Your return will be failed if the software identifies issues with the data.

This means you could receive a penalty charge because HMRC views failed returns as outstanding.

The spreadsheet has built-in error validation to help you complete your return correctly.

If you make a mistake in any column, then row 1 of that column will:

  • turn amber in colour
  • display the:
    • total number of errors in that column
    • number of the first row containing an error

When you correct the first error, row 1 will update the:

  • total number of errors
  • number of the row containing the next error

Once all the errors have been corrected, row 1 reverts to a blank white cell.

Example

Column H has errors in rows 10 and 20:

  • row 1 will turn amber
  • the total number of errors will display as 2
  • the number of the row containing the first error will display as 10

When you correct row 10 the:

  • total number of errors will update to 1
  • number of the row containing the first error will display as 20

Once row 20 is corrected, row 1 reverts to a blank white cell.

Error validations are complex so the spreadsheet may be slow to respond when you input or correct data.

Error validation cannot identify all potential errors so it’s important to check your return.

Entering data in spreadsheet columns

This section explains how to correctly enter data into each column of the spreadsheet. You must follow the criteria for each data field.

Column A: financial institution reference

This is a mandatory field.

HMRC assigns you a unique financial institution reference for submitting your return. Enter your full reference (including sub-reference),

You only need to enter this data once in the spreadsheet. It must:

  • only be entered in row 3
  • be 8 characters long
  • begin with either the letter A or B
  • be in the right format: ANNNN/NN (for example A0000/01)

No other characters will be accepted and this field cannot contain any blank spaces.

Column B: SI 03/3297 report

This is a mandatory field and must be completed for every reported participant.

Enter N in this field — participants are no longer reportable under the European Savings Directive.

No other characters will be accepted and this field cannot contain any blank spaces.

Column C: tax year

This is a mandatory field. Enter the latter year of the reported tax period. For example, the entry for the 2020 to 2021 tax period would be 2021.

You only need to enter this data once in the spreadsheet. It must:

  • only be entered in row 3
  • be 4 characters long
  • be in the right format: YYYY (for example 2022)
  • only contain numerical characters

No other characters will be accepted and this field cannot contain any blank spaces.

Column D: sort code

Leave this field blank if it’s not applicable.

If your return relates to multiple branches you must provide the sort code for every reported participant. The data must:

  • be 6 characters long
  • be in the right format: NNNNNN
  • only contain numerical characters
  • be provided in ascending numerical order

No other characters will be accepted and this field cannot contain any blank spaces or dividers.

Column E: income code

Leave this field blank.

Column F: security/account number

This is a mandatory field and must be completed for every reported participant.

The data must not exceed 19 characters and should not include the sort code.

For securities, start with one of the following letters to indicate the identification system:

  • I: International Securities Identification Number (ISIN)
  • S: Stock Exchange Daily Official List (SEDOL)
  • C: Committee on Uniform Securities Identification Procedures (CUSIP)

This must be followed by the unique identification number for that system.

Column G: account/client’s name or relevant payee’s name

This is a mandatory field and must be completed for every reported participant. This includes the accounts of companies, persons, or bodies of persons. Only include those with a UK address.

Enter the name used by your systems to identify the account or payment. The data must:

  • not exceed 50 characters
  • be in the right format: title forenames surname (for example, Mr John Edward Smith) or title initials surname (for example, Mr J E Smith, leave a space between initials)

Column H: reported participant’s name

This is a mandatory field and must be completed for every reported participant. The data must:

  • not exceed 50 characters
  • be in the right format: title forenames surname (for example, Mr John Edward Smith) or title initials surname (for example, Mr J E Smith, leave a space between initials)

Column I: type of participant

This is a mandatory field and must be completed for every reported participant. Bank and building society interest returns — categorisation will help you categorise participants correctly.

Only characters Y and N are acceptable. Y represents individuals and N, non-individuals.

No other characters will be accepted and this field cannot contain any blank spaces or dividers.

Column J: total number of participants

This is a mandatory field and must be completed for every reported participant.

Enter the total number of participants on the account, including non-reportable participants. The data must:

  • not exceed 4 characters
  • only contain numerical characters
  • not begin with blank spaces

Enter 0 if the account relates to a non-individual. Bank and building society interest returns — categorisation will help you identify non-individuals.

Column K: reported participant number

This is a mandatory field and must be completed for every reported participant.

Enter a number to distinguish each reported participant. Numbers must be sequential. For example, if the account has a total of 2 reported participants: the first participant is 1, the second is 2. The data must:

  • not exceed 2 characters
  • only contain numerical characters
  • not begin with blank spaces

Enter 1 if the account relates to a non-individual. Bank and building society interest returns — categorisation will help you identify non-individuals.

Column L: total number of reported participants

This is a mandatory field and must be completed for every reported participant.

Enter the total number of reported participants in relation to the account. The total number should not include participants who have not been reported. The data must:

  • not exceed 2 characters
  • only contain numerical characters (no other characters will be accepted)
  • not begin with blank spaces

Enter 1 if the account relates to a non-individual. Bank and building society interest returns — categorisation will help you identify non-individuals.

Column M: reported participant’s address line 1

This is a mandatory field and must be completed for every reported participant. Enter the first line of the address of the reported participant or relevant payee. The data must:

  • not exceed 40 characters
  • only include:
    • UK addresses
    • the address of the reported participant detailed in column H

The data must not include:

  • ‘care of’ addresses
  • UK postcodes
  • carriage returns or line breaks
  • punctuation marks or typographical symbols
Allowable character names allowable characters
upper case alphabet A to Z
lower case alphabet a to z
numbers 0 to 9
forward slash /
hyphen -
ampersand &
full stop .
apostrophe
comma ,
left hand brackets (
right hand brackets )

It is vital that you do not use non-printing control characters (excluding carriage return (CR) and line feed (LF)) or the following characters in your data return:

Non-allowable character names Non-allowable characters
Asterisk *
Semi-colon ;
Vertical bar |
Tab character  

Data entries such as ‘ditto’, ‘not known’ or ‘see above’ are not acceptable.

Columns N to Q: reported participant’s address lines 2 to 5

Only complete these fields if the participant or relevant payee has more than one line in their address.

The data must not exceed 40 characters per address column and follow the same criteria as column M.

Column R: reported participant’s postcode

This is a conditional field and must be completed for every reported participant of held.

Postcodes should only be entered in this column and not in address fields M to Q. The data must :

  • be a valid UK postcode
  • be 9 characters maximum

Do not include punctuation marks or typographical symbols.

Column S: country code for country of residence

This is a mandatory field and must be completed for every reported participant.

Only enter the code ZZ.

No other characters will be accepted and this field cannot contain any blank spaces or dividers.

Column T: National Insurance number

Leave this field blank if not known or not applicable.

Temporary National Insurance numbers are not acceptable.

The data must:

  • be between 8 and 9 characters in length (the ninth character must be either A, B, C, D)
  • be in the right format: AANNNNNNA or AANNNNNN (for example QQ123456A or QQ123456)

The data must not include the:

  • letters D, F, I, Q, U or V as the first or second prefix letter
  • letter O as the second prefix
  • following prefix combinations: BG, GB, KN, NK, NT, TN, ZZ

No other characters will be accepted and this field cannot contain any blank spaces or dividers either before or within the National Insurance number structure.

Column U: date of birth

Leave this field blank if not known or not applicable.

The data must:

  • be 8 characters long
  • be a valid date
  • only contain numerical characters
  • be in the right format: DDMMYYYY (for example, 3 August 1986 should be entered as 03081986)

No other characters will be accepted and this field cannot contain any blank spaces or dividers.

Column V: tax identification number

Leave this field blank.

Column W: country code for country of birth

Leave this field blank.

Column X: country of birth

Leave this field blank.

Column Y: gross interest paid

This is a mandatory field and must be completed for every reported participant. Enter the total amount of gross interest paid to the account for the reported period before tax deductions.

If the account has multiple participants, duplicate the total gross interest for each reported participant. The data must:

  • not exceed 15 characters
  • only contain numerical characters
  • be reported to 2 decimal places (for example, 999.00 or 750.50)
  • only contain values greater than 0, this means do not include non-payments (0.00)

No other characters will be accepted and this field cannot contain any blank spaces.

Column Z: tax deducted

This is a mandatory field and must be completed for every reported participant.

Enter the total amount of tax deducted from the account gross interest payment for the reported period.

If the account has multiple participants, duplicate the total tax deducted for each reported participant. The data must:

  • not exceed 15 characters
  • only contain numerical characters
  • be reported to 2 decimal places (for example, 999.00 or 750.50)
  • only contain values greater than 0, this means do not include non-payments (0.00)

Column AA: currency code

This is an optional field.

Enter the 3-character ISO currency code from ISO.org for the currency the reported payment was made in (even if the payment was converted to pound sterling before reporting). The data must:

  • be 3 characters long
  • only contains alphabetical characters

No other characters will be accepted (including currency symbols) and this field cannot contain any blank spaces.

Please note this will automatically default to pounds sterling (GBP) on our systems if not completed.

Column AB: conversion to sterling

This is a mandatory field.

Only enter the data in row 3. Only characters Y and N are acceptable:

  • Y: identifies accounts with a currency code other than pound sterling that’s been converted to pound sterling when reporting
  • N: identifies accounts with a currency code other than pound sterling that has not been converted and where the payment value relates to the reported currency

No other characters will be accepted and this field cannot contain any blank spaces.

Column AC: R105 signal

This is a mandatory field and must be completed for every reported participant.

Enter N in this field (the R105 form is no longer required).

Column AD: R85 gross registration

This is a mandatory field and must be completed for every reported participant.

Enter N in this field (the R85 form is no longer required).

Column AE: new account

This is a mandatory field.

Only characters Y or N are acceptable:

  • enter Y if this is the first time the account has been reported
  • enter N if the account has been reported before

No other characters will be accepted and this field cannot contain any blank spaces.

Using an electronic flat text file format (EFTF) for your return

All data submitted in electronic flat text file format must be encoded in UTF-8 as per ISO 20022 standard from ISO.org.

Use the correct record types in parts 1 to 4 of your text file

Each electronic text file batch that you submit to HMRC must consist of a text file made up of 4 parts. These parts are called ‘record types’.

Record type 1

This includes data about your financial institution and metadata about the type 2 and 3 data you’re providing. If you’re ‘branch-based’ there can be several type 1 records in a batch — otherwise there will be one in each batch).

Record type 2

This includes details of the account or instrument.

Record type 3

This includes details of participants in the account identified in the type 2 record.

Record type 4

This includes a count of the number of type 2 records in that batch.

Formatting for electronic flat text files

It’s essential to format your return correctly so HMRC can process it. Your return will be failed if HMRC’s data quality software identifies any issues and you could receive a penalty charge.

Each data field has it’s own specifications and you must pay attention to:

  • the format specified for that field
  • allowable characters
  • field alignment
  • field padding requirements

Data structure for electronic flat text files

Each account can either be reported in structured data formatting or unstructured data formatting, but structured data formatting is preferable. However, where the participant type must be categorised as a ‘non-individual’, for example when reporting a trustee, unstructured data must be entered. Whichever data format you choose to use or are required to use, your reporting must consistently use that data format when reporting the account throughout your return.

Structured data formatting

In structured formatting your data is entered in separate, named fields.

For example, the data relating to the participant’s name would be entered as:

  • participant title: Mr
  • participant forenames/initials: John
  • participant surname: Smith

Unstructured data formatting

In unstructured formatting, the data is presented together in a single field.

For example, the data relating to the participant’s name would be entered as ‘participant name: Mr John Smith’.

Account and participant naming conventions for EFTFs

When you use unstructured data to enter account and participant names it makes it harder for HMRC to identify different name elements.

We need to understand these elements to process your data correctly. This means you should enter the 2-digit code from the table below that corresponds with the naming convention you’ve used.

Type 3 records — (reportable) participant

Enter 0 (zero) as the first digit, followed by the appropriate code. Use codes 01 and 04 if possible and for non-individuals use 07, as other codes will be phased out.

Naming convention code Naming convention
01 Mr John A Smith
02 Smith John A Mr
03 Smith Mr John A
04 John A Smith
05 Smith John A
06 Smith Mr J A
07 Where the name is that of a non-individual

Type 2 records — (account)

Enter either:

  • 2 as the first digit to indicate multiple names, each with a separate surname
  • 4 as the first digit to indicate multiple names with a shared surname

This should be followed by the appropriate code.

Naming convention code Naming convention
21 Mr John A Smith and Mrs Heather Smith
22 Smith John A Mr and Smith Heather Mrs
23 Smith Mr John A and Smith Mrs Heather
24 John A Smith and Heather Smith
25 Smith John A and Smith Heather
26 Smith Mr J A and Smith Mrs H
27 Where the name is that of a non-individual
41 Mr John A and Mrs Heather Smith
42 Smith John A Mr and Heather Mrs
43 Smith Mr John A and Mrs Heather
44 John A and Heather Smith
45 Smith John A and Heather
46 Smith Mr J A and Mrs H
47 Where the name is that of a non-individual

Allowable characters and field formatting for EFTFs

You can use:

  • upper case and lower case alphabetical characters (or a mixture of the two)
  • numbers

Numbers should only be expressed as digits and printable characters. For example, number 12 should be expressed using 1 and 2 rather than entering the word ‘twelve’. Fractions must be decimal and expressed as printable characters. For example: 1.25.

The following characters are also allowable:

  • spaces (entered using the space bar)
  • forward slashes
  • hyphens
  • ampersands
  • full stops
  • apostrophes
  • commas
  • left and right brackets

Non-allowable characters

Do not use any of the following in your return:

  • asterisks
  • semi-colons
  • vertical bars
  • non-printing or control characters (excluding CR and LF)
  • the tab key

Foreign characters

In UTF-8, many foreign characters such as é and ü are stored as multiple bytes of data. These are called multibyte characters.

You must count multibyte characters as single characters when you make your return. We cannot process your return unless you do this.

Field alignment

Field entries are aligned to the left or right depending on the type of data you’re entering:

  • numerical fields (excluding date of birth field) and fields with a decimal point — align right
  • fields with any allowable character — align left

Field padding

When you submit a return, the fields for each type 2 or 3 record must be of a consistent length. If the data you want to enter is:

  • too long — abbreviate to fit the field
  • too short — use padding to fill the field

Padding describes the process of filling blank field spaces with pad characters. The pad character you use will depend on the type of data you are entering.

Fields that specify:

  • only numerical characters — pad with zeros
  • any allowable character — pad with spaces (entered using the space bar)

Example 1

If your forename field is 20 characters long and the participant’s forename is Frank (5 characters), the 15 ‘empty’ positions to the right are filled with spaces entered with the space bar.

Example 2

The participant count field requires 4 (right aligned) numerical characters. If there are 3 participants on the account, the 3 ‘empty’ positions should be filled with zeros so you would enter 0003.

Do not use the tab key to pad data entries or your return will be rejected. You must use zeros or spaces.

File formatting and file size for EFTFs

Terminated and continuous files

In a terminated file, only one record is held on each line. At the end of each line will be a line separator.

We no longer accept continuous files.

File size

Sub-returns containing less than one gigabyte of information can be:

  • submitted in one batch
  • split it into more than one batch

Sub-returns containing more than one gigabyte of data must be split into batches. Each separate batch can contain up to one gigabyte of data.

Entering type 1 record data in EFTFs

Type 1 records

Your type 1 records must provide accurate metadata about the type 2 and 3 records you submit. This is so HMRC can process your return.

Type 1 records contain dynamic fields that allow you to define the:

  • character length of some type 2 and 3 data fields
  • number of lines used

For example, if you define 4 participant address lines, each of 20 characters in your type 1 record you must enter 4 lines of 20 characters in the corresponding type 3 record.

Each type 2 and 3 data field can contain a maximum of:

  • 1,000 characters
  • 5 lines

This section explains how to correctly enter type 1 record data. You should follow the criteria for each data field.

Record type

Enter the number 1 in this field.

Financial institution reference and sub-reference number

HMRC assigns you a unique financial institution reference for submitting your return. Enter your full reference (including sub-reference).

The data must be 8 characters long and begin with the letter A or B followed by:

  • 4 numerical characters
  • a forward slash
  • your 2 digit sub-reference number

For example, A0000/01.

Financial institution or paying agent name

Only enter the name (and not the address). The data must:

  • only include allowable characters
  • be left-aligned
  • not exceed 50 characters
  • be padded with spaces if the name is less than 50 characters

Branch name

If you’re not branch-based, pad this field with 50 spaces.

Otherwise, enter the branch name (not the address). The data must:

  • only include allowable characters
  • be left-aligned
  • not exceed 50 characters
  • be padded with spaces if the name is less than 50 characters

Sort code

Enter your institution clearing bank sort code, or branch sort code. The data must be 6 numerical characters long.

Tax year

Enter the latter year of the reported tax period. For example, the entry for the 2021 to 2022 tax period would be 2022. The data must be:

  • 4 numerical characters long
  • in the right format: YYYY (for example 2022)

Sterling return signal

Only characters Y and N are acceptable.

Enter:

  • Y if non-sterling accounts have been converted into sterling for the purposes of submitting your return
  • N if non-sterling accounts have not been converted and are being reported in the currency stated

Account title length

Enter the number characters of the longest account title reported in your type 2 records. The data must be:

  • right-aligned
  • 4 numerical characters long
  • padded with zeros if necessary

Account name length

Enter the number characters of the longest account name reported in your type 2 records. The data must be:

  • right-aligned
  • 4 numerical characters long
  • padded with zeros if necessary

Account name count

Enter the maximum number of lines used to report the names of account holders in your type 2 records. The data must be:

  • right-aligned
  • 2 numerical characters long
  • padded with zeros if necessary

Account address line length

Enter the number characters of the longest address line reported in your type 2 records. The data must be:

  • right-aligned
  • 4 numerical characters long
  • padded with zeros if necessary

Account address line count

Enter the maximum number of lines used to report addresses of account holders in your type 2 records. The data must be:

  • right-aligned
  • 2 numerical characters long
  • padded with zeros if necessary

Reportable participant name length

If you’re using structured data formatting, enter 4 zeros in this field.

If you’re using unstructured data formatting, enter the number of characters of the longest participant name reported. The data must be:

  • be right-aligned
  • 4 numerical characters long
  • be padded with zeros if necessary

Participant title length

If you’re using unstructured data formatting, enter 4 zeros in this field.

If you’re using structured data formatting, enter the number characters of the longest participant title reported in your type 3 records. The data must be:

  • right-aligned
  • 4 numerical characters long
  • padded with zeros if necessary

Participant forenames, initials

If you’re using unstructured data formatting, enter 4 zeros in this field.

If you’re using structured data formatting, enter the number of characters of the longest participant forename with initials reported in your type 3 records. The data must:

  • be right-aligned
  • be 4 numerical characters long
  • be padded with zeros if necessary
  • (where relevant) include a space between each initial, these spaces count as characters

Participant surname length

If you’re using unstructured data formatting, enter 4 zeros in this field.

If you’re using structured data formatting, enter the number of characters of the longest participant surname reported in your type 3 records. The data must be:

  • right-aligned
  • 4 numerical characters long
  • padded with zeros if necessary

Participant address line length

If you’re using unstructured data formatting, you’ll enter all address elements in one continuous line.

This means you should enter the total number of characters of the longest participant address reported in your type 3 records.

If you’re using structured data formatting, you’ll enter different address elements on different lines.

This means you should enter the highest number of characters used in any one address line reported in your type 3 records.

For both unstructured and structured formats, the data must be:

  • right-aligned
  • 4 numerical characters long
  • padded with zeros if necessary

Participant address line count

If you’re using unstructured data formatting, enter 01.

If you’re using structured data formatting, enter the maximum number of lines used to report an address in your type 3 records. The data must be:

  • right-aligned
  • 2 numerical characters long
  • padded with a zero

The maximum number of address lines allowed is 5.

Entering type 2 record data in EFTFs

Type 2 records contain the account or instrument information. You must submit at least one type 2 record for each type 1 record.

The following section explains how to correctly enter type 2 record data. You should follow the criteria for each data field.

Record type

Enter the number 2 in this field.

Account reference or instrument details

Enter the account or instrument identification number where the interest was paid or received. The data must:

  • not include a sort code
  • be 20 allowable characters long
  • be left aligned
  • be padded with spaces if the identification number is less than 20 characters long

For instruments, start with one of the following letters to indicate the identification system:

  • I: International Securities Identification Number (ISIN)
  • S: Stock Exchange Daily Official List (SEDOL)
  • C: Committee on Uniform Securities Identification Procedures (CUSIP)

This must be followed by the unique identification number for that system.

If there is no unique instrument reference number, enter QQ999999999 and pad remaining 9 characters with spaces.

Account title

The data must:

  • only include allowable characters
  • not exceed the character limit you stipulated in the type 1 record for this field
  • be left aligned
  • be padded with spaces if the account title is shorter than the character limit stipulated

Account name

The data must:

  • only include allowable characters
  • not exceed the character limit you stipulated in the type 1 record for this field
  • be left aligned
  • be padded with spaces if the account name is shorter than the character limit stipulated

Account address

Enter the address held for the account — usually the address from the account statement. The data must:

  • only include allowable characters
  • not include post code
  • not exceed the character limit you stipulated in the type 1 record for this field
  • be left aligned
  • be padded with spaces if the address is shorter than the character limit stipulated

Account post code

Enter 9 alphanumeric characters. The data must:

  • only include allowable characters
  • be left aligned
  • be padded with spaces if the postcode it is shorter than 9 characters

Pad this field with 9 spaces if either:

  • you do not hold the post code
  • it is not recorded in a dedicated field on your IT system

R85 gross registration indicator

Enter N in this field. HMRC no longer requires data from the R85 form.

New account signal

Enter Y if this is the first time the account has been reported.

Otherwise enter N.

Post 05/04/01 R105 indicator

Enter N in this field. HMRC no longer requires data from the R105 form.

Gross interest amount

Enter the amount of interest paid or credited to the account for the reported tax year. The data must be:

  • right aligned
  • 15 numerical characters long
  • padded with zeros if necessary

The currency you use to report the interest dictates how you enter the amount:

  • for sterling — report the amount in pence with no decimal point, for example £100 would be entered as 10000
  • for non-sterling — report whole units as defined in the ISO currency code, for example $100 would be reported as 100, to report fractions of these units you must insert a decimal point

Tax deducted amount

Enter the amount of tax deducted from the gross interest amount. The data must be:

  • reported in the same currency used to report the interest
  • right aligned
  • 15 numerical characters long
  • padded with zeros if necessary

If no tax was deducted, pad this field with 15 zeros.

Currency identifier

Enter the ISO currency code for the currency the gross interest and tax deducted were paid in.

This field requires 3 alphabetical characters with no padding.

Participant count

Enter the total number of participants (reportable and non-reportable) on the account or instrument being reported. The data must be:

  • right aligned
  • 4 numerical characters long
  • padded with zeros if necessary

If you are reporting non-individuals enter 0 (zero).

Type 3 record count

Enter number of type 3 records associated with this account or instrument. The data must be:

  • right aligned
  • 4 numerical characters long
  • padded with zeros if necessary

Account naming convention

If you’re using structured data formatting, enter 00 (zero zero).

If you’re using unstructured data formatting, enter the 2-digit code for the naming convention you’ve used in the ‘account title’ and ‘account name’ fields.

SI 03/3297 first period only amount

Enter 11 zeros.

Income code

Enter the word NONE.

Entering type 3 record data in EFTFs

Type 3 records give details of reportable participants in accounts identified in type 2 records.

You must enter details for every reportable participant (both individuals and non-individuals). There is more information about correctly categorising participants as individuals and non-individuals in Bank and building society interest returns — categorisation guidance.

You must submit at least one type 3 record for every corresponding type 2 record or your return will be failed.

The following section explains how to correctly enter type 3 record data. You should follow the criteria for each data field.

Record type

Enter the number 3 in this field.

Reportable participant’s name

The data must:

  • only include allowable characters
  • not exceed the character limit you stipulated in the type 1 record for this field
  • be left aligned
  • be padded with spaces if it is shorter than the character limit stipulated

For non-individual accounts, check the corresponding type 2 entry to make sure:

  • a zero was entered in the participant count field
  • you exactly replicate the name entered in this field

Reportable participant’s title

For non-individual accounts, pad this field with spaces.

For individuals, the data must:

  • only include allowable characters
  • not exceed the character limit you stipulated in the type 1 record for this field
  • be left aligned
  • be padded with spaces if it is shorter than the character limit stipulated

If you’ve used structured data formatting, replicate the data in the ‘title’ field of the corresponding type 2 record.

Reportable participant’s forenames and initials

For non-individual accounts, pad this field with spaces.

For individuals, the data must:

  • only include allowable characters
  • not exceed the character limit you stipulated in the type 1 record for this field
  • be left aligned
  • be padded with spaces if it is shorter than the character limit stipulated
  • (where relevant) include a space between each initial, these spaces count as characters

Reportable participant’s surname

For non-individual accounts, pad this field with spaces.

For individuals, the data must:

  • only include allowable characters
  • not exceed the character limit you stipulated in the type 1 record for this field
  • be left aligned
  • be padded with spaces if it is shorter than the character limit stipulated

Reportable participant’s address

Enter the participant’s address without the postcode. If your IT system does not hold post codes in a separate field you should include it in last line of the address. The data must:

  • only include allowable characters
  • not exceed the character limit you stipulated in the type 1 record for this field
  • be left aligned
  • be padded with spaces if it is shorter than the character limit stipulated

Reportable participant’s postcode.

Enter 9 alphanumeric characters. The data must:

  • only include allowable characters
  • be left aligned
  • be padded with spaces if the postcode it is shorter than 9 characters

Pad this field with 9 spaces if either:

  • you do not hold the post code
  • it is not recorded in a dedicated field on your IT system

Reportable participant’s National Insurance number

Enter 9 alphanumeric characters. The final character is optional and may be replaced with a space.

The data must be in the right format — AANNNNNNA or AANNNNNN (for example QQ123456A or QQ123456).

The data must not include:

  • letters D, F, I, Q, U or V as the first or second prefix letter
  • letter O as the second prefix
  • any of these prefix combinations, BG, GB, KN, NK, NT, TN, ZZ

Pad this field with spaces if:

  • you do not know an individual’s National Insurance number
  • the participant is a non-individual

Reportable participant’s date of birth

Enter the date of birth without separators. For example, 12 December 2024 would be entered as 12122024.

If the day or month are not known, enter ‘00’ (zero zero). For example 00122024, 12002024.

If you do not know the participants date of birth pad this field with zeros.

R85 gross registration indicator

Enter N in this field. HMRC no longer requires data from the R85 form.

R85 address signal

Pad this field with a space (using the space bar). HMRC no longer requires data from the R85 form.

Tax identification number

Pad this field with 20 spaces (using the space bar).

Country code for country of birth

Pad this field with 2 spaces (using the space bar).

Place of birth

Pad this field with 35 spaces (using the space bar).

SI 03/3297 indicator

Enter N in this field.

Reportable participant naming convention

Enter 2 numerical characters depending on whether you have used structured or unstructured data formatting:

If you’re using structured data formatting, enter 00 (zero zero).

If you’re using unstructured data formatting, enter the 2-digit code for the naming convention you’ve used in the ‘participant title’ and ‘participant name’ fields.

Country code for country of residence

Enter ZZ in this field.

Entering type 4 record data EFTFs

A type 4 record should be the last record in each batch. It tells HMRC the number of type 2 records in that batch.

Record type

Enter the number 4 in this field.

Account count

Enter the total number of type 2 records submitted in that batch. The data must:

  • be 11 numerical characters long
  • right aligned
  • padded with zeros if necessary

Submitting your return

You can submit your return via:

  • the Secure Data Exchange Service (SDES)
  • email attachment

The Secure Data Exchange Service is the most secure way to submit your return to HMRC.

Contact support.SDES@hmrc.gov.uk to sign up for the service.

HMRC will not accept any returns by post or courier .

Nil returns and failed returns

Nil returns

In some circumstances you can make a nil return. For example, if a product is withdrawn or a new product is introduced and no interest has been paid at the time the return is due.

You must inform HMRC if you want to make a nil return.

You can do this by email to tpi.a@hmrc.gov.uk.

Failed returns

If HMRC’s data quality software identifies issues with the data in your return you’ll be asked to:

  1. Review the return.
  2. Correct the errors.
  3. Resubmit the return.
Published 2 December 2021
Last updated 4 January 2024 + show all updates
  1. We no longer accept continuous files when you submit a return using an electronic flat text file (EFTF).

  2. Gross interest paid on the HMRC spreadsheet and electronic flat text file has now been increased from 11 numerical characters to 15. Tax deducted from the account gross interest payment for the reported period has been increased from 11 numerical characters to 15.

  3. The guidance has been corrected, as the account reference or instrument details should be 20 allowable characters long.

  4. The information has been updated as the account reference or instrument details should be 24 allowable characters long.

  5. Guidance about what you need to enter in column T on the HMRC spreadsheet has been updated. Guidance on what you need to enter under 'new account signal' when completing electronic flat text file returns has also been updated.

  6. The information for completing your electronic flat text file returns has been updated. For the 'country code for country of birth' entry you should pad this field with 2 spaces (using the space bar).

  7. Information about sub-return number requests and updates has been added.

  8. The postal address has been removed from the 'Nil returns' section. You should inform us by email rather than by post.

  9. First published.