Membership Manager: Use Revenue Report to Reconcile Payments

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