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.clearing account +++++++++3
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 100000
To IDBI Check deposit a/c 100000
(with clearing)
Purchases :
4. Purchase invoice posting F-43
Inventory RM Dr 200000
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, Koti
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
