do.070 mog cash management enhancements - 02-03-2016

8/16/2019 DO.070 MOG Cash Management Enhancements - 02-03-2016

1/45

4 i a p p s . c o m0

4i Apps Solutions

4i Apps

Solutions

Submitted to

DO.070 MOG Cash Management Enhancements

Author:

Creation Date: !eb "#$ "0%&

'ast (pdated: !eb "#$ "0%&

)ersion: %.0

4i Apps Solutions

INDIA | UAE | OMAN |QATAR | USA


2/45

4i Apps Solutions

4 i a p p s . c o m"

*able o+ Contents

TABLE OF CONTENTS............................................................1

1. BANK ACCOUNT MODEL.....................................................2

2. BANK ACCOUNT BALANCES AND INTEREST CALCULATIONS11

".% ,A-S SEC(/*1 23A/D:...............................................................%%

3. BANK ACCOUNT TRANSFERS............................................30

.% ,A- ACCO(-* */A-S!E/S:...........................................................0

4. SUBLEDGER ACCOUNTING...............................................23

4.% S(,'EDGE/ ACCO(-*-G:................................................................"

5. BANK STATEMENT RECONCILIATION.................................30

5.% ,A- S*A*EME-* /ECO-C'A*O-:....................................................0

6. MULTI-ORG ACCESS CONTROL AND SECURITY...................11

&.% MOAC A-D SEC(/*1:....................................................................%%

7. CASH POOLING...............................................................11

7.% CAS6 OO'-G:..............................................................................%%


3/45

4i Apps Solutions

4 i a p p s . c o m


4/45

4i Apps Solutions


R12 C!" M#$%&%#' E#"#(%&%#'!.

B#)!*B#) B+#("%!*B#) ((,#'!.

B#)! !%(+'/ +

B#) T+#!%+!.

B#) ((,#' !$##$ '",+'/.

S %$%+ A((,#'#$.

A',&'( R%(,#(',#.

C!" F,+%(!'#$.

C!" P,,#$.


5/45

4i Apps Solutions


%. ,A- ACCO(-* MODE'

http://apps2fusion.com/images/docs/anilpassi/R12-Oracle-Cash-Management.pdf

De8nes and trac9s all ban9 account in+ormation in a central place

roides o;nership o+ ban9 accounts b< legal entities ;ith the

option to grant account use to Operating (nit =a$ 'egal Entit< =*reasur$ ,usiness Group =a

Grants eplicitl< account access to multiple operating

units?+unctions and users

(ses Multi@Org Access and (M@based securit<

Each ,an9 account is associated ;ith a ,an9 and ,an9 ,ranch

de8ned in OracleBs common *rading Communit< Architecture =*CA>

resulting in Centralied maintenance. *CA is not isible to endusers.

BANK ACCOUNT MODEL INTEGRATION


6/45

4i Apps Solutions

4 i a p p s . c o m&

*rading Communit<

Architecture =*CA>

,an9

,an9 ,ranch

BANK ACCOUNT MODEL BENEFITS

/educes number o+ access points to manage ban9 accounts

Centralies user inter+ace

mproes isibilit< and control o+ ban9 accounts

Cash Managementa


7/45

4i Apps Solutions


Simpli8es ban9 reconciliation

roides reconciliation o+ a single ban9 statement across multiple

Operating units

ncreases percentage o+ automaticall< reconciled transaction

Adds eibilit< b< using ban9 account leel reconciliation

parameters

B#) A((,#' M,% S&&+/

Single ban9 account can be used across dierent organiations and

+unctions

Centralied maintenance

Eplicit usage permission

Simpli8ed reconciliation


8/45

4i Apps Solutions

4 i a p p s . c o mF

Cross@unit reconciliation

,an9 account leel reconciliation parameters

B#) A((,#' M,% S%' # P+,(%!!

P/+, C!" M#$%&%#'T+%!+/

De8ne ,an9s

De8ne ,an9 ,ranches

1es De8ne ,an9

Counterparties

and lin9 to ,an9

,ranches


9/45

4i Apps Solutions

4 i a p p s . c o m#

*reasur< (se

-O

1es

a

S


10/45

4i Apps Solutions

4 i a p p s . c o m%0

C+%'% B#)- I#,+&',#


11/45

4i Apps Solutions

4 i a p p s . c o m%%

C+%'% B#)- A+%!!

C+%'% B#) A+%!!


12/45

4i Apps Solutions

4 i a p p s . c o m%"

C+%'% B+#("

C+%'#$ B+#("


13/45

4i Apps Solutions

4 i a p p s . c o m%

B#) B+#(" #,+&',#

B+#(" A+%!!


14/45

4i Apps Solutions

4 i a p p s . c o m%4

C+%'% B+#(" A+%!!

B+#(" A+%!! # ', !!$#% '" B+#("


15/45

4i Apps Solutions

4 i a p p s . c o m%5

S% # N%8'

C+%'% C,#'('


16/45

4i Apps Solutions

4 i a p p s . c o m%&

E&* P",#% # A+%!!

F#!"


17/45

4i Apps Solutions

4 i a p p s . c o m%7

B#) A((,#' (+%',#


18/45

4i Apps Solutions

4 i a p p s . c o m%F

C+%'% A((,#'

A((,#' O#%+ # U!%


19/45

4i Apps Solutions

4 i a p p s . c o m%#

A'%+ !!$##$ '"% L%$ E#''/ # A((,#' !%

A((,#' #,+&',#


20/45

4i Apps Solutions

4 i a p p s . c o m"0

A((,#' C,#'+,!

C


21/45

4i Apps Solutions

4 i a p p s . c o m"%

C

A((,#' A((%!!


22/45

4i Apps Solutions

4 i a p p s . c o m""

A O+$#',# A((%!!

O%+'#$ #' !%(9( ((%!! ! $+#'%


23/45

4i Apps Solutions


C+%'#$ (,#'(' ,+ B#) ((,#' ! %

M#$% P/&%#' D,(&%#'!

C+%'%


24/45

4i Apps Solutions

4 i a p p s . c o m"4

C+%'#$ P/&%#' D,(&%#'!

P/&%#' D,(&%#' ! (+%'%


25/45

4i Apps Solutions

4 i a p p s . c o m"5


26/45

4i Apps Solutions

4 i a p p s . c o m"&

". ,A- ACCO(-* ,A'A-CES A-D -*E/ES* CA'C('A*O-S

http:??apps"+usion.com?images?docs?anilpassi?/%"@Oracle@[email protected]+

Centralies balances and interest. *rac9s balances o+ all

internal ban9 accounts in a single location.

/eports on the accumulated ban9 account interest

Allo;s manual entr< and automatic upload.

Compares actual historic s. proHected balances

roides +leible reports onscreen and through M'

roides reusable interest rate schedules

BENEFITS

mproes isibilit< o+ ban9 account balances.

Single place to maintain balances +or all internal ban9

accounts.

)eri8es ban9 account interest charges.

!leible tool to calculate interest due

mproes balance reporting

eep trac9 o+ and report on multiple balance t


27/45

4i Apps Solutions

4 i a p p s . c o m"7

,A- ACCO(-* ,A'A-CES A-D -*E/ES* CA'C('A*O-S MA-*E-A-CE

Iuer< ,an9 Accounts

Maintain -o historical-o balances

Maintainbalances o+ multipleban9 accounts

1es

Maintain historicalbalances o+ a singleaccount

Select a date

Maintain proHectedbalances o+ a single

Maintain historical ban9 account,alances o+ multipleban9 accounts

Cash osition


28/45

4i Apps Solutions

4 i a p p s . c o m"F

S(MMA/1

Manage all ban9 account balances in one place

)arious balance and oat t


29/45

4i Apps Solutions

4 i a p p s . c o m"#

. ,A- ACCO(-* */A-S!E/S

Allo;s creating$ approing$ settling and accounting +or cash trans+ers bet;een internal ban9accounts

(ses ;ith Cash ools$ 3ero ,alance Accounts =3,A> and Cash 'eeling actiities

BANK ACCOUNT TRANSFERS DESCRIPTION

roides multiple creation methods

Manual

Cash 'eeling

3ero ,alance Account =3,A>

ncludes ban9 account trans+er pa


30/45

4i Apps Solutions


Authorie ,an9)alidate ,an9 Account *rans+er

Account *rans+er

Kournalie ,an9

Account *rans+er

/eturn status a


31/45

4i Apps Solutions

4 i a p p s . c o m%

Create ban9 account trans+ers in the cash position.

/ecord cash trans+ers based on the ban9 statement actiit


32/45

4i Apps Solutions


IMPLEMENTATION CONSIDERATIONS

2here can


33/45

4i Apps Solutions

4 i a p p s . c o m

4. S(,'EDGE/ ACCO(-*-G DESC/*O-

/ule@based accounting engine: roides a common$ eible

+rame;or9 +or creating Hournal entries +or:

,an9 Account *rans+ers

,an9 Statement Cash !lo;s in Cash Management

C!" M#$%&%#' S%$%+ A((,#'#$

,an9 Account Accounting *rans+er Con8gurations

Subledger G'

Kournal

Kournal

Entries and

Accounting Accounting Entries

,alances

Eents rogram

Subledger

,alances

,an9 Kournal

Statement Entr< Setup

Cash !lo;


34/45

4i Apps Solutions


SUBLEDGER ACCOUNTING BENEFITS

/educes 8nancial reporting costs.

Allo;s multiple accounting representations +or a single business

eent.

/esoles conicts bet;een corporate and local 8scal accounting

reLuirements.

ncreases transparenc< and auditabilit


35/45

4i Apps Solutions


SUBLEDGER ACCOUNTING KEY CONCEPTS FLO<

S,+(%! E%#' (!! E%#'T/%

Create

,an9 Account *rans+er

Date ,an9 Account Cancel

Cash !lo; Amount *rans+er

,an9 Account -umber Clear

(nclear

,an9 Statement Date /ecord ,an9 Statement -umber ,an9 Statement

Cash !lo; Amount Cash !lo; Cancel

SUBLEDGER ACCOUNTING SUMMARY

!leible accounting engine.

Common eible +rame;or9 +or creating Hournal entries +or ,an9Account *rans+ers and ,an9 Statement Cash !lo;s in Cash

Management

*ransparenc< and auditabilit


36/45

4i Apps Solutions

4 i a p p s . c o m&


General 'edger: *he G' account deriation in this +eature depends on

the setup in General 'edger.


37/45

4i Apps Solutions


5. ,A- S*A*EME-* /ECO-C'A*O-

BANK STATEMENT RECONCILIATION DESCRIPTION

,an9 *ransaction Codes can be lin9ed to multiple sources.

/econciliation tolerances are:

De8ned at the ban9 account leel

Aailable as separate tolerances +or manual and auto

reconciliation

,ro9en do;n b< source +or Auto reconciliation

/econciliation can be done across operating units.

BANK STATEMENT RECONCILIATION BENEFITS

mproed EJcienc


38/45

4i Apps Solutions

4 i a p p s . c o mF

-o; part o+ ban9 setup

*ransaction Codes

Assign a transaction code to multiple transaction sources

Account Controls

/econciliation control parameters


39/45

4i Apps Solutions

4 i a p p s . c o m#

&. M('*@O/G ACCESS CO-*/O' A-D SEC(/*1 DESC/*O-

roides ban9 account maintenance securit


40/45

4i Apps Solutions

4 i a p p s . c o m40

MULTI-ORG ACCESS CONTROL AND SECURITY SUMMARY

Eisting securit< model epanded: More granular and eplicit

access and usage rights.

Shared serices center support.

ndia (SA Singapore

'egal 'egal 'egal

Entit< Entit< Entit<

ndia (SA SingaporeOperating Operating Operating

(nit (nit (nit

S#$% R%!,#!'/


6/MS

Organiational hierarch<

Set up Multi@Org Securit< ro8les

*reasur<

a


41/45

4i Apps Solutions

4 i a p p s . c o m4%

s a cash management techniLue aimed at optimiing the

balances o+ the internal ban9 accounts held at one or seeral

ban9s

s usuall< per+ormed on a dail< basis

Can be done b< transaction or b< total net end@o+@da< balances

C/EA*-G CAS6 OO'S

-otional Cash ools:

Consist o+ one concentration account and multiple sub accounts

Are used +or cash leeling similar to ero balancing ;ithout the

actual +unds moement

h


42/45

4i Apps Solutions

4 i a p p s . c o m4"

7.


43/45

4i Apps Solutions


4. Cash ooling

Manages trans+ers bet;een internal ban9s


44/45

4i Apps Solutions

4 i a p p s . c o m44

5. ,an9 Account Signing Authorities

Manages ;ho has signing authorit< on ;hich ban9 accounts


45/45

4i Apps Solutions

&. Cash ositioning ntra@da< Actiities

do.070 mog cash management enhancements - 02-03-2016

Documents