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 / Petty Cash Book
Free Excel template

Petty Cash Book

Free Excel petty cash book: cash movements with receipt and category, balance after each row, negative-balance alert, physical count with cash difference and outflows by category.

Comptia by 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 « Petty Cash Book » 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.

Petty cash

Date, receipt, description, category, in, out, balance

Count and summary

Book balance, count, difference, outflows by category

Alert

Negative balance flagged on the row

Settings

Currency, opening balance

Instructions

Get started in 3 minutes, cells protected without password

Print

Portrait, repeated headers

How to use it

Up and running in minutes.

  1. 01

    In the Settings sheet, enter the currency and the opening petty cash balance.

  2. 02

    Record each movement the same day with the receipt number and category.

  3. 03

    The balance computes after each row; a negative balance reveals a missing entry.

  4. 04

    Count the cash weekly or monthly: the cash difference must be zero.

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.
You cannot pay out cash you do not have: a negative balance almost always signals an unrecorded receipt or a duplicated payment, and audits often point it out. The template flags it on the row and the physical count confirms the real balance.
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.