Forum Discussion
Weekly opening balance
Hi Oomsen ,
you are right. There was one part of the calculation that I had not fixed.
You can download the new version from here.
I rechecked calculations manually, now all seem to be good.
Let me know if it also works for you!
LC
Interested in Power BI and DAX templates? Check out my blog at www.finance-bi.com
lc_finance do you have any suggestion?
lc_finance thanks for your solution. Unfortunately it's not completely what i'm looking for.
I would like to forecast my cashflow.
I want to see the opening balance of the week (opening), plus the transactions (mutatie), plus the debtors (deb), minus creditors (cred) is closing balance (closing).
Then next week i would like to start with the closing of last week and again, plus transactions, plus debtors and minus creditors.
I'm expecting:
Week Opening Mutatie Deb Cred Closing
45 31240 0 440 889 30790
46 30790 0 386 -97 31273
47 31273 0 992 961 31304
Hi Oomsen ,
You can find attached an updated version.
I obtain different numbers than you, but I rechecked them in Excel and they look correct.
| week | opening new | mutatie | deb | cred | closing new | check closing |
| 53 | ||||||
| 52 | 0 | 0 | ||||
| 51 | -405 | 0 | -405 | 0 | ||
| 50 | -405 | -405 | 0 | |||
| 49 | 0 | 0 | ||||
| 48 | 31.26 | 0 | 31.26 | 0 | ||
| 47 | 482.79 | 992 | -960.78 | 514.05 | -0.04 | |
| 46 | -449.48 | 386 | 96.56 | 33.31 | -0.23 | |
| 45 | 40332.06 | 440 | -889.32 | 39882.58 | 0.16 | |
| 44 | 31272.19 | -32 | 25457 | -16364.5 | 40332.06 | 0.67 |
| 43 | 15523.69 | 15749 | 0 | 31272.19 | 0.5 | |
| 42 | 26763.57 | -11240 | 0 | 15523.69 | -0.12 | |
| 41 | 3532.45 | 23231 | 0 | 26763.57 | -0.12 | |
| 40 | 3532 | 0 | 3532.45 | -0.45 |
Let me know if this fixes your problem!
LC
Interested in Power BI and DAX templates? Check out my blog at www.finance-bi.com
lc_finance it's still not completely what i'm looking for.
I'm expecting below:
46 39882.58 0 386 96.56 40172.02
47 40172.02 0 992 -960.78 42124.80
48 42124.80 0 0 0 42124.80
Hi Oomsen ,
you are right. There was one part of the calculation that I had not fixed.
You can download the new version from here.
I rechecked calculations manually, now all seem to be good.
Let me know if it also works for you!
LC
Interested in Power BI and DAX templates? Check out my blog at www.finance-bi.com
lc_finance although it is now working properly, I noticed that there is a difference with the actual balance. This is because last year's balance is not included. How could I add this?