If you are a landlord and wish to collect utility payments from your tenants, you can create your own utility bill template using a program like Microsoft Excel. This is especially helpful if you wish to keep one large, centralised utility account in the building superintendent's name and to collect smaller, shared payments from your tenants. A utility bill must contain three things: the tenant's address and account information, the account balance and the services rendered for the month.
Open a new Excel spreadsheet. Create a large, bold-print title for your utility bill a few rows down from the top of the page in cell A3. The title can be as simple as "Anywhere Apartments Water Bill."
Skip one or two rows and create an "Account Information" subheading in cell A5.
Below the subheading, include your tenant's name, address, apartment number and utility account number. In a separate column to the right of the name and address (columns B or C), write down the billing cycle dates. You can find this information on the main utility bill. In a another column to the right of the billing cycle dates (columns D or E), write down the utility bill's due date and the total amount of new charges.
Skip another two rows. Create a second subheading entitled "Account Balance" near cell A13.
Below the "Account Balance" subheading, write down the total amount due the previous billing cycle. Subtract the amount you received from the tenant's previous payment and add the new charges for the month. For example, if your tenant owed £26 in June, paid the total in full and now owes £27 in July, indicate this on the utility bill by displaying £26 - £26 = £0 due in June + £27 = £27 due in July. Alternatively, if a tenant has not paid the bill in June, you would display £26 +$0 = £26 due in June + £27 = £53 due in July.
Skip another two rows. Create a third and final "Services Rendered" subheading near cell A28.
Indicate how you arrived at the total amount due in this section. For example, if the total utility cost for the entire building was £650 and you divide the bill by 10 apartment rooms and 20 tenants, indicate that the total owed by a single tenant living alone is £32. In this section, you can also include the total kilowatt-hours or gallons of water consumed within the building complex.
Click on the "Print Preview" icon to make sure all parts of your utility bill print onto a single page. You can adjust the location and placement of the titles, headings and information on your utility bill by clicking the cells and dragging them.
Double-check and save your work.
Make sure your applicants know that they are paying shared utilities before they sign a lease. Explain the pooling process and how the utility bills are divided among tenants.
Understand your state laws before creating utility bills.
Tips and warnings
- Make sure your applicants know that they are paying shared utilities before they sign a lease. Explain the pooling process and how the utility bills are divided among tenants.
- Understand your state laws before creating utility bills.
Things you need
- Microsoft Excel