ReferralKnow a company that should run on Procura? Refer it and get rewarded for every signed client.Refer a company, get rewardedDiscover the programmeDiscover
Free Excel templates / Budget vs Actual Tracker
Free Excel template

Budget vs Actual Tracker

Free Excel budget vs actual tracker by department: annual budget, budget to date, committed, month-by-month actuals, available, percentage used and an automatic alert at 80% of budget.

Procura
Download

Your country's version.

Each country has its two files: one fully French, one fully English. Direct download, no sign-up.

FRANCE

France

Multi-rate VAT 20/10/5.5/2.1, euro amounts. Currency, decimals and rates editable in the Settings sheet.French ↓English ↓

QUEBEC

Québec and Canada

5% GST and 9.975% QST computed on net, dollar amounts. Currency, decimals and rates editable in the Settings sheet.French ↓English ↓

AFRIQUE

Africa

18% WAEMU VAT, no-decimal FCFA amounts. Currency, decimals and rates editable in the Settings sheet.French ↓English ↓

By e-mail, optional

Get the template by e-mail, and its updates.

Keep the six files of « Budget vs Actual Tracker » in your inbox, to find or share them later. The direct download stays free, no sign-up.

  • The France, Québec and Africa versions, in French and English.
  • If you wish: three e-mails of tips over ten days, once you confirm, then nothing more.
  • Your details are never sold, one-click unsubscribe.
Contents

What the workbook contains.

Budget

Budget, budget to date, committed, actual, available, alert by department

Monthly actuals

Invoiced spend over 12 months from the fiscal-year start

Dashboard

Totals, variance to date, departments on warning or over

Settings

Currency, decimals, fiscal year, as-of date, alert threshold

Instructions

Get started in 3 minutes, cells protected without password

Print

Landscape, repeated headers, fit to width

How to use it

Up and running in minutes.

  1. 01

    In the Settings sheet, set the currency, the fiscal-year start and the alert threshold (80% by default).

  2. 02

    In the Budget sheet, enter one row per department with its owner and annual budget.

  3. 03

    Keep committed up to date (issued orders not yet invoiced) and enter invoiced actuals each month.

  4. 04

    Available, percentage used and the alert (OK, Warning, Over) compute automatically; the dashboard lists departments on alert.

FAQ

Your questions, answered.

Yes: direct download, no sign-up or e-mail. Use it freely internally and duplicate it each month or fiscal year. If you prefer, you can also get it by e-mail.
Committed is orders issued but not yet invoiced; actual is invoiced spend; available is budget minus both. Tracking committed avoids the bad surprise: a budget can look healthy on actuals while open orders have already used it up.
The spreadsheet shows its limits: email approvals, re-entry, duplicates. Procura automates the same cycle (requests, POs, AI 3-way matching, taxes, payments) and is usually deployed within a week.

The same cycle, automated.

Procura replaces the spreadsheet as the team grows: online approvals, AI 3-way matching, taxes filed from the books.