Retail Sales Reporting in Leases: Process and Audit Rights

A retail sales reporting lease requirement is the clause that obliges a tenant to send the landlord a statement of gross sales on a fixed schedule, usually monthly within 15 to 20 days of month end, plus an annual statement certified by an officer of the tenant or an independent accountant within 60 to 90 days of the lease year end. The same clause gives the landlord the right to audit the tenant's books and shifts the audit cost to the tenant if sales were understated by more than a stated threshold, typically 2% or 3%.

If you run accounting for a centre with 40 retail tenants, this clause is the reason you spend the third week of every month sending reminders. It is worth the chase. Tenant sales reports feed three things at once: the percentage rent calculation, the sales-per-square-foot test in co-tenancy clauses, and the tenant sales covenants in the property's loan agreement. A late report breaks all three. The percentage rent invoice cannot go out, the co-tenancy test cannot be run, and the lender's quarterly sales schedule goes in with a blank row.

This guide covers what the lease actually requires, the monthly workflow that gets reports in on time, the annual certified gross sales statement, how the sales audit clause works with a worked cost-shift example, and how to stop collecting reports by email.

The retail sales reporting calendar

Most of the work in sales reporting is calendar discipline, so here is the calendar first. Dates are for a lease with a calendar lease year, monthly reports due on the 15th, an annual statement due within 90 days, and a two-year audit look-back. Adjust to your own lease terms; the sequence is the same.

Two things in that table catch people out. Sales reports are due from tenants who have no percentage rent at all, because the lease still wants the data for co-tenancy and lender purposes, and those tenants are the least motivated to send it. And the annual statement is a separate deliverable from the twelve monthlies; it is not satisfied by the tenant having sent every monthly report.

Why landlords collect sales

Percentage rent is the obvious reason, but it is not the only one, and for a modern shopping centre it is often not the most important one.

• Percentage rent. Where the lease has a percentage rent clause, gross sales are the input to the calculation. Without the monthly figure there is nothing to accrue and nothing to invoice. The mechanics are in our guide to how percentage rent is calculated and the clause language is in our percentage rent clause example.

• Co-tenancy tests. Many retail co-tenancy clauses give the tenant a rent reduction if the centre's occupancy or its sales fall below a threshold. Some are drafted around the centre's aggregate sales per square foot. The landlord cannot demonstrate that the test is passed without sales data from the other tenants, which is why sales reporting obligations sit in leases that have no percentage rent. See how retail co-tenancy clauses work for the test mechanics.

• Lender covenants. Loan agreements on retail assets commonly require the borrower to deliver tenant sales reports, either quarterly or annually, and some set a minimum sales-per-square-foot covenant for anchor tenants. A landlord who cannot collect the reports cannot deliver them, and a missed reporting covenant is a technical default.

• Leasing and asset management. Sales per square foot by tenant and category is how the leasing team prices renewals, decides which tenants to relocate, and shows prospective tenants how the centre trades. It is also what a buyer's due diligence team asks for on day one.

What the lease requires: frequency, certification and format

The reporting clause usually sits inside or next to the percentage rent article and has four elements.

• Frequency and deadline. Monthly is standard for enclosed malls and lifestyle centres. Some strip-centre leases and most leases with national credit tenants are quarterly or annual only, because the tenant's leasing team negotiated it down. The deadline is expressed as a number of days after the end of the reporting period: 15 days is common in landlord forms, 20 or 30 days is common after negotiation. Read the actual number for each tenant. In a 40-tenant centre you will find at least three different deadlines.

• Definition of gross sales. The report is only useful if every tenant is reporting the same thing. The lease defines gross sales, and the definition matters more than the frequency. The usual inclusions are all sales of merchandise and services from or through the premises, including online orders fulfilled from the store, gift card redemptions, and layaway at the time of sale. The usual exclusions are sales tax, returns and refunds, employee sales at a discount (often capped at 1% to 2% of sales), transfers of stock to other stores, gift card sales (counted on redemption, not sale), and delivery charges passed through at cost. Online sales are the contested item in current leases: whether an order placed on the tenant's website and picked up in the store counts as a sale "from the premises" depends entirely on the drafting, and tenants and landlords negotiate it hard.

• Certification. Monthly reports are usually certified by the store manager or the tenant's accounting department, on a form the landlord supplies or accepts. The annual statement carries a heavier certification: signed by an officer of the tenant (typically the CFO or controller) and, in many mall leases, either prepared or reviewed by an independent certified public accountant. Leases for small local tenants sometimes allow the annual statement to be certified by the tenant's own accountant rather than an independent one.

• Format. Older leases say "in a form reasonably satisfactory to Landlord". Newer leases specify the fields: gross sales, exclusions by category, net gross sales, and sometimes transaction count and online sales as separate lines. If your leases are the older type, you are entitled to set the form, and setting it is the single most effective thing you can do to make the monthly chase easier.

