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 Card (Weighted Average Cost)
Free Excel template

Stock Card (Weighted Average Cost)

Free Excel stock card valued at weighted average cost: receipts, valued issues, average cost recomputed after each receipt, stock in quantity and value, minimum-stock alert.

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 Card (Weighted Average Cost) » 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 card

Receipts, issues, stock, average cost, value, alert

Valuation

Issues valued at the current average cost

Alert

Negative stock or below minimum

Settings

Item, unit, opening stock, minimum stock

Instructions

Get started in 3 minutes, cells protected without password

Print

Landscape, repeated headers

How to use it

Up and running in minutes.

  1. 01

    In the Settings sheet, enter the item, the opening stock (quantity and unit cost) and the minimum stock.

  2. 02

    Enter each receipt with its quantity and purchase unit cost: the average cost is recomputed.

  3. 03

    Enter each issue with its quantity: it is valued at the current average cost.

  4. 04

    Watch the alert: negative stock or below minimum, time to reorder.

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.
After each receipt: (stock value before the receipt + receipt value) / (quantity before + quantity received). Issues are valued at the current average cost and do not change it. Most accounting frameworks accept this method, alongside first in, first out.
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.