Expenses are not amortized and prepaid, you go 20 years without doing a roof or furnace and then you do 3.

It actually doesn't include your prepaid items such as daily interest, and tax and insurance impounds. keep that in mind if you are creating an escrow account to pay your taxes and insurance within your monthly payment.

Arranging the spreadsheet by monthly bills and payments, and showing the credits and debits in the 'bank account', and the appreciation month by month/depreciation month by month?

Set up your auto debit for your loan on this account.

Again it will varyby jurisdiction, but last week in Baltimore they imediately debited my checking account.

Make sure the debit card for the new account looks different than your personal one - that way you are less likely to swipe the wrong one at the store. 

On one hand I would love to take that cash and buy another property and on the other hand I wonder if I would be better paying this property off quicker and enjoying a debit free asset.I have been watching Robert Kiyosaki, Dave Ramsey and Grant Cardone to try to reset my thinking.

Simply link Quickbooks to your bank account and company credit card and import monthly credits and debits. 

@Jane S.Can’t they use there debit card at Walmart and get a money order. 

A seller who finances needs to get a substantial down payment and ensure that the property is adequately insured by the buyer and that initial property taxes are pre paid and a tax payment plan is established."