Spreadhseet for Buy and Hold real estate accounting. On this spreadsheet, the only important piece that needs to be updated is the 'Transactions' tab Columns A-F. Columns G-Z can be copy and pasted from the row above. Each transaction is like a single journal entry A: What property is this transaction for B: What is the effective date of this transaction C: What is the Dollar amount of this transaction D: What account is being debited E: What account is being credited F: Description/Notes/Misc The other tabs all populate automatically. The balance sheet and income statement tabs have list data validation that you to see each property individually or choose a different time view. If you would like to add your own GL Account, you give it a number in column C of the Chart of Accounts tab (only the number, dashes is just a formatting thing) and what account that account rolls into in column A.