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

zondag 27 maart 2022 18:24 |  | 20003 - Hoest BV
Grootboekkaarten (EUR)
Traject |  |  |  |  | Tonen |  |  |  | Aanvullende informatie
Grootboekrekening |  | 8000 - 8099 |  |  | [NAME] |  | Alle |  | Val. |  | Nee
Boekjaar/Periode |  | 2022 / 1 - 2 (01-01-2022 - 28-02-2022) |  |  | Boekingen |  | Alle |  | BTW |  | Nee
 |  |  |  |  | Uitsluiten : Correctieboekingen |  | Verwerkt |  | Kostenanalyse |  | Nee
 |  |  |  |  | Transacties |  | Beide |  | Relaties |  | Ja
 |  |  |  |  |  |  |  |  | Activa |  | Nee
Algemene inlichtingen |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Aanvullende informatie
Datum | Financiële periode | Column1 | Code dagboek | Omschrijving dagboek | Column2 | Bkst.nr. | Omschrijving | Column3 | Column4 | Debet | Column5 | Credit | Column6 | Column7 | Voorlopig totaal | Onze ref. | Verricht
8000 - kauwgum
01-01-2022 | 2022 - 1 |  | 70 | [NAME] |  | 22700017 | text |  |  |  |  | 43.2 |  |  | -43.2 | 22700017
01-01-2022 | 2022 - 1 |  | 70 | [NAME] |  | 22700018 | text |  |  |  |  | 12.6 |  |  | -55.8 | 22700018
01-01-2022 | 2022 - 1 |  | 70 | [NAME] |  | 22700019 | text |  |  |  |  | 9.36 |  |  | -65.16000000000001 | 22700019
01-01-2022 | 2022 - 1 |  | 70 | [NAME] |  | 22700020 | text |  |  |  |  | 45 |  |  | -110.16 | 22700020
01-01-2022 | 2022 - 1 |  | 70 | [NAME] |  | 22700021 | text |  |  |  |  | 18 |  |  | -128.16 | 22700021
01-01-2022 | 2022 - 1 |  | 70 | [NAME] |  | 22700022 | text |  |  |  |  | 28.8 |  |  | -156.96 | 22700022
01-01-2022 | 2022 - 1 |  | 70 | [NAME] |  | 22700001 | text |  |  |  |  |  |  |  | -156.96 | 22700001
01-01-2022 | 2022 - 1 |  | 70 | [NAME] |  | 22700002 | text |  |  |  |  |  |  |  | -156.96 | 22700002
01-01-2022 | 2022 - 1 |  | 70 | [NAME] |  | 22700003 | text |  |  |  |  | 25.2 |  |  | -182.16 | 22700003
01-01-2022 | 2022 - 1 |  | 70 | [NAME] |  | 22700004 | text |  |  |  |  | 25.2 |  |  | -207.36 | 22700004
01-01-2022 | 2022 - 1 |  | 70 | [NAME] |  | 22700005 | text |  |  |  |  | 9.720000000000002 |  |  | -217.08 | 22700005
 |  |  |  |  |  |  |  | Totaal |  | 8300.9376 |  | 31629.06
 |  |  |  |  |  |  | [NAME] |  |  |  |  | -23328.1224
8010 - drop
02-01-2022 | 2022 - 1 |  | 70 | [NAME] |  | 22700054 | text |  |  |  |  |  |  |  | 0 | 22700054
03-01-2022 | 2022 - 1 |  | 70 | [NAME] |  | 22700078 | text |  |  |  |  |  |  |  | 0 | 22700078
03-01-2022 | 2022 - 1 |  | 70 | [NAME] |  | 22700080 | text |  |  |  |  |  |  |  | 0 | 22700080
03-01-2022 | 2022 - 1 |  | 70 | [NAME] |  | 22700082 | text |  |  |  |  |  |  |  | 0 | 22700082
03-01-2022 | 2022 - 1 |  | 70 | [NAME] |  | 22700073 | text |  |  |  |  |  |  |  | 0 | 22700073
03-01-2022 | 2022 - 1 |  | 70 | [NAME] |  | 22700081 | text |  |  |  |  |  |  |  | 0 | 22700081
04-01-2022 | 2022 - 1 |  | 70 | [NAME] |  | 22700122 | text |  |  |  |  |  |  |  | 0 | 22700122
04-01-2022 | 2022 - 1 |  | 70 | [NAME] |  | 22700124 | text |  |  |  |  |  |  |  | 0 | 22700124
04-01-2022 | 2022 - 1 |  | 70 | [NAME] |  | 22700126 | text |  |  |  |  |  |  |  | 0 | 22700126
05-01-2022 | 2022 - 1 |  | 70 | [NAME] |  | 22700171 | text |  |  |  |  |  |  |  | 0 | 22700171
05-01-2022 | 2022 - 1 |  | 70 | [NAME] |  | 22700172 | text |  |  |  |  |  |  |  | 0 | 22700172
 |  |  |  |  |  |  |  | Totaal |  | 43.14 |  | 99.678
 |  |  |  |  |  |  | [NAME] |  |  |  |  | -56.538
