How To Build Your Import (UK)

You can import both UK and Irish clients using this spreadsheet, so you can use both guides to understand what data needs to be added.

This article will explain what you can achieve adding different levels of data, which columns are compulsory and what the purpose of each column is.

Levels of Data

Once you've imported your clients you can then add additional data manually at a later date. This may be time consuming though as each client would have to be updated individually so we recommend that you add as much as you are able to during the initial import.

Level 1 - Just get your clients in and portal registered

Fill in columns:

A, C, F, I, N, O, R, X

(This will add just a Main Contact, you have the option to add Secondary Contact Details too)

Level 2 - Get your clients portal registered and Task List set up

Fill in columns:

Add CH Accounts, CT600, Confirmation Statements, Self Assessment Accounts and Returns:

A, C, F, I, N, O, R, X, A, AA, AB

(This will add just a Main Contact, you have the option to add Secondary Contact Details too)

Add VAT Tasks

CG, CH.

Add PAYE Tasks:

CL, CM, CO

Add P11D Tasks:

Add CIS Tasks:

Add Auto Enrolment Tasks:

CV, CZ

Add Bookkeeping Tasks in line with other services:

SA800 Accounts and Returns:

EL, EN

Level 3 - Get your clients portal registered, Task List set up make sure your client’s missing Data is accurate

Complete Level 2 then:

For Agent Authorisations:

AC, AU, BL, CC, CI, CT, CU

Client has provided valid ID:

AD, AV, BM, CD

