Think Build Implement Repeat
London, UK +44 7367 067226
WhatsApp FOLLOW f in X
  1. Home
  2. Blog
  3. How Can an Energy Consultancy Keep Track of Every Billing Query Raised With Suppliers Until It Is Resolved?
Problems We Solve

How Can an Energy Consultancy Keep Track of Every Billing Query Raised With Suppliers Until It Is Resolved?

Energy consultancies raise billing queries with suppliers and lose track of them for months. We build a query tracker with references, chasing and outcomes.

Updated 3 min readBy SpiderHunts Technologies

Free estimateNo obligation

Get a free estimate

Tell us what you need. A senior engineer reads every enquiry.

Takes under a minute. We never share your details.

  • Free consultation
  • No commitment
  • NDA on request

Prefer to talk? Book a free 30-minute call →

Quick answer — TL;DR

Billing queries with suppliers can take months to resolve, pass through several teams and get new reference numbers along the way. Consultancies track them in spreadsheets and inboxes, and many go quiet. We build a query tracker that records each query against the client, meter and bill, holds every supplier reference, chases on a schedule and records the outcome, including credits promised and received.

Query raised in March, still open in September

Your analyst found a wrong standing charge on a client's bills and raised a query with the supplier in the spring. The supplier acknowledged it with a reference. A month later, a different team replied asking for a copy of the contract, with a new reference. Then nothing. The analyst who raised it has since moved to another client.

In September, the client asks whether the credit ever came through. Nobody can say without reading through six months of emails.

Why supplier queries go quiet

Billing queries are slow by nature, and the process at the supplier's end involves handoffs. On the consultancy side, they are tracked less carefully than new business.

  • Queries are raised by email from individual analysts.
  • Suppliers issue new reference numbers as queries move between teams.
  • Responses arrive in shared or personal inboxes.
  • There is no routine for chasing queries that have gone quiet.
  • Credits promised are not checked against later bills.

Money left on the table

A query that goes quiet often means a credit never received. The client paid for an error and was never refunded, and the consultancy's work to spot it counted for nothing.

Clients notice when the same issue appears on bill after bill. They also notice when their consultant cannot tell them the status of a query. And analysts spend time rebuilding the history of a query instead of resolving it.

There is a management blind spot as well. Without a list of open queries, nobody can see how many are waiting on each supplier, which clients have the most outstanding, or whether a particular supplier's queries routinely stall at the same stage. Those are useful facts in a supplier relationship meeting, and they are usually missing.

A query tracker from first email to credit

We build a supplier query tracker linked to your bill validation.

  1. Each query is created against the client, meter and bills affected, with the issue and the amount in question as your analyst has worked it out.
  2. The query is sent to the supplier from the tracker, using the supplier's preferred address or portal, and a copy is kept.
  3. Replies are matched to the query from the inbox, including replies with new reference numbers, using the meter, account and bill details. Uncertain matches go to a person.
  4. Every supplier reference is kept against the query, so the history is in one place.
  5. Queries without a reply are chased after an interval you set, then escalated.
  6. When a supplier agrees a credit, it is recorded, and later bills are checked to confirm the credit appears. If it does not, the query is reopened.
Emails and spreadsheetQuery tracker
Where the query livesAn analyst's inboxAgainst the client and meter
Supplier referencesScatteredAll kept on the query
ChasingWhen rememberedOn a schedule
Credit promisedAssumed receivedChecked against later bills
Client asks for statusSearch and reconstructCurrent status on screen

The tracker records what was raised and what happened. Whether to escalate further, and how, remain decisions for your consultancy and the client.

Queries that reach an outcome

Every open query is on a board by client and age. The ones that have gone quiet are chased automatically. When a credit is agreed, the next bill is checked for it. When an analyst moves to another client, their queries stay visible and move with the client.

In reviews, you can show clients every query raised on their behalf, the status and the credits received, which is a clear record of value.

Are supplier queries disappearing?

  • Queries are tracked in analysts' inboxes.
  • You cannot quickly list open queries for a client.
  • Suppliers' reference numbers change and are lost.
  • Promised credits are not checked on later bills.
  • Queries go quiet when analysts move on.

FAQ

Frequently asked questions

The questions readers ask us after this guide.

Still have a question?

Ask us directly — a senior engineer will get back to you.

Ask about your project

Can it read replies with new reference numbers?

Yes. It matches using meter numbers, account numbers and bill details as well as references, with a person checking uncertain matches.

Does it work with our bill validation?

Yes. Mismatches found in validation can become queries with one click, carrying the details across.

Can clients see their queries?

If you want them to, through reports or a client portal.

What if a supplier only accepts queries through its portal?

The tracker creates a task for a person to submit it and records the portal reference when they do.

Keep reading

More on Problems We Solve

Start here

Tell us how your team checks client bills today

Describe how bills reach you, how many sites you look after and what your analysts check by hand. We will tell you what we would build, and if a smaller change would get you most of the way, we will say so.

  1. You tell us what you needTwo minutes on the form, or a message on WhatsApp.
  2. A senior engineer reviews itAnd comes back with questions, a realistic range and an honest view on fit.
  3. Free 30-minute scoping callWe talk through scope, options and a realistic estimate — with no obligation.
Free estimateNo obligation

Talk to someone who builds this

Send a short brief and we will come back with an honest view and a realistic range.

Takes under a minute. We never share your details.

  • Free consultation
  • No commitment
  • NDA on request

Prefer to talk? Book a free 30-minute call →