Unable to reconcile Amex cashiering deposits at a detail level due to bank statement format

Summary

We are wondering how the community handles reconciling bank statements if the bank can only send summary-level details.

Content

We process many point of sale transactions each month, many of which are paid for with Amex. Monthly, Amex provides us our statement of transactions we’ve received money for, and our goal in Cash Management is to reconcile these individual statement lines with the system transaction lines that will be integrated from our cashiering system.

According to Amex, the only file types they’re able to produce statements in are CSV and TSV, but Oracle does not support either of these out of the box. File types Oracle supports out of the box: BAI2, SWIFT MT100/103/940, EDIFACT FINSTA/ PAYMUL, and ISO20022.