{"product_id":"water-bill-tracker-for-single-family-rentals-excel-google-sheets-tenant-charges-payment-balances","title":"Water Bill Tracker for Single-Family Rentals | Excel + Google Sheets | Tenant Charges \u0026 Payment Balances","description":"\u003cp\u003eWater Bill Tracker for Single-Family Rentals\u003c\/p\u003e\u003cp\u003eKeep the utility bill, the tenant charge and the payment clearly connected. See which bills have not yet been charged and which tenant balances still need attention.\u003c\/p\u003e\u003ch3\u003eWHAT YOU RECEIVE\u003c\/h3\u003e\u003cp\u003eOne ZIP containing the blank Excel workbook and a quick-start text guide, plus a separate Google Sheets Access PDF with a clickable link to make your own editable Google Sheets copy. The workbook has four tabs: Quarterly View, Bills, Payments and Start Here.\u003c\/p\u003e\u003cp\u003eINCLUDED\u003c\/p\u003e\u003ch3\u003eFEATURES\u003c\/h3\u003e\u003cp\u003e- 25 properties with optional water-account references\n- 200 utility bill records and 400 payment allocations\n- Quarterly and annual utility totals grouped by utility due date\n- Separate utility amounts, posted tenant charges and payment receipts\n- Multiple partial payments linked to each Bill ID\n- Not-charged, overdue, due-today, part-paid, settled and tenant-credit actions\n- Visible checks for duplicate IDs, incomplete entries and dates after your review date\u003c\/p\u003e\u003cp\u003eHOW THE TOTALS WORK\nEnter your own records and review date. Payments remain linked to the original bill due year, even when received in a later year. Flagged bills are excluded from totals and flagged payments are excluded from receipts until corrected. Balances may be overstated while payment entries need correction. The workbook starts blank; pictured examples are fictional.\u003c\/p\u003e\u003cp\u003ePLEASE READ BEFORE BUYING\nDesigned specifically for single-family rentals. No shared-meter or multifamily bill splitting. This workbook does not post tenant charges, send messages, connect to banks or sync with property-management software. Positive payment receipts only; refunds, write-offs and reversals require separate reconciliation.\u003c\/p\u003e\u003cp\u003eEnter the responsibility, amounts and dates confirmed for your tenancy.\u003c\/p\u003e\u003cp\u003eExcel + Google Sheets included. To use Google Sheets, open the access PDF, sign in to Google, click Open Your Google Sheets Template, and choose Make a copy. Set your review date and bill due year on Quarterly View, then read Start Here before entering bills and payments. A sample partial-payment calculation was checked in Google Sheets; other applications may differ.\u003c\/p\u003e\u003cp\u003eStay within the prepared rows. No software license is included.\u003c\/p\u003e\u003cp\u003eDigital download only. No physical item is shipped. Cover uses AI-assisted decorative imagery and an illustrative laptop setup. Supporting screenshots show actual worksheets with fictional data.\u003c\/p\u003e","brand":"Keys and Keep Property","offers":[{"title":"Default Title","offer_id":46108722167877,"sku":null,"price":7.99,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0771\/3767\/4309\/files\/13c67725-il_fullxfull.8684619876_i6u4.jpg?v=1792789604","url":"https:\/\/keysandkeepproperty.com\/products\/water-bill-tracker-for-single-family-rentals-excel-google-sheets-tenant-charges-payment-balances","provider":"Keys and Keep Property","version":"1.0","type":"link"}