Membership Utilities - Clubtreasurer Community

The Membership Utilities section provide an ‘administrative hub’ for efficiently managing member profiles, membership assignments, and financial records via rapid bulk processing.

The various utilities allow you to execute mass operations across three core areas: Member Accounts, Membership Assignments, and Financial Transactions. Within this section, you can instantly alter member visibility by archiving profiles or reactivating them from an inactive state. For membership allocations and financial data, the system provides powerful multi-row execution capabilities to mass delete, cancel, or edit assignment billing lines.

Furthermore, you can easily alter membership receipts & payment by moving transactions between unallocated membership entries and general non-membership accounts, or automatically cascade incoming payments across open bills using sequential, date-prioritised matching rules.

Members: Delete, Archive & Restore

Use this page to efficiently process bulk changes (Archive, Restore, or Delete) for multiple members at once.

📋 Steps to Manage Members

Filter Members
Use the available filters to isolate the members you want to process.
- Filters include: Member Status (Active/Inactive), Section, and Membership Assignment.
Select Members
Check the individual row selector boxes in the table below, or use the header checkbox to select all visible rows.

💡 Batch Limit: You can select up to 500 rows at a time. If you have more than 500 members to update, please process them in separate batches.
Validate Selection
Check the Validate checkbox to confirm your selected list.
Choose and Perform an Action
Select one of the three bulk actions below. Review the breakdown table below to understand how each action impacts member data.

⚡ Action Breakdown & Consequences

Action	What it does	Data Impact & Requirements
Archive (Make Inactive)	Changes status to Inactive and prevents new Membership Assignments.	Personal details remain intact. ⚠️ Prerequisite: Members with open, unpaid assignments cannot be archived. Resolve these by marking billing lines as paid or cancelling/deleting them first.
Restore (Make Active)	Re-activates previously archived members.	Changes status back to Active.
Delete (Permanent)	Irreversible. Permanently removes personal data and Member Balances.	No Transactions: Open, unpaid assignments with no payments are completely deleted. With Transactions: Renamed to “Deleted Member Ref ID: XXXXX”. Assignments are cancelled but remain on the Members > Billing Schedules page. Audit Trail: Names may still appear in transaction Details or Notes.

⚠️ Important Notes

Restoring Deleted Members: If a deleted member had past payment transactions, they can technically be restored. However, because their personal details were scrubbed during deletion, you will need to manually re-enter their personal data.

Membership Assignments: Delete, Cancel & Archive

Use this page to efficiently process bulk changes—Delete, Cancel or Archive—for multiple Membership Assignments in a single, streamlined process.

📋 Steps to Manage Assignments

Filter Membership Assignments
Use the filters to isolate the specific Membership Assignments you wish to manage in the table below.
- Available filters: Mass Assignment Batch, Members, Memberships, and Date Range.
Select Membership Assignments
In the table, select specific assignments by checking the row selector boxes. To select all visible rows, use the column header checkbox.

💡 Batch Limit: Selection is limited to a maximum of 500 rows. If you have more than 500 assignments to update, please process them in separate batches.
Validate Your Selection
Check the Validate checkbox to lock in and confirm your selected assignments.
Choose and Execute an Action
Click the corresponding action button (**Delete**, **Cancel**, or **Archive**). Review the interactive comparison table below to choose the method right for your needs.

⚡ Action Breakdown & Consequences

❌ Option 1: Delete Assignments	⏸️ Option 2: Cancel Assignments	📦 Option 3: Archive Assignments
What it does: Permanently removes assignments and associated data. This action is completely irreversible. ⚠️ Critical Data Consequences: Any “Marked as Paid” lines associated with deleted assignments will also be permanently deleted. Assignments with Billing Lines that are “Marked as Paid” or have a Member Balance allocation can be deleted. 🚫 System Exclusions: Assignments with any billing lines that are already paid or credited by Receipt/Payment transactions cannot be deleted. These assignments are automatically excluded from selection.	What it does: Stops future renewals while keeping past financial records and historical data intact. 📅 Date Selection & Billing Rules: Set a Cancellation Date (can be in the future, but cannot be earlier than the latest paid billing line). Check “Cancel All Unpaid Billing Lines” to force-cancel unpaid lines and move the cancellation date back to the last paid line. 💰 Financial Impact: No further billing renewals will generate after the Cancellation Date. Any unpaid lines remaining before the Cancellation Date will still appear as due in billing reports and can still receive payments. Can be reversed at any time via the Restore button.	What it does: Used to unclutter a member’s Membership Assignment page by hiding older or inactive assignments from immediate view. ⚙️ Visibility & Controls: Archived items are simply hidden, not removed. You can view hidden assignments at any time by checking the “Show Archived” box. 🔄 Reversibility: This action is 100% reversible. You can restore individual item visibility directly inside the member’s Membership Assignment page. ℹ️ Note: Archiving is universal and operates independently of any active page filters.

