Execu/Tech Systems, Inc.
Knowledgebase
Search:
850-747-0581EmailWebsite
Contents
 
IndexBookmarkPrint This Article

Home > Execu/Suite Hotel PMS > Execu/Suite Hotel PMS Procedures > Folio Detail Export

To save folio transactions to a spreadsheet do the following:

Bullet-point instructions
Detailed instructions

 Bullet-point instructions
  1. Go to Select Printer - Preview/Print to screen.
  2. Go to either the Night Audit menu or the Manager Menu.
  3. Go to Print Guest Trial Balance (Detail).
  4. Select #11, "Print single folio".
  5. At the prompt enter the folio number.  Press Enter or click OK to print all.
  6. Answer Yes to "Detail lines only?"
  7. When the next screen opens, click "Print Detail".  Enter the beginning date to print.  If you want to include zero-balance accounts, click that option.
  8. When the report displays, select "Save to text file".
  9. Remember where you save it.  You will use that file for the import into Excel.
  10. Open Excel and go to its Data Import function.  Browse to the text file you saved.  You can also use Excel's Open function.
  11. The file you import will be a fixed width file type.


Detailed instructions 

Go to Select Printer - Preview/Print to screen.

Go to either the Night Audit menu or the Manager Menu.  Select Print Guest Trial Balance (Detail).



Select #11, "Print single folio".



At the prompt enter the folio number.  Press Enter or click OK to print all.



Answer Yes to "Detail lines only?"



When the next screen opens, click "Print Detail".  Enter the beginning date to print.  If you want to include zero-balance accounts, click that option.



When the report displays, select "Save to text file".





Remember where you save it.  You will use that file for the import into Excel.  You can rename the file if you wish.  Make sure to save it as a *.txt file.





This is what the text file looks like.  Yours will have detail, of course.


Open Excel and go to its Data Import function.  Browse to the text file you saved.  You can also use Excel's Open function.



The file you import will be a fixed width file type.



This is what the spreadsheet will look like.  Yours will have data, of course.

  
           







Related Files
none..

Related Pages
none..





Article ID
 folio_detail_export
Views
 862
Last Modified
 10/21/2016 3:59 PM