Within OnQ, please run the below reports for 3 recent days (preferably high occupancy nights) in chr format using the step by step instructions below:
REPORT CODE | REPORT NAME |
TRIALBAL | Trial Balance |
RECRCP | Detailed Receivables Recap |
GSTSTATS | Room/Guest Statistics |
MCATRPT | Market Category Report |
The files will download similar to below (with the date in the file name).
Within OnQ, go to Reports List
Select All Reports
Select the first report: Trial Balance (as you run reports, the report selected will change)
Select Preview
Change the Bus Date and then select OK
When the report opens, click on the envelope at the top to open the Export screen
Change the Export Format to Character-separated values
Change the Destination dropdown to Desk File
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.
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.
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.
Follow the above instructions for the remaining reports, where you update Step # 4 according to the report needed. Below are the reports needed:
TRIALBAL Trial Balance
RECRCP Detailed Receivables Recap
GSTSTATS Room/Guest Statistics
MCATRPT Market Category Report
Save these in chr format and send these to your Implementation Specialist via the task assigned.