[go: up one dir, main page]
Scribd
Upload
130 views19 pages

Manual - BRS - Screen & Logic

This document provides instructions for running a Bank Reconciliation Statement (BRS) in SAP. It includes steps to retrieve bank statement data from various SAP tables based on input parameters, update document references, post clearing entries between bank accounts, and avoid including reversal documents in the reconciliation. The steps begin by retrieving account and transaction details from tables like SKA1, BSIS, and FAGLFLEXA, then provide FM programs for updating references and posting journal entries to complete the reconciliation in SAP.

Uploaded by

mayoor
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
130 views19 pages

Manual - BRS - Screen & Logic

This document provides instructions for running a Bank Reconciliation Statement (BRS) in SAP. It includes steps to retrieve bank statement data from various SAP tables based on input parameters, update document references, post clearing entries between bank accounts, and avoid including reversal documents in the reconciliation. The steps begin by retrieving account and transaction details from tables like SKA1, BSIS, and FAGLFLEXA, then provide FM programs for updating references and posting journal entries to complete the reconciliation in SAP.

Uploaded by

mayoor
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 19

Company Code 1000 BSIS - BUKRS

Bank GL Range From To SKA1 - KTOPL = 3000, SKA1 - SAKNR = GL Range


Posting Date From To BSIS - BUDAT
Test Case
3000
21500000 21500002
01.04.2020 31.03.2020
Main Bank GL Name of Main Bank GL 10001
Posting date From TO
Opening Balance As per SAP 120,000.00

Receipts Bank GL Name of Receipts Bank GL 10002


Company Code Doc No. Actual Amount
1000 Doc1 100,000.00
1000 Doc2 250,000.00
1000 Doc3 500.00
1000 Doc4 60,000.00
Total Receipts as per SAP 410,500.00
Receipts as per Bank Statement 160,500.00

Receipts Bank GL Name of Receipts Bank GL 10002


Company Code Narration Actual Amount
1000 ABCD 100,000.00
1000 XYZ 250,000.00
1000 TYUU 500.00
1000 SHDD 60,000.00
Total Receipts as per SAP 410,500.00

Payments Bank GL Name of Payment Bank GL 10003


Company Code Doc No. Actual Amount
1000 Doc1 -500.00
1000 Doc2 -64,000.00
1000 Doc3 -100,000.00
1000 Doc4 -23,000.00
Total Payments as per SAP -187,500.00
Payments as per Bank Statement -87,500.00
Closing Balance as per Bank 193,000.00

Update Ref. Icon


Part 4
Run BRS Icon
Posted Amount Currency Dr / Cr Posting Date Fiscal Year
100,000.00 INR Dr
200,000.00 INR Dr
500.00 INR Dr
50,000.00 INR Dr

Posted Amount Currency Doc Date Posting Date Fiscal Year


100,000.00 INR
250,000.00 INR
500.00 INR
60,000.00 INR

Posted Amount Currency Dr / Cr Posting Date Fiscal Year


-500.00 INR Cr
-64,000.00 INR Cr
-100,000.00 INR Cr
-23,000.00 INR Cr
Bank Ref. Statement Date Matched with Bank Statement Status
Yes

Yes
Yes

Bank Ref. Statement Date Matched with Bank Statement Status


Yes
Yes

Yes
Part 1

GL
F-28 Acct.Entry
Reciept-Bank DR 10002
Customer Account CR

Part 2
FF67 Acct.Entry
Main Bank DR 10001
Reciept-Bank CR 10002

Part 3
FF67 Acct.Entry Assignment
Main Bank DR ABCD
Reciept-Bank CR ABCD

F-53 Acct.Entry
Vendor DR
Payment-Bank CR

Part 4
FF67 Acct.Entry
Main BANK CR
Payment-Bank DR
F-28 Acct.Entry
Reciept-Bank DR
Customer Account CR

10001
10002

10003

10001
10003
Main Bank GL
Name of Main Bank GL
Posting date
Part 1

Opening Balance As per SAP

Receipts Bank GL
Name of Receipts Bank GL
Company Code

