
CajaClara SME Premium is a Microsoft Excel workbook for cash flow forecasting. It answers one practical question: will the business have enough cash, week by week and month by month?
You enter your opening balances, your income and expense items, and the amounts you expect to collect and pay. The workbook projects the closing balance for the next 13 weeks and the next 12 months, compares it with a minimum balance you define, and shows you when cash falls short and by how much.
Two time horizons
- 13-week dashboard for short-term treasury: weekly closing balance, operating receipts and payments, net flow by group (operating, investing, financing), top receipts and payments, and a week selector to inspect any week.
- 12-month plan: receipts and payments that can be indexed to expected inflation, nominal balance versus balance in today’s values, month-end exchange rate, and a month selector.
Three scenarios side by side
Base, Pessimistic and Optimistic scenarios are calculated in parallel over the 13-week horizon. Each scenario applies adjustments you can edit: a percentage change in operating receipts and payments, and extra points of monthly inflation and devaluation. The scenario comparison shows the week-13 balance, the lowest projected balance and the week it occurs, weeks below the minimum, weeks with a negative balance, and the financing required.
Alerts you can read at a glance
A cash traffic light (GREEN / AMBER / RED) and an alerts panel flag negative balances, balances below the minimum, and the financing needed to stay above it. A built-in set of 23 integrity checks validates your inputs (dates, currencies, list values, non-negative amounts, reconciliations) and warns you before an error reaches the dashboards.
Two currencies
Amounts can be entered in ARS or USD, are converted with an exchange rate driven by your monthly devaluation assumptions, and are shown in the reporting currency you choose. Inflation and devaluation assumptions are simple monthly percentages. The model supports the ARS/USD pair only.
What you get
- Clean template (.xlsx): empty fields, ready for your company’s data.
- Demo workbook (.xlsx): the same model preloaded with fictitious sample data, so every dashboard, scenario and alert already works.
- Buyer guide in PDF (4 pages).
Designed to be easy
Only the yellow cells are inputs. It supports up to 25 items and includes a short in-workbook guide plus the PDF buyer guide. All sheets are unlocked and every formula is visible, so you can audit or adapt the logic. The workbook contains no macros or external links and does not require an internet connection.
Compatibility and limitations
Designed for Microsoft Excel 365 on Windows and tested with LibreOffice Calc. Excel for Mac, Excel Online and Google Sheets have not been tested.
The model supports up to 25 items, 13 weeks and 12 months. Weekly amounts are not adjusted for inflation automatically; the monthly plan lets you index selected items. Scenario assumptions are editable estimates, not guaranteed forecasts.
All formulas are visible and editable. Changing them can affect the calculations, so keeping a backup copy is recommended.
Technical support, customization and future updates are not included.
Important notice
CajaClara is a planning tool, not a financial, accounting or tax advisory service. Results depend entirely on the assumptions entered by the user. The demo contains fictitious sample data.
With this comprehensive 5- or 10-year monthly tool, investors can assess the viability of setting up... Read more
The Mobile App Financial Plan Template in Excel allows you to develop financial projections when lau... Read more
The Food Truck Financial Model helps entrepreneurs, founders, business owners, consultants, and anal... Read more
The Green Hydrogen from Wind Financial Model aims to comprehensively forecast a horizon of 40 years ... Read more
Protect your business secrets with ease using our Simple Mutual Non-Disclosure Agreement Template. S... Read more
The Solar Energy Financial Model Spreadsheet Template in Excel assists you in preparing a sophistica... Read more
Starting a restaurant without a financial plan is like driving a car blindfolded. You wouldn´t do i... Read more
You must log in to submit a review.