Gateway Payment Reconciliation Report

The Payment Reconciliation Report was created for Payment Integration and Consumer Portal customers. View all transactions made through Energy Force or a connected NMI account and compare and reconcile with NMI transactions, view failures and other relevant details without having to log into NMI. 

This report is located at Posting Menu / Gateway Payment Reconciliation. In order to view this setting, set the Pay2Day Active? system setting to Y at Supervisor Menu / Maintenance Menu / Division Maintenance / System Settings. The default is to view all by the current date but can be filtered by Division and Payment Date. 

Columns on the Payment Reconciliation Report may include: 

• Division
• Posting Division
• Customer Number
• Date of Payment
• Payment Amount
• Fee
• Discount Amount
• Status
• Payment Apply to
  • Budget, Balance, or Contract
• Payment Type
• Channel – displays how this payment was processed.
  • Device  
    • The transaction was processed through a payment device. 
    • Would include the Energy Force User in the Entered By column who ran the payment. 
  • Direct Merchant 
    • If the transaction was processed through NMI directly (outside of Energy Force). 
    • Would not include Entered By details since the transaction was outside of Energy Force. 
  • Batch 
    • If the transaction was processed through batch processing. 
    • Would not include Entered By details since the transaction was outside of Energy Force. 
  • Energy Force 
    • If the transaction was processed through the payment modal inside of Energy Force either as a Saved Payment Method, One-Time Payment or with a Payment Device. 
    • Would include the Energy Force User in the Entered By column who ran the payment.
  • Consumer Portal 
    • If the transaction was processed through the Consumer Portal by the consumer. 
    • Would not include Entered By details since the transaction was outside of Energy Force. 
• Payment Journal 
• Fee Journal 
• Payment Ticket Number
• Fee Ticket Number
• Processed Date
• Processed Time
• Entered By 
  • Shows the Energy Force user who processed the payment if the payment was processed through the payment modal as either a Saved Payment Method, One-Time Payment or via a Payment Device.  Entered By will be blank if the payment was processed through the Direct Merchant (within NMI), the Consumer Portal (customer), or a Batch payment process.