CSV upload template to include property as column in template

Would love to be able to upload 10 properties at once in the transactions by providing a column for property to apply to (as is, need to upload 10 different transaction files which can be time consuming). I could upload all and then do bulk update to edit each to relevant property but as the number of rentals grows, this can be very tedious and a lot of manual clicking.

1 Like

Kevin, I am struggling with this too. Did you find a better solution?

Unfortunately not. It is very tedious to enter each month if you have many properties. I’d love to hear if anybody has other suggestions. Hopefully this is an optional feature that will get added to the product! Thanks for the reply.

Hi Kevin,

Thanks for the suggestion! I’d like to learn more about your use case so we can build something that works well for you.

It sounds like you are importing transactions pretty frequently. Out of curiosity, where are you getting this data from? It sounds like you have a spreadsheet where each transaction is already labeled with a property - do you assign the property for each transaction as part of your manual process, or does your data already come to you that way?

Cheers,
Walter

We currently track 10+ properties in an excel sheet (one tab per property) and if this feature was available, would create another tab (i.e. Monthly transactions) that does a VLookup on the data from each of the property tabs to add the monthly transactions for all of the properties with a 6th column that includes the property address (which matches the one in Stessa). I downloaded a free Excel PlugIn called ‘XLTools.net Tool Export to CSV’ which allows us to highlight the transactions and save directly to a separate CSV which can be used as template for upload. Manually copying to the template file also works (and what we’ve been doing) but this requires 10+ copies and uploads. Thanks for considering!