❌ Option 1: Delete Assignments

⏸️ Option 2: Cancel Assignments

📦 Option 3: Archive Assignments

What it does: Permanently removes assignments and associated data. This action is completely irreversible.

⚠️ Critical Data Consequences:

Any “Marked as Paid” lines associated with deleted assignments will also be permanently deleted.
Assignments with Billing Lines that are “Marked as Paid” or have a Member Balance allocation can be deleted.

🚫 System Exclusions:

Assignments with any billing lines that are already paid or credited by Receipt/Payment transactions cannot be deleted.
These assignments are automatically excluded from selection.

What it does: Stops future renewals while keeping past financial records and historical data intact.

📅 Date Selection & Billing Rules:

Set a Cancellation Date (can be in the future, but cannot be earlier than the latest paid billing line).
Check “Cancel All Unpaid Billing Lines” to force-cancel unpaid lines and move the cancellation date back to the last paid line.

💰 Financial Impact:

No further billing renewals will generate after the Cancellation Date.
Any unpaid lines remaining before the Cancellation Date will still appear as due in billing reports and can still receive payments.
Can be reversed at any time via the Restore button.

What it does: Used to unclutter a member’s Membership Assignment page by hiding older or inactive assignments from immediate view.

⚙️ Visibility & Controls:

Archived items are simply hidden, not removed.
You can view hidden assignments at any time by checking the “Show Archived” box.

🔄 Reversibility:

This action is 100% reversible. You can restore individual item visibility directly inside the member’s Membership Assignment page.

ℹ️ Note: Archiving is universal and operates independently of any active page filters.

Billing Lines: Delete, Cancel, Restore & Edit

Use this page to efficiently process bulk modifications—Delete, Cancel, Restore, or Edit—for multiple assignment Billing Lines in a single process.

📋 Steps to Manage Billing Lines

Filter Billing Lines
Use the filters to isolate the desired Billing Lines in the table below.
- Available filters: Member, Membership Assignment, and Date Range.
- You can also toggle your view between Active/Hold or Cancelled Billing Lines.
ℹ️ Filter Exclusion: Paid or part-paid Billing Lines cannot be modified and are automatically hidden from this interface.
Select Billing Lines
In the Billing Lines table, check individual row boxes or use the column header checkbox to select all visible rows.

💡 Batch Limit: Selection is limited to a maximum of 500 rows. If there are more than 500 rows, please process your changes in batches.
Validate Your Selection
Check the Validate checkbox to lock in and confirm your selections.
Choose and Execute an Action
Click the corresponding action button (**Delete**, **Cancel**, **Restore**, or **Edit**). Review the interactive matrix below to understand the operational impact of each action.

⚡ Action Breakdown & Consequences

