This report shows annual usage and dollar volume of stock items by current ABC groupings. It also details the stock item descriptions, issue units, and average unit cost. The ABC analysis report is useful in determining the most reasonable ABC grouping for a stock item according to annual usage and dollar volume.
The following form names should be used in Document Direct to locate this report:
This report provides management with a description of ABC classes currently in use. Each ABC details the following elements: forecast method, number of months back, reorder method, safety stock factor, EOQ order, and EOQ carry percent. These elements are defined in the ABC Classification Parameter (ABCP) table.
The following form names should be used in Document Direct to locate this report:
The Aged Open Payment Vouchers Report by Vendor and Payment Voucher (A651) report shows open payment vouchers by vendor and payment voucher and indicates how long it has been since the payment voucher was entered into the system. Aging is done in 30-day increments, from 0 to 120 days. The payment voucher amount, the cleared amount, and the outstanding amounts are all shown.
The following form names should be used in Document Direct to locate this report:
|
Aged Open Payment Vouchers Report by Vendor and Payment Voucher |
This report shows all the alternate views, their record counts, and whether the alternate view table is out of sync with its base table.
The following form names should be used in Document Direct to locate this report:
This report lists balance sheet account balances, by fund, account type and balance sheet class.
The following form names should be used in Document Direct to locate this report:
This report is a list of all transactions which affected bank account balances within the specified period of time. Transactions affecting balance sheet accounts with the cash-account indicator of Y are shown. The user supplies a from- and to-date range and the cash account desired.
The following form names should be used in Document Direct to locate this report:
This report shows voucher numbers of payment vouchers paid by the automated disbursement cycle, as well as Manual Warrants (MW) and Travel Checks (TC). This report also displays the amounts paid and check numbers used, including the numbers of voided checks. This report is part of the automated disbursement cycle, but it must be specifically requested.
The following form names should be used in Document Direct to locate this report:
The Collection Agency Performance Report is used to monitor a collection agency's performance in collecting delinquent receivables which have been assigned to them. Vendor number, vendor name, agreement number, amount assigned and amount collected are all listed. A percent collected is also calculated to use for comparison against other collection agencies.
The following form names should be used in Document Direct to locate this report:
This report shows a comprehensive balance sheet for all fund types and account groups. It groups balance sheet account balances under the balance sheet group or under the balance sheet category within a balance sheet group. Prior year totals are derived from the current year Balance Sheet open records. Page breaks are used to divide the report into nine parts:
The following form names should be used in Document Direct to locate this report:
|
Combined Balance Sheet Report - All Fund Types and Account Groups |
This report shows fund balance changes resulting from current year actual revenues, expenditures, and increase in fund balance direct for all fund types and expendable trust funds - by fund. Revenues are summarized by revenue group, expenditures by object group or by activity group within an object group. Fund balance at the beginning of the year and prior year totals are derived from the prior year Closed Year-To-Date Ledger (CLSYTD) records.
Amounts shown on report are rounded at summary level.
The following form names should be used in Document Direct to locate this report:
|
Combined Statement of Revenues, Expenditures, and Changes in Agency Liability/Fund Balance |
This report shows fund balance changes resulting from current year actual revenues, expenditures, and increase in fund balance direct for all fund types and expendable trust funds. Revenues are summarized by revenue group, expenditures by object group or by activity group within an object group. Fund balance at the beginning of the year and prior year totals are derived from the prior year Closed Year-To-Date Ledger (CLSYTD) records. A page break is used to divide the report into two parts: one shows all fund types (shown), and the other shows the totals.
Amounts shown on report are rounded at summary level.
The following form names should be used in Document Direct to locate this report:
|
Combined Statement of Revenues, Expenditures, and Changes in Fund Balance |
This report compares budgeted against actual revenues, and expenditures, and shows the difference between the two amounts. It covers general, special revenue, and capital projects fund types; the GAAP basis is used. Revenues are summarized by revenue group, expenditures by object group or by activity group within an object group. Fund balance at the beginning of the year is derived from the prior year Closed Year-To-Date Ledger (CLSYTD) records. Page break is used to divide the report into two parts: one shows the general and special revenue fund types, the other shows the capital projects fund type.
Amounts shown on report are rounded at summary level.
The following form names should be used in Document Direct to locate this report:
|
Combined Statement of Revenues, Expenditures, and Changes in Fund Balances -- Budget (GAAP Basis) and Actual |
This report shows fund balance changes resulting from current year actual revenues, expenditures, and increase in fund balance direct for all proprietary fund types and similar trust funds - by fund. Revenues are summarized by revenue group, expenditures by object group. Fund balance at the beginning of the year and prior year totals are derived from the prior year Closed Year-To-Date Ledger (CLSYTD) records. Amounts shown on report are rounded at summary level.
The following form names should be used in Document Direct to locate this report:
|
Combined Statement of Revenues, Expenditures, and Changes in Retained Earnings/Fund Balances |
This report shows fund balance changes resulting from current year actual revenues, expenditures, and increase in fund balance direct for all proprietary fund types and similar trust funds. Revenues are summarized by revenue group, expenditures by object category. Fund balance at the beginning of the year and prior year totals are derived from the prior year Closed Year-To-Date Ledger (CLSYTD) records.
Amounts shown on report are rounded at summary level.
The following form names should be used in Document Direct to locate this report:
|
Combined Statement of Revenues, Expenses, and Changes in Retained Earnings/Fund Balances |
This report shows a comprehensive balance sheet - by fund. It groups balance sheet account balances under the balance sheet group or under the balance sheet category within a balance sheet group. Prior year totals are derived from the current year Balance Sheet Opening Ledger (BSOPEN) records.
The following form names should be used in Document Direct to locate this report:
The Customer Credit Balance Report lists all REs with a credit balance (i.e. the outstanding balance is less than zero). This report lists the RE number as well as all referencing transactions which have affected the REs outstanding balance.
The following form names should be used in Document Direct to locate this report:
Produced during the memo billing and review billing processes. Lists depleted fund sources (identified by fund type, program/provider, and fund source) within agency and project.
The following form names should be used in Document Direct to locate this report:
The Detail Assigned to a Collection Agency Report provides detail information about receivables which have been assigned to a collection agency. Customer information, collection agency, receivable number, date assigned and outstanding balance are provided on the report.
The following form names should be used in Document Direct to locate this report:
This report is a detail listing of total encumbrances and expenses during both the current period and the fiscal year-to-date. The detail lines are totalled by organization, unit of appropriation, agency, and fund. Listed at the detail level are sub-organization, activity, object, sub-object, job number, and reporting category.
The following form names should be used in Document Direct to locate this report:
|
Detail Listing of Encumbrances vs. Expenses by Accounting Distribution |
This report is a detail listing by organization, activity, and object of obligations. Encumbrances, expenditures, and total obligations for both the current period (as specified in the dates parameters) and year-to-date are shown. The year-to-date column includes the current accounting period.
The following form names should be used in Document Direct to locate this report:
Each report is a detail listing of obligations against budget by fund, agency, object class, object code, and one of several organization cuts. Expenditures for the current period, year-to-date, and inception-to-date (for multi-year organizations) are shown along with current budgets and budget adjustments (from approved budget amounts) for each object. The outstanding pre-encumbrances, encumbrances, and unencumbered balance are also shown.
The AFINA104 program creates up to seven reports based on the organization levels maintained in the Organization (ORG2) table. These reports present obligation vs budget data sorted in the following sequences:
The following form names should be used in Document Direct to locate this report:
This report is a detail listing by revenue source of revenues recognized. Revenue recognized and cash collected for both the current period (as specified in the dates parameters) and fiscal year-to-date are shown at each revenue budget detail line. The year-to-date column includes the current accounting period.
The following form names should be used in Document Direct to locate this report:
This report shows a detail listing of transactions as they appear in the ledgers. Transactions are listed by batch date, batch number, and transaction number. By specifying FROM and TO dates as parameters for the report program, you can report on a single day, an accounting period, or multiple accounting periods (open periods). The miscellaneous parameter allows you to specify what type of transactions you want the report to contain.
The following form names should be used in Document Direct to locate this report:
This report provides a listing of imbalances between debits and credits on the general ledger and on the budget ledger. It balances ledger entries within accounting period, fund, and document ID. If a site is using summary ledgers rather than detailed ledgers, the SA1E report will balance within fund. Also note that if a site is posting summarized entries out of automated disbursements, AD documents will be summarized by fund, rather than document ID.
The following form names should be used in Document Direct to locate this report:
This report shows all fully disposed assets still on the Fixed Asset Summary Inquiry (FAS1) table as of the date the report is run.
The following form names should be used in Document Direct to locate this report:
This report is part of the Electronic Funds Prenote Process (EFPN) program. This process is used to notify the bank of the intention to begin using electronic funds transfers. The report shows the vendors selected for the pre-note process. The report reads through the EFTT table for new entries (status = N) and creates a file to be written to tape and then sent to the bank.
The EFT status on EFTT and VEND is changed to P and the Last Status Change date on EFTT is set to the current date. Once the bank tape is created, the bank has a pre-determined number of days to inform the user that his or her information is incorrect. This pre-determined number of days is found on SOPT as the number of prenote days. If the bank does not respond within the appropriate time frame, the EFPN process will approve the vendor for EFT (the EFT status on EFTT and VEND will be changed to A). The report does not show vendors that were approved for EFT (EFT status changed from P to A).
The following form names should be used in Document Direct to locate this report:
These reports are part of the automated disbursement cycle before and after disbursement. They show outstanding payment vouchers that are not on hold whose scheduled payment date, fund, and bank account satisfy the requested parameters. The reports show payment voucher line detail and totals by vendor. Credit memos are taken into account in the vendor total. Discounts are not calculated or considered for these reports.
The following form names should be used in Document Direct to locate this report:
This report is issued during the run of EFCG. It reports a list of transactions created for the EFTTAPE ledger.
The following form names should be used in Document Direct to locate this report:
These reports show all outstanding payment vouchers that are on hold and those whose scheduled payment date, fund, and bank account do not satisfy the requested parameters. In other words, these reports will show all outstanding vouchers that do not appear on the EF01A and EF01B reports before and after disbursement. Closed vouchers do not appear on any of these reports.
The following form names should be used in Document Direct to locate this report:
This report shows voucher numbers of vouchers transferred by the electronic funds transfer cycle. This report also displays the amounts paid and transaction numbers used, including the numbers of voided transactions. This report is part of the automated disbursement cycle, but it must be specifically requested.
The following form names should be used in Document Direct to locate this report: