ExcelFlux
← Workbooks

13-Week Cash Flow

See how much cash you could have on hand over the next 13 weeks. If collections fall short, find the first week your cash buffer comes under pressure and see how large the gap could be.

Macro-free .xlsx · 13 weeks of sample data · Workbook labels in Turkish

Results from the sample workbook

Below the cash buffer
7 weeks
Lowest downside cash balance
11,790
Largest cash buffer gap
58,210

Who can use it, and for what?

Business owners and finance leads

Track available cash by week. See when payroll, rent and supplier payments are due at the same time.

Wholesale and distribution

Compare customer collections on credit with supplier due dates. See which week a large inventory purchase could strain cash.

Manufacturing, project and service teams

Compare material, contractor or payroll costs with customer deposits and milestone payments. Decide which spending to prioritise if a receipt is delayed.

Example with 55% of expected collections received

The business starts with 120,000 in cash and wants to keep at least 70,000 available. The base case assumes all expected collections arrive. The downside case assumes 55% arrive. Confirmed receipts and payments are the same in both scenarios.

The Excel dashboard showing the opening balance, collection rate, minimum balance and four summary metrics.
The Panel sheet from the workbook. Select the image to enlarge it.
WeekBase balanceDownside balanceBuffer gap
196,50071,7500
2124,20073,8900
3139,10062,4207,580
9263,70011,79058,210

The first gap appears in week 3. Cash closes at 62,420, which is 7,580 below the target. In week 9 the gap reaches 58,210. Seeing those weeks in advance gives you time to confirm a customer payment date or discuss the payment schedule with a supplier.

How do you start with your own data?

Gather your weekly collections list, payment schedule and current opening cash balance. Enter all amounts in the same currency.

  1. Set the opening balance and cash buffer

    On the Panel sheet, enter the first week’s opening cash and the minimum you want to keep available. Set the share of expected collections you expect to receive under the downside scenario.

  2. Place receipts and payments in the right weeks

    Replace the sample entries on the Veri sheet with your amounts. Keep confirmed receipts separate from expected collections. Put payroll, supplier and other payments in the week the cash will leave.

  3. Find the first shortfall and refresh the plan

    Check the downside balance and buffer gap columns on the Veri sheet. Work out which receipt you could bring forward or which payment you could reschedule before the first gap. Refresh the plan weekly with actual amounts.

Detailed Excel guide

Initial setup

Use the same weekly cutoff throughout. Separate confirmed receipts from expected collections so the same payment is counted once. Reconcile opening cash to the bank before rolling forward.

  1. Open a copy and try the sample data first. Panel contains settings and totals. Veri contains editable inputs and formulas. Workbook field labels are in Turkish and appear as written in the file.
  2. Compare the settings and the first data row below with the workbook. Blue cells are inputs. Preserve the working formulas.
  3. The workbook has 13 populated examples and 13 prepared formula rows. Keep the headers and replace the input values with your own records.

Panel settings

CellFieldSample value
Panel!B7İlk hafta açılış bakiyesi120,000
Panel!B8Kötümser tahsilat oranı55%
Panel!B9Asgari nakit bakiyesi70,000

First data row

CellFieldSample value
Veri!A7HaftaHafta 01
Veri!B7Kesin giriş38,000
Veri!C7Beklenen tahsilat55,000
Veri!D7Maaş82,000
Veri!E7Tedarikçi27,000
Veri!F7Diğer çıkış7,500

Calculated results and formulas

These values are calculated from the supplied workbook examples.

Formulas below use English Excel syntax. Function names and separators can vary with your Excel locale.

CellFieldSample value
Veri!G7Baz net akış
Cell formula=IF(A7="","",B7+C7-SUM(D7:F7))
-23,500
Veri!H7Baz kapanış
Cell formula=IF(A7="","",IF(ROW()=7,Panel!$B$7,H6)+G7)
96,500
Veri!I7Kötümser net
Cell formula=IF(A7="","",B7+C7*Panel!$B$8-SUM(D7:F7))
-48,250
Veri!J7Kötümser kapanış
Cell formula=IF(A7="","",IF(ROW()=7,Panel!$B$7,J6)+I7)
71,750
Veri!K7Rezerv açığı
Cell formula=IF(A7="","",MAX(0,Panel!$B$9-J7))
0

Dashboard indicators

These values are calculated from the supplied workbook examples.

CellFieldSample value
Panel!E7Baz dönem sonu448,100
Panel!E8Kötümser en düşük bakiye11,790
Panel!E9Rezerv altı hafta7
Panel!E10En büyük rezerv açığı58,210

Change one input and check the result

  1. Open the Veri sheet in the sample workbook.
  2. C7 → enter 65,000.
  3. J7 expected value 77,250.
  4. Review the affected dashboard metrics. Restore the test input or save the example as a separate copy before using your own data.

Interpretation and troubleshooting

Compare base and downside closing balances and identify the first week with a reserve shortfall. Negative weekly net cash does not automatically mean the reserve has been breached.

If the result does not change, confirm the input cell and sheet and check that automatic calculation is enabled. To reproduce the example, leave the remaining inputs at their starting values.