Cash Management Reports: A to Z
This appendix provides an overview of Cash Management reports and enables you to view a summary table of all reports.
Note. For samples of these reports, see the Portable Document Format (PDF) fields that are published on CD-ROM with your documentation.
See Also
PeopleTools PeopleBook: PeopleSoft Process Scheduler
Cash Management Reports: A to Z
This table lists all of the reports provided with Cash Management, sorted alphanumerically by report ID. The reports listed are Crystal and XMLP reports.
|
Report ID and Report Name |
Description |
Navigation |
Run Control Page |
|
FIN3003 Fees & Interest (Crystal) |
Shows miscellaneous transaction details for a specified bank ID, bank account, and statement ID number. |
Cash Management, Reports, Fees and Interest |
RUN_FIN3003 |
|
FSX3003 Fees & Interest (XML format) |
Shows miscellaneous transaction details for a specified bank ID, bank account, and statement ID number. |
Cash Management, Reports, Fees and Interest |
RUN_FIN3003 |
|
TRC1000 Accounting Entries (Crystal) |
Shows comprehensive accounting entry information for a specified business unit and accounting ID. |
Cash Management, Treasury Accounting, Accounting Entries Report |
RUN_TRC1000 |
|
TRX1000 Accounting Entries (XML format) |
Shows comprehensive accounting entry information for a specified business unit and accounting ID. |
Cash Management, Treasury Accounting, Accounting Entries Report |
RUN_TRC1000 |
|
TRC1004 Actual vs. Projected Cash Positions (Crystal) |
Lists actual versus projected cash positions for a specified business unit, tree name, and tree node. |
Cash Management, Reports, Actual v Projected by BU |
RUN_TRC1004 |
|
TRX1004 Actual vs. Projected Cash Positions (XML format) |
Lists actual versus projected cash positions for a specified business unit, tree name, and tree node. |
Cash Management, Reports, Actual v Projected by BU |
RUN_TRC1004 |
|
TRC1008 Actual vs. Projected Cash Positions by Currency (Crystal) |
Lists, by currency code, actual versus projected cash positions for a specified business unit, tree name, and tree node. |
Cash Management, Reports, Actual v Projected by BU |
RUN_TRC1008 |
|
TRX1008 Actual vs. Projected Cash Positions by Currency (XML format) |
Lists, by currency code, actual versus projected cash positions for a specified business unit, tree name, and tree node. |
Cash Management, Reports, Actual v Projected by BU |
RUN_TRC1008 |
|
TRC1009 Actual vs. Projected Cash Positions by Account (Crystal) |
Lists actual versus projected cash positions for comparison by bank account number. |
Cash Management, Reports, Actual v Projected by Account |
RUN_TRC1009 |
|
TRX1009 Actual vs. Projected Cash Positions by Account (XML format) |
Lists actual versus projected cash positions for comparison by bank account number. |
Cash Management, Reports, Actual v Projected by Account |
RUN_TRC1009 |
|
TRC1010 Settlement Instructions (Crystal) |
Shows settlement instruction information for all settlement IDs of a specified set ID. |
Cash Management, Reports, Settlement Instructions |
RUN_TRC1010 |
|
TRX1010 Settlement Instructions (XML format) |
Shows settlement instruction information for all settlement IDs of a specified set ID. |
Cash Management, Reports, Settlement Instructions |
RUN_TRC1010 |
|
TRC1014 Cash Flow Settlements (Crystal) |
Lists bank, account, and settlement information for cash flows of a specified business unit and time period. |
Cash Management, Reports, Cash Flow Settlements |
RUN_TRC1014 |
|
TRX1014 Cash Flow Settlements (XML format) |
Lists bank, account, and settlement information for cash flows of a specified business unit and time period. |
Cash Management, Reports, Cash Flow Settlements |
RUN_TRC1014 |
|
TRC3005 In-House Bank Statement (Crystal) |
Lists transaction and interest accrual activity for a specified bank and account during a defined time frame. |
Cash Management, In-House Banking, In-House Bank Statements |
RUN_TRC3005 |
|
TRX3005 In-House Bank Statement (XML format) |
Lists transaction and interest accrual activity for a specified bank and account during a defined time frame. |
Cash Management, In-House Banking, In-House Bank Statements |
RUN_TRC3005 |
|
TRC4000 Netting Balance List (Crystal) |
Lists comprehensive balance information for all nets of a specified netting status and time period. |
Cash Management, Reports, Netting Balance List |
RUN_TRC4000 |
|
TRX4000 Netting Balance List (XML format) |
Lists comprehensive balance information for all nets of a specified netting status and time period. |
Cash Management, Reports, Netting Balance List |
RUN_TRC4000 |
|
TRC4010 Netting Advice Balance Summary (Crystal) |
Lists total receivable, total payable, and total net amounts for a specified netting status and time period. The amounts are formatted for faxing. |
Cash Management, Report, Netting Advice Summary |
RUN_TRC4010 |
|
TRX4010 Netting Advice Balance Summary (XML format) |
Lists total receivable, total payable, and total net amounts for a specified netting status and time period. The amounts are formatted for faxing. |
Cash Management, Report, Netting Advice Summary |
RUN_TRC4010 |
|
TRC4020 Netting Advice Balance Detail (Crystal) |
Lists detailed information (such as accounts payable/accounts receivable association, business unit, gross amount, and net amount) for all nets of a specified netting status and timeframe. |
Cash Management, Report, Netting Advice Detail |
RUN_TRC4020 |
|
TRX4020 Netting Advice Balance Detail (XML format) |
Lists detailed information (such as accounts payable/accounts receivable association, business unit, gross amount, and net amount) for all nets of a specified netting status and timeframe. |
Cash Management, Report, Netting Advice Detail |
RUN_TRC4020 |
|
TRC4050 Fee Structures (Crystal) |
Shows comprehensive fee structure information for a specified bank code, including the fee description, type, minimum and maximum ranges, and rate and price information. |
Banking, Account Analysis, Fee Structures Report |
RUN_TRC4050 |
|
TRX4050 Fee Structures (XML format) |
Shows comprehensive fee structure information for a specified bank code, including the fee description, type, minimum and maximum ranges, and rate and price information. |
Banking, Account Analysis, Fee Structures Report |
RUN_TRC4050 |
|
TRC4060 Actual vs. Projected Cash Position (Crystal) |
Lists actual versus projected cash positions by a specified tree name and value date. |
Cash Management, Reports, Actual v Projected by Position |
RUN_TRC4060 |
|
TRX4060 Actual vs. Projected Cash Position (XML format) |
Lists actual versus projected cash positions by a specified tree name and value date. |
Cash Management, Reports, Actual v Projected by Position |
RUN_TRC4060 |
|
TRC4090 Book-to-Bank Reconciliation (Crystal) |
Lists book-to-bank reconciliation details for a selected bank account, including adjusted bank statement balance or ledger balance information. |
Banking, Reconcile Statements, Book to Bank Reconciliation Click Detail on the Book to Bank Reconciliation page. Click Report on the Book to Bank Reconciliation Details page. |
RUN_TRC4090 |
|
TRX4090 Book-to-Bank Reconciliation |
Lists book-to-bank reconciliation details for a selected bank account, including adjusted bank statement balance or ledger balance information. |
Banking, Reconcile Statements, Book to Bank Reconciliation Click Detail on the Book to Bank Reconciliation page. Click Report on the Book to Bank Reconciliation Details page. |
RUN_TRC4090 |
|
TRC4100 Participant Positions by Pool (Crystal) |
Lists the positions of investment pools and the positions of each pool's participants for a specified business unit. |
Cash Management, Reports, Participant Positions by Pool |
RUN_TRC4100 |
|
TRX4100 Participant Positions by Pool (XML format) |
Lists the positions of investment pools and the positions of each pool's participants for a specified business unit. |
Cash Management, Reports, Participant Positions by Pool |
RUN_TRC4100 |
|
TRX5000 Cash Sweep Structure |
Lists detailed information for a cash sweep structure, includes the master bank account, overall cash sweep processing attributes, sub-accounts, sub-account processing attributes and audit information. |
Cash Management, Cash Sweep, Reports, Cash Sweep Structure |
RUN_TRX5000 |
|
TRX5001 Cash Sweep Bank Accounts |
Lists all of the cash sweep structures associated with a given bank account and whether the account is the master bank account or sub account in the structure. |
Cash Management, Cash Sweep, Reports, Cash Sweep Bank Accounts |
RUN_TRX5001 |
|
TRX5002 Cash Sweep Summary |
Summarizes cash sweep amounts within a cash sweep structure by bank account. |
Cash Management, Cash Sweep, Reports, Cash Sweep Summary |
RUN_TRX5002 |
|
TRX5003 Denied Cash Sweep Payments |
Run the Denied Cash Sweep Payments report. |
Cash Management, Cash Sweep, Reports, Denied Cash Sweep Payments |
RUN_TRX5003 |