3/7/2024 0 Comments Income tracker google sheetsIf you want to add more rentals, add 3 columns to the right of the sheet (before the hidden columns.) Then copy and paste the Rental property columns (for example, G,H and I) into the new blank Columns. This is just for your own reference so you stay organized.Īlso for each property, link the correct Category Group to each Rental in Rows 18 to 20. Now you are ready to set up the Rental Manager sheet.įor each property, add the Overview information in rows 8 to 14. Each property should have its own categories, so you might use the property number as the first part of the name.Īssign each of these Categories to the correct Category Group for the property. In the Categories sheet, create as many Income, Expense, and Deposit categories you want per property. Deposits (these can be type Transfer they are not income or expenses).What are the sheets? Does it use any custom scripts or formulas?įor each rental property you own, you will use three Category Groups in the Categories sheet to track: My colleagues here gave me some ideas to improve it further, and here we go! Of course, we were already using a spreadsheet to track a rental, and this report makes it easy to see the status of one or many rental properties on a monthly, quarterly, or annual basis.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |