Register on WhatsApp
← Back to blog
Bookkeeping BasicsShorab.C·14/08/2026

How to Create a Cash Flow Forecast for Your Small Business

Discover how to create a 13-week rolling cash flow forecast for your Mauritian small business. Learn the difference between profit and cash flow, avoid MRA tax traps, and automate reporting with QuickBooks.

How to Create a Cash Flow Forecast for Your Small Business — Bookkeeping Basics guide for Mauritian businesses from Quick Focus

Running a profitable business in Mauritius does not guarantee that you will have enough cash in the bank to pay your bills when they are due. Many business owners discover too late that an impressive profit and loss statement cannot pay supplier bills, monthly salaries, or MRA tax obligations if customer payments are delayed. Developing a reliable cash flow forecast small business strategy bridges the gap between accounting profits and bank account reality. By projecting actual cash inflows and outflows over time, you gain complete visibility over upcoming cash shortfalls, make smarter purchasing decisions, and protect your company against sudden liquidity crises. Here is a practical, step-by-step guide to mastering cash flow forecasting for your Mauritian enterprise.

Why Profit Does Not Equal Cash Flow in a Mauritian Small Business

In business accounting, profit and cash flow represent two completely different measures of financial health. Profit is an accounting calculation—the revenue you earn minus the expenses you incur during a given period, regardless of whether any money has actually changed hands. Cash flow, on the other hand, measures the physical movement of money into and out of your corporate bank accounts. A company can appear highly profitable on an income statement while simultaneously facing bankruptcy due to an empty bank account.

This distinction is especially critical for small and medium-sized enterprises in Mauritius operating under accrual accounting rules. When you issue an invoice to a corporate client for Rs 200,000 with 60-day payment terms, your accounting records immediately reflect Rs 200,000 in revenue. On paper, your business looks profitable. However, until that customer actually transfers the funds into your bank account two months later, your available cash remains zero. Meanwhile, your operational expenses—payroll, rent, utilities, and vendor bills—must be paid on strict schedules, regardless of whether your clients have settled their accounts.

Furthermore, statutory obligations in Mauritius create significant periodic cash drains that do not directly align with monthly profit calculations:

  • •**Value Added Tax (VAT):** If your annual taxable turnover exceeds Rs 3 million, compulsory VAT registration applies (a threshold reduced from the previous Rs 6 million mark by the Mauritius Revenue Authority). Collecting 15% VAT on sales increases your gross cash inflow temporarily, but that money belongs to the MRA. When VAT submission deadlines arrive, paying that accumulated tax requires immediate cash outlay.
  • •**Corporate Tax & APS Instalments:** Corporate income tax is levied at a flat rate of 15%, plus a 2% Corporate Social Responsibility (CSR) levy where applicable. Through the Advance Payment System (APS), the MRA requires quarterly tax payments throughout the financial year. These scheduled disbursements impact your bank balance long before your final annual financial statements are audited.
  • •**End-of-Year Bonus Payments:** In Mauritius, the 13th-month bonus is a statutory legal entitlement. Employers typically pay a substantial portion of this bonus a few working days before December 25th, with the remainder reconciled after final annual earnings are confirmed. This creates a severe liquidity bottleneck in December if funds are not systematically reserved throughout the year.
  • •**Payroll Contributions:** Monthly salary disbursements require paying employee contributions alongside employer obligations for Contribution Sociale Généralisée (CSG) and the National Savings Fund (NSF), which follow tiered structures around the MUR 50,000 monthly threshold.

Profit vs. Cash Flow: A Quick Comparison

To understand how these concepts contrast in day-to-day operations, review the key distinctions below:

  • •**Definition:** Profit measures total financial gain over a period (Revenue minus Expenses). Cash flow measures liquid money moving through your bank accounts (Cash In minus Cash Out).
  • •**Timing:** Profit recognizes revenue when invoiced and expenses when incurred. Cash flow recognizes revenue when payment is cleared and expenses when cash leaves the account.
  • •**Tax Liability Impact:** Taxable profit determines your annual corporate tax assessment. Cash flow determines whether you have the physical money to pay your APS quarterly instalments and VAT filings on time.
  • •**Business Survival:** A business can survive temporarily with zero profit if it has cash reserves or credit. A business cannot survive without cash, regardless of how profitable its book orders appear.

