Patronage Worksheet

Description

A description for this worksheet (e.g., "2025 Annual Patronage").

From Date

The start of the date range for the patronage calculation.

To Date

The end of the date range for the patronage calculation.

Equity Amount

The total equity allocation to distribute across groups.

Equity Account

The GL account for posting equity allocations.

Equity Memo

Memo text that appears on equity posting entries.

Credit Amount

The total credit allocation to distribute across groups.

Credit Account

The GL account for posting credit allocations.

Credit Memo

Memo text that appears on credit posting entries.

Inactive

When checked, this worksheet is marked inactive. The worksheet is automatically set to inactive after posting.

Summary view showing each patronage group and its calculated allocations. Columns include:

Group # / Group Name

Patronage group identifier and name.

Sales

Total sales points for this group.

Purchases

Total purchase points.

Balances

Total balance-change points.

Taxes

Total tax points.

Adjusts

Total manual adjustment points.

Total Points

Sum of all point categories.

Equity

Calculated equity allocation amount.

Credit

Calculated credit allocation amount.

Total Alloc

Combined equity + credit allocation.

Member sales activity for the date range. Double-click a group to see individual customer/department detail.

Customer Detail?

Check to break down sales by individual customer within each group.

Department Detail?

Check to break down sales by department within each group.

Include in Calculations?

Check to include sales points in the patronage total calculation. When unchecked, sales data is shown but not factored into the equity/credit allocation.

Member purchase activity from vendors assigned to patronage groups. Double-click a group for vendor-level detail.

Vendor Detail?

Check to break down purchases by individual vendor within each group.

Purchase Points

A multiplier value applied to purchase amounts to calculate purchase points for the patronage calculation.

Shows customer account balance changes over the date range. Opening balances are compared to closing balances. Double-click for customer detail.

Customer Detail?

Check to break down balance changes by individual customer.

Balance Points

A multiplier value applied to balance change amounts to calculate balance points for the patronage calculation.

Tax amounts collected from members during the period. Up to four tax codes can be selected; the grid reformats to show each selected tax.

Tax 1

First tax code to include in the patronage tax calculation (e.g., GST).

Tax 2

Second tax code (e.g., PST).

Tax 3

Third tax code (optional).

Tax 4

Fourth tax code (optional).

Include in Calculations?

Check to include tax points in the patronage total. When unchecked, tax data is displayed but excluded from equity/credit allocation.

Manual point adjustments that can be added, edited, or removed to fine-tune the patronage calculation before posting.

Group # / Group Name

The patronage group receiving the adjustment.

Points

The number of points to add (positive) or subtract (negative).

Reason

A free-text explanation for the adjustment.

Add

Add a new adjustment.

Edit

Edit the selected adjustment.

Remove

Remove the selected adjustment.

Reload

Recalculate the worksheet from current transaction data. Warns that any manual changes will be lost.

Post

Posts patronage dividends to the General Ledger. Creates Card Adjustments for each patronage group’s equity and credit customer accounts. The worksheet is set to Inactive after posting.

Print

Print the currently visible tab as a report.

Save

Saves the worksheet.

Undo

Reverts changes since the last save.

New

Opens a blank worksheet.

Delete

Deletes the worksheet.

Copy

Duplicates the worksheet.

Groups

Assign the worksheet to security/data groups.

OK

Saves and closes the screen.

Cancel

Closes without saving changes.