Modelo de fluxo de caixa no Planilhas Google

Ficar de olho em seu fluxo de caixa é essencial para tomar boas decisões de negócios. E um demonstrativo de fluxo de caixa é um dos principais documentos que os credores e investidores levam em conta ao avaliar a saúde geral de uma empresa. Para que sua empresa seja viável, ela deve gerar receita (recebimentos) suficiente para cobrir as despesas (pagamentos). Para acompanhar isso, você precisa de um sistema para monitorar com precisão o fluxo de entrada e saída de dinheiro.

Sales proceeds, investments, operational costs, taxes, debt repayments … most businesses have multiple revenue and expenditure streams. This makes it difficult to keep the whole picture in one place. Data is often processed by different departments, resulting in communication delays and a lack of standardization.

Even if you have an in-house accounting team, collating receipts and payment data is often still a manual task. Financial management software can help, especially when you want to create smart reports and visualizations. But these programs come with a hefty price tag, and you still have to feed them the numbers.

Every business has unique financial management processes. Nonetheless, there’s one thing that every company in the world has in common: spreadsheets. A good cash flow template gives you the structure of purpose-built software without the price tag: one Google Sheets file where you log what came in and what went out, and your balance, your monthly totals and the chart are worked out from those entries.

That is what Sheetgo’s free Modelo de fluxo de caixa is. It is a single Google Sheets file that you copy into your own Google Drive — no account to create, nothing to set up.

Por que usar o Google Sheets para o gerenciamento do fluxo de caixa?

• Flexível: Independentemente do tipo de negócio que você administra, o Planilhas Google permite que você crie um sistema sob medida. Você pode adaptá-lo conforme as necessidades mudam, sem precisar de um novo software.
• Acessível: Você e seus colegas de trabalho podem acessar, compartilhar e trabalhar com todos os seus dados financeiros de qualquer lugar do mundo. Tudo o que você precisa é de uma conexão com a Internet.
• Compatible with everything: Every other piece of software in the world integrates with Google Sheets. As a result, you can get income and expenses data out of the tools your teams already use and into your sheet.
• Fácil de usar: Não há necessidade de integrar a sua equipe, pois ela já trabalha com planilhas diariamente. A manutenção é fácil e não há necessidade de suporte de TI.

What the cash flow template does

O Sheetgo cash flow template keeps money coming in and money going out on two separate tabs, so you can see what you have received and what you have paid without picking through one long list. Everything else in the file — your running cash balance, receivables and payables by month, and the chart that plots them — is worked out from those two logs by formulas that are already in place.

You are not tied to the version that arrives, either. Rename the categories, add columns, switch the currency: it is your own copy of an ordinary Google Sheets file, so you can shape it around the way your business actually runs.

O que você obtém com este modelo

The template is one Google Sheets file. Alongside a Read me tab that explains how it fits together, you get:

1. Entradas: the start date for the period you want to track, and your opening balance.
2. Recebimentos: a log for money coming in, invoice by invoice — client name, invoice number, invoice amount, amount received, date received and a product category.
3. Pagamentos: the same layout on the outgoing side — supplier, invoice number, invoice amount, amount paid, date paid and an expense category.
4. Cash Flow Analysis: your cash balance, receivables and payables month by month, calculated from those two logs.
5. Gráfico de fluxo de caixa mensal: the same three lines plotted over time.
6. Receipts Analysis e Payments Analysis: a breakdown of each side on its own.

There is also an Automate this tab. That one is not part of the bookkeeping — it is where you can look into having a Sheetgo virtual employee take the data entry off your hands later on.

Como começar a usar o modelo

Click the button below to make your own copy of the free template:

Como usar o modelo de fluxo de caixa

Step 1: Enter your start date and opening balance

Abra o Entradas tab and fill in two settings: the start date of the period you want to look at, and the balance you are starting from. Every figure the file works out counts forward from there.

Step 2: Log the money coming in

O Recebimentos tab is where you record everything the business takes in: customer sales, client payments, loans, interest. Each row holds the client, the invoice number, the invoice amount, how much of it has actually landed and the date it landed, plus a product category you can rename to match your own. The tab arrives with sample rows so you can see the layout — delete or overwrite them and start logging your own entries.

Step 3: Log the money going out

O Pagamentos tab works the same way on the outgoing side: supplier, invoice number, invoice amount, amount paid, date paid and a category such as Travel, Marketing or Office expenses. An invoice you settle in two instalments is simply two rows. Clear the sample data here too, then keep the tab up to date as you pay.

Step 4: Read your cash position

With your entries in, the Cash Flow Analysis tab lays out your cash balance, receivables and payables month by month, with a small sparkline beside each line so you can see the shape at a glance. It moves as soon as you add a row to Receipts or Payments — there is nothing to refresh.

O Gráfico de fluxo de caixa mensal tab plots the same three lines over time, which is the quickest way to spot a month where payments are about to outrun the money coming in. When you want a closer look at one side on its own, Receipts Analysis e Payments Analysis break down each log separately.

Perguntas frequentes