REVENUE SHOULD SURVIVE RECONCILIATION
A rent roll is a claim about the business. The property-management system, customer ledgers, processor reports, cash records and bank deposits should support that claim over time.
A self-storage facility can look full and still collect far less than its apparent rental potential. Units may be discounted, delinquent, complimentary, offline or occupied by customers whose rents have not kept pace with advertised rates. Ancillary revenue may be reported gross even when part belongs to a third party. Cash may be recorded without a clear path to a bank deposit.
Revenue diligence is the process of rebuilding what the facility earned, billed and collected from the underlying operating records. It gives a prospective owner a dependable starting point for understanding the business the seller actually operated.
The work is less about finding one perfect report and more about making several independent records agree. When they do not, the difference needs a clear explanation.
Request at least three full years of financial statements and filed tax returns, plus monthly statements for the most recent 12 to 24 months. Annual documents show the broad pattern. Monthly records show seasonality, rate changes, promotions, delinquency and unusual activity that can disappear inside a yearly total.
Ask for native exports as well as PDFs. A spreadsheet or comma-separated export can be sorted by unit, tenant, date and transaction type. Static reports are useful for preserving what management saw at the time, but they are harder to test.
PRESERVE THE ORIGINAL DATA
Obtain read-only backups or dated exports before anyone cleans up records for the sale. Keep a log of the report name, date range, filters, accounting basis and person who produced it.
Different systems answer different questions. The accounting ledger shows how management classified revenue. The property-management system shows tenant and unit activity. The processor shows electronic payments settled. The bank shows deposits received. Tax returns show what the seller reported for tax purposes. None should be accepted as the sole source of truth.
Then build a monthly reconciliation schedule with columns for the property-management system, accounting ledger, processor settlements, cash deposits and bank activity. Give every difference a category and supporting document.
Revenue cannot be tested until the unit inventory is dependable. Obtain the unit list and confirm the number, size and status of every rentable space. Tie the total to site plans, building schedules, management reports and a physical walk-through.
Look for duplicated unit numbers, spaces missing from one system, phantom units that cannot be located, units combined for one tenant and units shown as occupied even though they are unavailable for rent. A unit-count error changes every occupancy calculation that follows.
A current rent roll describes one moment. Revenue diligence needs a month-by-month view. Rebuild beginning occupied units, move-ins, move-outs, transfers, units taken offline, units returned to service and ending occupied units.
BASIC UNIT ROLL-FORWARD
Beginning occupied units + move-ins − move-outs ± transfers and status corrections = ending occupied units. Transfers should not create a false move-in or double-count an occupied unit.
Tie the ending count to each month-end occupancy report. Explain retroactive edits, backdated move-outs and changes to unit status. Review activity immediately before the measurement date, since temporary move-ins, delayed move-outs or complimentary occupancies can make a snapshot look stronger than the underlying pattern.
Repeat the analysis by unit size and unit type. A facility may be full in small climate-controlled units and weak in large drive-up units. The total percentage can hide the part of the inventory that is driving concessions or limiting revenue.
For a selected month, begin with each occupied unit and trace the scheduled rent, discounts, credits, taxes where applicable, payments, delinquency and ending balance. Expand the test across several months, including a high-activity month and a month with unusual collections or adjustments.
Prepaid rent deserves special attention. Cash may reach the bank before the related rental period. Under accrual reporting, the unearned portion may belong on the balance sheet until earned. Under cash reporting, the timing may differ. The diligence schedule should state which basis it uses and avoid comparing unlike totals.
A complete reconstruction follows two paths. The first traces tenant charges and adjustments into reported rental revenue. The second traces customer payments through processor settlement or cash deposit into the bank.
Bank deposits may include nonrevenue items such as owner contributions, loan proceeds, tax refunds or transfers between accounts. They may also be net of fees or delayed by processor timing. The goal is a documented bridge, not an assumption that deposits equal revenue.
Source: Internal Revenue Service, What Kind of Records Should I Keep?
Reconcile rental income by unit and month. Compare scheduled rent with in-place rent and actual collections. Investigate sharp changes that do not align with occupancy, rate increases or the calendar.
Separate recurring rent from late, lien, setup and administrative fees. Trace the fee to the rental agreement and tenant ledger, then determine whether it was billed, waived, collected or refunded. A fee charged to a delinquent customer is not cash revenue until it is collected.
Read the governing contract. Identify the amount charged to the tenant, taxes or regulatory charges, amounts remitted to the provider, commissions or retained program revenue, cancellations, refunds and settlement timing. Do not treat the entire tenant charge as facility revenue when a portion is payable to another party.
Reconcile enrolled tenants to occupied units and then to monthly provider statements. Watch for enrollment after move-out, duplicate coverage, missing cancellations and revenue recorded gross in one period and net in another.
For locks, boxes, packing materials and similar items, compare point-of-sale reports with inventory purchases, unit sales, receipts and bank deposits. Review voids, employee discounts, returns and manual price overrides. Merchandise activity can be small in total while still revealing weak cash controls.
Obtain the vendor agreement and settlement reports. Determine whether the facility earns a commission, rental fee, referral payment or reimbursement. Separate amounts collected on behalf of the vendor from revenue retained by the facility. Apply the same test to mailbox services, parking, vending, equipment rental and other ancillary programs.
Promotions can accelerate move-ins while reducing the cash value of occupancy. Reconstruct concessions by offer type, unit size, move-in cohort and month.
For each concession, identify who approved it, when it ends and whether the system automatically returns the customer to the intended rate. Search for expired promotions that remained on the account and recurring credits described as one-time adjustments.
Report both gross scheduled rent and the reduction caused by concessions. Netting everything into one revenue number makes it difficult to understand whether the facility’s occupancy was earned through durable pricing or continued discounting.
These items have different causes and should not be grouped into one unexplained adjustment account.
Review the approval trail and supporting notes. Compare write-offs with delinquency and auction records. Look for large adjustments near month-end, at year-end or shortly before the sale process. Determine whether a reported improvement in receivables came from cash collections or balances being written off.
Cash requires a tighter chain of evidence because it does not create an automatic processor trail. Compare daily cash receipts from the property-management system with register totals, receipt books, drawer counts, deposit slips and bank deposits.
Document:
Investigate round-dollar adjustments, missing receipt numbers, delayed deposits, frequent cash refunds and transactions posted under shared user credentials. These patterns may have innocent explanations, but each one weakens the reliability of the cash record until resolved.
Source: Internal Revenue Service, Publication 583: Starting a Business and Keeping Records
If the facility collects security deposits, obtain the rental agreement, state-specific policy, tenant-level deposit ledger and bank records. Reconcile beginning deposits, new deposits, refunds, permitted deductions and ending deposits.
A refundable security deposit is generally different from earned rental income. Confirm how the seller records and holds deposits, whether a separate account is required, which balances transfer at closing and how unclaimed or forfeited amounts are handled. The rules depend on the governing agreements and applicable law, so local legal and accounting advice is appropriate.
DO NOT LET A LIABILITY INFLATE REVENUE
Cash received can improve a bank balance without being earned revenue. Security deposits, prepaid rent, taxes collected and amounts due to program partners should be identified before deposits are compared with income.
Occupancy is a family of measurements. Each answers a different question, and each needs a defined numerator, denominator and measurement date.
|
Measure |
What it reveals |
|
Physical occupancy |
Percentage of units or rentable square footage occupied. State whether the calculation uses unit count, square feet or both. |
|
Economic occupancy |
Revenue collected compared with a defined potential revenue amount. The denominator must be stated. |
|
Unit occupancy |
Occupancy by count and, ideally, by unit size and type. It shows whether smaller or larger units are driving vacancy. |
|
Collected rent |
What customers actually paid during the period after failed payments, refunds and timing adjustments. |
|
Street rate |
The rate currently advertised or quoted to a new customer, before or after promotions as clearly labeled. |
|
In-place rate |
The scheduled recurring rate charged to an existing tenant, before collection losses unless otherwise stated. |
Calculate unit occupancy and square-foot occupancy. If 95 of 100 units are occupied, unit occupancy is 95 percent. If the vacant units are unusually large, square-foot occupancy will be lower. Report both when unit sizes vary meaningfully.
Economic occupancy is only useful when the potential-revenue denominator is defined. Potential revenue might use current street rates, standard rates in the management system or gross scheduled rent. Those choices can produce different answers. State the method and apply it consistently across periods.
ILLUSTRATIVE EXAMPLE
Assume a 100-unit facility has 95 occupied units and $10,000 of defined monthly potential rent. If it collects $8,200 after concessions, delinquency and refunds, physical unit occupancy is 95 percent while collected revenue equals 82 percent of potential rent. The percentages describe different parts of the same month.
Compare street and in-place rates by unit size and type. A high street rate may apply only to new tenants, may be paired with a promotion or may have produced few actual move-ins. An in-place rate shows what is scheduled for existing tenants, but it still does not show whether they paid.
For each rate measure, preserve the date and offer terms. Online prices can change quickly, and a quoted rate without the promotion, required fees and duration can overstate the customer’s effective price.
A revenue bridge explains why the month changed. Begin with the prior month’s recurring rent and identify the effect of move-ins, move-outs, transfers, rate increases, promotions, credits and collection performance.
A practical bridge can show:
Keep billed activity and cash activity in separate sections. Combining them can make prior-period collections look like current-period revenue or make current billing look like money already received.
Totals can agree while individual records are wrong. Select a sample that includes ordinary tenants and higher-risk items: recent move-ins, recent move-outs, delinquent tenants, tenants with promotions, tenants with rate changes, cash payers, large units, vehicle spaces, complimentary units and accounts with refunds or write-offs.
For each sample, trace:
Document exceptions in a log with the amount, period, likely cause, evidence requested, person responsible and resolution. Expand the sample when errors repeat or access to supporting records is limited.
After the monthly reconstruction is complete, tie the months to the annual financial statements and tax returns. Differences may result from accounting basis, fiscal-year timing, entity-level items, reclassifications or amended returns. Each difference should be quantified and supported.
Look for trends in:
Seasonality should repeat in a reasonably explainable way. A one-time spike, sudden drop in bad debt or strong final month deserves supporting detail, especially when it materially affects the trailing results presented to a buyer.
AN UNEXPLAINED DIFFERENCE IS INFORMATION
A discrepancy does not automatically mean the business is unsound. It does mean the buyer does not yet have a dependable revenue baseline. Quantify it, identify the affected periods and decide what evidence would resolve it.
The final work product should allow another reviewer to follow the numbers without repeating the entire investigation.
Keep the original source files, the transformed data and the final schedules separate. Record formulas and judgment calls. A clean audit trail makes it easier to update the work when another month closes or a new document arrives.
A buyer is ultimately trying to understand a repeatable operating pattern. That pattern begins with rentable inventory, moves through occupancy and pricing, passes through billing and collection, and ends in supported deposits.
When the unit list, tenant ledgers, revenue accounts, processor records and bank activity agree, the facility’s reported performance becomes much more useful. When they do not, the reconstruction shows exactly where confidence breaks down and how large the difference may be.
A buyer should generally request at least three years of financial statements and tax returns, along with monthly operating statements for the most recent 12 to 24 months. Monthly records are especially useful because they reveal seasonality, concessions, delinquency, rate changes and unusual adjustments that annual totals can hide.
Bank deposits and reported revenue can differ because of payment-processing delays, merchant fees, chargebacks, prepaid rent and deposits that cross reporting periods. Bank activity may also include transfers, loan proceeds, owner contributions or other nonrevenue funds. A monthly reconciliation should explain each difference.
Review revenue by month, unit size and source. Compare occupancy, move-ins, move-outs, effective rents, promotions, delinquency and collections over time. Revenue supported by stable tenant payments and limited concessions is generally more repeatable than revenue created by temporary discounts, aggressive rate increases or collections of old balances.
Only the portion the facility is entitled to retain should be treated as facility revenue. The tenant charge may include amounts owed to an insurer, program administrator or other provider. Buyers should review the governing contract and reconcile tenant enrollments, provider statements, cancellations, refunds and net settlements.
Prepaid rent may reach the bank before the related rental period, so the timing must be handled consistently with the facility’s accounting method. Refundable security deposits are generally held as liabilities until refunded or properly applied. Treating either amount as current earned revenue can overstate operating performance.
The gap may indicate below-market tenant rates, promotions, delinquency, complimentary units, write-offs or weak collections. It can also reflect how potential revenue was defined. Buyers should confirm the calculation method and compare physical occupancy with scheduled rent, concessions and actual cash collected.
Quantify the difference by month and trace it through tenant ledgers, processor settlements, cash deposits, refunds, chargebacks and general-ledger entries. Timing differences may be reasonable, but every material variance should have supporting documentation. Unexplained or recurring differences reduce confidence in the facility’s reported revenue.
First Bank of the Lake helps business owners nationwide find the financing they need to grow, expand and invest in what comes next. Our experience has made us one of the country’s leading SBA lenders. Since 2023, First Bank of the Lake has ranked among the top 1% of SBA 7(a) lenders, placing 15th nationwide by approval amount and have also ranked as the third most active SBA franchise lender by lending volume, according to the U.S. Small Business Administration.
Founded in 1985, we combine national lending capabilities with the personal attention you would expect from a community bank. Our knowledgeable team takes the time to understand your goals, walk you through your options and support you at every step.
If you are considering financing for your business, we would be happy to answer your questions. Call us at (888) 828-5689 or complete the form above to start the conversation. You can also visit our website or connect with us on Facebook and LinkedIn.
This content is provided for general informational purposes only and should not be considered legal, financial, tax, investment or lending advice. Financing options, approval requirements and transaction risks vary by borrower, property, lender and jurisdiction. Consult qualified legal, financial and lending professionals regarding your specific circumstances.