Research and analysis

CT600 main return panel dataset

Published 14 November 2014

Notes on the dataset

The CT600 is the Company Tax Return form. See CT600 (2008) Version 2 - Company Tax Return form for reference.

For each company for each accounting period the record where the flag CTA_BEST_DATA_IND is ‘Y’ is selected. This is usually an assessment. This indicator shows whether the return or an assessment holds the most up to date information for the accounting period of a case, or if it has been superseded. However, data that has failed a serious validation test is excluded. Where no best version exists an assessment is included for completeness. In this way for each company and each accounting period one record is chosen.

For turnover, the variable TRADING_TURNOVER should be used as this is the first box in the form and holds the ‘Total turnover from trade or profession’. The description of AMOUNT_OF_TURNOVER_IN_AP shows that it is constructed in a more complex way.

Where the repaired version of a variable exists only the repaired version is provided and not the original. A repair to a variable is often made to ensure consistency within a return; for example where a certain box should add to the sum of a series of other boxes on the form. However, this does NOT mean that there has been any further check on whether overall the values are correct. In particular extreme values have NOT been removed.

There has been no further attempt to clean up this data beyond providing the repaired version of variables where they exist. Hence care is required when examining and analysing the data as extremely large values which may have been entered wrongly will distort findings if assumed to be correct. If you want us to check any values just ask.

Main return for the population of large and small firms from 1 April 2001 to 31 March 2013

