...
The default date range is the current posting period. The report can be run to include any posting period in the fiscal year ; however, the posting period(s) included in the date range must be created under Core. The Start/End Date fields currently select transactions by posting period so if a date within a period is selected, then all transactions related to that posting period will be included on the report.
Info |
---|
Example If the Start/Stop dates entered are 3/15/2021 to 4/15/2021 all qualifying transactions from the March 2021 and April 2021 posting periods will be included (3/1/2021 - 4/30/2021). |
...
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.
Objects to be Audited | Included Target Types |
---|---|
Purchase Order | PurchaseOrder, PurchaseOrderItem, and PurchaseOrderCharge |
Invoice | Invoice, InvoicePOItem, and Source |
Fund | AccountMapping |
CashAccount | CashTransaction |
Appropriation | |
ExpenditureAccount | ExpenditureAccountHistory |
RevnueAccount | RevenueAccountHistory |
BankAccount | |
DeliveryAddress | |
Opu | |
Organization | |
PostingPeriod | |
Project | |
Vendor | VendorLocation, MergedVendor |
ActivityLedger | |
Invoice | InvocieItem and InvoicePOItem |
Disbursement | DisbursementItem, DisbursementRefundItem, DisbursementInvoiceItem, DisbursmentExpenditureItem,BankTransaction |
Distribution | |
PurchaseOrder | PurchaseOrderItem, PurchaseOrderCharge |
Receipt | ReceiptIem |
Refund | RefundItem |
Requisition | RequisitionItem, RequisitionCharge, FileStore |
Building | |
CashReconciliation | CashRecItem |
CivilProceeding | |
FederalAssistanceDetail | |
FederalAssistanceSummary | |
CustomFieldDefinition | |
Role | Permission |
User | |
Budget | BudgetTransaction |
AnticipatedRevenue | AnticiaptedRevenueTransaction |
...
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.
...
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.
...
Save and Recall: Can be used to save report parameters and recall options later
Info |
---|
Report Link The Report Direct Link is available for this report and can be utilized to generate a Financial Detail Spreadsheet with a Running Fund Balance. Format Type HTML-Table should be used for this option. For a walkthrough of how to create the Financial Detail Spreadsheet with Running Fund Balance, please click here. |
Start & End Date: Required fields. Will determine the date range for transactions included on the report.
Info |
---|
Date Range Selected If the Start/End Dates are consistent with the Current Fiscal Year, the Beginning Cash Balance will be included on the report. When generated for custom date ranges (ex. Monthly) the report will not include the Initial Cash Balance. To run a report for a previous Fiscal Year with the Initial Balance, the Current Period should be changed to a period within that fiscal year. |
...
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 to include Group Chains that have been archived.
Sample PdfPDF
...
...
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
Info |
---|
Report Link The Report Direct Link is available for this report and can be utilized to generate a spreadsheet that can be refreshed in Excel. Format Type HTML-Table should be used for this option. For a walkthrough of how to use the Report link that uses the Financial Detail Spreadsheet with Running Fund Balance as an example, please click here. |
...
Reported Date:This date is populated on the vendor's 'Last Reported Date' field when the actual option runs
Projection Report: When checked, it will generate the report but it does not update the 'reported' flag or 'last reported date' fields on the vendor record
Calculate date payments begin (if blank): When checked, it will calculate the date payments began using the payment information from the current calendar year's disbursements. It will not auto populate the beginning payment date on the vendor's 'begin date' field. If unchecked, it will look for the 'begin date' field on the vendor record. If blank, it will generate an error on the report.
Available Vendors, Force Vendors to be included and Remove Selected: From 'Available Vendors', you may select a particular vendor you want included on the report in order to force the vendor to be included on the report Use the 'remove selected' to remove any from the list. After you have selected all vendors to be included, check the 'Force Vendors' box in order to include them on the report.
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.
Generate Report: Generates a current version of the report.
...
Revenues and Expenditures Report
...