Oracle Cash Management enables you to perform online inquiries to review bank account information, bank transfers, cashflow, balances and interest rate schedules, monitor reconciliation status, research payments and receipts, and view cash forecasting amounts. There are several inquiry windows in Cash Management:
View Bank Statement Reconciliation window: Use this window to review statement reconciliations, details, and status. You can also access these other inquiry windows from View Bank Statement Reconciliation window:
View Available Transactions window: Use this window to find and view transactions that are available to be reconciled with bank statement lines.
View Bank Account Transfer window: Use this window to find and view the status of a bank account transfer.
View Cashflow window: Use this window to find and view cashflow information.
View Bank Account Balances window: Use this window to find and view bank account balance information.
View Interest Rate Schedule window: Use this window to find and view interest rate schedule details.
View Bank Information window: Use this window to view bank information, bank addresses, and bank contacts.
View Bank Accounts window: Use this window to view account owner and use information, account information, account controls, cash management controls, reconciliation controls, foreign bank currency details, open interface controls, and manual reconciliation tolerances.
Payments window: Use this window to review details of payments that are available for reconciliation. You can also find out the bank statement that a payment is reconciled to.
Receipts window: Use this window to review details of receipts that are available for reconciliation. You can also find out the bank statement that a receipt is reconciled to.
Related Topics
Viewing Bank Statement Reconciliation
Viewing Available Transactions
You can use View Bank Statement Reconciliation window to review statement reconciliations, details, and status. You can also access other inquiry windows from View Bank Statement Reconciliation window. You cannot change the information in a bank statement or reconciliation.
Have bank statements entered and/or reconciled in Cash Management.
Navigate to the Find Bank Statements window. From the Navigator, choose View > Bank Statements.
Enter the criteria for the statement you want to query or leave the criteria blank to see a list of all existing statements.
Choose Find to open the View Bank Statement Reconciliation window containing the statements that meet your query criteria.
Select the statement you want to review, then choose Review. The View Bank Statement window appears.
Cash Management displays the header information for the statement you queried. You can view Bank Name, Bank Branch, Statement Date, Bank Currency, Document Number, Statement Number, and GL Date. You also see Control and Line Totals for the statement and the corresponding reconciliation. Also, the number of lines and total amount are displayed for any statement lines that remain unreconciled. Finally, there is a Complete check box indicating whether the statement reconciliation has been completed.
You can also navigate to Errors, Reversals, Reconciled, Available, and Lines inquiry windows from the View Bank Statement window.
Errors: The View Reconciliation Errors window appears.
Reversals: The Find Reversals window appears.
Reconciled: The View Reconciled Transactions window appears.
Available: The Find Available Transactions window appears, or the View Available Batches window appears, depending on your selection criteria.
Lines button: The View Bank Statement Lines window appears.
Query the bank statement you want to review.
Choose Lines from the View Bank Statement window. The View Bank Statement Lines window appears, showing the statement lines, Transaction Type, Bank Transaction Code, Transaction Number, Date Cleared, Amount, Amount Reconciled, Charges and Status.
In the Exchange tabbed region, view exchange rate information for foreign currency transactions.
In the Reference tabbed region, view the Agent (supplier or customer), Agent Bank Account and Invoice number associated with each transaction.
In the Description tabbed region, view the Effective Date and Description of the transaction, as well as any associated Bank Charges.
You can also navigate to Errors, Reversals, Reconciled, and Available inquiry windows from the View Bank Statement window.
Query the bank statement you want to review.
Choose Reconciled from the View Bank Statement window or the View Bank Statement Lines window. The View Reconciled Transactions window appears, showing the reconciled transaction lines. For each line you can view Transaction Type and Number, Original Currency and Amount, Bank Account Currency Amount and Amount Cleared, Transaction Date, Value Date, GL Date, and Cleared Date.
At the bottom of the window, you can see two fields showing the Status and Maturity Date for the selected transaction line.
In the Exchange tabbed region, view the Exchange Date, Type, and Rate, as well as the Bank Account Currency Charges and Errors.
In the Reference tabbed region, view the Batch Name, Agent Name, Deposit Number, Reference Type and Number.
Choose Next to move to the next record, if any, or choose Previous to move to the previous record, if any.
Query the bank statement you want to review.
Choose Reversals from the View Bank Statement window. The Find Reversals window appears.
Enter any query values for Receipt or Check Number, Amount, Currency, and Date. You can also search for receipts and payments based on the Payment Method, Status, Account Number, and Account Currency Amount. Also, you can enter Agent information to further narrow your search for a specific customer or supplier Name and Number.
Choose Find. The View Reversals window appears, showing the transactions that meet your search criteria. For each line you can view Transaction Type and Number, Original Currency and Amount, Bank Account Currency Amount and Amount Cleared, Transaction Date, Value Date, GL Date, and Cleared Date.
At the bottom of the window, you can see two fields showing the Status and Maturity Date for the selected transaction line.
In the Reference tabbed region, view the Batch Name, Agent Name, Deposit Number, and Payment Method.
In the Comment tabbed region, view the Reversal Category, Reason, and Comments.
In the Bank tabbed region, view the Bank Account Number, Currency, and Name, as well as the Statement Number.
Query the bank statement you want to review.
Choose Errors from the View Bank Statement window or View Bank Statement Lines window. The View Reconciliation Errors window appears, showing the Account, Bank Name, Currency, and Statement Date. The window also shows the Line Number and Message for each reconciliation error.
Related Topics
Entering Bank Statements Manually
Reconciling Bank Statements Manually
Reviewing Reconciled Transactions
Reviewing Reconciliation Errors
You can use View Available Transactions window to review those Payables and Receivables transactions that are available for reconciliation. You can also review any Oracle General Ledger journal entries that are available for reconciliation.
The window only lists void payments if the Show Void Payments option on the Systems Parameters window is checked. It does not list reversed receipts due to user error nor does it list the associated original receipts that were not reconciled.
You can access the View Available Transactions window from the Navigator, the View Bank Statement window, or the View Bank Statement Lines window.
Note: You cannot reconcile available transactions or journal entries from the View Available Transactions window.
Have bank statements entered and/or reconciled in Cash Management.
Navigate to the Find Available window.
Choose Detail from the Detail/Batch/Open region, then select one or more transaction types to find detail transactions that match your criteria. You may select to view Receipt, Payment, Miscellaneous transactions, Journal, and Statement Line.
Edit the default sort criteria in the Ordering tabbed region of the window. The sort criteria you select determines how the resulting transactions are displayed in the View Available Transactions window.
Use the Primary poplist to select your primary sort category and the Secondary poplist to select your secondary sort category. The sort categories are transaction Type, Ttransaction Number, Date, and Amount.
Use the primary order poplist to select a sort order for the primary sort category. Use the secondary order poplist to select a sort order for the secondary category. The options are Ascending or Descending.
Select the Bank tabbed region.
Cash Management displays some additional fields where you can enter the bank Account Number, Account Name, and Bank Name. The Branch Name and Currency Code fields are display only.
(Optional) Refine or focus your search further by selecting the following tabbed regions:
Transaction: Cash Management displays some additional fields where you can enter ranges of transaction Numbers, Dates, Amounts, Maturity Dates, Batch Names, and Remittance Numbers to find only transactions within those ranges. You can also choose to find only those transactions with a specific Currency Code.
Agent: Cash Management displays some additional fields where you can enter a Customer Name and Customer Number to use when finding Receivables transactions. You can also enter a Supplier Name and Supplier Number to use when finding Payables transactions.
Receipt: Cash Management displays some additional fields where you can enter a Reference Type, Reference Number, Receipt Class, Payment Method, and Deposit Dates to use when finding miscellaneous transactions. Some fields are only available if you select Receipts or Miscellaneous in step 2 above.
Journal: Cash Management displays some additional fields where you can enter a Period Name, Journal Entry Name, Document Number, or Line Number to use when finding journal entries.
Choose Find to find all transactions that match your search criteria. The View Available Transactions window appears, showing the available transaction lines. For each transaction you can view the transaction Type and Number, Original Currency and Amount, Bank Account Currency Amount and Amount Cleared, Transaction Date, Value Date, GL Date, and Cleared Date.
At the bottom of the window, you can see two fields showing the Status and Maturity Date for the selected transaction line.
In the Exchange tabbed region, view the Exchange Date, Type, and Rate, as well as the Bank Account Currency Charges and Errors.
In the Reference tabbed region, view the Batch Name, Agent Name, Deposit Number, and Reference Type and Number.
Navigate to the Find Available window.
Choose Batch from the Detail/Batch/Open region, then select Remittance and/or Payment to find batches that match your criteria.
Edit the default sort criteria in the Ordering tabbed region of the window. The sort criteria you select determines how the resulting transactions are displayed in the View Available Transactions window.
Select the Bank tabbed region.
Enter your Bank Account information or select one from the available list of values.
(Optional) Refine or focus your search further by selecting the Transaction tabbed region. You can enter transaction Dates, Amounts, Batch Names, Remittance Numbers, or the Currency Code to search for.
Note: You cannot enter search criteria for the Agent, Miscellaneous, or Journal tabbed regions.
Choose Find to find all batches that match your search criteria. The View Available Batches window appears, showing the available batch lines. For each line you can view Batch Name, Original Currency and Total, bank Account Currency Total, Amount Cleared, Transaction Date, Value Date, GL Date, and Cleared Date.
At the bottom of the window, you can see two fields showing the batch Type, and the Remittance Number for the selected batch line.
In the Exchange tabbed region, view the Exchange Date, Type, and Rate, as well as the bank Account Currency Charges and Errors.
Select Available from the related window. The Find Available window appears.
Complete your search criteria for transactions or batches as described in the previous two tasks.
Note: You do not need to select a bank since you will have already done this from the View Bank Statement Reconciliation window.
Choose Find to perform your search. Refer to the previous two tasks for the steps to follow when reviewing the results of your search.
Navigate to the Find Available window.
Choose Open Interface from the Detail/Batch/Open region, then select Receipts and/or Payments to find open interface transactions that match your criteria.
The Open Interface option appears only if you have checked the Use Reconciliation Open Interface check box in the System Parameters window.
(Optional) Refine or focus your search further by selecting the Transaction tabbed region. You can enter transaction Dates, Amounts, Batch Names, Remittance Numbers, or the Currency Code to search for. You can also enter sort criteria, which determines how the resulting transactions are displayed in the Available Transactions window.
Choose Find to perform your search.
Related Topics
Reconciling Bank Statements Manually
Finding Available Transactions, Batches, and Journal Entries for Reconciliation
Reconciling Available Transactions, Batches, and Journal Entries
Creating Miscellaneous Transactions
You can use this window to find out the status of a bank account transfer.
Navigate to the View > Bank Account Transfers page.
Enter search criteria and click Go.
The bank account transfer status can be one of the following:
New: The transfer has been created but not validated yet.
Validated: The transfer has been created and validated. It is ready to be manually authorized for settlement.
Invalid: The transfer has failed validation.
Rejected: The transfer is rejected by the user who is performing manual authorization.
Settlement in Process: The transfer has been authorized for settlement and sent to Oracle Payments.
Settled: The transfer was successfully processed by Oracle Payments or it did not require settlement through Oracle Payments.
Failed: The transfer failed processing in Oracle Payments.
Canceled: The transfer has been manually canceled by the user.
You can use this window to find out cashflow details.
Navigate to Cashflows window. From the navigator, choose View > Cashflows.
Enter the criteria for the cashflows you want to query. Fill in at least one of following fields:
Cashflow Number
Bank Account Number
Cashflow Amount
Transaction Type
Direction
Bank Reference Number
Legal Entity
Cashflow Date
Cashflow Status
Click Go.
You can use the Bank Account Balance window to review the details of your balances.
Navigate to the View > Bank Account Balance page.
If you do not have any personalized views created, you will be taken to the Advanced Search page. In this case, enter the search criteria and click Go. The bank account balances will be displayed using the system default layout. If you already have at least one view created, you will be taken to the Views page. In this case, select a view name from the list and click Go. The bank account balances will be displayed using your personal layout.
You can use the Interest Rate Schedule window to review the details of your interest rates.
Navigate to the View > Interest Rate Schedules page.
Optionally, enter a part of the Interest Rate Schedule name in the Search region.
Click Go.
Click the name of the Interest Rate Schedule to view the details.
You can use the Banks window to review the details of general bank information, address information, and bank contact access.
Navigate to the View > Banks page.
Perform a search using one of the following search options:
Bank Name
Alternate Bank Name
Short Bank Name
Bank Number
Country
The following Bank Information can be viewed or edited:
Country: The name of the country where the bank is located.
Description: Description of the bank, for example, International Bank Partner
Institution Type: Description of the kind of organization, for example, credit union.
Bank Name: The name of the bank.
Alternate Bank Name: The alternate name for your bank. The system does not use the value. It is for your reference only.
Taxpayer ID: Tax identification number for example, an individual's social security number, or a corporation or partnership's federal identification number/federal tax ID.
Short Bank Name: This may be an alpha or a numeric reference.
Bank Number: Identification number of the bank. Payables uses this information to identify the bank in payment formats that use electronic payment methods. The combination of Bank Number, Branch Number, and Country must be unique.
XML Messages Email: Email address for your contact at the bank.
Inactive Date: Date after which an expense report template can no longer be used when entering expense reports.
View Bank Address region information.
Address: The mailing address for the bank.
Country: The name of the country where the bank is located.
Identifying: In many countries a fiscal code is the principal means of identifying and querying suppliers. The fiscal code is unique across all entities and appears on all official documentation.
View Bank Contact details.
Name: Name of your contact person.
Phone: Direct number to your bank contact.
Email: Email address for your contact at the bank.
Address: The mailing address for your contact.
You can use the Bank Accounts window to review the details of account owner and use, general account information, account controls, cash management controls, reconciliation controls, foreign bank currency details, open interface controls, and manual reconciliation tolerances.
Navigate to the View > Bank Accounts page.
Perform a search using one of the following search options:
Account Name
Alternate Account Name
Short Account Name
Account Number
Account Owner
Currency
Bank Name
Branch Name
View Account Owner and Use region.
Bank Account Owner: The name of the source account holder.
Account Use: Select the checkboxes that apply to your account: Payables, Payroll, Receivables, Treasury.
View Account Information region.
Account Name: The name you used to refer to the bank account.
Alternate Account Name: The alternate name for your bank account. You can enter an alternate name for your bank account. This is particularly useful if you do business in Japan so you can enter both Kanji and Kana values for your bank account name. The system does not use the value you enter here unless you enable the Sort by Alternate Fields Payables option. If you enable that option then Payables uses the alternate name when it sorts reports by bank account name.
Short Account Name: This may be an alpha or a numeric reference.
Account Number: The bank account identification number. The combination of Bank Account Number, Bank Branch Number, Account Use, and Currency must be unique for each bank. Refer to your country-specific documentation on validation that the system performs on the bank account number for specific countries.
Check Digit: The value used to validate the authenticity of your bank account number according to country specific bank account validation requirements. This value is provided by your financial institution.
Currency: Currency for a bank account. The default value is your ledger currency.
Multiple Currencies Allowed: If you selected a different currency than your ledger currency in this field, when you define Payables Payment Documents, you will only be able to select payment formats that you define in that currency. Also, you will only be able to pay invoices that you enter in this foreign currency.
IBAN: International Bank Account Number.
Account Type: Bank account type. For example, Controlled Disbursement for your internal bank account or Checking for a supplier or customer bank account.
Account Type: Bank account type. For example, Controlled Disbursement for your internal bank account or Checking for a supplier or customer bank account.
EFT Number: Your enterprise's EFT (electronic funds transfer) user number.
Account Suffix: An identifier for your bank.
Account Holder: Name of the person or organization within your organization who is responsible for this account.
Secondary Account Reference: Additional account reference.
Description: Description of the Bank Account.
Alternate Account Holder: The alternate name for your bank account holder.
Start Date: The start date entered if you wanted to limit the time during which a supplier site uses this bank account as the primary bank account for receiving electronic payments in the bank account currency.
Treasury Bank Account Number Reference: If your enterprise is a United States federal agency then you define the bank account number reference for a branch of the United States Treasury bank.
End Date: The end date entered if you wanted to limit the time during which a supplier site uses this bank account as the primary bank account for receiving electronic payments in the bank account currency.
View General Controls region.
Cash: The cash account number.
Cash Clearing: The cash clearing account number.
Bank Charges:The bank charges account number.
Bank Errors: The bank errors account number.
Foreign Exchange Charges: The foreign exchange charges account number.
Agency Location Code: If your enterprise is a United States federal agency then you entered an Agency Location Code.
Netting Account: Display if the Netting Account is there or not.
View Cash Management Controls region.
Minimum Target Balance: The minimum target balance for bank accounts.
Maximum Target Balance: The maximum target balance for bank accounts.
Minimum Payment Amount: Option to pay the minimum payment available.
Minimum Receipt Amount: This is the minimum amount in this currency that must be specified when you created automatic receipts with this payment method.
Rounding Factor: Indicates the way amounts are displayed. Options are selected from the LOV.
Rounding Rule: Round Up, Round Down, or Nearest.
Cash Flow Display Order: Details cash receipts minus cash disbursements from a given operation or asset for a given period.
View Payables region.
Multiple Currency Payments: Transaction or Batch.
Allow Zero Payments: Error or Ignore.
Pooled Account: Transaction or Batch.
View Reconciliation Controls region.
Payables Matching Order: Transaction or Batch.
Float Handling: Error or Ignore.
Receivables Matching Order: Transaction or Batch.
View Foreign Currency Bank region.
Exchange Rate Type: AutoReconciliation selected the exchange rates for the transaction currency using the Exchange Rate Type you specified.
Exchange Rate Date: AutoReconciliation selected the exchange rates for the transaction currency using the date source you specified.
Options for exchange rate dates include:
Bank Statement GL Date: The accounting date used to clear the statement.
Bank Statement Date: The closing date of the statement.
Statement Line Date: The date the transaction cleared the bank.
Transaction Creation Date: The date the transaction was created.
Transaction Creation GL Date: The accounting date used to create the transaction.
Transaction Exchange Rate Date: The date associated with the exchange rate that was used to create the transaction.
View Open Interface Controls region.
Use Reconciliation Open Interfaces: The checkbox is enabled if you use this feature.
Open Interface Matching Criteria: The default is Transaction Number. To reconcile bank statement lines to Treasury settlements, select the Date and Amount option.
Float Status: Status of open interface transactions that are available for clearing and reconciliation.
Clear Status: Status of open interface transactions that have cleared or reconciled.
View Manual Reconciliation Tolerances region.
Tolerance Amount: Reconciliation tolerances that were entered as an amount.
Tolerance Percentage: Reconciliation tolerances that were entered as a percentage.
View Account Access region.
Organization: The checkboxes selected apply to your account: Payables, Payroll, Receivables, Treasury, End Date, Access, Options.
View Account Contact
Name: Name of your contact person.
Phone: Direct number to your bank contact.
Email: Email address for your contact at the bank.
Address: The mailing address for your contact.
You can use the Payments window to review the details of transactions in Oracle Payables that are available for reconciliation. You can use the Receipts window to review the details of transactions in Oracle Receivables that are available for reconciliation. You can also use these two windows to find out the bank statement that a payment or receipt is reconciled to.
Navigate to the Payments window.
Query the payments you want to review.
If a payment is reconciled, scroll to the Statement Num and Statement Line Num field to find information on the bank statement.
Navigate to the Receipts window.
Query the receipts you want to review.
If a receipt is reconciled, choose the Cash Management tab to find information on the bank statement.
Cash Management provides several reports to help you review and analyze your cash management activities.
You can run the following Cash Management reports from the Submit Request window:
To submit a standard request or request set from the Submit Request window:
Navigate to the Submit a New Request window.
Choose either Request or Request Set. Choose OK to open the Submit Requests window.
Enter the name of the request or request set that you want to submit.
If the request or request set has parameters, enter the parameters in the Parameters window. Choose OK to save the parameters.
If your request has parameters, you can see detailed information on the parameters in the Selected Report Parameters section of the request description, or in Common Report Parameters. See: Common Report Parameters.
Choose Submit to submit your request. You can review the status of your request in the Concurrent Requests Summary or the Requests window.
If your request has output, you can see detailed information on it in the Selected Report Headings section of the request description, or in the Common Report Headings help document. See: Common Report Headings.
In the Concurrent Requests Summary, query the concurrent request number for your request. Select your request. Choose Cancel Request. See also: Options for Requests in Progress, Oracle Applications User's Guide.
You can view the status of your concurrent request in the Requests window by choosing View My Requests from the Help Menu. See also: Monitoring Requests, Oracle Applications User's Guide.
From the Submit Request window, you can submit a single request, or you can submit a request set to run several reports as a group. See also: Running Reports and Programs, Oracle Applications User's Guide.
Related Topics
Running Reports and Programs, Oracle Applications User's Guide
These report parameters are common to many Cash Management reports:
Bank Account Number: Select an account or leave blank to run the report for all accounts at the bank branch.
Bank Branch Name: Select the bank branch name for which the report will be produced.
Statement Date: Enter the date of the statement lines that you want to include in the report.
Statement Date From/To: Enter a range of dates to see information only for statement lines that fall within those dates.
Statement Number From/To: Enter a range of statement numbers to include in the report.
Report headings at the top of each page provide you with general information about the contents of your report or listing, such as your ledger name, report title, date and time when Cash Management runs your report, and page number.
In addition, Cash Management prints the parameters you specified when you submitted the report request.
The following are report headings common to many Cash Management reports:
Bank Account Currency: Currency for a bank account.
Bank Account Name: Name of the bank account.
Bank Account Number: Bank account identification number.
Bank Branch Name: Name of the bank branch.
Bank Name: Name of the bank.
When you generate a cash forecast, Cash Management automatically produces the Cash Forecast Execution Report. If the cash forecast completes successfully, Cash Management also automatically produces the Cash Forecast report.
You can review the Cash Forecast Execution Report to determine if any errors occurred when you ran the Submit Forecast program.
Cash Management provides the following cash forecasting reports:
The Cash Forecast Report lets you view the cash forecast data that you can see in the Cash Forecast Results page online.
If you submit this report using Oracle Report eXchange you can export your cash forecast data to the spreadsheet application of your choice. You can also print the Cash Forecast Report to review your forecasts instead of viewing them online.
Cash Management automatically produces this report when you generate a cash forecast using the Run Forecast icon in the Forecast Templates Search and Results page or the Forecasts Search and Results page or when you are using the Submit Request window, and that forecast completes successfully. You can also print this report at a later time using the Submit Request window. See: Submitting Requests.
Template Name:Enter the template name of the cash forecast that you want to produce.
Forecast Name:Enter the name of the cash forecast that you want to produce.
Status: The status of the forecast execution, such as success, warning, or error.
Calendar Name: The name of the General Ledger accounting calendar. Applicable only for forecasts by General Ledger period.
Start Date: For forecasts by days, the earliest date of information that is included in the forecast.
Start Period: For forecasts by General Ledger period, the earliest period of information that is included in the forecast.
Project Number: For forecasts of projects, the project number associated with the forecast.
Project Name: For forecasts of projects, the project name associated with the forecast.
Forecast Currency: The currency of the amounts that appear in the forecast.
Source Currency Type: Determines if source transactions are selected by currency:
All - All transactions are included.
Entered - Transactions entered in the source currency are included.
Ledger - Transactions where the source currency is the same as the ledger currency are included.
Source Currency: The currency of the source transactions included in the forecast.
Exchange Type: The exchange rate type, as defined in Oracle General Ledger.
Exchange Date: The exchange date, as defined in Oracle General Ledger.
Amount Threshold: The minimum amount of an individual transaction in order for it to be included in the forecast.
Cash Inflow: The total amount of cash received during the forecast period.
Cash Outflow: The total amount of cash spent during the forecast period.
Net Cash: The difference between the cash inflow and cash outflow for the forecast period.
This report includes information on any errors that the Submit Forecast program produced when you submitted a cash forecast to be generated.
Cash Management automatically generates this report when you submit a forecast using the Run Forecast icon in the Forecast Templates Search and Results page or the Forecasts Search and Results page, or when you are using the Submit Request window to submit a forecast. You can also print this report at a later time using the Submit Request window. See: Generating a Cash Forecast with Amounts Calculated Automatically and Submitting Requests.
Forecast Name: Enter the name of the forecast that you submitted.
Forecast Name: The name of the cash forecast.
Template Name: The name of the template for the cash forecast.
Forecast By:he forecast period type (GL Period or Days).
Start Date: The earliest date of information that is included in the forecast.
Forecast Currency: The currency of the amounts that appear in the forecast.
Source Currency Type: Determines if source transactions are selected by currency:
All - All transactions are included.
Entered - Transactions entered in the source currency are included.
Ledger - Transactions where the source currency is the same as the ledger currency are included.
Source Currency: The currency for the source transactions included in the forecast.
Exchange Date: The exchange date, as defined in Oracle General Ledger.
Exchange Type: The exchange rate type, as defined in Oracle General Ledger.
Error Message: Description of any errors that occurred for the cash forecast.
The Purge Cash Forecast Report lets you view which forecasts have been purged. Cash Management automatically generates this report when you submit the Purge Cash Forecasts program using the Submit Request window.
Cash Management automatically generates this report when you run the Purge Cash Forecasts program.
Forecast Name: The name of the forecasts that were purged.
Template Name: The name of the template associated with the purged forecasts.
Forecast By: Indicates whether the forecast was by days or GL periods.
Forecast Date/Period: Indicates the start date or GL period of the purged forecast.
Cash Management provides the following statements reports:
Use this report to view a list of bank statements that were archived or purged from Cash Management. This report lists only the number of headers and lines archived or purged from the bank statement interface table and does not list reconciliations or errors, since they are not applicable to interface tables. This report does, however, list the number of headers, lines, reconciliations, and errors for the bank statement tables.
The number under the headers and lines column is the total number of headers and lines that have been archived or purged.
Cash Management automatically generates this report when you run the Archive/Purge Bank Statements program.
This report shows import and reconciliation errors that occurred when running the AutoReconciliation program. Cash Management automatically produces this report during the automatic reconciliation process. You may also request it as needed from the Submit Request window.
This report includes either statement import errors, which prevented the automatic loading of your bank statement, or your reconciliation exceptions found during the automatic reconciliation process.
This report lists the details of any miscellaneous transactions that were created in Receivables during the automatic reconciliation process.
If the AutoReconciliation program does not encounter any reconciliation errors or exceptions, the body of the report will display a message that says the program ran successfully and that there was no error found.
You submit this report from the Submit Request window. See: Submitting Requests.
Statement Number: Enter the number of the bank statement.
This report shows statement and transaction information for a specific bank account statement, including bank statement header information, statement line detail, and reconciled transaction detail. This report lists any unreconciled transactions separately with their current status, and the statement totals for each type of transaction, including the amount entered, reconciled, unreconciled and over-reconciled. Under-reconciled amounts are displayed as a negative amount in the over-reconciled column. You also have the option to run the report for only unreconciled statement lines.
The statements are displayed in the following order:
Bank Branch Name
Bank Account Name
Statement Date
Statement Number
You submit this report from the Submit Request window. See: Submitting Requests.
Break Level: Indicate if you want the report to have a page break for every bank account or for every bank statement.
Statement Line Status: Indicate if you want to include reconciled, unreconciled, or all transactions in the report.
This report shows errors and warnings that occur when the Bank Statement Loader program transfers data from the intermediate table to the Bank Statement Open Interface tables. Cash Management automatically produces this report when you run the Bank Statement Loader program.
The report lists exceptions by their type. The report lists errors first and warnings next. Within each type, the report sorts exceptions by the Rec No, in ascending order.
Cash Management automatically generates this report when you run the Bank Statement Loader program.
Name: Name of the mapping template specified in the Mapping Name parameter of the Bank Statement Loader program.
Description: Description of the mapping template specified in the Mapping Name parameter of the Bank Statement Loader program.
Format Type: Format type of the mapping template specified in the Mapping Name parameter of the Bank Statement Loader program.
Control File: SQL*Loader file of the mapping template specified in the Mapping Name parameter of the Bank Statement Loader program.
Data File Name: Value specified in the Data File Name parameter of the Bank Statement Loader program.
Bank Account Number: The bank account number of the statement that was loaded into the Bank Statement Open Interface tables.
Statement Number: The bank statement number of the statement that was loaded into the Bank Statement Open Interface tables.
Type: Warning or error
Message: Message text.
Record Number: The sequential number of the record in the bank statement file.
This report shows summary bank statement information for a bank account.
You submit this report from the Submit Request window. See: Submitting Requests.
Balances By: Indicate if you want to sort the balances on the report by statement date or effective date.
As Of Date: Only statement information entered before this date is included on the report.
This report lists bank statements in document number order, to help you identify missing and deleted statements.
If you or your System Administrator sets up the Document Sequences feature for Cash Management, then you can print a report to list all bank statements in document number order.
You submit this report from the Submit Request window. See: Submitting Requests.
Sequence Name: Enter the name of the document sequence that you want to use to produce the report.
Document Number From/To: Enter the range of document numbers for statements that you want to include in the report.
Use this report to reconcile the General Ledger cash account balance to the bank statement closing balance and to identify any discrepancies in your cash position. The General Ledger cash account should pertain to only one bank account. This report is available in Summary and in Detail format.
The Summary report lists the General Ledger cash account balance and an adjusted balance for the bank statement. It also lists a separate adjustment amount for unreconciled receipts, payments, and journal entries which have been recorded in the General Ledger cash account, as well as bank errors. The Detail report provides details for the unreconciled items as well as the information contained in the Summary report.
Note: This report does not include information on Payroll payments, Treasury settlements, or external transactions in the Reconciliation Open Interface because they may have been posted to a different General Ledger account than the one assigned to the bank account.
Warning: To ensure that this report is accurate, you must first perform the following tasks:
Reconcile all statements in Cash Management.
Transfer journal entry transactions from Oracle Payables and Oracle Receivables to your General Ledger.
Post journals in General Ledger.
Run the report for the current GL period.
See: How Using Cash Management Affects Your Closing Process
You submit this report from the Submit Request window. See: Submitting Requests.
Period Name: Enter the name of the period for which you want to reconcile to the General Ledger.
Closing Balance: Enter the bank statement closing balance for the period you entered.
Report Type: Choose either Summary or Detail to indicate if you want the report to provide summary balances only or details of unreconciled items.
General Ledger Cash Account Balance: The balance in the General Ledger cash account after all relevant entries have occurred for the reconciliation period. The General Ledger cash account pertains to only one bank account.
Bank Statement Closing Balance: The bank statement closing balance that you specified.
Unreconciled Receipts: Total amount of receipts that were recorded in the General Ledger cash account for the reconciliation period, but were not reconciled as of the statement cutoff date.
Unreconciled Payments: Total amount of payments that were recorded in the General Ledger cash account for the reconciliation period, but were not reconciled as of the statement cutoff date.
Unreconciled Journal Entries: Total amount of journal entries that were posted to the General Ledger cash account but were not reconciled for the reconciliation period. Depending on the transactions, these are added to or subtracted from the General Ledger cash account balance.
Lines Marked as Errors: Total amount of transactions that are in dispute with the bank and are considered to be outstanding as of the statement cutoff date.
Adjusted Bank Statement Balance: The sum of the Bank Statement Closing Balance, Unreconciled Receipts, Unreconciled Payments, Unreconciled Journal Entries, and Lines Marked as Errors.
Difference: The net difference between the General Ledger Cash Account Balance and the Adjusted Bank Statement Balance. You can investigate this balance to identify items that comprise it. You can start by investigating the corresponding items for the lines marked as error in the bank statement.
Unreconciled Receipts: Details of transactions that comprise the Unreconciled Receipts total amount. The transactions include receipts that have the status of Cleared, Remitted, or Reversed.
Cleared: Receipts that have been manually cleared in Cash Management or automatically cleared in Receivables, but have not been reconciled.
Remitted: Receipts that have been deposited and accounted, but have not been cleared or reconciled.
Reversed: Receipts that have been reversed either through Cash Management or through Receivables and are available for reconciliation.
Unreconciled Payments: Details of transactions that comprise the Unreconciled Payments total amount. The transactions include payments that have the status of Cleared, Negotiable, or Stop Initiated.
Cleared: Payments that have been manually cleared but have not been reconciled.
Negotiable: Payments that have been issued and accounted, but have not been cleared or reconciled.
Stop Initiated: Payments that have been stopped in Payables and are available for reconciliation.
Note: If the Payment transactions are accounted on Creation and also after Clearing, then such unreconciled payments will be displayed in this report only after accounting the clearing events.
Unreconciled Journal Entries: Details of transactions that comprise the Unreconciled Journal Entries total amount. The transactions include budget journals created with the Balance Type of Actual.
Lines Marked as Errors: Details of transactions that comprise the Lines Marked as Errors total amount.
The Bank Statement Cashflow Creation Execution Report shows a complete, comprehensive listing of errors and cashflow transactions created successfully when running the Bank Statement Cashflow Creation program. Cash Management automatically produces this report during the bank statement cashflow creation process.
Cash Management automatically generates this report when you run the Bank Statement Cashflow Creation program.
The Sweep Transactions Generation Execution Report lists Sweep Transactions Generation exceptions. During automatic deal generation, the following error messages are shown in the output file:
Transaction generation failure, incomplete cash pool setup
Transaction generation failure, mandatory fields missing
Transaction generation failure, bank account number is missing
Transaction generation successful, with a limit warning
Possible match already exists for Deal # ______, Transaction # _____
Cash Management automatically generates this report when you run the Sweep Transactions Generation Execution program.
Cash Management provides the following transactions reports.
This report lists, for a specific bank account, all transactions that have been remitted to the bank but have not been cleared. This report excludes all voided transactions. The report also excludes all reversed transactions which have a reversal date on or prior to the As Of Date.
You submit this report from the Submit Request window. See: Submitting Requests.
Transaction Type: The type of transactions that you want to include on the report.
AP Payments
AR Receipts
AP Payments and AR Receipts
Payroll Payments
Open Interface Transactions
All
Payroll Business Group: This field is only enabled if Payroll Payments is selected in the Transaction Type field. If a business group is entered, only payroll payments that belong to this business group are displayed on the report.
AP/AR Operating Unit: This field is only enabled if either AP Payments or AR Receipts is selected in the Transaction Type parameter field. If an operating unit is entered, only AP Payments or AR receipts that belong to this operating unit are included on the report.
As Of Date: Only transactions that were entered before this date are included on the report.
Sort By: Indicate if you wish to sort the uncleared receipts and payments by Maturity Date, Payment Method, or Payment/Receipt Number.
Payments in Transit:
Vendor Name: The supplier associated with the transaction.
Payment Date: The check or payment date.
Maturity Date: The maturity date of the payment.
Currency: The code for the currency of the payment.
Amount: The amount of the payment.
Bank Account Amount: The payment amount in the currency of the bank account.
Receipts in Transit:
Customer Name: The customer associated with the transaction.
Remit Date: The receipt transaction date.
Maturity Date: The receipt maturity/due date.
Currency: The code for the currency of the receipt.
Amount: The amount of the receipt.
Account Amount The receipt amount in the currency of the bank account.
This report shows transactions that were cleared or reconciled both manually and automatically.
The cleared receipts section shows the customer name, remittance date, maturity date, payment method, receipt number, currency, amount, account amount, cleared date, and cleared amount.
The cleared payments section shows the supplier name, payment date, payroll payments, maturity date, payment method, payment number, currency, amount, account amount, cleared date, and cleared amount
You can submit the report for Oracle Payables payments only, receipts only, payroll payments, or all.
You submit this report from the Submit Request window. See: Submitting Requests.
Bank Branch: Bank branch for which you want to submit the report.
Bank Account Number: If you want to submit the report for a particular bank account, enter the bank account number.
Transaction/Batch: Select the level at which you want to run the report:
Batch
Transaction
Transaction Type Transaction type for which you want to run the report.
All
Payments
Receipts
AP Payments and AR Receipts
Payroll Payments
Open Interface Transactions
Cash Management Transactions
Journal Entry Lines
Bank Statement Lines
Treasury Open Interface Transactions
Treasury Legal Entity: This field is enabled if Treasury Open Interface is selected in the Transaction Type parameter field. If a legal entity is entered, only Treasury transactions that belong to this legal entity are included on the report.
Payroll Business Group: This field is only enabled if Payroll Payments is selected in the Transaction Type field. If a business group is entered, only payroll payments that belong to this business group are displayed on the report.
AP/AR Operating Unit: This field is enabled if either AP Payments or AR Receipts is selected in the Transaction Type parameter field. If an operating unit is entered, only AP payments or AR receipts that belong to this operating unit are included on the report.
Cleared Date From/To: Enter a value in one or both fields if you want to limit the report to transactions with cleared dates during a particular time period.
Order By: Order in which report output will be displayed.
Amount
Date
Remittance Date: The receipt transaction date.
Maturity Date: Date the issuing bank dispersed funds.
Amount: Amount of payment in the currency it was issued.
Account Amount: Payment amount in the currency of the bank account.
Cleared Date: Date the payment or receipt cleared in Cash Management.
Payment Date: Date payment is issued.
Cleared Amount: Amount cleared in Cash Management.
This report shows all transactions available for reconciliation for a specific bank account. It lists detailed transaction information for your Available Receipts, Available Payments, and Available Journal Entries for reconciliation. Detailed information includes the Customer, Supplier, Transaction Date, Payment Method, Transaction Number, Currency, and Amount. It also lists detailed information for statement lines that are available for reconciliation against other statement lines.
Note: Statement lines that cannot be reconciled are not shown. To view these lines, you should run the Bank Statement Detail Report.
This report only lists void payments if the Show Void Payments option on the Systems Parameters window is checked. It does not list receipts reversed due to user error nor does it list the associated original receipts that were not reconciled. This report groups transactions by status so that void or reversed transactions are separate from regular transactions.
The Net Available Amount is calculated as Total Available Receipts minus Total Reversed Receipts minus Total Available Payments plus Total Voided Payments.
Note: If you want to view batches available for reconciliation, submit the Batches Available for Reconciliation Report.
You submit this report from the Submit Request window. See: Submitting Requests.
Transaction Type Indicate the types of transactions, such as payments, that you want to include on the report.
All
Payments
Receipts
AP Payments and AR Receipts
Payroll Payments
Open Interface Transactions
Cash Management Transactions
Journal Entry Lines
Bank Statement Lines
Treasury Open Interface Transactions
Treasury Legal Entity: This field is enabled if Treasury Open Interface is selected in the Transaction Type parameter field. If a legal entity is entered, only Treasury transactions that belong to this legal entity are included on the report.
Payroll Business Group: This field is only enabled if Payroll Payments is selected in the Transaction Type field. If a business group is entered, only payroll payments that belong to this business group are displayed on the report.
AP/AR Operating Unit: This field is enabled if either AP Payments or AR Receipts is selected in the Transaction Type parameter field. If an operating unit is entered, only AP payments or AR receipts that belong to this operating unit are included on the report.
Bank Account Number: Enter the bank account number.
Order By:Choose to sort the report by amount or date.
Available Receipts:
Customer Name: The customer associated with the transaction.
Remit Date: The receipt transaction date.
Maturity Date: The receipt maturity/due date.
Currency: The code for the currency of the receipt.
Amount: The amount of the receipt.
Account Amount: The receipt amount in the currency of the bank account.
Available Payments:
Supplier Name: The supplier associated with the transaction.
Payment Date: The check or payment date.
Maturity Date: The maturity date of the payment.
Currency: The code for the currency of the payment.
Amount: The amount of the payment.
Account Amount: The payment amount in the currency of the bank account.
Journal Entry Lines:
Effective Date: The date the journal entry line affects balances in the general ledger.
Maturity Date: The maturity date of the journal entry line.
Journal Entry Description: Matching is performed against the journal entry description.
Currency: The code for the currency of the journal entry line.
Amount: The amount of the journal entry line.
Account Amount: The amount of the journal entry line in the currency of the bank account.
Reversed Receipts:
Customer Name: The customer associated with the transaction.
Remit Date: The receipt transaction date.
Maturity Date: The maturity date or due date of the transaction.
Payment Method: The user-defined Receivables choices for how customer's invoices can be paid for customer receipts.
Receipt Number: The receipt number.
Currency: The code for the currency of the receipt.
Amount: The amount of the receipt.
Account Amount: The receipt amount in the currency of the bank account.
Unreconciled Statement Lines:
Statement Number: The number of the bank statement.
Transaction Date: The transaction date.
Maturity Date: The transaction maturity/due date.
Line Type: Indicates the types of transactions, such as payments.
Transaction Number: The transaction number.
Currency: The code for the currency of the statement line.
Amount: The amount of the statement line.
Account Amount: The amount in the currency of the bank account.
This report shows any batches available for reconciliation for a specific bank account. It lists detailed transaction information for your Payment and Remittance Batches that are available for reconciliation. Detailed information includes the Batch Name, Remit/Payment Date, Deposit Number/Reference, Currency, and Amount.
Note: To view transactions available for reconciliation, submit the Transactions Available for Reconciliation Report.
Submit this report from the Submit Request window. See: Submitting Requests.
Batch Type: Indicate the type of batch to include on the report.
Bank Account Number: Enter the bank account number.
Order By: Choose to sort the report by amount or date.
Bank Account Currency: The code for the currency of the bank account.
Remit/Payment Date: The batch transaction date.
Deposit Number/Reference Number: The deposit number on the remittance batch or the reference number on the payment batch.
Currency: The code for the currency of the batch.
Amount: The amount of the batch.
Account Amount: The batch amount in the currency of the bank account.
If you implement the automatic bank transmission feature, use this report to view payment exceptions generated by the bank and transmitted to your local directory. You can view the transmission history and the actual report in the Transmissions window. In the Find Transmissions window, choose the file type of EXCEPTION to query exceptions reports. Select the File Text field of the file you want to view and choose Edit Field from the Edit menu. The Editor window displays the content of the file you selected.
To resolve the payment exceptions, you need to manually unreconcile the transactions in Cash Management and void the payment in Payables.
You submit this report from the Submit Request window. See: Submitting Requests.
Select the Retrieve Payment Exceptions program.
Transmission Code: Indicate the transmission code defined for your bank. The transmission code determines the set of transmission parameters this program uses.
Cash Management provides the following balances reports.
The Bank Account Balance Single Date Report allows users to report on one or more bank account's balances for a particular date and the results are grouped by Bank Account Currency.
Bank Account Currency: Enter the currency of the bank account.
Legal Entity: Enter a legal entity to which the user has access.
As of Date: Enter the date on which you want to review the balance information.
Reporting Currency: Choose a currency in which you want the balances to be reported in addition to the local currency: If the user selects a Reporting Currency, the Exchange Rate Type and Exchange Rate Date parameters are required.
Exchange Rate Type: Choose an exchange rate type, as defined in Oracle General Ledger.
Exchange Rate Date: Enter the date of the exchange rate.
As of Date: Balance date on which the balances are reported.
Legal Entity: The legal entity that you specified.
Reporting Currency: The reporting currency that you specified.
Exchange Rate Type: The exchange rate type that you specified.
Exchange Rate Date: The exchange rate date that you specified.
The Bank Account Balance Day Range Report allows users to report on one or more bank account's balances for a range of dates.
Bank Account Currency: Enter the currency of the bank account.
Legal Entity: Enter a legal entity to which the user has access.
From Date: Enter the start date of a date range from which you want to review the balance information.
To Date: Enter the end date of a date range to which you want to review the balances.
Reporting Currency: Choose a currency in which you want the balances to be reported in addition to the local currency: If the user selects a Reporting Currency, the Exchange Rate Type and Exchange Rate Date parameters are required.
Exchange Rate Type: Choose an exchange rate type, as defined in Oracle General Ledger.
Exchange Rate Date: Enter the date of the exchange rate.
From/To Date: The from and to dates that you specified.
Legal Entity: The legal entity that you specified.
Reporting Currency: The reporting currency that you specified.
Exchange Rate Type: The exchange rate type that you specified.
Exchange Rate Date: The exchange rate date that you specified.
The Bank Account Balance Actual vs Projected Report allows users to compare one or more bank account's actual balance to the projected balance for a range of dates.
Bank Account Currency: Enter the currency of the bank account.
Legal Entity: Enter a legal entity to which the user has access.
From Date: Enter the start date of a date range from which you want to review the balance information.
To Date: Enter the end date of a date range to which you want to review the balances.
Actual Balance Type: Choose the actual balance type (such as Available Balance, Ledger Balance, among others) that you want to compare to the projected balance.
From/To Date: The from and to dates that you specified.
Legal Entity: The legal entity that you specified.
Cash Management provides the following listings:
Use this listing to review the transaction codes that you defined for a specific bank account.
You submit this listing from the Submit Request window. See: Submitting Requests.
Code: The code that the bank uses to identify this type of transaction.
Description A description of the transaction associated with this code.
Start Date: The first date, in a range of dates, that the transaction code is active.
End Date: The last date, in a range of dates, that the transaction code is active.
Transaction Source: The source for transactions that Cash Management uses to reconcile statement lines for this transaction code.
Journal - General Ledger journals
Open Interface - Reconciliation Open Interface
Supplier Payments - Oracle Payables
Customer Receipts - Oracle Receivables
Matching Against: The identifier for the order and type of transactions to match for the transaction code if the transaction type is Miscellaneous Receipt or Miscellaneous Payment:
Miscellaneous - Only matches against miscellaneous transactions.
Statement - Only matches against statement lines (corrections).
Miscellaneous and Statement - Cash Management first tries to match against miscellaneous transactions. If there is no match, then it tries to match against statement lines (corrections).
Statement and Miscellaneous - Cash Management first tries to match against statement lines (corrections). If there is no match, then it tries to match against miscellaneous transactions.
Correction Method: The method the bank uses to correct bank errors: reversal, adjustment, or both. The correction method only applies to Miscellaneous Receipt or Miscellaneous Payment transaction codes that may be used to match to correction statement lines.
Create: Indicates if Cash Management creates transactions for any miscellaneous payments or miscellaneous receipts that are reported on a bank statement without a transaction number.
Activity: The Receivables activity type for any miscellaneous transactions (receipts) that were created within Cash Management.
Payment Method: The payment method for any miscellaneous transactions (payments) that were created within Cash Management.
Use this report to see details for a cash forecast template.
You submit this listing from the Submit Request window. See: Submitting Requests.
Template Name: The template for which you want to run the report. Leave this parameter blank to create a listing for all templates.
For details on any heading, see the Forecast Template Rows Window Reference.
Cash Management provides the following programs:
Bank Statement Import and AutoReconciliation
Cash Forecasting by GL Periods
Cash Position Prior Day Cash Flow and Overdue Transactions
You submit these programs from the Submit Request window. See: Submitting Requests.