Consignment Shop Monthly Settlement for Google Sheets & Excel
Know exactly what you owe every consignor, every month · by Unelify
$29USD · one-time payment
Buy nowInstant download after payment. You get a PDF with your Google Sheets links (a blank copy and an example) and the Excel files. A free Google account is enough.
- Instant digital download, nothing is shipped
- Works in Google Sheets and Microsoft Excel
- Pay now for every consignor, each month: share of sales, refunds, charges, what you paid and what is carried over
- Log sales by tag number; link returns and price refunds to the original sale, and cancel mistakes with a Void
- Printable consignor statements and drop-off receipts with your own terms
- Every item with its days in the shop and the date its time is up
- Check your totals against the figures from your POS, then close the month
- 4 color sets and your own words for the labels
- Made to work on a phone too
Know exactly what you owe every consignor
Type your items and every sale, return and refund as they happen. At the end of the month, Payouts shows each consignor's share of sales, refunds, charges and credits, what was still owed from earlier months, what you have paid and what is carried to next month, with one number to pay now. Amounts below your minimum payout are carried over for you. Print a statement for each consignor, a receipt with your terms when they drop items off, and check the month against your POS before you close it.
How it works
- Set it upOn Settings: your shop name and contact line, currency, usual consignor %, consignment period, minimum payout and your drop-off terms. In Google Sheets, first set your Locale (country) and Time zone (File > Settings), before entering dates.
- Add your consignorsAn ID, the name and their usual %. Anything you already owed goes under Starting balance.
- Tag the itemsTag #, consignor ID, item and tag price, then the agreed % and the date received.
- Log every saleEvery sale, return and price refund, with the amount your consignor agreement splits. The item, consignor and both shares fill in by themselves.
- Settle up each monthPay what Pay now shows, add the payouts on Payments, print the statements and close the month.
What's inside
Pay now, paid and to pay for the month; one row per consignor from brought forward to carried; check against your POS; close the month.
A printable statement for any consignor and month: a summary and every line, one page per part.
Up to 3,000 lines: sales, returns, price refunds and voids, with a tag look-up and a check on every line.
Up to 3,000 items: tag price, agreed %, date received, the date their time is up, days in the shop and status.
Up to 150 consignors: usual %, payout method, starting balance, items in the shop and what you owe now.
Up to 1,000 lines: payouts, returned payouts, charges, credits and refunds of sales made before this file.
A drop-off receipt with your terms, two signature lines and the items received.
Shop name, currency, usual %, consignment period, minimum payout, colors, your terms, your own words and closed months.
Questions
Does it calculate sales tax?
No. Type sale amounts the way your consignor agreement splits them, on the same basis as your tag prices. The file does not calculate or remove sales tax, GST or HST. It does the math with your own figures and is not tax, legal or accounting advice.
Does it connect to my POS?
No. You type your POS's net sales of consigned items for the month (and, if you like, the item count) and the file tells you whether they match its own totals.
What if I type a line by mistake?
Add a Void: it cancels the line and keeps your history. A line that needs a fix turns light red, the message at the top names its row, Affected payouts are held back until the line is fixed. If the consignor cannot be identified, all payouts are held back. A returned check is a Payout reversal.
Can each item have its own split?
Yes. Each consignor has a usual %, and each item has its own agreed %, so a different split for one item is no problem.
Can my staff use it?
Yes. In Google Sheets, share your copy with your staff and you can all type in it.
Do I need Microsoft Excel?
No. Google Sheets is free with a Google account; on a phone, use the free Google Sheets app. If you prefer Excel, the Excel files are included too: a blank file and an example.
How do I get my copy in Google Sheets?
Open the PDF you download and tap a button: a blank copy or an example. Then tap "Use template". A copy is saved in your own Google Drive.
Which currencies can I use?
Pick one from the list on Settings (US, Canadian and Australian dollars and more) or type your own currency sign. Amounts show 2 decimals, and there is no exchange-rate conversion.
How do the statements print?
On Letter or A4, one page per part. In Excel, use File > Print. In Google Sheets, the line above the statement names the cells to print. Save each statement as a PDF too.
What happens when the file is full?
Start a new copy, type each consignor's balance as their starting balance and copy the unsold items with their original dates and %. For refunds of sales recorded in the old file, use Old-file refund on Payments in the new copy.