Page Comparison

...

Generates a detailed report of transactions that make up the amounts in either the Budget accounts or the Revenue accounts per user's selection.  The canned report version of the Budget/Revenue Account Activity Report was created to increase performance.

• Save and Recall: Can be used to save report parameters and recall options later.
• Account Activity Type:  defaults to Budget checkmarked for selection, but Revenue can be chosen. 
• Start/Stop dates: Select dates for output report if desired.  
• Format: Select format for output report. Defaults to PDF.
• Include Full Account Code(s): Filter to only include transactions charged to a specific detail Account Code(s). 
• Include other Account Code Parameters: Filters to only include transactions charged to accounts meeting the entered parameters. Wildcards cannot be utilized in these fields. For more complex sort options, an account filter can be used.
• Filter: Select an account filter to include only transactions meeting those account parameters on the report.
• Show Options: This option will include a cover page showing the report options chosen for generating the report.
• Generate: Generates the report.

...

By default all accounts are selected but the user can narrow down accounts by utilizing the account dimensions or Account Filter. The account status report is sorted by full account, activity and subtotaled only by activity. It does not include accounts without transactions.

• Save and Recall: Can be used to save report parameters and recall options later.
• Start/Stop dates: Select dates for output report if desired.  
• Report Format: Select format for output report. Defaults to PDF.  
• Include Cash Account(s): Filter to only include transactions charged to a specific Cash Account(s). 
• Include Full Account Code(s): Filter to only include transactions charged to a specific detail Account Code(s). 
• Exclude Full Account Code(s): Filter to exclude transactions charged to a specific detail Account Code(s).
• Include other Account Code Parameters: Filters to only include transactions charged to accounts meeting the entered parameters. Wildcards cannot be utilized in these fields. For more complex sort options, an account filter can be used.
• Filter: Select an account filter to include only transactions meeting those account parameters on the report.
• Show Report Options: This option will include a cover page showing options chosen for generating the report.

...

Snapshot of the report in pdf format.

Anchor
audit audit

Audit Report

A report showing additions, deletions and modifications to transactions with the ability to sort by username and date as well as to use control and page breaks.

Classic Comparison: AUDITS

• Save and Recall: Can be used to save report parameters and recall options later
• Start/Stop dates: Required to select dates for output report.  
• Select Operation:  Select transaction operation(s) to be included on report: 
  • Create - Will show transactions that have been created.
  • Update - Will show transactions that have been modified.
  • Delete - Will show transactions that have been deleted.
• Select Objects:  Select objects to sort on or leave blank to select all objects.
• Select Specific Users:  Select specific user or leave blank to select all users.
• Format: Select format for output report. Defaults to PDF but Comma Separated Values format is available.

...

Anchor
budsum budsum

Budget Summary Report

Summary report for one, several, or all of the budget accounts. It includes the expendable amount, actual expenditures, current encumbrances, unencumbered balance, and percentage expended/encumbered.

Classic Comparison: BUDSUM

• Save and Recall: Can be used to save report parameters and recall options later.
• Format: Select format for output report. Defaults to PDF.
• Include Cash Account(s): Filter to only include transactions charged to a specific Cash Account(s). 
• Include Full Account Code(s): Filter to only include transactions charged to a specific detail Account Code(s). 
• Exclude Full Account Code(s): Filter to exclude transactions charged to a specific detail Account Code(s). 
• Include other Account Code Parameters: Filters to only include transactions charged to accounts meeting the entered parameters. Wildcards cannot be utilized in these fields. For more complex sort options, an account filter can be used.
• Filter: Select an account filter to include only transactions meeting those account parameters on the report.
• Total As of Period: The period specified will be used to determine the period the totals will be calculated for.
• Show Report Options: This option will include a cover page showing options chosen for generating the report.
• Summary Report: Produces a report containing only the header, footer, subtotal, and total information.
• Include only Active accounts?: Check to include only active accounts; leave unchecked to include both active and inactive.
• Exclude Accounts with zero amounts?: Check to include only accounts where all relevant MTD, YTD, and FYTD amounts are zero; leave unchecked to include all accounts.

In addition to the standard Report Parameter selection, this report also includes the ability to update the Sort Options. For more information on how to use these options, see the Reports Manager section for the Dynamic Sort - Sort Options. 

Image Modified

Snapshot of the report:

...

Anchor
Disbursement Detail Report Disbursement Detail Report

Disbursement Detail Report

A report listing disbursements (checks) which have been processed.  The report can produce a summary or a detailed report. The report can include various types of checks, including Accounts Payable, Refund and Payroll, and allows for various check statuses to be chosen (reconciled, voided or outstanding.)

• Save and Recall: Can be used to save report parameters and recall options later.
• Format: Select format for output report. Defaults to PDF.
• Show Options: This option will include a cover page showing options chosen for generating the report.
• Summary Report: Produces a report containing only the header, footer, subtotal, and total information.
• Select Disbursement Types:  Accounts Payable, Refund, and Payroll can be selected to be included in the report.
• Transaction Start & End Date: Will determine the date range for transactions included on the report.  By default, all are selected.
• Starting & Ending Check #:  A range of check numbers can be selected if desired.
• Disbursement Statuses:  Outstanding, Reconciled, and Void can be selected to be included in the report.  By default, all are selected.
• Vendor #(s):  Select a vendor number(s) if desired.
• Filter: Select an account filter to include only transactions meeting those account parameters on the report.

In addition to the standard Report Parameter selection, this report also includes the ability to update the Sort Options.  For more information on how to use these options, see the Reports Manager section for the Dynamic Sort - Sort Options. 

