Forum Discussion
Exclude next year
I wasn't able to add the document so below the date:
| date | opening balance | cashflow | receivable | sales orders | payable | costs | closing balance |
| 1-1-2018 | 362.441,00 | -94.613,00 | 267.828,00 | ||||
| 1-2-2018 | 267.828,00 | -271.768,00 | 2,00 | -3.942,00 | |||
| 1-3-2018 | -3.942,00 | -298.819,00 | -302.761,00 | ||||
| 1-4-2018 | -302.761,00 | -75.327,00 | -378.088,00 | ||||
| 1-5-2018 | -378.088,00 | 27.366,00 | -350.722,00 | ||||
| 1-6-2018 | -350.722,00 | -14.062,00 | -170,00 | 160,00 | -365.114,00 | ||
| 1-7-2018 | -365.114,00 | 31.476,00 | 101.559,00 | -435.197,00 | |||
| 1-8-2018 | -435.197,00 | 630.486,00 | 195.289,00 | ||||
| 1-9-2018 | 195.289,00 | -164.167,00 | 481,00 | 199,00 | 31.404,00 | ||
| 1-10-2018 | 31.404,00 | 49.742,00 | 85.097,00 | 10.984,00 | 155.259,00 | ||
| 1-11-2018 | 155.259,00 | -65.174,00 | 143.904,00 | -50.679,00 | 167.045,00 | 16.265,00 | |
| 1-12-2018 | 16.265,00 | 7.741,00 | 36.732,00 | - | 106.045,00 | -45.307,00 | |
| 1-1-2019 | -45.307,00 | 63.000,00 | 30.079,00 | 95.490,00 | -107.876,00 | ||
| 1-2-2019 | -107.876,00 | 82.500,00 | 92.253,00 | -117.629,00 | |||
| 1-3-2019 | -117.629,00 | 91.312,00 | -208.941,00 | ||||
| 1-4-2019 | -208.941,00 | 93.996,00 | -302.937,00 | ||||
| 1-5-2019 | -302.937,00 | 99.100,00 | -402.037,00 | ||||
| 1-6-2019 | -402.037,00 | 97.426,00 | -499.463,00 | ||||
| 1-7-2019 | -499.463,00 | 95.468,00 | -594.931,00 | ||||
| 1-8-2019 | -594.931,00 | 95.464,00 | -690.395,00 | ||||
| 1-9-2019 | -690.395,00 | 96.008,00 | -786.403,00 | ||||
| 1-10-2019 | -786.403,00 | 96.805,00 | -883.208,00 | ||||
| 1-11-2019 | -883.208,00 | 97.282,00 | -980.490,00 | ||||
| 1-12-2019 | -980.490,00 | 96.975,00 | -1.077.465,00 |
Hi Oomsen,
Can you share a complete sample file? You can upload it to the cloud drive like OneDrive, GoogleDrive, then share the download link here.
Because your sample data works well. Please refer to the snapshot below.
Best Regards,
Dale
That's what i tried but unfortunately it wasn't the solution. As you can see in my example the function works for 2018 december, but not for 2019. So i'm looking for a fix in the formula.
I can't share the data because the information is confidentially. I will try to explain the calculation.
"Beginsaldo" means "Opening balance" and is a running total of alle financial transactions - "cashflow" which is the sum of al financial transactions in the specific month.