Tax Reference Numbers (including NI and PSS numbers:

J, W, Y, AO, AQ, BF, BH, BW BY, CE, CJ, CK, EN

Authorisation Codes:

Level 4 - All of the above and everything else

Column Breakdown

This section of the article explains what each column on the spreadsheet does

Staff & Partner Users

Column A - Staff User Responsible - Compulsory Column

This will be the Staff Member named as the Client Manager, this user must have a login for the import to work correctly. If the user hasn't been added or the cell is blank then the client manager will be the user performing the import. The Client Manager will receive Notifications relating to that client.

Column B - Partner Name - Reference Only

This will be the Staff Member named as the Client Partner, this user must have a login to be added as the Partner. This field is for reference, you can filter your Task List by Partner.

Business Details

Column C - Client Name - Compulsory Column

This is the name of the Limited Company, Partnership, Self Assessment Client etc. If the client is a Self Assessment client this should still be entered. There should be no blank cells in this column.

Column D - Trading As - Reference Only

This field is used to record the Trading As name, and this name will be displayed alongside the Client Name on the Client List. On the client file for a Limited Company, Other or LLP this name will be stored under Company Details > Company Trading As. On a Partnership, Trust or Self Assessment client file it will be stored under Business Details > Trading As and on a Charity Client File it will be stored under Charity Details > Company Trading As. This field should only be used if the Trading As and Client Name differ.

Column E - Nature of Business - Reference Only

This field is for reference, you could enter something like Estate Agent, Window Cleaner etc. This is stored on the client file for a Limited Company, Other or LLP this will be stored under Company Details > Nature of Business. On a Partnership, Trust or Self Assessment client file it will be stored under Business Details > Nature of Business and on a Charity Client File it will be stored under Charity Details > Nature of Business.

Column F - Client Type - Compulsory Column

The options are: Private Limited Company or LTD, Irish Limited Company or Irish LTD, Public Limited Company, Limited Liability Partnership or LLP, Self Assessment or SA, Irish Self Assessment or Irish SA, Trust, Charity, Other, Irish Partnership and Irish Other. If the client is a Sole Trader they should be marked as SA and an Accounts Period End should be recorded under Column Z (Sole Trader Accounts Period End).

For UK Limited Companies the following tasks will be generated automatically:

Accounts Preparation

Companies House Submission

CT600 Submission

Confirmation Statement Submission

Column G - Date of Trading - Reference Only

This field is used to record the day the client first started trading. This is stored on the client file for a Limited Company, Other or LLP this will be stored under Company Details > Date of Trading. On a Partnership, Trust or Self Assessment client file it will be stored under Business Details > Date of Trading and on a Charity Client File it will be stored under Charity Details > Date of Trading.

Accounting System

Column H - Accounts Production Software - Reference Only

This is stored on the client file under Other Details > Accounting System. The standard options are Cashbook, Assisted, Sage, Xero, QuickBooks, FreeAgent, VT Transaction+, Excel, Paper and Other.

You can add other options prior to import by navigating to Settings > Account Settings > Client Settings > Accounting System Options.

Company Details

Column I - Company Number - Compulsory Column

If a UK company number is entered here then this will populate the CH Year End, HMRC Year End, CH Accounts Next Due date, CT600 Due date, Confirmation Statement Date, Confirmation Statement Due date, Company Status, Incorporation Date, Registered Address and SIC Code. This will only work for UK Limited Companies.

Column J - Company UTR - Missing Information Trigger

To be entered for the Client Types Limited Companies & LLP. If left blank a request for this information will be sent to your client via the Registration or Missing Information email.

Column K - Companies House Authorisation Code - Missing Information Trigger

To be entered for the UK Limited Company Client Types. If left blank a request for this information will be sent to your client via the Registration or Missing Information email.

Column L - HMRC Year End Date - Task Related

Used as the Period End for CT600 Return Tasks - This only needs to be filled in if for some reason this date differs from the CH Year End Date. Format dd/mm/yyyy.

Column M - CT Online (Y/N) - Missing Information Trigger

This information will be stored on the client file under Agent Authorisation. Indicates whether you have a 64-8 for Corporation Tax filing. If left blank a request for this information will be sent to your client via the Registration or Missing Information email.

Main Contact / Director

Columns N & O - Contact 1 First Name & Last Name - Compulsory Columns

If a cell in either of these columns is blank, the entire row will fail to upload.

You must add a Main Contact First Name for each client.

Column P - Terms of Engagement Signed Date - Terms

If a date is added it will populate Terms Signed under Main Contact. If this field is populated the client will not need to sign Registration Terms if you have set these up, they will still need to sign an LoE. Format dd/mm/yyyy.

Column Q - Date of Birth - Reference Only

This information is stored under Main Contact > Date of Birth. The format is dd/mm/yyyy.

Column R - Email 1 - Portal Registration

Field populated is under Main Contact > Email.

This email address will be used to Portal Register the contact.

Column S - Email 2 - Reference Only

Field populated is under Main Contact > Email. This second address will be added with a comma after any address added to Column R.

Column T - Postal Address - Reference Only

The address will be stored under Main Contact > Address in the same format it is entered into this cell.

Column U - Telephone Number - Reference Only

The number will be stored for reference under Main Contact > Telephone.

Column V - Mobile Number - Used for SMS

The number will be stored under Main Contact > Mobile. SMS can only be sent to UK and ROI numbers.

Column W - UK - NI Number - Missing Information Trigger

The number will be stored under Main Contact > NI Number. If left blank a request for this information will be sent to your client via the Registration or Missing Information email.

Column X - Self Assessment Client (Y/N) - Creates SA Client File

If the contact appears more than once on the import a Y must only be entered for them once or multiple SA client files will be created for them.

Add a Y to create a Self Assessment client file for this contact.

If the contact appears more than once on the import a Y must only be entered for them once or multiple SA client files will be created for them.

Column Y - Personal UTR No. - Missing Information Trigger

The number will be stored under Main Contact > Personal UTR. If left blank a request for this information will be sent to your client via the Registration or Missing Information email.

Column Z - Sole Trader Accounts Period End - Drives Tasks

If a date is added this will turn on the Accounts Service for this client. Format dd/mm/yyyy.

Column AA - SA Tax Year - Drives Tasks

This should always be entered if you perform a Self Assessment for this contact, the format is yyyy/yy (eg 2019/20).

Where no period end has been entered for the Self Assessment, the period end will be assumed as the 5th April for the Tax Year entered.

Column AB - MTD Qualifying Year

This is the tax year that the client qualifies for MTD. The format is yyyy/yy. Valid vsalues are 2026/27, 2027/28, 2028/29 or leave blank if the clients earnings don't qualify them for MTD submissions.

Column AC -Next SA Return Due - Drives Tasks

The format for Next SA Return Due is dd/mm/yyyy. This deadline will be applied to the SA task for this client.

Column AD - Next MTD Quarterly Period End

The format for Next MTD Quarterly Return Period End is dd/mm/yyyy. This deadline will be applied to the MTD Quarterly task for this client.

Column AE - Next MTD Quarterly Due

The format for Next MTD Quarterly Return Due is dd/mm/yyyy. This deadline will be applied to the MTD Quarterly task for this client.

AF. Next MTD Final Declaration Period End (e.g. 05/04/2022)

The format for Next MTD Final Declaration Period End is dd/mm/yyyy. This deadline will be applied to the MTD Final Declaration task for this client.

AG. Next MTD Final Declaration Due (e.g. 05/04/2022)

The format for Next MTD Final Declaration Due is dd/mm/yyyy. This deadline will be applied to the MTD Final Declaration task for this client.

AH. SA Online (Y/N) - Missing Information Trigger

This information will be stored on the client file under Agent Authorisation. Add a Y if you have a current 64-8 for this client’s Self Assessment. If N is entered or the cell is left blank, a request for this information will be sent to your client via the Registration or Missing Information email.

AI. ID Received (Y/N) - Missing Information Trigger

This information will be stored under Main Contact > ID Verified & Address Verified. Add a Y if you have received ID and proof of address from your client. If N is entered or the cell is left blank, a request for this information will be sent to your client via the Registration or Missing Information email.

AJ. Unhide columns to: add up to 4 contacts / directors

Second Contact / Director

If you carry out a Self Assessment for a Secondary Contact, on their Self Assessment client file their details will appear under Main Contact.

AK & AL. Contact 2 First Name & Last Name

If you are adding a secondary contact both name cells need to be filled in.

AM. Terms of Engagement Signed (Date)

If a date is added it will populate Terms Signed under Secondary Contact. If this field is populated the client will not need to sign Registration Terms if you have set these up, they will still need to sign an LoE. Format dd/mm/yyyy.

AN. Date of Birth - Reference Only

This information is stored for reference under Secondary Contact > Date of Birth. The format is dd/mm/yyyy.

AO. Email 1 Required for Client Portal Registration

Field populated is under Main Contact > Email.

This email address will be used to Portal Register the contact.

AP. Email 2 - Reference Only

Field populated is under Secondary Contact > Email. This second address will be added with a comma after any address added to Column AJ.

AQ. Postal Address - Reference Only

The address will appear under Secondary Contact > Address in the same format it is entered into this cell.

AR. Telephone No - Reference Only

The number will be stored for reference under Secondary Contact > Telephone.

AS. Mobile Number - Used for SMS

The number will be stored under Secondary Contact > Mobile. SMS can only be sent to UK and ROI numbers.

AT. NI Number - Missing Information Trigger

The number will be stored under Secondary Contact > NI Number. If left blank a request for this information will be sent to your client via the Registration or Missing Information email.

AU. Self-Assessment Client (Y/N) - Creates SA Client File

If the contact appears more than once on the import a Y must only be entered for them once or multiple SA client files will be created for them.

Add a Y to create a Self Assessment client file for this contact.

If the contact appears more than once on the import a Y must only be entered for them once or multiple SA client files will be created for them.

AV. Personal UTR No. - Missing Information Trigger

The number will be stored under Secondary Contact > Personal UTR. If left blank a request for this information will be sent to your client via the Registration or Missing Information email.

AW. Sole Trader Accounts Period End - Drives Tasks

If a date is added this will turn on the Accounts Service for this client. Format dd/mm/yyyy.

AX. SA Tax Year (e.g. 2020/21) - Drives Tasks

This should always be entered if you perform a Self Assessment for this contact, the format is yyyy/yy (eg 2019/20).

Where no period end has been entered for the Self Assessment, the period end will be assumed as the 5th April for the Tax Year entered.

AY. MTD Qualifying Year (e.g. 2026/27)

AZ. Next SA Return Due (e.g. 31/01/2022) - Drives Tasks

The format for Next SA Return Due is dd/mm/yyyy. This deadline will be applied to the SA task for this client.

BA. Next MTD Quarterly Period End (e.g. 05/04/2022)

The format for Next MTD Quarterly Return Period End is dd/mm/yyyy. This deadline will be applied to the MTD Quarterly task for this client.

BB. Next MTD Quarterly Due (e.g. 07/05/2022)

The format for Next MTD Quarterly Return Due is dd/mm/yyyy. This deadline will be applied to the MTD Quarterly task for this client.

BC. Next MTD Final Declaration Period End (e.g. 05/04/2022)

The format for Next MTD Final Declaration Period End is dd/mm/yyyy. This deadline will be applied to the MTD Final Declaration task for this client.

BD. Next MTD Final Declaration Due (e.g. 05/04/2022)

The format for Next MTD Final Declaration Due is dd/mm/yyyy. This deadline will be applied to the MTD Final Declaration task for this client.

BE. SA Online (Y/N) - Missing Information Trigger

BF. ID Received (Y/N) - Missing Information Trigger

This information will be stored under Secondary Contact > ID Verified & Address Verified. Add a Y if you have received ID and proof of address from your client. If N is entered or the cell is left blank, a request for this information will be sent to your client via the Registration or Missing Information email.

Third Contact / Director & Forth Contact / Director

BG & BH. Contact 3 First Name & Last Name

If you are adding a Third contact both name cells need to be filled in.

BI. Terms of Engagement Signed (Date)

BJ. Date of Birth - Reference Only

This information is stored for reference under Secondary Contact > Date of Birth. The format is dd/mm/yyyy.

BK. Email 1 Required for Client Portal Registration

Field populated is under Main Contact > Email.

This email address will be used to Portal Register the contact.

BL. Email 2 - Reference Only

Field populated is under Secondary Contact > Email. This second address will be added with a comma after any address added to Column AJ.

BM. Postal Address - Reference Only

The address will appear under Secondary Contact > Address in the same format it is entered into this cell.

BN. Telephone No - Reference Only

The number will be stored for reference under Secondary Contact > Telephone.

BO. Mobile Number - Used for SMS

The number will be stored under Secondary Contact > Mobile. SMS can only be sent to UK and ROI numbers.

BP. NI Number - Missing Information Trigger

The number will be stored under Secondary Contact > NI Number. If left blank a request for this information will be sent to your client via the Registration or Missing Information email.

BQ. Self-Assessment Client (Y/N) - Creates SA Client File

If the contact appears more than once on the import a Y must only be entered for them once or multiple SA client files will be created for them.

Add a Y to create a Self Assessment client file for this contact.

If the contact appears more than once on the import a Y must only be entered for them once or multiple SA client files will be created for them.

BR. Personal UTR No. - Missing Information Trigger

The number will be stored under Secondary Contact > Personal UTR. If left blank a request for this information will be sent to your client via the Registration or Missing Information email.

BS. Sole Trader Accounts Period End - Drives Tasks

If a date is added this will turn on the Accounts Service for this client. Format dd/mm/yyyy.

BT. SA Tax Year (e.g. 2020/21) - Drives Tasks

This should always be entered if you perform a Self Assessment for this contact, the format is yyyy/yy (eg 2019/20).

Where no period end has been entered for the Self Assessment, the period end will be assumed as the 5th April for the Tax Year entered.

BU. MTD Qualifying Year (e.g. 2026/27)

BV. Next SA Return Due (e.g. 31/01/2022) - Drives Tasks

The format for Next SA Return Due is dd/mm/yyyy. This deadline will be applied to the SA task for this client.

BW. Next MTD Quarterly Period End (e.g. 05/04/2022)

The format for Next MTD Quarterly Return Period End is dd/mm/yyyy. This deadline will be applied to the MTD Quarterly task for this client.

BX. Next MTD Quarterly Due (e.g. 07/05/2022)

The format for Next MTD Quarterly Return Due is dd/mm/yyyy. This deadline will be applied to the MTD Quarterly task for this client.

BY. Next MTD Final Declaration Period End (e.g. 05/04/2022)

The format for Next MTD Final Declaration Period End is dd/mm/yyyy. This deadline will be applied to the MTD Final Declaration task for this client.

BZ. Next MTD Final Declaration Due (e.g. 05/04/2022)

The format for Next MTD Final Declaration Due is dd/mm/yyyy. This deadline will be applied to the MTD Final Declaration task for this client.

CA. SA Online (Y/N) - Missing Information Trigger

CB. ID Received (Y/N) - Missing Information Trigger

CC & CD. Contact 4 First Name & Last Name

If you are adding a Fourth contact both name cells need to be filled in.

CE. Terms of Engagement Signed (Date)

CF. Date of Birth - Reference Only

This information is stored for reference under Secondary Contact > Date of Birth. The format is dd/mm/yyyy.

CG. Email 1 Required for Client Portal Registration

Field populated is under Main Contact > Email.

This email address will be used to Portal Register the contact.

CH. Email 2 - Reference Only

Field populated is under Secondary Contact > Email. This second address will be added with a comma after any address added to Column AJ.

CI. Postal Address - Reference Only

The address will appear under Secondary Contact > Address in the same format it is entered into this cell.

CJ. Telephone No - Reference Only

The number will be stored for reference under Secondary Contact > Telephone.

CK. Mobile Number - Used for SMS

The number will be stored under Secondary Contact > Mobile. SMS can only be sent to UK and ROI numbers.

CL. NI Number - Missing Information Trigger

The number will be stored under Secondary Contact > NI Number. If left blank a request for this information will be sent to your client via the Registration or Missing Information email.

CM. Self-Assessment Client (Y/N) - Creates SA Client File

If the contact appears more than once on the import a Y must only be entered for them once or multiple SA client files will be created for them.

Add a Y to create a Self Assessment client file for this contact.

If the contact appears more than once on the import a Y must only be entered for them once or multiple SA client files will be created for them.

CN. Personal UTR No. - Missing Information Trigger

The number will be stored under Secondary Contact > Personal UTR. If left blank a request for this information will be sent to your client via the Registration or Missing Information email.

CO. Sole Trader Accounts Period End - Drives Tasks

If a date is added this will turn on the Accounts Service for this client. Format dd/mm/yyyy.

CP. SA Tax Year (e.g. 2020/21)- Drives Tasks

This should always be entered if you perform a Self Assessment for this contact, the format is yyyy/yy (eg 2019/20).

Where no period end has been entered for the Self Assessment, the period end will be assumed as the 5th April for the Tax Year entered.

CQ. MTD Qualifying Year (e.g. 2026/27)

CR. Next SA Return Due (e.g. 31/01/2022) - Drives Tasks

The format for Next SA Return Due is dd/mm/yyyy. This deadline will be applied to the SA task for this client.

CS. Next MTD Quarterly Period End (e.g. 05/04/2022)

The format for Next MTD Quarterly Return Period End is dd/mm/yyyy. This deadline will be applied to the MTD Quarterly task for this client.

CT. Next MTD Quarterly Due (e.g. 07/05/2022)

The format for Next MTD Quarterly Return Due is dd/mm/yyyy. This deadline will be applied to the MTD Quarterly task for this client.

CU. Next MTD Final Declaration Period End (e.g. 05/04/2022)

The format for Next MTD Final Declaration Period End is dd/mm/yyyy. This deadline will be applied to the MTD Final Declaration task for this client.

CV. Next MTD Final Declaration Due (e.g. 05/04/2022)

The format for Next MTD Final Declaration Due is dd/mm/yyyy. This deadline will be applied to the MTD Final Declaration task for this client.

CW. SA Online (Y/N) - Missing Information Trigger

CX. ID Received (Y/N) - Missing Information Trigger

CY. VAT Number - Reference Only

This information will be stored for reference on the Client File under VAT Details > VAT Number.

CZ. VAT Scheme - Reference Only

This information will be stored for reference on the Client File under VAT Details.

DA. VAT Quarter End (e.g. 31/01/2021) - Drives Tasks

This information will be stored on the client file under VAT Details > VAT Period End. The format for this is dd/mm/yyyy and this will be used as the period end for the VAT Tasks.

DB. VAT Next Return Due (e.g. 07/03/2021) - Drives Tasks

This information will be stored on the client file under VAT Details > VAT Next Return Due.The format for this is dd/mm/yyyy and this is the deadline used for the VAT tasks.

DC. VAT Online (Y/N) - Missing Information Trigger

This information will be stored on the client file under Agent Authorisation. Add a Y if you have a current 64-8 for this client’s VAT. If N is entered or the cell is left blank, a request for this information will be sent to your client via the Registration or Missing Information email.

DD. PAYE Employers Reference - Missing Information Trigger

This information will be stored on the client file under PAYE Details > Employers Reference. If left blank a request for this information will be sent to your client via the Registration or Missing Information email.

DE. PAYE Accounts Office Reference - Missing Information Trigger

This information will be stored on the client file under PAYE Details > Accounts Office Reference. If left blank a request for this information will be sent to your client via the Registration or Missing Information email.

DF. PAYE Year Required (e.g. 2020/21) - Reference Only

This information will be stored for reference on the client file under PAYE Details > Year Required.

DG. PAYE Payslip Frequency - Drives Tasks

This information will be stored on the client file under PAYE Details > PAYE Frequency. Your Payroll Task will be created in line with this frequency.

DH. PAYE First Pay Date - Reference Only

This information will be stored for reference on the client file under PAYE Details > First Pay Date. Format dd/mm/yyyy.

DI. PAYE RTI Deadline Due (e.g. 05/06/2021) - Drives Tasks

This information will be stored on the client file under PAYE Details > RTI Deadline. This is the deadline used for your Payroll Task. Format dd/mm/yyyy.

DJ. Next P11D Return Due (e.g. 07/07/2021) - Drives Tasks

This information will be stored on the client file under PAYE Details > Next P11D Return Due. This is the deadline used for your P11D Task. Format dd/mm/yyyy.

DK. CIS Contractor (Y/N) - Reference Only

This information will be stored for reference on the client file under CIS Details > CIS Contractor.

DL. CIS Subcontractor (Y/N) - Reference Only

This information will be stored for reference on the client file under CIS Details > CIS Subcontractor.

DM. CIS Deadline Due (e.g. 19/07/2021) - Drives Tasks

This information will be stored on the client file under CIS Details > CIS Deadline. This is the deadline used for your CIS Task. Format dd/mm/yyyy.

DN. PAYE Online (Y/N) - Missing Information Trigger

This information will be stored on the client file under Agent Authorisation. Add a Y if you have a current 64-8 for this client’s PAYE. If N is entered or the cell is left blank, a request for this information will be sent to your client via the Registration or Missing Information email.

DO. CIS Online (Y/N) - Missing Information Trigger

This information will be stored on the client file under Agent Authorisation. Add a Y if you have a current 64-8 for this client’s CIS. If N is entered or the cell is left blank, a request for this information will be sent to your client via the Registration or Missing Information email.

DP. Auto-Enrolment Staging Date (e.g. 01/06/2021) - Reference Only

This information will be stored on the client file under PAYE Details > Auto Enrolment Staging. Format dd/mm/yyyy.

DQ. Postponement Date - Reference Only

This information will be stored on the client file under PAYE Details > Postponement Date. Format dd/mm/yyyy.

DR. Pension Provider - Reference Only

This information will be stored for reference on the client file under PAYE Details > Pension Provider.

DS. Pension ID - Reference Only

This information will be stored for reference on the client file under PAYE Details > Pension ID.

DT. Declaration of Compliance Due Date (e.g. 01/07/2021) - Drives Tasks

This information will be stored on the client file under PAYE Details > Declaration of Compliance Due. This will be used as the deadline for your Auto Enrolment Task. Format dd/mm/yyyy.

DU. Pension Deadline Due Date

DV. Filing Tasks Default to Staff User (if you leave filing columns blank)

DW to EK - Staff Tasks

The Staff Member entered here will need to have a user account for the import to assign the task correctly. Enter a Staff name for Bookkeeping to turn on this service. Other services are turned on when deadlines are entered on other sections of the import.

EL. Client Notes

This information is stored on the client file under Internal > Notes.

Note - You can also use the “Allocated Office” column to track which office each client belongs to. This will also allow you to filter by the office on the client's list

Search

Welcome to our Support