Cash management · 16 min read · Updated:

Cash flow management: a 13-week plan to stay profitable without running out of cash

An empty bank account while sales are rising isn't a paradox, it's a timing problem. This article shows how businesses in Türkiye can manage that timing with a 13-week table.

In short

Atlas Kahve Kavurma closed August as the best month in its history: three new hotel customers, two café chains and revenue almost double the same month last year. In the second week of September, when the founder went to pay the supplier for green beans arriving from Brazil, there wasn't enough money in the bank account.

The company was profitable. The books were flawless. The problem was where the money was: in the cafés' and hotels' accounts, on invoices with 45- and 60-day terms. By the end of this article you'll have a table you can update in fifteen minutes every Monday so you never face the same surprise.

Part 1 · The paradox Why does a profitable business run out of cash?

A profitable but cash-poor business is one that shows a profit on its income statement yet doesn't have the money to meet obligations as they fall due. Profit is a measurement, cash is an asset; the two arise at different moments.

On the day you issue an invoice, the sale and the profit exist in your books. But the money only arrives when the customer's due date comes and they actually pay. Meanwhile you've already bought the raw materials, paid salaries and covered the rent.

The ironic part is this: the faster a business grows, the wider this gap gets. Every new order means money spent today that only comes back weeks later. Growth consumes cash.

Granting 90- or 120-day terms without knowing this rule is one of the most common causes of cash crunches at growing SMEs. So how do you measure how many days and how many lira that gap is?

Part 2 · The measure What is the cash conversion cycle and how is it calculated?

The cash conversion cycle is the number of days between paying a supplier and that money returning to the business through sales and collections. The formula is: days sales outstanding + days inventory outstanding − days payable outstanding.

  1. Raw material purchase — Supplier invoice
  2. Time in stock — Roasting, packaging
  3. Sales invoice — Profit is created here
  4. Payment term — In the customer's account
  5. Collection — Cash is created here
The three components of the cash conversion cycle
ComponentWhat does it measure?What happens if it shortens?
Days sales outstandingAverage days from issuing the invoice to the money arrivingCash comes in sooner
Days inventory outstandingAverage days purchased goods sit in the warehouse until soldLess money is tied up on the shelf
Days payable outstandingAverage days from the supplier invoice to paymentIf it lengthens, the cycle shortens, but don't strain the relationship
Atlas Kahve's cash conversion cycle
Annual sales9.600.000 TL
Average daily sales (9.600.000 / 365)≈ 26.300 TL
Days sales outstanding52 days
Days inventory outstanding (green and roasted beans)+ 40 days
Days payable outstanding− 30 days
Cash conversion cycle62 days
Approximate cash tied up in the business (26.300 × 62)≈ 1.630.000 TL

This is a simplified calculation; computing the inventory and supplier periods using cost of sales gives a more precise result. But it doesn't change the direction: cutting days sales outstanding by 10 days frees up roughly 263.000 TL.

The figure on the last line tells you something most business owners never calculate: before looking for a bank loan to grow, know how much money is waiting in your own receivables. We cover ways to shorten collection times separately in our article on speeding up collections.

Collections: open receivables
On the Collections screen, overdue invoices and open balances show where your collection period is stretching. Look at the largest and oldest amounts first.
  1. 1. Add collection button
  2. 2. Total pending receivables
  3. 3. Total overdue receivables
  4. 4. Per-row Collect button

Knowing the cycle answers the question "how much". To answer "when", you need a weekly calendar.

Part 3 · The method How do you prepare a 13-week cash flow forecast?

A 13-week cash flow forecast is a table that starts from today's cash balance, lists the expected inflows and outflows for each of the next 13 weeks and projects the end-of-week balance. Thirteen weeks covers a full quarter: long enough to spot payment problems in advance, short enough to keep the estimates realistic.

The method's strength is its weekly detail. A monthly plan might look positive at the end of September while hiding that the account goes negative in the second week. Payments such as salaries, rent and taxes pile up on specific days, while collections are scattered.

