Your Transactions Page
Actual income and expenses are tracked on your Transactions page. That's where you'll categorize your line items and assign them to a portfolio, property, and/or unit. You'll also run reports like an Income Statement, Net Cash Flow, CapEx, and others, directly from the Transactions page.
There are three ways to add transactions to your Stessa account:
- Automatic Import via Linked Bank Accounts
- Manually via the "+ Add" Button on the Transactions page
- File Uploads via CSV or QIF format
Once your income and expense data is showing up on your Transactions page, you can then make edits directly, assign categories, and decide whether you want to associate the transaction with a portfolio, property, and/or specific unit. You can also perform some of these actions on multiple transactions at once, with bulk edits.
Sometimes you'll have an expense item, like mileage or insurance for example, that doesn't really make sense to assign directly to any single property. As long as you have at least two properties set up in Stessa, these "portfolio-level" expenses can be assigned to a Portfolio instead. To do this, simply select the Portfolio name from the drop-down selector under the "Property" column on your Transactions page.
Note that portfolio-level expenses are not technically allocated to the actual Properties within the Portfolio. They are instead accounted for in a separate "Portfolio" bucket, which is then reported in its own column at far right on your Income Statement, Net Cash Flow report, etc. If you want an expense allocated directly to multiple Properties (or Units), you'll need to use the Split feature instead.
Accurately tying income and expenses to the correct Property is essential if you want to take advantage of Stessa's full capabilities. If you have a dedicated bank account that's only used for a single Property, you can associate the account directly such that all transactions imported from that account will be automatically assigned to the chosen Property. To set this up, visit your Data Sources page and select the Property from the drop-down selector to the right of the account name.
If you're uploading data via CSV or QIF file, you have two options. You can associate the entire file with a Property at the moment of upload or you can include a "Property" column in your file prior to upload. Property addresses must be a perfect match to your Stessa account in order for the system to properly associate the transaction.
It's also worth noting that if you only have one property set up in Stessa, all transactions will automatically be assigned to that Property by default. In this circumstance, you won't even see a "Property" column on your Transactions page. Portfolio-level expenses will not be available until you add a second Property.
Optionally, you can also assign any transaction directly to a Unit when it makes sense. First, make sure the transaction is assigned to a Property. Assuming you have multiple Units set up on your Leases & Tenants page, an option to "Assign to Unit" will then appear underneath the Property name. Click and then select the appropriate Unit.
This feature is perhaps most powerful when it comes to rental income. Assigning rents received to actual units is the best way to keep track of who's paying on time, late, or not at all. You can also use Unit assignments to track parking revenue at a more granular level. Eventually, associating rents with specific units will become the foundation of new tenant management features that we plan to release later in 2020.
Associating certain expenses with specific Units can also give you a critical layer of insight into what's actually going on at a particular Property. Is one problem unit generating 90% of all R&M expenses? Is there an outlier when it comes to Utilities? We've also seen quite a few investors using this feature to track CapEx projects like kitchen and bathroom remodels at the Unit level.
All of Stessa's reports, including the Income Statement, Net Cash Flow, Balance Sheet, Capital Expenses, Tax Package and Stress Test are available at the Portfolio, Property, and Unit levels. To run a report based on actual income and expense data, click the "Reports" button at upper right on your Transactions page.
Then follow these simple steps:
- Select the relevant Date Range
- Choose an entire Portfolio or a single Property
- For "Reporting," select By Month, By Property, By Unit, or Combined
Note that you will only see "By Property" if you've selected a Portfolio above, and you'll only see "By Unit" if you've selected a specific Property above. "By Month" will give you a separate column for each calendar month of your selected Date Range, on a consolidated basis. "By Property" will give you a separate column for each Property in the Portfolio. "By Unit" will give you a separate column for each Unit in the selected Property. "Combined" generates a single column with all data aggregated over the Date Range.
- Leave "Category Details" set to "Show" if you want to see each relevant sub-category on a separate line. Turn this off to see all data aggregated to the top-level categories only.
- Click "Download" and your Report will generate and download as an Excel file. While we plan to eventually add support for PDF reports that can be viewed directly online, they are currently not supported.
Have Questions About Transactions & Reporting?
Use the blue circle at lower right to open a support conversation. We'll get back to you shortly.