Understanding this dynamic makes it clear that tracking accounting profit is not enough. To maintain operational stability, every business owner must implement a dedicated cash flow forecast.

Key Components of an Accurate Cash Flow Forecast

A robust cash flow forecast relies on complete accuracy regarding when money enters and leaves your bank accounts. Guessing dates or overestimating collection speeds will produce a misleading projection that leaves your business vulnerable to unexpected cash deficits. To construct an effective model, you must categorize and track three fundamental streams: cash inflows, operational cash outflows, and scheduled statutory or financing obligations.

1. Projecting Cash Inflows (Cash Receipts)

Cash inflows include all cash payments received by your business during a specific timeframe. It is vital to base these projections on realistic payment timelines rather than contract dates or invoice due dates.

  • •**Customer Invoice Settlements:** Track outstanding receivables based on your clients' actual historical payment behavior. If a key customer regularly pays on 45 days despite 30-day terms, schedule their payment in week 6 rather than week 4.
  • •**Direct Cash Sales & Point-of-Sale Receipts:** For retail, hospitality, or direct service businesses, estimate immediate cash sales based on historical seasonal trends, discounting for off-peak periods.
  • •**Tax Refunds & Grant Receipts:** Include confirmed inflows such as HRDC training grant reimbursements or MRA tax refunds only when approval notices and disbursement dates are officially confirmed.

2. Projecting Operational Cash Outflows (Disbursements)

Operational outflows cover the ongoing costs required to keep your business running. Categorize these into fixed predictable payments and variable operational expenses:

  • •**Payroll & Social Security:** Net salaries paid to staff, along with monthly employer CSG and NSF contributions payable to the MRA.
  • •**Supplier & Subcontractor Payments:** Payments owed for raw materials, inventory purchases, and third-party vendor services.
  • •**Overheads & Rent:** Fixed recurring obligations including office or commercial lease payments, utilities, telecommunications, insurance premiums, and software subscriptions.

3. Projecting Statutory, Tax, and Capital Outflows

Many cash flow crises occur because business owners forget major non-monthly disbursements that occur periodically throughout the fiscal year:

  • •**MRA VAT Submissions:** The standard 15% VAT collected from customers must be remitted quarterly or monthly depending on your filing category. Never treat collected VAT as operational income.
  • •**Advance Payment System (APS) & Corporate Tax:** Reserve funds for quarterly APS income tax instalments and annual tax balance settlements.
  • •**13th Month End-of-Year Bonus:** Accumulate reserves monthly for the statutory end-of-year bonus paid before December 25th to prevent a massive cash deficit in December.
  • •**Debt Service & Capital Expenditures:** Monthly loan principal repayments, asset lease payments, and scheduled equipment replacements.

Step-by-Step Guide to Building a 13-Week Rolling Cash Flow Forecast

A 13-week rolling cash flow forecast is widely regarded by financial experts as the gold standard for operational cash management. Covering one full quarter (13 weeks), this timeframe is long enough to anticipate upcoming liquidity bottlenecks and short enough to maintain high accuracy in your projections. As each week concludes, you drop the past week and add a new 13th week, ensuring you always maintain a clear 90-day forward vision.

Here is the step-by-step process to build and maintain a 13-week rolling forecast for your business:

Step 1: Establish Your Opening Cash Balance

Begin Week 1 by taking your actual cleared cash balance across all corporate bank accounts, petty cash funds, and short-term liquid reserves. Do not include uncollected credit lines or uncleared cheques that have not yet deposited.

Step 2: Map Projected Inflows Week by Week

Examine your current accounts receivable aging report. Place each outstanding invoice into the specific week you realistically expect the customer's payment to clear in your bank. Add anticipated direct cash sales for each week based on historical revenue patterns, adjusting for seasonal factors like public holidays or tourism slow seasons in Mauritius.

Step 3: Schedule Projected Outflows Week by Week

Review your accounts payable, upcoming vendor invoices, monthly recurring expenses, and fixed overhead schedules. Allocate every cash disbursement to the exact week it must be paid:

  • •Assign weekly payroll disbursements and monthly CSG/NSF payments to their precise payment weeks.
  • •Position quarterly MRA VAT payments and APS tax instalments into their corresponding payment weeks.
  • •Include loan principal and interest repayments on their scheduled due dates.

