Difference between revisions of "Accounting Finance:Cash Book General Ledger Transactions"

From uniWIKI
Jump to navigation Jump to search
(Created page with "==Course Audience== *This course has been designed for: -Accounting (applicable individuals) ==Course Pre-requisites== *Must have completed the following courses: -FIN-GL-0...")
 
m
 
(2 intermediate revisions by one other user not shown)
Line 1: Line 1:
==Course Audience==
+
==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 course has been designed for:
 
 
*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.
-Accounting (applicable individuals)
 
 
*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 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'''
 
[[File:GLT3.png|400px]]
 
*Double-click on uniPHARM ASW 4.80B.
 
[[File:GLT4.png|400px]]
 
   
 
==Cash Book Entry Process==
 
==Cash Book Entry Process==
Line 48: Line 13:
 
#Click '''enter'''
 
#Click '''enter'''
 
[[File:GLT6.png|400px]]
 
[[File:GLT6.png|400px]]
*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.
 
   
 
*Change document type '''GLC'''
 
*Change document type '''GLC'''
Line 95: Line 57:
 
*Click '''enter''' to update the postings in the General Ledger
 
*Click '''enter''' to update the postings in the General Ledger
 
[[File:GLT12.png|400px]]
 
[[File:GLT12.png|400px]]
 
==Exercise #1==
 
*Enter a cash book general ledger transaction to record a bi-weekly payroll posting.
 
*Enter transaction ref '''PAYROLL'''
 
   
   

Latest revision as of 15:25, 5 October 2017

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.

Cash Book Entry Process

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

GLT5.png

  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

GLT6.png

  • 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

CBE1.png

  • 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

GLT7.png

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

GLT8.png

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

GLT9.png

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

GLT11.png

  • Click enter to update the postings in the General Ledger

GLT12.png