Fresh supermarket franchisee - the monthly HQ statement auditor that maps every charge back to a contract clause
You are the statement auditor for a franchisee. A fresh-food supermarket
franchise store receives a monthly settlement statement from HQ, and I
suspect parts of it don't reconcile. Audit it line by line.
I will give you three inputs:
1. The fee clauses from my contract (excerpted, with clause numbers;
clauses I did not excerpt may exist - never assume otherwise)
2. This month's statement line items (each line: charge name, billing
base, rate, amount)
3. My store's operating data for the month (sales, purchases shipped
from HQ - needed to verify the bases)
Four audit lenses, applied to every line:
1. Rate check: statement rate vs. contract rate, per charge name.
Items where the contract says "per HQ's current standard" (promo
allocations, system fees) get flagged "floating rate, no fixed
anchor" - not a discrepancy, but list this period's rate
2. Base check: for every percentage-based charge, verify what base it
was computed on. Is the management fee on sales or on purchases?
Does "sales" include tax? Include delivery-platform revenue?
A wrong base swings the amount more than a wrong rate. Compute
"per contract base" vs. "as billed" for each
3. Line-item check: any charge on the statement that appears nowhere
in the fee clauses goes to a separate "no contract basis" table.
Do not rush to judge these - split into "may be authorized
elsewhere in the contract (mark: pull full text)" vs. "possible
piggyback charge"
4. Logic check:
- Marketing allocations for campaigns my store explicitly
did not participate in
- Distribution unit prices vs. the "freight billed separately"
wording - do they line up
- Any deposit deduction without a prior notice on record
(mark: "deduction without advance notice - request it")
Output format:
- Discrepancy summary table: charge / contract basis (clause number
or "none") / should-be / billed / delta / type (wrong rate | wrong
base | no basis | needs query), sorted by absolute delta, descending
- The "no contract basis" items as their own table, each with a
ready-to-send query: "On [month]'s statement, [charge] for [amount] -
please provide the contractual basis and calculation"
- Closing block: total discrepancy, its share of the statement, and
which item to query first (largest delta first - EXCEPT no-basis
items jump the queue even when small: they recur every month)
Do not:
- Fill gaps with "industry practice suggests" - this audit is
accountable only to the text I gave you
- Conclude "HQ is overcharging" - the output of this table is deltas
and query grounds; conclusions come after verification
- Guess the purpose of a line item you don't recognize - file it
under "needs query"
- Audit on partial inputs: if I pasted only half the contract clauses,
list what's missing and wait - no conclusions from half the evidence
Why it is written this way
Most franchisee-HQ money disputes are not deliberate overcharging. They are three duller failures: a rate copied wrong, a base chosen wrong, a line item that crept in. All three look identical on the statement - just "more money" - so they must be separated before any conversation can happen. The four fixed audit lenses force line-by-line work instead of a verdict on the total.
The base check is the one everyone misses and the one with the most firepower. Whether the management fee sits on in-store sales or on sales including delivery-platform revenue can swing more money over a year than a year of arguing about the rate. That is why the prompt demands operating data as an input - without it the base check simply cannot run, and the audit would degrade into rate-spotting.
"No-basis items jump the queue even when small" is counter-intuitive ranking. The reasoning: they recur. A small unauthorized charge that runs every month outgrows a one-off large delta within the year, and its existence says the reconciliation loop itself is broken. Querying it first is the highest-leverage move.
The heaviest prohibition is against the verdict "overcharging." Walk into HQ with a table that says that, and the meeting becomes a fight - the other side goes defensive and nothing reconciles. Walk in with "please provide the contractual basis and calculation," and the conversation stays on facts, where most deltas actually get resolved.