Financial

WinTeam and eHub contain an extensive amount of information that is relevant to your business operations. However, it is not always easy to isolate the information you need due to the volume of available information. The goal of the Insights page is to reduce the time and effort you spend locating the information you need, and deliver it directly to you so that you can focus on operations and less on the applications.

The Insights page includes data feeds that are divided by categories that are relevant to core business operations. Data is generated and updated in different cadences within these categories (daily, weekly, period close, etc.)

Note:  Insights that provide analysis around the last fiscal period are only generated when the fiscal period is marked as closed in WinTeam in the Fiscal Year Setup window.


Category Financial
Cadence Weekly

Logic
  1. This Insights first determines the most recently completed work week (last week) and the work week prior (prior week) using the date at run time.
  2. Then pulls back all work tickets that are marked as ‘Closed’, with a Completed Date over that two-week period.
  3. Dollar amounts for each of the two weeks are calculated by totaling the extension for line items that are listed as ‘billable’ from the ticket’s actuals (as opposed to budgeted).
Example Company 1 (River City Services) closed $23,400 in billable work tickets last week, up 10% from the previous week!
WinTeam Reference

This Insight runs on the first day of each pay week. Pay week start date can be seen and edited on the Payroll > Defaults page in WinTeam.

The measurement periods are also defined by this value. For example, if the pay week starts on Monday 5/13, the immediately preceding week is Monday 5/6 to Sunday 5/12. The week prior to that is Monday 4/29 to Sunday 5/5.

The WS: Billable Ticket Review screen will show matching amounts when filtered to the same date range (last work week or week prior’s work week) and ‘Include Tickets Not Invoiced’ is checked.

Category Financial
Cadence Daily

Logic

  1. Determine all AR Invoices that a) have an Invoice Date prior to the current date, b) are outstanding (not marked as Paid), c) and are Past Due.

  2. Calculate the days past due for each Invoice by adding the Past Due Days from the Invoice's Terms to the Invoice Date and comparing that result against today's date.

  3. The total amount due is based on the Invoice’s Invoice Total (Revenue Total + Tax) minus any amounts already paid.
  4. Total invoice amounts are they split into buckets based on values found in WinTeam -> AR: Defaults -> Invoice Aging Periods:
    • Bucket 1: From 1 day to the value in Bucket 1
    • Bucket 2: From Bucket 1 + 1 to Bucket 2
    • Bucket 3: From Bucket 2 + 1 to Bucket 3
    • Bucket 4: From Bucket 3 + 1 to Bucket 4
    • Bucket 5: Greater than Bucket 4
    • Total AR Past Due: Greater than 1 day
Example

Bucket 1 Past Due: AR Past Due between 1 and 30 days is $173,155 (33% of total past due).

Bucket 2 Past Due: AR Past Due between 31 and 60 days is $157,414 (30% of total past due).

Bucket 3 Past Due: AR Past Due between 61 and 90 days is $89,201 (17% of total past due).

Bucket 4 Past Due: AR Past Due between 91 and 120 days is $41,977 (8% of total past due).

Bucket 5 Past Due: AR Past Due greater than 120 days is $62,965 (12% of total past due). Total AR Past Due: Total AR Past Due is $524,712 from 204 invoices.

WinTeam Reference