How to use the consignment settlement calculator
- Paste one line per sale or return: consignor, item, price, and the word sold or returned. Add a fifth value to give a line its own shop share.
- Set the default shop share in percent and the fixed fee per sold item. Both are examples you replace with the terms of your agreement.
- Read the settlement table for each consignor: sales, returns, gross sales, shop commission, fees and payout.
- Use the statement lines table as the item level record, then copy it or download the CSV.
Formula
commission = price x shop share, rounded to cents
payout = price - commission - fee
a return reverses a sale on the same terms: price, commission, fee and payout all change sign
for every line: commission + fee + payout = price
All amounts are in whole cents. Because each line splits the price exactly, the shop’s total and the payouts add up to gross sales with no cents left over.
Three consignors
Ana sold an oak table for $180, a lamp for $65 and a vase for $40 at her own 30% share. At 40% the table gives the shop $72 and a $2 fee, so Ana receives $106. The lamp pays $37 and the vase $26. Ana’s payout is $169.00 on gross sales of $285.00.
Ben sold a coat for $90, then it came back, which cancels that sale, and boots for $120 that pay $70 after a $48 commission and a $2 fee. Cara sold a radio and a mirror for $240 and $75.50, which pay $142.00 and $43.30. Overall the consignors are owed $424.30 out of $720.50, and the shop keeps $296.20.
Returns and negative balances
A return that comes after a payout has been made can leave a consignor owing money. The page shows such a balance as owed to the shop, in parentheses. It reverses a sale at the terms of the line you enter, so give a return the same shop share as the sale it reverses.
Check your agreement for how returns, damaged items and unsold items are treated, and for how soon consignors must be paid. Those terms are not modeled.
Keeping the statement useful
The item level table is what you send to a consignor, and the summary is what you keep. Sort your list by consignor before you paste it if you like, and keep item names consistent from week to week. The fee can be zero.
Send each consignor a statement with the Statement of Account Template, check the shop margin with the Profit Margin Calculator, or work out a commission on a single sale with the Commission Calculator.
Assumptions and limits
- The shop share applies to the price. A fee is a fixed amount per sold item, taken from the consignor.
- Prices must be 0 or more. Shares are percentages from 0 to 100.
- Up to 1,000 lines are read. Names of consignors are matched exactly as typed, ignoring nothing.
- Sales tax, payment processing costs and the time limits for paying consignors are not modeled.
- Nothing typed here leaves your browser.
Frequently asked questions
How is a return handled?
It is entered as a line with the word returned and reverses the sale on the same terms. The price, commission, fee and payout of that line are negative, and they net against the sale in the totals.
Can different consignors have different shares?
Yes. Add the share in percent as a fifth value on any line, and that line uses it instead of the default. Lines without one use the default.
Does the fee come out of the consignor’s share?
Yes. The payout is the price minus the commission minus the fee. The fee is kept by the shop, so the shop’s take is the commission plus the fee.
What if a payout comes out negative?
A price below the commission plus the fee gives a negative line, and the total for a consignor can be negative after returns. The page shows it in parentheses with a note that the consignor owes the shop.