[ BEN Financials ]
306.BUD: Negative BBA CNAC/ORG/FUND/CREF PJTD
Documentation :|: BEN Balances Report Documentation :|: Quick View
* Return to Quick View List
Last Updated: 10/18/99
The 306.BUD report provides a listing of
all of the account combinations within a given CNAC that have a
budgetary control of 4' (funds checking on a
project-to-date basis at the ORG/FUND/CREF level) and that have a
negative budget balance available (BBA) as of the specified
accounting period. The accounts on this report are for the
unrestricted net asset class only (NAC = 0'). The purpose
of the report is to identify those accounts that are failing
funds checking so that the appropriate corrective action can be
Options are provided to allow users to list
the accounts by ORG or to list accounts in descending order by
the negative BBA amount (that is, highest negative BBA to lowest
The report break determines the page break
and the first level sort for this report. Report 306.BUD breaks at CNAC (Center Net
Asset Class). A new page will be created for each unique CNAC
The report break is the first level of
sort; in this case, CNAC is the report break. Within CNAC, the 306.BUD offers two
different sorts depending on the report selection option
specified. When the report selection option is 1', the
report lists accounts first by ORG. Within each ORG, accounts are
listed by FUND and, within FUND, by CREF value. When the report
selection option is 2', the report lists accounts in
descending order by the negative BBA amount (that is, the highest
negative BBA amount to the lowest negative BBA amount). If more
than one account has the same negative BBA amount, the accounts
are sorted by ORG, then FUND, and finally, CREF.
No report template is used for this report.
However, the balances that appear on this report are calculated
based on the object codes in the TEXP summary template plus
overhead (object codes 5282 and 5292). This calculation Excludes
In addition to the Accounting Period, the
following parameters are provided for account selection on the
- Report Selection
- CNAC Low/High
- ORG Low/High
- Fund Low/High
- CREF Low/High
The last four parameters work just like
they do for other General Ledger Reports (see Section 6, Report
Parameters). The following provides information on the additional
parameter (Report Selection) used in this report.
Report Selection - Valid choices are 1' or 2'
- This option will produce a report sorted by CREF within FUND within ORG
- This option will produce a report sorted by the negative BBA amount (highest to lowest),
then CREF within FUND within ORG.
The report heading includes the following
- Report Break: CNAC
Indicates the report break variable for this report. In the 306.BUD report, CNAC is the report break variable.
- For Month Of:
Indicates the accounting period through which balances are provided. Accounting period is provided as
a parameter when the report is requested.
The CNAC value and name are listed.
- BC: 4
Indicates the BC value, and therefore the level of funds checking, used for accounts listed on this
report. In the 306.BUD report, all accounts listed use a BC value of 4', which defines funds checking at the
ORG/FUND/CREF level on a project-to-date basis.
- Report Selection:
Indicates the report selection option specified for this report.
From left to right, the report columns
provide the following information.
This column provides the numeric code for the ORG in the account combination being reported.
- ORG Description:
This column provides the name of the ORG referenced in column one.
FRZ: This column displays a single character to indicate the freeze status
of the fund.
|N = Not Frozen
||NONE of the transaction sources are currently frozen for this
|P = Partially Frozen
||At least one, but not all of the transaction sources are
currently frozen for this grant.
|F = Fully Frozen
||All of the transaction sources are currently frozen for this
|D = Fund Disabled
||The fund is disabled; its freeze status is irrelevant.
This column provides the FUND number for the FUND in the account combination being reported.
- FUND Description:
This column provides the name of the FUND referenced in column three.
This column provides the CREF numeric value in the account combination being reported.
- CREF Description:
This column provides the description associated with the CREF value referenced in column 5.
Special Note: in the following
columns, balance information is calculated using the object codes
in the TEXP summary template plus overhead expense (object codes
5282 and 5292). Expense credits (object codes 55xx) are excluded.
For the same account and accounting period, the totals in these
columns should match the totals on the Total Expenditures line of
the 103.ORG report, adjusted for expense credits.
- PJTD Budget:
The total project-to-date operating budget for this ORG/FUND/CREF combination as of the specified accounting period.
- PJTD Actual:
The total project-to-date actual expenditures for this ORG/FUND/CREF combination as of the specified accounting
- PJTD Encumbrance:
The total project-to-date outstanding encumbrances for this ORG/FUND/CREF combination as of the specified accounting
- Budget Balance Available:
The total project-to-date budget balance available for this ORG/FUND/CREF combination as of the specified accounting
period. The budget balance available is calculated as:
PJTD Budget less (PJTD Actual + PJTD Encumbrance)
Last Page Of The Report:
On the last page of every report, two
pieces of important information are provided: Report Parameters
and Report Break - Resolved Parameters.
- Report Parameters
The parameters used to request the report are printed on the last page as confirmation of what
was requested. If the account combinations returned to you in the report are not what you expected, the report parameters
list is a useful first place to start. At a minimum, you can verify the range of values you provided at the time you
submitted the report.
- Report Break - Resolved Parameters
The list provided here presents the list of values within the range you provided as Report
Parameters that passed security verification. When a report is submitted, ORGanization parameters that were provided are
compared against your security profile. All ORGanizations in the range that match your profile will be returned to you in
This is a good place to look if you did not get the results you expected. Compare the list of
ORGanizations in this list against the parameter range you provided. If an ORGanization is missing, chances are it does
not exist in your security profile.