Data elements required from AMS

The table below shows the PMI data elements required for PMI Planning module. Corresponding data elements must be identified and included in the export routine that is to be set up in the accounting management system (or ledger/ERP). The extract only needs to include P&L accounts – balance sheet accounts are not used in PMI Planning.

#PMI data element (target)DescriptionMandatory / OptionalComment
1Property IDID of the property (hotel, restaurant)M
2Property NameName of the property (hotel, restaurant)M
3Department IDID of the department within the propertyM
4Department NameName of the department within the propertyM
5YearAccounting yearM
6MonthAccounting month (period)M
7Account IDID of the accountM
8Account NameName of the accountM
9AmountAmount (sum of debit and credit)MNet balance on the account
10Credit/debitCredit or debit signMThe sign should be in a separate column so it can be mapped in PMI – not part of the amount.


Please note: The names of data elements are provided in source system (native) codes. These native codes will be translated into PMI names in PMI.

VISMA IMPORT ACTUAL FIGURES

For import of Actual figures from Visma into PMI Planning P&L

Visma Hovedbok.png

It is advised to use the format .csv if possible and otherwise Excel will suffice.

Steps of pulling a Visma report;

  1. Regnskap/Accounting
  2. Bilagssøk/Verifications
  3. Hovedbokstransaksjoner/Ledger Transactions
  4. Pick you fields – see picture
  5. Write it all out in Excle format first and…
  6. Delete all balance accounts or simply pick from what accounts you wish to the far right.
  7. Once done save as .csv file and either e-mail to support; support@d2o.com or save in specified catalogue on the hotel server.
  8. This should be done once a month once closing of the previous month is completed.

The fields that are to be included are;

  • Visa save as .csvYear
  • Period (1-12)
  • Account
  • Department
  • Name of Account
  • Value = sum of verifications within the period/month

Not needed:

  • Opening balance
  • Closing balance
  • Balance Accounts (1000-2999)

Was this article helpful?

Related Articles