Most of your expenses will be property-wide anyway, other than some small repairs on individual units.BUT, if you do want to keep a separate accounting for your own purposes, I would still keep one spreadsheet but add a column for 'Unit Allocation. 

Those, sometimes, after ALL allocations, can be pre-tax just under net-0 yr1.

It has come to my attention also to not work with low budget investors, I do not want to touch anything that is less than a gut-out rehab, there is simply really low to no money to be made, or the amount of time managing the project can be allocated on a more profitable project.

First - It depends on if you have a 'trade or business'.That will determine whether the payments received are 'interest income/portfolio income' or 'business income'If they are portfolio income, they will likely be taxed at your resident state.If they are considered business income, you will need to allocate it amongst the states.There are court cases that determine on average how many notes you need to originate in a year to be considered in the business of lending.The state that you form the entity has little bearing on if that is the state where the income will be sourced, otherwise everyone will form the LLC in a state like Florida or Texas.

The opportunity for you though is to allocate those proceeds any way you choose. 

The town of Yucca Valley has allocated 10% of the housing stock to STRs and the town of 29 Palms has allocated 500 permits for STRs.

After year 5, there is no prepay penalty.OPEN PREPAY OPTIONPrepay penalty will be applied to any prepayments of the scheduled principal balance during the prepayment period.RELEASE PRICEThe lien against an individual property will be released when 115% of the original loan amount allocated to that property is paid in full.PERSONAL GUARANTYAll loans must be personally guaranteed by all members of the borrowing entity.PRELIMINARY ESTIMATE IS SUBJECT TO CHANGEThis estimate of costs is contingent upon full borrower and property underwriting.BUSINESS PURPOSEThe Rental30 Loan is for business purpose use only, speciqcally, for real estate investors purchasing, reqnancing, or cashing’out of non’owner occupied, rental

I used managed accounts for years (which are expensive in terms of fees) until I switched over to a robo-advisor service that is low in cost (the investment technique is asset allocation, where the different asset classes are rebalanced periodically to maintain their desired ratios).

You shouldn't open so many bank accounts for the sole purpose of funds being allocated for different things.

No- Allocate based on business vs. personal use. 4) What about expenses such as retro-fitting the place to get it airbnb-ready (I had to add doors, buy keypad locks, smart thermostats, ...)