Reconstruct the Revenue the Facility Actually Produces

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.

Begin with a document request that covers complete cycles

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.

The core request should include:

• Annual profit-and-loss statements, balance sheets and general ledgers
• Filed federal, state and local tax returns relevant to the operating entity
• Monthly profit-and-loss statements for the latest 12 to 24 months
• Bank statements for every account receiving facility revenue
• Merchant-processor settlement reports and chargeback reports
• Cash receipt journals, deposit slips and cash-over or cash-short records
• Current and historical rent rolls
• Month-end occupancy, receivables, collections and delinquency reports
• Move-in, move-out, transfer and rate-change reports
• Unit inventory by size, type, status and rentable square footage
• General-ledger detail for every revenue, refund, discount and write-off account
• Contracts and settlement statements for insurance, protection plans, truck rental and other third-party programs
• Sales reports for merchandise and other ancillary services
• Security-deposit subsidiary records, if deposits are used
• Where the charge originates
• Where the customer payment is recorded
• Whether the amount is gross or net of processor or partner deductions
• Which bank account receives the funds
• Which general-ledger account records the amount
• How refunds, reversals and chargebacks appear
• Whether reporting is on a cash or accrual basis
• Who can edit, void or backdate transactions
• Unit number and building
• Nominal dimensions and rentable square feet
• Unit type, including climate controlled, drive-up, interior or vehicle storage
• Standard or street rate
• Current tenant and in-place rate
• Occupancy status and move-in date
• Vacate date when applicable
• Offline, damaged, owner-use, employee-use or complimentary status
• Access restrictions or other conditions that affect rentability
• Rent billed for the period
• Rent collected during the period
• Amounts collected for earlier or future periods
• Promotional credits and recurring discounts
• Rate increases and their effective dates
• Returned payments and chargebacks
• Refunds and account credits
• Amounts written off
• Tenant balances still outstanding at month-end
• Sum gross rental charges by month
• Subtract discounts, concessions, credits and reversals using the facility’s accounting treatment
• Identify write-offs and bad debt separately
• Tie the result to rental-income accounts in the general ledger
• Reconcile the general ledger to the monthly financial statements and annual tax reporting
• Sum card, ACH, check and cash receipts by transaction date
• Match electronic receipts to processor batches
• Reconcile processor batches to net settlements, fees, reserves and chargebacks
• Match check and cash receipts to deposit records
• Match settlements and deposits to the bank statement
• Reconcile timing items that cross month-end
• Investigate receipts that never appear in a deposit and deposits with no supporting receipt detail
• Free first month or partial-month rent
• Introductory percentage discounts
• Price guarantees
• Military, student, senior or employer discounts
• Manager-approved credits
• Referral credits
• Waived administrative fees
• Complimentary or owner-use units
• Rate reductions used to retain an existing tenant
• Refunds return money previously received
• Credits reduce a tenant balance and may correct billing or resolve a complaint
• Payment reversals undo a failed or disputed transaction
• Chargebacks are withdrawals initiated through the payment network
• Write-offs remove balances management no longer expects to collect
• Bad-debt expense reflects the accounting treatment of uncollectible amounts
• Who receives cash and issues receipts
• Whether receipts are sequential and voids are retained
• Who counts and reconciles the drawer
• How often cash is deposited
• Whether one person can receive, adjust and deposit cash
• How shortages and overages are recorded
• Whether deposits combine multiple days or locations
• Whether cash refunds require independent approval
• Beginning in-place monthly rent
• Rent added by move-ins
• Rent removed by move-outs
• Change from transfers and unit-status corrections
• Rate increases and decreases
• New and expired discounts
• Ending in-place monthly rent
• Other billed fees and ancillary revenue
• Collections of current-period charges
• Collections of prior-period balances
• Refunds, chargebacks and returned payments
• Ending accounts receivable and write-offs
• Net cash receipts reconciled to deposits
• Signed rental agreement and unit assignment
• Move-in date, access status and physical occupancy
• Scheduled rate and documented promotion
• Every charge, payment, credit and adjustment on the tenant ledger
• Payment method and processor or cash record
• Settlement or deposit reaching the bank
• Move-out, refund and final account disposition when applicable
• Rent per occupied unit and per occupied square foot
• Physical and economic occupancy
• Move-ins, move-outs and net change
• Concessions as a share of scheduled rent
• Delinquency aging and collection rate
• Refunds, chargebacks and write-offs
• Revenue by unit size and type
• Ancillary revenue per occupied tenant
• Cash receipts compared with bank deposits
• Manual adjustments and backdated transactions
• The current rent roll is available, but historical month-end reports are not
• Unit counts differ among the site plan, management system and offering materials
• Physical occupancy is quoted without unit and square-foot denominators
• Economic occupancy is shown without defining potential revenue
• Street rates are used as though every occupied tenant pays them
• Promotions are omitted from the rate comparison
• In-place rent is presented as collected cash
• Receivables decline because balances were written off
• Occupied units include owner use, employee use, damaged units or long-term delinquency
• Processor settlements cannot be tied to bank deposits
• Cash receipts are posted under shared credentials or deposited irregularly
• Ancillary charges are reported gross even though amounts are due to a partner
• Security deposits or prepaid amounts appear in revenue
• Large credits, refunds or adjustments cluster near reporting dates
• Tax returns, financial statements and system reports differ without a written bridge
• Reports are recreated for diligence and do not match archived copies
• Document index and report-definition log
• Verified unit inventory and rentable-square-foot schedule
• Monthly physical occupancy by unit count and square feet
• Occupancy by unit size and type
• Monthly scheduled rent, concessions and in-place rent
• Monthly cash collections and accounts-receivable roll-forward
• Revenue by category, including ancillary sources
• Processor, cash and bank-deposit reconciliation
• Refund, chargeback, write-off and bad-debt schedules
• Security-deposit reconciliation, if applicable
• Street-rate and in-place-rate comparison by unit type
• Monthly revenue bridge and exception log
• Reconciliation to annual financial statements and tax returns
• List of unresolved items and the amount each could affect

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.