❌ Option 1: Delete Lines	⏸️ Option 2: Cancel Lines	🔄 Option 3: Restore Lines	✏️ Option 4: Edit Lines
What it does: Permanently removes Cancelled Billing Lines from the system. ⚠️ Critical Warnings: This action is permanent and cannot be undone. If you are unsure, choose Cancel instead. Assignment Deletion: If ALL Billing Lines inside an assignment are deleted, the entire Membership Assignment is permanently deleted. 🛑 Renewal Impact: Deleting the last remaining Billing Line in an assignment stops future generation cycles. To keep the assignment active, use Cancel instead.	What it does: Moves Billing Lines from an Active/Hold status into a Cancelled status. 🔄 Reversibility: This process is safe and reversible. Cancelled lines remain in the system history and can be restored at any point. 🛡️ Renewal Safeguard: Cancelling the last Billing Line on an assignment safely preserves the assignment structure, ensuring it stays active for the next billing renewal cycle.	What it does: Re-activates previously Cancelled Billing Lines. ⚙️ Expected Behavior: Changes the row status back to Active/Hold. Restores the billing row’s line eligibility for future payment collections and financial accounting reports.	What it does: Allows you to manually modify specific fields on the selected Billing Lines directly within the grid view. 🛠️ How to Edit: Click the Edit button located above the main table. Click into individual cells to make modifications. Click the Save button to commit your updates. ⚠️ Editing is limited to: Bill From / Bill To Dates Due Date Billed Amount Comments All other fields are protected and will be greyed-out.

❌ Option 1: Delete Lines

⏸️ Option 2: Cancel Lines

🔄 Option 3: Restore Lines

✏️ Option 4: Edit Lines

What it does: Permanently removes Cancelled Billing Lines from the system.

⚠️ Critical Warnings:

This action is permanent and cannot be undone. If you are unsure, choose Cancel instead.
Assignment Deletion: If ALL Billing Lines inside an assignment are deleted, the entire Membership Assignment is permanently deleted.

🛑 Renewal Impact:

Deleting the last remaining Billing Line in an assignment stops future generation cycles. To keep the assignment active, use Cancel instead.

What it does: Moves Billing Lines from an Active/Hold status into a Cancelled status.

🔄 Reversibility:

This process is safe and reversible. Cancelled lines remain in the system history and can be restored at any point.

🛡️ Renewal Safeguard:

Cancelling the last Billing Line on an assignment safely preserves the assignment structure, ensuring it stays active for the next billing renewal cycle.

What it does: Re-activates previously Cancelled Billing Lines.

⚙️ Expected Behavior:

Changes the row status back to Active/Hold.
Restores the billing row’s line eligibility for future payment collections and financial accounting reports.

What it does: Allows you to manually modify specific fields on the selected Billing Lines directly within the grid view.

🛠️ How to Edit:

Click the Edit button located above the main table.
Click into individual cells to make modifications.
Click the Save button to commit your updates.

⚠️ Editing is limited to:

Bill From / Bill To Dates
Due Date
Billed Amount
Comments

All other fields are protected and will be greyed-out.

⚠️ Important Exclusion Safeguards

🔒 Protected Billing Rows (System Block):
Paid or part-paid Billing Lines with associated Payment receipts/credits cannot be cancelled or deleted.

System Update: This protection rule applies universally to any Billing Lines that are currently Marked as Paid or possess a Member Balance allocation. These rows will not be displayed or selectable.

Receipt/Payment Associations to Membership Billing Lines

Use this page to quickly amend Membership Billing Lines and Receipt/Payment associations. For example, you can reallocate multiple recorded Receipts to alternative Membership Billing Lines and/or different Members entirely. In most scenarios, utilizing this interface is significantly faster than manually adjusting individual Receipt transactions.

📋 Steps to Manage Receipt/Payment Lines

Filter Receipt/Payment Lines
Use the filtering criteria to display the specific Receipt/Payment lines you need to adjust in the data table below.

📅 Financial Year Restriction:
By default, you can only select and edit Receipt/Payment lines that fall within or later than the active Financial Year.

Tip: If you must adjust prior-year entries, you can temporarily update your system’s current Financial Year setting to gain access.
Edit Receipt/Payment Associations
Click the Edit button positioned in the table header or row to open the fields for modifications. Adjust values within the following critical columns:
- Member: Reallocate the receipt to a different individual or organization profile.
- Membership Invoice / Billing Line No.: Remap the transaction to a different targeted billing item.
Save Your Changes
Click the Save button to commit your modifications and update the accounting ledger allocations.

Mass Allocate & Convert Payments

This utility page streamlines payment matching, balancing ledger accounts, and managing fund distributions across your membership database via three main capabilities:

⚙️ 1. Mass Allocate Balances

Bulk matches unallocated transactions and member credits directly to unpaid billing lines (oldest first). Automatically applies custom accounting rules if configured.

