Post-migration WIP Reconciliation using the FYI Time Report

Elite Only.png

Elite plan is currently in Beta for practices in the United Kingdom.

The final step of the migration process is to reconcile the WIP by comparing Xero Practice Manager with FYI. Ensure the WIP entries have been imported into FYI correctly and the balances match.

To compare Xero Practice Manager with FYI, an FYI Admin or a user with permissions to create Views and Reports will need to:

  1. Create a View for the current WIP filtered by "Chargeable" type and "Submitted" status.
  2. Create a Time Report using the new View with the current WIP entries in FYI.
  3. Compare the Time Report from FYI with the Xero Practice Manager "Unbilled WIP" report.

Step 1 - Create a new View for current WIP in FYI

  1. In FYI, click the Practice menu and the Time tab.
    3178_Practice_Time_Tab.gif
  2. Hover over the Time Type column and click the List icon.
    3179_Time_List_Time_Type_List_Icon.gif
  3. When displaying options in the column heading, the option that was last selected for a column (that is, the Filters, Columns or Autosize Columns) is re-displayed so you may need to click the Filters option if this is not the option you last selected.

  4. The Filters option in the column heading displays the values for that column that can used as the filter. Click to de-select (Select All) and then tick Chargeable only.
    3177_Time_Filter_Chargeable.gif
  5. Click on a blank space on the screen to close the filter box.

  6. Repeat the steps to filter the Status column by Submitted entries only.
    3180_Time_List_Status_Filter_Submitted.gif
  7. Click the View Tools button which is at the end of the column headings, on the right-hand side of the list.
    500_NL_View_Tools.gif
  8. Click Save View.

  9. Enter a Name for the view, for example, "Current WIP (Submitted Time)".

  10. Ensure the Reports option is ticked so the View will be available when creating the report in step 2 below.
    3181_Time_List_Save_View_Current_WIP.gif
  11. Click Save and Close.

The View will be saved accordingly. Refer to Saving Changes to the View Layout, Modifying and Deleting Views.

Step 2 - Create the Time Report in FYI

  1. In FYI, click the + button and select Report, or press the keyboard shortcut. The Create Report drawer will open.
    3174_Create_Report_Drawer_New.gif
  2. Ensure the Report field is set to Excel Report.

  3. Select the Time Report from the Template drop-down. This will add the Time field directly below the Template field.
    Note: If there are no templates to select from, please contact the Support Team to add the templates for you.

  4. From the Time field drop-down, select the View created in the previous section e.g. Current WIP (Submitted Time). 
    3182_Create_Report_Time_dropdown_Current_WIP.gif
    Tick the option Include All Columns. This means that all available columns from the Time list will be included in the report and used to prepare the data accordingly.

    The View Type drop-down can be disregarded, as we will not require any additional views for this report.

    The Name of the report will be set to the Name entered in the Time Report Template and can be updated if required. By default, the standard name uses an advanced Merge Field to select the previous month and year. For example, if today's date is the 15th of January, the report will be created with the name "Time Report December 2023". Refer to the section "Advanced Merge Fields and Formatting" of Including Merge Fields in Automations for more details.

    The Cabinet will be selected automatically based on the Report Template and can be updated if required.

  5. Click Run.

  6. The report will be generated in the background. Once created, the report can be accessed from the Documents list in the cabinet selected in the filing details. Refer to Using the Documents Lists.

  7. A notification will also be displayed for the user who requested the report to advise it has been completed. The Alerts icon (bell) in the top-right corner of FYI will display a numbered badge, and the Home - Notifications tab will display detailed information. Refer to Comments and Notifications.

    3175_Notifications_Time_Report_ready.gif
  8. To open the Spreadsheet drawer and view the report, click the Document Name link in the notification. Alternatively, the report can be found in the Documents list. Refer to Using the Documents Lists.
    3184_Notifications_click_Time_Report_Link.gif
  9. From the Edit button drop-down, select Co-Edit.
    Note: Due to the Pivot Table functionality of the report, it's recommended to open the report in the Desktop version of Microsoft Excel.
    3183_Create_Report_Edit_Button.gif
  10. The report will be displayed in Microsoft Excel.
    3176_Time_Report_Excel_WIP_Reconciliation.gif

Step 3 - Compare FYI with Xero Practice Manager

Reconcile the entries in this report with the Xero Practice Manager Unbilled WIP Report to confirm all entries have been imported successfully.

If you need to re-export the report from Xero Practice Manager, refer to Import Xero Practice Manager Unbilled WIP Report (Elite).

Was this article helpful?
0 out of 0 found this helpful