Intra-day bank statements in SAP

Dmitry Kaglik

December 4, 2018


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

Are SAP consultants going back to the office?

Dmitry Kaglik

October 4, 2021


No Comment

Coronavirus pandemic made a huge shift in people behaviour. SAP Consultants are not an exception here. Many of us, SAP people, left office when governments around the world decided it was not safe to be close to each other. Many companies switched to remote work model. Many of then since then decided to keep remote […]

Read More

20 Years in SAP

Dmitry Kaglik

September 3, 2021


No Comment

If you are reading this post, you are more than likely to work with SAP in one or another way. How many years have you been working with SAP? 1, 5, 10 or 25 year? Every of them is especial because it adds to your knowledge, to you expertise. You are probably aware that the […]

Read More

Leave a Reply

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

Search this site


You can subscribe to our regular updates here.


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