cash management - university of wisconsin system
TRANSCRIPT
University of Wisconsin System SFS Business Process
Cash Management Add Bank
Cash Management Add Bank 1 of 15
Contents
Defining Bank Information ...................................................................................................................... 1
I. Add Bank .................................................................................................................................... 1
II. Adding Bank Contact Information ................................................................................................ 4
III. Add Bank Branches .................................................................................................................... 6
External Accounts .................................................................................................................................. 9
IV. Add External Accounts ................................................................................................................ 9
V. Add Signatories ........................................................................................................................ 12
VI. Reconciliation Rules ................................................................................................................. 13
VII. Account Information .................................................................................................................. 13
VIII. Payment Methods ..................................................................................................................... 14
Defining Bank Information
Before you can move funds in and out of PeopleSoft Financials, you must define banks and bank accounts in the system. You define as many banks and bank accounts as you need to manage your funds. For each bank, you can also define various processing defaults. In PeopleSoft, a bank is any financial institution with which your organization maintains a banking relationship. A counterparty has a trading relationship with your organization. When you define bank information, you define a hierarchy of information: first, the general bank setup; second, the bank detail information (general information such as bank and branch information, and processing information such as payment methods for bank accounts). Once you have established this core banking data, you can then define settlement instructions (predefined bank account specifics for handling cash inflows and outflows), account types (external, internal, or netting) and additional banking functionality. PeopleSoft bank functionality is available to PeopleSoft Cash Management, Deal Management, Risk Management, Expenses, Payables, Receivables, General Ledger, and Global Payroll. Establishing your banks, bank accounts, and counterparties involves several steps that vary depending on which applications you have installed. Your banks supply information such as account, bank ID, branch ID, and other Depository Financial Institution (DFI) numbers. Other information depends on how you and your customers, suppliers, and counterparties agree to set up payment, receipt, and settlement procedures.
I. Add Bank
University of Wisconsin System SFS Business Process
Cash Management Add Bank
Cash Management Add Bank 2 of 15
1. Select CM WorkCenter tile
2. Select Bank Information Links under Banking
3. Click 4. Enter SetID and Bank Code <5 Character Alpha Numeric> 5. Click Add 6. Enter Description <This value should be beneficial for the end user> 7. Type Short Desc 8. Select Type ‘External’ 9. Select Status ‘Active’ 10. Select Bank ID Qualifier ‘US Bank’ 11. Type in the Bank ID <Bank ID is a 9-digit numeric value, routing number> 12. Type Immediate Origin <If Applicable><Obtain the code from your bank> 13. Type Immediate Destination <If Applicable><Obtain the code from your bank> 14. Click Address Information Link and enter the values specified on the Address
Information Page.
University of Wisconsin System SFS Business Process
Cash Management Add Bank
Cash Management Add Bank 3 of 15
15. Enter Address 1, 2, City, State, Postal and Phone
16. Click Ok 17. Click on the Notes Link
University of Wisconsin System SFS Business Process
Cash Management Add Bank
Cash Management Add Bank 4 of 15
18. Enter notes
19. Click Ok 20. Click Save
II. Adding Bank Contact Information
1. Select CM WorkCenter tile
University of Wisconsin System SFS Business Process
Cash Management Add Bank
Cash Management Add Bank 5 of 15
2. Click on Contact Information Links
3. Click tab. 4. Select SetID 5. Leave Contact ID as is ‘NEXT’ <This will be Auto Numbering> 6. Click Add 7. Enter Name 8. Enter Contact Title 9. Select Contact Type ‘General’ 10. Enter Email ID <If Applicable> 11. Select Bank Code 12. Select Country 13. Click Address Information Link <Enter the values specified on the Address
Information Page>
University of Wisconsin System SFS Business Process
Cash Management Add Bank
Cash Management Add Bank 6 of 15
14. Enter Address 1, 2, City, State, Postal and Phone
15. Click Ok 16. Click Save
III. Add Bank Branches Bank Branches represent physical bank locations. Use the Bank Branch information page to edit bank branch information associated with an external account. 1. Select ‘CM WorkCenter’ title from the Home Page
University of Wisconsin System SFS Business Process
Cash Management Add Bank
Cash Management Add Bank 7 of 15
2. Click Bank Branch Information Link
3. Click tab. 4. Select SetID 5. Select Bank Code 6. Enter/Select Branch name 7. Click Add 8. Enter Description 9. Enter Short Description 10. Select Status ‘Active’ 11. Select Bank ID Qualifier ‘US Bank’ 12. Enter Notes that will assist anyone with additional information that would be useful.
University of Wisconsin System SFS Business Process
Cash Management Add Bank
Cash Management Add Bank 8 of 15
13. Enter Address Information
14. Enter Address 1, 2, City, State, Postal and Phone
15. Click Ok 16. Click Contact Information
University of Wisconsin System SFS Business Process
Cash Management Add Bank
Cash Management Add Bank 9 of 15
17. Click Magnify glass and select Contact ID
18. Click Ok 19. Click Save
External Accounts IV. Add External Accounts
1. Select ‘CM WorkCenter’ title from the Home Page
University of Wisconsin System SFS Business Process
Cash Management Add Bank
Cash Management Add Bank 10 of 15
2. Click External Accounts
3. Click 4. Select SetID 5. Select Bank Code 6. Select Branch Name 7. Enter Bank Account <Typically the last for digit of the Account number> 8. Click Add 9. Select Status 10. Select GL Unit 11. Enter Description 12. Enter Short Desc 13. Select Branch 14. Enter Account Number 15. Select DFI Qualifier ‘01’ 16. Enter DFI ID 17. Select Currency Code ‘USD’ 18. Select the appropriate Acct Type box to indicate which PeopleSoft Financials
applications use this account. BI: Billing AP: Payables AR: Receivables TR: Treasury EX: Expenses GP: Global Payroll
University of Wisconsin System SFS Business Process
Cash Management Add Bank
Cash Management Add Bank 11 of 15
19. Select Rate Type ‘CRRNT’ 20. Select Index ‘DEFAULT’ 21. Select Checkbox for ‘Stmt Accounting’
22. Enter the applicable ChartFields in Bank Account Ledger Types
University of Wisconsin System SFS Business Process
Cash Management Add Bank
Cash Management Add Bank 12 of 15
23. Click Save
V. Add Signatories
Use the External Accounts – Signatories Page to define account signatories. Enter the name of the signatory and the monetary ceiling (the signatory limit) that the signatory can approve. The system does not generate a required activity for the signatory (for example, the signatory’s electronic signature on a system-generated check). You can use this for reports or configurations that you want to add. 1. Click Signatories tab from the External Accounts page 2. Enter Name and Signatory Limit
University of Wisconsin System SFS Business Process
Cash Management Add Bank
Cash Management Add Bank 13 of 15
3. Click Save
VI. Reconciliation Rules
Use the External Accounts – Reconciliation page to select a method of reconciliation to use for each external account. 1. Click Reconciliation Rules tab from the External Accounts page. 2. Select Recon Method as ‘Automatic’ 3. Select Notification Method as ‘No Workflow 4. Select Recon Process under the Reconciliation Sources type and give it a number
Source Seq PS_BNK_RCN_DISBRSE – AP Disbursement Rules PS_BNK_RCN_TRAN – External Transaction Rules
VII. Account Information
Use the External Accounts – Account Information page to specify additional information for each bank account. 1. Click Account Information tab from the External Accounts Page. 2. Select Holiday List ID ‘USA’ 3. Select Preferred Language ‘ENG’ 4. Select Charge Bank ‘USB95’ 5. Enter Check# Length <Please check with your AP what they require Length is>
University of Wisconsin System SFS Business Process
Cash Management Add Bank
Cash Management Add Bank 14 of 15
VIII. Payment Methods
Use the External Accounts – Payment Methods page to define the payment methods supported for an account, payment processing options, and EFT file attributes. For each account, you can enter multiple payment methods.
1. Click Payment Methods tab from External Accounts page. 2. Select Payment Method 3. Add more Payment Method by clicking plus sign if needed.
University of Wisconsin System SFS Business Process
Cash Management Add Bank
Cash Management Add Bank 15 of 15
4. Click Save
Revision History
Author Version Date Description of Change
Nou Vang 1.0 09/18/18 Final