Why Excel is not enough for Department Budget tracking

The problem is not the spreadsheet. It is the data going into it.

By Jeppe Jørgensen, Founder — Onpoint

Excel is not the problem

Most department managers run their budgets in Excel.

It works for structure. Rows, categories, formulas - it does what you tell it.

The problem is not Excel. It is what you feed it.

When actuals come from memory, from forwarded emails, or from a finance report that is already two weeks old - the spreadsheet is only as good as that data.

Garbage in, garbage out. The tool is fine. The inputs are not.

The data going into it is the problem

Every time you update your budget spreadsheet manually, you introduce a lag.

An invoice arrives. You do not see it until someone forwards it - or until Finance closes the month.

By the time it lands in your spreadsheet, the period it belongs to may already be over.

The result: your actuals are always behind. And a budget built on delayed actuals is not a budget - it is a guess with formatting.

The four things Excel cannot do on its own

  • Read invoices: Excel cannot extract line items from a PDF. You have to type them in - or copy from a finance report that already summarises them.
  • Update automatically: Nothing happens in your spreadsheet until you make it happen. Every new invoice is a manual step.
  • Separate one-off from recurring: A total in a cell gives you no signal about whether a cost repeats next month or was a one-time charge.
  • Catch errors: Duplicate invoices, wrong amounts, charges to the wrong cost centre - Excel will not spot them. It just adds up what you give it.

What changes when actuals are backed by invoices

1

Actuals update as invoices arrive

No manual entry. No waiting for the month-end report. The number in your budget reflects what has actually been charged.

2

Every line has a source

You can click through from a budget category to the specific invoices behind it. Not a total - the actual charges, by Supplier, by date, by item.

3

One-off and recurring are visible

When each actual is tied to an invoice line, you know whether a cost is structural or exceptional - without calling Finance.

4

Your spreadsheet stays your spreadsheet

Onpoint does not replace Excel. It connects to it. You keep your layout and formulas - the actuals just become real.

Onpoint is Excel-connected

Onpoint is not a replacement for your spreadsheet. It is what makes the actuals in it trustworthy.

You upload your invoices. Onpoint reads them, maps the line items to your budget categories, and keeps your actuals current.

Your Excel stays exactly as it is. The numbers backing it are now real.

Summary

  • Excel is fine for structure - the problem is the data going into it
  • Manual actuals are always delayed and always incomplete
  • Invoice-backed actuals update automatically and show the detail behind every line
  • Onpoint connects to your spreadsheet - it does not replace it

Frequently asked questions

Does Onpoint replace Excel?

No. Onpoint is Excel-connected. You keep your spreadsheet exactly as it is. Onpoint feeds it actuals that are backed by real invoice data instead of manual entries.

What if my invoices come in different formats?

Onpoint reads invoices regardless of format - PDF, scanned, email attachments. The line items are extracted automatically.

Do I need to change how I structure my budget?

No. Onpoint maps invoice line items to your existing budget categories. You define the mapping once, and it applies automatically.

What about invoices that cover multiple budget lines?

Onpoint splits them. A single invoice with charges across IT, marketing, and travel gets allocated to the right categories automatically.

How is this different from exporting a finance report into Excel?

A finance report gives you totals for a closed period. Onpoint gives you line-level detail in real time - before the month closes, not after.

Keep your spreadsheet. Fix the numbers inside it.

Onpoint connects to Excel and backs your actuals with real invoice data.