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

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…