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)||Description||Mandatory / Optional||Comment|
|1||Property ID||ID of the property (hotel, restaurant)||M|
|2||Property Name||Name of the property (hotel, restaurant)||M|
|3||Department ID||ID of the department within the property||M|
|4||Department Name||Name of the department within the property||M|
|6||Month||Accounting month (period)||M|
|7||Account ID||ID of the account||M|
|8||Account Name||Name of the account||M|
|9||Amount||Amount (sum of debit and credit)||M||Net balance on the account|
|10||Credit/debit||Credit or debit sign||M||The 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
It is advised to use the format .csv if possible and otherwise Excel will suffice.
Steps of pulling a Visma report;
- Hovedbokstransaksjoner/Ledger Transactions
- Pick you fields – see picture
- Write it all out in Excle format first and…
- Delete all balance accounts or simply pick from what accounts you wish to the far right.
- Once done save as .csv file and either e-mail to support; email@example.com or save in specified catalogue on the hotel server.
- 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)
- Name of Account
- Value = sum of verifications within the period/month
- Opening balance
- Closing balance
- Balance Accounts (1000-2999)