8020 - hatseflats
06-02-2022 | 2022 - 2 |  | 70 | [NAME] |  | 22701680 | text |  |  |  |  | 94.5 |  |  | -2997.192 | 22701680
06-02-2022 | 2022 - 2 |  | 70 | [NAME] |  | 22701681 | text |  |  |  |  | 42 |  |  | -3039.192 | 22701681
06-02-2022 | 2022 - 2 |  | 70 | [NAME] |  | 22701682 | text |  |  |  |  | 84 |  |  | -3123.192 | 22701682
06-02-2022 | 2022 - 2 |  | 70 | [NAME] |  | 22701683 | text |  |  |  |  |  |  |  | -3123.192 | 22701683
06-02-2022 | 2022 - 2 |  | 70 | [NAME] |  | 22701684 | text |  |  |  |  | 94.5 |  |  | -3217.692 | 22701684
06-02-2022 | 2022 - 2 |  | 70 | [NAME] |  | 22701698 | text |  |  |  |  |  |  |  | -3217.692 | 22701698
07-02-2022 | 2022 - 2 |  | 70 | [NAME] |  | 22701703 | text |  |  |  |  | 105 |  |  | -3322.692 | 22701703
07-02-2022 | 2022 - 2 |  | 70 | [NAME] |  | 22701704 | text |  |  |  |  | 39.59999999999999 |  |  | -3362.291999999999 | 22701704
07-02-2022 | 2022 - 2 |  | 70 | [NAME] |  | 22701705 | text |  |  |  |  |  |  |  | -3362.291999999999 | 22701705
07-02-2022 | 2022 - 2 |  | 70 | [NAME] |  | 22701706 | text |  |  |  |  | 294 |  |  | -3656.291999999999 | 22701706
07-02-2022 | 2022 - 2 |  | 70 | [NAME] |  | 22701707 | text |  |  |  |  | 23.4 |  |  | -3679.692 | 22701707
07-02-2022 | 2022 - 2 |  | 70 | [NAME] |  | 22701708 | text |  |  |  |  | 50.40000000000001 |  |  | -3730.092 | 22701708
07-02-2022 | 2022 - 2 |  | 70 | [NAME] |  | 22701709 | text |  |  |  |  | 45 |  |  | -3775.092 | 22701709
07-02-2022 | 2022 - 2 |  | 70 | [NAME] |  | 22701701 | text |  |  |  |  | 142.56 |  |  | -3917.652 | 22701701
07-02-2022 | 2022 - 2 |  | 70 | [NAME] |  | 22701740 | text |  |  |  |  |  |  |  | -3917.652 | 22701740
07-02-2022 | 2022 - 2 |  | 70 | [NAME] |  | 22701739 | text |  |  |  |  | 16.86 |  |  | -3934.512000000001 | 22701739
07-02-2022 | 2022 - 2 |  | 70 | [NAME] |  | 22701739 | text |  |  |  |  |  |  |  | -3934.512000000001 | 22701739
07-02-2022 | 2022 - 2 |  | 70 | [NAME] |  | 22701738 | text |  |  |  |  |  |  |  | -3934.512000000001 | 22701738
07-02-2022 | 2022 - 2 |  | 70 | [NAME] |  | 22701737 | text |  |  |  |  | 82.314 |  |  | -4016.826 | 22701737
07-02-2022 | 2022 - 2 |  | 70 | [NAME] |  | 22701735 | text |  |  |  |  | 45.12599999999999 |  |  | -4061.952 | 22701735
24-02-2022 | 2022 - 2 |  | 70 | [NAME] |  | 22702736 | text |  |  |  |  | 61.986 |  |  | -12806.496 | 22702736
24-02-2022 | 2022 - 2 |  | 70 | [NAME] |  | 22702726 | text |  |  |  |  | 323.802 |  |  | -13130.298 | 22702726
25-02-2022 | 2022 - 2 |  | 70 | [NAME] |  | 22702777 | text |  |  |  |  | 24.792 |  |  | -13155.09 | 22702777
25-02-2022 | 2022 - 2 |  | 70 | [NAME] |  | 22702778 | text |  |  |  |  | 122.976 |  |  | -13278.066 | 22702778
28-02-2022 | 2022 - 2 |  | 70 | [NAME] |  | 22702894 | text |  |  |  |  | 212.232 |  |  | -13490.298 | 22702894
28-02-2022 | 2022 - 2 |  | 70 | [NAME] |  | 22702896 | text |  |  | 86.77799999999999 |  |  |  |  | -13403.52 | 22702896
28-02-2022 | 2022 - 2 |  | 70 | [NAME] |  | 22702887 | text |  |  |  |  | 111.57 |  |  | -13515.09 | 22702887
28-02-2022 | 2022 - 2 |  | 70 | [NAME] |  | 22702888 | text |  |  |  |  | 156.198 |  |  | -13671.288 | 22702888
28-02-2022 | 2022 - 2 |  | 70 | [NAME] |  | 22702902 | text |  |  |  |  | 200.826 |  |  | -13872.114 | 22702902
28-02-2022 | 2022 - 2 |  | 70 | [NAME] |  | 22702903 | text |  |  | 200.826 |  |  |  |  | -13671.288 | 22702903
 |  |  |  |  |  |  |  | Totaal |  | 2638.98 |  | 16310.268
 |  |  |  |  |  |  | [NAME] |  |  |  |  | -13671.288
