Description

Personal Finance Excel Spreadsheet Template

Easy-to-use Account Group
This worksheet follows best practices for controlling your finances. You start by registering the various types of financial transactions, composing your Group of Accounts. You can also register your banks.

Transfers
Control the transfers you make between your banks very easily with this new version 4.0 tab.

Daily Movements
Make your launches every day, recording the main information of the financial movement, including the form of payment. You can also register different dates for posting and payment, so you can control accounts you would have to pay or receive.

Spending Control
Control all your spending on a view that separates the total spending per month, divided by banks, so you can better analyze how your spending is month by month.

Cash Flow Report by Bank
View a Cash Flow report by bank and track how the moves happen in each of your accounts. This vision will help you better understand your consolidated numbers and helps you make decisions for the coming months of the year.

Long Term Objectives
Trace and track your long-term goals. Going on a trip and want to control your finances so you can raise money? Or buy a car, and wonder how much you need to join month after month? This tab helps you chart those goals and understand how you can accomplish them.

Manage Your Investments
New to this version 4.0, you can now check how much you have in each investment made. Spreadsheet consolidates the information of the launches and shows you, month by month, how your long-term investments are going, in addition to issuing alerts if you do not make your investments.

Cash Flow Report
Check how your Cash Flow walks and understand better how your moves happen and affect your personal finances. Cash Flow still comes with several indicators that help you think in the long term, such as Cash Need.

Goal Control
Another novelty of this release is that it is now possible to set revenue and expenditure targets and track whether you are achieving them or not. You can also change them at any time as the year goes by. You can also compare your goals with the actual result, to have better references for the future.

Financial results
Get an overview of your results, both annually and monthly. Keep track of your movements day by day and understand what were your main expenses each month.

Bills to pay and receive
The spreadsheet comes with automatic reports that tell you the outstanding amounts, both for you and for you to pay. So you do not run the risk of being defaulted and can also manage your expenses for the future, based on what you still need to receive. In addition, the spreadsheet shows you how much of the open expense or revenue.

Print Reports
You can print all reports from the spreadsheet, either to show to another person or to yourself to keep track to analyze calmly, away from the computer, as your financial transactions are occurring.

Monthly Analysis Dashboard
With this Indicator Panel, you will be able to quickly and easily visualize your main indicators within the month. In addition, the spreadsheet points out some essential information for you to keep an eye on as your primary expense, for example.

Annual Review Dashboard
Also follow a view of the annual results of your finances, graphically showing the main months of the highest movements.

Account Analysis Dashboard
It is also possible, in this version of the Worksheet, to analyze your account in your Chart of Accounts. Understand how much an account represents from your total income and expenses and how it behaves throughout the year, all demonstrated through charts.

Revenue and Expense Dashboard
Generate automatic charts to better understand how your top income and expenses behave. Understand how each sub-account is responsible for the total of each account, both Revenue, and expenses. So you can understand your money allocation, month by month.

Where does your money go?
With this new dashboard version 4.0, you'll find out! This panel shows you very easily and practically, month by month, where your money is going. So you can find out in a few clicks what is driving you to spend more.

Personal Finance Excel Spreadsheet Template
average rating 4.6 out of 5
Based on 29 reviews
  • 5 Stars
    17 Reviews
  • 4 Stars
    11 Reviews
  • 3 Stars
    1 Review
  • 2 Stars
    0 Reviews
  • 1 Star
    0 Reviews
97% of reviewers would recommend this product to a friend
29 Reviews
Reviewed by Luis Felipe T.
Verified Buyer
I recommend this product
Como você usou a planilha adquirida?
Fiz uso pessoal
Qual o seu nível de conhecimento de Excel?
Intermediário
O que você usava antes da planilha?
Uma planilha própria
Age Range
25 - 34
O que lhe agradou mais no produto?
  • Desenvolvido por Especialistas
Rated 5 out of 5
Review posted

otima planilha

gostei muito da planilha, esta me ajudando muito na organização pessoal

Loading...
Quanto tempo você ganhou com essa planilha?
Rated 5 out of 5
Was this helpful?
Reviewed by Manuel Fernandes Baptista F.
Verified Buyer
I recommend this product
Como você usou a planilha adquirida?
Fiz uso pessoal
Qual o seu nível de conhecimento de Excel?
Intermediário
O que você usava antes da planilha?
Uma planilha própria
Age Range
35 - 44
O que lhe agradou mais no produto?
  • Facilidade de Preenchimento
  • Visualmente Bonito
  • Conteúdo de Apoio
  • Vídeos com Instruções
  • Aplicação Imediata
Rated 4 out of 5
Review posted

Muito Completa

Seria ótimo se tivesse uma parte específica para termos um melhor controle com cartão de crédito e de investimentos. Mas recomendo demais!!!

Loading...
Quanto tempo você ganhou com essa planilha?
Rated 5 out of 5
Was this helpful?
Reviewed by Marcelo L.
Verified Buyer
I recommend this product
Como você usou a planilha adquirida?
Fiz uso pessoal
Qual o seu nível de conhecimento de Excel?
Intermediário
O que você usava antes da planilha?
Uma planilha própria
Age Range
55 - 64
O que lhe agradou mais no produto?
  • Visualmente Bonito
  • Desenvolvido por Especialistas
  • Facilidade de Preenchimento
  • Conteúdo de Apoio
  • Aplicação Imediata
Rated 5 out of 5
Review posted

Excelente!

A planilha atende a tudo que preciso, é fácil de entender, e vai muito além do que preciso. Parabéns!

Loading...
Quanto tempo você ganhou com essa planilha?
Rated 5 out of 5
Was this helpful?
Reviewed by Excelente
Verified Buyer
I recommend this product
Rated 5 out of 5
Review posted

5 Stars

Parabêns aos desenvolvedores.

Loading...
Was this helpful?
Reviewed by LUIS V., from Brazil
Verified Buyer
I recommend this product
Rated 4 out of 5
Review posted

4 Stars

Planilha de Orçamento Pessoal e Familiar em Excel 4.0

Loading...
Was this helpful?
Download Free Trial Version

Product Specs:

  • License to 3 Computers
  • 100% Editable File
  • Immediate Access
  • Works on MAC and PC
  • All Excel Versions
  • Premium Support
  • Over 30.000 satisfied customers