The Unmatched Client Import can be used:
- As an alternative way to resolve or merge unmatched clients, especially where you have a lot of unmatched clients.
- To update unmatched clients to the relevant active using the Client Name or Client Code and to archive the unmatched clients in bulk.
Note: Client Code is not available for UK sites.
The Unmatched Client Import process uses an Excel spreadsheet as the import template. This spreadsheet can be requested from your Onboarding Consultant.
- In the spreadsheet, you add the unmatched clients that you want to match to an active client and you add the Client Code and Name of the active client to match them to.
- The process will automatically match the unmatched client to the active client and merge the documents to the active client.
- The process can also be used to automatically archive the unmatched client. This is done by additionally entering in the spreadsheet the name you want the client to be shown as when archived. If this differs to the unmatched client name, the process updates the name of unmatched client name and then automatically archives the unmatched client.
Note: The process cannot simply update the unmatched client name.
- Where the process cannot automatically match the unmatched client to an active client (if the information for the active client is not entered in the spreadsheet, or the active client name does not exist) no changes will be made to the unmatched client.
To run the Unmatched Client Import, your practice must have nominated a OneDrive Admin Account User. Refer to Link your Practice's OneDrive Admin Account.
Preparing and Running the Unmatched Client Import
- Request the spreadsheet Unmatched Client Import template from your Onboarding Consultant.
The spreadsheet holds the following columns:
Column A Unmatched Client Name Column B Client Code Match Column C Client Name Match Column D Create Archived Client
- Export a list of your unmatched clients in FYI.
In the FYI Clients list, use the Status column to filter only "Unmatched" clients. Then use the Export view tool to export the unmatched clients to a .csv file (refer to Exporting Lists).
- Update the Unmatched Client Import spreadsheet as follows:
Important Note: Do not change the order of the columns or the column names in the spreadsheet. If they are changed, the process will not be able to complete the auto-match.
a) Remove any examples that are already in the spreadsheet.
b) In Column A, add the unmatched Client Names.
c) In Column B, add the Client Code of the active client that you want to match the unmatched client to.
Column B can remain blank if Client Codes are not available.
d) In Column C, add the Name of the active client that you want to match the unmatched client to. This should match client's name from Xero Practice Manager.
e) In Column D, if you want the unmatched clients to also be automatically archived, enter the name you want the archived client to be created as.
Leave Column D blank if you do not want the unmatched client to be archived.
- Save the spreadsheet as a .csv file with the filename Unmatched
Important Note: The next two steps need to be completed using the OneDrive account that is listed as the OneDrive Admin Account user in FYI. Refer to Link your Practice's OneDrive Admin Account.
- Open your practice's Admin OneDrive and add a new folder. The new folder must be named:
FYI - Practice Sync
- Upload the Unmatched .csv file to the newly created folder FYI - Practice Sync
The system will automatically import the spreadsheet to your FYI and automatically update the unmatched clients within the hour.
- Send your Onboarding Consultant an email who will confirm the upload has been completed.