Consignment Payout Reconciliation for Resale Retail
What Makes Consignment Retail Different?
In a conventional retail business, the shop owns what it sells. Inventory is an asset, the full sale price is revenue, and reconciliation ends when the customer’s money is banked.
Consignment inverts that. The item belongs to the consignor until it sells. The retailer holds it, markets it, sells it, and then owes the consignor an agreed share. Two consequences follow, and both change how reconciliation works.
The first is that gross sales are not revenue. Under IFRS 15, the question is whether the entity controls the goods before transfer and therefore acts as principal, or arranges the sale for another party and acts as agent. Where the retailer is an agent, revenue is the commission rather than the full ticket price — a distinction summarised in the IFRS 15 principal versus agent guidance. Treating gross sales as revenue overstates the top line and makes every downstream reconciliation disagree with the ledger.
The second is that one sale creates two obligations. The customer owes the retailer, and the retailer owes the consignor. Both need reconciling, and they resolve on completely different clocks.
Why Is the Consignor Side Harder Than the Customer Side?
The customer side is a payment problem, and it is well understood: money arrives through card, transfer or cash, and gets matched against the order.
The consignor side is a calculation problem with a payment attached, and the calculation is where it goes wrong.
The split is per item, not per order. A single customer order can contain items from several consignors at several commission rates. The payment arrives as one amount; the obligation it creates fragments across multiple payees.
Commission terms are not uniform. Rates commonly vary by consignor, by category, by item value band, or by how long the item took to sell. A single global rate is the exception.
The payable is created by an event the consignor cannot see. The consignor’s entitlement crystallises when the item sells, which may be weeks after they handed it over and before the retailer has been paid by the payment processor.
Reversals flow backwards. A customer return after a consignor has been paid creates a recoverable, not just a journal entry. Unsold items eventually return to the consignor, which closes the relationship for that item without any money moving at all.
What Are the Two Reconciliation Chains?
Modelling consignment as one reconciliation is the usual design error. There are two, and they share exactly one record — the matched sale.
| Chain | Proves | Runs from | Resolves when |
|---|---|---|---|
| Customer side | The sale was collected and banked | Order to payment to bank | Payment settles and clears the bank |
| Consignor side | The correct share was calculated and paid out | Sold item to payable to payout | Payout is made and acknowledged |
The shared record matters. If the consignor payable is calculated from a sales export while the customer side is reconciled from a matched payment file, the two will diverge quietly — most often when an order is refunded, amended or partially collected after the payable has already been raised.
The customer chain is covered in our POS reconciliation guide. This article is about the second chain and the join between them.
How Should Consignor Payables Be Reconciled?
Four controls do most of the work.
Reconcile the payable to sold items, not to a period total. Every consignor payable balance should decompose into individual sold items with their commission rate and calculated split. A balance that can only be agreed in total is a balance nobody can dispute intelligently when the consignor queries it.
Validate the commission rate per line at calculation time. Apply the consignor’s contracted rate from the agreement rather than a default, and flag any line where the applied rate differs from the expected one. Rate drift is easy to introduce and almost impossible to find later.
Hold the payable until the underlying sale is collected, if that is the agreed term. Many agreements entitle the consignor to payment only once the retailer has received the funds. If so, the payable should be driven by the reconciled customer chain, which means the two chains must be joined rather than run in parallel.
Track unsold inventory as an obligation to return. Items that do not sell are still the consignor’s property. They need an explicit lifecycle ending in return or in a renegotiated arrangement, not an open position that quietly ages in a spreadsheet.
What Does the Calculation Look Like?
The arithmetic is simple; the bookkeeping is where errors enter. The figures below are illustrative.
| Step | Amount | Note |
|---|---|---|
| Customer pays for the item | 4,000 | Collected through the customer chain |
| Payment processing deducted | -90 | Belongs to the retailer unless the agreement says otherwise |
| Net received by the retailer | 3,910 | Reconciled to the bank credit |
| Consignor share at agreed rate | -2,800 | Calculated on the agreed base, not on net cash |
| Retailer commission | 1,200 | This, not the 4,000, is the revenue figure where the retailer is an agent |
The line that causes most disputes is the base for the consignor’s share. Whether it is calculated on the ticket price or on the amount after payment fees is a contractual question, and it must be configured per agreement rather than assumed. Getting it wrong is invisible on any single item and material across a period.
How Do You Automate This Step by Step?
Step 1: Make the agreement machine-readable. Record each consignor’s commission structure — the rate, the base it applies to, and any variation by category, value band or time to sell — as data rather than as a PDF in a folder.
Step 2: Join the payable to the matched sale. Generate the consignor payable from the reconciled sale record so that refunds, amendments and partial collections flow through automatically instead of being corrected by hand.
Step 3: Calculate and validate per line. Compute each consignor’s share per sold item, compare the applied rate with the contracted rate, and raise an exception on any mismatch before the payout run rather than after.
Step 4: Apply the payment condition. If the agreement pays only on collection, hold lines whose customer payment has not yet cleared, and release them automatically once the customer chain reconciles.
Step 5: Run the payout and reconcile it back. Pay the approved lines, match each payout to the bank debit, and clear the corresponding payable lines rather than the balance in aggregate.
Step 6: Close out unsold items. Track items that did not sell to an explicit outcome — returned, renegotiated or retained — so the consignor relationship has no open positions carried on trust.
How Does Peakflo Spaces Handle Consignment Reconciliation?
Peakflo Spaces gives finance and operations teams a shared workspace where AI agents run recurring finance work under human review. For consignment retail, the relevant point is that both chains run off one matched sale record.
One sale, two outputs. The customer-side match produces both the collection evidence and the consignor payable, so the two can never drift apart through separate exports.
Per-line commission validation. Contracted rates are held as configuration and applied per item, with any deviation surfaced as an exception showing the arithmetic rather than a total that silently differs.
Collection-linked release. Where payouts depend on the customer payment clearing, payable lines are held and released by the reconciled customer chain rather than by a manual check.
Payout reconciliation back to the bank. Each payout run is matched to the bank debit and clears individual payable lines, so a consignor balance always decomposes into items.
Statements consignors can check. Because the payable resolves to item level, a consignor query is answered with the line, the rate and the sale, which is also what makes supplier statement reconciliation tractable on the conventional AP side.
Our Verdict: When to Automate the Consignor Side
Automate now if
- You hold items from more than a handful of consignors on varying commission terms.
- Consignor payouts are calculated in a spreadsheet separate from your sales reconciliation.
- Payouts are conditional on the customer payment clearing.
- Consignor queries are answered by rebuilding the calculation rather than by looking it up.
Fix prerequisites first if
- Commission terms exist only as documents and have never been captured as data.
- Sold items cannot be tied to a specific consignor record in your systems.
- Unsold inventory has no lifecycle beyond a status field nobody maintains.
Our recommendation: start by generating the consignor payable from the reconciled sale rather than from a sales export. It is the smallest change with the largest effect, because it eliminates the entire class of errors where a refunded or amended order has already produced a payout.
Conclusion: Two Chains, One Record
Consignment retail is not conventional retail with an extra payment run. It is two reconciliations hanging off a single sale, resolving on different clocks, with a calculation in the middle that is contractual rather than arithmetical.
Teams that join the chains at the matched sale get a consignor payable that is always explicable at item level and a revenue figure that reflects the agent relationship correctly. Teams that run them separately get two sets of numbers that agree in most periods and quietly disagree in the ones that matter.
Next steps:
- Capture every consignor’s commission structure as data, including the base it applies to.
- Generate consignor payables from the reconciled sale rather than from a sales export.
- Validate the applied rate against the contracted rate on every line.
- Confirm whether payouts are conditional on collection, and enforce it automatically.
- Give unsold items an explicit lifecycle ending in return or renegotiation.
See both reconciliation chains on your own data
Bring one period of sales, collections and consignor agreements, and see the customer-side match, the per-item consignor payable and the payout reconciliation in a single reviewed workflow. Request a demo.
Frequently Asked Questions
What is consignment payout reconciliation?
Consignment payout reconciliation proves that each consignor received the correct share of the items they sold through the retailer. It links every sold item to a commission calculation, a payable line and an eventual payout matched to the bank, so the balance owed can always be broken down to item level.
Why are gross sales not revenue in a consignment business?
Because the retailer may be acting as an agent rather than as principal. Where the entity arranges a sale on behalf of another party rather than controlling the goods, revenue is the commission earned rather than the full ticket price. Recording gross sales as revenue overstates the top line.
How is the consignor’s share usually calculated?
It is a contracted rate applied to an agreed base, and both vary by agreement. Rates commonly differ by consignor, category, value band or time to sell, and the base may be the ticket price or the amount after payment processing fees. Both must be configured per agreement rather than assumed.
Should payment processing fees be deducted before the consignor split?
That is a contractual question, not an accounting one. Some agreements calculate the consignor share on the ticket price and leave processing fees with the retailer; others calculate on net proceeds. The system must apply whichever the agreement specifies, per consignor.
When does the consignor become entitled to payment?
Usually when the item sells, but many agreements make payment conditional on the retailer first receiving cleared funds from the customer. Where that applies, the payable should be released by the reconciled customer payment rather than by a manual check.
What happens when a customer returns a consigned item after payout?
The retailer has paid out against a sale that no longer exists, which creates a recoverable from the consignor rather than a simple reversal. Generating payables from the reconciled sale record prevents most of these by holding the payout until collection is confirmed.
How should unsold consignment inventory be treated?
It remains the consignor’s property and represents an obligation to return rather than retailer inventory. Each item needs an explicit lifecycle ending in return, renegotiation or retention, otherwise open positions age indefinitely with no owner.
Why should the payable reconcile to items rather than to a period total?
Because a consignor query can only be answered properly at item level. A balance agreed only in total cannot be defended line by line, so disputes get settled from memory and rate errors stay hidden across periods.
Can one customer order contain items from several consignors?
Yes, and it commonly does. A single payment then creates obligations to several payees at potentially different commission rates, which is why the consignor calculation must run per item while the customer-side match runs per order.
How does consignment reconciliation relate to POS reconciliation?
They are two chains sharing one record. POS reconciliation proves the customer’s money was collected and banked; consignment reconciliation proves the correct share went back out. Both should be driven by the same matched sale so they cannot diverge.
What causes consignor payable balances to drift?
Most commonly, calculating payables from a sales export while reconciling collections separately. Refunds, order amendments and partial collections then update one side and not the other, and the difference accumulates until someone rebuilds the schedule by hand.
Does this apply to marketplaces and resale platforms as well as physical stores?
Yes. Any business selling goods it does not own faces the same two-chain structure, whether the sale happens on a shop floor, an online store or a social commerce channel. Only the customer-side settlement behaviour differs by channel.