Bank Statements and Reconciliation
Discussion List
-
Is it possible to reconcile 2 different bank accounts statement lines with each otherContent (required): Hi all I got a customer which ask if it is possible to reconcile 2 different bank accounts' statement lines with each other. Is that possible? Or wha…Daniel Lundsteen Minke 11 views 2 comments 0 points Most recent by Daniel Lundsteen Minke Payables, Payments & Cash Management -
QR Codes For Billing and PaymentsSummary QR Code Integration For Oracle PaymentsContent This summer (June 2020) Switzerland has announced that it will be switching from payment slips (orange and red) to…User_8O6L5 118 views 5 comments 3 points Most recent by Ashutosh_Srivastava Payables, Payments & Cash Management -
Bank Reconciliation Matching RuleSummary: Bank Reconciliation Matching Rule Content (required): How to reconcile 1 bank statement line to 4 system transaction line with similar reference. 66029 on Bank … -
user visibility on bank statements imported in errorSummary: I have a scenario where in Cash Management, Bank Statements and Reconciliation, Processing Warnings and Errors page, there are bank statements imported with err…Silvia Damiani-Oracle 11 views 1 comment 0 points Most recent by Vinutha-Oracle Payables, Payments & Cash Management
-
BAI2 bank Statement import for two different BankSummary: BAI2 bank Statement import for two different Bank (Example:- ABC Bank and XYZ Bank) Content (required): I would like to know if there is a way to configure and …
-
Bank is rejecting payment file for payment of payables invoices with credit memo.Summary: We are using ISO20022 Common Global Implementation payment format to generate our payment file. Most of our invoices and credit memo are created from IDR. When …Zandro 52 views 5 comments 1 point Most recent by Kondaiah Mandadi-Oracle Payables, Payments & Cash Management
-
SWIFT MT940 row 25 file formatSummary Bank statement export in Swift MT940 format contains a dash (-) which is erroring on upload to CloudContent Our UK bank statement (Barclays) Swift MT940 exports …Tony Glennon 32 views 4 comments 2 points Most recent by Ashutosh_Srivastava Payables, Payments & Cash Management
-
Incoming WIRE recording in Cash ManagementSummary: Incoming WIRE recording in Cash Management Content (required): I would like to understand how to set up a incoming WIRE recording in Cash Management. This is pu…
-
Is it possible to configure the system transaction data fields that are available for reconciliationSummary: We would like to add data fields that are available on Receipt records to the data fields that are available to the system transaction UI on the manual reconcil…Adrian Townsend 1 view 0 comments 0 points Started by Adrian Townsend Payables, Payments & Cash Management -
Booking Date not within statement dateSummary: Bank Statement Upload error Content (required): Hi, We tried to upload a bank statement with the statement date from 01-Oct-2022 to 31-Oct-2022. The booking dat…Sheneli Fernando 1 view 0 comments 0 points Started by Sheneli Fernando Payables, Payments & Cash Management
-
Troubleshooting: intraday bank statements are causing import errors for US, EMEA, and APACSummary: When requesting intraday bank statements for US, EMEA, and APAC, the following import error message occurs: "The statement line availability amount is invalid b…Kathryn Santello 11 views 0 comments 0 points Started by Kathryn Santello Payables, Payments & Cash Management
-
External Transaction creation by Auto reconciliation for One to Many ruleSummary: We are looking to implement automatic reconciliation. Since amount in statement will have difference we are looking to use tolerance limit. As per oracle docs a…
-
Service Provider BU concept in Oracle FusionSummary: The basic concept for Service provider model very clear that the Service provider BU provide the service on behalf of other BUs when it comes to centralize the …Jugander Kumar 11 views 2 comments 0 points Most recent by Jugander Kumar Payables, Payments & Cash Management
-
Need to get only the last 5 digits (highlighted) to be made available from the MT940 for Recon ReferSummary: Need inputs on getting only the last 5 digits (highlighted) to be made available from the MT940 statement as a Reconciliation Reference using Parse Rule to faci…Mansoor Mahmood-Oracle 12 views 1 comment 0 points Most recent by Edgar Nieto-Oracle Payables, Payments & Cash Management
-
Reconcile multiples transactions source against a bank statement lineSummary: Reconcile multiples transactions source against a bank statement line - cash management module Content (required): Hi All, i have the following business case fo…CM_ 2 views 1 comment 0 points Most recent by Vijay K Beriwala-Oracle Payables, Payments & Cash Management
-
What is the Best Way to Reconcile in Cash Management to Third Party PaymentsSummary: We are a Health Insurance Company and we pay our claims out of a third party system. We have about 9,000 payments per week out of the third party system. We are… -
How to Find/Retrieve/the Location of BAI2 File that the Bank Sends to Oracle Fusion-Cash ManagementSummary: We are unable to find out BAI2 file that the bank sends so as to import the bank statement into Oracle Financials Cloud – Cash Management and run Oracle Cash Ma…shivakumar.gurram 11 views 0 comments 0 points Started by shivakumar.gurram Payables, Payments & Cash Management
-
AP invoice calculating withholding in functional currency. Is there a way we can change it.Summary: Our functional currency is USD. We have lot of invoices that are in another currency, anytime those invoices are created, their withholding and VAT invoices are…David Sakeye 1 view 1 comment 0 points Most recent by Edgar Nieto-Oracle Payables, Payments & Cash Management
-
Cash to GL recon report - Bank and book balance not matchingSummary: Content (required): Cash to GL recon report - Bank and Book balance not matching for the current month. There is no unreconciled transactions. All AP, CM and AR…DPM 1 view 1 comment 0 points Most recent by Edgar Nieto-Oracle Payables, Payments & Cash Management
-
Validation to prevent a payment run making a payment to a country not serviced by the firm's bankSummary: Validation to prevent a payment run making a payment to a country not serviced by the firm's bank Content (required): We have an agreement with a bank to proces…Phil Nibert 11 views 5 comments 0 points Most recent by Phil Nibert Payables, Payments & Cash Management
-
bank ReconciliationSummary: How to reconcile a GL Journal in GBP with a Bank Statement Line which is in USD. Content (required): Version (include the version you are using, if applicable):…Ash000 12 views 1 comment 0 points Most recent by Vinutha-Oracle Payables, Payments & Cash Management
-
Best practice or process to handle a voided check that cleared the bankSummary: What is best practice or process to handle a voided check that cleared the bank Content (required): Version (include the version you are using, if applicable): …Anthony Cambria 1 view 1 comment 0 points Most recent by Edgar Nieto-Oracle Payables, Payments & Cash Management
-
How to modify the bank statement file from the bank for automatic processing of bank statement?Summary: We will need to process the bank statement file from the bank automatically in oracle cloud. Content (required): Hi Experts, We are using ISO20022 MX CAMT053.00…Zandro 21 views 1 comment 0 points Most recent by Edgar Nieto-Oracle Payables, Payments & Cash Management
-
How to autoreconcile One to Many EFT Payments in Cash ManagementSummary: How to autoreconcile One to Many EFT Payments in Cash Management when not all payments in the payment process request are cleared at the same time by the bank C…SChalam-Oracle 1 view 1 comment 0 points Most recent by Edgar Nieto-Oracle Payables, Payments & Cash Management
-
In reconciled tab for bank statement search is not working - what are the optionsSummary: In Bank statement reconciled tab , if there is a group of 100 records - when we are searching with particular amount/reference/ other field it is not sowing the…Jagadeesh Sukavasi 1 view 3 comments 0 points Most recent by Vinutha-Oracle Payables, Payments & Cash Management
-
How can I clear system transactions where the cash nets to zero (no entry on bank statement)Summary: How can we clear/auto-reconcile net zero cash system transactions in the bank reconciliation. Content (required): We have many journal entries transferring cash…Tena Mose 43 views 10 comments 0 points Most recent by Glen Ryen Payables, Payments & Cash Management -
Accounting date for reconciled checks is not the date the check cleared the bankSummary: Accounting date for reconciled checks is not the date the check cleared the bank when it crosses months Content (required): We currently have a situation where …Stacy Oelke 1 view 2 comments 1 point Most recent by Ravi Kanth Vuddagiri Payables, Payments & Cash Management
-
Query or Report to Extract Unreconciled Bank Bank Statement Lines & System TransactionsSummary: We would like to have a Query or Report to Extract Unreconciled Bank Bank Statement Lines & System Transactions. Content (required): One option to extract them …Ravi Kanth Vuddagiri 11 views 1 comment 0 points Most recent by Ravi Kanth Vuddagiri Payables, Payments & Cash Management -
Reconciliation Reference is coming blank for BAI2Summary: Hi Team Reconciliation reference is coming blank when we upload bank statement. The line in bank statement is "16,466,10000,Z,123456789,000012345/" We have pars…Nidhi Chhajed 1 view 4 comments 0 points Most recent by JessicaSF Payables, Payments & Cash Management
-
View only access to manual Bank Reconciliation pageSummary: We have a requirement to provide view only access to manual reconciliation page. Content (required): View only access is required to check reconcilied and unrec…Samindi 1 view 2 comments 0 points Most recent by Ravi Kanth Vuddagiri Payables, Payments & Cash Management