Cutting Fixed Costs

Reading a year of electricity bills with 30-minute data: what to do before getting a solar quote

Reading a year of electricity bills with 30-minute data: what to do before getting a solar quote

Good morning, this is まさきん.

I am currently considering putting solar panels on our house. Partway through, I was asked, “Please tell us your electricity bills and usage for the past year.” To answer, I went back through our electricity in actual numbers, so here are the steps and what I noticed.

*This information is current as of publication. Please check the official sites for the latest details.

POINT
  • Before getting a solar quote, get your own grip on a year of usage and “when you use it”
  • There are two angles: the seasonal peaks by month, and the day/night split seen in 30-minute interval data
  • The more electricity you use during the day, the more of your generated power you can typically use yourself
  • For fiscal 2026, the residential feed-in price differs between the first 4 years and year 5 onward
  • Having your own numbers tells you where to look in the installer’s estimate

I was asked for “a year of electricity” before the quote

I was contacted by both the coordinator organizing the solar installation and the installer. They wanted to know our electricity bills and usage for the past year in order to estimate the benefit.

At first, I thought lining up 12 months of bill amounts would be enough. But on reflection, “how we use it” seemed more important. Solar only generates during the day. So whether a household uses power during the day should change how much it helps.

Our electricity provider is Octopus Energy. Using the billing emails and the online account page, I put everything into one table and replied. I had AI help with the work. I am still waiting for the estimate results.

Why “a full year” is needed

Electricity usage swings a lot by season. Summer has a peak from air conditioning, and winter from heating. Spring and autumn tend to be the valleys.

Solar generation also changes by season. It is higher when days are long and lower in winter. To see how the usage peaks overlap with the generation peaks, you need a full year.

Using only one month or the last three months might distort the yearly picture. For example, an estimate based only on winter numbers gets pulled toward the season when generation is low and usage is high.

SeasonUsage trend (general)Generation trend (general)
Spring/AutumnLittle heating or cooling, tends to be a valleyGenerates well in good weather
SummerAir conditioning tends to create a peakLong days, generation is higher
WinterHeating and lighting tend to create a peakShort days, generation is lower

In our case, annual usage was well above the average household. We are a family of six with four kids, so I think being on the high side is natural.

Why “when you use it” matters

Electricity generated by residential solar is used inside the home first. Whatever you cannot use becomes electricity sold to the power company.

This is where the price difference between buying and selling electricity comes in. Whatever you use yourself is electricity you do not have to buy. Whatever you sell is bought back at a set price.

Generally, it seems the price of buying electricity is often higher than the selling price. In that case, using generated power yourself tends to be better than selling it.

In other words, the more electricity a home uses during the day, the more solar tends to pay off. Conversely, a home that is empty during the day and uses power mostly at night will sell a larger share. What I used to look at this “day/night split” was the 30-minute interval data.

Checking the fiscal 2026 feed-in price

The price for selling electricity is set by Japan’s national FIT (feed-in tariff) scheme. I checked the residential (under 10kW) price on the Agency for Natural Resources and Energy’s page.

CategoryPurchase price (per kWh)Period
FY2026, years 1–424 yenFirst 4 years
FY2026, years 5–108.3 yenRemaining 6 years
(Reference) FY2025 April–September15 yen10 years

For fiscal 2026, the first 4 years are 24 yen per kWh. From year 5 to year 10, it drops to 8.3 yen. The pricing is reportedly front-loaded so the initial investment can be recovered sooner. The same pricing has apparently already been applied since the second half of fiscal 2025.

Personally, the 8.3 yen from year 5 onward caught my attention. On many rate plans, the price of buying electricity is quite a bit higher than that, I think. So the longer the time frame, the more “the share you use yourself” may matter.

For after the period ends, the Agency for Natural Resources and Energy also outlines options: using the power at home combined with a storage battery or an electric vehicle, or selling it under an individual contract with a power company.

Think about storage batteries from your “night usage”

I suspect many quotes come with a proposal bundled with a storage battery. A storage battery is equipment that stores surplus daytime electricity so you can use it at night.

So night usage is a clue to how much a battery would help. A home that uses a lot at night has somewhere to use the stored power. On the other hand, a home with little daytime surplus might not have enough power to store.

Here too, the 30-minute data helps. You can only see daytime surplus and night usage by looking at time slots. We have not decided on a storage battery yet either.

The steps I took

