Perform Manual Reconciliation

[Gabor5]

Hello!

During the testing of J78 test script we have arrived to the step 4.6.2 Perform Manual Reconciliation. When we open we only see one bank account an has a status of 'not applicable'. Why is that? What did we miss?

We have the neccessarry configurations. We have bank statements uploaded. 

Thanks!

[Amy_Niu]

Hello @Gabor5, The "Not applicable" status indicates that the bank account has not been reconciled and currently no bank statement flows are available for reconciliation (for example when the bank statement is not uploaded). For more information, please see: https://help.sap.com/docs/SAP_S4HANA_CLOUD/186460fdc35a4b64a713da9bb00deb1e/eb100328e8464540b2616356...

[Gabor5]

Hello Amy, the bank statement was created in the Manage Bank Statement app. It is also posted. Yet we still see it is not applicable.

[Amy_Niu]

Hello Gabor, the reconciliation is only supported for non-posted bank statement flows. Once the bank statement is posted, the bank statement flows (source application BS) will be deleted and replaced by accounting flows (source application BSEGV).

[Gabor5]

Hello Amy, can we summarize the flow somehow? First, there needs to be a bank statement created, but not posted? Then we would be able to see it in the 'Reconcile Cash Flow' app? Also, can you please expand BS (bank statement?) and BSEGV?.

[Amy_Niu]

Hello Gabor, yes you can only reconcile non-posted bank statements with forecasted cash flows using this app. Check out the following topics for more information: 

End-of-Day Bank Statement Flows

End-of-Day Bank Statements in One Exposure from Operations | SAP Help Portal

Accounting Flows

Integration of Accounting Documents | SAP Help Portal

[Jeremy_Deo]

Hello dear user,

And thank you for asking your question in the SAP Community blog.

If in step 4.6.2 Perform Manual Reconciliation you only see one bank account with status "Not Applicable", it usually means:

What likely went wrong :

• No open items to reconcile – The bank statement may have already cleared everything automatically.
• No bank statement uploaded or processed – Manual reconciliation needs posted statement items.
• Bank GL account not set as open item managed – Reconciliation requires this setting.
• Wrong filters – Could be using the wrong company code or account filter.

What to check :

• Use Manage Bank Statements to confirm a statement was uploaded and items are not cleared.
• Use Display Journal Entries to see if postings hit the bank GL.
• Use Manage G/L Account Master Data to check that the GL is open item managed.
• Review filters in Perform Manual Reconciliation.

I hope this will help you answer your question.

Best regards,

Jeremy