• Consequences. Three appear in landlord forms. A late reporting fee, usually a flat amount per late report (often $100 to $250) or a per-day charge. The landlord's right to estimate sales and bill percentage rent on the estimate if the report is not received, with the tenant liable for any shortfall after the true-up. And, for persistent non-reporting, the right to audit at the tenant's cost regardless of what the audit finds. Tenants push back on all three, so check which survived in each lease.

The monthly reporting workflow

This is the process for the 15 to 25 day window each month. It assumes one accountant handling 40 tenants, which is realistic for a mid-sized centre.

Step 1: Build the reporting register before the month starts

For every tenant, record the reporting frequency, the deadline in days, the gross sales definition (or at least a flag for non-standard exclusions), whether the tenant pays percentage rent, whether the tenant is in a co-tenancy group, and the tenant contact who actually sends the report. The last field is the one people skip and the one that saves the most time. The store manager is rarely the person who sends the number for a national tenant; it comes from a regional accounting office that handles dozens of landlords and responds to whichever landlord has the clearest request.

Step 2: Send the request on the 1st, not the 10th

Send the reporting form to every tenant on the first business day of the month with the deadline stated. Tenants who are reporting to many landlords work from their inbox, and a request that arrives early gets processed in the first batch. A request that arrives after the deadline gets treated as a dispute rather than a routine task.

Step 3: Log receipts daily and validate on arrival

As each report arrives, log the date received and check three things before posting: that the period is correct (tenants send the wrong month more often than you would expect), that the exclusions claimed are ones the lease allows, and that the figure is plausible against the same month last year and the prior month. A report showing a 40% drop in sales with no explanation is either a data error or a store in trouble, and either way the leasing team wants to know now, not at year end.

Step 4: Chase on the deadline, then escalate

On the day after the deadline, send a first reminder to the reporting contact. Five business days later, send a second reminder that cites the lease clause and states the late fee if the lease has one. Ten business days after the deadline, escalate to the tenant's regional or head-office contact and copy the leasing manager. Most of the 40 will have reported by the first reminder; the chase is for the five to eight who report late every month, and the escalation contact is what changes their behaviour.

Step 5: Bill percentage rent and run the co-tenancy test

Once reports are in, accrue percentage rent for tenants over breakpoint and issue invoices in line with the lease billing method. The invoice timing and the annual true-up process are covered in percentage rent collection in retail. Run the co-tenancy sales test if any lease has one that is tested monthly, and record the result.

Step 6: Estimate for non-reporters, and say so

If a tenant still has not reported by the time percentage rent must be billed, use the lease's estimation right. Bill on the greater of the same month last year or the trailing three-month average, state on the invoice that it is an estimate under the reporting clause, and record that a true-up is owed. Do not simply skip the month. A skipped month is a month that never gets billed, and it also leaves a gap in the lender schedule.

The annual certified gross sales statement

The annual statement is the document the annual percentage rent true-up is built on, and it is the document the sales audit clause references. Treat it as a separate collection cycle with its own register.

It is due a fixed number of days after the lease year end, which is not always the calendar year end. A tenant with a lease year running from the rent commencement date in April reports annually in June or July. Track lease year ends per tenant, not one date for the centre.

Reconcile the certified annual figure to the sum of the twelve monthly reports before doing anything with it. Differences are normal and usually small: year-end returns, gift card breakage adjustments, or a monthly report that was sent as an estimate and never corrected. A difference above 1% to 2% is worth a question to the tenant before the true-up is issued, because whichever figure you use will be the one an auditor tests later.

Check the certification. If the lease requires an officer's certificate and you received a report signed by the store manager, it is not the annual statement the lease requires, and the audit look-back and the tenant's estoppel position are both affected. Send it back with the clause reference. If the lease requires an independent CPA and the tenant sends an officer certificate only, the lease usually lets you require the CPA statement at the tenant's cost.

Then issue the true-up. If the twelve monthly percentage rent payments exceed the amount due on certified annual sales, the tenant is owed a credit; if they fall short, an invoice. Both should reference the annual statement by date and figure.

Audit rights and the cost-shift threshold

The sales audit clause gives the landlord the right, on notice, to inspect and audit the tenant's sales records for a stated look-back period, and it sets out what happens if the audit finds an understatement.

A typical clause has these terms. The landlord may audit once per lease year, on 15 to 30 days' written notice, during business hours, at the premises or at the tenant's regional office. The look-back is two or three years from the date the annual statement was delivered (which is why a late or non-compliant annual statement matters: the clock does not start until it arrives). The tenant must keep records, usually for the same period, including POS journals, sales tax returns, bank deposits and, increasingly, e-commerce order data tied to the store.

The cost-shift threshold is the term everyone negotiates. If the audit shows gross sales were understated by more than the threshold, the tenant pays the landlord's reasonable audit costs in addition to the underpaid percentage rent, usually with interest at the lease default rate. Below the threshold the tenant pays only the shortfall and the landlord bears its own audit cost. Landlord forms start at 2%; negotiated leases commonly land at 3%, and anchor leases can be 5%. Many leases add a second tier: an understatement above a higher figure (5% or 10%), or a second understatement within the look-back, is an event of default, or gives the landlord the right to convert the tenant to reporting on a monthly certified basis for the remainder of the term.

