Knowing how much money you owe consignors, how they made it, and whether it has been paid out is crucial to running any consignment business.
Our Accounts Summary report aims to answer those questions as succinctly as possible. For a deeper dive, try out the Data Explorer report.
You can find your Accounts Summary under your Reports navigation item. The way this table works is pretty straightforward — the final row is the total of all the rows above it. Here's how the breakdown works:
Consignor Portion of Sales — this is the "split price" of a sold item, times the consignor split (after surcharges and discounts are calculated). This accrues as of the time of a sale or corresponding refund.
Consignor Surcharges — adjustments taken directly out of the consignor's portion per your surcharges. These are included here, not in the Sales Summary because they don't affect the price of an item.
Consignor Credit Used — payments made using store credit. This number should match the Store Credit number in the Sales table.
Buy Outright Purchase Credit — credit based on the cost of buy-outright items entered during the time period.
Arbitrary Balance Adjustments — adjustments manually added to an account.
Settlements — payouts of store credit; these will decrease the balance on an account.
Note that this is not a table of payouts, though that's part of it. Rather, it's a summary of changes to your accounts' balances. This means for example that the total at the bottom may be negative, if more payouts were issued during the time period than credits to consignor accounts.
Other things to know
The date picker is inclusive, meaning the report will show data from the selected days, as well as all the days in between. To view data for a single day, set the date pickers to the same date.