Here is the actual flow I followed.

  1. Gather 12 months of billing emails going back
  2. Pick out each month’s usage (kWh) and bill amount from the email text
  3. Add up the 12 months to get annual usage and annual electricity cost
  4. Look at usage every 30 minutes on the online account page to get a sense of the time-of-day pattern
  5. Put the annual numbers and the time-of-day pattern into one table and reply

I had AI help with steps 2 and 3. Picking numbers out of email text and turning them into a table felt much easier.

Lining up the monthly numbers makes the seasonal peaks obvious at a glance. It is also a bit fun to work out the average price per kWh. You just divide the bill amount by usage.

Where I got stuck

The work did not go as smoothly as I expected. I got stuck in two places.

The first was the invoice PDFs. The PDFs were email attachments, and the AI could not extract their contents. So I used the numbers written in the body of the billing emails. The body included both usage and amount, so that was enough this time.

The second was the online account data. I could not fetch the 30-minute usage automatically. In the end, I opened the account page myself and looked through it by hand. Rather than copying it down, I browsed it to get a sense of the time-of-day pattern.

Once you look at your electricity bill in this much detail, other fixed costs start to bother you too. It seems worth lining up your monthly phone and internet costs in numbers the same way.

Try the fee simulator and get 100 points, no sign-up required While you are at it, review your phone bill with Rakuten Mobile too

Clicking this opens the Rakuten login page. Once you log in, you’ll see the campaign details.

How to read 30-minute data

A smart meter measures usage every 30 minutes. Kansai Transmission and Distribution’s page explains it that way too. Another feature is automatic remote meter reading through its communication function.

According to Octopus Energy’s FAQ, you can check it from the electricity usage section of the online account page. It says you can see usage and estimated charges by hour, day, and month.

I think 30-minute data is useful even without totaling all of it. Here are some things to look for, for example:

Just picking a few days per season and looking through them may be enough to see the pattern.

Octopus Energy’s FAQ also has guidance for when the display shows 0. Data can take time to arrive, and it says to wait a while and reopen the page. The bill amount apparently reflects accurate data.

What I put in the one-page table

The table I sent back used the following items. I will not share the actual numbers here, but the framework should be reusable as is.

ItemWhat to writeSource
Power company and planCompany name and plan nameBilling email
Monthly usage12 months of kWhBilling email text
Monthly bill amount12 months of amountsBilling email text
Annual usageTotal of 12 monthsSum of the above
Annual electricity costTotal of 12 monthsSum of the above
Seasonal peaksHigh and low monthsMonthly lineup
Time-of-day patternWhether day or night is higher30-minute data on the account page
Lifestyle patternTimes when people are usually home, etc.My own notes

The last one, lifestyle pattern, is not a number. But I think it is useful information for whoever does the estimate. Daytime usage changes depending on whether there are work-from-home days, for example.

What to look at in the installer’s estimate

With your own numbers, you know what to look at when the estimate arrives. I have not received the results yet, so these are the points I plan to check.

The self-consumption rate in particular could move the estimate a lot. If you have looked at your own day/night split, you can judge whether that number is too optimistic.

Common pitfalls

Here are points that seem easy to trip over, based on the official information and my own work.

Warning
  • Deciding based only on the last few months and missing the seasonal peaks
  • Looking only at bill amounts without checking usage (kWh)
  • Calculating all 10 years using the first-4-year selling price
  • Deciding whether you need a storage battery without looking at day vs. night usage
  • Giving up after trying to collect by hand all the data that cannot be fetched automatically

I think looking at just enough to see the pattern is more sustainable than collecting everything.

Households that charge an EV at home will see that added to their usage. Depending on when you charge, the day/night split may change too. I have written about my approach to EV charging in my post about driving a Tesla without home charging.

Things to check before you start

If you do not have a smart meter, you may not be able to see 30-minute data. Octopus Energy’s FAQ says the meter is, in principle, replaced free of charge when you switch. The replacement is done by the general transmission and distribution operator. However, depending on the installation, there may be additional costs.

FAQ

Q. Is it enough to share just the bill amounts?

With bill amounts only, changes in unit price and changes in usage get mixed together. I think sharing monthly usage (kWh) as well tends to make the estimate more accurate. It is often listed in the body of the billing email, so take a look.

Q. Where can I see 30-minute data?

It seems it is often available on your power company’s online account page or app. For Octopus Energy, you can reportedly check it by hour from the electricity usage section of the account page. Please check each company’s guidance for what range and period you can view.

Q. Do I need to collect a full year of 30-minute data?

I do not think it is required. Looking at a few typical days per season is enough to see the day/night pattern. I also looked by hand, so I stopped at getting a sense of the pattern.