Worked example: a 2% threshold

Tenant reports annual gross sales of $2,400,000. Percentage rent is 6% over a $2,000,000 natural breakpoint, so the tenant paid 6% × $400,000 = $24,000 in percentage rent on the certified statement. The audit finds actual gross sales of $2,475,000 after removing an exclusion the tenant took for online orders collected in store, which this lease counts as sales from the premises.

Two points from the example. The understatement percentage is calculated on audited sales, not reported sales, in most clauses; check the wording, because on reported sales the same figures give 3.13%. And the audit cost exceeds the percentage rent shortfall. That is normal for a single-tenant audit, and it is why the threshold matters: had the audit found $2,450,000 instead, the understatement would have been 1.01%, the tenant would owe $1,500 in shortfall, and the landlord would absorb the $6,000 audit cost.

Choosing who to audit

A 40-tenant centre cannot audit everyone every year. The candidates are tenants whose reported sales are flat while foot traffic and category peers are up, tenants whose monthly reports and annual statement never reconcile, tenants whose sales sit just under breakpoint for two or more years running, and tenants with a large online business and an ambiguous in-store fulfilment clause. Many landlords use a specialist lease audit firm on a contingent fee for percentage rent audits, which changes the cost side of the threshold calculation.

Collecting reports through a tenant portal

The email-and-spreadsheet method works for 10 tenants and breaks at 40. A sales reporting portal moves the process from chase to self-service.

The tenant logs in, selects the period, and enters gross sales and exclusions on the landlord's form, with the lease's exclusion categories pre-set per tenant so a tenant cannot deduct an item the lease does not allow. The system timestamps the submission, which settles late-reporting disputes, and it shows each tenant its own outstanding periods, which does more to reduce late reports than any reminder. Reminders still go out, but automatically, on the schedule in the reporting register, and escalations trigger on the days-late count rather than on the accountant remembering.

On the landlord side, the register in Step 1 becomes a live status board: reported, late, estimated, disputed. The annual statement is uploaded to the same place with its certification, and the reconciliation to the monthlies runs on submission. For a centre with lender reporting, the quarterly sales schedule is an export rather than a compilation.

RIOO's tenant portal supports sales submission against the lease's own reporting terms, and is built for the malls and retail centres where monthly sales collection is a standing job.

Sales data in the ERP feeding percentage rent

Sales reporting only pays for itself when the figure the tenant submits lands directly in the system that calculates percentage rent and posts the invoice, without being re-keyed.

In RIOO on NetSuite, each retail lease carries its reporting frequency, deadline, gross sales definition flags, percentage rent rate and breakpoint, and audit look-back as lease terms. A sales submission posts to the lease as a sales record for the period. Percentage rent accrues from that record using the method described in our percentage rent calculation guide, the invoice is generated in NetSuite against the tenant's customer record, and the annual certified statement triggers the true-up as a reconciling transaction rather than a manual journal. Co-tenancy sales tests read the same records. Lender sales schedules are a saved search on them.

The audit trail is the part the audit clause cares about: who submitted what figure, when, what was estimated and later corrected, and what the certified annual statement said against the monthlies. That history sits on the lease record, which is where an auditor, a buyer's diligence team or a lender's reviewer will ask to see it. See NetSuite property accounting software for how lease terms drive billing in RIOO.

Frequently asked questions

Q1. How often do retail tenants have to report sales to the landlord?
Most enclosed mall and lifestyle centre leases require monthly gross sales reports, due 15 to 30 days after month end, plus an annual certified statement due 60 to 90 days after the lease year end. Strip-centre leases and leases with national credit tenants are often quarterly or annual only. The obligation applies whether or not the tenant pays percentage rent, if the lease says so.

Q2. What is a certified gross sales statement?
It is the tenant's annual statement of gross sales for the lease year, signed by an officer of the tenant and, in many leases, prepared or reviewed by an independent certified public accountant. It is the figure the annual percentage rent true-up is calculated on and the document the landlord's audit right is measured against.

Q3. What happens if a tenant does not submit sales reports?
Depending on the lease: a late reporting fee per report, the landlord's right to estimate sales and bill percentage rent on the estimate subject to later true-up, the right to audit at the tenant's cost, and for persistent failure an event of default. The landlord should bill on an estimate rather than skip the month, so that the shortfall is preserved.

Q4. What is the audit cost-shift threshold in a sales audit clause?
It is the percentage understatement of gross sales above which the tenant must pay the landlord's audit costs in addition to any underpaid percentage rent. Landlord forms usually say 2%; negotiated leases often say 3%, anchor leases up to 5%. Below the threshold the tenant pays the shortfall only. Check whether the percentage is measured against audited or reported sales, since the two give different results.

Q5. Do online sales count as gross sales under a retail lease?
Only if the lease definition includes them. Common drafting counts orders placed online and fulfilled or collected from the premises, and orders returned to the store, while excluding online orders shipped from a warehouse. Older leases are silent, which is the most frequent cause of audit findings on current retail leases. Read the definition in each lease rather than applying one rule to the centre.