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 / Stock Count Sheet
Free Excel template

Stock Count Sheet

Free Excel stock count sheet: book and counted quantity, variances in quantity, value and percentage, configurable tolerance, items to recount and a variance summary.

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 « Stock Count Sheet » 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.

Stock count

Book, counted, variances in quantity, value and percentage

Check

OK, within tolerance, recount, check

Dashboard

Book and counted value, net and absolute variance

Settings

Currency, decimals, variance tolerance

Instructions

Get started in 3 minutes, cells protected without password

Print

Landscape, repeated headers, filter by location

How to use it

Up and running in minutes.

  1. 01

    In the Settings sheet, set the currency and the variance tolerance (2% by default).

  2. 02

    Paste each item's book quantity and unit cost from your software.

  3. 03

    Count by location and enter the counted quantity; variances and checks compute.

  4. 04

    Recount the flagged items, then post the approved variances in the books.

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.
One to two percent on standard items, zero on expensive or sensitive items. Above the tolerance, recount before adjusting stock: most variances come from counting errors or unrecorded movements, not real losses.
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.