Payment Reconciliation: Submitted / Processed

The Payment Reconciliation page allows usersadministrators to effectively track and manage the status of payments within a defined time period. ThisIts reportprimary purpose is specifically designed to reconcile the dollar value of received payments with your bank or credit card merchant by accurately comparing the amounts charged between the two.two Userssystems. This article is intended for OPS-COM administrators responsible for financial reporting and auditing.

Setup and Configuration

To effectively filter reconciliation data, administrators can create designated groups and assign specific members to them.

You must have the View Payments permission enabled on your profile to access this report. This permission can be added to your role by a Primary Admin.

Creating a Payment Reconciliation Group

1. Hover over System Configuration, click Admin Management then Manage Groups.

2. Click the Payment Reconciliation module tab.

3. Click the Add New button in the top right corner.

4. Enter a name for the group into the Group Name field.

5. Set the purpose of the group using the Module drop-down menu.

6. Add the appropriate staff to the group using the Admin Members selection area.

7. Click the Save Group button. The new group will appear at the bottom of the Administrator Groups list.

Adding Members to an Existing Group

1. Hover over System Configuration, click Admin Management then Manage Groups.

2. Click the Edit button next to the specific Administrator Group you wish to modify.

3. Click the Admin Members bar to select and add additional members to the group.

4. Click the Save Group button at the bottom of the window to apply your changes.

Using this Feature

Administrators can filter results to view either submitted or processed payments.

payments

Setup & Configuration

To access the Payment Reconciliation page you must have the permission to View Payments turned on.  This can be added to your role by your Primary Admin.

---

Creating a Payment Reconciliation Group

1. Navigate to System Configuration, then Admin Management, and clickbased on Managespecific Groups.
2. This brings you to the Manage Administrator Groups page.
3. To create a Payment Reconciliation group click on the Payment Reconciliation module and then click Add New in the top right corner under.

   criteria.

   The Adding New Group window will appear with the following options:

   Options	Info
   1. Group Name	The Group Name is how you set the name of a group.
   2. Module	The Module is where you can set the purpose of the group.
   3. Admin Members	The Admin Members is the area in which you can add admin members to the group

   
   
4. When you are finished click the Save Group button. You will see your group added to the bottom of the Administrator Groups.

Adding Members to a Group

1. Navigate to System Configuration, then Admin Management, and click on Manage Groups.
   
2. Click the Edit button next to the Administrator Group you wish to edit. 
   
3. Click on the Admin Members bar to add more members to the group.
   
4. When finished, click the Save Group button found at the bottom of the Editing Group.

Using this Feature

1. GoHover toover Payments, and click Payment Reconciliation.

2. On this page, you can apply filters to refine the payment data displayed:

   • Filter by Date Range: Define the start and end dates for the payments you wish to view.view using the Filter by Date Range fields.

   • Filter by Payment Type: Select the specific payment method(s)methods you want to include in the results.results using the Filter by Payment Type drop-down menu.

   • Filter by Admin Group: 

     Filter reconciliation data based on specific admindesignated groups designatedusing forthe paymentFilter reconciliation.

   by
   Admin Group drop-down menu.

3. Click Search.the Search button. The results arewill displayeddisplay directly below the search criteria.

4. Click on any column header within the results table to reorder and sort the data.

SystemAvailable Task (Export Options)Actions

The report page offers various export options,options shown(displayed inas green,green buttons) that allow usersadministrators to generate files for external use:

• Copy: Copies the row data to your clipboard, allowing you to easily paste it into anyexternal program, such as Excel.programs.

• CSV: Creates and prompts you to downloaddownloads a CSVComma-Separated Values (Comma-separated values, .csv)csv) file for use in yourspreadsheet program of choice.software.

• Excel: Creates and promptsdownloads youa to download anMicrosoft Excel (Microsoft.xls) Excel, .xls) file for use in your program of choice.file.

• Print: Prompts your web browser to print the current page view.

 

---

Best Practices &and Considerations

[!WARNING]

• Avoid

  Reconciliation Focus: The Payment Reconciliation report isusing the correct tool for comparing system payments with bank/merchant payments.

• Avoid Daily Payments Itemized report for Reconciliationreconciliation Tasks:tasks. TheWhile the Daily Payments Itemized report shows received payments, but it is not recommended for reconciliationfinancial becausereconciliation. itIt may display tax differently and can lead to rounding errors, making exact dollar-value comparisoncomparisons inaccurate.

  • Reconciliation Focus: Always use the Payment Reconciliation report as your primary tool when comparing internal OPS-COM system payments with external bank or merchant settlement statements.