Import Template - Individuals

Use this template to import Individual records.

The Relationship field can be set to Client, Prospect or Contact. Where relevant, an Individual can be linked to an Organisation using the Linked Company Number field.


Column Field Name Description
A Reference Optional internal client reference.
B Relationship Client, Prospect or Contact. If left blank, defaults to Client.
C First Name Individual's first name.
D Last Name Individual's last name.
E DOB Date of birth.
F Companies House Personal Code Personal code issued to the individual by Companies House.
G UTR Number Individual's 10-digit Unique Taxpayer Reference.
H NI Number Individual’s National Insurance number.
I Passport Number Individual’s passport number.
J Phone 1 Primary telephone number.
K Phone 2 Alternative telephone number.
L Email Individual’s email address.
M Address Line 1 First line of the individual’s address.
N Address Line 2 Second line of the individual’s address.
O Address Line 3 Third line of the individual’s address.
P Postcode Address postcode.
Q Registered as Tax Agent Date your firm was registered as the individual’s tax agent.
R Start From⚡ Date from which Self Assessment Smart Tasks should be created.
S Tax Return Required ⚡ Enter TRUE if a Self Assessment tax return is required; otherwise enter FALSE.
T Tax Return Last Made Up To End date of the last completed tax return period.
U MTD IT Start From Date from which MTD for Income Tax applies. Any date in a quarter will generate a task for that quarter and each subsequent quarter.
V MTD IT Quarters Taxyear or Calendar to determine the quarterly periods.
W Engagement Signed Date the engagement letter was signed.
X Last AML RA Date the last AML risk assessment was completed.
Y AML Risk Level Individual’s last recorded AML risk assessment level (Low, Medium or High).
Z Partner Enter an existing PracticeFlow user email address on your account.
AA Account Manager Enter an existing PracticeFlow user email address on your account. If left blank, defaults to the user doing the import.
AB Linked Company Number Companies House registration number of the organisation to link to the individual.
AC Notes Additional notes about the individual.
AD–AM Custom Field 1–10 Enter values for any Individual Custom Fields configured in PracticeFlow.

Notes

  1. This symbol ⚡indicates minimum required information to activate a Smart Task.
  2. All dates should be entered in DD/MM/YYYY format.