Premium showrooms pay architects 5 to 15 percent on end-customer purchases. The system needs project-linked enquiries, multi-month attribution, and clean payout records. Excel breaks at 30 architects.
By Mohammad Jamnagarwala · Simply Five Studio
A premium sanitaryware showroom in Chennai had a problem that started small and grew quietly through 2023. Their relationship with the architect community was the single largest driver of qualified walk-ins. Architects sent their interior-designer clients in for tile and fixture selections. The showroom paid the architect a commission, typically between 5 and 15 percent of the end-customer purchase value, paid out monthly.
By mid-2024, the showroom had 42 active architects on its commission roster. The Excel sheet that tracked which architect had referred which end-customer to which proforma to which order to which payout was 14,000 rows long. The founder's accounts team spent two days a month reconciling it. Three architects had stopped sending referrals because they suspected they had been under-paid on commissions. The founder could not prove they had not been, because the audit trail was a chain of spreadsheet edits with no version history.
This essay is about why commission tracking for premium showrooms is a software problem, what the system actually needs to do, and what happens when the founder treats it as an Excel problem instead.
The transaction has more parties and more time than a normal retail sale. The architect refers an end-customer to the showroom. The end-customer is the buyer. The architect is the influencer, paid by the showroom. The end-customer's spouse, contractor, or designer may also influence the choice. The purchase is rarely a single transaction. It is multiple proformas across multiple visits, sometimes over six to nine months, ending in one or more orders.
The commission is calculated on the final purchase value, net of returns and credit notes. The percentage depends on the architect tier (firms with higher referral volume earn higher percentages), the product category (some categories carry lower commissions because the margin is thinner), and any project-specific terms (a flagship residential project might carry a different percentage by negotiation).
The payout happens monthly. The architect receives a statement showing each end-customer purchase attributed to them, the commission earned per purchase, and the total payable. Disputes happen when the architect's expectation differs from the showroom's record.
Excel handles the first 10 architects reasonably. The sheet has a column for the architect, a column for the customer, a column for the proforma number, a column for the final invoice number, a column for the invoice value, a column for the commission percentage, and a column for the commission amount. Anyone can read it.
The first failure mode appears around 25 architects. The sheet starts holding 4,000 to 6,000 rows. Filtering becomes slow. Two team members editing the same sheet produces conflicts. The version that exists at month-end is not the same version anyone remembers approving.
The second failure mode appears around 30 architects. End-customers start showing up on multiple architects' lists, because two architects were involved in the same project. The attribution rules need to handle splits. Excel does not enforce attribution rules. Whoever writes the row decides the split. The founder discovers the inconsistency only when an architect complains.
The third failure mode appears around 40 architects. Some end-customers come back six months after the original proforma to place an order. The showroom team has rotated. The salesperson who originally captured the architect attribution has left. The new salesperson does not know who referred this customer. The commission gets missed. The architect notices three months later and demands a back-payment.
By the time the showroom has 50 architects, the Excel sheet is no longer a record. It is a fiction maintained by the accounts team, contested by half the architects on it, and trusted by no one including the founder.
The system has to capture the architect attribution at the moment the end-customer is first registered. The walk-in capture, which is already happening for every customer in a properly run showroom CRM, has to include a field for the referring architect, the project name, and any split notation. We have written about the broader walk-in capture discipline in our piece on walk-in qualification for high-ticket retail.
The system has to persist the attribution across the multi-visit decision journey. Every proforma generated for that customer carries the attribution. Every revision carries it. The final order carries it. The invoice carries it. The credit notes against the invoice carry it. The attribution is structural data, not a tag.
The system has to compute commission against defined rules. The rules carry architect tier, product category overrides, and project-specific terms. The computation runs against final realised value, net of credits. The computation is reproducible: given the same inputs, the same answer comes out every time.
The system has to produce architect statements. Monthly, by architect, showing each attributed purchase, the commission earned, and the total payable. The statement should be downloadable as a PDF and shareable on WhatsApp, in the same way that any other branded document moves through the system. We documented this branded-PDF discipline in our piece on decision infrastructure for founder-led businesses.
The system has to handle splits and adjustments. Two architects on one project. A late-attribution correction. A returned item that reduces the commission. These are first-class workflows, not exceptions handled by the accounts team in a parallel sheet.
The system has to produce an audit trail. Every change to attribution, percentage, or payable amount has to be recorded with a timestamp and a user. When an architect disputes a payout, the founder can reconstruct exactly what happened, when, and by whom.
The ERP we built for TNCC Arkadia, a premium ceramic-tile and sanitaryware showroom in Chennai, handles the attribution chain from walk-in capture through proforma generation through order placement through invoice. The architect is a first-class entity in the customer relationship. Commission rules sit in the configuration layer. Statements generate automatically at month-end. The accounts team's reconciliation work compresses from two days to two hours.
The same architectural pattern applies to other multi-stakeholder buying journeys we have built for, including the showroom configuration documented in our case work for Car Seat Wala's retail ERP, where customer-to-installer-to-fitter chains carry similar attribution dynamics in a different category.
The temptation, when commission tracking gets messy, is to treat it as an accounting problem. Hire another person. Buy a commission management module from an accounting suite. Cut Excel into multiple sheets and divide by region.
This frames the problem incorrectly. Commission tracking is not an accounting concern. It is a growth concern. The architect referrals are the single most expensive customer acquisition channel the showroom operates. Every disputed payout damages the channel. Every missed attribution shortens the architect's loyalty. Every quiet under-payment migrates referrals to a competing showroom that pays cleanly.
The right framing is that commission infrastructure protects the channel. The investment in a fitted system pays back through retained architect relationships, which pays back through continued referrals, which pays back through end-customer purchases. The math is direct.
A founder running a premium showroom with more than 20 architects on commission should treat the tracking system as part of the firm's internal systems backbone. Excel is the symptom of an unrecognised infrastructure problem. The fix is bounded and produces a permanent shift in how the channel operates.
Decision infrastructure for a premium showroom includes the architect statement that the architect trusts without phoning the founder. When that trust holds, the channel compounds. When it breaks, the channel decays in silence and the founder discovers the loss in lagging quarterly numbers.
The median time from RFQ received to quote sent predicts close rate more reliably than any other sales metric. Industries with twenty-four-hour turnaround close thirty to forty percent higher than five-day.
A premium showroom sees 20 to 40 walk-ins a day. Three to five are buyers. The four qualifying questions that separate the two are the difference between busy and profitable.
Storing every shipped invoice, COA, MSDS, and packing list in a customer-facing portal raises reorder rate. In B2B, retention features beat marketing spend on every honest spreadsheet.
The contact form takes about two minutes. The reply comes from the founder within two working days.
