cash journal and electroni BRS

[Former Member]

Hi ,

I am sunitha , plz tell me the basic steps for cash journal and electronic BRS .

Thank you.

Regards,

sunita.

[Former Member · Accepted solution]

HI

CASH JOURNAL

IMG/FA/BANK A/C / BUS TRANS/ CASH JOURNAL

1. Create GL a/c for Cash Journal – Ensure post automatically is on, so that posting can take place automatically. [ 100000 Petty Cash A/c ]

2. Define doc types for Cash Journal Docs - SK [other doc types SA GL, DZ Customer Receipt, KZ Vendor Payment] [ OBA7 ]

3. Define No range & interval for Cash Journal documents [ FBCJC1 ] - copy from 0001.

4. Setup cash journal : [ FBCJC0 ]

a. Give a Cash Journal Code

b. Various code for GL A/c’s, Customers, Vendors.

5. Create, Change, Delete Business Transactions [ FBCJC2 ] : These tran types can be copied, but as they are linked to GL a/c’s, change as reqd. These can be accessed at FBCJ.

a. C receipts from bank GL a/c -

---

b. B payment ot bank GL a/c -

---

c. R Sales

For vendors & Customers, GL a/c’s need not be given, as they will be different for A/P, A/R.

6. Setup Print params [ FBCJC3 ]– copy from 0001, output device – LP01.

7. Posting - SAP/A/c/FA/GL/Doc Entry - Cash Journal Posting FBCJ

BANK RECONCILIATION STATEMENT

SAP/FA/Banking/MasterData/BankMasterData

• FI01 create. Instead of the above, you can also create the house bank thru IMG/FA/BankAccounting/BankAccounts

• Define house bank - When the house bank is entered, click create button to create. The other details on left like bank a/c con be copied wherever possible.

• IMG/FA/ARAP/BT/IP/AutoIP/Payment Method/Bank selection for payment prg

o Setup all co codes for payment transactions

 FPJ customers

 FP vendors

o Setup paying co codes for payment transactions

 Copy from …..

o Setup payment methods per country for payment transactions

 Copy IN cheque exists

 Possible currencies - include all possible currencies. If not set, payment cannot be made in that currency.

o Setup payment method per co code for payment transactions

 C cheque

 Ranking order 1

 Min & max amounts for payment

 Optimize using postal code for faster searches.

o Setup bank determination for payment transactions

 Bank a/c create

 Available amounts for C

 Value dates

• IMG/FA/ARAP/BT/OP/AutoOp/PaymentMedia/CheckManagement

o Define no ranges for cheques

o Pass some bank entries thru FBCJ [cash journal]

• SAP/AC/Treasury/CashManagement/Incomings/ManualBankStatement

o FF67 enter

 Beginning balance = 0

 End balance = total or earlier entry

 In Further Processing keep Bank Posting  ON.

 The difference enter into the statement with +=dr & -=cr

 Save statement.

 Post statement from Bank Statement TOP.

o FEBA post process. Value date is important, as the matching takes place as per the value dates.

Assign Points

Z

[Former Member]

Just give me test mail to kishore_bachina@yahoo.com,so that i can forward you the documents of BRS.

Thanks

kishore

[Former Member]

Hi,

Please find the below info.

Step1: Create account symbols for the main bank and the sub accounts

Step2: Assign accounts to account symbols

Step3: Create keys for posting rules

Step4: Define posting rules

Step5: Create transaction type

Step6: Assign external transaction type to posting rules

Step7: Assign Bank accounts to Transaction types

also check https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/a97fa590-0201-0010-04ba-bee...

http://help.sap.com/bp_bblibrary/500/Documentation/J03_BankStmt_EN_US.doc

http://iris.tennessee.edu/BPP/FI/Cash%20Management/FI_CM_FF.5%20Import%

http://www.sap-img.com/financial/customizing-an-electronic-bank-reconciliation-statement.htm

Regards,

Murali

[Former Member]

Hello,

For Cash Journal Setup, follow the following steps:

1. Create Cash Journal G/L account(T. Code FS00)

2. Define Document Types for Cash Journal Document (T. Code OBA7)

3. Define Number Range Intervals for Cash Journal Document (T Code FBCJC1)

4. Setup Cash Journal (T Code FBCJCO)

5. Create Business Transactions ( T. Code FBCJC2)

6. Set up print parameter ( T Code FBCJC3)

The path for these steps are defined as:

IMG > Financial Accounting > Bank Accounting >Business Transactions > Cash Journal

Please assign points if found useful.

Regards

Mayank

[Former Member]

Hi Sunita,

For BRS

Path:IMG\Fin.A/cng\Bank A/cing\BT\PaymentTransactions\Manual Bank Statement\

1.Create A/c symbols and assign GL accounts to it.

2. For automatic posting, Create Keys and define posting rules for these keys.

For Electronic BRS.

in addition to the above you need to

1. Create a Transaction Type and Assign External Transaction Types to Posting Rules

2. Assign Bank account to transaction Type.

Cash Journal:

Path: IMG\Fin.A/cng\Bank A/cng\BT\Cash Journa\

Create Business Transactions at FBCJC2 and specifiy GL accounts

Post these Transactions at FBCJ