Example Consignor Balance Custom Reports

Have more questions? Submit a request

Consignor Positive Pay

Positive Pay is used by some stores to help prevent fraud by comparing key information for check payments.

Base

Payout Activity

Fields

Date Created, Check #, First Name, Last Name, Payout By, Amount

Filters

Date Created is _____

Consignor Aged Balances

Looking for balances that haven't changed in a while? This report should help.

 

The system will allow you to manually adjust balances. Every state has specific rules surrounding the forfeiture of unclaimed funds. Consult with your accountant or state agency for more information before expiring balances.

 

Base

Consignor

Fields

Consignor Created, Consignor ID, Consignor Status, Last Activity Date, First Name, Last Name, Balance

Filters

Balance is greater than 0.00, AND Last Activity Date is before ____

Consignor Rent Paid

If you use the pay in on specific items feature you can check which consignors haven't paid their rent so far each month.

Base

Consignor Account Activity

Fields

Consignor ID, Date Created, Amount, Description, Account Entry Status, Created by Monthly Fee

Filters

Created By Monthly Fee is true, AND Date Created is after ____, AND Account Entry Status is Active

Screenshot 2024-09-10 at 10.40.21 AM.png

Manual Account Adjustments

If you want to audit any manual account adjustments that have occurred you can use the following report.

Base

Consignor Account Activity

Fields

Date Created, Description, Amount, Consignor ID, First Name, Last Name, Created By User

Filters

Manual Adjustment is true, AND Date Created is after ____, AND Date Created is before ____

Articles in this section

Was this article helpful?
1 out of 1 found this helpful