Bank Reconciliation

[Former Member]

Hi All,

I am working on SAP Business One 2007B PL 8.

1]]]]]]]

Does the functionality of Install "Bank Statement Processing" functionality operational. If yes then what is the process.

Kindly enumerate the steps in BRIEF.

2]]]]]]]

The Bank Statements and External Reconciliation folder in the Banking module contains

:::::::::> Reconciliation...............What is the use.

:::::::::> Manual Reconciliation............OK

:::::::::> Manage Previous Reconciliation

:::::::::> Check and Restore Previous External Reconciliation

Kindly Advice how best I can use Bank Reconciliation.

...........Jimmy

[msundararaja_perumal · Accepted solution]

Hi,

As of 2007 B PL09, bank statement processing is supported in SAP Business One 2007 B.

The application supports the following scenarios:

• Creating, posting, and internal reconciliation of those business partner incoming and outgoing payments made by direct debit or bank transfer and not already entered in SAP Business One.

• Posting and internal reconciliation of interim accounts used in payments with the payment means of bank transfer (via either the payment wizard or manual payment).

• Posting and external reconciliation of bank debits and credits, for example, bank handling charges and interest payments.

• External reconciliation of transactions already posted in SAP Business One, for example, by manual payments or the payment wizard.

For more information, see [How to Use Bank Statement Processing|https://websmp105.sap-ag.de/~sapdownload/011000358700000477822008E/HowTo_BSP_2007.pdf] in the SAP Business One documentation resource center in SAP Channel Partner Portal.

And regarding

The Bank Statements and External Reconciliation folder in the Banking module contains

:::::::::> Reconciliation...............What is the use.

This screen will be used to reconcile either gl or bp with the Bank statement

:::::::::> Manual Reconciliation............OK

:::::::::> Manage Previous Reconciliation

After doing reconciliation,incase at later stage if you find any mistake was made in the external bank reconciliation,then this screen will be used to undo/cancel those incorrect reconciliation.

:::::::::> Check and Restore Previous External Reconciliation.

This is another option where you can display and open reconciliations performed both by the users and by system(SAP B1)

IN CASE OF MANUAL BANK RECO. HOW TO IMPORT THE EXTERNAL STATEMENT.

There is one more screen which would be normally hidden,go to the main menu form settings-under Banking-Bank statements and external reconciliations-Process external bank statement.

Here you can either manually enter the bank statement or you can import the bank statement via DTW template oBankPages,

you can find the examples of the filled template under C:\Program Files\SAP\Data Transfer Workbench\Templates\Data preparation examples\10. Testcase1_Test Data for Import function\oBankPages(if you have installed SAP B1 in default path)

Hope this is helpful!

[Former Member]

Hi Jimmy......

Without installing Bank statement process you can import the bank statement and can do the recon easily.

You need to choose just Banking> Bank Statement External Internal Reconciliation> Recon.--> Manual/Automantic. Most preferable way.....

Regards,

Rahul

[Former Member]

THANKS RAHUL,

KINDLY TELL ME THE FULL STORY A LITTLE BRIEFLY.

IN CASE OF MANUAL BANK RECO. HOW TO IMPORT THE EXTERNAL STATEMENT.

THANKS FOR REPLYING......JIMMY

[former_member206488]

Dear,

You can find SAP documentation from the below link,

http://service.sap.com/smb/sbo/documentation

Also here is a collection of online help.

http://help.sap.com

Hope it help.

Regards,

Neetu