• Money
    • Budget
    • Shop
    • Travel
    • Stories
  • Career
    • Advice
    • Entrepreneurship
    • Freelance
    • Small Business
  • Investing
    • General
    • IRA + 401K
    • Stocks + Bonds
    • Retirement Planning
    • Estate
  • The Basics
    • Student Loans
    • Credit Cards
    • Debt
    • Taxes
    • More
  1. Home
  2. The Basics
  3. Saving
  4. How to Create a Utility Bill

How to Create a Utility Bill

December 1, 2010
By: Adela Sanders
  • Share
  • Share on Facebook

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, centralized 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.

...
Some buildings have a shared utility meter.

Step

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

Step

Skip one or two rows and create an "Account Information" subheading in cell A5.

Step

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.

Video of the Day

Step

Skip another two rows. Create a second subheading entitled "Account Balance" near cell A13.

Step

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 $40 in June, paid the total in full and now owes $42 in July, indicate this on the utility bill by displaying $40 - $40 = $0 due in June + $42 = $42 due in July. Alternatively, if a tenant has not paid the bill in June, you would display $40 +$0 = $40 due in June + $42 = $82 due in July.

Step

Skip another two rows. Create a third and final "Services Rendered" subheading near cell A28.

Step

Indicate how you arrived at the total amount due in this section. For example, if the total utility cost for the entire building was $1,000 and you divide the bill by 10 apartment rooms and 20 tenants, indicate that the total owed by a single tenant living alone is $50. In this section, you can also include the total kilowatt-hours or gallons of water consumed within the building complex.

Step

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.

Step

Double-check and save your work.



Show Comments

Related Articles

How to Make a Printable Monthly Bill Payment Log

How to Make a Printable Monthly Bill Payment Log

Money
Budget
By: Diane Dilov-Schultheis
How to Defer Payments to Credit Cards

How to Defer Payments to Credit Cards

The Basics
Debt
By: Lisa McQuerrey

PARTNER CONTENT

Money Mistakes Wealthy People Don't Make

Money Mistakes Wealthy People Don't Make

How to Make a Spending Spreadsheet in Excel

How to Make a Spending Spreadsheet in Excel

Money
Budget
By: Tim Plaehn
How to Change the Name on a Utility Bill

How to Change the Name on a Utility Bill

The Basics
Real Estate
By: Jayne Thompson
How to Dispute a Utility Bill

How to Dispute a Utility Bill

The Basics
Consumer Rights
By: Tamara Price

Get Weekly Savings& Finance Tips.

  • Money
  • Career
  • Investing
  • The Basics
  • About
  • Contact Us
  • Terms
  • Privacy Policy
  • Copyright Policy
© 2018 Leaf Group Ltd. Leaf Group Media

Get Weekly Savings
& Finance Tips.

Money Made Easier.

Please enter a valid email.