I am trying to figure out a way to store historical utility bill data in home assistant. I have the bill estimating logic set up and working very well, but I need to store historical data to compare to the actual bills.
It would also be great to be able to store, view and use the historical bill data. For the moment, I have 4 bills per utility being saved and referenced.
- current month’s bill (estimated)
- previous month’s bill (estimated)
- 2 months previous bill (estimated)
- actual latest bill data from retailer (manually entered)
I am wondering if there is something simple I can do with available core or add-on stuff to store the billing data or if I need to look into creating something new.
Here’s a screenshot of my billing dashboard to get a feel of the data. The last bill template is how I would like to store the data, so the line items match to my actual bill.
