After you have created the report in FundWare, open Print Manager to view the name of the report.  For example, the trial balance is called GLTRBAL.L02 for division 02. This report exists as an ASCII formatted file in your data directory/reports folder. 
  1. Open a new Excel document.
  2. Select File / Open.
  3. Change the files of type to "all".
  4. Select the report you want to open and click "Open".
  5. The text import wizard will appear.
  6. On Step 1 of 3, click "Delimited" and click "Next".
  7. On Step 2 of 3, mark the "Tab" checkbox, then click "Next" and follow the rest of the instructions in the wizard.
Alternative solution:
  1. Launch Microsoft Excel.
  2. Select File -> Open.
  3. Change the Files of type drop down box to All Files (*.*).
  4. Browse to the report you want to open and click Open.  
  5. The text import wizard will appear.  
  6. On Step 1 of 3, select Fixed Width in the Original data type section, and choose the line that you would like to start the import on. Then click Next. 
  7. On Step 2 of 3, put the lines in at the column ends following the directions on the screen, and click Next. 
  8. Make any necessary changes in step 3 of 3, and click Finish.
FundWare ASCII reports can also be emailed to or copied for coworkers, Board Members, or auditors who do not have FundWare.  Copy the report file out of your FundWare\Data or unique report folder on the server and attach it to the email, etc.  Then include instructions for them regarding how to open this file with their Word or Excel software.