Automated Music Store Consignment Payout Digest
On the first Monday of each month, WebRun opens RAIN POS, pulls all consignment sales from the prior month, calculates each consignor's payout at your agreed split, logs the breakdown to a Google Sheet, and drafts a payout summary email in Gmail for each consignor, queued for your review before sending.
How do I automatically calculate and draft consignment payouts for my music store?
On the first Monday of each month, WebRun opens RAIN POS, pulls all consignment sales from the prior month, calculates each consignor's net payout at your agreed split, logs the breakdown to a Google Sheet, and drafts a payout summary email in Gmail for each consignor. All emails await your approval before any consignor is contacted.
- Monthly consignment payouts calculated automatically without manual spreadsheet work
- Each consignor's payout detailed at the item level for full transparency
- No payout email sent until you review and confirm the amounts
Built for music store owners · instrument retailers running consignment · used instrument consignment managers
What does WebRun do on every run?
The exact actions WebRun takes, in order - in plain language, so you can adjust anything.
-
WebRun signs in and gets to work
Opens
app.rainpos.comin a real browser with your saved login - no setup, no API keys. -
1
RAIN POS - pull last month's consignment sales
rainpos.com
WebRun opens RAIN POS to pull last month's consignment sales. - Open RAIN POS and run the consignment sales report for the previous month
- Pull each sold consignment item with its sale price, consignor name, and agreed split percentage
- Group sales by consignor and calculate the gross payout for each
- Deduct any agreed fees or store charges and calculate the net payout per consignor
- Flag any consignment item returned or unsold that may affect the payout
Done when All consignment sales are tallied and a net payout figure is calculated for each consignor.
-
2
Google Sheets - log payout calculations by consignor
google.com
WebRun opens Google Sheets to log payout calculations by consignor. - Open the consignment payout tracking sheet
- Append a section dated with last month's period
- Log each consignor's items sold, gross sales, split percentage, deductions, and net payout
- Add a total row for the month showing the combined payout liability
Done when The sheet has a complete payout record for all consignors for the prior month.
-
3
Gmail - draft payout summary email for each consignor
gmail.com
WebRun opens Gmail to draft payout summary email for each consignor. - Draft a payout summary email for each consignor listing their items sold, sale prices, and calculated net payout
- Include a note on any deductions applied
- Save every email as a Gmail draft. Do not send automatically
- Leave drafts for your review so you can confirm payout amounts before contacting consignors
Done when Draft payout emails are saved in Gmail for every consignor, none sent, awaiting your approval.
How is each run configured?
Secure by default
Connect once, stays signed in
WebRun signs in once and keeps each session in a persistent environment, so every run picks up right where it left off.
Every action is checked against this policy before it runs.
Questions, answered
Will it send the payout email or transfer funds automatically?
No. Every payout email is saved as a Gmail draft for your review, and no payment is ever initiated automatically. You confirm the amounts and send the emails yourself.
How does it know my consignment split percentage?
You configure the default split during setup. If individual consignors have different agreed rates, those are read from RAIN POS's consignment records.
What happens if a consignment item was returned or is still unsold?
Unsold and returned items are flagged in the report and excluded from the payout calculation, so consignors are only credited for items that actually sold.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.