Accounting Finance:Cash Book General Ledger Transactions

Overview

• The Cash Book routine supports the control of bank accounts in the General Ledger and the purposes is to specify the G/L bank accounts in order to make it easy to reconcile bank statements.
• This is obtained by the entry of Cashbook information when you handle the daily payment routine in the General Ledger, Accounts Receivable and Accounts Payable.
• This includes, for example, manual payments and receipts, deposits and A/P automatic payments. The G/L bank account will become Cash Book control accounts which ensures that only Cashbook entries will be possible to enter.

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

• 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:

-Understand how to enter a cash book general ledger transaction (i.e. payroll)

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.

Cash Book Entry Process

• Select ASW FastPath→Financial accounting→General Ledger transaction tasks→Enter financial transactions

1. Enter voucher type 50
2. Enter batch amount
3. Click enter
4. Choose a routine G/L Transactions or G/L Easy Entry Transactions
5. Click enter

• Change document type GLC
• Click enter
• Click Cash Book Entry or click F8

1. Change bank (optional)
2. Change bank currency (optional)
3. Enter bank amount
4. Enter Transaction ref (enter a reference for the transaction that will be used in the routine Work with Cash Book Reconciliation)
5. Enter text (optional)
6. Click enter

• This panel also provides you with the function key F6, Fund Transfer.
• This function key is only available from the G/L transactions entry panel.
• The fund transfer makes it possible to move amounts between different banks by creating two Cashbook entries within one voucher.
• The function enables an easy way to change the bank if the total or part of the posted amount has to be moved.

1. Enter Account
2. Enter Cost (if mandatory)
3. Enter Amount
4. Enter Text (optional)
5. Click enter twice
6. Enter next G/L transaction and click enter OR press F12 to move back to previous panel

• Tip: if you want more information on an account you have entered, mark the posting and click enter and then click F2.
• The system shows the panel Account information.
• Click F3 to return to the entry panel.

• Tip: If you want to enter unique text per accounting year, voucher type/number, mark the posting on panel G/L transaction entry and press F10.
• The system shows panel Text maintenance.
• Click F12 to return to the entry panel.

Financial System Transaction Entry

• Click F3 to end the journal

1. Mark close batch
2. Enter description (optional)
3. Change Printer queue (optional)
4. Change # of copies (optional)
5. Change Hold on spool file (optional)
6. Click enter

• Click enter to update the postings in the General Ledger

Exercise #1

• Enter a cash book general ledger transaction to record a bi-weekly payroll posting.
• Enter transaction ref PAYROLL