Step 4: Calculate Net Cash Flow and Closing Balance

For each week in the 13-week model, apply the core cash flow formula:

  1. **Net Cash Flow** = Total Expected Inflows - Total Expected Outflows
  2. **Closing Cash Balance** = Opening Cash Balance + Net Cash Flow

The closing cash balance of Week 1 automatically becomes the opening cash balance for Week 2. Repeat this calculation across all 13 weeks. If any future week displays a negative closing balance, you have identified a cash deficit weeks before it occurs, giving you time to arrange credit lines, delay non-essential purchases, or push for early customer collections.

Step 5: Roll the Forecast Forward Weekly

At the end of each week, compare your forecasted numbers against actual bank activity to refine your future assumptions. Remove the completed week, update Week 1 with your new actual starting bank balance, and add Week 13 at the end of the horizon. This rolling discipline keeps your financial management active and responsive.

Why Manual Spreadsheets Fail and How QuickBooks Automates Forecasting

Many Mauritian business owners attempt to manage their cash flow projections using static Excel spreadsheets. While a spreadsheet is better than no forecast at all, manual spreadsheets quickly become outdated, prone to formula errors, and disconnected from daily financial activity. Updating spreadsheets manually requires hours of tedious data entry, leading many busy owners to abandon the exercise altogether.

Modern accounting software like QuickBooks fundamentally transforms cash flow management by replacing manual guesswork with real-time automated data. When your daily invoicing, vendor bills, and bank feeds are managed inside accounting software, generating accurate cash flow insights takes minutes rather than hours.

Real-Time Accounts Receivable and Payable Visibility

Instead of manually typing customer balances into a spreadsheet, QuickBooks automatically tracks overdue accounts, upcoming invoice due dates, and payment histories. You can instantly view your exact Accounts Receivable aging schedule to identify which clients consistently pay on time and which require follow-up. Similarly, QuickBooks tracks your Accounts Payable, showing exactly when vendor bills are due so you can time payments strategically to preserve bank reserves.

Automated Bank Feeds and Instant Reconciliation

With automated bank reconciliation features, QuickBooks matches incoming customer payments and outgoing supplier disbursements directly against your bank transactions. This ensures your baseline opening cash figure is always accurate to the minute, removing the risk of double-counting uncleared transactions or missing unexpected bank fees.

Seamless Software Selection for Mauritian Businesses

Whether your company requires the flexibility of cloud accounting or the robust desktop infrastructure needed for complex inventory management, choosing the right accounting engine is essential. Small businesses seeking mobile access, automated bank feeds, and cloud convenience can implement [QuickBooks Online](/products/quickbooks-online) to access real-time financial dashboards from any device. On the other hand, enterprises with specialized reporting needs or offline operational requirements can [compare QuickBooks Desktop editions](/products/quickbooks-desktop-comparison) to find the ideal desktop solution tailored to their workflow.

Common Cash Flow Mistakes Mauritian Businesses Make (and How to Avoid Them)

Even well-managed Mauritian small businesses can fall into dangerous liquidity traps if they rely on flawed assumptions. Being aware of these common cash flow mistakes allows you to build preventive measures directly into your financial routines.

1. Treating Collected VAT as Operating Cash

One of the most frequent financial errors made by newly registered VAT businesses in Mauritius is treating total bank deposits as available working capital. Remember that the 15% VAT added to your taxable invoices is collected on behalf of the MRA. If you spend that money on operating costs or inventory, you will face an urgent cash crunch when your VAT return is due. Always segregate estimated VAT liabilities into a separate sub-account or factor them into your forecast as earmarked funds.

2. Overestimating Customer Payment Speeds

Assuming every client will honor 30-day payment terms is a fast track to cash deficits. In practice, corporate payment processing delays, administrative approvals, and regional economic slowdowns often push actual collection dates to 45 or 60 days. Always apply realistic payment lag assumptions in your 13-week forecast based on actual customer history.

3. Ignoring Non-Monthly and Seasonal Financial Commitments

