Water Bill Tracker graphic showing a laptop spreadsheet dashboard beside a model house, plant, and pen.

Water Bill Tracker for Single-Family Rentals | Excel + Google Sheets | Tenant Charges & Payment Balances

$7.99
Skip to product information
Water Bill Tracker graphic showing a laptop spreadsheet dashboard beside a model house, plant, and pen.
  • Water Bill Tracker graphic showing a laptop spreadsheet dashboard beside a model house, plant, and pen.
  • Water Bill Tracker format graphic with Microsoft Excel and Google Sheets logos beside a wooden house and keys.
  • Water Bill Tracker quarterly overview spreadsheet with property totals, tenant charges, receipts, and balances.
  • Water Bill Tracker bill-register preview with property, tenant, service-period, due-date, and bill-amount columns.
  • Water Bill Tracker calculated-status preview highlighting Bill entered - tenant not charged and other payment statuses.
  • Water Bill Tracker tenant payment log showing two partial payments linked to one bill and a remaining balance.
  • Water Bill Tracker contents graphic listing quarterly view, bill and payment records, and a getting-started guide.
  • Water Bill Tracker graphic showing a laptop spreadsheet dashboard beside a model house, plant, and pen.
  • Water Bill Tracker format graphic with Microsoft Excel and Google Sheets logos beside a wooden house and keys.
  • Water Bill Tracker quarterly overview spreadsheet with property totals, tenant charges, receipts, and balances.
  • Water Bill Tracker bill-register preview with property, tenant, service-period, due-date, and bill-amount columns.
  • Water Bill Tracker calculated-status preview highlighting Bill entered - tenant not charged and other payment statuses.
  • Water Bill Tracker tenant payment log showing two partial payments linked to one bill and a remaining balance.
  • Water Bill Tracker contents graphic listing quarterly view, bill and payment records, and a getting-started guide.
Water Bill Tracker for Single-Family Rentals | Excel + Google Sheets | Tenant Charges & Payment Balances

Water Bill Tracker for Single-Family Rentals | Excel + Google Sheets | Tenant Charges & Payment Balances

$7.99

Water Bill Tracker for Single-Family Rentals

Keep 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.

WHAT YOU RECEIVE

One 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.

INCLUDED

FEATURES

- 25 properties with optional water-account references - 200 utility bill records and 400 payment allocations - Quarterly and annual utility totals grouped by utility due date - Separate utility amounts, posted tenant charges and payment receipts - Multiple partial payments linked to each Bill ID - Not-charged, overdue, due-today, part-paid, settled and tenant-credit actions - Visible checks for duplicate IDs, incomplete entries and dates after your review date

HOW THE TOTALS WORK Enter 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.

PLEASE READ BEFORE BUYING Designed 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.

Enter the responsibility, amounts and dates confirmed for your tenancy.

Excel + 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.

Stay within the prepared rows. No software license is included.

Digital 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.

You may also like