*PMS Integration must be activated by Inn-Flow first. Please contact Support to activate your property for the correct PMS Integration option.*






 

Hilton/OnQ Operations Audit Extract Instructions

 

To complete the Hilton/OnQ Daily Activity Import, there are 2 main steps to be completed. 

 

Part 1 is downloading the night audit reports in PDF and .chr format. 

 

Part 2 is importing the reports into Inn-Flow. (not required if subscribed to Bookkeeping Services with Daily Activity)


Part 1:

 

Within OnQ, please run the below reports on a nightly basis and save as chr format using the step by step instructions below.

 

OnQ Reports Needed:

REPORT CODE                       REPORT NAME                        

TRIALBAL                                 Trial Balance

RECRCP                                  Detailed Receivables Recap

GSTSTATS                              Room/Guest Statistics

MCATRPT                               Market Category Report

 

Within OnQ, go to Reports List

 

A screenshot of a social media post

Description automatically generated

 

Select All Reports

 

Select the first report: Trial Balance (as you run reports, the report selected will change)

 

Select Preview

 

A screenshot of a cell phone

Description automatically generated

 

Change the Bus Date and then select OK

 

A screenshot of a cell phone

Description automatically generated

 

When the report opens, click on the envelope at the top to open the Export screen

 

A screenshot of a cell phone

Description automatically generated

 

Change the Export Format to Character-separated values

 

A screenshot of a cell phone

Description automatically generated

 

 Change the Destination dropdown to Desk File

 

A screenshot of a cell phone

Description automatically generated

 

Select OK

 

On the next pop-up, the Separator and Delimiter box should be shown as below. Please update the Separator box to have a Caret (^), found by selecting Shift 6, and Quotation marks (“) in the Delimiter box.

 

A screenshot of a cell phone

Description automatically generated
 


 

 

 

 

 

 

Select OK

 

On the next pop-up, check both boxes then select OK. This step is key. If these boxes are not selected, the numbers will be rounded and the import will not work. Please ensure the boxes are selected.

 

A screenshot of a cell phone

Description automatically generated

 

The next pop-up, you’ll be prompted to Save the file. The file should be saved as a .chr format. You can save the file as the prompted name but add a distinguishing factor for each reference, like TRIAL BAL 12.30.19 for the 12/31/2019 file.

 

A screenshot of a cell phone

Description automatically generated

 

Follow the above instructions for the remaining reports, where you update Step # 4 according to the report needed. Below are the reports needed:

 

REPORT CODE                       REPORT NAME                        

TRIALBAL                               Trial Balance

RECRCP                                 Detailed Receivables Recap

GSTSTATS                              Room/Guest Statistics

MCATRPT                               Market Category Report



Part 2: (not required if subscribed to Bookkeeping Services with Daily Activity)

 

Within Inn-Flow, go to Daily Activity Entry.

 


Select Import.

 

 

 

Select the Upload/Import PMS button.

 

A screenshot of a cell phone

Description automatically generated

Select Upload on the top right of the page.

A screenshot of a cell phone

Description automatically generated

 

Select Choose Files and select the files saved from Part 1 above. Make sure to select ONLY the chr version reports that were saved in Part 1 of the instructions. All files must be uploaded at the same time.

 

A screenshot of a cell phone

Description automatically generated

 

 The next screen should appear as below:

 

A screenshot of a cell phone

Description automatically generated

 

This will remove any previously entered data and overwrite it per the reports. Please OK to continue.

 

A screenshot of a cell phone

Description automatically generated

 

 You’ll receive a pop-up when your files have been imported successfully. Select OK.

 

A screenshot of a cell phone

Description automatically generated

 

Then select Close on the top right of the screen to proceed back to Daily Activity Entry.

 

From there, select the Upload Docs button to import the PDF reports. This version of the reports is helpful for reference or any review that may be needed. 

 

If the red box appears with Auto Import Errors, please create a Support Ticket by emailing Support@Inn-Flow.com, or by selecting the Help button on the bottom right of the page. We will take care of the error so that it imports correctly moving forward.

 

Following the upload, please upload the below reports in PDF version should you need to reference the reports in the future. All below reports should be uploaded into the Upload Docs location within Daily Activity.

 

 

REPORT CODE         REPORT NAME                                   

RECRCP                    Detailed Receivables Recap

GSTSTATS                 Room/Guest Statistics

DPAUDSAA                Account Summary Report

MCATRPT                   Market Category Report

TRIALBAL                   Trial Balance 

 

 

Complete the Night Audit Checklist and Approve & Next to proceed to the following day.