summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorJonas Smedegaard <dr@jones.dk>2023-08-31 18:01:07 +0200
committerJonas Smedegaard <dr@jones.dk>2023-08-31 18:01:07 +0200
commitdcfeca8cb99fc0b9180b54c6694382de968741eb (patch)
treee9db08ee96d18a6145e10d73e1c9aadae19d5898
parent83e958a59cb212725e5be5233667b884df0c69c4 (diff)
add data for 2023
-rw-r--r--data/2023/assets/84011036773.csv34
l---------data/2023/assets/84011036773.csv.rules1
-rw-r--r--data/2023/assets/84011036773.ledger134
-rw-r--r--data/2023/expenses/dkhm.ledger9
-rw-r--r--data/2023/expenses/fibia.ledger4
-rw-r--r--data/2023/expenses/kviknet.ledger40
-rw-r--r--data/2023/expenses/scaleway.ledger31
-rw-r--r--data/2023/expenses/unotel.ledger41
-rw-r--r--data/2023/journal.ledger7
-rw-r--r--data/2023/primo.ledger1
-rw-r--r--data/journal.ledger1
-rw-r--r--data/merkur.rules1
12 files changed, 304 insertions, 0 deletions
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