Conditional Cost Centre of the transaction in case of Expense transactions
Conditional The G/L account needs to be entered only for certain transaction types as explained below
Description Cheques Issued Bank Interest paid Cash Withdrawals Wrong debits Reversal of wrong credits Bank Charges Bank Trf Payment Direct Debit - Elect Direct Debit - Other Direct Debit - Salar Direct Debit - Tele Cheques Received Bank Interest received Cash Deposits Wrong credits Reversal of wrong debits Bank Trf Receipt Direct Credit
Input G/L Account No No No No No No No No
Yes No No No No No No No No
Yes
Bank Reconciliation Statement
2
Each transaction in the bank statement needs to be assigned the relevant transaction type as shown above in the table. For e.g. if cheque has been issued and a debit is appearing in the bank statement assign transaction type as HP01. For transaction type HP09 and HP57, it is mandatory for the user to input the G/L account. For all other transaction types selected, please do not enter any G/L account. To get the file in the txt format, first enter the data in an excel file in the above format. Make sure that there is no header row and only data in the required order. Then save the file as text file using Save as option We attach a sample excel and text file for your ready reference.
Sample data upload.xls
Sample data upload.txt
We would be using this sample data to run the BRS.
FI_ User_ Manual
Bank Reconciliation Statement
3
Step 2: Run Transaction Code ZBRS
This is the screen which appears on entering the T-Code ZBRS
FI_ User_ Manual
Bank Reconciliation Statement
4
Enter the following required fields as explained: Input - Required Fields
Field Value / Comments
Company Code
Enter the Co. Code .
House Bank
Enter the House Bank for which we have received the bank statement
Account ID Currency Statement number
Enter the Account ID indicating the specific Bank account. Each House Bank and Account ID is linked to a specific G/L account. Enter the currency in which the account is maintained Input the statement number. This is an external field and needs to be input by the user.
Statement Date Enter here the date in which the BRS is being run. Currency
Enter the currency in which the bank account is maintained
Opening Balance
Enter the opening balance of the bank statement
Closing Balance
Enter the closing balance of the bank statement
Posting Date
Enter the date on which you want to post the entries to the Bank account G/L.
Section Variant Input file- Enter txt file
FI_ User_ Manual
Always enter “HOPF” in this field Enter the path of the txt file containing the upload data. You may also browse the system by placing the cursor on the field and left clicking to locate the file.
Bank Reconciliation Statement
5
Enter the fields as described above in the table and press the ‘Execute’ button.
After entering the above fields press this “Execute” icon to process
Enter the House Bank, Account Id and other fields in this screen
Next Screen FI_ User_ Manual
Bank Reconciliation Statement
6
The message appears that the Bank Balance tallies. Press Enter
The message indicating that the balance tallies.
FI_ User_ Manual
Bank Reconciliation Statement
7
Next Screen Continue pressing Enter
FI_ User_ Manual
Bank Reconciliation Statement
8
Next Screen You can see the data getting uploaded
Data from the txt file getting uploaded
Next Screen FI_ User_ Manual
Bank Reconciliation Statement
9
You need to continue pressing Enter until the message ‘Statement/list posted’ appears on the bottom of the screen.
Message indicating the list has been posted
Step 3: Process batch input session via Transaction Code SM35 FI_ User_ Manual
Bank Reconciliation Statement
10
Please note till now the transactions have not been posted. We now run transaction Code SM35 from the SAP menu screen to process the session and post the transactions. Enter T Code: SM35
Select your session and click on this icon to Process
Select the session from this screen and click on ‘Process’ icon. The session name would be the combination of House Bank and Account ID.
FI_ User_ Manual
Bank Reconciliation Statement
11
On clicking the ‘Process’ icon, a dialog box pops up with the following Processing Mode options: Process foreground: Indicates that the session will run in the foreground on the screen. You can view them on your screen. Display errors only: Indicates that the session will run in the background and only in case of any error the system will display the particular transaction. Background: In this case, the session will run on the background and you cannot view the same
We can select any one of the options. Let us select the Process/foreground option and click on ‘Process’
Select the processing mode option here
FI_ User_ Manual
Bank Reconciliation Statement
12
Next Screen The document entry screen is displayed. Press enter to move forward.
FI_ User_ Manual
Bank Reconciliation Statement
13
Continue pressing enter. The screen will keep on changing
FI_ User_ Manual
Bank Reconciliation Statement
14
Optional step: In case after viewing a couple of transactions in the foreground you want the system to process in “Display Errors Only” mode, you can change the same by selecting System- Services-Batch Input- Display Errors only as shown below.
Option to switch to “Display Errors only” mode
FI_ User_ Manual
Bank Reconciliation Statement
15
Once all the transactions in the session are entered we see the message box on the screen ‘Processing of batch input session completed’. Press Enter.
Message indicating the processing of Batch input session completed
Press Enter
FI_ User_ Manual
Bank Reconciliation Statement
16
Next Screen All the transactions have been entered now and we see that the session line item executed no longer appears on the Session Overview screen.
However in case of any error in posting, the session line item would have remained in this screen and the number of error transactions would have been reported under the red mark icon.
In case of any error in any transaction the same would be reported under this column against the respective session name
You can check the G/L account of Main Bank account and sub Bank accounts to view the postings made.
