Bank Statements and Reconciliation
Discussion List
-
Way to exclude month-end interest trx in the BAI file for purposes of calc'g closing bal in recon?Summary: Bank statement reconciliation at month-end ends in warning of 'You must enter a closing balance that's the same as the added amount of the opening balance and s… -
Is the ZBA sweep transaction functionality for Cash Management available in Oracle Fusion?Summary: Is the ZBA sweep functionality available in Oracle Fusion? Scenario: Bank will provide the ZBA Sweep transactions in Bank Statement file. Query: How to load the…RiC0 339 views 1 comment 0 points Most recent by Edgar Nieto-Oracle Payables, Payments & Cash Management -
SFTP stopped loading BAI2 files to Oracle but Manual load worksSummary: SFTP has files, Process electronic bank statement process ends in warning as no bank statements found but same file load manually, statements uploaded and recon…User_2025-03-07-05-43-14-868 25 views 1 comment 0 points Most recent by Edgar Nieto-Oracle Payables, Payments & Cash Management
-
Debit and credit transaction with same transaction code with different family and sub-family in ISO2We are trying to define transaction codes for ISO20022 Bank statements based on the files received from the business, we have identified a scenario where Debit and credi…Manikanta Varra 41 views 1 comment 0 points Most recent by Edgar Nieto-Oracle Payables, Payments & Cash Management
-
how can we perform the cash reconciliations if we use same cash accounts for multiple bank accounts.Summary: We are moving from old COA to New COA where in old COA we have a segment "Reconciliation Control" which is used for reconciliations and now we are eliminating t…Priyankagupta_NATWEST 23 views 5 comments 0 points Most recent by Siva Chittapragada-Oracle Payables, Payments & Cash Management
-
Advice on Cash Management Implementation ApproachContext: We implemented ERP Cloud roughly 7 years ago. We are now looking at implementing cash management to automate bank reconciliations, and are curious how others ha…Gorane Stormoen 11 views 3 comments 0 points Most recent by Gorane Stormoen Payables, Payments & Cash Management
-
BankToCustomerDebitCreditNotificationV06 - camt.054.001.06Content It seems there is no support for camt.054 which is the common reconcilliation file in use in the Nordic countries. -
Auto Recon is not working for one bank statement line with multiple system transaction sourceHi, Auto Reconciliation is not working for one bank statement line with multiple transaction sources of system transactions in cash management. Ex: One bank statement li…Pardha_Mukala 69 views 1 comment 0 points Most recent by Bogdan Nita-Oracle Payables, Payments & Cash Management
-
Germany Bank Account Number is Different in Bank Statement FileHi All, When we try to import bank statement for germany entity, it thows erros saying account number mismatch. We saw that account number configures in the system is li…Jakeeagarwal 13 views 1 comment 0 points Most recent by Jakeeagarwal Payables, Payments & Cash Management
-
Multiple Transaction Codes and Description for a unique combination of Domain, Family and SubfamilyWe have a requirement to Implement ISO type Bank Statements. We observed that we have multiple descriptions available for same combination of Domain, Family and Subfamil…Ameya Dani 3 views 1 comment 0 points Most recent by MariusS-Oracle Payables, Payments & Cash Management -
Importance and Use of Transaction Code in Cash ManagementWe have a requirement to Implement ISO type Bank Statements and we observed that "Transaction Code" is a mandatory field. Can someone Explain the importance of "Transact…Ameya Dani 3 views 1 comment 0 points Most recent by MariusS-Oracle Payables, Payments & Cash Management
-
How to avoid System Transactions in Manual Reconciliation Page under Cash ManagementThere is a dummy bank account that we have created to clear out the invoices and transactions where client is clearing them from other sources. However, once we do the p…Aditya Koch 31 views 2 comments 0 points Most recent by Aditya Koch Payables, Payments & Cash Management
-
Do we have "Structured Payment Reference" Field in AP Payments/PPR for ReconciliationSummary: Hi Experts IN AR for Reconciling Receipts with Bank Statement, we have Field called Structured Reference which updatable field where we have keep bank reference…Satya Mothe 44 views 3 comments 0 points Most recent by Ravi Prakash Shukla-Oracle Payables, Payments & Cash Management
-
Autocreation of Journal from Bank statement in Oracle Fusion CloudSummary: Content (required): We've requirement of autocreation of journal from Bank statement (MT940) for entries being first advised by the statement that needs to be r…Ruchi Gourshettiwar 42 views 1 comment 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management -
Bank reconciliation on value dateWe bank with Skandinaviska Enskilda Banken - and they transmit a daily bank statement file in the ISO20022 CAMT053 V1 format. Quite frequently, they add lines to our ban…Andrew Kelly 203 views 4 comments 1 point Most recent by Andrew Kelly Payables, Payments & Cash Management -
Cash Management :upload multiple MT940 statement files of same bank account in one goSummary: users have a zipped folder with 30 days statement files individually , all MT940 can they upload it at once in the usual way? the Load and import program is imp…Nandinis31 35 views 1 comment 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management
-
Transmit Payment File Web ServiceSummary: Is it possible to transmit bank payment files via web service? Currently, we have to transmit via Manage Transmission Configurations via SFTP but wanted to cehc…sailesh_cloudare 32 views 2 comments 0 points Most recent by Satish Kumar Reddy Byreddy Payables, Payments & Cash Management -
Which languages are supported for bank statements upload in Cash ManagementSummary: "Which languages are supported for bank statements upload in Cash Management?" Content (required): Which languages are supported for bank statements upload in C…Kumar_Tarun 42 views 1 comment 0 points Most recent by Bogdan Nita-Oracle Payables, Payments & Cash Management -
How to setup One to many Reconciliation Matching RuleSummary: Hi Experts Can any one advise how to setup Reconciliation Matching Rule for ONE TO MANY where we can reconcile one Bank Statement line both for Receipts (AR) & …Satya Mothe 177 views 2 comments 0 points Most recent by Satya Mothe Payables, Payments & Cash Management
-
BAI2 to CAMT ImplementationCurrently we have BAI2 codes configured in Oracle cloud, now in order to add the ISO codes (Domain, Family, Sub family) we need to define it against the existing BAI2 co…
-
"Manage Bank Statement Transaction Codes" changing mandatory fields as opionalCurrently, in the task "Manage Bank Statement Transaction Codes" the Transaction Codes and Transaction type is a mandatory field. Can we make these two fields as optiona…
-
Notification when load bank statement schedule faildSummary: Notification when load bank statement schedule faild Content (required): we have a schedule process that load bank statement from bank. i wonder if there is a n…Ahmed N. Elghannam 22 views 3 comments 0 points Most recent by Jen W. Payables, Payments & Cash Management
-
What is the effect of bank statement reconciliation on Financial statements?Summary: Customer wants to know the effect of unreconciling a transaction on financial reporting. Content (required): Hi All, There is a specific query by customer on wh…Akash Verma 2 views 2 comments 0 points Most recent by Akash Verma Payables, Payments & Cash Management -
Upload CFONB 120 Bank StatementsDoes anyone know if Fusion Financials will accept CFONB 120 Bank Statements? EBS used to using the EDIFACT parser so I assumed it would but I'm having issues. Currently …Antony N123 143 views 4 comments 0 points Most recent by ANTHONYB Payables, Payments & Cash Management
-
Is it possible to increase the size of the column to store more than 35 characters?Summary: As the length of character has increase from bank statement lines, after importing bank statement lines into Cash Management tables using integration, system do…Veerpal Kaur 35 views 3 comments 0 points Most recent by Ravi Prakash Shukla-Oracle Payables, Payments & Cash Management
-
Category = reconciled payment shows twice in GL journals and when reconciliation in cloudSummary: GL journals batch shows 2 lines in batch with category = Reconciled Payment and have 2 lines when reconciled, one line is reconciled and other is available Cont…Ashish Tralsawala 3 views 2 comments 0 points Most recent by Ashish Tralsawala Payables, Payments & Cash Management
-
Bank Auto Reconciliation LogicHello, Can someone please confirm for me the logic Fusion uses for for auto-reconciling a bank statement with bank transaction codes. When you set up bank transaction co… -
Reconciled transaction from system transactionHello Could you please advise which table store the follow data? We need reconciled transaction from system transaction for a specific Batch Reference. We are trying to …Kamonwan Srasrisom 14 views 2 comments 0 points Most recent by Kamonwan Srasrisom Payables, Payments & Cash Management
-
Cash Management External Transactions accounting errorSummary: The Bank Exchange rate type is not setup at the bank account level in order to replicate the subledger transactions conversion in the Manual reconciliation page…Indumathi V 57 views 1 comment 0 points Most recent by Eugeniu J-Oracle Payables, Payments & Cash Management
-
We would like to automate the exchange rate. Any idea please?Summary:Instead of loading it manually via speadsheet, we would like to automate the process. Content (required): Version (include the version you are using, if applicab…David Sakeye 41 views 2 comments 0 points Most recent by Karun_Jain-Oracle Payables, Payments & Cash Management