As part of migrating historical information, your documents are imported from a folder structure that represents your filing structure.
For practices integrated with Xero Practice Manager, the FYI import function will use folder names to match clients in Xero Practice Manager. If any Clients in Xero Practice Manager do not match your nominated folder structure for FYI, the clients and documents can then be created as Unmatched Client names and then resolved. Refer to Creating and Resolving Unmatched Clients (Folder-Based Systems) in Implementors: Live Import.
Note: When you begin your trial with FYI and your client list is migrated, this does not bring in any of your archived clients. However, when you import your documents (from your historical document store) if there are any archived clients in Xero Practice Manager, these will be imported but will not match to a client in FYI. The FYI import will create these as ‘Unmatched clients' in FYI and the documents are stored under the unmatched client names.
This video will show you how to:
- Identify unmatched clients
- Merge unmatched clients with active clients
- Delete unmatched clients
- Locate unmatched clients, in order to view the documents associated with them
Note: Unmatched clients are now displayed in the Clients list by selecting "Unmatched" as a filter in the Status column (not with the Archived button).
This article contains the following sections:
- Displaying the Status and Source in the Clients List
- Using Resolve Clients
- Matching an Unmatched Client
- Matching an Unmatched Client in the Resolved Clients Function
- Exporting the Unmatched Clients
- Leaving an Unmatched Client as an Archived Client
- Removing Unmatched Clients that have no Files
- Removing all Unmatched Clients and documents
- Deleting an Unmatched Client
- If a Client is Merged to the Wrong Client
Displaying the Status and Source in the Clients List
You can use the Status column in the Clients list to filter on "Unmatched" client as well as "Archived" clients. You can also use the Clients Bulk Update to set "Unmatched" clients as "Archived". Refer to Bulk Update Unmatched Clients as Archived in Clients Bulk Update.
You can also include the Source column to display and filter on the source of the client. Refer to Adding/Removing/Moving Columns in a List. This column shows the following:
- XPM - The client has been created/synced from XPM.
- Practice Sync - The client has been created/synced with the Generic Practice Management Software (refer to Integration with Generic Practice Management Software).
- Legacy - The client has been created from the migration process, but was not matched with a client in FYI, The unmatched client was created in FYI in the Refile function and then shows the Source as Legacy. Refer to Creating and Resolving Unmatched Clients in Implementors: Live Import.
Using Resolve Clients
The following are some examples of how Resolve Clients is used and what it does.
Note: The Resolve Clients button is only included if there are any unmatched clients.
- There is a difference in the spelling of the name in the folder. For example, in the folder structure the client name has been entered as "Jones, Antony" but the correct name is in Xero Practice Manager is "Jones, Anthony". An Unmatched Client is created for "Jones, Antony".
Use the Resolve Clients function to match the incorrect client name to the actual client. All the documents will show in FYI under the actual client name as held in Xero Practice Manager.
- There is an additional folder for a client with a different name. For example, most of the documents for "Smith, Abigail" are in the folder structure as "Smith, Abigail" but there is also an additional folder "Smith, Abigail 1" with some additional documents.
Use the Resolve Clients function to match the additional client to the actual client.
When merging an Unmatched Client into an actual client, you do not lose anything already filed to the actual client. The actual client will now contain both sets of documents. All the documents will have the client name as the actual client.
- There is an Unmatched Client that you do not want to import as an active client. This may be, for example, for an historical client from before you started using Xero Practice Manager.
You can leave the client in the Resolve Clients without matching it. The client and any documents that have been imported for it, will be kept in FYI as an Unmatched client. You can display and search for documents for the Unmatched client. Refer to Archived Clients.
- From FYI, you can mark Unmatched clients as "Archived" using the Clients Bulk Update. Refer to Bulk Update Unmatched Clients as Archived in Clients Bulk Update.
- The name of an archived client can be changed in the Client - Summary tab (refer to Client Summary). This can be useful when clients are imported as part of the migration and they have been imported as Client Codes instead of names.
- If you are sure you do not need the documents for the imported Unmatched Client, and are sure it is not needed as an archived client, it can be deleted in the Resolve Clients function. This will also delete the associated documents. Refer below to Deleting an Unmatched Client.
Matching an Unmatched Client
An Unmatched Client can be matched to a Client in Xero Practice Manager:
- Using the FYI Resolve Clients function (refer below to Matching an Unmatched Client in the Resolved Clients Function).
- Using the Unmatched Client Import process (refer to Unmatched Client Import).
Matching an Unmatched Client in the Resolved Clients Function
- Display the Clients list on the Clients workspace.
- Click the filter for the Status column.
- Filter only on "Unmatched"
The Clients list includes unmatched client which display Unmatched next to the Client Name.
- Click the Resolve Clients button on the right-hand side.
Note: The Resolve Clients button is only included if there are any unmatched clients.
The Merge Clients displays with a list of unmatched clients that were created in FYI.
The Delete Client button only displays for FYI Admins.
Note: This can also be accessed from Settings - Practice Settings - Documents - Import/Export tab.
- Select an Unmatched Client and, on the right-hand side, search for the correct Client in Xero Practice Manager.
6. Click Merge to match it.
When merging an Unmatched Client into an actual client, you do not lose anything already filed to the actual client. The actual client will now contain both sets of documents. All documents will have the client name as the actual client.
Exporting the Unmatched Clients
You can export a list of the names of the Unmatched Clients as a .CSV file which you can open in Excel. This can be useful to compare to your previous system to check which client to match to the Unmatched Client in FYI. From the Actions button, select Export.
Leaving an Unmatched Client as an Archived Client
You can leave the imported client as an Unmatched Client without matching it. The client, and any documents that have been imported for it, will be stored in FYI as an Archived client. Refer to Archived Clients.
The name of the Unmatched Client can be changed if needed in the Client - Summary tab (refer to Client Summary). This is useful if the client name has been imported as a Client Code.
Removing Unmatched Clients that have no Files
You can remove any of the unmatched clients that do not have any files. From the Actions button, select Remove unassigned. This checks any of the clients that are unassigned and removes them from the list of unmatched clients.
Removing all Unmatched Clients and documents
You can also remove all the unmatched clients that have files. From the Actions button, select Remove all unmatched clients and documents. You are prompted to confirm. This checks any of the clients that are unassigned that have documents. This removes the clients and documents and removes the client from the list of unmatched clients.
Deleting an Unmatched Client
If you are sure you do not need any information relating to the imported Unmatched Client it can be deleted from Merge Clients. This will remove the unmatched client but any associated documents are left and can be refiled under a different client. This function is only available to FYI Admins.
- Before deleting an Unmatched client, ensure that it is not needed as an archived client.
- To delete the Unmatched Client, in Merge Clients, select the client and click Delete Client.
If a Client is Merged to the Wrong Client
If you accidentally merge an unresolved client to the wrong client you can refile the documents to the correct client using Bulk Update.
You can identify the documents that need to be updated as follows:
- Select the client that the unresolved client was merged to in Clients.
- Display the Client - Documents tab.
- Add the Source column to the view to show where the files were imported from. This will display information such as the directory (refer to Adding/Removing/Moving Columns in a List).
- Filter the view to show only these documents (refer to Sorting and Filtering).
- Select the documents and use Bulk Update to file them to the correct client (refer to Bulk Updating of Filing Details).