# Cashflow strest test template

**URL:** https://community.silverfin.com/t/cashflow-strest-test-template/1708
**Category:** COVID-19
**Tags:** templates, insights
**Created:** [March 27, 2020, 11:13am UTC](https://community.silverfin.com/t/cashflow-strest-test-template/1708 "2020-03-27T11:13:15Z")
**Posts on this page:** 10
**Page:** 1

<div class="post-metadata">

### Author: ![DomienClaeys](https://yyz2.discourse-cdn.com/flex030/user_avatar/community.silverfin.com/domienclaeys/32/1294_2.png) [@DomienClaeys](https://community.silverfin.com/u/DomienClaeys)
#### Post date: [March 27, 2020, 11:13am UTC](https://community.silverfin.com/t/cashflow-strest-test-template/1708/1 "2020-03-27T11:13:15Z")

</div>

We are working on a cashflow simulation tool in order to stress test individual clients cashflow position.  
This template provides every accountant with a tool to calculate and simulate clients cashflow over a period of 8 coming weeks. To make it possible to zoom really zoom in on every client file. To have a proper discussion with clients regarding the impact of COVID-19 on their business, and/or challenge clients in how to survive the coming two months.

---

<div class="post-metadata">

### Author: ![DomienClaeys](https://yyz2.discourse-cdn.com/flex030/user_avatar/community.silverfin.com/domienclaeys/32/1294_2.png) [@DomienClaeys](https://community.silverfin.com/u/DomienClaeys)
#### Post date: [March 27, 2020, 11:20am UTC](https://community.silverfin.com/t/cashflow-strest-test-template/1708/2 "2020-03-27T11:20:02Z")

</div>

Start from the current cash positon of you client.  
Simulate the impact of work capital needs.

 ![Schermafbeelding 2020-03-27 om 12.21.12](https://canada1.discourse-cdn.com/flex030/uploads/getsilverfin/original/2X/a/a6a84e465667b0d52502ca37296a46d0898f17da.png)

---

<div class="post-metadata">

### Author: ![DomienClaeys](https://yyz2.discourse-cdn.com/flex030/user_avatar/community.silverfin.com/domienclaeys/32/1294_2.png) [@DomienClaeys](https://community.silverfin.com/u/DomienClaeys)
#### Post date: [March 27, 2020, 11:25am UTC](https://community.silverfin.com/t/cashflow-strest-test-template/1708/3 "2020-03-27T11:25:51Z")

</div>

Addiontally, predict cash in and cash out movements for the coming 8 weeks.  
See cash impact instantly, discuss and make disicions in how to cover the next two months

 ![Schermafbeelding 2020-03-27 om 12.23.20](https://canada1.discourse-cdn.com/flex030/uploads/getsilverfin/original/2X/0/07a9027e238c2c801a106bc1e20abd872e16e199.png)

---

<div class="post-metadata">

### Author: ![DomienClaeys](https://yyz2.discourse-cdn.com/flex030/user_avatar/community.silverfin.com/domienclaeys/32/1294_2.png) [@DomienClaeys](https://community.silverfin.com/u/DomienClaeys)
#### Post date: [March 27, 2020, 11:28am UTC](https://community.silverfin.com/t/cashflow-strest-test-template/1708/4 "2020-03-27T11:28:18Z")

</div>

Run multiple scenarios and coach client in need throughout this tuff period.

 ![Schermafbeelding 2020-03-27 om 12.27.43](https://canada1.discourse-cdn.com/flex030/uploads/getsilverfin/original/2X/3/3248f9df1a3a1c8a8273dff0687c6efdee01c5ae.png)

---

<div class="post-metadata">

### Author: ![DomienClaeys](https://yyz2.discourse-cdn.com/flex030/user_avatar/community.silverfin.com/domienclaeys/32/1294_2.png) [@DomienClaeys](https://community.silverfin.com/u/DomienClaeys)
#### Post date: [March 27, 2020, 11:30am UTC](https://community.silverfin.com/t/cashflow-strest-test-template/1708/5 "2020-03-27T11:30:12Z")

</div>

Keep track of made discision and instantly see the impact on clients cash situation.  
Silverfin also provides you with a [specific template with a holistic overview of all possible measurements](https://community.silverfin.com/t/measurements-follow-up/1709). This for every specific area.

 ![Schermafbeelding 2020-03-27 om 12.27.49](https://canada1.discourse-cdn.com/flex030/uploads/getsilverfin/original/2X/6/675465d4cde489650aa1e873c5eced20e2683852.png)

---

<div class="post-metadata">

### Author: ![Tom\_Libbrecht](https://yyz2.discourse-cdn.com/flex030/user_avatar/community.silverfin.com/tom_libbrecht/32/1305_2.png) [@Tom\_Libbrecht](https://community.silverfin.com/u/Tom_Libbrecht)
#### Post date: [March 27, 2020, 2:46pm UTC](https://community.silverfin.com/t/cashflow-strest-test-template/1708/6 "2020-03-27T14:46:49Z")

</div>

@DomienClaeys great initiative - could you consider expanding this to 13 weeks?  
That equals 1 quarter and pretty much best practice in the world of investors, banks & shareholders.  
Happy to join forces as we also plan to install this internally.

---

<div class="post-metadata">

### Author: ![bpirmez](https://avatars.discourse-cdn.com/v4/letter/b/e19adc/32.png) [@bpirmez](https://community.silverfin.com/u/bpirmez)
#### Post date: [April 6, 2020, 10:42am UTC](https://community.silverfin.com/t/cashflow-strest-test-template/1708/7 "2020-04-06T10:42:29Z")

</div>

Hello !  
Very nice template !  
Instead of using a % of the customers/suppliers to be paid in the next X days, we would like to see the aged balance by customer/supplier and be able to retype in the appropriate week the amount to be paid for each of them. It would be easier than computing a general ratio…  
This is a discussion we had with a client during a practice session.

![image](https://canada1.discourse-cdn.com/flex030/uploads/getsilverfin/original/2X/4/455a92bcf9d446a949c99f7f2cc6d3381e33d35b.png)

Thank’s you !

---

<div class="post-metadata">

### Author: ![DomienClaeys](https://yyz2.discourse-cdn.com/flex030/user_avatar/community.silverfin.com/domienclaeys/32/1294_2.png) [@DomienClaeys](https://community.silverfin.com/u/DomienClaeys)
#### Post date: [April 6, 2020, 10:56am UTC](https://community.silverfin.com/t/cashflow-strest-test-template/1708/8 "2020-04-06T10:56:17Z")

</div>

Hey,

Thanks for your feedback!  
Make sure to follow this community page the comming days.  
We are working on a updated release of this template pack. Without spoiling our development scope, you will find what you need in there 😉

Updates will be communicated here and on the Silverfin Marketplace.  
Domien

---

<div class="post-metadata">

### Author: ![bpirmez](https://avatars.discourse-cdn.com/v4/letter/b/e19adc/32.png) [@bpirmez](https://community.silverfin.com/u/bpirmez)
#### Post date: [May 4, 2020, 7:54am UTC](https://community.silverfin.com/t/cashflow-strest-test-template/1708/9 "2020-05-04T07:54:45Z")

</div>

Hello !  
Currently, I do not see any change in the template in the marketplace (Covid-19 guide Belgium). Will the aged balance by customer/supplier be added to the template or will it replace the % of the customers/suppliers ?  
Thank’s you

---

<div class="post-metadata">

### Author: ![sven](https://yyz2.discourse-cdn.com/flex030/user_avatar/community.silverfin.com/sven/32/1495_2.png) [@sven](https://community.silverfin.com/u/sven)
#### Post date: [May 4, 2020, 9:51am UTC](https://community.silverfin.com/t/cashflow-strest-test-template/1708/10 "2020-05-04T09:51:35Z")

</div>

Hey @bpirmez,

The update should made this possible now:  
 ![Screen Shot 2020-05-04 at 11.48.59](https://canada1.discourse-cdn.com/flex030/uploads/getsilverfin/original/2X/3/3a7eb026063dab19a10b685f70fd53feaa48ac1e.png)  
in which you can manually enter the correct amount of open payables & receivables without the need to enter a percentage.

If you once entered percentages before our update, then we will still show those. You can leave them and still use them, or delete them to start from scratch if wished of course.

Does this help you further @bpirmez?
