Skip to content

Knowledge Base

← Back to Knowledge Base Home

Training Tidbit: Report Template for COA Report by Fund Balance Account

Are you looking for a report that lists each fund balance account number and then all the revenue and expenditure accounts tied to that fund balance account number?With Report Writer, you are able to design a report to show this information.

The report example below shows the fund balance account numbers within an activity fund (using Iowa lab data) and the revenue and expenditure accounts tied to each.

For those customers who have the full version of the Report Writer module licensed, we have provided a complimentary template of this report for youto download from our website. You can then importthe report template into the Report Writer module using the Import option.Refer to the steps below for detailed instructions.

Downloading the Report Template:

  • Click this link to access the report template file:https://docs.su-inc.com/training/rw/RWTemplate4.exe
  • A message will appear prompting to run or save the file; click the Run button (the Open button if using Windows 2000). Note: Depending on the security settings of your Internet browser, an additional prompt may appear after clicking the Run button stating the publisher could not be verified; if the additional message appears, click Run to continue.
  • When prompted for the location in which to save the unzipped file, specify a location and then click the Unzip button.The system will default to save the file on your C: drive, but that can be changed if desired.Please note the location you select for where to save the unzipped file.
  • Once the file has been unzipped, a message will appear stating the process was successful; click OK.
  • Then click the Close button to close the screen.
  • There will now be a file called Transfer.mdb containing the report template in the location you specified above.

Importing the Report Template into Report Writer

  • From the Report Writer screen, select the File menu and then Import.
  • The Select Report Writer Database File screen will display prompting for the location of the Transfer.mdb file.Specify the correct location (as noted above) by keying the complete path and file name in the File Name field, or selecting the correct path from the list that appears in the Look In field; then click Open.
  • At the Import screen, select the report to import by clicking once on the box under the Selected column to the left of the report name.A checkmark will appear in the box if the report is selected.
  • Then click the Execute button. Note: If a report with the same name already exists, the system will prompt asking whether you want to replace the existing file; click Yes to replace the existing file, or click No to import the file under another report name.
  • When the import is complete, a message will appear; click OK.
  • Click the X in the upper right-hand corner of the Import screen to display the Report Writer screen.

The COA Report by Fund Balance Account will now be available in Report Writer, and can also be printed by selecting the Reports menu on the main General Ledger screen, and then Report Writer – Custom.To see a full example of this report, click the link below.

https://docs.su-inc.com/training/rw/RWTemplate4.pdf

For more information on the Report Writer module, visit the Report Writer product page of our website. Also, to register for a Report Writer or Advanced Report Writer Workshop where you will learn how to create similar reports and those using additional report features, visit our training calendar.