Below are steps to reconcile Revenue Payment Statement with Revenue Detail Report. Both reports are available for download after Login to ACTIVE Works Membership Manager

  1. Open Revenue Detail report in Microsoft Excel
  2. Locate Column P (Consumer Fee), Column R (Amount Billed), Column T (Refund Product Fee), Column U (Refund Process Fee)
  • Credits: Check and total Column R (Amount Billed) to confirm with Credits
  • Debits: Check and total Column T (Refund Product Fee) to confirm with Debits
  • Processing fee: Check and total Column P (Consumer Fee) and Column U (Refund Process Fee), use Column P - Column U to confirm with Processing fee 

Note: Click here for instructions on Export Revenue Detail Report in Membership Manager and Download Revenue Statement in Membership Manager