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 / Accounting Journal
Free Excel template

Accounting Journal

Free Excel double-entry accounting journal: date, document, journal code, account with its name looked up in your region's chart of accounts, debit, credit, balance check per document.

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 « Accounting Journal » 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.

Entries

Double entry, journal codes, per-document check

Chart of accounts

PCG, SYSCOHADA or Canadian numbering by region

Checks

Debit and credit totals, unbalanced documents, unknown accounts

Settings

Currency, decimals

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

    Check the included chart of accounts and add your accounts at the bottom of the list.

  2. 02

    Enter each entry over several lines: date, document, journal, account, description, debit or credit.

  3. 03

    The account name appears automatically; « Unknown account » flags a typo.

  4. 04

    The Checks sheet verifies each document and the whole journal balance.

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.
Each transaction affects at least two accounts: total debits equal total credits. A purchase invoice debits the purchase account and the recoverable tax, and credits the supplier for the total. The template visibly flags any unbalanced document.
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.