Accounting Finance:Cash Book Reconciling Bank Transactions

Course Audience

• This course has been designed for:

-Accounting (applicable individuals)

Course Pre-requisites

• Must have completed the following courses:

-FIN-GL-002 Entering General Ledger Transactions
-FIN-GL-003 Work with Cash Book General Ledger Transactions

• Must have:

-User Profile
-B-001 Orientation Training
-B-HTL-001 Basic Hotline Training

Course Components

• Classroom training - 15 mins (max)
• Practical training - 10 mins
• Daily practice (until 'go live')

Course Reference Material

• PowerPoint handout (also available on-line)
• Workflow diagram

Course Objectives

• By the end of this course, you will be able to:

-Perform a manual reconciliation of Cashbook bank transactions from a bank statement

Sign On & Startup

Sign on

• Double left-click the ASW icon on your desktop

Sign on to AS400

• Click anywhere on screen
• Enter your User Name (as assigned by the DMS Technical Administrator)
• Enter your password
• Click enter

Unity Startup Menu

• Enter 1 under option
• Click enter

• Double-click on uniPHARM ASW 4.80B.

Work with Cash Book Reconciliation

• Select ASW FastPath→Financial accounting→Reconciliation tasks→Cash Book tasks→Work with Cash book reconciliation

1. Enter bank number
2. Enter Dt (optional)
3. Enter Doc date (optional)
4. Enter Rscd (optional)
5. Enter Transaction ref (optional)
6. In the field Open you enter Y or N to switch between open and reconciled transactions
7. Click enter
8. Mark the transaction you want to reconcile and click Reconcile

Reconcile

• Change reconciled amount (optional)
• If you change the amount here 4 different situations apply:

1. If both the fields Tolerance % and Tolerance amount are left blank in the Bank table, reconciliation with difference will not be allowed.
2. If there is a value entered for field Tolerance % in the Bank table and if the value of the entered difference is less than or equal to the allowed tolerance value then reconciliation with difference will be allowed.
3. If there is a value entered for field Tolerance amount in the Bank table and if the value of the entered difference is less than or equal to the allowed tolerance value then reconciliation with difference will be allowed.
4. If the currency for the bank, defined in the Bank table, is not equal to the currency for the transaction, reconciliation with difference will not be allowed.

• Reconciliation date – today’s date will be defaulted, If you change the date it cannot be future date or a date earlier than the document date.
• Enter statement number (the statement number you entered here will be a default value for the subsequent reconciliation transaction until you enter a new. This filed is mandatory.
• Enter text (optional)
• Select confirm or press F10 to confirm the reconciliation.

• Continue working with reconciliation or press F12 to complete the reconciliation and update the General Ledger.

Exercise #1

• Create a general ledger cash book general ledger transaction.
• Create an Accounts Receivable manual cheque deposit.
• Reconcile the above transactions in work with Cash Book Reconciliation.