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
- Open Revenue Detail report in Microsoft Excel
- 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