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 / Income and Expense Log
Free Excel template

Income and Expense Log

Free Excel income and expense log for the self-employed and small businesses: amounts including tax, net and tax included computed, categories, monthly summary and net tax due.

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 « Income and Expense Log » 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.

Log

Income and expenses, gross, net, tax included

Monthly summary

Income, expenses, result, tax collected, deductible and net

Included rates

List of total rates (Québec: GST + QST)

Settings

Currency, year, rates

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, set the currency, the year tracked and the possible included tax rates.

  2. 02

    Record each receipt and payment: date, type, category, amount including tax and the included tax rate.

  3. 03

    Net amount and tax compute; the summary gives income, expenses, result and net tax by month.

  4. 04

    File each receipt under its number.

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.
A chronological record of income, and of expenses if you deduct actual costs, with for each line the date, customer or supplier, amount, payment method and receipt reference. This is what the French tax authority asks of micro-entrepreneurs and Revenu Québec of self-employed workers.
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.