On the Transactions page, users will have the opportunity to enter transaction data for the property.
| Note: Gray shading over a field denotes that it cannot be actively edited; it is an auto-calculated field. |
There are several important actions at the top of the page: Instance Select, Create, Copy, and Delete.
Instance Select
Click the Instance Select drop-down menu to select the instance you'd like to edit.
| Note: A checkmark icon next to an instance denotes that the instance is “Active.” A table icon denotes that the instance will be utilized for Excel usage. |
Edit the instance name by editing the Sale Date and/or the Transaction Type. Users can choose the following Transaction types: Listing, Pending Contract, Closed Sale, Appraisal, Option, Un-Executed Contract, Letter of Intent and Transfer. Note that Listing and Pending Contract allows for a NULL date value.
Create
Click the Create button to open a pop-up with options to create a new instance. You will be able to enter a Sale Date and define a Transaction Type. Note that this new instance will automatically become the “Active” instance. The Active instance Transaction data will be used to derive calculations such as Cap Rate. Regardless of which instance the user chooses to pull into Excel, the active instance will stay the same until a new instance is created.
Copy
Click the Copy button to open a pop-up with options to copy an existing instance.
You will be able to define Sale Date and Transaction Type, but the values will be a copy of those in the currently-selected instance record.
Delete
Click the Delete button to delete the currently-selected instance. A pop-up will request confirmation.
Confidential
The confidential checkmark will display as a True/False when pulled into the Excel template. Users should use this checkmark to indicate the confidentiality of a Sale.
Used by Excel
Regardless of whether the instance is “Active” or current, a user can mark whether they want to utilize the instance in their Excel template (for subject import or for use as a comp).
The Active instance Transaction data will be used to derive calculations such as Cap Rate, PGIM, EGIM and NIM. The active instance data is also what will be available for Property Searches.
Sale Price and Adjustments
Active instances will auto-calculate the “Price per” fields as well as displaying the corresponding metric underneath the field. These fields are locked and cannot be edited.
Non-active instances will allow the user to adjust the “Price per” fields in case of a metric such as GBA changing. For instance, due to an addition to the building, the GBA is currently larger than it was in the non-active sale instance. Entering the new value will adjust the corresponding “Price per” field.
You can hand-enter adjustment data or calculate the end price after entering the adjustment. It accepts positive or negative numbers. Adjustments can be toggled by clicking on the blue pen icon by the Price label.
General Transaction Fields
General Transaction fields are grouped together for ease of data entry.
For some browsers, users may increase the text box size for Grantor and Grantee by grabbing the lower right-hand corner of the data entry box and expanding.
Time of Sale
Time of sale fields allow the user to keep fixed data metrics. The user can either hand-enter the data or use the buttons to the right of the fields to calculate or copy current values.
Discounted Cash Flow
Discounted Cash Flow fields are grouped together for ease of entry. This group is hidden by default.
Adjustment Comments: Allows the user to add comments specifically for the Adjustment to Actual Price, etc. This field is hidden by default, unless an adjustment is made.
Internal Comments: Allows the user to comment on the sale. Narrative1 suggests keeping this field as a non-report facing field. Example: “This sale has not been verified, please do not use in a report.” This field is hidden by default.
Sale Notes: Allows the user to capture miscellaneous notes on the instance of the Sale. Some user's use this field as the Sale History.
Sale Comments: Allows you to add comments to the current instance record. This field is hidden by default.
| Note: Excel Template versions 45.66.4 and above will allow users to toggle between the property comments found in the General page and the Sale comments found in the Transactions page. |
Save: Click to save all changes made to the instance.
Save and Add Another: Saves the current record and creates a new property record for data entry.
