Svenska Dokumentmallar
Liquidity Budget & Cash Flow Forecast 2026/2027 – Swedish + English | Excel, Word & PDF
Liquidity Budget & Cash Flow Forecast 2026/2027 – Swedish + English | Excel, Word & PDF
- File format
- DOCX, PDF, XLSX
- Document language
- Swedish
- Number of files
- 5
Digital download. No physical product is shipped.
Couldn't load pickup availability
About this template
Plan your company's finances before payments fall due. With Mallbutikens cash flow budget, you get an editable 12-month cash flow forecast in Excel with a budget, actual results, stress test, and dashboard. The package also includes templates and separate user guides in Word and PDF in Swedish and English. Tailored for Swedish small businesses, sole traders, limited companies, and associations.
What's included in the package
You get 9 delivery files in a downloadable ZIP, with five logical documents:
| Document | Format | Content |
|---|---|---|
| Cash flow budget & forecast – Swedish | Word (DOCX) + PDF | Planning basis, payment plan, and monthly reconciliation |
| Cash Flow Budget & Rolling Forecast – English | Word (DOCX) + PDF | English reference and working version tailored to Swedish business conditions |
| User guide – Swedish | Word (DOCX) + PDF | Detailed instructions, examples, and common mistakes |
| User Guide – English | Word (DOCX) + PDF | English step-by-step instructions |
| 12-month cash flow tool | Excel (XLSX) | Budget, actual results, stress test, dashboard, and source tab |
Excel features – designed for real cash flow planning
- 12 monthly columns: optional start month and start year, with automatically calculated periods.
- Automatic cash flow chain: the closing balance becomes the next month's opening balance.
- Budget vs. actual: enter planned payments and compare with actual bank transactions.
- Stress test: adjust the assumed decrease in customer payments and increase in supplier payments.
- Cash flow warnings: identify negative cash or a balance below the company's own reserve limit.
- Dashboard: key figures, forecast, stressed cash balance, and monthly trend.
- Separate cash flow items: including customers, suppliers, net salary, employer contributions, VAT, preliminary tax, loans, repayments, and investments.
How to use the cash flow budget
- Enter the company's start month, opening available funds, and own reserve limit in Start_Inputs.
- Fill in expected inflows and outflows in the month when the money actually changes accounts.
- Read the automatically calculated monthly balance in Budget_12m and the dashboard.
- Test delayed/lower customer payments and increased expenses in Stress_Scenario.
- After each month, record the payment results and follow up on deviations in Utfall_Actual.
Important about VAT, tax, and accounting
A cash flow budget shows expected inflows and outflows and differs from a profit and loss budget, which is based on revenue and costs. Budget customer and supplier payments including VAT when it corresponds to the actual payment amount, and budget payments to/from the Swedish Tax Agency on their respective actual dates. Avoid double counting. New loans and repayments affect the bank balance but not the company's sales.
This is a general planning tool, not an accounting product, income tax return, VAT return, or individual financial advice. An accounting consultant or other specialist should be hired for complex taxation, group financing, recurring liquidity shortages, or risk of insolvency.
For which businesses is the product suitable?
Start-up companies, consulting firms, e-commerce, construction and service companies, businesses with seasonal variation, non-profit organizations, and anyone who needs a documented cash flow plan for internal follow-up, bank dialogue, or investment decisions.
Frequently asked questions
Is this the same thing as a profit and loss budget?
No. The profit and loss budget focuses on revenue and costs; the cash flow budget focuses on when money is paid.
Can I choose a different start month?
Yes. Enter the start year and start month, and the Excel model's 12 months will shift.
Do I get both the budget and actual results?
Yes. There are separate sheets for the budget and actual results, as well as a dashboard that compares cash balances.
Does the template have Swedish tax and VAT rates pre-programmed?
No. Tax rates and payment periods vary. You enter the company's own payment amounts and dates.
Can the template replace accounting and annual reporting?
No. It is a planning and follow-up tool, not an accounting system or a formal reporting basis.
Is the English version intended for Swedish law?
Yes. The English is a working translation for use in businesses with Swedish business conditions, not a template for foreign tax legislation.
Format, delivery, and sources
Format: Word (DOCX), PDF, and Excel (XLSX). Language: Swedish + English. Delivery: downloadable ZIP via the store's digital file delivery when the file is linked to the product. Document version 1.0, reviewed 2026-10-07.
Government sources: Verksamt.se – Cash flow budget and Verksamt.se – Make a budget.
Bankruptcy & insolvency – knowledge cluster
A liquidity forecast can show when payments risk not being enough, but it does not legally determine insolvency. Read insolvency and capital shortage in limited companies and the guide on the bankruptcy process. The Bankruptcy document package is sold separately.
