Spreadsheet: 774404d1648459878-power-query-question-data-for-powerquery
Sheet: GL must become

GL | Datum | Financiële periode | Code dagboek | Omschrijving dagboek | Bkst.nr. | Omschrijving | Debet | Credit | Voorlopig totaal | Onze ref. | Verricht
8000 - kauwgum | 01-01-2022 | 2022 - 1 | 70 | [NAME] | 22700017 | text |  | 43.2 | -43.2 | 22700017
8000 - kauwgum | 01-01-2022 | 2022 - 1 | 70 | [NAME] | 22700018 | text |  | 12.6 | -55.8 | 22700018
8000 - kauwgum | 01-01-2022 | 2022 - 1 | 70 | [NAME] | 22700019 | text |  | 9.36 | -65.16000000000001 | 22700019
8000 - kauwgum | 01-01-2022 | 2022 - 1 | 70 | [NAME] | 22700020 | text |  | 45 | -110.16 | 22700020
8000 - kauwgum | 01-01-2022 | 2022 - 1 | 70 | [NAME] | 22700021 | text |  | 18 | -128.16 | 22700021
8000 - kauwgum | 01-01-2022 | 2022 - 1 | 70 | [NAME] | 22700022 | text |  | 28.8 | -156.96 | 22700022
8000 - kauwgum | 01-01-2022 | 2022 - 1 | 70 | [NAME] | 22700001 | text |  |  | -156.96 | 22700001
8000 - kauwgum | 01-01-2022 | 2022 - 1 | 70 | [NAME] | 22700002 | text |  |  | -156.96 | 22700002
8000 - kauwgum | 01-01-2022 | 2022 - 1 | 70 | [NAME] | 22700003 | text |  | 25.2 | -182.16 | 22700003
8000 - kauwgum | 01-01-2022 | 2022 - 1 | 70 | [NAME] | 22700004 | text |  | 25.2 | -207.36 | 22700004
8000 - kauwgum | 01-01-2022 | 2022 - 1 | 70 | [NAME] | 22700005 | text |  | 9.720000000000002 | -217.08 | 22700005
8010 - drop | 02-01-2022 | 2022 - 1 | 70 | [NAME] | 22700054 | text |  |  | 0 | 22700054
8010 - drop | 03-01-2022 | 2022 - 1 | 70 | [NAME] | 22700078 | text |  |  | 0 | 22700078
8010 - drop | 03-01-2022 | 2022 - 1 | 70 | [NAME] | 22700080 | text |  |  | 0 | 22700080
8010 - drop | 03-01-2022 | 2022 - 1 | 70 | [NAME] | 22700082 | text |  |  | 0 | 22700082
8010 - drop | 03-01-2022 | 2022 - 1 | 70 | [NAME] | 22700073 | text |  |  | 0 | 22700073
8010 - drop | 03-01-2022 | 2022 - 1 | 70 | [NAME] | 22700081 | text |  |  | 0 | 22700081
8010 - drop | 04-01-2022 | 2022 - 1 | 70 | [NAME] | 22700122 | text |  |  | 0 | 22700122
8010 - drop | 04-01-2022 | 2022 - 1 | 70 | [NAME] | 22700124 | text |  |  | 0 | 22700124
8010 - drop | 04-01-2022 | 2022 - 1 | 70 | [NAME] | 22700126 | text |  |  | 0 | 22700126
8010 - drop | 05-01-2022 | 2022 - 1 | 70 | [NAME] | 22700171 | text |  |  | 0 | 22700171
8010 - drop | 05-01-2022 | 2022 - 1 | 70 | [NAME] | 22700172 | text |  |  | 0 | 22700172
8020 - hatseflats | 06-02-2022 | 2022 - 2 | 70 | [NAME] | 22701680 | text |  | 94.5 | -2997.192 | 22701680
8020 - hatseflats | 06-02-2022 | 2022 - 2 | 70 | [NAME] | 22701681 | text |  | 42 | -3039.192 | 22701681
8020 - hatseflats | 06-02-2022 | 2022 - 2 | 70 | [NAME] | 22701682 | text |  | 84 | -3123.192 | 22701682
8020 - hatseflats | 06-02-2022 | 2022 - 2 | 70 | [NAME] | 22701683 | text |  |  | -3123.192 | 22701683
8020 - hatseflats | 06-02-2022 | 2022 - 2 | 70 | [NAME] | 22701684 | text |  | 94.5 | -3217.692 | 22701684
8020 - hatseflats | 06-02-2022 | 2022 - 2 | 70 | [NAME] | 22701698 | text |  |  | -3217.692 | 22701698
8020 - hatseflats | 07-02-2022 | 2022 - 2 | 70 | [NAME] | 22701703 | text |  | 105 | -3322.692 | 22701703
8020 - hatseflats | 07-02-2022 | 2022 - 2 | 70 | [NAME] | 22701704 | text |  | 39.59999999999999 | -3362.291999999999 | 22701704
8020 - hatseflats | 07-02-2022 | 2022 - 2 | 70 | [NAME] | 22701705 | text |  |  | -3362.291999999999 | 22701705
8020 - hatseflats | 07-02-2022 | 2022 - 2 | 70 | [NAME] | 22701706 | text |  | 294 | -3656.291999999999 | 22701706
8020 - hatseflats | 07-02-2022 | 2022 - 2 | 70 | [NAME] | 22701707 | text |  | 23.4 | -3679.692 | 22701707
8020 - hatseflats | 07-02-2022 | 2022 - 2 | 70 | [NAME] | 22701708 | text |  | 50.40000000000001 | -3730.092 | 22701708
8020 - hatseflats | 07-02-2022 | 2022 - 2 | 70 | [NAME] | 22701709 | text |  | 45 | -3775.092 | 22701709
8020 - hatseflats | 07-02-2022 | 2022 - 2 | 70 | [NAME] | 22701701 | text |  | 142.56 | -3917.652 | 22701701
8020 - hatseflats | 07-02-2022 | 2022 - 2 | 70 | [NAME] | 22701740 | text |  |  | -3917.652 | 22701740
8020 - hatseflats | 07-02-2022 | 2022 - 2 | 70 | [NAME] | 22701739 | text |  | 16.86 | -3934.512000000001 | 22701739
8020 - hatseflats | 07-02-2022 | 2022 - 2 | 70 | [NAME] | 22701739 | text |  |  | -3934.512000000001 | 22701739
8020 - hatseflats | 07-02-2022 | 2022 - 2 | 70 | [NAME] | 22701738 | text |  |  | -3934.512000000001 | 22701738
8020 - hatseflats | 07-02-2022 | 2022 - 2 | 70 | [NAME] | 22701737 | text |  | 82.314 | -4016.826 | 22701737
8020 - hatseflats | 07-02-2022 | 2022 - 2 | 70 | [NAME] | 22701735 | text |  | 45.12599999999999 | -4061.952 | 22701735
8020 - hatseflats | 24-02-2022 | 2022 - 2 | 70 | [NAME] | 22702736 | text |  | 61.986 | -12806.496 | 22702736
8020 - hatseflats | 24-02-2022 | 2022 - 2 | 70 | [NAME] | 22702726 | text |  | 323.802 | -13130.298 | 22702726
8020 - hatseflats | 25-02-2022 | 2022 - 2 | 70 | [NAME] | 22702777 | text |  | 24.792 | -13155.09 | 22702777
8020 - hatseflats | 25-02-2022 | 2022 - 2 | 70 | [NAME] | 22702778 | text |  | 122.976 | -13278.066 | 22702778
8020 - hatseflats | 28-02-2022 | 2022 - 2 | 70 | [NAME] | 22702894 | text |  | 212.232 | -13490.298 | 22702894
8020 - hatseflats | 28-02-2022 | 2022 - 2 | 70 | [NAME] | 22702896 | text | 86.77799999999999 |  | -13403.52 | 22702896
8020 - hatseflats | 28-02-2022 | 2022 - 2 | 70 | [NAME] | 22702887 | text |  | 111.57 | -13515.09 | 22702887
8020 - hatseflats | 28-02-2022 | 2022 - 2 | 70 | [NAME] | 22702888 | text |  | 156.198 | -13671.288 | 22702888
8020 - hatseflats | 28-02-2022 | 2022 - 2 | 70 | [NAME] | 22702902 | text |  | 200.826 | -13872.114 | 22702902
8020 - hatseflats | 28-02-2022 | 2022 - 2 | 70 | [NAME] | 22702903 | text | 200.826 |  | -13671.288 | 22702903
8030 - frietje met | 13-01-2022 | 2022 - 1 | 70 | [NAME] | 22700574 | text |  | 47.604 | -47.604 | 22700574
8030 - frietje met | 31-01-2022 | 2022 - 1 | 70 | [NAME] | 22701483 | text |  | 29.754 | -77.358 | 22701483
8030 - frietje met | 19-02-2022 | 2022 - 2 | 70 | [NAME] | 22702572 | text | 47.604 |  | -29.754 | 22702572
8031 - salsa | 07-01-2022 | 2022 - 1 | 70 | [NAME] | 22700270 | text |  | 238.014 | -238.014 | 22700270
8031 - salsa | 17-01-2022 | 2022 - 1 | 70 | [NAME] | 22700802 | text |  | 238.014 | -476.028 | 22700802
8040 - bier met worst | 01-01-2022 | 2022 - 1 | 70 | [NAME] | 22700026 | text |  |  | 0 | 22700026
8040 - bier met worst | 01-01-2022 | 2022 - 1 | 70 | [NAME] | 22700030 | text |  |  | 0 | 22700030
8040 - bier met worst | 01-01-2022 | 2022 - 1 | 70 | [NAME] | 22700028 | text |  |  | 0 | 22700028
8040 - bier met worst | 01-01-2022 | 2022 - 1 | 70 | [NAME] | 22700022 | text |  |  | 0 | 22700022
8040 - bier met worst | 01-01-2022 | 2022 - 1 | 70 | [NAME] | 22700021 | text |  |  | 0 | 22700021
8040 - bier met worst | 01-01-2022 | 2022 - 1 | 70 | [NAME] | 22700020 | text |  |  | 0 | 22700020
8040 - bier met worst | 02-01-2022 | 2022 - 1 | 70 | [NAME] | 22700048 | text |  |  | 0 | 22700048
8040 - bier met worst | 02-01-2022 | 2022 - 1 | 70 | [NAME] | 22700047 | text |  |  | 0 | 22700047
8040 - bier met worst | 02-01-2022 | 2022 - 1 | 70 | [NAME] | 22700046 | text |  |  | 0 | 22700046
8040 - bier met worst | 02-01-2022 | 2022 - 1 | 70 | [NAME] | 22700044 | text |  |  | 0 | 22700044
8040 - bier met worst | 03-01-2022 | 2022 - 1 | 70 | [NAME] | 22700069 | text |  |  | 0 | 22700069
8040 - bier met worst | 03-01-2022 | 2022 - 1 | 70 | [NAME] | 22700068 | text |  |  | 0 | 22700068
8040 - bier met worst | 03-01-2022 | 2022 - 1 | 70 | [NAME] | 22700071 | text |  |  | 0 | 22700071
8040 - bier met worst | 03-01-2022 | 2022 - 1 | 70 | [NAME] | 22700070 | text |  |  | 0 | 22700070
8040 - bier met worst | 03-01-2022 | 2022 - 1 | 70 | [NAME] | 22700072 | text |  |  | 0 | 22700072
8040 - bier met worst | 03-01-2022 | 2022 - 1 | 70 | [NAME] | 22700067 | text |  |  | 0 | 22700067
8040 - bier met worst | 04-01-2022 | 2022 - 1 | 70 | [NAME] | 22700114 | text |  |  | 0 | 22700114
8040 - bier met worst | 04-01-2022 | 2022 - 1 | 70 | [NAME] | 22700113 | text |  |  | 0 | 22700113