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 / Simplified Balance Sheet
Free Excel template

Simplified Balance Sheet

Free Excel simplified balance sheet over two years: non-current and current assets, equity and liabilities, balance check, working capital, working capital requirement, net cash, equity ratio and current ratio.

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 « Simplified Balance 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.

Assets

Fixed assets, inventory, receivables, cash

Liabilities and equity

Equity, borrowings, payables, overdrafts

Check and ratios

Balance, working capital, requirement, net cash, equity, liquidity

Settings

Currency, decimals

Instructions

Get started in 3 minutes, cells protected without password

Print

One portrait page

How to use it

Up and running in minutes.

  1. 01

    Take the year-end balances from your trial balance, as net amounts.

  2. 02

    Enter assets and liabilities for N, and for N-1 to compare.

  3. 03

    The check must show Balanced; otherwise an account is missing or on the wrong side.

  4. 04

    Read the five ratios: working capital, working capital requirement, net cash, equity ratio, current ratio.

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.
Working capital is the excess of long-term funds over fixed assets; the working capital requirement is the cash tied up in the cycle (inventory and receivables less trade and tax payables). The difference is net cash: if the requirement exceeds working capital, the business lives on overdraft.
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.