PMI Knowledge base

Back to Knowledge base

More results...

Generic filters
Exact matches only
Search in title
Search in content
Search in excerpt
Filter by Custom Post Type
PMI Knowledge Base
Article contents (TOC)
Print

How is the month-to-date forecast and budget calculated in the Flash report?

January 6, 2025
UpdatedFebruary 12, 2025
ByEldorette Hines
Views390
Please Share Your Feedback
How Can We Improve This Article?

The MTD (month-to-date) forecast is the amount you should have by this point in the month/period, in order to reach your end-of-the-month forecast, given that your Live forecast for the rest of the month is correct.

The calculation is: ME (month-end) forecast divided by month-end Live forecast multiplied by MTD actuals.

In the example below, reflected in the screenshot:

A. ME Forecast: 58,571

B. ME Live forecast: 56,430

C. MTD Actual: 7,314

D. A (58,571) divided by B (56,430) multiplied by C (7,314) = MTD forecast (7,591)

 

Image description: The Flash report in PMI with method for calculating MTD forecast/budget

Note: If the MTD actual is higher than this amount you will exceed the forecast and vice versa. The Forecast index is calculated by taking the month-end figure and dividing it by the forecast figure.

The index indicates where you will end up at month-end compared to the forecast. Deviation is also displayed in local currency.

The above calculation works the same way for Budget: Month-end Budget divided by month-end Live forecast multiplied by MTD actuals.

 

Troubleshooting tips

This section provides additional troubleshooting advice for readers experiencing specific issues. While it’s packed with useful insights, you may skip it if you’re not facing any related problems.

Troubleshoot data in the Import Status view

Accessing the Import Status View:

  1. Navigate to the main menu and select Import Status.
  2. Choose your desired chain, property, status, and interface filters.
  3. The view will display detailed import information for the selected property.

Troubleshooting Missing or Delayed Data:

If Interface Status is “In progress”: This indicates that data is actively being imported and is currently in the ingestion queue. It will soon “arrive” and be visible within PMI.

If data appears to be missing:

  1. Use the search (magnifying glass) to drill down into the details.
  2. Compare the data received with what’s displayed in PMI to ensure alignment.
  3. Check for potential issues like unmapped accounts or ignored figures that may prevent data from appearing.
  4. If discrepancies persist, consider performing a new import to refresh the data.

Providing context for better insights

Issue: Users ask broad questions like “Where is my data?” or “What do these figures tell you about my productivity?”without providing sufficient context or visual input.

If you're unsure why specific data or insights aren't displaying as expected, ensure your query includes enough context. You can also use the Query Library, which offers premade queries tailored to common needs—screenshots are automatically added when required for these queries. 

For custom queries, consider taking a screenshot of the relevant data or view by clicking the camera icon. Providing clear context or visuals helps the AI analyze your data more effectively and deliver accurate responses.

Tags: