Module 06 · Receivables, Collections and Cash Flow

Cash-Flow Forecasting from Receivables and Payables

Build a 30 day cash flow forecast from bank cash, receivables and pending cheques, minus bills and outgoing cheques. Reyuko has no forecast, so do it by hand.

5 min readLesson 9 of 9 in this moduleUpdated 2026-10-24

A wholesaler can show a profit and still run short of cash, because customers pay late and suppliers want payment on time. Reyuko's Cash Flow report looks back, and it has no forward forecast. You can build a short forecast by hand from four lists the app does show: Cash & Bank, Receivable, Payable and Cheques & Giro.

Key takeaways

  • Reyuko's Cash Flow report shows past cash only. Build the next 30 days by hand.
  • Start from today's bank balance, add cash expected in, and subtract cash expected out.
  • Place each amount by its due date, not its invoice date.
  • Count pending cheques separately. Their invoices are already settled, so they will not appear in Receivable.
  • Add costs that are not bills yet, such as payroll and rent, yourself.

What you can read in Reyuko

  • Cash & Bank (Payment menu): the balance of each cash and bank account today.
  • Payment > Receivable: each unpaid invoice with its Due Date and Balance. Use the Due range filter to pick the days you want, and the Overdue chip for invoices already late.
  • Payment > Aging AR/AP: totals by bucket for each contact. The buckets are Not Due, 1-30 days, 31-60 days, 61-90 days and >90 days. It has no as-of date, so it always shows today.
  • Payment > Cheques & Giro: the Awaiting Clearance total and the Due Date of each cheque.
  • Payment > Payable: supplier bills, with the same Due range filter as Receivable.

The Dashboard widget 30-Day Cash Projection (Advanced, off by default) is a partial cross-check. It leaves out payroll and rent.

The 30-day method

Illustration: Harbor Wholesale is a fictional business; numbers are examples. On a Monday, Harbor reads these figures and fills in the table below.

LineWhere to read itRp
Cash and bank todayCash & Bank120,000,000
Receivables due in the next 30 daysReceivable, Due range75,000,000
Incoming cheques due in the next 30 daysCheques & Giro, Awaiting Clearance20,000,000
Outgoing cheques due in the next 30 daysCheques & Giro, Outgoing(15,000,000)
Bills due in the next 30 daysPayable, Due range(90,000,000)
Expected cash at day 30110,000,000

Check the arithmetic: 120 + 75 + 20 - 15 - 90 = 110 (million).

Two items are left out on purpose. First, Rp 10,000,000 from invoices already past due. Show it on its own line as at risk, and do not count it as cash. Second, sales not yet invoiced, and any cost that is not a bill yet, such as payroll, rent and fuel. Add those yourself.

The incoming cheques get their own line because a recorded cheque settles its invoice at once, so it leaves the Receivable list. Outgoing cheques work the same way: a recorded cheque settles its bill, so it leaves Payable.

Doing this in Reyuko
  1. Open Cash & Bank and note the balance of each account. Add them up.
  2. Open Payment > Receivable, set the Due range from today to 30 days ahead, and note the total Balance.
  3. Open Payment > Cheques & Giro. On the Incoming Cheques tab, note the Awaiting Clearance total with a Due Date in the window. On the Outgoing Cheques tab, do the same.
  4. Open Payment > Payable (or Aging AR/AP with the Payable (AP) view) and note the bills due in the window.
  5. Fill in the table and subtract the outgoing lines. Keep the result in a spreadsheet, and repeat it each week on the same day.
Aging shows today only

Aging AR/AP has no as-of date. If you need last week's position, export the CSV on that day and keep the file. Do not try to rebuild an old view from today's numbers.

Check yourself: why is the Rp 10,000,000 past-due amount not in the forecast?

Because it may not arrive on time, and it is not certain cash. Show it separately as at risk, and decide with your team when to chase it.

Where the method is weak

Customers pay late, so expected cash often arrives after its Due Date. Check the Overdue chip every week and move the amounts that slipped. Treat day 30 as a planning figure, not a promise.

Frequently asked questions

How do you build a 30-day cash flow forecast?

Start with today's cash and bank balance, then add the cash you expect within 30 days, such as receivables due and incoming cheques. Subtract the payments due in the same window, including supplier bills and outgoing cheques. Place each amount by its due date rather than its invoice date, and show overdue invoices on their own line as at risk.

What is the formula for ending cash in a forecast?

Ending cash equals opening cash plus expected receipts minus expected payments. For example, Rp 120 million opening cash, plus Rp 75 million receivables and Rp 20 million incoming cheques, minus Rp 15 million outgoing cheques and Rp 90 million bills, gives Rp 110 million at day 30.

Should receivables be counted as cash when they are due?

Not automatically. A due date is when payment is expected, not when cash arrives, and late customers often pay after it. Count an amount as expected cash only when you have a reasonable reason to expect it, and keep overdue amounts separate as at risk.

Which costs besides supplier bills belong in the forecast?

Add any outflow you know will happen in the window that is not yet a bill, such as payroll, rent and fuel. A forecast that counts only supplier bills will look better than the cash you will really have. Reyuko does not add these to a forecast, so enter them as your own lines.

Does Reyuko have a cash flow forecast report?

No. Accounting > Reporting > Cash Flow shows cash movement that has already happened. The Dashboard widget 30-Day Cash Projection, which is off by default, gives a partial view from receivables and payables due, but it leaves out payroll and rent, so keep your own table.

Why are my pending cheques not in the Receivable list?

Recording a cheque settles its invoice at once, so the invoice leaves Receivable. The amount stays under Awaiting Clearance in Payment > Cheques & Giro until you click Confirm Clearance or Record Rejection. Add that amount with its due date as a separate line in your forecast.

Put this into practice in Reyuko

Reyuko's inventory, purchasing, sales, purchasing and reporting tools work together on one ledger, so your stock and your books always agree.

Download ReyukoSee what's included