How to Build a 13-Week Cash Flow Forecast for SMBs

How to Build a 13-Week Cash Flow Forecast for Your SMB

A 13-week rolling cash flow forecast is the single most important financial tool for Brazilian SMBs in the R$2M-R$20M range. It gives you a quarter of forward visibility into every real coming in and going out of your business, updated weekly so you are never surprised by a cash shortfall. If you build nothing else this year, build this.

Most Brazilian small businesses check their bank balance daily and hope for the best. That approach works until it does not — and when it fails, it fails fast. A supplier demands early payment, a large client delays 30 days, payroll hits the same week as tax obligations, and suddenly you are scrambling for an expensive working capital line at the bank.

This guide walks you through building a forecast from scratch, choosing the right methodology, establishing a weekly review cadence, and avoiding the pitfalls that derail most first attempts.

Why 13 Weeks? Why Not 12 Months?

Thirteen weeks is a quarterly horizon — long enough to spot problems before they become emergencies, short enough that your projections remain accurate. A 12-month forecast is useful for strategic planning, but it is too imprecise for operational cash management. At the 13-week level, you know which specific week you might run short, giving you time to act.

For Brazilian SMBs, this timeframe is especially valuable because:

• Tax obligations cluster: DARF, DAS (Simples Nacional), FGTS, INSS, and ICMS/ISS all have specific monthly due dates. A 13-week view lets you see when multiple obligations stack up.
• Receivables are unpredictable: Brazilian B2B payment terms commonly range from 30 to 90 days. Boleto payments often arrive late. You need granular weekly visibility.
• Seasonal patterns emerge: Most businesses have intra-quarter patterns that a monthly view obscures.

Direct Method vs. Indirect Method

There are two approaches to cash flow forecasting. For SMBs, the choice matters.

Direct Method (Recommended for SMBs)

The direct method tracks actual cash movements: money coming in and money going out. You list every expected receipt and every expected payment by week.

Week	Beginning Balance	Cash In	Cash Out	Net Flow	Ending Balance
W1	R$250,000	R$180,000	R$165,000	+R$15,000	R$265,000
W2	R$265,000	R$95,000	R$210,000	-R$115,000	R$150,000
W3	R$150,000	R$220,000	R$140,000	+R$80,000	R$230,000

Why it works for SMBs: It maps directly to what you see in your bank account. No accounting adjustments, no accrual conversions. Your operations team can contribute to it because it speaks their language — invoices, payroll, rent, supplier payments. Learn more about our operational excellence services.

Indirect Method

The indirect method starts with net income from your P&L and adjusts for non-cash items (depreciation, accruals, changes in working capital). It is the standard for financial reporting under IFRS/CPC and what your accountant uses for the DFC (Demonstracao dos Fluxos de Caixa).

Why it is less useful for SMB operations: It requires accurate accrual accounting, which many SMBs in the R$2M-R$20M range do not maintain in real time. It also obscures the timing of specific payments, which is precisely what you need to manage.

Our recommendation: Use the direct method for your 13-week operational forecast. Use the indirect method for annual planning and investor presentations.

Building Your Forecast: Step-by-Step

Step 1: Gather Your Data Sources

Before you open a spreadsheet, identify where your cash flow data lives:

• Accounts receivable aging report: From your ERP (Omie, Bling, Tiny, ContaAzul) or accounting system. This shows you invoices outstanding and their expected payment dates.
• Accounts payable schedule: Supplier invoices, recurring contracts, and purchase orders with payment terms.
• Payroll register: Fixed monthly cost, but confirm dates — CLT payroll typically hits on the 5th business day, but some companies pay on the last business day of the month.
• Tax calendar: Map out DARF, DAS, FGTS (by the 7th), INSS, ICMS, ISS, PIS/COFINS due dates. Your contador can provide this.
• Bank statements: Last 13 weeks of actual data to establish your baseline and identify patterns.

Step 2: Build the Spreadsheet Structure

Your spreadsheet needs these sections:

Cash Inflows:

1. Client receipts (by client or client category for your top 10-20 clients)
2. Other income (interest, rental income, tax refunds)
3. New sales expected to convert to cash within the window

Cash Outflows:

1. Payroll and benefits (salaries, FGTS, INSS, vale-transporte, vale-refeicao)
2. Suppliers and COGS
3. Rent and utilities
4. Tax obligations (itemized by type and due date)
5. Loan repayments
6. Capital expenditures
7. Other operating expenses

Summary:

• Beginning cash balance
• Total inflows
• Total outflows
• Net cash flow
• Ending cash balance
• Minimum cash threshold (your safety buffer — typically 2-4 weeks of operating expenses)

Step 3: Populate the First 4 Weeks with High Confidence Data

Weeks 1 through 4 should be highly accurate. You know which invoices are outstanding, which payables are due, and what your fixed costs are. Aim for 90%+ accuracy in this window.

For client receipts, do not assume invoices will be paid on time. Use your historical collection data. If clients in a certain segment typically pay 7 days late, build that into your forecast.

Step 4: Estimate Weeks 5-13 with Reasonable Assumptions

Beyond the first month, use category-level estimates based on:

