Upload a QIF Data File from Your Bank
If your bank can export your data to Quicken Interchange Format (QIF), you can bulk import it directly into your Stessa account to get things current. QIF imports are particularly easy because you don't need to do anything to prepare your file in advance.
Once you've downloaded the QIF file and are ready to import, click the blue "+ Data File" button on your Data Sources page. Be sure to select a Property if all the transactions in the file should be associated with a single address. Once uploaded, you'll see your new data on your Transactions page.
Upload a CSV Data File from Your Bank or PM
If your bank or property manager can generate a Comma-Separated Values (CSV) file with historical transactions data, you can bulk import it directly into your Stessa account to get things current.
You'll first want to clean up and prepare your CSV files for a successful import. Spend the time now to organize your data properly and it'll save you plenty of headache later.
Here's how to prep your CSV files:
Organize your data into separate CSV files for each Property.
This will save you the hassle of manually matching each transaction to a Property after import. Note that if your CSV file has transactions data commingled for multiple properties, you're not required to separate it now. If you prefer, you can simply upload it to "Multiple Properties" and manually assign each transaction later.
Consolidate the data into four (4) mandatory columns and one (1) optional column.
Date, Amount, Payee, Description, and Category. Columns should be in this order and with these specific column headers in row 1. Category is optional.
Use Excel's CONCATENATE formula to preserve data if needed.
If the CSV from your bank or PM includes other columns like Category, Tenant, Unit, Payment Method, etc., open your file in Excel and use the =CONCATENATE formula to combine everything into a single new Description column if you don't want to lose any of this data. Remember to cut and "Paste Special" this new column as "Values" before deleting the source columns.
Add a "Category" column to manage auto-categorization.
Simply include an optional column labeled "Category" to tell Stessa exactly how you'd like each income and expense line-item categorized. Exact matches to Stessa's existing top-level or sub-categories will be instantly categorized upon upload. When referring to sub-categories, do NOT include the top-level category. For example, if you want something categorized as "Insurance > Rental Dwelling" just enter "Rental Dwelling" to create a perfect match.
- Save each file as CSV with filenames that roughly match the property addresses.
Once your files are ready to import, click the blue "Import" button on your Transactions page or the blue "+ Data File" button on your Data Sources page. Both buttons accomplish the same task. Be sure to select a Property if all the transactions in the file should be associated with a single address. Once uploaded, you'll see your new data on your Transactions page.
Still Having Trouble with a File Upload?
Use the blue circle at lower right to drop us a note. We'll get back to you with next steps shortly.