Membership Reconciliation
Overview
The following should act as a guide for the process to obtain a membership reconciliation out with the Stewardship Reporting process.
This may be required on an ad hoc basis or for the Annual Trustee Report and Accounts. If the later, an automated scheme level workflow can be set up to remind the administrator to complete this task annually.
How to process a Membership Reconciliation
Access through the left-hand drop-down menu under Administration, Scheme Setup. Select the Scheme and click here to go to the scheme reports page.
If reports have been run previously, find the report run for the last set of accounts and click follow on to complete the report up to the accounts date. This ensures continuity of the membership statistics.
Alternatively click Add New (if not previously run) or Add Another.
The results can be viewed on-screen, or a copy of the report can be saved as a PDF by clicking the printer icon in the top right-hand corner.
Retrospective movements and movements in the current period can be viewed by scrolling further down the screen.
If you require a list of the members as at the effective date, run a membership download from Mantle. Access through the left-hand drop-down menu under Administration, Bulk Download.
Use the Simple Data Dump for the relevant scheme and ensure that you enter the effective date as at the date of the accounts. Save this document in excel.