• Historical averages: What did inflows and outflows look like in the same period last year?
• Pipeline data: For service businesses, what proposals are outstanding and what is your historical win rate?
• Seasonal adjustments: December is slow for many B2B businesses. January has high tax obligations. Carnival week disrupts February.
• Known commitments: A signed contract starting in week 8, an annual insurance payment in week 10.

Step 5: Establish the Weekly Review Cadence

This is where most forecasts fail — not in the building, but in the maintaining. Here is the cadence that works:

Monday morning (30-45 minutes):

1. Update actual results for the previous week
2. Compare forecast vs. actual — identify variances greater than 10%
3. Roll the forecast forward: remove the completed week, add a new week 13
4. Update weeks 1-4 with any new information
5. Flag any week where ending balance drops below your minimum threshold

Monthly (60-90 minutes):

1. Review forecast accuracy trends — are you consistently over- or under-estimating?
2. Adjust assumptions for recurring items
3. Compare your rolling forecast to your annual budget

The Accuracy Spectrum: What to Expect

Do not expect perfection. Here are realistic accuracy targets by time horizon:

Horizon	Target Accuracy	Acceptable Variance
Week 1	95%+	+/- 5%
Weeks 2-4	85-90%	+/- 10-15%
Weeks 5-8	75-85%	+/- 15-25%
Weeks 9-13	65-75%	+/- 25-35%

If your Week 1 accuracy is consistently below 90%, you have a data quality problem that needs addressing before you worry about weeks 5-13.

Common Pitfalls and How to Avoid Them

Pitfall 1: Confusing Revenue with Cash

You booked R$500,000 in sales this month. That does not mean R$500,000 will hit your bank account this month. If your terms are 30/60/90 days, that cash arrives in April, May, and June. The forecast must track cash, not revenue.

Pitfall 2: Forgetting Seasonal Tax Obligations

Beyond monthly obligations, Brazilian companies face periodic spikes: 13th salary (two installments — November and December), annual vacation provisions (varies by employee), IRPJ/CSLL quarterly estimates (Lucro Presumido), and annual RAIS/DIRF filing-related costs.

Pitfall 3: Ignoring the Safety Buffer

Your minimum cash threshold should be 2-4 weeks of operating expenses. If your weekly burn is R$150,000, keep at least R$300,000-R$600,000 as a floor. When the forecast shows you approaching this floor, act immediately — do not wait.

Pitfall 4: Building It and Forgetting It

A forecast that is not updated weekly is worse than no forecast at all, because it creates false confidence. If you cannot commit to the Monday morning cadence, assign it to someone who can.

Pitfall 5: Over-Complicating the Model

Your first forecast should be a simple spreadsheet with 20-30 line items. Do not build a 200-row model with formulas that nobody understands. Start simple, add complexity only when you have proven the basic discipline.

Tools and Technology

For SMBs in the R$2M-R$20M range, here is what we recommend:

Starting Point: Google Sheets / Excel

A well-structured spreadsheet is sufficient for most companies. Benefits: flexible, shareable, no software cost, easy to customize.

Level 2: ERP Integration

If you use Omie, Bling, or ContaAzul, export your AR aging and AP schedule weekly to feed your forecast. Some ERPs have basic cash flow projection features built in, but they rarely provide the 13-week granular view you need.

Level 3: Dedicated Cash Flow Tools

Tools like Treasy, Granatum, or Nibo offer cash flow forecasting features designed for the Brazilian market, with bank integrations and automatic categorization. Worth considering once your business exceeds R$10M in revenue.

A Framework for Action

When your forecast identifies a cash shortfall in a future week, you have a decision framework:

1. Accelerate inflows: Offer early payment discounts (2-3% for 15-day payment vs. 30-day terms). Contact overdue clients. Invoice faster.
2. Delay outflows: Negotiate extended terms with suppliers (carefully — this affects relationships). Defer non-essential purchases.
3. Access credit lines: If you maintain a good relationship with your bank, pre-approved lines (capital de giro) can bridge short-term gaps. But this is expensive — Selic + spread often means 1.5-3% per month.
4. Adjust operations: If the shortfall is structural rather than timing-related, you need to address the underlying profitability issue.

What a Good Forecast Looks Like in Practice

A company doing R$8M annually with consistent cash management typically sees:

• Week 1 accuracy: 95%+
• Cash shortfall warnings: 4-6 weeks in advance, giving time to act
• Financing costs reduced: 15-30% lower because emergency borrowing is eliminated
• Supplier negotiations: Improved because you pay on time, every time
• Growth decisions: Made with confidence because you can see the cash impact

Moving Beyond the 13-Week Forecast

Once you have mastered the 13-week forecast, the natural next steps are:

1. Scenario planning: Build optimistic, base, and pessimistic versions to stress-test your cash position
2. Integration with your P&L and balance sheet: Create a three-statement model for strategic planning
3. KPI dashboard: Track key financial indicators alongside your cash forecast for a complete picture

---

Your cash flow does not have to be a source of anxiety. A disciplined 13-week forecast transforms cash management from reactive firefighting into proactive planning. Most of our clients at Arizen implement this within 2-3 weeks and wonder how they operated without it.

Ready to get your finances under control? Take our free assessment to see where your business stands — it takes 5 minutes and gives you a personalized benchmark against similar Brazilian SMBs.