13 week cash flow forecast from the ledgers
Builds the weekly cash view from open receivables, open payables and the recurring schedule, dates receipts by how each customer actually pays, and runs the scenarios that matter.
The problem it solves
A cash forecast built on due dates is fiction, because customers do not pay on due dates. This one uses each customer's average days late from history, so the low point lands in the right week.
What it does
- Reads open AR, open AP, recurring items (payroll, rent, VAT and corporate tax payments, subscriptions, retainers) and customer payment behaviour.
- Places every receipt and payment in its week, builds opening and closing cash for 13 weeks, flags weeks below the minimum.
- Four scenarios from the same ledgers: base, collections 14 days slower, largest customer lost, supplier terms stretched 7 days, with the first breach week for each.
- Detail sheets show every receipt and payment behind every week, and an assumptions sheet says exactly what was and was not included.
How it was tested
- Sample business: base case low point in week 11, slow collections breaches the minimum in week 2 and again in week 11, largest customer lost stays above it. All three checked by hand against the detail sheets.
Screens
Who it is for
Owners who want to know the low week before it arrives.
See it running on a call → hamza.jamal@finamatik.com Source code on GitHub →
Built and tested on sample data before any live credential is connected. Every system Finamatik ships is adapted to the client's own tools and owned by the client outright.