¢ Even Cents
All guides

How to track bills that change every month (electric, water, gas)

To track bills that change every month, set each bill up once with its schedule, then fill in the actual amount each month when the bill arrives. The schedule stays fixed. Only the number changes.

Most bill trackers and budgeting apps get this wrong in one of two ways. Either they assume every recurring transaction is the same amount every month, which works for Netflix and fails for your electric bill, or they make you create each month’s bill from scratch, which is tedious enough that you stop doing it by March.

Which bills change every month?

The usual variable bills are:

  • Electric, which swings with heating, cooling, and daylight.
  • Gas or heating oil, which is often tiny in summer and large in winter.
  • Water and sewer, which rises in summer with gardens and lawns, and is billed quarterly in many towns.
  • Trash and recycling, sometimes flat, sometimes by the bin.
  • Phone plans with overage or pay-as-you-go data.
  • Credit card statements, which are recurring but whose amount depends entirely on your spending.

What they share: same schedule, different amount. A good tracker treats those as two separate things.

Why does tracking the actual amount matter?

Because the history is the useful part. One electric bill tells you almost nothing. Twelve of them tell you your winter is $190 and your spring is $85, and that’s what lets you budget for January in October.

If you only ever budget a single “electric: $100” line, you’ll be over by $90 in January and under by $15 in April, and neither the overage nor the leftover will mean much to you. If you record each month’s real number, the pattern becomes obvious within a year.

How do you set up a bill tracker for variable bills?

Here’s a setup that takes about fifteen minutes and then only a minute or two each month.

  1. List every bill once. Pull three months of bank and card statements and write down everything that repeats. Don’t work from memory; memory reliably misses the quarterly water bill and the annual renewal.
  2. Give each bill its schedule. Monthly for most utilities. Quarterly for water in many towns. Annual for things like car registration or a domain name. Every two months for some utilities that bill bimonthly.
  3. Note where it’s paid from. Which card or account the bill is charged to. When something looks off on a statement, this saves you a search.
  4. Leave the amount blank. This is the important bit. Don’t guess. You’ll fill it in when the bill actually arrives.
  5. Each month, enter the real amount and dates as bills come in.

That’s it. After a few months you have a month-by-month grid of what every bill actually cost.

What dates should you track for each bill?

Track two dates, and one more once you’ve paid it.

  • Bill date: when the bill was issued. Useful for spotting a bill that’s late to arrive, which sometimes means it went to an old address or an old email.
  • Due date: when payment has to arrive. This is the one that matters for late fees.
  • Paid date: when you actually paid it. This closes the loop, and it settles any “did we pay the water bill?” question in two seconds.

Autopay doesn’t remove the need to track. An autopaid bill that suddenly doubles is exactly the thing you want to notice, and autopay will cheerfully pay it without telling you. It may also show as pending in your bank for a day or two before it posts, so a bill due tomorrow is already spoken for.

How much should you budget for a variable bill?

Budget close to the recent high, not the average.

If your electric bill averaged $95 over the last year and you budget $95, you’ll come up short roughly half the months, by construction. Look at the last six to twelve months and budget the second-highest figure instead. Most months you’ll have something left over, which carries forward and covers the peak.

For strongly seasonal bills, you can go one step further: budget the same modest amount every month and let the summer surplus build up for the winter bills. That’s a small sinking fund for heating, and it turns January from a shock into a non-event.

If you budget by paycheck, the variable bills matter even more, since a big utility bill can land on a paycheck that’s already carrying rent. See how to budget by paycheck for how to spread a heavy bill across the checks before it.

How do you handle quarterly and annual bills?

Put them on the same tracker with their own schedule, so they show up in the months they’re actually due and not before.

Quarterly water, a semiannual insurance premium, an annual subscription renewal: these are the bills people forget, precisely because they don’t come every month. A tracker that shows each month’s bills on one screen will show the quarterly water bill in March, June, September, and December and nowhere else, which is exactly when you need to see it.

What should you look for in a bill tracker?

A few things separate a bill tracker you’ll keep using from one you’ll abandon:

  • Set up once. Each bill is defined once with its schedule, not re-created monthly.
  • Blank amounts for variable bills. You type the real amount when the bill arrives instead of overwriting a guess.
  • Due dates and a paid checkbox so you can see at a glance what’s outstanding.
  • A month view with the month’s total, so you can compare months and see seasonal swings.
  • Support for irregular schedules: quarterly, semiannual, annual, one-time, and every-N-months.
  • Sharing, if you split bills. If you split household bills with a roommate, friend, or partner, you want the tracker to tell you who owes whom, not just what was spent.

How Even Cents tracks bills

Even Cents has a Bills page built around this. You set each bill up once with a name, a cadence (monthly, quarterly, semiannual, annual, one-time, or every N months), an optional start month, and an optional “billed to” account.

Each month a bill is due, it appears on a month-by-month grid with a blank amount. When the bill arrives, you type the exact figure. You can add the bill date, the due date, and a note, and ticking Paid stamps today’s date as the paid-on date. The top of each month shows the month’s total and how many bills are paid, and you can step backward through past months or forward to see what’s coming.

If you split bills with someone, turn on Share bills with someone and Even Cents works out each person’s share and who owes whom. See how to split bills fairly. If you don’t, leave it off and it’s a plain bill tracker.

Already tracking bills in a spreadsheet? Upload an .ods workbook of past expenses and Even Cents infers each bill’s cadence and loads the history as paid months, so your year of electric bills is there from day one. Bill amounts are encrypted at rest.

In short

Set each bill up once with its schedule. Leave the amount blank and fill in the real number when the bill arrives. Track the due date and mark it paid. Budget near the recent high, and give quarterly and annual bills their own schedule so they show up in the right month. A year of real numbers beats any estimate. Even Cents is free to start.

Start with your next paycheck

Free to set up. Bring your spreadsheet along.

Create your account