Bank Statement

[Former Member]

Hi There!

could anyone help how to enter amount from bank statement into sap B1 2007A? I have 3 different account in 3 differenc currency, but i dont know how to enter them from bank statement! could someone provide a step by step intruction, please?

thank you

Andrea

Edited by: Andrea Suto on Jul 14, 2008 2:38 PM

[Former Member · Accepted solution]

Hi Andrea

First you will need to have defined your house banks. This is done under Administration > Setup > Banking > Banks/House Bank Accounts. Here you will be able to select the country for each bank account as well. If however, all 3 accounts are held in your local country, but in different currencies, you will need to set these accounts in the G/L to the specific currency for those accounts (under COA).

To capture your bank statements, select Process External Bank Statements from Banking > Bank statements and External Reconciliations. Choose the G/L account for your first bank account and then capture all the transactions on the bank statement. You will notice that the currency will be as per the G/L account currency.

Once your bank statements are captured, you can reconcile them by choosing Reconciliation/External Reconciliation (depends on language, country and localization). Once again select the G/L account for the bank account you want to process. You can use manual to match each line in the G/L to the external bank statement.

Bear in mind that any payment methods linked to the various House Banks must also be set in terms of currency.

Hope this helps

Kind regards

Peter Juby

[Former Member · Accepted solution]

Hi!

In the Bank Statements and External reconciliation i have the following: 1. reconciliation

2. manual reconciliation 3. manager previous external reconciliation 4. check and restore external reconciliation

this is all the option i have on sap

[Former Member]

HI

You can upload bank statement through DTW.

use bank pages template for the same.

regards

Kamlesh

[Former Member]

Hi Andrea

What is your country? I know that for South Africa that would be the menu which is different from Europe, etc.

The options you are seeing is for a different approach to the same structure. If you select Manual Reconciliation, enter the G/L account for the bank account and then set the date for the statement as well as the closing balance on that Bank statement. You will get a list of all the transactions in the G/L Account. On the right top corner you can enter the Current Bank Statement Number. On the left under the G/L Account Number, you can change the list display to only show items you have ticked or items unticked or All items. As you tick items on the list that are on your statement, the Difference at the bottom right will change, and you will only be able to select "Reconcile" once this is zero. In the interim you can use "Save" and come back to the reconciliation later. You can also post additional entries by selecting adjustments. This is useful for bank charges, etc that you might not have posted yet.

You can also use the find function to get a specific transaction. To use this double click on the column you want to search in. then start typing in the find field and this will bring all matches from that column.

And that is about it. This will post an entry to the Process External Bank Statement function in the "background". You can still use this function by going to the Form Settings whilst on the Main Menu and expanding Banking. You will notice that under the Process External Bank Statement a single line is posted for each Reconciliation done (Should be equal to 1 line per Statement Number). The system also does the External Reconciliation for you in this case.

In order to print your reconciliations, you will still have to go to the Reconciliation function and set your print settings there.

Hope this helps

Kind Regards

Peter Juby