🔁 2. Convert to Non-Membership

Transforms membership payments into generic non-membership receipts, safely isolating or removing those balance lines out of the active membership core.

🔄 3. Convert to Membership

The inverse of Process 2. Re-introduces non-membership fund entries back into the system as unallocated lines, preparing them to be applied via Process 1.

ℹ️ Membership Credits: Please note that the allocation utility cannot process unallocated membership Credits.

1. Allocate Unallocated Membership Transactions

Filter Payments
Narrow down your selection to target specific members and unallocated payments. Filter criteria options include Member and Date Range. Leaving filters blank returns all unallocated lines system-wide.
Select Unallocated Payment Lines
Check the desired entry checkboxes within the main table view. Toggle the header checkbox to capture all rows.

💡 Batch Limit: Multi-row selection captures up to 500 entries per transaction batch. Larger ledger updates must be run sequentially.
Validate Unallocated Transactions
Check the “Validate selection for Allocating to Membership Billing Lines” checkbox. The interface filters down exclusively to your selections, and an Unpaid Billing Lines child-table displays right below (sorted oldest to newest).
- Tip: To direct allocations exclusively toward an individual membership, narrow your view using the Membership Assignment selection dropdown.
- Note: Selected items visually appear unchecked post-validation; this grid refresh cycle is expected.
Execute Allocations
Click Allocate Selected Payment Line(s) and confirm. The process will automatically apply funds starting with the oldest balances first, processing split records where necessary.
📊 Automatic Splitting Example:
Allocating a single £100 payment against two open Billing Lines requiring £70 and £30 respectively:
- £70 clears the oldest open Billing Line.
- The remaining £30 clears the second line sequentially.
- Any leftover unmatched payment balance (e.g., if the payment was £110 instead) will remain safely unallocated.
Split accounting profiles are updated in both the Membership and Receipts/Payments.
⚠️ Accounting Rule Override Warning: If system-wide Accounting Rules are configured, execution will enforce them dynamically. This behavior may alter or overwrite targeted Cost Codes, Events, or Funds on your processed lines.
Review and Verify / Undo Options
The layout updates with a clear comparative view. To reverse a mistake, click Delete Allocation Batch to pull back allocations and cleanly reset any split payments. Historical distributions can be targeted via the Select Allocation Batch filter top-of-page.

2. Convert Unallocated Membership Transactions into Non-Membership Transactions

Filter and Select Entries
Narrow down your selection to target specific members and payments via Member or Date Range parameters. Check target lines up to the standard 500-row limit batch maximum.
Validate for Conversion
Check the “Validate selection for conversion to Non-Membership Transactions” confirmation checkbox.
- Note: While “Member Balances” lines remain selectable here, they carry no matching Receipt/Payment records and will bypass matching outputs.
Finalise Processing
Click Convert Unallocated Payment Lines to Non-Membership Transactions. This operation will deletes the matching Unallocated Payment lines out of the active Membership view entirely.

ℹ️ Note: The system will safely process prior period (Age-locked) or Reconciled statements, as changing classification labels here does not alter underlying reported account balances.
Reversing Conversions
Mass rollbacks are not available for conversions. To undo an entry, navigate to individual files inside the tracking grid, click the View/Edit icon, and manually restore settings. Note: Age-locked profiles will require a temporary change to your Financial Year-End prior to altering fields.

3. Convert Non-Membership Transactions to Unallocated Membership Payments

Navigate and Filter
Switch over to the dedicated Non-Membership Transactions Tab. Filter lines by Member name or custom accounting Date Ranges.
Select and Validate Rows
Check transaction lines (500 maximum batch limitation applies) and confirm by tracking the “Validate selection for conversion to Unallocated Membership Transactions” box.
Execute Re-Conversion
Click Convert Non-Membership Lines to Unallocated Transactions. This converts these member payments into Unallocated Membership Payments, making them fully eligible for allocation via Process 1.
Reversing Re-Conversions
Mass-undo is unavailable. However, lines can easily be corrected back into standard non-membership slots by running them through Process 2 at any time.

🔄 Resetting Processes: If you make an error or need to clear selections mid-setup during any step above, hit the Restart Process button to wipe current filters and start fresh.