Create a source-of-truth map before comparing totals

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.

For each material revenue stream, identify:

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.

Prove the rentable inventory first

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.

For each unit or parking space, capture:

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.

Reconstruct monthly occupancy instead of relying on today’s snapshot

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.

Rebuild monthly rental income from the tenant level

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.

At the unit level, distinguish:

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.

Tie billed rent to the general ledger and collected rent to the bank

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.

Charge-to-ledger path

Payment-to-bank path

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?

Test every revenue stream separately

Monthly rental income

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.

Late fees and administrative fees

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.

Tenant insurance or protection-plan revenue

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.

Merchandise sales

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.

Truck rental and other ancillary income

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.

Give concessions and free rent their own schedule

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.

Separate refunds, write-offs and bad debt

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.

Trace cash receipts all the way to deposit

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

Reconcile security deposits separately

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.

Use more than one occupancy and rate measure

Occupancy is a family of measurements. Each answers a different question, and each needs a defined numerator, denominator and measurement date.

Physical occupancy

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

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.

Street rate and in-place rate

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.

Build a monthly revenue bridge

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.

Perform unit-level transaction tracing

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.

Compare the reporting periods to one another

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.

Watch for revenue-quality warning signs

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.

Finish with a revenue-reconstruction package

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.

The question is what the facility repeatedly converts into cash

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.

Frequently Asked Questions About Verifying Self-Storage Revenue

1. How many years of financial records should a buyer review before purchasing a self-storage facility?

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.

2. Why might self-storage bank deposits differ from reported revenue?

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.

3. How can a buyer tell whether a self-storage facility’s revenue is sustainable?

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.

4. Should tenant insurance or protection-plan charges count as self-storage revenue?

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.

5. How do prepaid rents and security deposits affect self-storage revenue analysis?

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.

6. What does a large gap between physical and economic occupancy indicate?

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.

7. What should a buyer do when the property-management system does not match the bank records?

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.

Why Work with First Bank of the Lake

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.