Five steps to build the table

  1. Pin down the opening balance

    Take today's total across all cash and bank accounts. In Heyşirket, the TRY account balance indicator on the Cash & Bank screen gives you this figure; first make sure the balances match your bank statements.

    Cash & Bank: accounts
    Pin down the opening balance
    1. 1. Add transaction button
    2. 2. Transfer between accounts
    3. 3. Total TRY balance
    4. 4. Cash and bank account list
  2. Enter collections by due date

    Spread open invoices across the weeks according to their due dates. Use each customer's real payment habits: for a customer who pays an average of 10 days late, push the collection out by a week or two.

    Collections: open receivables
    Enter collections by due date
    1. 1. Add collection button
    2. 2. Total pending receivables
    3. 3. Total overdue receivables
    4. 4. Per-row Collect button
  3. Add cheques and promissory notes

    Enter cheques received in your portfolio as inflows in their due week, and the cheques and notes you've issued as outflows in their payment week. The Cheque & note tracking section lists them in order of due date.

    Check & promissory note tracking
    Add cheques and promissory notes
    1. 1. Received and issued portfolio summary
    2. 2. Received check in portfolio and Collect
    3. 3. Issued check and Pay
    4. 4. Collected check
  4. Put mandatory payments on the calendar

    Enter salaries, SGK (social security) premiums, rent, tax payments, loan instalments and supplier due dates in the week they belong to. Confirm the tax and SGK payment dates with your accountant once and put them on the same row every month.

  5. Update every Monday

    Compare last week's actuals with the forecast, roll the table forward one week and add week 13. Noting the reasons for variances makes your forecasts more accurate every month.

How do you set your collection assumptions?

Collections are the hardest row in the table because they depend on the customer's decision, not yours. The most common mistake here is assuming every invoice will be paid on its due date. Instead, split your customers into a few groups based on past payment behaviour and give each group a delay allowance.

Atlas Kahve's collection assumptions by customer group
GroupExample customerPast behaviourWeek entered in the table
PunctualModa Sahil KafePays on or before the due dateDue week
Slightly lateNişantaşı BistroPays on average 7-10 days after the due dateOne week after the due date
UnpredictableKaraköy Pera OtelPayment day varies month to month, pays partly by chequeTwo weeks after the due date, cheques on their own due date
RiskyAny cari (customer account) more than 60 days overdueHasn't paid despite remindersNever entered in the base scenario

This grouping will be rough in the first month. As you compare actuals with the forecast every Monday, it becomes clear which customer belongs in which group, and your table's accuracy improves noticeably.

First six weeks of Atlas Kahve's 13-week forecast (TL)
ItemWeek 1Week 2Week 3Week 4Week 5Week 6
Opening balance310.000352.000196.000214.000128.000171.000
Invoice collections+ 148.000+ 96.000+ 162.000+ 104.000+ 151.000+ 118.000
Cheque collections+ 40.0000+ 60.0000+ 35.0000
Supplier payments− 86.000− 214.000− 92.000− 48.000− 88.000− 196.000
Salaries, SGK and rent000− 112.00000
Tax and other− 60.000− 38.000− 112.000− 30.000− 55.000− 36.000
Closing balance352.000196.000214.000128.000171.00057.000

Anyone reading the table spots week 6: a large green bean payment drops the closing balance to 57.000 TL. It's a problem known six weeks ahead, which means you have six weeks to solve it. But is 57.000 TL dangerous, or is it enough?

Part 4 · The buffer How big should your cash safety buffer be?

A cash safety buffer is the minimum amount of cash always kept in the account so that mandatory payments aren't disrupted even if a collection is unexpectedly delayed. There's no single ratio that fits everyone; a common starting point is an amount that covers a few weeks of essential fixed costs.

Essential fixed costs are items paid whether or not you make sales: salaries, SGK, rent, loan instalments and subscriptions you can't cancel. Leave supplier payments out of this calculation, because they rise and fall with sales.

Buffer calculation for Atlas Kahve
Monthly salaries and SGK84.000 TL
Roastery and shop rent28.000 TL
Loan instalment, software, insurance18.000 TL
Monthly essential fixed costs130.000 TL
Weekly equivalent (130.000 × 12 / 52)≈ 30.000 TL
Target coverage× 4 weeks
Safety buffer≈ 120.000 TL

Businesses with volatile collections, a dependence on a few large customers or seasonal sales may want to extend the coverage.

