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.

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.