Financial Export Overview

Financial Export Modules allow you to export financial figures from PMPRO into a file format that can be imported again by your accounting or back office system. This will save you time and errors, compared to when you would have to manually enter the figures into your accounting system. Financial export modules are not part of the standard Amadeus - PMPRO installation, a separate license is required.

The details given below is an indication of figures that can be exported. However, not all export modules can export these figures. Please refer to the details of a specific financial export module for more information.

Guest Ledger Figures

The following guest ledger figures will be exported:

Revenue summarized by posting date, product.
TAX/VAT summarized by posting date, vat group.
The revenue and TAX/VAT figures will be exported by financial department when the parameter ExportDepartments in the export configuration file is set to 'Yes'.
Payments summarized by payment date and pay method.
Incoming deposit transfer from deposit ledger to guest ledger (during check-in).
Outgoing ledger transfer from guest ledger to city ledger (ledger/account to company payments).

Deposit Ledger Figures

The following deposit ledger figures will be exported when the parameter ExportDepositLedger in the export configuration file is set to 'Yes'.

Payments entered in the deposit module, summarized by payment date and pay method.
Outgoing deposit transfer from deposit ledger to guest ledger (during check-in).

Deposit payments are purged from the deposit system after the reservation has checked-out. Therefor you should export your financial data on a daily basis when you include deposit ledger figures.

City Ledger Figures (Accounts Receivables)

Depending on how you would like to work with your A/R accounts, you can export the city ledger figures in two different ways. You need to make a choice between the two methods, otherwise your back office system will import duplicate city ledger balances.

Export Invoices: Account Receivables are managed in your accounting system

In this situation you don't use the Account Receivables module from PMPRO. In stead you use your back office system to enter received payments and send statements and reminders. The following figures are exported when the parameter ExportInvoices in the export configuration file is set to 'Yes':

Invoices (ie ledger/account to company payments) are exported into the sales ledger of the accounting system. The export contains the total outstanding amount of each invoice. Invoice transaction details are not exported as they are included in the guest ledger export.
Address details of guests and account receivables can be exported, although generally they are not.

Export City Ledger: Account Receivables are managed in PMPRO

In this situation you use the Account Receivables module from PMPRO. Statements and reminders are being sent from within PMPRO and received payments are entered in the PMPRO A/R module. The following figures are exported when the parameter ExportCityLedger in the export configuration file is set to 'Yes':

Incoming ledger transfer from guest ledger to city ledger (ledger/account to company payments).
Payments entered in the Accounts Receivable module, summarized by payment date and pay method.
Adjustments entered in the Accounts Receivable module, summarized by posting date, product and financial department.

Figures that are Never exported

Invoices: transaction details and tax/vat on the invoice level is not exported. The details are already included in the guest ledger export.
Address details: address details of guests and account receivables are generally not exported (with the exception of exports for specific accounting systems).