Bank Statements and Reconciliation
Discussion List
-
Reconciling External Cash Transactions not on bank statementContent Hello, We currently import cash transactions from our external systems into cash management for reconciliation. The Auto Reconciliation function works very well …Elizabeth Mitchell 29 views 4 comments 2 points Most recent by Glen Ryen Payables, Payments & Cash Management -
What steps are required for using a custom bank statement?Summary What steps are required for using a custom bank statement?Content Hi, We have a requirement to use a custom Bank Statement. Could someone please explain the step…Richard Lang 17 views 4 comments 1 point Most recent by Richard Lang Payables, Payments & Cash Management
-
Can bank account balances held in Cash Management be linked through to ARCS reconciliations?Summary Can the bank statement balances at the end of the month that are held in cash management be linked through to the ARCS reconciliations for the associated GL acco…Jason Goody 25 views 1 comment 0 points Most recent by Glen Ryen Payables, Payments & Cash Management
-
AP User Rate for Payments not coming over to Cash Management for ReconciliationContent We are having an issue with our Cash Management in Oracle Fusion ERP when booking user rates for invoice payments from AP. When paying a currency we don't own, C…Sergey Feldman 11 views 2 comments 0 points Most recent by Baskar.Chakravarthi Payables, Payments & Cash Management
-
PAIN002 Banking Acknowledge ProcessingSummary Bank Acknowledge Process using the PAIN002 xmlContent Hi, I have never used the Bank Acknowledge Process using the PAIN002 xml format. I want to know if we can u…User_G3L4B 19 views 4 comments 3 points Most recent by Geert Mouwen Payables, Payments & Cash Management
-
cashExternalTransactions API not giving data after 21A releaseSummary /fscmRestApi/resources/latest/cashExternalTransactions - APIContent Hi Team, After 21A update not able to Get data and Update the data by using below REST API's.…Nazeer Anantha-145553 9 views 3 comments 0 points Most recent by Danut Stoian-Oracle Payables, Payments & Cash Management -
In Create Bank Account Transfer when selecting the Conversion Rate Type User can Oracle check the raContent We recently encountered an issue where an abnormal conversion user rate was entered in Create Bank Account Transfer which created an incorrect external transacti…Jason Goody 14 views 3 comments 1 point Most recent by Jason Goody Payables, Payments & Cash Management
-
-
Bank Reconciliation: Foreign ExchangeSummary Bank Reconciliation: how to account for foreign exchange gain/loss between bank statement and AP system transactionContent Scenario: An Oracle AP invoice amount …Stephen Masterson 33 views 3 comments 1 point Most recent by Ash000 Payables, Payments & Cash Management
-
Urgent payments at month end/Period closeContent Hi, We close the current period in the first week of the next month. Account for payment is set to At payment issue and clearing. We Allow payment date before th…Stefan pettersson 21 views 1 comment 1 point Most recent by Vinutha-Oracle Payables, Payments & Cash Management
-
Mark Bank Statement Line as ExternalSummary Marking Unreconciled Bank Statement Line as ExternalContent We have a bank statement line that does not correspond to any of the system transaction, therefore wo…Sedrilyn Siow 16 views 3 comments 1 point Most recent by Mahesh Jami-Oracle Payables, Payments & Cash Management
-
User selected wrong bank account for AP Payment - issue reconcilingSummary How to reconcile between 2 bank accountsContent Hi I have an issue where we have 2 bank accounts set up which bothe use the same GL code. Both accounts are activ… -
Not able to load few details for CAMT053 bank statementSummary Not able to load few details for CAMT053 bank statementContent Hi Team, We are not able to load domain, family and sub-family fields from CAMT053 bank statement …User_QGBH2 11 views 5 comments 2 points Most recent by Danut Stoian-Oracle Payables, Payments & Cash Management
-
Need help on payables 'Check printing by bank'Summary Looking for some end-to-end process documentation and configurations required for Non-In-House check printingContent Hi - We will be implementing 'Check printing…User_MSDWD 17 views 6 comments 0 points Most recent by User_MSDWD Payables, Payments & Cash Management
-
Bank Statement ReconciliationContent Bank Statement BAI files are received one day in arrears from bank. For activity that comes into Cash Management on the last day of the month, the activity erron…User_58HTJ 49 views 5 comments 0 points Most recent by Geert Mouwen Payables, Payments & Cash Management
-
CM - Importing MT940Content We noted that when the MT940 has ':62M:', the system does not recognize the tag. As a result, for the additional information field, the system picks details of b…
-
Leaving Bank Exchange Rate Type Blank, can cause problems?Summary Leaving Bank Exchange Rate Type Blank, can cause problems?Content Hi Experts, We are following this document below but we are concerned about the potential probl…User_87I2Y 11 views 1 comment 1 point Most recent by Danut Stoian-Oracle Payables, Payments & Cash Management
-
How to clear a clearing account balanceContent Hi, We are configured to use two GL accounts for Cash Management, a cash and a cash clearing account. For one of our bank accounts we need to clear a balance in …Clare Farris 22 views 2 comments 0 points Most recent by Clare Farris Payables, Payments & Cash Management
-
CM - Loading MT940 Bank StatementContent When loading MT940 bank statement, the file got imported successfully. But we noticed that bank statement is not visible under 'Manage Bank Statements'. But the …
-
Bank account idContent Where can I find what the bank account id is for a bank account? I'm trying to troubleshoot autoreconciliation and the process output only gives me the bank acco…Clare Farris 25 views 6 comments 1 point Most recent by Clare Farris Payables, Payments & Cash Management
-
Cash Management Bank Account TransfersSummary Bank Account Transfers/SubAccount/Pooled Accounts or whatelse?Content Hi, Bank Account Transfers/Pooled Accounts We have a requirement to use 1 bank account for …Ratna 32 views 7 comments 0 points Most recent by JOEL DSILVA-Oracle Payables, Payments & Cash Management
-
What is the best process for expenses debited directly from our bank accountsSummary Should expenses debited directly by suppliers be booked and paid in AP? If yes, how to reconcile the payments with the statement?Content Some suppliers, such as …User_DXLU4 21 views 3 comments 2 points Most recent by Srinivasa Rao Karri Payables, Payments & Cash Management
-
Partial Reconciliation of Bank Statements in Cash ManagementContent Hi, We have many scenarios where customer needs to perform partial reconciliation of the bank statements and take appropriate manual action on the un-reconciled …User489315-OC 31 views 3 comments 1 point Most recent by Vinutha-Oracle Payables, Payments & Cash Management
-
Exchange rate required at payment even if you use accountting at reconciliationSummary The exchange should not be necessary whenContent Hello, We use account at reconciliation for our payments. Our exchange rate are loaded on a daily basis. When we…Louis fayard 20 views 1 comment 0 points Most recent by Nadia Khan-73252 Payables, Payments & Cash Management
-
Cash Management - Go-Live Best PracticeSummary Discussion on the best way to get started using cash managementContent Does anyone have any best practice or recommendations on how best to go-live with Cash Man…Martin Cook 36 views 2 comments 0 points Most recent by Martin Cook Payables, Payments & Cash Management
-
How is payment accounting done if option "at payment clearing" is set and there's no reconciliation?Content Hello In Romania, payment need to be accounted only after receiving the bank statement as a proof of payment (legal requirement).In order to do so, we set the Pa…User_DFZE6 33 views 5 comments 0 points Most recent by User_DFZE6 Payables, Payments & Cash Management
-
How to Restrict old asset books to the AP user?Summary How to Restrict old asset books to the AP user?Content Hi All, How to Restrict old asset books to the AP user? We have 2 books in 1 Business Unit. Currently user…Devendra Thota-220620 17 views 3 comments 1 point Most recent by Vinutha-Oracle Payables, Payments & Cash Management
-
Need to bypass/remove leading zeros from bank account value on BAi2 statement fileSummary Bank account number in BAi2 statement has leading zeros so file import failsContent For one of our banking partners, the bank account number on the BAi2 statemen…Daniel T Roy 19 views 5 comments 1 point Most recent by Daniel T Roy 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 21 views 1 comment 1 point Most recent by Edgar Nieto-Oracle Payables, Payments & Cash Management
-
Restricting access with Cash Manger RoleSummary Cash Manger Role allows access to al BU'sContent HI All When assigning the Cash Manger role to a User that already has for example an AP role, the Cash Manger ro…Paula Dyason 27 views 5 comments 0 points Most recent by Paula Dyason Payables, Payments & Cash Management