Variable Name	Description	CT600 V2 Box
ABA_AND_OTHER_BCS	Balancing Charges for other charges and allowances.	114
ABA_AND_OTHER_CAS	Capital Allowances for other charges and allowances.	113
ACCOUNTING_PERIOD_END_DATE	The end date of the accounting period.
ACCOUNTING_PERIOD_NUMBER	Unique identifier for each accounting period for a taxpayer.
ACCOUNTING_PERIOD_START_DATE	The start date of the accounting period.
ACT	Advance Corporation Tax.	76
ALLOWABLE_LOSSES_R	Repaired allowable losses including losses brought forward.	17
AMOUNT_OF_TURNOVER_IN_AP	Required for CT Survey data purposes. Turnover is recorded in thousands of pounds (rounded to the nearest £1,000 up or down). Turnover is treated as total receipts except for capital items. Where accounts do not cover a 12 month period gross up or reduce as necessary to give an annual amount. eg £301,651 is recorded as 302. NB Any amount between £1 and £1,499 to be recorded as 1.
AP_NO_OF_ASSOC_COMPANIES	Number of companies associated with this company in the period covered by this return.	39
AP_STATUS_IND	Indicates whether the accounting period is: dormant (D), live (L) or exempt (E). (Note: Superseded (S) will not be held in CTA.
A_GCI_LOSS_AMT	Assessment Gross Case I Losses.	Repaired & derived
A_GCI_PROF_AMT	Assessment Gross Case I Profits.	Repaired & derived
BAL_AMT	Balancing Charges.	Derived
BAL_PLANT_AMT	Plant and machinery Balancing Charges.	Derived
CAPITAL_ALLOWANCES	Capital Allowances for the purposes of management of the business.	27
CARS_BCS	Balancing Charges for any cars not included in the general pool.	110
CARS_CAS	Capital Allowances for any cars not included in the general pool.	109
CA_AMT	Capital Allowances.	Derived
CA_PLANT_AMT	Plant and machinery Capital Allowances.	Derived
CHARGES_PAID	Charges paid.	35
CITR	Community investment relief.	72
CTA_BEST_DATA_IND	Set to ‘Y’ if the assessment or return data is evaluated as ‘best’ available for this accounting period. Otherwise the value will be N.
CTA_SIZE_IND	(Stratum) 1 (Large Case) or 2 (Not Large Case) NEVER missing; Once Stratum1 always Stratum 1.
CTA_ SOURCE_IND	Indicate the data source ‘A’ - Assessment ‘R’ - Return.
CT_ALREADY_PAID	Tax already paid (and not already repaid).	91
CT_CHARGEABLE_R	Repaired Corporation Tax chargeable.	70
CT_NET_MARG_RATE_RELIEF_R	Repaired Corporation Tax net of marginal rate relief.	65
CT_OVERPAID_R	Repaired tax overpaid.	93 Repaired & Derived
CVS_INV_RELIEF	Corporate Venturing Schemes investment relief.	71
DTR	Double taxation relief.	73
D_AND_R_NT_LOSS_INTANGIBLES	Non-trading losses on intangible fixed assets.	29
FRANKED_INV_INCOME	Franked investment income.	38
GROSS_CT_CHARGEABLE_R	Repaired Corporation Tax.	63
GROSS_GAINS_R	Repaired gross chargeable gains.	16
GROUP_RELIEF	Group relief. Accompanied by form CT600C.	36
GROUP_STATUS_IND	Signal showing if this CT_PAYER instance refers to a pseudo record set up as a focal point for the GPA, or a company participating in a group arrangement, or neither. N or null = CT Payer record; G = Group Payment record ; P = Participator. Permitted values N, G, P, T.
IBA_BCS	Balancing Charges for Industrial buildings and structures.	112
IBA_CAS	Capital Allowances for industrial buildings and structures.	111
IDENTIFIER	Introduced to replace the taxpayer reference number.
INCOME_TAX_REPAYABLE_R	Repaired Income Tax repayable to the company.	85
INTEREST_UNDER_S468L	Interest distributions under S468L ICTA 1988.	25
LOSSES_B_F_S3938	Losses brought forward against certain investment income.	19
LOSSES_ON_SHARES	CVS loss relief, and losses on unquoted shares under S573 ICTA 1988.	22
MAN_EXPS_SCHA_LOSS_R	Repaired management expenses under S75 ICTA 1988.	24
MSCR_R	Repaired marginal starting rate or small companies’ relief.	64
NET_CHARGEABLE_GAINS_R	Repaired net chargeable gains.	18
NET_CT_CHARGEABLE_R	Repaired Net corporation tax liability.	78
NET_NON_TRADE_LOSSES	Non-trade deficits for this accounting period from loan relationships and derivative contracts (financial instruments).	28
NET_TAX_PAYABLE_R	Repaired self-assessment of tax payable.	86
NET_TRADING_PROFIT_R	Repaired net trading and professional profits.	5
NONTRADE_BCS	Balancing charges not included in calculation of trading profits or losses.	116
NONTRADE_CAPITAL_ALLOWANCES	Non-trade Capital Allowances.	32
NONTRADE_CAS	Capital Allowances not included in calculation of trading profits or losses.	115
NON_CORP_DIST_TO_PROFITS_R	Repaired profits matched with non-corporate distributions.	67
NON_TRADE_LOSS_B_F	Non-trade deficits on loan relationships (including interest), and derivative contracts (financial instruments) brought forward.	20
NT_DEFICITS	Non-trade deficits on loan relationships and derivative contracts arising.	125
NT_GAINS_INTANGIBLES	Non-trading gains on intangible fixed assets.	12
NT_LOAN_PROFIT	Bank, building society or other interest, and profits and gains from non-trading loan relationships.	6
OTHER_ANNUAL_PROFITS	Annual profits and gains not falling under any other heading.	14
OVERSEAS_INCOME	Overseas income within Schedule D Case V.	9
PROFITS_BEFORE_CHGES	Profits before charges.	34
PROFITS_CHARGEABLE_R	Repaired profits chargeable to Corporation Tax .	37
P_AND_M_LONG_LIFE_BCS	Balancing Charges for machinery and plant - special rate pool.	106
P_AND_M_LONG_LIFE_CAS	Capital Allowances for machinery and plant - special rate pool.	105
P_AND_M_OTHER_BCS	Balancing Charges for machinery and plant - main pool.	108
P_AND_M_OTHER_CAS	Capital Allowances for machinery and plant - main pool.	107
RF_CT_INCLUDED	The amount of Ring Fence Corporation Tax included in tax payable.	161
R_AND_D_REPAYABLE_R	Repaired Research and Development tax credit payable, including any vaccines tax credit, or film tax credit payable.	89
R_GCI_LOSS_AMT	ReturnGross Case I Losses.	Repaired & derived
R_GCI_PROF_AMT	Return Gross Case I Profits.	Repaired & derived
S501A_TAX_CHARGE	Tax payable under S501A ICTA 1988. Accompanied by form CT600I.	82
SCHEDULE_A_INCOME	Income from UK land and buildings.	11
SCHEDULE_A_LOSSES	Schedule A losses for this or previous accounting period under S392A ICTA 1988.	26
SCHEDULE_D_CASE_III	Annuities, annual payments and discounts not arising from loan relationships and from which Income Tax has not been deducted.	8
SCHEDULE_D_CASE_VI_R	Repaired income within Schedule D Case VI.	15
SECTION_747	Tax payable under S747 ICTA 1988.	81
SECTION_4191	Tax payable under S419 ICTA 1988.	79
STRATUM_IND	Value ‘1’ indicates that this taxpayer is considered to be a ‘large’ case, value is ‘2’ indicates a small company. Note: A case will remain designated ‘large’ case for all accounting periods following the accounting period when a case has been identified as a ‘large’ case.
TAXED_INCOME	Income from which Income Tax has been deducted.	10
TAX_CHARGEABLE_R	Repaired tax chargeable.	83
TAX_NON_CORP_DIST_RATE	Tax at non-corporate distributions rate.	68
TAX_UNDERLYING_RATE_REM_PROFIT_R	Repaired tax at underlying rate on remaining profits.	69
TONNAGE_TAX_PROFITS	Tonnage tax profits.	13
TRADE_TCN
TRADING_LOSSES_BROUGHT_FORWARD_R	Repaired trading losses brought forward claimed against profits.	4
TRADING_LOSSES_CASE_I_R	Repaired trading losses Case I Arising.	122 Repaired & Derived
TRADING_PROFIT_R	Repaired trading and professional profits.	3
TRADING_TURNOVER	Total turnover from trade or profession.	1
UNDERLYING_RATE_CT	Underlying rate of Corporation Tax	66