How to confirm if P&L accounts are pulling the correct data

Hamburg-based RIMC Hotels & Resorts implements d2o's Productivity Management tool PMI in 16 of its hotels

Written by Geson Perry

May 20, 2025

May 20, 2025

To quickly check if the revenue shown in your P&L report matches what’s in the Accounts view, and to confirm where the data is coming from (e.g., Budget, Forecast, or Live values), follow these steps:

Step 1: Compare Totals

  • Open the P&L report and note the total revenue.
  • Then go to Planning → P&L → Accounts for the same period.
  • Use the filter to show only Revenue accounts to simplify the view.
  • Check that the totals match. If they do — you’re good to go ✅

Step 2: Check Where Each Account Pulls Data From

To understand exactly which source (Budget, Forecast, etc.) a revenue account is using:

  • Still in Planning → P&L → Accounts, find the account in question.
  • Click the calculator icon next to the account name.
  • A pop-up labeled Source Definition will appear. This shows which dataset PMI is using — such as:
  • Hotel name → Room Revenue (Forecast)
  • Hotel name → Food Revenue (Budget)

This is especially useful if your setup includes manual overrides, custom mappings, or multiple data sources.

Step 3: If Totals Still Don’t Match

  • Check account mappings: Go to Mapping → Accounts and confirm each account is correctly assigned.
  • Look for split accounts: If one account feeds multiple departments, make sure the splits are correct.
  • Use the Import Status module to check if all expected revenue has been pulled in.
  • Use Flash Report: Hover over revenue figures to view the underlying data imported from your PMS/POS.

Share this article!

You may also like…

0 Comments