Support Centre

RoomKeyPMS Payments - Payment Reconciliation Report Printing/Exporting

Updated on

The Transaction Reconciliation Report can be printed by selecting the “Print Preview” button located to the right of the screen.  

The next screen will display exactly what the guest is viewing when "Print Preview" is selected (ie:  Date Range, Ignored Transactions if Ignored Transactions box is checked, Transaction Details if boxes are expanded, etc...).  The guest can then select "Print" at the bottom of the preview screen to Print the report to a printer or use Microsoft Print to PDF to save as a PDF. 

The “Export to CSV” option allows clients to pull all the data associated with the Date Range selected at the time “Export to CSV” was selected.  This export will include all the Transaction Details including Ignored Transactions.  

Should the client wish to view this data in Excel, below is the best practice on how to open this Export to ensure all data is displayed correctly.  After the file has been saved to your computer, using desktop Excel, go to the Data Menu -> From Text/CSV to import the CSV file.

Once CSV file has been selected, select "Open" and the following screen will appear.  Change the Data Type Detection to "Do not detect data types" and click the "Load" button below.

The CSV file will now open in Excel.  

This file can be opened using just the Open file method, however, if there are any Authorization Codes or if the Last 4 Digits of any cards start with a "0" - the 0 will not be displayed.  To display all information correctly within Excel the file must be properly loaded using the above steps.

Have a question for us? Submit a Support Case