Now go back to week 6. The 57.000 TL closing balance is less than half the 120.000 TL buffer. The table is flashing red, and this is still a table built on an optimistic assumption.

Part 5 · Scenarios Scenario analysis: what if customers pay two weeks late?

Scenario analysis means recalculating the same cash forecast with different assumptions to see which week becomes a problem in the worst case. A single forecast gives you a number; three scenarios give you a range.

Three scenarios for Atlas Kahve, week 6 closing balance
ScenarioAssumptionWeek 6 closingAgainst the buffer
BaseCustomers pay as they do today57.000 TL63.000 TL short
PessimisticOne fifth of collections are two weeks late, and a hotel's cheque bounces− 94.000 TL214.000 TL short
OptimisticTwo overdue invoices are collected, and the new café chain pays upfront168.000 TL48.000 TL over

In the pessimistic scenario the account goes negative. This isn't a prophecy, it's a preparation list: you can decide today which lever you'll pull before that week arrives. You don't need to rebuild the scenarios every week; write the assumptions next to the table and update them only when a major customer or payment changes.

  1. Bring collections forward: reminders for overdue invoices from week 2, and an early payment discount offer to large customers.
  2. Reschedule payments: talk to the green bean supplier now about splitting the payment into two instalments; a request made six weeks ahead is accepted far more easily than one made two days before.
  3. Postpone spending: push deferrable investments, such as a new roasting machine, back by a quarter.
  4. Arrange financing in advance: if needed, discuss a short-term credit line with the bank before the need arises.

Part 6 · In practice How do you feed this table with Heyşirket data?

A 13-week forecast rests on three well-answered questions: how much money do I have today, who will pay me and when, and whom will I pay and when. In Heyşirket, these three answers live on three separate screens.

Cash & Bank: accounts
The TRY account balance on the Cash & Bank screen is your table's opening row. The balance is the opening balance plus the total of the transactions entered on this screen, so don't forget to record collections here too.
  1. 1. Add transaction button
  2. 2. Transfer between accounts
  3. 3. Total TRY balance
  4. 4. Cash and bank account list
Cash flow report
The Net movement and Open receivables indicators in the Cash flow report show the balance between collections and expenses in past months; use them to test whether your forecast is realistic.
  1. 1. Collected and expenses
  2. 2. Cash flow view

We explain the report's logic and limits in the cash flow report guide. In short: the report shows the past, the 13-week table shows the future; use them side by side and your forecasts will be less wrong every month.

A 15-minute weekly cash routine

A cash plan isn't made to know the future, but to see the surprise six weeks in advance.

Since that day in September, Atlas Kahve's founder opens this table every Monday. They discussed splitting the green bean payment into two instalments six weeks in advance, and the supplier agreed. Record sales keep coming in; they just don't empty the account anymore.

Is Excel enough for a 13-week cash flow forecast?

Yes, the table has a simple structure. What matters is the accuracy of the inputs: the current bank balance, open invoices with due dates and cheques in your portfolio. You can take this data from Heyşirket into the table and export the cash flow report with Download CSV.

How many days should the cash conversion cycle be?

It varies a lot by industry. For a retailer selling for cash it can even be negative; for a manufacturer selling on credit it can take months. Measure your own cycle every quarter and focus on keeping it moving in the shorter direction.

Why do I borrow to pay taxes even though I'm making a profit?

Because tax arises on the invoices you issue, regardless of whether they've been collected. The KDV (VAT) on a credit sale can fall into the filing period before the customer pays. Putting tax payments on their own row in the 13-week table prevents this surprise; for details, see the VAT guide.

Can I use the safety buffer instead of a credit line?

The two complement each other. The buffer is your own money and always available; a credit line depends on the bank's decision and has a cost. A credit line is easier to arrange when it's negotiated before the need arises.

How do cheque collections affect my cash flow?

Until its due date, a cheque is a promise to pay, not cash. Enter it in the forecast as an inflow in its due week and add the possibility of it bouncing to the pessimistic scenario. More detail in our article on cheque and promissory note management.

Pin down your opening balance today The first row of the 13-week table is an accurate balance. Update your cash and bank accounts in Heyşirket and add your cheques and promissory notes to the portfolio with their due dates. Go to cash and banks

Author: Heyşirket Editorial Team