Using the Report Builder to Create Financial Reports



August 28, 2017 | comments

Imagine that it’s been a banner year for your brokerage: you’ve scaled up your team, everyone in town knows your name, and you’re selling houses like hotcakes. But how many houses have you sold? When did they sell and how much did they sell for? How many transactions do you have under contract? And how is your banner year tracking against your sales last year?

To find out, simply download a CSV of your data, then download this template and follow the instructions on the first tab.


STEP 1: Export and select all your transaction data

Once you’ve downloaded your data using the Report Builder, open the CSV file, sellect all the data using CTRL + A, and copy it to your clipboard using CTRL + C.

Copy all your transaction data

STEP 2: Open the Financial Report template

When you open the template, you’ll see 2 things on the first tab:
1. A “How to use this template” section. Once you’re you’re familiar with the steps, please feel free to delete by clicking on the section and hitting DEL.
2. Sample transaction data. This placeholder data exists to help you visualize what your report will look like when finished.

Open the template you downloaded

STEP 3: Paste all your data

Click on cell A1 in the DATA IMPORT tab and paste all your data using CTRL + V.

Paste your data on cell A1

STEP 4: Analyze and digest your data

The template will break down your data and automatically populate a report that you can easily analyze in tabs Charts – Financial and Calculations – DO NOT EDIT.

Charts of your data

Stay tuned for more tips and templates that will help you gain insight into the performance of your real estate brokerage or team!

Check out more articles on the Report Builder and Excel tips:

Unleash the Power of Your Report Builder Data: Sorting and Filtering
[WEBINAR RECORDING] Making Data-Driven Decisions to Grow Your Real Estate Business
Introducing Dotloop’s Newest Feature: The Report Builder

Welcome to dotloop.

Please complete these fields.

Login failed

Last week, 27,998 people signed up for dotloop

Signup failed.