8030 - frietje met
13-01-2022 | 2022 - 1 |  | 70 | [NAME] |  | 22700574 | text |  |  |  |  | 47.604 |  |  | -47.604 | 22700574
31-01-2022 | 2022 - 1 |  | 70 | [NAME] |  | 22701483 | text |  |  |  |  | 29.754 |  |  | -77.358 | 22701483
19-02-2022 | 2022 - 2 |  | 70 | [NAME] |  | 22702572 | text |  |  | 47.604 |  |  |  |  | -29.754 | 22702572
 |  |  |  |  |  |  |  | Totaal |  | 47.604 |  | 77.358
 |  |  |  |  |  |  | [NAME] |  |  |  |  | -29.754
8031 - salsa
07-01-2022 | 2022 - 1 |  | 70 | [NAME] |  | 22700270 | text |  |  |  |  | 238.014 |  |  | -238.014 | 22700270
17-01-2022 | 2022 - 1 |  | 70 | [NAME] |  | 22700802 | text |  |  |  |  | 238.014 |  |  | -476.028 | 22700802
 |  |  |  |  |  |  |  | Totaal |  | 0 |  | 476.028
 |  |  |  |  |  |  | [NAME] |  |  |  |  | -476.028
8040 - bier met worst
01-01-2022 | 2022 - 1 |  | 70 | [NAME] |  | 22700026 | text |  |  |  |  |  |  |  | 0 | 22700026
01-01-2022 | 2022 - 1 |  | 70 | [NAME] |  | 22700030 | text |  |  |  |  |  |  |  | 0 | 22700030
01-01-2022 | 2022 - 1 |  | 70 | [NAME] |  | 22700028 | text |  |  |  |  |  |  |  | 0 | 22700028
01-01-2022 | 2022 - 1 |  | 70 | [NAME] |  | 22700022 | text |  |  |  |  |  |  |  | 0 | 22700022
01-01-2022 | 2022 - 1 |  | 70 | [NAME] |  | 22700021 | text |  |  |  |  |  |  |  | 0 | 22700021
01-01-2022 | 2022 - 1 |  | 70 | [NAME] |  | 22700020 | text |  |  |  |  |  |  |  | 0 | 22700020
02-01-2022 | 2022 - 1 |  | 70 | [NAME] |  | 22700048 | text |  |  |  |  |  |  |  | 0 | 22700048
02-01-2022 | 2022 - 1 |  | 70 | [NAME] |  | 22700047 | text |  |  |  |  |  |  |  | 0 | 22700047
02-01-2022 | 2022 - 1 |  | 70 | [NAME] |  | 22700046 | text |  |  |  |  |  |  |  | 0 | 22700046
02-01-2022 | 2022 - 1 |  | 70 | [NAME] |  | 22700044 | text |  |  |  |  |  |  |  | 0 | 22700044
03-01-2022 | 2022 - 1 |  | 70 | [NAME] |  | 22700069 | text |  |  |  |  |  |  |  | 0 | 22700069
03-01-2022 | 2022 - 1 |  | 70 | [NAME] |  | 22700068 | text |  |  |  |  |  |  |  | 0 | 22700068
03-01-2022 | 2022 - 1 |  | 70 | [NAME] |  | 22700071 | text |  |  |  |  |  |  |  | 0 | 22700071
03-01-2022 | 2022 - 1 |  | 70 | [NAME] |  | 22700070 | text |  |  |  |  |  |  |  | 0 | 22700070
03-01-2022 | 2022 - 1 |  | 70 | [NAME] |  | 22700072 | text |  |  |  |  |  |  |  | 0 | 22700072
03-01-2022 | 2022 - 1 |  | 70 | [NAME] |  | 22700067 | text |  |  |  |  |  |  |  | 0 | 22700067
04-01-2022 | 2022 - 1 |  | 70 | [NAME] |  | 22700114 | text |  |  |  |  |  |  |  | 0 | 22700114
04-01-2022 | 2022 - 1 |  | 70 | [NAME] |  | 22700113 | text |  |  |  |  |  |  |  | 0 | 22700113
 |  |  |  |  |  |  |  | Totaal |  | 29536.69799999994 |  | 35613.822
 |  |  |  |  |  |  | [NAME] |  |  |  |  | -6077.124