Revenue Management

Your software gives you an easy way to make rate changes for select unit groups or tenants through the Revenue Management section, which our support team can activate for you. Once activated, this feature can be found in the Corporate section on the Settings tab. Only users with corporate permissions can access this section of storEDGE.

There are several steps for managing your rates using Revenue Management:

 

To access Revenue Management, go to the Corporate section of your software and access the Settings tab. Then, under Software Settings, click Revenue Management under the Billing heading.

revenuemanagementsection.png

Filtering Unit Groups

There are three tabs in the Revenue Management section. You can view your Occupied or your Unoccupied unit details. You’ll also see a tab titled Import History. From both the Occupied and Unoccupied tabs, you can filter which units you want to view by facility or facility group, and then by unit type, unit size, and unit amenities. You can apply as many filters as you choose. At minimum, you must select a facility or facility group. Once you’ve selected the filters you want, click Apply.

Screen_Shot_2017-03-08_at_2.48.05_PM.png

The results will be displayed in a table that gives a variety of details about the units you’ve selected to view:

Unoccupied Units:

Each row represents a unit group.

  • Facility name: This displays the facility at which the unit is located.
  • Unit type: This displays the type of unit.
  • Size: This displays the size of the unit.
  • Amenities: This displays a list of the amenities that this unit has.
  • Door: This displays the dimensions of the unit’s door.
  • Floor: This displays the level on which the unit is located in the facility. This will be blank for single-level facilities.
  • Indoor/Outdoor: This reveals whether the unit is indoor or outdoor.
  • Area: This gives the area of the unit in square feet.
  • Total units in group: This displays how many units of this type there are at the facility.
  • Occupied units in group: This displays the number of occupied units in this group.
  • Vacancy of Group: This displays what percentage of units in this group are currently vacant.
  • Occupancy of Group: This displays the percentage of units in this group that are currently occupied.
  • Days Since Last Move-in: Here, you’ll see the date that a move-in occurred for a unit in this group.
  • Average Rent: This displays the average rental rate currently being applied to units in this group.
  • Standard Rate Per Square Foot: This displays the amount your facility charges per square foot for this particular unit group.
  • Current Standard Rate: This displays the standard rate for units in this group.
  • Managed Rate: This displays the managed rate for units in this group. This unit will likely be blank if you do not have any scheduled rate changes.

Occupied Units:

Each row represents an occupied unit.

  • Facility: This displays which facility at which the unit is located.
  • Tenant Name: This displays the name of the tenant who is currently renting this unit.
  • Unit #: Displays the unit number.
  • Unit Type: Displays the unit type.
  • Size: Displays the unit size.
  • Type: Displays the account type.
  • Business Name: If this unit is rented by a business, the business name will be displayed here.
  • Amenities: This displays a list of the amenities that this unit has.
  • Floor: This displays the level on which the unit is located in the facility. This will be blank for single-level facilities.
  • Area: This gives the area of the unit in square feet.
  • Average Rent for Unit Group: This displays the average rental rate for tenants occupying this size and type of unit.
  • Variance Between Standard and Rent Rate: This displays the average difference between the rate renters are currently paying and the standard rate for this size and type of unit.
  • Move-in Date: This displays the tenant's move-in date.
  • Length of Stay: This displays how long the tenant has occupied this unit.
  • Paid Through Date: This displays the date the tenant has paid through.
  • Rent Las Changed: This displays the date the rental rate for this unit was last changed.
  • Scheduled Rate Change Date: This displays the date the rate for this unit is scheduled to change. This column will be blank if there is not a rate change scheduled for this unit.
  • New Scheduled Rate: If there is a rate change scheduled for this unit, it will be displayed here.
  • Current Rent Rate: This displays the current rental rate that the tenant is paying at this time.

Screen_Shot_2017-03-08_at_2.49.56_PM.png

Once you’ve defined the unit groups for which you’d like to manage the rates, you can select the Export button. This will prepare the table in a .csv file. This may take a few minutes. When it's ready to download, a Download button will appear. Click this button to download the file.

