Purpose
These reports help stores maintain financial accuracy, prevent fraud, and manage consignor account activity with transparency. Whether you're auditing payouts, tracking rent payments, or monitoring stale balances, these reports offer focused insights.
To learn more about creating customer reports, please view our Custom Reports Overview guide.
Report Setup
Consignor Positive Pay
Description:
The Positive Pay report helps protect against check fraud by listing critical check payout details. By exporting and comparing this report to your bank’s cleared checks, you can quickly spot unauthorized transactions.
Base:
Payout Activity
Fields to Include:
| Field Name | Description |
| Date Created | When the payout was recorded |
| Check # | Check number associated with payout |
| First Name | Consignor’s first name |
| Last Name | Consignor’s last name |
| Payout By | Method used for payout (Check, ACH) |
| Amount | Payout amount |
Filters:
| Filter | Use Case |
| Date Created is ___ | View payouts from a specific date |
Consignor Aged Balances
Description:
Use this report to identify consignors with stale balances — accounts with funds that haven’t been touched in a long time. This is especially valuable for initiating outreach or preparing for unclaimed property audits.
Base:
Consignor
Fields to Include:
| Field Name | Description |
| Consignor Created | Date the consignor was added |
| Consignor ID | Unique identifier |
| Consignor Status | Active/inactive status |
| Last Activity Date | Last date any account activity occurred |
| First Name | Consignor’s first name |
| Last Name | Consignor’s last name |
| Balance | Current balance held |
Filters:
| Filter | Use Case |
| Balance is greater than 0.00 | Limit to consignors with a balance |
| Last Activity Date is before [Date] | Find balances with long inactivity |
⚠ Before adjusting balances, consult your accountant or local regulations regarding unclaimed property.
Consignor Rent Paid
Description:
This report tracks which consignors have been charged rent for item-based storage or display fees. It ensures rent policies are enforced and helps monitor fee collection activity across all consignors.
Base:
Consignor Account Activity
Fields to Include:
| Field Name | Description |
| Consignor ID | Internal account number |
| Date Created | Date of the fee |
| Amount | Fee charged |
| Description | Description of the charge |
| Account Entry Status | Status (Active, Voided, etc.) |
| Created by Monthly Fee | Flag for recurring item rent charges |
Filters:
| Filter | Use Case |
| Created by Monthly Fee is true | Show only rent-related transactions |
| Date Created is after [MM/DD/YYYY] | Track payments for the current month |
| Account Entry Status is Active | Exclude voided or inactive entries |
Manual Account Adjustments
Description:
Audit manual changes to consignor accounts such as custom credits, corrections, or penalties. This report enhances transparency by showing who made each change and why.
Base:
Consignor Account Activity
Fields to Include:
| Field Name | Description |
| Date Created | When the adjustment was made |
| Description | Notes or reasoning for the adjustment |
| Amount | Value of the adjustment |
| Consignor ID | Internal account number |
| First Name | Consignor’s first name |
| Last Name | Consignor’s last name |
| Created By User | User who performed the adjustment |
Filters:
| Filter | Use Case |
| Manual Adjustment is true | Limit to only manual account changes |
| Date Created is after [MM/DD/YYYY] | Start of audit range |
| Date Created is before [MM/DD/YYYY] | End of audit range |
Tips
-
Use Aged Balances to prepare for escheatment audits.
-
Positive Pay exports can be matched with bank-issued check clearing reports.
-
Keep Manual Adjustment reports secure for internal use only.