Skip to main content

Viewing Funds Available

You can review funds available and compare encumbrances and expenditures with budgets. You can review functional currency budget, actual and encumbrance balances, and funds available for any detail or summary account. General Ledger calculates funds available by subtracting expenditures and encumbrances from budgets.
When you inquire on funds available, the amount type you specify determines how General Ledger calculates funds available.
Amount Type How the System Calculates Funds Available
Period-to-Date
Calculates funds available as the budgeted amount for the period, less actuals and encumbrances for the period.
Quarter-to-Date Extended
Calculates funds available as the budgeted amount to date for the quarter, less actuals and encumbrances to date for the quarter. For example, you budget $100 to an account for each of the three months in a quarter. The available amount for the second month of the quarter is $200.
Year-to-Date Extended
Calculates funds available as the budgeted amount to date for the year, less actuals and encumbrances to date for the year. For example, you budget $100 to an account for each of the 12 months. The available amount for the first half of the year is $600.
Project-to-Date
Calculates funds available as the budgeted amount to date, less actuals and encumbrances to date.
You can review the cumulative funds available total only by selecting Year-to-Date Extended (or Project-to-Date) as the amount type. For example, if you budget $100 for January, spend $50 and have $10 in encumbrances, the funds available for January is $40. If you view funds available for the amount type PTD for February, the February balances will not include the $40 available at the end of January. When you choose an amount type of YTDE, you can view cumulative amounts so the February balances will include the $40 available for January.
To view funds available:
1. Navigate to the Funds Available Inquiry window.
2. Enter the Budget Name for the inquiry. General Ledger defaults the current budget, if you have one.
3. Enter the Period Name for the inquiry.
General Ledger defaults to the first period for the current budget. General Ledger uses the period name along with the amount type to determine funds available.
4. Select an Amount Type.
5. Enter an Encumbrance Type. You can view all encumbrances types by entering ALL.
6. Do one of the following:
Choose the Find button to query all accounts that meet your selection criteria.
Navigate to the Funds Available region and query a partial or complete account.
General Ledger displays the functional Budget, Encumbrance and Actual Amounts for each account. The displayed amounts are the posted balances plus reserved funds. General Ledger displays debit balances as positive amounts and credit balances as negative amounts.
General Ledger automatically displays Funds Available as:
Budget Amount for Period Interval
Actual Amount for Period Interval
Encumbrance Amount for Period Interval
If you chose the encumbrance type ALL and you have budgetary control enabled and Purchasing installed, General Ledger displays the encumbered amounts for purchase order and requisition encumbrance types and all other encumbrance types in the Encumbrance Amount region.

Comments

Popular posts from this blog

Applying Prepayments to Invoices

You can apply the available amount of Item type distributions from a Temporary type prepayment to one or more invoices to offset the amount you pay on the invoice(s). If you entered the prepayment as a Permanent type and want to apply it, you can query the prepayment in the Invoices window and change the Prepayment Type to Temporary. If you use Automatic Offsets then your setting for the Prevent Prepayment Application Across Balancing Segments Payables option controls whether you can apply a prepayment to an invoice or expense report with a different balancing segment. Prerequisites The invoice type is Standard, Mixed, or Expense Report. Today's date is on or after the Settlement Date of the prepayment. The invoice date is on or after the date of the prepayment. The prepayment is type Temporary, fully paid, validated, not cancelled, has no active holds, and has not already been fully applied. The prepayment has the same supplier, invoice currency and payment currenc...

Application Utilities Lookups and Application Object Library Lookups

Maintain existing and define additional Lookups for your shared Lookup types. You can define up to 250 Lookups for each Lookup type. Each Lookup has a code and a meaning. For example, Lookup type YES_NO has a code Y with meaning Yes, and a code N with a meaning No. Note: In Releases 11.0 and earlier, there were two Lookup features, Special Lookups and Common Lookups. These two features have been merged into one. The new consolidated Lookups feature has Lookups maintained in this form. If you make changes to a Lookup, users must log out then log back on before your changes take effect. Lookups Block Type Query the type of your Lookup. You can define a maximum of 250 Lookups for a single type. User Name The user name is used by loader programs. Application Query the application associated with your Lookup type. Description If you use windows specialized for a particular Lookup type, the window uses this description in the window title. Access Level The access level restricts changes that...

About Bank Reconciliation

The diagram in this section provides an overview of the Cash Management process, from entering bank statements to posting accounting entries to your general ledger. There are two major process steps you need to follow when reconciling bank statements: 1. Load Bank Statements: You need to enter the detailed information from each bank statement, including bank account information, deposits received by the bank, and payments cleared. You can enter bank statements manually or load electronic statements that you receive directly from your bank. (See: Entering Bank Statements Manually and Loading Bank Statement Open Interface ) 2. Reconcile Bank Statements: Once you have entered detailed bank statement information into Cash Management, you must reconcile that information with your system transactions. Cash Management provides two methods of reconciliation: Automatic--Bank statement details are automatically matched and reconciled with system transactions. This method is ideally suited for b...