Adjusting rates in a .csv file

To adjust rates, access the .csv file you just downloaded. We suggest using a program like Microsoft Excel, LibreOffice, or even Google Sheets to view and edit this document.

How you edit and import this file will depend on whether you are editing rates for Unoccupied or Occupied units:

Unoccupied Units

If you're changing the rates for unoccupied units, your .csv file will be nearly identical to the table you saw in your software, but will have additional columns at the end titled New Standard Rate and New Managed Rate. You will make your changes in column T: New Standard Rate. You can also make changes in column V: New Managed Rate. You do not have to make changes to every unit group; you only need to enter rates for those you'd like to change. When you're finished, save the file.

Screen_Shot_2017-03-14_at_2.40.59_PM.png

Note: Ensure that you do not make changes to any fields in the Group Key or Facility ID columns. If you make changes to these columns, your import will fail.

Occupied Units

If you're changing the rates to occupied units, your .csv file will be nearly identical to the table you saw in your software, but will have several additional columns on the end:

  • New Rent Rate: This is where you will input the new rental rate.
  • Effective date: This is where you input the date you'd like the rental rate to change.
    • Note: The date must be in the format xx/xx/xxxx, or the import will fail. The best way to do ensure that your import doesn't fail is to change the format of this column in the program you're using to plain text instead of date formatting, and ensure that you input your date as xx/xx/xxxx precisely.
  • Ledger ID: This is a code that connects each tenant in this file to their ledger. 
    • Note: It is imperative that you do not delete anything from the ledger ID column. If you delete anything in this column, your import will fail.

Screen_Shot_2017-03-09_at_9.29.46_AM.png

Note: Changing rates for occupied units takes a bit more care than changing rates for unoccupied units since it affects your current tenants' ledgers. If your import fails, it is most likely because your date is in the wrong format or you've inadvertently changed a ledger ID. Troubleshoot these two factors if your import fails, and you'll most likely find that one of these issues is the problem.

You will make your changes tenant by tenant. When your changes are complete, save the .csv file.

Importing new rates

Once your changes are complete and your .csv document is saved, you can import your document. First, check that you saved your .csv file correctly. If you have saved it as an .xlsl or in any other format, your import will fail.

To import your file, access the Revenue Management section in your Corporate Settings. Find and select the Import button. A window will open that will allow you receive browser notifications. This is useful for importing managed rates for occupied units because these files contain a lot of data and take a few minutes to import. You can choose to turn on these notifications at this time. Choosing not to turn on browser notifications will not affect the import.

 Screen_Shot_2017-03-09_at_8.49.26_AM.png

To import your file, you can select click here to browse and access your file on your computer. If you are a Mac user, you can also find your file and drag and drop it into the window. Once your file is recognized, the Start Import button will highlight, and you can click it to begin your import.

Screen_Shot_2017-03-09_at_9.46.06_AM.png

After you've started your import, a window will appear that informs you that your import has begun.

Screen_Shot_2017-03-09_at_8.50.43_AM.png

If there is a problem with your file, a window will appear informing you that your .csv file does not meet the import standards. You will need to check your .csv file to correct formatting or check for missing essential information.

Screen_Shot_2017-03-09_at_9.50.15_AM.png

When your import is complete, it will appear on the Import History tab in the Revenue Management section. You can download the file to review your changes. Any rate changes you made to the .csv file will be scheduled and carried out by your software. You can also filter the imports by date and occupied or unoccupied units to find a specific batch.

Screen_Shot_2017-04-18_at_3.21.38_PM.png

Note: If you change a rental rate for an occupied unit that already has an upcoming rate change that you previously scheduled in your Yield Management settings, this will override the scheduled rate change. The previous scheduled change will no longer take place and will be replaced by the new rate change. 

Comments

Still have questions?
Don't be afraid to ask us. We're here to help you.
Powered by Zendesk