Q. What is the feed-in price for fiscal 2026?

According to the Agency for Natural Resources and Energy’s page, residential (under 10kW) is 24 yen per kWh for the first 4 years. From year 5 to year 10, it is 8.3 yen. The price changes depending on when you are certified, so please check the latest information.

Q. Is solar a bad fit for homes where nobody is in during the day?

I would not go that far. It just means a larger share gets sold, so the estimate looks different. Combinations like storage batteries or running appliances on timers may change things too.

Q. What if I cannot get the numbers from the invoice PDF?

In my case, usage and amount were in the body of the billing email. Even if the PDF will not open, the email text or account page may be enough. Checking just one email first to see what is where is the quickest approach, I think.

Q. How can I tell if I have a smart meter?

It seems you can often tell from the meter’s appearance, or from guidance by your power company or the transmission and distribution operator. If you are not sure, asking your power company is the surest way.

Official references

Summary

Before getting a solar quote, I went back through a full year of our electricity. I looked at two things: the seasonal peaks by month, and the day/night split seen in 30-minute data.

With the numbers in hand, I know what to look at when the installer’s estimate arrives. I plan to decide whether to install after seeing the results. I have also summarized how to review fixed costs overall in getting started with reviewing fixed costs.

If you are thinking about solar, just opening one billing email might be a good place to start.

Try the fee simulator and get 100 points, no sign-up required Review your monthly phone costs once with Rakuten Mobile

Clicking this opens the Rakuten login page. Once you log in, you’ll see the campaign details.

This article contains affiliate advertising. If you sign up for a product or service through a link on this site, we may receive compensation from the partner company. The site operator is also an employee of Rakuten Group and may receive compensation through an employee referral program. The content and opinions here are based on the operator’s own experience and research regardless of any advertising relationship, but please read with the above in mind. See the Disclaimer & Affiliate Disclosure for details. Disclaimer & Affiliate Disclosure

This article includes machine-translated content. Please check the official Rakuten Mobile multilingual page for exact terms.

If you have concerns about Rakuten Mobile coverage or signal quality, you can consult through the official signal improvement request form .

ABOUT THE AUTHOR
まさきん

Rakuten Group employee · Digital Marketer (holds a Financial Planner qualification)

In his early 40s, part of a dual-income household with four kids. Works as a digital marketer at Rakuten Group, while also using his Financial Planner (FP) qualification to focus on household finances and building assets.

View Profile

Related Articles

RELATED
You Can't Judge a Convenience Store Spending Cap Within the Month: Card Statements Lag Days, So I Judge on the 4th or 5th of the Next Month Cutting Fixed Costs

You Can't Judge a Convenience Store Spending Cap Within the Month: Card Statements Lag Days, So I Judge on the 4th or 5th of the Next Month

Even with a monthly cap on convenience store spending, card statements arrive days late. Here is a real example where, on the 16th, only charges through the 11th had come in, a table of how PASMO, Rakuten Pay and cash show up differently, and the steps I use to push the final judgment to around the 4th or 5th of the following month.

2026.10.18 · 12 min read
Apple Watch Trade-In: Ultra 2 Gets Up to 42,000 Yen, and the Steps to Finish Within 24 Days of Applying Cutting Fixed Costs

Apple Watch Trade-In: Ultra 2 Gets Up to 42,000 Yen, and the Steps to Finish Within 24 Days of Applying

With Apple Trade In, an Apple Watch Ultra 2 is worth up to 42,000 yen. If you take an Apple Gift Card, your watch should arrive within 24 days of applying, and you send only the watch itself. Here is my plan from unpairing to dropping it in the mailbox, plus how to compare it with resale shops.

2026.10.18 · 11 min read
How to Do No Money Days Three Days a Week: 10 Minutes of Prep at 9 p.m. the Night Before, and the Pitfall of Shopping for Events Cutting Fixed Costs

How to Do No Money Days Three Days a Week: 10 Minutes of Prep at 9 p.m. the Night Before, and the Pitfall of Shopping for Events

I set no money days (days without spending) on Tuesday, Wednesday and Thursday, three days a week. What keeps it going is 10 minutes of prep at 21:00 the night before. Last week my card usage alerts showed 0 transactions on all 3 days. Here is the pitfall that nearly clashed with shopping for a school trip, and how to set your own rules.

2026.10.12 · 13 min read
Switch to Rakuten Mobile, get up to 14,000 points Try the fee simulator and get 100 points, no sign-up required →
Apply Now →