This free finance spreadsheet for freelancers puts the whole money system in one file: income, expenses, tax savings, a salary plan, an emergency fund calculator and a multi-currency budget. It works in Excel, LibreOffice and Google Sheets, and you can adapt it to your country.
Download: freelance-finance-spreadsheet.xlsx. The spreadsheet is a planning tool, not tax or accounting software. Check your own tax rules and ask your gestor to confirm your numbers.
All percentages and amounts in the spreadsheet are editable examples, not tax advice. The file contains no macros and no personal data. Back up your copy and keep your own records.
Key takeaways: finance spreadsheet
- The finance spreadsheet tracks income, expenses and monthly profit in one place.
- It calculates your tax set-aside, a salary and the buffer, based on settings you control.
- It includes an emergency fund calculator and a multi-currency budget.
- It uses formulas, so you only fill in the white cells.
- Review it monthly and update the settings every quarter.
In this guide
- Key takeaways: finance spreadsheet
- What is inside the finance spreadsheet
- How to use the finance spreadsheet step by step
- The multi-currency tab in the finance spreadsheet
- Adapting the finance spreadsheet to your country
- Monthly routine with the finance spreadsheet
- Limits of this finance spreadsheet
- Common mistakes to avoid
- Frequently asked questions about finance spreadsheet
- Final thoughts on finance spreadsheet
- Sources and further reading
- Related guides
What is inside the finance spreadsheet
| Sheet | What it does |
|---|---|
| Settings | Home currency, tax set-aside percentage, monthly social security, emergency fund months and salary target |
| Income | Log each payment with date, client, currency, amount and euro value; the tax share is calculated |
| Expenses | Log business costs with categories chosen from a list |
| Monthly summary | Income, expenses, tax set-aside and profit for every month |
| Emergency fund | Calculates your target from essential expenses and the number of months |
| Pay yourself | Shows the salary you can afford and the buffer balance |
| Multi-currency budget | Plans income in another currency at a conservative rate |
How to use the finance spreadsheet step by step
- Download it and save a copy. In Google Sheets, upload it and open as a Sheet.
- Fill in Settings: your home currency, a tax percentage, monthly social security and your target months of emergency fund. See how much to set aside for taxes.
- Add each payment in Income, with the euro value received.
- Add business expenses in Expenses.
- Open the monthly summary to see profit and tax savings.
- Use Pay yourself to set a salary. The method is explained in how to pay yourself a salary.
- Check the emergency fund tab. Read how many months you need.
The multi-currency tab in the finance spreadsheet
If you earn in dollars or pounds, enter the expected income, a conservative exchange rate and the planned conversion date. The sheet shows the euro value and the effect of a change in the rate. Learn how to choose the rate in how to build a multi-currency budget and how to reduce exchange rate risk.
Adapting the finance spreadsheet to your country
- Change the home currency and the tax percentage in Settings.
- Rename expense categories to match your tax return.
- Add columns for VAT if you charge it.
- For Spanish freelancers, check the figures against how much tax freelancers pay in Spain.
Monthly routine with the finance spreadsheet
- Record every payment and expense within a week.
- Check that the tax set-aside is in your tax account. See how to separate personal and business accounts.
- Transfer your salary.
- Compare the buffer with your target.
- Save a dated copy at the end of each quarter.
Limits of this finance spreadsheet
It is not accounting software, it does not file taxes and it does not validate invoices. For invoicing, see invoicing software for freelancers. The big picture is in how to manage irregular income.
Common mistakes to avoid
- Not recording small payments and expenses.
- Using the example percentages without checking them.
- Overwriting formulas in the grey cells.
- Not saving a backup copy.
- Treating the spreadsheet as tax advice.
- Forgetting to update the settings every quarter.
Frequently asked questions about finance spreadsheet
Is the finance spreadsheet really free?
Yes. You can download, copy and adapt it for your own use.
Does it work in Google Sheets?
Yes. Upload the file to Google Drive and open it with Google Sheets, or use Excel or LibreOffice.
Can it file my taxes?
No. It helps you plan and track. Filing and checking returns is up to you or your gestor.
Does it work outside Spain?
Yes. Change the home currency, tax percentage and categories in Settings.
Does it include a multi-currency budget?
Yes, there is a sheet for planning income in another currency at a conservative rate.
How often should I update it?
Weekly for entries and monthly for the summary.
Final thoughts on finance spreadsheet
A good finance spreadsheet makes the system visible: what comes in, what goes to taxes, what you pay yourself and what is left in the buffer. Download the file, set your percentages, record every payment and review it monthly. After three months of use, your finances will feel far more predictable.
Sources and further reading
- Agencia Tributaria (Spanish tax agency)
- Banco de España: finanzas para todos
- Seguridad Social: régimen de autónomos
Related guides
- Irregular Income: How Freelancers Manage Their Finances Without Stress
- Pay Yourself a Salary as a Freelancer with Variable Income
- Emergency Fund for Freelancers: How Many Months Do You Need?
- Multi-Currency Budget for Freelancers: Plan Spending in Two Currencies
Disclaimer: This article is for general information only and is not tax, legal or financial advice. Rules, fees and thresholds change often and differ by country; always confirm current details with the tax authority and a qualified adviser. Some links may be affiliate links, which means we may earn a commission at no extra cost to you.