Doc No.

Amount
Part 2 Currency

Dr / Cr
Posting Date
Fiscal Year

Profit Center
Bank Ref.

Statement Date
Matched with Bank Statement

Receipts Bank GL
Name of Receipts Bank GL
Company Code

Doc No.

Amount
Part 4 Currency

Dr / Cr
Part 4

Posting Date
Fiscal Year

Profit Center
Bank Ref.

Statement Date
Matched with Bank Statement

Update Ref.
Part 4
Run BRS

BRS document for Receipts


Document

BRS document for Payments


Document

Document Type for BRS


As per Input screen and GL ending with "0".
Pass the above GL no. in SKA1 - SAKNR with SKA1 - KTOPL = 3000 and get SKA1 - TXT50
As per Input Screen.

Pass the input parameters BUKRS in FAGLFLEXA - BUKRS , BUDAT in FAGLFLEXA - BUDAT and
SAK1 in SAKNR by considering only GL ending with "0" and get the total of FAGLFLEXA - TSL

As per Input screen and GL ending with "1".


Pass the above GL no. in SKA1 - SAKNR with SKA1 - KTOPL = 3000 and get SKA1 - TXT50
As per Input screen.

Pass the input parameters BUKRS in BSIS - BUKRS , BUDAT in BSIS - BUDAT and SAKNR in BSIS -
HKONT by considering only GL ending with "1" and get the BSIS - BENR

Pass the input parameters BUKRS in BSIS - BUKRS , BUDAT in BSIS - BUDAT and SAKNR in BSIS -
HKONT by considering only GL ending with "1" and get the BSIS - BENR and BSIS - DMBTR for
individual document with +/- sign
BSIS - BELNR & get BSIS - WAERS

BSIS - BELNR and get BSIS - SHKZG, if SHKZG = S show it as Dr, if DRCRK = H show it as Cr
Against the above documents of BSIS - BELNR get BSIS - BUDAT
Against the above documents of BSIS - BELNR get BSIS - GJAHR

Pass the parameters of above received documents BSIS - BELNR, BSIS - BUDAT & BSIS - HKONT
in FAGLFLEXA - DOCNR, FAGLFLEXA - BUDAT, FAGLFLEXA - RACCT and get FAGLFLEXA - PRCTR
Manual Input with 40 Char - Updated through excel upload
Manual Input for mentioning statement date - Should be updated in value date field while run
the BRS
Manual Input - YES

As per Input screen and GL ending with "2".


Pass the above GL no. in SKA1 - SAKNR with SKA1 - KTOPL = 3000 and get SKA1 - TXT50
As per Input screen.

Pass the input parameters BUKRS in BSIS - BUKRS , BUDAT in BSIS - BUDAT and SAKNR in BSIS -
HKONT by considering only GL ending with "2" and get the BSIS - BENR

Pass the input parameters BUKRS in BSIS - BUKRS , BUDAT in BSIS - BUDAT and SAKNR in BSIS -
HKONT by considering only GL ending with "2" and get the BSIS - BENR and BSIS - DMBTR for
individual document with +/- sign
BSIS - BELNR & get BSIS - WAERS

BSIS - BELNR and get BSIS - SHKZG, if SHKZG = S show it as Dr, if DRCRK = H show it as Cr
Against the above documents of BSIS - BELNR get BSIS - BUDAT
Against the above documents of BSIS - BELNR get BSIS - GJAHR

Pass the parameters of above received documents BSIS - BELNR, BSIS - BUDAT & BSIS - HKONT
in FAGLFLEXA - DOCNR, FAGLFLEXA - BUDAT, FAGLFLEXA - RACCT and get FAGLFLEXA - PRCTR
Manual Input with 40 Char - Updated through excel upload
Manual Input for mentioning statement date - Should be updated in value date field while run
the BRS
Manual Input - YES

Updating of Ref. in Document Assignment Field.


When this icon clicks BRS program should run

Once user click on Update Ref. icon - First we have to change the assignment field of the
document from the value entered at Bank Ref. against that document number

