Knowledge Base

Welcome to the SmarterCommerce documentation portal

What can we help you find?

SMARTERCOMMERCE

Search and Learn about Unified Commerce and Our SmarterCommerce Solutions
Payment Processing

Credit Card Reconciliation Processing

Credit Card Reconciliation processing consists of the following steps:

Step 1- Run the Load Settled Transactions Process (RQ6704213)

Step 2 - Execute the Reconciliation Automated Process (RQ6704214 - single-threaded queue)

Step 3 - Reconcile transactions manually

 

Step 1

Before you reconcile your accounts you must run the Load Settled Transactions Report (RQ6704213). Typically, this report is run at the end of each period, but it can be run as many times as needed to reconcile settled transactions. If desired you can also place this report in the JDE Scheduler to run automatically.  The Load Settled Transactions report updates the Report Information (FQ674225) and the Settled (FQ674226) tables. This report does not replace the existing data in the tables but updates them with the new settled transaction from the last date the report was executed to the new execution date. For example, if the report was run on 06/06/2015 and then run again on 7/20/2015, the result would be that the new settle transactions from 06/06 to 07/20 would be appended to the table(s). This report will pull only the settled transactions based on the date indicated in the Credit Card Processor screen and the time zone indicated in the report procession option. However, you may also limit the data by selecting a specific connection name in the data selection. Once both files are updated the Automatic and Manual processes can be performed.



Make sure that the business function BQ674276 (Submit Settlement Report) is mapped as the other CC BSFN’s within OCM.

 

Step 2

The Reconciliation Automated Process is designed to reconcile all the transactions that have been paid with Credit Card, that have been settled in PayPal/Braintree, and that have an associated posted receipt (even if the transaction still has an open amount). The report will display the reconciled transaction grouped by Bank ID.

You can run the report in proof mode to review the transactions that would be reconciled. Once you have reviewed the information you can run the report in final mode.  Final mode will update the F0911.RCND field with the value R (reconciled). Likewise the FQ674226.RCRN will also be updated with an R (reconciled). Both records (F0911 and FQ674226) are linked by Transaction ID.

Since unreconciled transactions are not removed from the reconciliation files they can be taken into account by the Reconciliation Automated report next time you execute it. You can limit the amount of transaction to be reconciled by adding data selection (based on F0911 fields) to the report and/or changing the current processing options.  

Once the transactions have been reconcile through the Reconciliation Automated Process you can review any unreconciled items and if necessary reconcile them using the Manual Reconciliation Process application.

 

Please note the report will also display transactions that were not reconciled during the process. Transactions are not reconcile for two reasons: (1) Transactions were not found in bank - this means that we have a receipt posted in Accounting (F0911), but not a settle record in PayPal/Braintree yet. (2) Payments not found in accounting - this means that there is not a receipt posted in Accounting (F0911), but there is transaction paid with a Credit Card in the gateway records.  

Step 3

After running the Reconciliation Automated Process you can open the Manual Reconciliation Process application (PQ670045) to review the reconciled transactions.  However, the main purpose of this application is to allow you to review unreconciled transactions. Please note you can also use this application to reconcile/unreconciled transactions as needed. This application will show only the records that have been refreshed after running the Load Settled Transactions report.

To manually reconcile a transaction just check the check box on the left side of the transaction and then click on the Reconcile/Unreconcile button. You can reconcile one or multiple rows using this method. When a transaction is reconciled from this application the system updates the field F0911.RCND field with the value R (reconciled)  Likewise, the FQ674226.RCND field will also be updated with the value R (reconciled). At times you might find it necessary to change a reconciled transaction to unreconciled. You can un-reconcile using this same process as detailed above. Please note that when you change a transaction to unreconciled the system removes the R from Files R0911RCND and FQ674226.RCND fields.

 

The Settled Transactions application displays all the settled transactions in PayPal/Braintree which have no records in the J.D. Edwards files. This indicates that the credit card payments were processed directly via the gateway. Even though these records are not in J.D. Edwards this application was designed to give you more control over the transactions processed and the money that is coming into your bank accounts.

Read Next
This Section Also Contains

Bring It All Together

We bring together digital commerce, retail and call center channels with a united approach that leverages the power of onmi-channel while prioritizing JD Edwards connectivity.

CONNECT WITH AN EXPERT