Skip to Content
0
Former Member
Feb 18, 2011 at 12:20 AM

Bank Statement Processing - FF_5 - FEBA - Posting Rules

1049 Views

Hi All SAP Experts !!!

I am a non SAP expert (I am a tehcnically minded accountant) trying to find out if I can find a SAP solution to my problem.

I am trying to introduce automatic processing / upload and posting of journals from electronic Bank statements from Citibank.

My particular problem is in the area of processing Cash/Customer receipts which can come from various

different external transaction types from my bank statement.

I have tested a solution whereby the e-bank statement is queried for Invoice numbers with some success but

my problem is the success depends on the accuracy and completeness of Invoice numbers provided by my cusomters.

The above solution when it works makes the following accouNting entries

Level 1 Dr Bank A/c Cr Suspense A/c (General Ledger)

Level 2 Dr Suspense A/c Cr A/R Subledger (Clearing the Customer Invoices)

Due to the lack of consistancy in results of testing I now wish to do something different

Query the same statement on the basis of Customer Name or Customer Bank Details (Bank Orig ID)

From this I would simply like to make the same level 1 posting as above but for the Level 2 posting I simply

want to leave the monies received unallocated on the subledger (ie FBO1 or Not clearing anything)

Is it possible to query the E-Bank statemnent on a name or Bank Originatiing ID and use same to map to a

Customer No within one of SAP's tables ie "Widget & Co" = Cust No 10001 in the AR subledger?

Can the above FB01 Level 2 type transaction be carried out just posting and not allocating/clearing?

Thanks a million

MJOAP40