Failing to plan for periodic cash disbursements can dismantle an otherwise sound financial plan. Quarterly APS income tax payments, annual trade license fees, vehicle insurance renewals, and the statutory December 13th-month bonus represent significant outlays. Build monthly reserve allocations into your forecast so that periodic payments are fully funded well before their due dates.

4. Expanding Operations Without Working Capital Reserves

Winning a large new commercial contract or opening a second outlet is exciting, but growth consumes cash. Fulfilling a larger contract requires buying inventory, paying additional labor, and funding operational overhead upfront—months before the customer pays the final invoice. Without adequate working capital forecasting, rapid sales expansion can paradoxically push a business into insolvency.

Upskilling Your Team: Building Practical Forecasting Expertise

Software is only as effective as the people who operate it. To maintain reliable cash flow forecasts, your internal bookkeeping and finance team must understand how to configure reports, reconcile accounts accurately, and interpret financial indicators correctly inside QuickBooks. Investing in practical, hands-on training ensures that your staff can transform raw transaction data into actionable cash flow intelligence.

QuickFocus Ltd has been supporting Mauritian businesses as an established QuickBooks specialist and MQA-approved training provider since 2004, serving over 2,000 companies across the island. Through interactive, practical training modules, your staff learn step-by-step how to manage cash flow reporting, automate invoicing, and streamline tax compliance.

MQA-Approved Courses Eligible for HRDC Refunds

Mauritian employers can significantly reduce training expenses by leveraging the Human Resource Development Council (HRDC) Training Levy Grant System. QuickFocus offers specialized, hands-on training programs designed for immediate business application:

  • •**QuickBooks Online Masterclass:** A 4-hour comprehensive cloud masterclass designed for small-business owners and accounting staff seeking to master cloud bookkeeping, real-time invoicing, and cash flow tracking.
  • •**QuickBooks Desktop Masterclass:** A 6-hour practical training session covering Pro, Premier, and Accountant editions, focusing on advanced inventory, reporting, and financial controls.
  • •**QuickBooks Essentials:** A focused 5-hour refresher course for existing users wanting to optimize their daily accounting workflows.

Both the Online and Desktop Masterclass courses are priced at Rs 12,000 gross per participant. Eligible companies can claim up to a 75% HRDC grant refund (Rs 9,000), reducing the net cost to just Rs 3,000 per participant. Courses feature small class sizes, practical hands-on exercises, official Certificates of Attendance, and ongoing post-training support via WhatsApp.

To explore course schedules and maximize your training grant benefits, review [our training courses](/training) or check detailed [training pricing and HRDC refund details](/training/pricing-and-hrdc) to upskill your team cost-effectively. For complex payroll structure adjustments or specialized tax advisory support, QuickFocus also works seamlessly alongside trusted professional partners specializing in corporate tax, payroll management, and financial consultancy.

Transforming Cash Flow Insights Into Strategic Growth

A well-maintained 13-week cash flow forecast is far more than an emergency risk-management tool—it is a powerful strategic instrument that empowers business owners to make confident, proactive decisions. When you have full visibility over your liquid capital 90 days into the future, you can transition from reactive fire-fighting to deliberate strategic planning.

Strategic Advantages of Clear Cash Flow Forecasting

  • •**Confident Capital Expenditure:** Know exactly when your cash reserves can absorb new equipment purchases, technology upgrades, or office renovations without risking operational liquidity.
  • •**Stronger Negotiating Power with Vendors:** By accurately forecasting your payables, you can negotiate early-payment discounts with key suppliers or request extended credit terms before seasonal tight periods arrive.
  • •**Proactive Credit and Financing Management:** If your 13-week forecast reveals a temporary cash deficit six weeks away, you can approach your bank for short-term working capital or line-of-credit adjustments in advance, securing favorable terms rather than seeking emergency funding.
  • •**Optimized Tax Planning:** Anticipating upcoming MRA tax liabilities—such as quarterly APS instalments and VAT settlements—ensures that tax payments are made smoothly on time, avoiding late penalties and preserving credit ratings.

By combining disciplined financial practices, robust software tools like QuickBooks, and practical team training, Mauritian small business owners can build a resilient, cash-healthy enterprise capable of navigating any economic environment.

#Cash Flow#Forecasting#Small Business

Need help applying this to your business?

Talk to a QuickBooks specialist at Quick Focus Mauritius.