How to pay antique mall vendors when you use Square
How to pay antique mall vendors when your register is Square: tie sales to vendors, work out commission and rent, then pay on schedule.
If you run an antique mall, booth rental shop or consignment store on Square, you've probably hit the same wall: Square is great at taking payments and has no idea what a vendor is. Every sale lands in one pile, and at the end of the month you have to work out who is owed what.
This is how to set that up so it's not a weekend of spreadsheet work, whether or not you ever use VendNex.
The core problem
When a customer buys a $40 lamp, Square records a $40 sale for your shop. Nothing in that record says the lamp belongs to the vendor in booth 12. To pay vendors correctly, every sale has to be tied back to a vendor somehow. Everything else is arithmetic.
Step 1: give every vendor a short code
Pick a code that's quick to read off a price tag and unlikely to be confused with another booth. Initials of the booth name usually work: MPLM for Maple Antiques, HTRE for Hollow Tree. Codes must be unique across your shop. A tag that says "MPLM $40" tells the person at the register, and you later on, exactly whose item it is.
Step 2: make sure each item is linked to its vendor in Square
There are two common ways to do it, and you can mix them:
- By item. Each product in your Square catalog is connected to one vendor. This is precise, but someone has to do it for every new item.
- By category. Create a Square category for each vendor, and put their items in it. Anything added to that category later belongs to that vendor automatically. For most malls this is the lower-maintenance option.
A lot of malls also ring items up as one-off custom amounts at the register. That works, but only if the vendor code is typed in the item name or note, which makes the math harder later. If you can, ring up from the catalog.
Step 3: handle the exceptions before they pile up
Four things cause most of the month-end headaches:
- Unassigned items. A sale for an item no vendor is attached to has no owner. When a vendor says a sale is missing from their statement, this is the first thing to check.
- Refunds. A refunded sale shouldn't count toward the vendor's total, and the commission on it comes back too.
- Sales tax. Decide whether the shop keeps it and remits it, or whether it passes through to the vendor, and be consistent. It should never be mixed into commission.
- Cash. Cash you ring up in Square is still a Square sale. Cash you take without entering it anywhere isn't recorded at all, so it has to be tracked separately and added by hand.
Step 4: work out each vendor's payout
For each vendor, for the month:
- Add up their sales, after refunds.
- Subtract your commission (a percentage).
- Subtract any fees: a flat monthly booth fee, a processing fee, anything in your vendor agreement.
- Add sales tax only if it passes through to them.
If you'd rather not build the spreadsheet yourself, the free vendor payout calculator does this math for a list of vendors, and you can download a ready-made spreadsheet template from the same page.
Doing this by hand means exporting Square's item or category sales report to a spreadsheet each month, splitting it by vendor, and checking the totals against the report. It works for a handful of vendors. By twenty or thirty, it is a monthly chore that's easy to get wrong.
Step 5: pay them, and say what you paid
Whatever you use, give each vendor a statement that shows their sales, your commission, any fees and the final amount. A vendor who can see the breakdown rarely argues about it, and one who only gets a number often does.
Where VendNex fits
VendNex automates steps 2 to 5. You connect your Square account, assign items or categories to vendors, and sales are attributed as they come in. Commission, custom fees, refunds and sales tax are calculated for you, each vendor gets their own login to see exactly what they're owed, and when you're ready you can send each vendor's payout straight to their bank account or debit card. You keep using Square at the register exactly as before.
There's a free 14-day trial on every plan, and the setup guide is in the docs. If you'd like to see how the commission math itself works first, start with how vendor commission splits actually work.