Intra-day bank statements in SAP

Dmitry Kaglik

December 4, 2018

SAP

No Comment

When we say “Bank statement”, we most often mean the statement that bank provides to us (person or company) with a list of transactions from the past. These are the transactions that already happened on account. They affect available balance on account. They cannot be changed or back-dated.

When talking about bank statement formats, these are SWIFT MT940, BAI2 and many other country- or bank-specific formats, and even FINSTA IDOCs. SAP provides multiple options to upload these bank statement formats.

But these end-of-day statements are not the only ones that banks may provide, and they do provide. There are also intra-day statements.

These intra-day statements contain the information about transactions happening on the account during the day. They are not necessarily confirmed, as there is a chance that some issues may cause the cancellations or delays. But there’s still a chance that these transactions will make their way to the end-of-day statement, which we will receive tomorrow. There can be multiple intra-day statements covering transactions at different time intervals.

Why are they needed? Mostly for cash position reporting. If your company trade volumes are measured in millions, every single transaction may affect your cash position both in negative and positive direction. Treasury needs to plan cash position and act quickly to avoid unnecessary overdrafts and bank charges.

Another use of intra-day statement is to give the credit control team idea about customer payments. Why would you need to chase the customer payment, if your bank already informs you about the transfer to your account?

What are the formats available for intra-day statements? Just to name the most common: SWIFT MT942 plus the same BAI2, and also FINSTA IDOCs. Of course, BAI2 and FINSTA have special indicators to distinguish end-of-day and intra-day files. SWIFT MT940 and MT942 are very similar, but even they have their unique tags, which only appear in one format, but not in other.

What can you do with intra-day statements in SAP? Of course, you can import the intra-day statement files into SAP. But SAP understands that these transactions can yet be cancelled, and it does not make any postings based on intra-day information. Instead, standard SAP program can create Cash Management Memo Records (Payment advices). These memo records can then be viewed in Treasury reports.

The pre-requisite for Memo Records (Payment advices) creation are checkboxes “CM Payment advice” and “Account balance” on the selection screen of MT942 import. Another important thing to remember is that SAP only accepts SWIFT MT942 statements in “Field 86-structured” format. Is your file coming non-structured? There’s a workaround. SAP Expert will be happy to advise if you ask.

Are you using intra-day statements in your company?

Related Posts

What are IDOCs and how you can use them

Dmitry Kaglik

November 4, 2019

SAP

No Comment

IDOC, or Idoc, or IDoc. This is an abbreviation that every SAP consultant hears from time to time. What is this? It is an Intermediary Document, a format of data exchange between different systems introduced by SAP. You can use IDOCs to exchange information between different SAP systems within a landscape, between your and external […]

Read More

Working on SAP projects abroad: do you consider this?

Dmitry Kaglik

October 7, 2019

SAP

No Comment

SAP is a global company. It has presence in many countries. And this adds a possibility for SAP consultants to dream or to consider possibilities of working abroad. Have you ever thought about such possibilities? Or maybe you worked abroad in the past? Or even now? Working abroad brings its own benefits: you can explore […]

Read More

Leave a Reply

Your email address will not be published. Required fields are marked *

Search this site

Subscribe!

You can subscribe to our regular updates here.

Polls

Will you be happy to pay for the 3rd edition of the book FREQUENTLY ASKED QUESTIONS ON SAP FINANCE?

View Results

Loading ... Loading ...
Disclaimer and privacy policy