ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Banking: Bank Reconciliation Checklist
2
Section
Step
ProcessDescriptionNavigationQuick Reference Guide or Notes
3
Initial Setup1Review Bank Information SetupReview the branch information, addingbranch address information, and adding branch contact information.
Navigation > Banking > Banks and Branches > Bank InformationSetup by SBCTC
4
Initial Setup2Review External Account SetupReview the external account information, contacts, account reconciliation, collection methods, payment methods, additional payment methods and settlement instructions.Navigation > Banking > Bank Accounts > External AccountsSetup by SBCTC
5
Process Bank Statement File3Import Bank StatementThe 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.Navigation > Banking > Bank Statements > Import Bank Statementshttp://ctclinkreferencecenter.ctclink.us/m/79737/l/928806-9-2-import-bank-statements
6
Review Bank Statement Files4Review Bank Statement FilesThe 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.Navigation > Banking > Bank Statements > Review Bank Statement Fileshttp://ctclinkreferencecenter.ctclink.us/m/79737/l/928807-9-2-review-bank-statement-files
7
Review Bank Statements5Review Bank StatementsUse 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.Navigation > Banking > Bank Statements > Review Bank Statementshttp://ctclinkreferencecenter.ctclink.us/m/79737/l/928817-9-2-review-bank-statements
8
Create a Manual Bank Statement6Enter Bank StatementsAfter 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.Navigation > Banking > Bank Statements > Enter Bank Statementshttp://ctclinkreferencecenter.ctclink.us/m/79737/l/928811-9-2-entering-bank-statements
9
Performing Automatic Bank Reconcilitation7Process Bank ReconciliationUse 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.Navigation > Banking > Reconcile Statements> Process Bank Reconciliationhttp://ctclinkreferencecenter.ctclink.us/m/79737/l/928808-9-2-running-process-reconciliation
10
Process Bank Statement Accounting8Bank Statement AccountingBank 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.Navigation > Banking > Administer Banking > Bank Statement Accountinghttp://ctclinkreferencecenter.ctclink.us/m/79737/l/928810-9-2-process-bank-statement-accounting
11
Performing Semi-Manual Reconciliaiton9Semi-Manual ReconciliaitonUse 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 hardcopy bank statement online.Navigation > Banking > Reconcile Statements> Semi-Manual Reconciliationhttp://ctclinkreferencecenter.ctclink.us/m/79737/l/928809-9-2-performing-semi-manual-reconciliation
12
Performing Manual Reconciliaiton10Manual ReconciliaitonUse 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.Navigation > Banking > Reconcile Statements> Manual Reconciliationhttp://ctclinkreferencecenter.ctclink.us/m/79737/l/928814-9-2-perform-manual-reconciliation
13
Create an Accounting Template for External Transactions11 Accouning TemplatesThe 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.

Navigation > Cash Management > Treasury Accounting > Accounting Templateshttp://ctclinkreferencecenter.ctclink.us/m/79737/l/928833-9-2-create-an-accounting-template
14
Approve Treasury Accounting Entries12View/Approve EntriesUse the View/Approve Entries page to approve accounting entries that are awaiting review.Navigation > Cash Management > Treasury Accounting > View/Approve Entrieshttp://ctclinkreferencecenter.ctclink.us/m/79737/l/928835-9-2-view-and-approve-accounting-entries
15
Modify Treasury Accounting Entries13Accounting EntriesUse the Accounting Entries page to review, modify, and approve automated accounting entries.Navigation > Cash Management > Treasury Accounting > Accounting Entrieshttp://ctclinkreferencecenter.ctclink.us/m/79737/l/1080331-9-2-review-and-modify-accounting-entries
16
Create External Transactions14External TransactionsUse 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.Navigation > Banking > Reconcile Statements> External Transactionshttp://ctclinkreferencecenter.ctclink.us/m/79737/l/1076652-9-2-create-external-transactions
17
Process Automated Accounting15Automated AccountingThe 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. Navigation > Cash Management > Treasury Accounting > Automated Accounting http://ctclinkreferencecenter.ctclink.us/m/79737/l/1201716-9-2-running-the-automated-accounting-process
18
Review the Treasury Table (Manual Recon)16Treasury Entries to GLReview 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.
Navigation > Reporting Tools > Query > Query Viewer http://ctclinkreferencecenter.ctclink.us/m/92912/l/1173739-ctclink-peoplesoft-query-reporting-training-manual
19
Treasury to GL17System Journal Generator Process - NightlyProcess interfaces treasury transactions to the General Ledger module.
20
Next Day, Review the General Ledger Table (Manual Recon)18General Ledger Entries to GLConfirm 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
Navigation > Reporting Tools > Query > Query Viewer http://ctclinkreferencecenter.ctclink.us/m/92912/l/1173739-ctclink-peoplesoft-query-reporting-training-manual
21
Perform Book to Bank Reconciliation19 Book to Bank ReconciliationBook-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.Navigation > Banking > Reconcile Statements> Select Book to Bank Statementshttp://ctclinkreferencecenter.ctclink.us/m/79737/l/1095098-9-2-perform-book-to-bank-reconciliation
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100