From dcfeca8cb99fc0b9180b54c6694382de968741eb Mon Sep 17 00:00:00 2001 From: Jonas Smedegaard Date: Thu, 31 Aug 2023 18:01:07 +0200 Subject: add data for 2023 --- data/2023/assets/84011036773.csv | 34 +++++++++ data/2023/assets/84011036773.csv.rules | 1 + data/2023/assets/84011036773.ledger | 134 +++++++++++++++++++++++++++++++++ data/2023/expenses/dkhm.ledger | 9 +++ data/2023/expenses/fibia.ledger | 4 + data/2023/expenses/kviknet.ledger | 40 ++++++++++ data/2023/expenses/scaleway.ledger | 31 ++++++++ data/2023/expenses/unotel.ledger | 41 ++++++++++ data/2023/journal.ledger | 7 ++ data/2023/primo.ledger | 1 + data/journal.ledger | 1 + data/merkur.rules | 1 + 12 files changed, 304 insertions(+) create mode 100644 data/2023/assets/84011036773.csv create mode 120000 data/2023/assets/84011036773.csv.rules create mode 100644 data/2023/assets/84011036773.ledger create mode 100644 data/2023/expenses/dkhm.ledger create mode 100644 data/2023/expenses/fibia.ledger create mode 100644 data/2023/expenses/kviknet.ledger create mode 100644 data/2023/expenses/scaleway.ledger create mode 100644 data/2023/expenses/unotel.ledger create mode 100644 data/2023/journal.ledger create mode 100644 data/2023/primo.ledger diff --git a/data/2023/assets/84011036773.csv b/data/2023/assets/84011036773.csv new file mode 100644 index 0000000..e681602 --- /dev/null +++ b/data/2023/assets/84011036773.csv @@ -0,0 +1,34 @@ +Dato,Tekst,Beløb,Saldo,Valørdato,Kreditorref.,End2end,Type,Adviseringer,, +02-01-2023,Gebyr iflg nota,-200.00,96401.72,02-01-2023," "," ",,,, +03-01-2023,BS UNOTEL A/S,-597.00,95804.72,03-01-2023," "," ",PBS,"UNOTEL FAKTURA NR. 4807043FOR ADSL GÆLDER:PERIODEN 19/09-22 TIL 19/12-22ABNR.: DSL39785 MBIT/S 597,00 KR.FAKTURABELØB 597,00 KR.MOMSPLIGTIGT BELØB 477,60 KR.MOMSFRIT BELØB (MARKERET MED *) 0,00 KR.MOMS 25% 119,40 KR.",, +06-01-2023,Forretning: SCALEWAY,-36.08,95768.64,06-01-2023," "," ",,,, +23-01-2023,DK-NOTAa2672 FIBIA P/S,-151.40,95617.24,23-01-2023," "," ",,,, +31-01-2023,DK-NOTA17043 KVIKNET.DK APS,-18.05,95599.19,31-01-2023," "," ",,,, +07-02-2023,Forretning: SCALEWAY,-35.68,95563.51,07-02-2023," "," ",,,, +28-02-2023,DK-NOTA17393 KVIKNET.DK APS,-20.00,95543.51,28-02-2023," "," ",,,, +28-02-2023,DK-NOTAP2086 DK HOSTMASTER A/S,-210.00,95333.51,28-02-2023," "," ",,,, +07-03-2023,Forretning: SCALEWAY,-32.41,95301.10,07-03-2023," "," ",,,, +13-03-2023,"MOMS, SKATTEKONTOEN",3018.00,98319.10,13-03-2023," ","1149230705-7000209533 ",OVF.,"SKATTEFORVALTNINGEN BRÆNDGÅRDVEJ 10 7400 HERNING ",, +20-03-2023,privat,-5000.00,93319.10,20-03-2023," ","1149230705-7000209533 ",,,, +20-03-2023,privat,-10000.00,83319.10,20-03-2023," ","1149230705-7000209533 ",,,, +31-03-2023,DK-NOTA17757 KVIKNET.DK APS,-20.00,83299.10,31-03-2023," ","1149230705-7000209533 ",,,, +03-04-2023,BS UNOTEL A/S,-597.00,82702.10,03-04-2023," ","1149230705-7000209533 ",PBS,"UNOTEL FAKTURA NR. 4827461FOR ADSL GÆLDER:PERIODEN 19/12-22 TIL 19/03-23ABNR.: DSL39785 MBIT/S 597,00 KR.FAKTURABELØB 597,00 KR.MOMSPLIGTIGT BELØB 477,60 KR.MOMSFRIT BELØB (MARKERET MED *) 0,00 KR.MOMS 25% 119,40 KR.",, +12-04-2023,Forretning: SCALEWAY,-35.93,82666.17,12-04-2023," "," ",,,, +18-04-2023,ASSOCIATION DEBI,2603.42,85269.59,18-04-2023," "," ",,,, +24-04-2023,DK-NOTAP2212 DK HOSTMASTER A/S,-70.00,85199.59,24-04-2023," "," ",,,, +28-04-2023,DK-NOTA18107 KVIKNET.DK APS,-316.10,84883.49,28-04-2023," "," ",,,, +09-05-2023,Forretning: SCALEWAY,-34.56,84848.93,09-05-2023," "," ",,,, +31-05-2023,DK-NOTA18512 KVIKNET.DK APS,-349.00,84499.93,31-05-2023," "," ",,,, +07-06-2023,Forretning: SCALEWAY,-35.74,84464.19,07-06-2023," "," ",,,, +09-06-2023,Til Privat,-10000.00,74464.19,09-06-2023," "," ",,,, +19-06-2023,privat,-5000.00,69464.19,19-06-2023," "," ",,,, +03-07-2023,DK-NOTA18930 KVIKNET.DK APS,-374.00,69090.19,03-07-2023," "," ",,,, +04-07-2023,BS UNOTEL A/S,-597.00,68493.19,04-07-2023," "," ",PBS,"UNOTEL FAKTURA NR. 4846809FOR ADSL GÆLDER:PERIODEN 19/03-23 TIL 19/06-23ABNR.: DSL39785 MBIT/S 597,00 KR.FAKTURABELØB 597,00 KR.MOMSPLIGTIGT BELØB 477,60 KR.MOMSFRIT BELØB (MARKERET MED *) 0,00 KR.MOMS 25% 119,40 KR.",, +05-07-2023,Til Privat,-10000.00,58493.19,05-07-2023," "," ",,,, +06-07-2023,Forretning: SCALEWAY,-34.53,58458.66,06-07-2023," "," ",,,, +31-07-2023,DK-NOTA19206 KVIKNET.DK APS,-399.00,58059.66,31-07-2023," "," ",,,, +07-08-2023,Forretning: SCALEWAY,-35.75,58023.91,07-08-2023," "," ",,,, +15-08-2023,Til Privat,-10000.00,48023.91,15-08-2023," "," ",,,, +18-08-2023,DK-NOTAP2402 PUNKTUM DK,-280.00,47743.91,18-08-2023," "," ",,,, +21-08-2023,DK-NOTA 45 DAGLIB ORØ,-43.50,47700.41,21-08-2023," "," ",,,, +21-08-2023,DK-NOTAC3020 MARLIESE'S GÅRDCAF,-345.00,47355.41,21-08-2023," "," ",,,, diff --git a/data/2023/assets/84011036773.csv.rules b/data/2023/assets/84011036773.csv.rules new file mode 120000 index 0000000..e2ebe50 --- /dev/null +++ b/data/2023/assets/84011036773.csv.rules @@ -0,0 +1 @@ +../../merkur.rules \ No newline at end of file diff --git a/data/2023/assets/84011036773.ledger b/data/2023/assets/84011036773.ledger new file mode 100644 index 0000000..633c244 --- /dev/null +++ b/data/2023/assets/84011036773.ledger @@ -0,0 +1,134 @@ +D 1,000.00 DKK + +2023-01-02=2023-01-02 Gebyr iflg nota - + assets:bank:dr. jones DKK -200.00 + expenses:non-vat:bank:fees DKK 200.00 + +2023-01-03=2023-01-03 BS UNOTEL A/S - + assets:bank:dr. jones DKK -597.00 + liabilities:payable:internet DKK 597.00 + +2023-01-06=2023-01-06 Forretning: SCALEWAY - + assets:bank:dr. jones DKK -36.08 + liabilities:payable:hosting DKK 36.08 + +2023-01-23=2023-01-23 DK-NOTAa2672 FIBIA P/S - + assets:bank:dr. jones DKK -151.40 + liabilities:payable:internet DKK 151.40 + +2023-01-31=2023-01-31 DK-NOTA17043 KVIKNET.DK APS - + assets:bank:dr. jones DKK -18.05 + liabilities:payable:internet DKK 18.05 + +2023-02-07=2023-02-07 Forretning: SCALEWAY - + assets:bank:dr. jones DKK -35.68 + liabilities:payable:hosting DKK 35.68 + +2023-02-28=2023-02-28 DK-NOTA17393 KVIKNET.DK APS - + assets:bank:dr. jones DKK -20.00 + liabilities:payable:internet DKK 20.00 + +2023-02-28=2023-02-28 DK-NOTAP2086 DK HOSTMASTER A/S - + assets:bank:dr. jones DKK -210.00 + liabilities:payable:hosting DKK 210.00 + +2023-03-07=2023-03-07 Forretning: SCALEWAY - + assets:bank:dr. jones DKK -32.41 + liabilities:payable:hosting DKK 32.41 + +2023-03-13=2023-03-13 MOMS, SKATTEKONTOEN - 1149230705-7000209533 + assets:bank:dr. jones DKK 3018.00 + assets:advances:unknown DKK -3018.00 + +2023-03-20=2023-03-20 privat - 1149230705-7000209533 + assets:bank:dr. jones DKK -5000.00 + assets:advances:jonas DKK 5000.00 + +2023-03-20=2023-03-20 privat - 1149230705-7000209533 + assets:bank:dr. jones DKK -10000.00 + assets:advances:jonas DKK 10000.00 + +2023-03-31=2023-03-31 DK-NOTA17757 KVIKNET.DK APS - 1149230705-7000209533 + assets:bank:dr. jones DKK -20.00 + liabilities:payable:internet DKK 20.00 + +2023-04-03=2023-04-03 BS UNOTEL A/S - 1149230705-7000209533 + assets:bank:dr. jones DKK -597.00 + liabilities:payable:internet DKK 597.00 + +2023-04-12=2023-04-12 Forretning: SCALEWAY - + assets:bank:dr. jones DKK -35.93 + liabilities:payable:hosting DKK 35.93 + +2023-04-18=2023-04-18 ASSOCIATION DEBI - + assets:bank:dr. jones DKK 2603.42 + assets:advances:unknown DKK -2603.42 + +2023-04-24=2023-04-24 DK-NOTAP2212 DK HOSTMASTER A/S - + assets:bank:dr. jones DKK -70.00 + liabilities:payable:hosting DKK 70.00 + +2023-04-28=2023-04-28 DK-NOTA18107 KVIKNET.DK APS - + assets:bank:dr. jones DKK -316.10 + liabilities:payable:internet DKK 316.10 + +2023-05-09=2023-05-09 Forretning: SCALEWAY - + assets:bank:dr. jones DKK -34.56 + liabilities:payable:hosting DKK 34.56 + +2023-05-31=2023-05-31 DK-NOTA18512 KVIKNET.DK APS - + assets:bank:dr. jones DKK -349.00 + liabilities:payable:internet DKK 349.00 + +2023-06-07=2023-06-07 Forretning: SCALEWAY - + assets:bank:dr. jones DKK -35.74 + liabilities:payable:hosting DKK 35.74 + +2023-06-09=2023-06-09 Til Privat - + assets:bank:dr. jones DKK -10000.00 + assets:advances:jonas DKK 10000.00 + +2023-06-19=2023-06-19 privat - + assets:bank:dr. jones DKK -5000.00 + assets:advances:jonas DKK 5000.00 + +2023-07-03=2023-07-03 DK-NOTA18930 KVIKNET.DK APS - + assets:bank:dr. jones DKK -374.00 + liabilities:payable:internet DKK 374.00 + +2023-07-04=2023-07-04 BS UNOTEL A/S - + assets:bank:dr. jones DKK -597.00 + liabilities:payable:internet DKK 597.00 + +2023-07-05=2023-07-05 Til Privat - + assets:bank:dr. jones DKK -10000.00 + assets:advances:jonas DKK 10000.00 + +2023-07-06=2023-07-06 Forretning: SCALEWAY - + assets:bank:dr. jones DKK -34.53 + liabilities:payable:hosting DKK 34.53 + +2023-07-31=2023-07-31 DK-NOTA19206 KVIKNET.DK APS - + assets:bank:dr. jones DKK -399.00 + liabilities:payable:internet DKK 399.00 + +2023-08-07=2023-08-07 Forretning: SCALEWAY - + assets:bank:dr. jones DKK -35.75 + liabilities:payable:hosting DKK 35.75 + +2023-08-15=2023-08-15 Til Privat - + assets:bank:dr. jones DKK -10000.00 + assets:advances:jonas DKK 10000.00 + +2023-08-18=2023-08-18 DK-NOTAP2402 PUNKTUM DK - + assets:bank:dr. jones DKK -280.00 + assets:advances:unknown DKK 280.00 + +2023-08-21=2023-08-21 DK-NOTA 45 DAGLIB ORØ - + assets:bank:dr. jones DKK -43.50 + assets:advances:unknown DKK 43.50 + +2023-08-21=2023-08-21 DK-NOTAC3020 MARLIESE'S GÅRDCAF - + assets:bank:dr. jones DKK -345.00 + assets:advances:unknown DKK 345.00 + diff --git a/data/2023/expenses/dkhm.ledger b/data/2023/expenses/dkhm.ledger new file mode 100644 index 0000000..1b0f95a --- /dev/null +++ b/data/2023/expenses/dkhm.ledger @@ -0,0 +1,9 @@ +02-15=02-28 dkhm 2086779 + liabilities:payable:hosting + expenses:internet 168 + liabilities:tax:expenses 42 + +04-17=04-24 dkhm 2212779 + liabilities:payable:hosting + expenses:internet 56 + liabilities:tax:expenses 14 diff --git a/data/2023/expenses/fibia.ledger b/data/2023/expenses/fibia.ledger new file mode 100644 index 0000000..4631e95 --- /dev/null +++ b/data/2023/expenses/fibia.ledger @@ -0,0 +1,4 @@ +01-09=01-23 fibia 05053455 + liabilities:payable:internet + expenses:internet 121,12 + liabilities:tax:expenses 30,28 diff --git a/data/2023/expenses/kviknet.ledger b/data/2023/expenses/kviknet.ledger new file mode 100644 index 0000000..f1c573c --- /dev/null +++ b/data/2023/expenses/kviknet.ledger @@ -0,0 +1,40 @@ +01-24=01-31 kviknet KN1374149 + liabilities:payable:internet + expenses:internet 14,45 + liabilities:tax:expenses 3,61 + expenses:non-vat:rounding -0,01 + +02-21=02-28 kviknet KN1408729 + liabilities:payable:internet + expenses:internet 16 + liabilities:tax:expenses 4 + +03-24=03-31 kviknet KN1443387 + liabilities:payable:internet + expenses:internet 16 + liabilities:tax:expenses 4 + +04-21=04-28 kviknet KN1478093OB + liabilities:payable:internet + expenses:internet 252,88 + liabilities:tax:expenses 63,22 + +05-24=05-31 kviknet KN1513645 + liabilities:payable:internet + expenses:internet 279,20 + liabilities:tax:expenses 69,80 + +06-23=07-03 kviknet KN1548959 + liabilities:payable:internet + expenses:internet 299,20 + liabilities:tax:expenses 74,80 + +07-24=07-31 kviknet KN1580633 + liabilities:payable:internet + expenses:internet 319,20 + liabilities:tax:expenses 79,80 + +08-24 kviknet KN1611808 + liabilities:payable:internet + expenses:internet 319,20 + liabilities:tax:expenses 79,80 diff --git a/data/2023/expenses/scaleway.ledger b/data/2023/expenses/scaleway.ledger new file mode 100644 index 0000000..282a89a --- /dev/null +++ b/data/2023/expenses/scaleway.ledger @@ -0,0 +1,31 @@ +01-03=01-06 scaleway 2088905 + liabilities:payable:hosting + expenses:eu-vat:hosting 4,78 EUR @@ 36,08 + +02-03=02-07 scaleway 2114988 + liabilities:payable:hosting + expenses:eu-vat:hosting 4,75 EUR @@ 35,68 + +03-03=03-07 scaleway 2139359 + liabilities:payable:hosting + expenses:eu-vat:hosting 4,29 EUR @@ 32,41 + +04-04=04-12 scaleway 2169539 + liabilities:payable:hosting + expenses:eu-vat:hosting 4,75 EUR @@ 35,93 + +05-03=05-09 scaleway 2194675 + liabilities:payable:hosting + expenses:eu-vat:hosting 4,59 EUR @@ 34,56 + +06-02=06-07 scaleway 2229907 + liabilities:payable:hosting + expenses:eu-vat:hosting 4,75 EUR @@ 35,74 + +07-04=07-06 scaleway 2263283 + liabilities:payable:hosting + expenses:eu-vat:hosting 4,59 EUR @@ 34,53 + +08-02=08-07 scaleway 2282045 + liabilities:payable:hosting + expenses:eu-vat:hosting 4,75 EUR @@ 35,75 diff --git a/data/2023/expenses/unotel.ledger b/data/2023/expenses/unotel.ledger new file mode 100644 index 0000000..f0e8b82 --- /dev/null +++ b/data/2023/expenses/unotel.ledger @@ -0,0 +1,41 @@ +01-01 unot 4809432 + assets:advances:jonas + expenses:non-vat:phone 99 + +02-02 unot 4816994 + assets:advances:jonas + expenses:non-vat:phone 99 + +03-01 unot 4824806 + assets:advances:jonas + expenses:non-vat:phone 99 + +03-19=04-03 unot 4827461 + liabilities:payable:internet + expenses:internet 477,60 + liabilities:tax:expenses 119,40 + +04-01 unot 4830198 + assets:advances:jonas + expenses:non-vat:phone 99 + +05-01 unot 4836387 + assets:advances:jonas + expenses:non-vat:phone 99 + +06-03 unot 4845122 + assets:advances:jonas + expenses:non-vat:phone 99 + +06-19=07-04 unot 4846809 + liabilities:payable:internet + expenses:internet 477,60 + liabilities:tax:expenses 119,40 + +07-01 unot 4849134 + assets:advances:jonas + expenses:non-vat:phone 99 + +08-01 unot 4856041 + assets:advances:jonas + expenses:non-vat:phone 99 diff --git a/data/2023/journal.ledger b/data/2023/journal.ledger new file mode 100644 index 0000000..956580f --- /dev/null +++ b/data/2023/journal.ledger @@ -0,0 +1,7 @@ +Y2023 +D 1.000,00 DKK +include primo.ledger +include assets/*.ledger +#include income/*.ledger +include expenses/*.ledger +#include ultimo.ledger diff --git a/data/2023/primo.ledger b/data/2023/primo.ledger new file mode 100644 index 0000000..6d85b37 --- /dev/null +++ b/data/2023/primo.ledger @@ -0,0 +1 @@ +Y2022 diff --git a/data/journal.ledger b/data/journal.ledger index d681e1e..134d0ff 100644 --- a/data/journal.ledger +++ b/data/journal.ledger @@ -21,3 +21,4 @@ include 2019/journal.ledger include 2020/journal.ledger include 2021/journal.ledger include 2022/journal.ledger +include 2023/journal.ledger diff --git a/data/merkur.rules b/data/merkur.rules index 70ea6ff..6c6c2d9 100644 --- a/data/merkur.rules +++ b/data/merkur.rules @@ -72,6 +72,7 @@ internet persp BETALT GIROKORT inet \bFIBIA\b BS UNOTEL +KVIKNET.DK APS Unotel ADSL account2 liabilities:payable:internet -- cgit v1.2.3