Bank Statements and Reconciliation
Discussion List
-
Bank Statement format CAMT053.001.02 supported??Summary: According to What Seeded Formats Are Available For Bank Statements. (Doc ID 1372887.1) (Last updated - Apr 15, 2024) ISO20022 - supported version MX CAMT053.001…Ramakanta Hota 422 views 3 comments 0 points Most recent by CA Syed Irshad Ali Payables, Payments & Cash Management -
How to clear payment status without bank reconciliationSummary: How to clear payment status without bank reconciliation (Manage Payment Options --> Account for Payment --> At payment issue and clearing) Content (required): H…UjasB 520 views 8 comments 0 points Most recent by GRACE SORIANO Payables, Payments & Cash Management -
Reference number in system transactionsSummary: Could we change the reference in system transactions for bank reconcilliation? The reference column and transaction number is populating same data. Could this b… -
How to populate the reconciliation reference using the Additional Entry Information (<AddtlNtry)Unable to populate Reconciliation Reference from Additional Entry Information (tag ) in ISO20022 CAMT.053.001.02 Bank Statement. We are attempting to load the Cash Manag…Bhavyasri Gaduputi 91 views 4 comments 0 points Most recent by Venkatesh Padamwar Payables, Payments & Cash Management -
Accounting Entries for Bank Account Transfer ReconciliationSummary: We are doing Bank Account Transfer. It creates 2 external transactions, one for each bank account. We are reconciling these external transactions with the bank …Swapnil Mangnalikar 126 views 3 comments 0 points Most recent by Vinutha-Oracle Payables, Payments & Cash Management -
How to purge the Imported Bank Statement files from SFTP Location and available in IBY_INBOUND_FILESummary: "Process Electronic Bank Statements" ESS Job used to fetch and import Bank statements files from external SFTP location into Oracle. The files are available in …Indumathi V 517 views 13 comments 0 points Most recent by Rahin 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. -
Extract foreign currency details from CAMT fileSummary: Extract foreign currency information from CAMT format bank statement via Parse Rules Content (please ensure you mask any confidential information): We are tryin…Arvind_Behura 22 views 4 comments 0 points Most recent by Aelia Bonnie Payables, Payments & Cash Management -
AR receipts not appearing in cash managementIn Cash Management Reconciliation, we have transactions that are not appearing. I am attaching a sample file with transactions that are showing on the Account Analysis r… -
One to Many Matching Rule is not WorkingSummary: One to Many Matching Rule is not Working Content (required): I get a single statement line for received check payments. The line can be identified using followi… -
Don't want to see System Transactions in Manual Reconciliations page for Dummy Bank AccountsHe have defined a dummy bank account in Fusion and user doesn't want the transactions to be shown in Manual Reconciliation in Cash Management as they cannot reconcile 1.… -
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… -
value date accounting for bank statement transactions in oracle cash management.Hello everyone, I would like my transactions reconciled with the bank reconciliations to be accounted to the cash value date and not the booking date. The configuration …FROD 316 views 5 comments 1 point Most recent by JegadishK-Oracle Payables, Payments & Cash Management -
Reconciliation of GL journals (Cash Account) with Cash ManagementSummary: Can clearing account reconciliation be enabled for cash accounts just to use 'Reconciliation Reference' field in journals for the purpose of cash management rec…Akila Suresh 443 views 5 comments 0 points Most recent by Philippe Kunstmann Payables, Payments & Cash Management -
Enabling US Bank Virtual Payments from Oracle cloudHi Team, We have a new project that we need to enable the US Bank Virtual Payments from Oracle Cloud. This is an end-to-end process, like creating an invoice, making pay…Raju Thadakala 121 views 6 comments 1 point Most recent by Jon Kelly Payables, Payments & Cash Management -
Is it possible to change a transaction code when importing a CAMT053.001.02 bank statement?We are importing bank statements from JPMC using the JPM ISO20022 MX CAMT053.001.02 Format. JPM uses a transaction code of 175 for cash deposits. The issue is that code …DMW_HILLSCOUNTY 12 views 0 comments 0 points Started by DMW_HILLSCOUNTY Payables, Payments & Cash Management -
GL Journal lines migrating via FAH Integration is not reflecting in Cash to GL reconciliation reportHi Everyone, When we are creating any journal line in GL those transaction are reflected in cash management dashboard source as Journal for reconciliation. The transacti…User_NGFDG 7 views 2 comments 0 points Most recent by User_DGENW Payables, Payments & Cash Management -
Non English Bank StatementSummary: Do Oracle Fusion, supports Bank Statements in Non English Content (please ensure you mask any confidential information): Do Oracle Fusion, supports Bank Stateme…RajibPramanik 11 views 3 comments 0 points Most recent by User_DGENW Payables, Payments & Cash Management -
How to upload external PGP Private decryption key in Oracle Fusion for Bank Statement importSummary: We're on 25B currently and planning to establish Host to Host connectivity with Bank to import bank statement files in CAMT.053 format. We're trying to use PGP …Shiv.Singhal 375 views 1 comment 0 points Most recent by Aelia Bonnie Payables, Payments & Cash Management -
How to Configure Bank Statement Reconciliation Reference on Reconciled Page and Journal Line PageSummary: 1) After reconciling statement line with GL journal, there is no reference on Manual Reconciliation>Reconciled Page. Is it possible to have the reference to sho…Abby Chen522 87 views 5 comments 2 points Most recent by MD ALAM Payables, Payments & Cash Management