Review the branch information, adding branch address information, and adding branch contact information.

Review the external account information, contacts,  account reconciliation,  collection methods, payment methods, additional payment methods and settlement instructions.

The importing of bank statement information is an integral part of the reconciliation, and bank statement accounting. The system processes previous day statements that are used for reconciliation and accounting.

The Review Bank Statement Files page enables you to review the staging status of imported bank statement files. You can see if the system successfully loads a file. If a file does not successfully load, use the View Bank Statement File Log page to determine exactly where the system encounters a file loading error.

Use this document as a reference to inquire on statement information for a bank account and run the Account Register report in ctcLink. Use this report to see all transactions in an electronic bank statement. You can also review parsed addenda from this page.

After you transfer bank statement information to the production tables, you can update the data by using the Bank Balance Entry and Bank Transaction Entry pages. In addition, if you do not receive bank statements electronically from the bank, you also use the same pages to manually enter bank statement information online.

Use this document as a reference for running process reconciliation in ctcLink. This process will match and reconcile one-to-one transactions between the bank transactions and the system transactions based on the matching rules.

Bank Statement Accounting is an automated process for force reconciling bank statement lines that were not reconciled because there were no corresponding PeopleSoft transactions. Once Automatic Reconciliation is run and there are NTF or MSC exceptions a user can run Bank Statement processing to force reconcile the bank statement line and create an external transaction. Note: Must have Bank Statement Accounting rules configured along with Accounting Templates.

Use the Semi Manual Reconciliation page to reconcile statements semi-manually when there is not a one-to-one match or doesn't match the match criteria, between your bank and system transactions and you have reconciliation exceptions. Or, you can reconcile bank statements after entering a hard copy bank statement online.

Use the Manual Reconciliation page to reconcile statements for banks that do not provide an electronic file of their transaction data.Important! If you open a bank account in the Manual Reconciliation page that is set for automatic reconciliation, you get a warning message stating “This bank account is set up to use Automatic Reconciliation.” To avoid this warning, you should not perform manual reconciliation on bank accounts whose reconciliation method is Automatic.Some care should be taken, as any system transaction marked as manually reconciled will not be considered a candidate for automatic (or semi-manual) reconciliation. In addition, you need to be careful not to mark the transaction of an automatic bank for manual reconciliation. The system will then not retrieve these marked transactions for automatic or semi-automatic reconciliation.

The accounting template depicts the correct accounting and debit and credit configuration for a given treasury transaction and business event.The accounting template contains the following characteristics: A unique template ID. Options that determine how the correct ChartField Combination is selected.

Use the View/Approve Entries page to approve accounting entries that are awaiting review.

Use the Accounting Entries page to review, modify, and approve automated accounting entries.

Use the External Transactions page to modify or insert additional external transactions for a bank account. You also use this page to add new external transactions. After you enter the transactions, you run the Bank Reconciliation process to reconcile them automatically or use Semi-Manual Reconciliation page to reconcile the transaction.

The Automated Accounting Process creates accounting entries and prepares them for the Journal Generator process. Note: The process creates accounting entries even if errors occur. Use the Accounting Entries page to correct any errors, and then change the status from ‘Error’ to ‘Provisional.’ Use the View/Approve Entries page to change the status from ‘Provisional’ to ‘Final.’ The accounting entries are then ready for General Ledger. You do not have to rerun the Automated Accounting process.

Review the treasury table. Run the QFS_GL_TR_ACCTG_LINE query to ensure all transactions from the bank statement appear on the table.  At this time, the General Ledger Journal ID information will be missing because the Journal Generator process has not run yet.

Process interfaces treasury transactions to the General Ledger module.

Next day, confirm GL Posting. Run the QFS_GL_ACCT_ANALYSIS which includes the LEDGER table. At this time, the General Ledger will display all the treasury accounting transactions posted to the LEDGER table.CTC_ALL_CASHIER_RECEIPTS.

Book-to-bank reconciliation compares bank-reported balances in the bank statement against the system's general ledger bank balance for a specified fiscal period. Book to Bank Reconciliation is normally performed as part of the periodic PeopleSoft General Ledger Close process after you run bank reconciliation and have posted all subsystem transactions.

END

Review the branch information, adding branch address information, and adding branch contact information.

Review the external account information, contacts,  account reconciliation,  collection methods, payment methods, additional payment methods and settlement instructions.

The accounting template depicts the correct accounting and debit and credit configuration for a given treasury transaction and business event.The accounting template contains the following characteristics: A unique template ID. Options that determine how the correct ChartField Combination is selected. Checking the requires review box. Note: Select the Requires Review check box to force a review of the accounting transactions that use this template. When selected, the system assigns error-free accounting entries that use this template a Provisional status. You can then use the View/Approve Entries page to review and change the status to Final.

Use the View/Approve Entries page to approve accounting entries that are awaiting review.

Use the Accounting Entries page to review, modify, and approve automated accounting entries.

You use EFT Request to transfer funds from your organization’s bank to an external third party.

(Optional) EFTs are used to transfer funds from your organization's bank to an external third party. You can send funds transfers from templates, as well as on an ad hoc basis. To minimize the amount of manual entry when sending these ad hoc funds transfers, you can complete recipient information from settlement instructions, such as when you are paying a supplier who provides occasional services.

Review EFTs/settlements that you want to approve or deny for payment.

Select the EFTs/settlements that you want to approve or deny for payment.

Process authorizing the release of scheduled treasury payments. If you enable settlement authorization workflow, the system submits payments to the appropriate Worklists for approval. If you enable auto approval, the system marks the payments as approved and ready for dispatch. If you enable manual settlement approval, you must manually approve the payments on the Settlement Approval page. If you do not enable automatic settlement approval, the system automatically marks the payments as approved and ready for dispatch.

Use the Settlement Manager to review and manage all settlement activity from a central location. In addition, you can select a settlement category to review and approve settlements from the same page.

Automatic dispatching payment files to the bank.

Automatic dispatching payment files to the bank.

The Automated Accounting Process creates accounting entries and prepares them for the Journal Generator process. Note: The process creates accounting entries even if errors occur. Use the Accounting Entries page to correct any errors, and then change the status from ‘Error’ to ‘Provisional.’ Use the View/Approve Entries page to change the status from ‘Provisional’ to ‘Final.’ The accounting entries are then ready for General Ledger. You do not have to rerun the Automated Accounting process.

Review the treasury table. Run the QFS_GL_TR_ACCTG_LINE query to ensure all transactions from the bank statement appear on the table.  At this time, the General Ledger Journal ID information will be missing because the Journal Generator process has not run yet.

Process interfaces treasury transactions to the General Ledger module.

Confirm GL Posting. Run the QFS_GL_ACCT_ANALYSIS which includes the LEDGER table. At this time, the General Ledger will display all the treasury accounting transactions posted to the LEDGER table.

END