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) files that are published with your online documentation.
See Also
PeopleTools PeopleBook: PeopleSoft Process Scheduler
This table lists all of the reports provided with Cash Management, sorted alphanumerically by report ID. The reports listed are Crystal and BI Publisher for PeopleSoft 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 (BI Publisher) |
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 (BI Publisher) |
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 (BI Publisher) |
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 (BI Publisher) |
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 (BI Publisher) |
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 setID. |
Cash Management, Reports, Settlement Instructions |
RUN_TRC1010 |
TRX1010 Settlement Instructions (BI Publisher) |
Shows settlement instruction information for all settlement IDs of a specified setID. |
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 (BI Publisher) |
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 (BI Publisher) |
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 (BI Publisher) |
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 (BI Publisher) |
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 (BI Publisher) |
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 (BI Publisher) |
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 (BI Publisher) |
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 (BI Publisher) |
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 subaccount 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 |