FB02: FM for changing documents - FI_ITEMS_MASS_CHANGE

Run BRS - After the assignment field is changed - Clearing should be happened and below
entries should be posted
For clearing T.Code is F-04: We may use below BAPI / FM
BAPI_ACC_GL_POSTING_POST
POSTING_INTERFACE_START
POSTING_INTERFACE_CLEARING
POSTING_INTERFACE_END
POSTING_INTERFACE_DOCUMENT

Bank - Main GL Dr (GL no. Ending with "0")

to Bank - Receipts GL (GL no. Ending with "1")

Bank - Payment Dr (GL no. Ending with "2")


to Bank - Main Gl (GL no. Ending with "0")

ZH
Do not consider Reversal Documents - Pass the received documents of
FAGALFLEXA - DOCNR with FAGALFLEXA - RYEAR in BKPF - BELNR & BKPF -
GJAHR and consider documents with only BKPF - XREVERSAL = BLANK.

Do not consider Reversal Documents - Pass the received documents of


BSIS - BELNR with BSIS - GJAHR in BKPF - BELNR & BKPF - GJAHR and
consider documents with only BKPF - XREVERSAL = BLANK.

Do not consider Reversal Documents - Pass the received documents of


BSIS - BELNR with BSIS - GJAHR in BKPF - BELNR & BKPF - GJAHR and
consider documents with only BKPF - XREVERSAL = BLANK.

BSIS

BSID
BSIK

Do not consider Reversal Documents - Pass the received documents of


BSIS - BELNR with BSIS - GJAHR in BKPF - BELNR & BKPF - GJAHR and
consider documents with only BKPF - XREVERSAL = BLANK.

Do not consider Reversal Documents - Pass the received documents of


BSIS - BELNR with BSIS - GJAHR in BKPF - BELNR & BKPF - GJAHR and
consider documents with only BKPF - XREVERSAL = BLANK.
BSAS GL

