Turnover Rent and Your PoS: How to Automate Revenue Reporting for Percentage-Based Leases

How Percentage-Based Leases Work and Why Accuracy Matters#

A percentage-based lease, also called a turnover rent or percentage rent agreement, requires the tenant to pay a base rent plus an additional amount calculated as a percentage of gross sales above a specified breakpoint. For example, a lease might specify $3,000 per month base rent plus 6 percent of gross sales exceeding $50,000 per month. If your monthly sales total $65,000, you owe the base rent plus 6 percent of $15,000, which is $900, for a total rent of $3,900. These lease structures are common in shopping centers, malls, high-street retail locations, and food halls where landlords want to participate in tenant success while providing a lower base rent that helps tenants manage cash flow during slow periods. The accuracy of your revenue reporting directly affects your rent obligation. Over-reporting revenue by including non-qualifying transactions costs you money in unnecessary percentage rent payments. Under-reporting creates legal exposure and potential lease violations that can trigger audits, penalties, or even lease termination. Lease agreements typically define qualifying gross sales carefully, and the definition matters enormously. Most leases exclude specific transaction types from the gross sales calculation: returns and refunds, employee discounts beyond a threshold, sales taxes collected, gift card sales at the point of activation, and sometimes online or delivery sales that do not originate from the physical premises. Understanding exactly which transactions qualify and which are excluded requires reading your lease definition of gross sales carefully and mapping it to the transaction categories in your PoS system.

Mapping Your PoS Transaction Data to Lease Revenue Definitions#

The critical step in automating turnover reporting is creating a precise mapping between your lease definition of gross sales and the transaction types in your PoS system. Start by pulling the gross sales definition from your lease agreement and listing every inclusion and exclusion specified. Common inclusions are all sales of merchandise and services conducted at or from the premises. Common exclusions include returns and refunds, which your PoS categorizes as negative transactions that reduce gross sales. Sales tax collected, which your PoS typically tracks as a separate line item and can be excluded from revenue totals. Gift card activations, which represent a prepayment rather than a sale, though gift card redemptions when the card is used to purchase goods typically do count. Employee purchases at a discount, where the lease may exclude the discount portion or the entire transaction. Delivery and online sales that did not originate from in-store customer visits, which your PoS may track through order channel tags. Voids and cancellations, which represent transactions that were started but never completed and should never appear in reported revenue. Once you have mapped each exclusion to a PoS transaction category or tag, you can build a report template that starts with total gross sales and subtracts each excluded category to arrive at qualifying revenue. Most PoS platforms allow you to save custom report configurations that you can run monthly with a single click, eliminating the manual data assembly that introduces errors and consumes time. The goal is a report that produces the exact qualifying revenue figure specified in your lease, documented clearly enough that it withstands landlord scrutiny or formal audit.

Automating Monthly Turnover Reports From PoS Data#

Once your mapping is established, the monthly reporting process can be reduced to a few minutes of verification rather than hours of data assembly. The automation workflow begins with your PoS system generating the monthly sales summary using the custom report template you configured. This report should break out total gross sales, each excluded category with specific amounts, and the resulting qualifying revenue. Below the qualifying revenue line, the report calculates whether the breakpoint threshold was exceeded and computes the percentage rent owed. For a lease with a $50,000 monthly breakpoint and 6 percent rate, the report shows qualifying revenue of $58,000, excess over breakpoint of $8,000, and percentage rent due of $480. Your monthly review consists of verifying that the excluded categories look reasonable compared to prior months, checking that no new transaction types have appeared that need classification, and confirming that the breakpoint and percentage rate match your lease terms. This verification takes five minutes compared to the hour or more required to assemble the same report manually from raw PoS exports. Documentation matters for landlord relationships. Submitting a clearly formatted report that shows your calculation methodology, the specific exclusions applied, and the resulting rent obligation builds trust and reduces the likelihood of audit disputes. Most landlords appreciate tenants who report transparently and consistently, which can benefit you during lease renewal negotiations. AskBiz can generate these turnover reports automatically from your PoS data, applying your lease-specific exclusion rules and producing a formatted report ready for landlord submission each month without manual intervention.

Common Errors That Cause Tenants to Overpay Percentage Rent#

Several common reporting errors consistently cause tenants to overpay their percentage rent obligation. The most frequent is failing to exclude returns and refunds from gross sales. If your PoS reports gross sales of $62,000 but $3,500 of that represents returns processed during the month, your qualifying revenue is $58,500, not $62,000. At a 6 percent rate above a $50,000 breakpoint, this error costs you $210 in a single month. Over a year, the cumulative overpayment from this single exclusion can exceed $2,000. The second common error is including sales tax in reported revenue. Many PoS systems display tax-inclusive totals by default, and tenants who report these totals without subtracting tax are overpaying on revenue that was never theirs to keep. For a business with an 8 percent sales tax rate, this error inflates reported revenue by approximately 7.4 percent, translating to meaningful percentage rent overpayment every month the breakpoint is exceeded. The third error is including gift card activations as sales. When a customer purchases a $50 gift card, your PoS records a $50 transaction, but no goods have been sold. The revenue event occurs when the gift card is redeemed, which your PoS records as a separate transaction. Including both the activation and the redemption double-counts the revenue. The fourth error is reporting revenue from channels excluded in the lease. If your lease specifies sales conducted at the premises and you report online orders fulfilled from a separate warehouse, you are including non-qualifying revenue. Reviewing your PoS channel tags ensures that only in-store and qualifying transactions flow into your turnover report.

Preparing for Landlord Audits With Clean PoS Records#

Most percentage-rent leases include an audit clause giving the landlord the right to examine your sales records, typically with 30 days notice. Being prepared for these audits requires maintaining clean, well-organized PoS records that support every number in your monthly turnover reports. The best preparation is making audit readiness a byproduct of your monthly reporting process rather than a separate exercise. When your monthly report clearly shows total gross sales, each excluded category with specific amounts and transaction counts, and the resulting qualifying revenue, you have already created the documentation an auditor needs. Store monthly reports in a dedicated file organized by date so you can produce any month records on request. Your PoS system transaction logs serve as the detailed backup to your summary reports. An auditor may want to verify specific exclusions by reviewing the underlying transactions. Ensure your PoS data retention period covers at least the audit lookback period specified in your lease, which is typically two to three years. If your PoS platform archives data after a certain period, export monthly transaction detail to a secure backup before it leaves the accessible database. Common audit triggers include sudden drops in reported revenue that do not align with foot traffic data the landlord may have, inconsistent reporting patterns that suggest selective exclusion, and reported revenue that seems low relative to comparable tenants in the same location. Maintaining consistent, transparent reporting dramatically reduces audit risk because it eliminates the reporting irregularities that trigger landlord scrutiny. AskBiz maintains a complete historical archive of your PoS transaction data and turnover reports, providing instant access to any period records when an audit request arrives, eliminating the scramble to assemble historical data from multiple sources under time pressure.