BANK RECONCILIATION
Check Deposit Bank statement
| |
-------------------- ------------------
| | | |
Manual Electronic Manual
Electronic
Manual check deposit /manual bank
statement
For each current account we have to
create ¾ accounts
Account
no. should with
- Main bank account 0
- Check issue account Open item 1
- Check deposit A/c Open item 2
- clearing account Open item 3
- Bank Changes
If
we have 100 Bank current accounts instead of assigning accounts 100 times –we
assign only one time using masking.
1.
Main bank account +++++++++0
2.
check issue account +++++++++1
3.
check deposit a/c +++++++++2
4.bank
charges +++++++++4
Always
main bank account balance and bank statement balance will be same.
Flow:
Sales:
- Sales invoice
posting F-22
Customer A/c Dr 100000
To
Sales 100000
- Check deposit
A) Bank key
B) Bank account
C) Pay slip no.
D) Transaction type
E) Customer
F) Bill no.
G) Amount and Save
IDBI
Check deposit a/c Dr 100000
To Customer with clearing 100000
3. Enter manual bank statement
A) If the check deposit credit
is not there –open items in bank check deposit A/c-Checks
Deposited but not credited
B) If the check deposit credit
comes in bank statement
A) Pay slip no.
B) Bank key
C) Bank account
D) Transaction type
E) Amount and save
IDBI
main bank A/c Dr
To IDBI Check deposit a/c 100000
(with clearing)
Purchases :
4.
Purchase invoice posting F-43
Inventory RM Dr
To
Party A/c 200000
5 Outgoing payment with
clearing F-53
Party A/c Dr with clearing 200000
To IDBI check issue A/c 200000
- Manual check creation
Assign check no.to payment doc.no.
- Enter manual bank
statement
A) If the check debit is not
there open items in bank check is issue A/c check issued but not presented.
B) If the check issue debit is
there
A) Bank key
B) Bank account
C) Transaction type
D) Check number
E) Amount and save
IDBI
check issue Dr with clearing 200000
To IDBI Bank a/c 200000
Bank
charges direct debits
- Enter manual bank
statement
A) Bank Key
B) Bank account
C) Transaction type
D) Amount and save
Bank charges Dr 5000
To IDBI main bank a/c 5000
IDBI
main bank A/c IDBI bank
statement
3 10000 7 B) 20000 7 B) 20000 3 B) 100000 Cr
8) 500 8) 500
DR
IDBI
check Dept A/c
2.
100000 3. 100000
IDBI
Check issue A/c
7
B) 20000 5 20000
1. Creation of GL masters (FS00)
Give the GL A/c no. :200130
Wages A/c
Company code :AML
Select with template button
Give the GL A/c no.200105 SBI A/c
Company code :AML
Enter
Change short text and GL Account long text to IDBI main
bank
Save
GL A/c No. :200131
Company code :AML
Select with template button
Give the GL A/c NO.200130
Company code :AML
Enter
Change short text and GL A/c long text to IDBI check
issue
Select control data tabs
Select open item
management check box
Save
GL A/c No. :200132
Company code :AML
Select with template button
Give the GL A/c No. :200131
Company code :AML
Enter
Select type/description tab
Change short text and GL A/c long text to IDBI check
deposit
Save
GL A/c No. :400304
Company code :AML
Select with template button
Give the GL A/c No. :400300
Rent A/c
Company code :AML
Enter
Change GL A/c short text and GL A/c long text to Bank
charges
Save
Define House Bank (FI12)
Give the company code :AML
Enter
Select new entries button
House bank :IDBI
Bank country :IN
Bank key :AMLIDBI1
Save
Give the name IDBI bank limited
Street :Bank Street
City :Hyderabad
Bank branch :Main
branch
Enter
Press enter to save in your request
Double click on bank accounts folder
Select new entries button
Account ID :IDBI1
Description :IDBI
current no.1
Bank account no. :AMLIDBI1234
Currency :INR
GL A/c No. :200130
IDBI Main bank
Save
- Creation of Check lots (Tr code is FCHI)
Give the paying company code :AML
House bank :IDBI
Account ID :IDBI1
Select change status button
Select create button (shift+F5) beside details button
Lot no. :1
Check no. :100001
To no. :100100
Select non-sequentional check box
Short information :IDBI
bank
Purchase date :Today’s
date
Enter and save
Define posting keys and posting rules
for check deposit
Path
:SPRO-Financial accounting –Bank accounting –Business transactions –Check
deposit –Define posting keys and posting rules for check deposit
Chart of accounts :AML
Enter
Select new entries button
Accounts symbol :AMLA
Text :Main
Bank
Accounts symbol :AMLB
Text :check
issue
Accounts symbol :AMLC
Text :Check
deposit
Accounts symbol :AMLD
Text :Bank
charges
save
press enter to save in your request
double click on assign accounts to account symbol folder
select new entries button
accounts symbol :AMLA
Account
symbol Currency GL A/c
AMLA INR +++++++++0 (9 times
plus)
AMLB INR +++++++++1 (9 times
plus)
AMLC INR +++++++++2 (9 times
plus)
AMLD INR 400304 –Bank
Charges A/c
Save
Double
click create keys for posting rules folder
Select
new entries button
Posing
rule Text
AML1 Check
receipt –Clear customer
AML2 Check
deposit clearing in Bank
AML3 Check
issue clearing in Bank
AML4 Bank
charges direct debit by banks
Save
Double
click on define posting rules folder
Select
new entries button
Notes:
Check receipt –clear customer
AML1-Check receipt clear customer
IDBI check deposit Dr GL
To Customer
–with clrg SL
Doc.Type DZ
Posting
rule :AML1
Posting
area :select
2 sub ledger accounting
Debit
posting key :40
Account
symbol :AMLC
(check deposit)
Document
type :DZ
Posting
type :select
8 sub ledger a/c
Select
next entry button
Posting
rule :select
AML2 (check deposit clearing in bank)
Notes:
AML2 :Check
deposit clearing in bank
IDBI1 Main account Dr GL
To IDBI check
deposit with clearing GL
Doc .type :SA
Posting
area :select 1
Bank accounting
Debit
posting key :40
Accounts
symbol :AMLA main bank a/c
Document
type :SA (GL account document)
Posting
type :select 5 clear credit GL Account
Select
next entry button
Posting
rule :AMLB check issue clearing in bank
AML3 Check issue clearing in Bank
IDBI check issue with clrg DR GL
To IDBI main bank A/c
Doc .type :SA
Posting
area :select
1 bank accounting
Debit
account symbol :AMLB
Credit
posting key :50
Account
symbol :AMLA Main bank
Document
type :SA
Posting
type :select 4
clear debit GL Account
Select
next entry button
Posting
rule :AML4 Bank
charges :Direct debit by bank
Bank
charges Dr GL
To IDBI Main bank A/c GL
Doc type :SA
Posting
area :select 1
Bank accounting
Debit
posting key :40
Account
symbol :AMLD
Credit
posting key :50
Account
symbol :AMLA
Document
type :SA
Posting
type :select 1 post to GL A/c
Save
Create and assign business
transactions :
Path :Up to
business transactions the path is same –Check deposit –Create and assign
business transactions (Tr code is OT53)
Select new entries button
Transaction :AML1
+/- :+
Posting rule :AML1
Text :Check
receipt clear customer
Transaction :AML1
+/- :-
(for posting revenues)
Posting rule :AML1
Text :Check
receipt clear customer reversal
Select save button
Select cancel button
Select Yes button
Save
Press enter to save in your request
Define variants for check deposit
Same
path ( Tr code is OT45)
Select
create button
Variant
:AML1
Name
:check
deposit variant for AML
Enter
From
the possible fields column
Double
click on reference document no.(selection)
Enter
|
Column
|
Offset
|
Length
|
|
1
|
3
|
|
|
2
|
20
|
16
|
|
3
|
37
|
4
|
|
4
|
52
|
10
|
Save
Select
create request button
short
description :Work Bench request for
AML
Enter
press
enter to save in your request
kept
the customer on AML1
select
activate button
create and assign business truncation for manual bank statement
path :up to
business truncation the path is same –Payment transactions –manual bank
statement –Create and assign business transactions
select
new entries button
|
Transaction
|
+/-
|
Posting rule
|
Interpretation algorithm
|
Text
|
|
AML2
|
+
|
AML2
|
|
Check
deposit
|
|
AML2
|
-
|
AML2
|
|
Check
deposit clearing in bank reversal
|
|
AML3
|
-
|
AML3
|
011
(Outgoing check :Check no. different from payment doc.no.
|
Check
issue clearing in Bank
|
|
AML3
|
+
|
AML3
|
11
|
Check
issue clearing in bank (Reversal)
|
|
AML4
|
-
|
AML4
|
|
Bank
charges direct debit by bank
|
|
AML4
|
+
|
AML4
|
|
Bank
charges direct debit by bank (reversal)
|
Save
Press
enter to save in your request
011-
Check no. different from payment doc.no. purchases
1.
Purchase
invoice posting F-43
Inventory RM DR 200000
To
Party A/c 200000
Doc
no.1
2.
Outgoing payment with clearing F-53
Party A/c DR with clearing 200000
To IDBI Check issue A/c 200000
Doc no.200001
3.
Manual check creation FCH5
Assign check no. to payment doc no.
Assign check no.100001 to payment
Doc no.200001
Check
no. and payment Doc no. are different
Define variants for manual bank
statement
Same
path (Tr cod is OT43)
Select create button
Variant :AML2
Name :Manual
bank statement variant for AML
Enter
From the possible fields column double click on reference
doc .number (selection)
Enter
4the column (20+16) :36
From the possible field column double click on bank reference
Enter
From the possible fields column double click on business
area
Enter (53+13+4):67
Save
Press enter to save in your work bench request
Keep the cursor on AML2 :select
activate button
To make text
field optional field for field status groups G001 and G005 (Tr code is OBC4)
Select field status variant :AML
Double click on field status group folder
Double click on G001
Double click on general data
Text make it optional entry field
Save
Press enter to save in your request
Double click on G005
Double click on General data
Text make it optional entry field
Save
SALES
Sales invoice posting (F-22)
Give the document date :Today’s
date
Type :DR
Company code :AML
Posting key :01
Reference bill no. :2345
Account :6600001
Enter
Amount :100000
Business area :AMLH
Text :Sales
invoice posting
Posting key :50
Account no. :300000
Sales a/c
Enter
Amount :*
Business area :AMLH
Text :+
Document –simulate & Save
Manual check deposit
Path
:Accounting –financial accounting –Banks –Incomings –check deposit –manual
entry (FF68)
From the menu select settings à Specifications
Start variant :select
AML1
Enter
Bank key :AMLIDBI1
Bank account ;AMLIDBI1234
Currency :INR
Group :1
(paying slip no.)
Transaction :select
AML1 (check receipt clear customer )
Posting date :Today’s
date
Value date :Today’s
date
Currency :INR
Enter
Amount :100000
Reference no. :2345
(bill no.)
Business area :AMLH
Customer no. :6600001
Enter & save
Save once again
From the menu select System –>services à Batch input à Sessions à select session name
:IDBI-IDBI1
Select process button
Select Display errors only radio button
Select process button
We get a message processing of batch in put session
completed
Select exit batch input button
Go and See the customer A/c
FBL5N
Give
the customer no.6600001
Company
code :AML
Select
cleared items radio button
Select
normal items check box
Execute
Double
click on type DZ
Select
column document overview button
Check deposit credit in bank statement
Path
:Accounting –Financial accounting –Banks-Incoming –Bank statement –manual entry
(Tr code is FF67)
From
the menu select settings –specifications
Start variant :select
AML2
Enter
Bank key :AMLIDBI1
Bank account :AMLIDBI1234
Currency :INR
Give the statement no. :1
Statement date :Today’s
date
Opening balance :0
Closing balance :100000
Posting date :Today’s
date
Enter
Ignore the warning message press enter
Transaction :select
AML2 check deposit in bank
Value date :Today’s
date
Amount :100000
Give the reference doc no. :1 (That is paying slip no.)
Business area :AMLH
Enter & Save
Save once again
From the menu select System –Services –Batch input àsession
Select session name :IDBI
–IDBI1
Select process button
Select display
errors only radio button
Select process button
Ignore the message and exit batch input button
Go and see
the IDBI check deposit A/c (FBL3N)
Give GL A/c No. :200132
Company code :AML
Select cleared items radio button
Select normal items check box
Execute
Double click credit 100000
Select call up document overview button
1. Purchases
Purchase invoice posting F-43
Give the document date :Today’s
date
Type :KR
Company code :AML
Posting key :31
Account no. :4200001
Enter
Give the amount :20000
Business area :AMLH
Text :Purchase
invoice posting
Posting key :40
Account no. :200120
Inventory RM
Enter
Amount :*
Business area :AMLH
Text :+
Document –Simulate and Save
2. Outgoing
payment with clearing (Tr code is F-53)
Give the document date :Today’s
date
Type :KZ
Company code :AML
Clearing text :Outgoing
payment
Account under bank data :200131
(IDBI cheque issue date)
Business area :AMLH
Amount :20000
Text :Outgoing
payment
Account under open item selection :4200001
Select process open item button
Double click on payable amount :20000
From the menu select Document --Simulate & Save
3. Manual
check creation (FCH5)
Give
the check no.100010
Save
4. Enter
manual bank statement (FF67)
Select
overview button (F8)
Keep the cursor on AML IDBI Bank Ltd
Select new statement button
Closing balance (100000-20000)=80000
Posting date :today’s
date
Enter
Transaction :AML3
check issue clearing in Bank
Value date :today’s
date
Amount :20000
with minus
Bank reference :100010
(cheque no.)
Business area :AMLH
Enter
Select save button , save once again
From the menu select System –Service –Batch input
–Sessions
Select session name :IDBI-IDBI
Select process button
Select Display errors only radio button
Select process button
Ignore the message exit batch input button
Go and see IDBI cheque issue account (FBL3N)
Give the GL account :200131
IDBI cheque issue account
Company code :AML
Select cleared items radio button
Select normal items check box
Execute
Double click on debit 20000
Select call up document overview button
Bank charges Direct debits
Enter manual bank statement FF67
Select overview button
Keep the cursor on AML IDBI Bank Ltd
Select new statement button
Give the closing balance :79500
Posting date :Today’s
date
Enter
Transaction :AML4
Bank charges direct debits
Value date :Today’s
date
Amount :500-
Business area :AMLH
Enter & Save
Save once again
From the menu select System –Services –Batch input
–Session
Select session name :IDBI –IDBI-1
Select process button
Select display errors only radio button
Select process button
Ignore the message and select exit batch input button
To view the document posted (FB03)
Enter
To
view bank statements in SAP FF67
Select
overview button
Double
click on AML IDBI Bank Ltd
To view the transactions in the
statement
Double
click on statement no.
can anyone pls share few Multiplechoice questions with Answers on Reconciliation in SAP
ReplyDelete