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) columns only.
Date, Amount, Payee, Description. Columns should be in this order and with these specific column headers in row 1.
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. You don't want to lose any of this data as Stessa will use it to auto-categorize as many transactions as possible. Remember to cut and "Paste Special" this new column as "Values" before deleting the source columns.
Use the Description column to manage auto-categorization.
Simply include the following words/phrases (just the part before the ">>>") anywhere in the Description and Stessa will automatically map uploaded income and expenses line items to the categories shown:
rent income >>> Rents
maintenance >>> Repairs & Maintenance
insurance >>> Insurance/Rental Dwelling
property taxes >>> Taxes/Property Taxes
remodeling >>> Capital Expenses/Remodeling
Make all expense values negative and income values positive.
If your transactions data only shows positive numbers and then uses a Credit/Debit column or something similar to denote income vs expense, you'll need to open Excel and use the "IF" formula to switch the sign from positive to negative for expenses.
Note: If you're uploading a file that has ONLY positive numbers (income), it will be rejected to prevent errors. As a workaround, add a single expense line item with a negative value of one dollar and then delete it after importing.
- 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.