Logging Transactions into the Sales Log

This guide provides step-by-step instructions on how to log transactions into the Sales Log. It includes links to the necessary folders on Google Drive, as well as explanations of the required data and calculations. Following this guide will ensure accurate and organized recording of transactions.

Kormendy Trott
|
11 steps
|
40 seconds

Google Docs

Google Drive

Google Account

Accessing the Sales Log

Navigate to the Sales Log on the Google Drive and select the appropriate year. <https://drive.google.com/drive/folders/0B4fsOIyhapUua2ZJT21BdDhjTm8?resourcekey=0-X4X9sILa2cL01jLpF6cH8w&usp=sharing>

For steps one and two, consult with an Administrator if met with insufficient privileges message.

Accessing Deal Paperwork | Trade Record Form

Open a new tab or browser window and navigate to the "Deal Paperwork" folder on the Google Drive. <https://drive.google.com/drive/folders/0B4fsOIyhapUuSVFrejlxaTlRZkU?resourcekey=0-14wtRL1WFc2_GmfHsfih2A&usp=sharing>

Select the appropriate folder for the transaction you're working on.

Select the appropriate real estate agent's or broker's folder.

Select the folder for the property.

Select the "Accepted Offer" folder to access pertinent documents.

Select the Trade Record file within the Accepted Offer folder.

Keep this information handy for transposing relevant data into respective cells in the Sales Log.

Logging Data in the Sales Log

Switch to tab "2023 Sales Log - Google Sheets"

If completing the input for a KT Listing, scroll down to the "Active and Upcoming Listings" section. Right-click on the row number for your property, select "Cut" and then paste it next inline in the appropriate section above. \*\* For all other transactions, insert a new line in the appropriate section and fill in the details from scratch.

Referencing the Trade Record Form, fill in all of the data for the respective trade.

DATA INPUT **Firm Date = Date the sale, purchase, or lease was condition-free**\ *\*\* If there were no conditions, the firm date can be found on the Agreement to Lease, or the Agreement of Purchase and Sale, in the Confirmation of Acceptance section. You will find "Waivers" or "Notice of Fulfillment" in the Offer Documents folder if there are conditions. In which case, the document with the oldest signature date would signify the Firm Date.* **Price = "Sale Price" from Trade Record sheet** **Comm. = Total Commision field (%) from Trade Record sheet**\ *\*\* Leave blank for leases* **Gross Comm = Sales Price field multiplied by Total Commission field**\ *\*\* Sample formula =(O21\*N21)* **Net Comm = Commission after deductions** \ *\*\* Sample =(P21\*.94-299)/2*\ *\*\* Breakdown =(Gross Comm. Cell\*Brokerage Split-Franchise Fee)/2* \ *The /2 is omitted for deals represented by Adrian Trott and Ariel Kormendy.* **HST = 13% of Net Commission**\ *\*\* Sample =(R21\*0.13)* **Net Pay = HST column plus Net Comm field**\ *\*\* Sample (S21+R21)* **List to Sale Ratio = Sale Price divided by List Price (Listings Only)**\ *\*\* Sample (=V21/U21)* **DOM = Total days between Listing Date and Firm Date**