Why spreadsheets fail for EV home charging reimbursement

Spreadsheets cannot handle the variability, scale and data complexity of EV home charging reimbursement.

They work at the start. Then they quietly become the problem and we have heard this many times before.

Why spreadsheets are the default starting point

Most fleets begin with spreadsheets because they are:

• Familiar
• Flexible
• Quick to set up
• Low cost

For a small number of drivers, this works.

You can:

• Collect mileage
• Apply a rate
• Calculate a reimbursement
• Process a payment

At this stage, spreadsheets feel perfectly adequate.

What changes as EV adoption grows

As fleets scale, home charging introduces new variables that spreadsheets were not designed to manage.

These include:

• Different energy tariffs per driver
• Time of use pricing
• Varying charging behaviour
• Mixed business and private miles
• Multiple vehicles per household

The number of inputs increases quickly. So does the risk of error.

Problem 1: Tariff complexity breaks simple models

Electricity is not priced like fuel.

Drivers may be on:

• Flat tariffs
• Variable tariffs
• Time of use tariffs

A spreadsheet often assumes:

• One average rate
• Or a manually entered cost per kWh

This creates problems:

• Rates become outdated
• Time based pricing is ignored
• Drivers are over or under reimbursed

Maintaining accurate tariff data manually is not realistic at scale.

Problem 2: Time of use pricing cannot be handled easily

Many drivers charge:

• Overnight at lower rates
• During peak hours at higher rates

To calculate this accurately, you need:

• Time stamped charging data
• Matching tariff rates

Spreadsheets typically:

• Ignore timing
• Use averages

This reduces accuracy and fairness.

Problem 3: Data collection becomes inconsistent

Spreadsheets rely heavily on manual input.

Drivers may submit:

• Mileage
• Estimated energy usage
• Tariff details
• Or nothing at all!

This leads to:

• Inconsistent formats
• Missing data
• Human error

Over time, the dataset becomes unreliable.

Problem 4: Separating business and private miles is fragile

Spreadsheets struggle with attribution.

You need to:

• Track total miles
• Identify business miles
• Apply a proportion

Without integration:

• Data is self reported
• Validation is limited

This increases the risk of:

• Over reimbursement
• Disputes
• Compliance concerns

Problem 5: Approval workflows do not scale

At small scale:

• Managers can review entries manually
• Finance can sense check totals

As volumes grow:

• Approvals slow down
• Bottlenecks appear
• Errors slip through

Spreadsheets do not provide structured workflows or controls.

Problem 6: Version control becomes a risk

Multiple versions of spreadsheets create confusion.

Common issues:

• Different versions being used
• Data overwritten
• Formulas changed accidentally

This leads to:

• Inconsistent outputs
• Loss of trust in the numbers

Problem 7: Audit trails are weak

Finance teams need to be able to show:

• How a number was calculated
• What data supports it
• Who approved it

Spreadsheets often lack:

• Clear audit history
• Standardised calculations
• Reliable documentation

This creates risk in audits or HMRC reviews.

Problem 8: Admin time grows quickly

What starts as a small task becomes significant.

Admin includes:

• Collecting data
• Cleaning inputs
• Checking calculations
• Managing approvals
• Responding to driver queries

At scale, this becomes:

• Time consuming
• Expensive
• Unsustainable

Problem 9: Driver experience suffers

Drivers experience the output of the system.

With spreadsheets, they often see:

• Delayed payments
• Inconsistent amounts
• Lack of transparency

This leads to:

• Questions
• Disputes
• Reduced trust

Problem 10: Spreadsheets hide the real problem

Spreadsheets give the illusion of control.

In reality:

• Complexity is increasing
• Risk is growing
• Processes are fragile

The problem is not visible until:

• Errors occur
• Drivers complain
• Finance raises concerns

By then, the system is already strained.

When spreadsheets stop working

A useful rule of thumb:

• Up to 10 vehicles, manageable
• 10 to 50 vehicles, warning signs
• 50 plus vehicles, unsustainable

At this point, the effort required to maintain accuracy outweighs the simplicity benefit.

What a scalable alternative looks like

A scalable approach replaces manual effort with structured systems.

Key characteristics:

• Automated data capture
• Tariff aware cost calculation
• Clear separation of business and private miles
• Built in approval workflows
• Strong audit trails
• Ability to shape driver behaviour

This reduces:

• Errors
• Admin
• Risk

How Paua Reimburse replaces spreadsheets

Paua Reimburse is designed to remove the limitations of spreadsheet based processes.

It helps fleets:

• Capture accurate charging data
• Apply real tariff pricing
• Separate business and private miles
• Standardise calculations across drivers
• Provide clear, auditable records

The result is a process that works consistently, even as fleets scale.

The takeaway

Spreadsheets are a useful starting point, but they are not a long term solution for EV home charging reimbursement.

• They cannot handle tariff complexity
• They rely on inconsistent manual data
• They do not scale with fleet growth

Fleets that move beyond spreadsheets early avoid operational and financial friction later.

‍

About Paua

‍Paua is a UK EV charging payment platform for fleets. We help businesses pay for electric vehicle charging across public networks, home charging and shared depots, giving fleet managers control over time, cost and data as they electrify.‍

‍

Read more about Paua Reimburse

‍

‍