{"product_id":"rental-property-tax-organizer-excel-google-sheets-tracker-for-expenses-escrow-tax-bill-increases","title":"Rental Property Tax Organizer | Excel + Google Sheets Tracker for Expenses, Escrow \u0026 Tax Bill Increases","description":"\u003cp\u003eKeep your rental property records organized throughout the year with editable Excel and Google Sheets versions built for landlords. Track income and expenses, stay on top of property tax bills and escrow, and see how each property’s tax bill changed from the previous year.\u003c\/p\u003e\u003cp\u003eYour original ZIP download includes the editable Excel workbook and a START HERE guide. A separate Rental_Tax_Organizer_Google_Sheets_Access.pdf is also included with a link to make your own editable Google Sheets copy. Use Microsoft Excel for the .xlsx file or a Google account for Google Sheets. Software and accounts are not included.\u003c\/p\u003e\u003cp\u003eYou enter transactions, tax bills, and receipt references yourself; the workbook organizes those records and calculates its summaries and comparisons.\u003c\/p\u003e\u003ch3\u003eWHAT’S INCLUDED\u003c\/h3\u003e\u003cul\u003e\n\u003cli\u003eYear-end summary with income, expenses, and review items by property\u003c\/li\u003e\n\u003cli\u003eTransaction log with editable categories and receipt reference fields\u003c\/li\u003e\n\u003cli\u003eProperty tax bill tracker for escrow, payments, and receipts\u003c\/li\u003e\n\u003cli\u003eYear-over-year tax bill comparison with dollar and percentage changes\u003c\/li\u003e\n\u003cli\u003eSetup page for up to 20 properties\u003c\/li\u003e\n\u003cli\u003eSTART HERE guide\u003c\/li\u003e\n\u003cli\u003eSeparate Google Sheets access PDF; download it separately from the original ZIP\u003c\/li\u003e\n\u003c\/ul\u003e\u003cp\u003eThe workbook provides 500 transaction rows and 100 tax bill rows.\u003c\/p\u003e\u003cp\u003eTRACK THE DETAILS THAT MATTER\u003c\/p\u003e\u003cp\u003eFor each property tax bill or installment, record the tax year, due date, bill amount, escrow available, payment date and amount, payment method, check number or online authorization number, and where you saved the receipt. A status column points out payment or receipt details that still need attention.\u003c\/p\u003e\u003cp\u003eThe year-end comparison adds bills entered for each property and shows the change from the previous tax year. The percentage stays blank until both years have bill amounts entered.\u003c\/p\u003e\u003cp\u003eHOW TO\u003c\/p\u003e\u003ch3\u003eGET STARTED\u003c\/h3\u003e\u003cp\u003e1. Download and unzip the file.\n2. Open the workbook in Microsoft Excel, or open the separate Google Sheets access PDF and follow its link to Make a copy in your own Google Drive. The master is view-only.\n3. On the Setup page, choose your tax year and replace “Property 1” with your own property name or address.\n4. Enter transactions and tax bills as they occur.\n5.\u003c\/p\u003e\u003cp\u003eReview the year-end totals and tax bill comparison.\u003c\/p\u003e\u003ch3\u003ePLEASE NOTE\u003c\/h3\u003e\u003cp\u003eThis is a record organizer for Excel or Google Sheets, not tax filing software. The versions do not sync; choose one main working version. Keep the supplied rows and formulas intact; use another copy when full. It does not scan receipts or automatically turn them into entries; you enter your records and save receipt references yourself.\u003c\/p\u003e\u003cp\u003eTax bills do not automatically become expense transactions, helping you review how each payment should be recorded. Use the separate Review type for items that need a tax preparer’s attention.\u003c\/p\u003e\u003cp\u003eThis is a digital download. No physical product will be shipped.\u003c\/p\u003e","brand":"Keys and Keep Property","offers":[{"title":"Default Title","offer_id":46108724920389,"sku":null,"price":12.99,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0771\/3767\/4309\/files\/8f099881-il_fullxfull.8706937879_ecxu.jpg?v=1792789627","url":"https:\/\/keysandkeepproperty.com\/products\/rental-property-tax-organizer-excel-google-sheets-tracker-for-expenses-escrow-tax-bill-increases","provider":"Keys and Keep Property","version":"1.0","type":"link"}