What Excel cannot tell you about your Invoices

Your spreadsheet shows a number. Your invoice has the story behind it.

By Jeppe Jørgensen, Founder — Onpoint

The number in your cell

Your budget shows €47,000 for IT this month.

That number came from somewhere. An invoice. Or several.

But the cell does not tell you which Supplier. Which service. Whether it was planned. Whether it repeats.

It just shows 47,000.

Every budget line is a summary of something that happened. Excel holds the summary. The invoices hold the truth.

What gets lost when you type it in

When you manually enter actuals into a spreadsheet, you compress the data.

A five-line invoice becomes one number. The Supplier name disappears. The individual items disappear. The date each item was charged disappears.

That detail is not gone - it is still in the invoice. But it is no longer in your budget.

And when someone asks why the number is what it is, you have to go back and find the invoice again.

Five things hidden behind every budget line

Supplier name: Which company sent the invoice. When multiple Suppliers contribute to one budget category, a total tells you nothing about who charged what.
Line items: What specifically was bought. Software licences, consulting hours, delivery fees - a total hides the composition entirely.
Date: When the charge was incurred, not when you entered it into the spreadsheet. Timing matters when you are explaining a variance.
Whether it was planned: A charge you expected is a different conversation than one that surprised you. The invoice makes this visible. The cell does not.
Whether it repeats: A one-off charge and a recurring subscription look identical in a budget cell. Only the invoice tells you which it is.

How invoice-backed actuals change what you can see

Every budget line links back to its invoices

Not just the total - the specific charges that make it up. Supplier, item, date, amount. All visible from the budget view.

Filter by Supplier across the whole month

See everything AWS charged you. Everything from a specific contractor. Without asking Finance for a breakdown.

Anomalies surface automatically

Duplicate invoices, unusual amounts, first-time Suppliers - these are flagged without you having to look for them.

The answer is one click away

When someone asks why a number is what it is, you already know. No two-day chase through emails and PDFs.

What Onpoint connects

Onpoint reads your invoices and maps each line item to your budget.

Your spreadsheet stays the same. But behind every cell is now a full invoice record - Supplier, date, items, amounts.

You keep the structure you already know. The detail that was always locked in PDFs is now searchable, filterable, and always current.

Summary

Every budget cell is a summary - the invoice behind it has the detail
Manual entry compresses that detail into a single number
Invoice-backed actuals keep Supplier, item, date, and amount linked to every line
When someone asks why, the answer is already there

Frequently asked questions

Can I see invoice detail for past months too?

Yes. Once invoices are uploaded, the line-level detail is available for any period. You can go back and see exactly what drove a number - not just what the total was.

What if I already have a spreadsheet I am happy with?

Keep it. Onpoint does not change your spreadsheet structure. It just makes the actuals in it accurate and traceable.

Do I need to upload every invoice manually?

No. Invoices can be forwarded automatically or connected via your email inbox. Once set up, new invoices are processed as they arrive.

What if an invoice covers multiple categories?

Onpoint splits it. A single invoice with IT and facilities charges gets allocated to the right budget lines automatically.

How is this different from what Finance already does?

Finance gives you period totals in the ERP. Onpoint gives you line-level access in real time - before the month closes, in a format you control.

Related resources

Excel

See what is behind every number in your budget.

Onpoint links every budget line back to the invoices that created it.

Use Onpoint Free See how it works