Snapshot of the report 

Anchor
findet findet

Financial Detail Report

A Detailed report of the transactions that make up the amounts in the cash accounts.  The report includes both receipt and expenditure data.   Allow users to enter a date range to generate the report. 

Image Modified

• Save and Recall: Can be used to save report parameters and recall options later

• Start & End Date: Required fields. Will determine the date range for transactions included on the report. 

...

Snapshot of the report with Initial Cash Balance:

Anchor
fundsumm fundsumm

Financial Summary by Fund Report

A summarized financial report using one print line for each cash balance record, sorted by Fund. This report contains the general fund accounts listed by function or object and the remaining accounts are listed by fund totals only. Displays Fund, Function, Description, Appropriation, Expended, % Expended, Encumbered, Balance. The July 1 Cash Balance, Total MTD receipts and Current Cash Balance (all funds) are displayed at the end of the report.

Image Modified

• Categorize Fund by: This option applies specifically to the General fund accounts. The General fund can be summarized by either Function or Object codes.
• Exclude Zero Amount Accounts: This option will exclude accounts where amounts in all columns would be zero.
• Show Report Options:This option will include a cover page showing options chosen for generating the report.
• Format: Select format for output report. Defaults to PDF.
• Submit: Generate Report

Snapshot Categorized by Function:

Image Modified

Snapshot Categorized by Object:

Image Modified

Anchor
Group Chain Report Group Chain Report

Group Chain Report

Detailed canned report showing the Group Chain and the Group Name(s) included in the Group Chain.

• Select and drag Available Group Chains from the left to right or leave blank to include all Chains not archived.   To deselect, drag from right to left.
• Checkmark  Image Modified to include Group Chains that have been archived.  

Sample Pdf

Anchor
podetl podetl

Purchase Order Detail Report

Detailed purchase order report containing information on individual purchase order items

• Save and Recall: Can be used to save report parameters and recall options later

• Status: User can use dropdown to select All, Invoiceable and Outstanding purchase orders to be reported.  
  • All - Includes all purchase order items
  • Invoiceable - Includes all purchase order items that are still invoiceable. (There is not a Full or Cancel_Full invoice associated with the line item.)
  • Outstanding - Includes all purchase order items that have remaining encumbrances based on the Current Posting Period.

• Amended: If True is selected, only Purchase Orders that have been Amended will be selected. If False is selected, only Purchase orders that have not been Amended will be selected. Leave blank to include all Purchase Orders.
• Starting/Ending Purchase Order #: Will determine the transaction number range for transactions included on the report.
• Transaction Start & End Date: Will determine the date range for transactions included on the report. 
• Created Start & End Date: Will determine the created date range for transactions included on the report.
• Vendor #(s): Enter a Vendor number or multiple Vendor numbers separated by a comma to select only Purchase Orders for a specific Vendor(s).
• Full Account Code(s): Filter to only include transactions charged to a specific detail Account Code(s)
• Fund Code - Filter for specific fund with ability to use % for wildcard.  (i.e. 5%%).
• Filter: Select an account filter to include only transactions meeting those account parameters on the report
• Report Format: Select format for output report. Defaults to PDF.
  • When using the Comma Separated Values, Excel-Data, or Excel-Fieldnames format the output will include additional columns for the Sortable Properties
    • Outstanding
    • Invoiceable
    • Item Description
    • Fund
    • Function
    • Function One Digit Level
    • Function Two Digit Level
    • Receipt
    • Receipt One Digit Level
    • Receipt Two Digit Level
    • Object
    • Object One Digit Level
    • SCC
    • Subject
    • Subject Two Digit Level
    • OPU
    • OPU One Digit Level
    • Job
    • IL
    • Forecast Line Number
• Show Options: This option will include a cover page showing options chosen for generating the report
• Summary Report: Produces a report containing only the header, footer, subtotal, and total information.

In addition to the standard Report Parameter selection, this report also includes the ability to update the Sort Options. For more information on how to use these options, see the Reports Manager section for the Dynamic Sort - Sort Options. 

Snapshot of report:

Anchor
venhire venhire

Vendor New Hire

The Vendor New Hire program allows for reporting of independent contractors to the Ohio New Hire reporting center.  Requirements and specifications can be found here: https://newhire-reporting.com/OH-Newhire/default.aspx.  The program will create a report listing all vendors with payments of at least $2,500.00 for the calendar year based off the reported date entered.  Vendors must have the "Report Status" field set to 'reportable' under the 'New Hire' section of the vendor record in order for the Vendor New Hire report to include them.  Other Vendor fields that may be filled in include:

...

The Requisition Approval Report will display the requisition audit trail for all requisitions that are currently in the Workflow Approval process based on the parameters the user chooses.

• Save and Recall: Can be used to save report parameters and recall options later
• Report Format: Select the format for report. The report defaults to PDF.
• Show Options: This option will include a cover page showing options chosen for generating the report.
• Select Actions: Select and drag the Actions available (Submitted, Approved, Rejected, Recalled, Cancelled) from left to right or leave blank to include all Actions.  To deselect, drag from right to left.
• Select Statuses:  Select and drag the Statuses available (InProgress, Approved, Rejected, Cancelled, Undefined) from left to right or leave blank to include all Statuses.   To deselect, drag from right to left. 
• Starting & Ending Requisition #:  A range of requisition numbers can be selected if desired.
• Select Users:   Select and drage available User from left to right or leave blank to include all Users.  To deselect, drag from right to left. 
• Generate: Generates the report.

...