BSAD Customer
BSAK Vendor
Bank GL End with
21500000 0 Main GL
21500001 1 Receipts GL
21500002 2 Payments GL
21500010 0 Main GL
21500011 1 Receipts GL
21500012 2 Payments GL
21500020 0 Main GL
21500021 1 Receipts GL
21500022 2 Payments GL
21500030 0 Main GL
21500031 1 Receipts GL
21500032 2 Payments GL
21500040 0 Main GL
21500041 1 Receipts GL
21500042 2 Payments GL
21500050 0 Main GL
21500051 1 Receipts GL
21500052 2 Payments GL
21500060 0 Main GL
21500061 1 Receipts GL
21500062 2 Payments GL
21500069 9 NA
21500070 0 Main GL
21500071 1 Receipts GL
21500072 2 Payments GL
21500079 9 NA
21500080 0 Main GL
21500081 1 Receipts GL
21500082 2 Payments GL
21500090 0 Main GL
21500091 1 Receipts GL
21500092 2 Payments GL
21500100 0 Main GL
21500101 1 Receipts GL
21500102 2 Payments GL
21500110 0 Main GL
21500111 1 Receipts GL
21500112 2 Payments GL
21500120 0 Main GL
21500121 1 Receipts GL
21500122 2 Payments GL
21500130 0 Main GL
21500131 1 Receipts GL
21500132 2 Payments GL
21500140 0 Main GL
21500141 1 Receipts GL
21500142 2 Payments GL
21500150 0 Main GL
21500151 1 Receipts GL
21500152 2 Payments GL
21500160 0 Main GL
21500161 1 Receipts GL
21500162 2 Payments GL
21500170 0 Main GL
21500171 1 Receipts GL
21500172 2 Payments GL
21500180 0 Main GL
21500181 1 Receipts GL
21500182 2 Payments GL
21500190 0 Main GL
21500191 1 Receipts GL
21500192 2 Payments GL
21500200 0 Main GL
21500201 1 Receipts GL
21500202 2 Payments GL
21500210 0 Main GL
21500211 1 Receipts GL
21500212 2 Payments GL
21500220 0 Main GL
21500221 1 Receipts GL
21500222 2 Payments GL
21500230 0 Main GL
21500231 1 Receipts GL
21500232 2 Payments GL
21500240 0 Main GL
21500241 1 Receipts GL
21500242 2 Payments GL
21500250 0 Main GL
21500251 1 Receipts GL
21500252 2 Payments GL
21500260 0 Main GL
21500261 1 Receipts GL
21500262 2 Payments GL
21500270 0 Main GL
21500271 1 Receipts GL
21500272 2 Payments GL
21500280 0 Main GL
21500281 1 Receipts GL
21500282 2 Payments GL
21500290 0 Main GL
21500291 1 Receipts GL
21500292 2 Payments GL
21500300 0 Main GL
21500301 1 Receipts GL
21500302 2 Payments GL
21500310 0 Main GL
21500311 1 Receipts GL
21500312 2 Payments GL
21500320 0 Main GL
21500321 1 Receipts GL
21500322 2 Payments GL
21500330 0 Main GL
21500331 1 Receipts GL
21500332 2 Payments GL
21500340 0 Main GL
21500341 1 Receipts GL
21500342 2 Payments GL
21500350 0 Main GL
21500351 1 Receipts GL
21500352 2 Payments GL
21500360 0 Main GL
21500361 1 Receipts GL
21500362 2 Payments GL
21500370 0 Main GL
21500371 1 Receipts GL
21500372 2 Payments GL
21500380 0 Main GL
21500381 1 Receipts GL
21500382 2 Payments GL
21500390 0 Main GL
21500391 1 Receipts GL
21500392 2 Payments GL
21500400 0 Main GL
21500401 1 Receipts GL
21500402 2 Payments GL
21500410 0 Main GL
21500411 1 Receipts GL
21500412 2 Payments GL
21500420 0 Main GL
21500421 1 Receipts GL
21500422 2 Payments GL
21500430 0 Main GL
21500431 1 Receipts GL
21500432 2 Payments GL
21500440 0 Main GL
21500441 1 Receipts GL
21500442 2 Payments GL
21500450 0 Main GL
21500451 1 Receipts GL
21500452 2 Payments GL
21500460 0 Main GL
21500461 1 Receipts GL
21500462 2 Payments GL
21500470 0 Main GL
21500471 1 Receipts GL
21500472 2 Payments GL
21500480 0 Main GL
21500481 1 Receipts GL
21500482 2 Payments GL
21500490 0 Main GL
21500491 1 Receipts GL
21500492 2 Payments GL
21500493 3 NA
21500500 0 Main GL
21500501 1 Receipts GL
21500502 2 Payments GL
21500510 0 Main GL
21500511 1 Receipts GL
21500512 2 Payments GL
21500520 0 Main GL
21500521 1 Receipts GL
21500522 2 Payments GL
21500530 0 Main GL
21500531 1 Receipts GL
21500532 2 Payments GL
21530000 0 Main GL
21530001 1 Receipts GL
21530002 2 Payments GL
21530010 0 Main GL
21530011 1 Receipts GL
21530012 2 Payments GL
21530100 0 Main GL
21530101 1 Receipts GL
21530102 2 Payments GL
21530200 0 Main GL
21530201 1 Receipts GL
21530202 2 Payments GL
21530210 0 Main GL
21530211 1 Receipts GL
21530212 2 Payments GL
21530400 0 Main GL
21530401 1 Receipts GL
21530402 2 Payments GL
21530410 0 Main GL
21530411 1 Receipts GL
21530412 2 Payments GL
21530500 0 Main GL
21530501 1 Receipts GL
21530502 2 Payments GL
21530510 0 Main GL
21530511 1 Receipts GL
21530512 2 Payments GL
21550000 0 Main GL
21550001 1 Receipts GL
21550002 2 Payments GL
21550010 0 Main GL
21550011 1 Receipts GL
21550012 2 Payments GL
21550020 0 Main GL
21550021 1 Receipts GL
21550022 2 Payments GL
21569900 0 Main GL
21599998 8 NA
21599999 9 NA

You might also like