Les 5 meilleurs modules complémentaires de Google Sheets pour la finance

People all over the world are building business solutions with Google Sheets add-ons. If you haven’t tried one yet, you are probably still doing tedious, manual work by hand, and missing out on better ways to run your finance department.

Think about the invention of the electronic spreadsheet and the change it made to the way finance departments work. Before electronic spreadsheets existed, spreadsheets were all created by hand (Pouvez-vous imaginer le cauchemar ?).

Electronic spreadsheets let people record and organize numbers quickly, and as their capabilities improved we’ve been able to sort and move data faster. These days it isn’t only up to the program developers to give us access to new tools: Google Sheets lets third-party developers build add-ons that change the way we use spreadsheets.

If you’ve been using spreadsheets like it’s 2011, it’s time to try add-ons. Below are five of the best for finance teams, and the first one also gives you a free income statement template you can copy to your own Drive.

How to access Google Sheets add-ons

Getting an add-on is simple. The quickest way is to click the link for the add-on you want: it opens the listing in the Google Workspace Marketplace, where you click Installer. You can also browse from inside a spreadsheet:

1. Ouvrir une feuille de calcul
2. Cliquez sur Extensions in the menu bar
3. Hover over Compléments et cliquez sur Obtenir des compléments
4. The Google Workspace Marketplace window opens for you to browse
5. Click any add-on to see more detail about it
6. Cliquez sur Installer to add it to Google Sheets

Les mêmes étapes installent le module complémentaire Goal Seek de Google, qui trouve la valeur d'entrée permettant d'atteindre un objectif chiffré, comme le volume de ventes du seuil de rentabilité. Consultez comment utiliser Goal Seek dans Google Sheets.

Our top 5 finance add-ons

Here are five Google Sheets add-ons that finance teams get real use out of, and what each one is good for. One note before we start: the free download in this post is not an add-on but a spreadsheet. It is the Income statement template from Sheetgo, a single Google Sheets file you copy to your own Drive, and you will find it under number one.

1. Sheetgo

Sheetgo is a data automation platform for teams that live in spreadsheets. It links the Google Sheets, Excel files, CSVs and databases your numbers are scattered across into a single pipeline, so month-end figures land in one place, clean enough to report on and to hand to AI.

Sheetgo also publishes free templates for finance teams, and the one we are handing over in this post is the Modèle de compte de résultat. It is one Google Sheets file that you copy to your own Drive: the layout, the formulas and a set of sample rows to write over. There is no account to create and nothing to connect.

Start in the Entrées tab, where you set the year you are reporting on and fill in the accrual table: an amount you want recognized straight away is divided by 1, while one you want spread over five years is divided by 5. That keeps a single large invoice from distorting one month.

Then log your figures in two tabs. Revenu takes one row per invoice received and Dépenses Entrées one row per cost, each with category and department columns and an accrual period. The Compte de résultat mensuel tab builds the statement from those entries, one column per month plus a total for the year, and it fills in as you type. Income Summary per Month et Résumé des dépenses par mois break the same numbers down by category, Income Accrual Mapping shows how each accrued amount was spread across the year, and a Read me tab explains the layout inside the file itself.

The link below opens Google’s copy dialog. Click Faire une copie and the template is in your own Drive, ready for your figures.

2. Feuilles de papier

Feuilles Bkper is a Google Sheets add-on for teams on Google Workspace. It suits just about any finance department, so schools, businesses, start-ups and non-profits all use it. Bkper integrates with various Google apps, which makes it easy to collaborate with team members.

You can update financial information in Bkper straight from a spreadsheet, and assign spreadsheets to different team members with different levels of permission to view, edit or comment. Many finance teams find this a good way for employees to create and manage expense reports from any device.

Information reaches Bkper in real time, ready to be accessed, and you can attach pictures or locations to transactions. Bkper also integrates with Google Docs and Google Forms for reporting and data entry.

Obtenez le module complémentaire ici : Bkper

3. Table impressionnante

Une table géniale is appropriately named. It lets people with little technical expertise build clear visual representations of data. Gone are the days when you needed advanced spreadsheet skills to make a graph or put together a readable report.

That is just the beginning. Awesome Table also integrates with Google Sites, WordPress, Drupal and many other content management systems. You can turn spreadsheet data into an interactive address book, a map view or a card view, and those are only a few examples.

Si le terme est nouveau pour vous, voici ce qu'est un système de gestion de contenu (CMS) et comment se comparent les principales plateformes.

There are several Awesome Table add-ons you can get to improve how your spreadsheets look, which makes your financial data easier to read and share with the rest of the team.

Obtenez le module complémentaire ici : Une table géniale

4. Feuilles de sagesse

For investors looking to find better opportunities faster, Wisesheets is a useful Google Sheets add-on. It provides data such as stock financials, dividends, ETFs and live data, all inside your spreadsheet.

Wisesheets also comes with an assortment of adaptable templates such as stock watch lists, DCFs and screeners. If you prefer, you can build your own from scratch and shape it around your own investment strategy.

Obtenez le module complémentaire ici : Feuilles de sagesse

5. LiveFlow

LiveFlow connects your accounting software, such as QuickBooks and Xero, to Google Sheets. It syncs your financial data into customizable, real-time spreadsheets, so your reports stay current instead of being rebuilt by hand, and you can keep an eye on expenses and income as the month goes on.

LiveFlow also gives you a variety of des modèles adaptés aux différents besoins financiers, including profit and loss statements, balance sheets and cash flow analysis. Each one comes with a dashboard that gives you a clear view of your vital financial metrics.

Obtenez le module complémentaire ici : LiveFlow

Modernize the way your finance team works

Those are our five picks: a free income statement template from Sheetgo, bookkeeping in Bkper, visual reporting in Awesome Table, market data in Wisesheets and a live link to your accounting software in LiveFlow. Start with the one that solves the job in front of you this month rather than adding all five at once.

Whichever tools you pick, someone still has to enter the numbers and chase the people who have them. If you would rather that part did not land on you, that is what Owen, Sheetgo’s finance virtual employee, is for: your data stays in Google Sheets, and you work with Owen in Slack, Teams or Google Chat.

Questions fréquemment posées