How do I reconcile a WIP Control Report with data in FYI?

When the two values do not match, this is often caused by an incorrectly configured Time view, missing required columns, or filters that do not match the reporting period.

Common causes include:

• Missing columns such as Billable Amount, Invoiced Amount, or Write-on/off Amount.
• Incorrect filters applied to the Time view.
• Using relative date filters that do not match the report period.
• Invoice Date filters are not aligned to the report period.

This article explains how to reconcile your WIP Control report by ensuring your Time view is configured correctly, and how to reconcile each report column using the appropriate filters and totals in FYI.

Reconciling the Report

Step 1 - Create a Time View used to reconcile totals

Create a Practice - Time view to use to reconcile the report:

1. Navigate to the Practice - Time workspace.
   Note: Users must be assigned to User Group with the Practice Time permission enabled.
    
2. Ensure the following columns are added to the view:
   • Date
   • Invoiced Date
   • Type (interim, time, disb)
   • Status
   • Billable amount
   • Invoiced amount
   • Write-on/off amount
   • Billable rate
   • User
   • Time
      
3. Save the view.
   Tip: Ensure you name the view a name that is associated with its use. For example, 'Reconciling WIP report values'.

Step 2 - Reconcile each Report Column

Reconcile the totals between your WIP Control Report Column and the corresponding Values in the Time view.

Use the table below, for each Report total, using the Time view created in  Step 1:

1. Apply the filters to the Time View.
2. Using calculations, display the total column value.
3. Reconcile the Report Total to the calculation displayed in the FYI view.
   For example, the Billable Amount Period in the WIP Control Report should match the Billable Amount values displayed in FYI, when the associated filters have been applied.
4. Where the values do not match, move to Step 3.

Step 3 - If the values still do not match

Ensure that the Time view that the WIP Control Report is using:

• The period dates match the dates.
• Avoid using relative date filters such as “Last month” unless they match the exact reporting period.
• Ensure Interim entries are included or excluded as required for the specific column.
• Confirm the correct Status values are selected.
• Check for entries invoiced in a different period than the time was recorded.

Run the WIP Control report again, with the correct columns and filters applied.