Budget calculation

[Byb747]

I'm trying to figure out the best way to create a budget spreadsheet. Currently my plan is to have three different sheets. 1. Our current budget with me and my wife both working. 2. I retire and my wife keeps working. 3. Both of us are fully retired.

How do you account for a rental property where you have an expense of a mortgage but you also have income to offset?

We are trying to have investment income and pensions satisfy our full expenses without withdrawals.

Thanks and have a wonderful day!

 

[JDARNELL]

I have a separate spreadsheet for my rentals. Income minus expenses so I can see how they are doing each month. I then take the net income and add it to the house budget as another income
Source.