diff options
32 files changed, 957 insertions, 270 deletions
diff --git a/bin/mywise2csv b/bin/mywise2csv new file mode 100755 index 0000000..282229f --- /dev/null +++ b/bin/mywise2csv @@ -0,0 +1,10 @@ +#!/bin/sh + +set -e + +infile="$1" +dirname=$(dirname "$infile") +basename=$(basename "$infile" .csv) +outfile="${2:-$dirname/${basename}_out.csv}" + +csvcut "$infile" > "$outfile" diff --git a/data/2023/assets/84011036773.ledger b/data/2023/assets/84011036773.ledger index e782658..a7ceb4f 100644 --- a/data/2023/assets/84011036773.ledger +++ b/data/2023/assets/84011036773.ledger @@ -121,12 +121,12 @@ D 1,000.00 DKK 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 + assets:bank:dr. jones DKK -280.00 + liabilities:payable:hosting 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 + assets:bank:dr. jones DKK -43.50 + assets:advances:jonas DKK 43.50 2023-08-21=2023-08-21 DK-NOTAC3020 MARLIESE'S GÅRDCAF - assets:bank:dr. jones DKK -345.00 @@ -169,8 +169,8 @@ D 1,000.00 DKK liabilities:payable:internet DKK 399.00 2023-12-05=2023-12-05 DK-NOTAP2534 PUNKTUM DK - - assets:bank:dr. jones DKK -70.00 - assets:advances:unknown DKK 70.00 + assets:bank:dr. jones DKK -70.00 + liabilities:payable:hosting DKK 70.00 2023-12-06=2023-12-06 Forretning: SCALEWAY - assets:bank:dr. jones DKK -34.57 diff --git a/data/2023/assets/banking.rules b/data/2023/assets/banking.rules new file mode 120000 index 0000000..95d408b --- /dev/null +++ b/data/2023/assets/banking.rules @@ -0,0 +1 @@ +../../banking.rules
\ No newline at end of file diff --git a/data/2023/expenses/punktum.ledger b/data/2023/expenses/punktum.ledger index fb428c4..e8f00ea 100644 --- a/data/2023/expenses/punktum.ledger +++ b/data/2023/expenses/punktum.ledger @@ -18,7 +18,7 @@ expenses:internet 56 liabilities:tax:expenses 14 -12-18 dkhm 2605390 +12-18=2024-01-02 dkhm 2605390 liabilities:payable:hosting expenses:internet 56 liabilities:tax:expenses 14 diff --git a/data/2024/assets/25541916.csv b/data/2024/assets/25541916.csv new file mode 100644 index 0000000..22174e9 --- /dev/null +++ b/data/2024/assets/25541916.csv @@ -0,0 +1,28 @@ +TransferWise ID,Date,Date Time,Amount,Currency,Description,Payment Reference,Running Balance,Exchange From,Exchange To,Exchange Rate,Payer Name,Payee Name,Payee Account Number,Merchant,Card Last Four Digits,Card Holder Full Name,Attachment,Note,Total fees,Exchange To Amount +CARD-1949956883,04-11-2024,04-11-2024 17:31:15.314,-35.42,DKK,Card transaction of EUR issued by Scaleway +,,28.05,DKK,EUR,0.13409,,,,Scaleway +33184130050,2607,Jonas Smedegaard,,,0.15,4.75 +FEE-CARD-1949956883,04-11-2024,04-11-2024 17:31:15.313,-0.15,DKK,Wise Charges for: CARD-1949956883,,63.47,,,,,,,Scaleway +33184130050,2607,Jonas Smedegaard,,,0, +CARD-1888137594,13-10-2024,13-10-2024 17:53:34.108,-85.27,DKK,Card transaction of USD issued by Rch-Kagicom +,,63.62,DKK,USD,0.14660,,,,Rch-Kagi.com +16505352700,2607,Jonas Smedegaard,,,0.37,12.50 +FEE-CARD-1888137594,13-10-2024,13-10-2024 17:53:34.107,-0.37,DKK,Wise Charges for: CARD-1888137594,,148.89,,,,,,,Rch-Kagi.com +16505352700,2607,Jonas Smedegaard,,,0, +CARD-1861051841,04-10-2024,04-10-2024 09:34:03.029,-34.24,DKK,Card transaction of EUR issued by Scaleway +,,149.26,DKK,EUR,0.13405,,,,Scaleway +33184130050,2607,Jonas Smedegaard,,,0.14,4.59 +FEE-CARD-1861051841,04-10-2024,04-10-2024 09:34:03.028,-0.14,DKK,Wise Charges for: CARD-1861051841,,183.50,,,,,,,Scaleway +33184130050,2607,Jonas Smedegaard,,,0, +CARD-1813176060,17-09-2024,17-09-2024 16:51:33.232,-61.61,DKK,Card transaction of USD issued by Aliexpress Luxembourg,,183.64,DKK,USD,0.14901,,,,Aliexpress Luxembourg,2607,Jonas Smedegaard,,,0.26,9.18 +FEE-CARD-1813176060,17-09-2024,17-09-2024 16:51:33.231,-0.26,DKK,Wise Charges for: CARD-1813176060,,245.25,,,,,,,Aliexpress Luxembourg,2607,Jonas Smedegaard,,,0, +CARD-1801988148,13-09-2024,13-09-2024 17:54:37.305,-84.17,DKK,Card transaction of USD issued by Rch-Kagicom +,,245.51,DKK,USD,0.14851,,,,Rch-Kagi.com +16505352700,2607,Jonas Smedegaard,,,0.36,12.50 +FEE-CARD-1801988148,13-09-2024,13-09-2024 17:54:37.304,-0.36,DKK,Wise Charges for: CARD-1801988148,,329.68,,,,,,,Rch-Kagi.com +16505352700,2607,Jonas Smedegaard,,,0, +CARD-1770393945,02-09-2024,02-09-2024 14:49:57.857,-35.43,DKK,Card transaction of EUR issued by Scaleway +,,330.04,DKK,EUR,0.13407,,,,Scaleway +33184130050,2607,Jonas Smedegaard,,,0.15,4.75 +FEE-CARD-1770393945,02-09-2024,02-09-2024 14:49:57.856,-0.15,DKK,Wise Charges for: CARD-1770393945,,365.47,,,,,,,Scaleway +33184130050,2607,Jonas Smedegaard,,,0, +CARD-1714223288,13-08-2024,13-08-2024 18:05:33.030,-85.03,DKK,Card transaction of USD issued by Rch-Kagicom +,,365.62,DKK,USD,0.14701,,,,Rch-Kagi.com +16505352700,2607,Jonas Smedegaard,,,0.37,12.50 +FEE-CARD-1714223288,13-08-2024,13-08-2024 18:05:33.029,-0.37,DKK,Wise Charges for: CARD-1714223288,,450.65,,,,,,,Rch-Kagi.com +16505352700,2607,Jonas Smedegaard,,,0, +CARD-1689550216,05-08-2024,05-08-2024 09:59:40.002,-35.44,DKK,Card transaction of EUR issued by Scaleway +,,451.02,DKK,EUR,0.13402,,,,Scaleway +33184130050,2607,Jonas Smedegaard,,,0.15,4.75 +FEE-CARD-1689550216,05-08-2024,05-08-2024 09:59:40.001,-0.15,DKK,Wise Charges for: CARD-1689550216,,486.46,,,,,,,Scaleway +33184130050,2607,Jonas Smedegaard,,,0, +CARD-1625056475,13-07-2024,13-07-2024 17:53:02.688,-50.35,DKK,Card transaction of USD issued by Rch-Kagicom +,,486.61,DKK,USD,0.14617,,,,Rch-Kagi.com +16505352700,2607,Jonas Smedegaard,,,0.22,7.36 +FEE-CARD-1625056475,13-07-2024,13-07-2024 17:53:02.687,-0.22,DKK,Wise Charges for: CARD-1625056475,,536.96,,,,,,,Rch-Kagi.com +16505352700,2607,Jonas Smedegaard,,,0, +CARD-1540896451,13-06-2024,13-06-2024 17:53:31.608,-86.88,DKK,Card transaction of USD issued by Rch-Kagicom +,,537.18,DKK,USD,0.14388,,,,Rch-Kagi.com +16505352700,2607,Jonas Smedegaard,,,0.40,12.50 +FEE-CARD-1540896451,13-06-2024,13-06-2024 17:53:31.607,-0.40,DKK,Wise Charges for: CARD-1540896451,,624.06,,,,,,,Rch-Kagi.com +16505352700,2607,Jonas Smedegaard,,,0, +CARD-1458053938,13-05-2024,13-05-2024 17:53:27.638,-86.39,DKK,Card transaction of USD issued by Rch-Kagicom +,,624.46,DKK,USD,0.14469,,,,Rch-Kagi.com +16505352700,2607,Jonas Smedegaard,,,0.40,12.50 +FEE-CARD-1458053938,13-05-2024,13-05-2024 17:53:27.637,-0.40,DKK,Wise Charges for: CARD-1458053938,,710.85,,,,,,,Rch-Kagi.com +16505352700,2607,Jonas Smedegaard,,,0, +CARD-1384700886,13-04-2024,13-04-2024 17:53:54.716,-70.11,DKK,Card transaction of USD issued by Kagicom +,,711.25,DKK,USD,0.14262,,,,Kagi.com +16505352700,2607,Jonas Smedegaard,,,0.34,10.00 +FEE-CARD-1384700886,13-04-2024,13-04-2024 17:53:54.715,-0.34,DKK,Wise Charges for: CARD-1384700886,,781.36,,,,,,,Kagi.com +16505352700,2607,Jonas Smedegaard,,,0, +CARD-1373107570,08-04-2024,08-04-2024 19:23:13.303,-218.30,DKK,Card transaction of DKK issued by Post Dk Told KOBENHAVN V,,781.70,,,,,,,Post Dk Told KOBENHAVN V,2607,Jonas Smedegaard,,,0.00, +TRANSFER-1028354332,08-04-2024,08-04-2024 19:22:28.278,1005.70,DKK,Topped up balance,,1000.00,,,,,,,,,,,,5.70, +FEE-TRANSFER-1028354332,08-04-2024,08-04-2024 19:22:28.277,-5.70,DKK,Wise Charges for: TRANSFER-1028354332,,-5.70,,,,,,,,,,,,0, diff --git a/data/2024/assets/25541916.csv.rules b/data/2024/assets/25541916.csv.rules new file mode 120000 index 0000000..d0ed647 --- /dev/null +++ b/data/2024/assets/25541916.csv.rules @@ -0,0 +1 @@ +../../wise.rules
\ No newline at end of file diff --git a/data/2024/assets/25541916.ledger b/data/2024/assets/25541916.ledger new file mode 100644 index 0000000..ebfe522 --- /dev/null +++ b/data/2024/assets/25541916.ledger @@ -0,0 +1,110 @@ +D 1,000.00 DKK + +2024-04-08=2024-04-08 Wise Charges for: TRANSFER-1028354332 + assets:bank:dr. jones DKK-5.70 + expenses:non-vat:bank:fees DKK5.70 + +2024-04-08=2024-04-08 Topped up balance + assets:bank:dr. jones DKK1005.70 + assets:advances:unknown DKK-1005.70 + +2024-04-08=2024-04-08 Card transaction of DKK issued by Post Dk Told KOBENHAVN V + assets:bank:dr. jones DKK-218.30 + assets:advances:unknown DKK218.30 + +2024-04-13=2024-04-13 Wise Charges for: CARD-1384700886 + assets:bank:dr. jones DKK-0.34 + expenses:non-vat:bank:fees DKK0.34 + +2024-04-13=2024-04-13 Card transaction of USD issued by Kagicom + + assets:bank:dr. jones DKK-70.11 + assets:advances:jonas DKK70.11 + +2024-05-13=2024-05-13 Wise Charges for: CARD-1458053938 + assets:bank:dr. jones DKK-0.40 + expenses:non-vat:bank:fees DKK0.40 + +2024-05-13=2024-05-13 Card transaction of USD issued by Rch-Kagicom + + assets:bank:dr. jones DKK-86.39 + assets:advances:jonas DKK86.39 + +2024-06-13=2024-06-13 Wise Charges for: CARD-1540896451 + assets:bank:dr. jones DKK-0.40 + expenses:non-vat:bank:fees DKK0.40 + +2024-06-13=2024-06-13 Card transaction of USD issued by Rch-Kagicom + + assets:bank:dr. jones DKK-86.88 + assets:advances:jonas DKK86.88 + +2024-07-13=2024-07-13 Wise Charges for: CARD-1625056475 + assets:bank:dr. jones DKK-0.22 + expenses:non-vat:bank:fees DKK0.22 + +2024-07-13=2024-07-13 Card transaction of USD issued by Rch-Kagicom + + assets:bank:dr. jones DKK-50.35 + assets:advances:jonas DKK50.35 + +2024-08-05=2024-08-05 Wise Charges for: CARD-1689550216 + assets:bank:dr. jones DKK-0.15 + expenses:non-vat:bank:fees DKK0.15 + +2024-08-05=2024-08-05 Card transaction of EUR issued by Scaleway + + assets:bank:dr. jones DKK-35.44 + liabilities:payable:hosting DKK35.44 + +2024-08-13=2024-08-13 Wise Charges for: CARD-1714223288 + assets:bank:dr. jones DKK-0.37 + expenses:non-vat:bank:fees DKK0.37 + +2024-08-13=2024-08-13 Card transaction of USD issued by Rch-Kagicom + + assets:bank:dr. jones DKK-85.03 + assets:advances:jonas DKK85.03 + +2024-09-02=2024-09-02 Wise Charges for: CARD-1770393945 + assets:bank:dr. jones DKK-0.15 + expenses:non-vat:bank:fees DKK0.15 + +2024-09-02=2024-09-02 Card transaction of EUR issued by Scaleway + + assets:bank:dr. jones DKK-35.43 + liabilities:payable:hosting DKK35.43 + +2024-09-13=2024-09-13 Wise Charges for: CARD-1801988148 + assets:bank:dr. jones DKK-0.36 + expenses:non-vat:bank:fees DKK0.36 + +2024-09-13=2024-09-13 Card transaction of USD issued by Rch-Kagicom + + assets:bank:dr. jones DKK-84.17 + assets:advances:jonas DKK84.17 + +2024-09-17=2024-09-17 Wise Charges for: CARD-1813176060 + assets:bank:dr. jones DKK-0.26 + expenses:non-vat:bank:fees DKK0.26 + +2024-09-17=2024-09-17 Card transaction of USD issued by Aliexpress Luxembourg + assets:bank:dr. jones DKK-61.61 + assets:advances:unknown DKK61.61 + +2024-10-04=2024-10-04 Wise Charges for: CARD-1861051841 + assets:bank:dr. jones DKK-0.14 + expenses:non-vat:bank:fees DKK0.14 + +2024-10-04=2024-10-04 Card transaction of EUR issued by Scaleway + + assets:bank:dr. jones DKK-34.24 + liabilities:payable:hosting DKK34.24 + +2024-10-13=2024-10-13 Wise Charges for: CARD-1888137594 + assets:bank:dr. jones DKK-0.37 + expenses:non-vat:bank:fees DKK0.37 + +2024-10-13=2024-10-13 Card transaction of USD issued by Rch-Kagicom + + assets:bank:dr. jones DKK-85.27 + assets:advances:jonas DKK85.27 + +2024-11-04=2024-11-04 Wise Charges for: CARD-1949956883 + assets:bank:dr. jones DKK-0.15 + expenses:non-vat:bank:fees DKK0.15 + +2024-11-04=2024-11-04 Card transaction of EUR issued by Scaleway + + assets:bank:dr. jones DKK-35.42 + liabilities:payable:hosting DKK35.42 + diff --git a/data/2024/assets/25541958.csv b/data/2024/assets/25541958.csv new file mode 100644 index 0000000..85612fa --- /dev/null +++ b/data/2024/assets/25541958.csv @@ -0,0 +1,16 @@ +TransferWise ID,Date,Date Time,Amount,Currency,Description,Payment Reference,Running Balance,Exchange From,Exchange To,Exchange Rate,Payer Name,Payee Name,Payee Account Number,Merchant,Card Last Four Digits,Card Holder Full Name,Attachment,Note,Total fees,Exchange To Amount +TRANSFER-1338346000,16-12-2024,16-12-2024 14:59:44.205,46.50,EUR,Received money from Jonas Smedegaard with reference ,,46.50,,,,Jonas Smedegaard,,,,,,,,0.00, +CARD-1625056475,13-07-2024,13-07-2024 17:53:02.685,-4.71,EUR,Card transaction of USD issued by Rch-Kagicom +,,0.00,EUR,USD,1.09070,,,,Rch-Kagi.com +16505352700,2607,Jonas Smedegaard,,,0.02,5.14 +FEE-CARD-1625056475,13-07-2024,13-07-2024 17:53:02.684,-0.02,EUR,Wise Charges for: CARD-1625056475,,4.71,,,,,,,Rch-Kagi.com +16505352700,2607,Jonas Smedegaard,,,0, +CARD-1591850255,02-07-2024,02-07-2024 10:18:05.585,-4.59,EUR,Card transaction of EUR issued by Scaleway +,,4.73,,,,,,,Scaleway +33184130050,2607,Jonas Smedegaard,,,0.00, +CARD-1515851340,04-06-2024,04-06-2024 14:45:45.363,-4.75,EUR,Card transaction of EUR issued by Scaleway +,,9.32,,,,,,,Scaleway +33184130050,2607,Jonas Smedegaard,,,0.00, +CARD-1438771679,06-05-2024,06-05-2024 09:23:47.913,-4.59,EUR,Card transaction of EUR issued by Scaleway +,,14.07,,,,,,,Scaleway +33184130050,2607,Jonas Smedegaard,,,0.00, +CARD-1373060816,08-04-2024,08-04-2024 18:59:59.260,-31.08,EUR,Card transaction of DKK issued by Post Dk Told KOBENHAVN V,,18.66,EUR,DKK,7.45890,,,,Post Dk Told KOBENHAVN V,2607,Jonas Smedegaard,,,0.17,231.80 +FEE-CARD-1373060816,08-04-2024,08-04-2024 18:59:59.259,-0.17,EUR,Wise Charges for: CARD-1373060816,,49.74,,,,,,,Post Dk Told KOBENHAVN V,2607,Jonas Smedegaard,,,0, +CARD-1362526457,05-04-2024,05-04-2024 14:54:46.444,1.00,EUR,Card transaction of -EUR issued by Scw* C-+,,49.91,,,,,,,Scw* C-1286 +33184130050,2607,Jonas Smedegaard,,,0.00, +BALANCE_CASHBACK-3aa61f3c-d1f7-4fb2-37ec-60127f8e5a62,05-04-2024,05-04-2024 02:31:25.357,0.08,EUR,Balance cashback,,48.91,,,,,,,,,,,,0.00, +CARD-1362596707,04-04-2024,04-04-2024 10:40:37.133,-4.75,EUR,Card transaction of EUR issued by Scaleway +,,48.83,,,,,,,Scaleway +33184130050,2607,Jonas Smedegaard,,,0.00, +CARD-1357880433,02-04-2024,02-04-2024 10:10:48.104,-1.00,EUR,Card transaction of EUR issued by Scw* C-+,,53.58,,,,,,,Scw* C-1286 +33184130050,2607,Jonas Smedegaard,,,0.00, +BALANCE_CASHBACK-37ec1d01-53c1-4ac3-72ec-5cc5ae66e2e3,04-03-2024,04-03-2024 08:31:25.513,0.07,EUR,Balance cashback,,54.58,,,,,,,,,,,,0.00, +BALANCE_CASHBACK-359191c3-e728-4065-7fd8-16ce99f41412,02-02-2024,02-02-2024 08:25:22.880,0.08,EUR,Balance cashback,,54.51,,,,,,,,,,,,0.00, +BALANCE_CASHBACK-333f9c8b-c6cb-4903-68f3-605767ab1b52,04-01-2024,04-01-2024 08:49:25.685,0.07,EUR,Balance cashback,,54.43,,,,,,,,,,,,0.00, diff --git a/data/2024/assets/25541958.csv.rules b/data/2024/assets/25541958.csv.rules new file mode 120000 index 0000000..d0ed647 --- /dev/null +++ b/data/2024/assets/25541958.csv.rules @@ -0,0 +1 @@ +../../wise.rules
\ No newline at end of file diff --git a/data/2024/assets/25541958.ledger b/data/2024/assets/25541958.ledger new file mode 100644 index 0000000..5a6a69f --- /dev/null +++ b/data/2024/assets/25541958.ledger @@ -0,0 +1,62 @@ +D 1,000.00 DKK + +2024-01-04=2024-01-04 Balance cashback + assets:bank:dr. jones EUR0.07 + assets:advances:unknown EUR-0.07 + +2024-02-02=2024-02-02 Balance cashback + assets:bank:dr. jones EUR0.08 + assets:advances:unknown EUR-0.08 + +2024-03-04=2024-03-04 Balance cashback + assets:bank:dr. jones EUR0.07 + assets:advances:unknown EUR-0.07 + +2024-04-02=2024-04-02 Card transaction of EUR issued by Scw* C-+ + assets:bank:dr. jones EUR-1.00 + assets:advances:unknown EUR1.00 + +2024-04-04=2024-04-04 Card transaction of EUR issued by Scaleway + + assets:bank:dr. jones EUR-4.75 + liabilities:payable:hosting EUR4.75 + +2024-04-05=2024-04-05 Balance cashback + assets:bank:dr. jones EUR0.08 + assets:advances:unknown EUR-0.08 + +2024-04-05=2024-04-05 Card transaction of -EUR issued by Scw* C-+ + assets:bank:dr. jones EUR1.00 + assets:advances:unknown EUR-1.00 + +2024-04-08=2024-04-08 Wise Charges for: CARD-1373060816 + assets:bank:dr. jones EUR-0.17 + expenses:non-vat:bank:fees EUR0.17 + +2024-04-08=2024-04-08 Card transaction of DKK issued by Post Dk Told KOBENHAVN V + assets:bank:dr. jones EUR-31.08 + assets:advances:unknown EUR31.08 + +2024-05-06=2024-05-06 Card transaction of EUR issued by Scaleway + + assets:bank:dr. jones EUR-4.59 + liabilities:payable:hosting EUR4.59 + +2024-06-04=2024-06-04 Card transaction of EUR issued by Scaleway + + assets:bank:dr. jones EUR-4.75 + liabilities:payable:hosting EUR4.75 + +2024-07-02=2024-07-02 Card transaction of EUR issued by Scaleway + + assets:bank:dr. jones EUR-4.59 + liabilities:payable:hosting EUR4.59 + +2024-07-13=2024-07-13 Wise Charges for: CARD-1625056475 + assets:bank:dr. jones EUR-0.02 + expenses:non-vat:bank:fees EUR0.02 + +2024-07-13=2024-07-13 Card transaction of USD issued by Rch-Kagicom + + assets:bank:dr. jones EUR-4.71 + assets:advances:jonas EUR4.71 + +2024-12-16=2024-12-16 Received money from Jonas Smedegaard with reference + assets:bank:dr. jones EUR46.50 + assets:advances:jonas EUR-46.50 + diff --git a/data/2024/assets/84011036773.csv b/data/2024/assets/84011036773.csv new file mode 100644 index 0000000..32f6c8d --- /dev/null +++ b/data/2024/assets/84011036773.csv @@ -0,0 +1,5 @@ +Dato,Tekst,Beløb,Saldo,Valørdato,Kreditorref.,End2end,Type,Adviseringer, +02-01-2024,DK-NOTAP2605 PUNKTUM DK,-70.00,44907.64,02-01-2024," "," ",,, +02-01-2024,Gebyr iflg nota,-200.00,44707.64,02-01-2024," "," ",,, +05-01-2024,Forretning: SCALEWAY,-35.77,44671.87,05-01-2024," "," ",,, +31-01-2024,DK-NOTA21174 KVIKNET.DK APS,-399.00,44272.87,31-01-2024," "," ",,, diff --git a/data/2024/assets/84011036773.csv.rules b/data/2024/assets/84011036773.csv.rules new file mode 120000 index 0000000..e2ebe50 --- /dev/null +++ b/data/2024/assets/84011036773.csv.rules @@ -0,0 +1 @@ +../../merkur.rules
\ No newline at end of file diff --git a/data/2024/assets/84011036773.ledger b/data/2024/assets/84011036773.ledger new file mode 100644 index 0000000..6b476db --- /dev/null +++ b/data/2024/assets/84011036773.ledger @@ -0,0 +1,18 @@ +D 1,000.00 DKK + +2024-01-02=2024-01-02 DK-NOTAP2605 PUNKTUM DK - + assets:bank:dr. jones DKK -70.00 + liabilities:payable:hosting DKK 70.00 + +2024-01-02=2024-01-02 Gebyr iflg nota - + assets:bank:dr. jones DKK -200.00 + expenses:non-vat:bank:fees DKK 200.00 + +2024-01-05=2024-01-05 Forretning: SCALEWAY - + assets:bank:dr. jones DKK -35.77 + liabilities:payable:hosting DKK 35.77 + +2024-01-31=2024-01-31 DK-NOTA21174 KVIKNET.DK APS - + assets:bank:dr. jones DKK -399.00 + liabilities:payable:internet DKK 399.00 + diff --git a/data/2024/assets/84011036773_2.csv b/data/2024/assets/84011036773_2.csv new file mode 100644 index 0000000..951be19 --- /dev/null +++ b/data/2024/assets/84011036773_2.csv @@ -0,0 +1,40 @@ +Exportkonto,Afsenderkonto,Modtagerkonto,Dato,Tekst,Beløb,Saldo,Indbetaler,Supp. tekst til modtager,Tekst til modtager,Betalingsident,End2end,Gebyrer(Swift),Gebyr valuta,Kontohaver,Kreditorreference,Modtagernavn,Modtaget beløb,Modtaget valuta,NEMkonto ID,Overført beløb,Overført valuta,Ovf.type,Samlepost,Swift/BIC,Valuta,Valørdato,Vekselkurs, +84011036773,84011036773,,07-02-2024,Forretning: SCALEWAY,-35.76,44237.11,,"Forretning: SCALEWAY Øvrig info: PARIS : REECCHOC Kurstillæg: 0,35 DKK Mark-up mod ECB-kurs: 0,90% VISA-NOTA EUR 4,75 05.02 EUR 4,75 KURS 745,47 4571XXXXXXXX9886 Kortnr: 4571 XXXX XXXX 9886",,,,,,It-Guide Dr. Jones,,,,,,35.76,DKK,Visa,,,DKK,07-02-2024,, +84011036773,84011036773,84010001028184,22-02-2024,Til Privat,-20000.00,24237.11,"It-Guide Dr. Jones v/Jonas Smedegaard Stauninggårdsvej 25 4305 Orø ",,Fra dr. Jones (CVR 1,,,,,It-Guide Dr. Jones,,,,,,20000.00,DKK,Overførsel,,,DKK,22-02-2024,, +84011036773,84011036773,,29-02-2024,DK-NOTA21466 KVIKNET.DK APS,-399.00,23838.11,,"Kortnr. Forretning: KVIKNET.DK APS By........: Odense S Forr.ref..: 060056883097 Terminal..: 5849403 Notanr....: 2146631 Købsdato..: 2024-02-29 Beløb.....: -399,00 ",,,,,,It-Guide Dr. Jones,,,,,,399.00,DKK,Dankort,,,DKK,29-02-2024,, +84011036773,84011036773,,04-03-2024,DK-NOTAP2716 PUNKTUM DK,-210.00,23628.11,,"Kortnr. Forretning: PUNKTUM DK By........: København S Forr.ref..: 064056467247 Terminal..: 2835126 Notanr....: P2716878 Købsdato..: 2024-03-04 Beløb.....: -210,00 ",,,,,,It-Guide Dr. Jones,,,,,,210.00,DKK,Dankort,,,DKK,04-03-2024,, +84011036773,84011036773,,06-03-2024,Forretning: SCALEWAY,-33.52,23594.59,,"Forretning: SCALEWAY Øvrig info: PARIS : REECCHOC Kurstillæg: 0,33 DKK Mark-up mod ECB-kurs: 1,05% VISA-NOTA EUR 4,45 04.03 EUR 4,45 KURS 745,84 4571XXXXXXXX9886 Kortnr: 4571 XXXX XXXX 9886",,,,,,It-Guide Dr. Jones,,,,,,33.52,DKK,Visa,,,DKK,06-03-2024,, +84011036773,84011036773,,27-03-2024,DK-NOTA21610 KVIKNET.DK APS,-399.00,23195.59,,"Kortnr. Forretning: KVIKNET.DK APS By........: Odense S Forr.ref..: 087056685770 Terminal..: 5849403 Notanr....: 2161073 Købsdato..: 2024-03-27 Beløb.....: -399,00 ",,,,,,It-Guide Dr. Jones,,,,,,399.00,DKK,Dankort,,,DKK,27-03-2024,, +84011036773,84011036773,,02-04-2024,Forretning: NEAT PINE STORE LTD,-560.39,22635.20,,"Forretning: NEAT PINE STORE LTD Øvrig info: TUEN MUN : TJLTGCC8 Kurstillæg: 8,28 DKK VISA-NOTA USD 79,96 26.03 USD 79,96 KURS 690,48 4571XXXXXXXX9886 Kortnr: 4571 XXXX XXXX 9886",,,,,,It-Guide Dr. Jones,,,,,,560.39,DKK,Visa,,,DKK,02-04-2024,, +84011036773,84011036773,,02-04-2024,Forretning: NEAT PINE STORE LTD,-672.11,21963.09,,"Forretning: NEAT PINE STORE LTD Øvrig info: TUEN MUN : TJLTGCC8 Kurstillæg: 9,93 DKK VISA-NOTA USD 95,90 26.03 USD 95,90 KURS 690,49 4571XXXXXXXX9886 Kortnr: 4571 XXXX XXXX 9886",,,,,,It-Guide Dr. Jones,,,,,,672.11,DKK,Visa,,,DKK,02-04-2024,, +84011036773,,84011036773,08-04-2024,UDBETALING FRA SKATT,633.58,22596.67,"SKATTEFORVALTNINGEN BRÆNDGÅRDVEJ 10 7400 HERNING ","Kundenr: 19483495 Rentekorrektion 3 ,02- Rentekorrektion 2,60- Rentekor rektion 0,81- Moms halvårlig 624,00 - Rente 0,07- R ",,,12428399001000184218-0300307078,,,It-Guide Dr. Jones,,,,,,633.58,DKK,Indsat,,,DKK,08-04-2024,, +84011036773,84011036773,,10-04-2024,Forretning: TransferWise,-1005.70,21590.97,,"Forretning: TransferWise Øvrig info: Bruxelles VISA-NOTA DKK 1005,70 08.04 4571XXXXXXXX8022 Kortnr: 4571 XXXX XXXX 8022",,,,,,It-Guide Dr. Jones,,,,,,1005.70,DKK,Visa,,,DKK,10-04-2024,, +84011036773,84011036773,,22-04-2024,DK-NOTAP2809 PUNKTUM DK,-70.00,21520.97,,"Kortnr. 4571 XXXX XXXX 8022 Forretning: PUNKTUM DK By........: København S Forr.ref..: 112056619860 Terminal..: 2835126 Notanr....: P2809315 Købsdato..: 2024-04-21 Beløb.....: -70,00 ",,,,,,It-Guide Dr. Jones,,,,,,70.00,DKK,Dankort,,,DKK,22-04-2024,, +84011036773,84011036773,84010001028184,22-04-2024,Til Privat,-5000.00,16520.97,"It-Guide Dr. Jones v/Jonas Smedegaard Stauninggårdsvej 25 4305 Orø ",,Fra dr. Jones (CVR 1,,,,,It-Guide Dr. Jones,,,,,,5000.00,DKK,Overførsel,,,DKK,22-04-2024,, +84011036773,84011036773,,01-05-2024,DK-NOTA21788 KVIKNET.DK APS,-399.00,16121.97,,"Kortnr. 4571 XXXX XXXX 8022 Forretning: KVIKNET.DK APS By........: Odense S Forr.ref..: 122056688323 Terminal..: 5849403 Notanr....: 2178841 Købsdato..: 2024-05-01 Beløb.....: -399,00 ",,,,,,It-Guide Dr. Jones,,,,,,399.00,DKK,Dankort,,,DKK,01-05-2024,, +84011036773,84011036773,,02-05-2024,DK-NOTA16707 UNOTEL.DK,-69.00,16052.97,,"Kortnr. 4571 XXXX XXXX 8022 Forretning: UNOTEL.DK By........: Tranbjerg J Forr.ref..: 122056573837 Terminal..: 5078598 Notanr....: 1670767 Købsdato..: 2024-05-01 Beløb.....: -69,00 ",,,,,,It-Guide Dr. Jones,,,,,,69.00,DKK,Dankort,,,DKK,02-05-2024,, +84011036773,84011036773,84010001028184,15-05-2024,Til Privat,-5000.00,11052.97,"It-Guide Dr. Jones v/Jonas Smedegaard Stauninggårdsvej 25 4305 Orø ",,Fra dr. Jones (CVR 1,,,,,It-Guide Dr. Jones,,,,,,5000.00,DKK,Overførsel,,,DKK,15-05-2024,, +84011036773,84011036773,,03-06-2024,DK-NOTA16751 UNOTEL.DK,-89.00,10963.97,,"Kortnr. 4571 XXXX XXXX 8022 Forretning: UNOTEL.DK By........: Tranbjerg J Forr.ref..: 153056877239 Terminal..: 5078598 Notanr....: 1675159 Købsdato..: 2024-06-01 Beløb.....: -89,00 ",,,,,,It-Guide Dr. Jones,,,,,,89.00,DKK,Dankort,,,DKK,03-06-2024,, +84011036773,,84011036773,06-06-2024,OVERFØRSEL,70.97,11034.94,"NUUDAY A/S C/O TDC A/S TEGLHOLMSGADE 1 2450 KØBENHAVN SV ","Udbetaling UnoTel ",,,CM191383 KN4283360,,,It-Guide Dr. Jones,,,,,,70.97,DKK,Indsat,,,DKK,06-06-2024,, +84011036773,,84011036773,06-06-2024,OVERFØRSEL,29.20,11064.14,"NUUDAY A/S C/O TDC A/S TEGLHOLMSGADE 1 2450 KØBENHAVN SV ","Udbetaling UnoTel ",,,CM191383 KN4886654,,,It-Guide Dr. Jones,,,,,,29.20,DKK,Indsat,,,DKK,06-06-2024,, +84011036773,84011036773,,10-06-2024,DK-NOTAa4458 EWII BREDBÅND,-399.00,10665.14,,"Kortnr. 4571 XXXX XXXX 8022 Forretning: EWII BREDBÅND By........: Kolding Forr.ref..: 162056841194 Terminal..: 6686966 Notanr....: a4458161 Købsdato..: 2024-06-10 Beløb.....: -399,00 ",,,,,,It-Guide Dr. Jones,,,,,,399.00,DKK,Dankort,,,DKK,10-06-2024,, +84011036773,84011036773,84010001028184,17-06-2024,Til Privat,-5000.00,5665.14,"It-Guide Dr. Jones v/Jonas Smedegaard Stauninggårdsvej 25 4305 Orø ",,Fra dr. Jones (CVR 1,,,,,It-Guide Dr. Jones,,,,,,5000.00,DKK,Overførsel,,,DKK,17-06-2024,, +84011036773,84011036773,,01-07-2024,DK-NOTAa4563 EWII BREDBÅND,-399.00,5266.14,,"Kortnr. 4571 XXXX XXXX 8022 Forretning: EWII BREDBÅND By........: Kolding Forr.ref..: 183056768588 Terminal..: 6686966 Notanr....: a4563559 Købsdato..: 2024-07-01 Beløb.....: -399,00 ",,,,,,It-Guide Dr. Jones,,,,,,399.00,DKK,Dankort,,,DKK,01-07-2024,, +84011036773,84011036773,,02-07-2024,DK-NOTA16789 UNOTEL.DK,-79.00,5187.14,,"Kortnr. 4571 XXXX XXXX 8022 Forretning: UNOTEL.DK By........: Tranbjerg J Forr.ref..: 183256500032 Terminal..: 5078598 Notanr....: 1678939 Købsdato..: 2024-07-01 Beløb.....: -79,00 ",,,,,,It-Guide Dr. Jones,,,,,,79.00,DKK,Dankort,,,DKK,02-07-2024,, +84011036773,84011036773,,22-07-2024,DK-NOTA16791 LET-ELEKTRONIK.DK,-789.00,4398.14,,"Kortnr. 4571 XXXX XXXX 8022 Forretning: LET-ELEKTRONIK.DK By........: Fredericia Forr.ref..: 197056639695 Terminal..: 6317731 Notanr....: 16791781 Købsdato..: 2024-07-22 Beløb.....: -789,00 ",,,,,,It-Guide Dr. Jones,,,,,,789.00,DKK,Dankort,,,DKK,22-07-2024,, +84011036773,84011036773,,01-08-2024,DK-NOTAa4736 EWII BREDBÅND,-399.00,3999.14,,"Kortnr. 4571 XXXX XXXX 8022 Forretning: EWII BREDBÅND By........: Kolding Forr.ref..: 214056737851 Terminal..: 6686966 Notanr....: a4736003 Købsdato..: 2024-08-01 Beløb.....: -399,00 ",,,,,,It-Guide Dr. Jones,,,,,,399.00,DKK,Dankort,,,DKK,01-08-2024,, +84011036773,84011036773,,02-08-2024,DK-NOTA16836 UNOTEL.DK,-79.26,3919.88,,"Kortnr. 4571 XXXX XXXX 8022 Forretning: UNOTEL.DK By........: Tranbjerg J Forr.ref..: 214256578190 Terminal..: 5078598 Notanr....: 1683690 Købsdato..: 2024-08-01 Beløb.....: -79,26 ",,,,,,It-Guide Dr. Jones,,,,,,79.26,DKK,Dankort,,,DKK,02-08-2024,, +84011036773,84011036773,,20-08-2024,DK-NOTAP2991 PUNKTUM DK,-280.00,3639.88,,"Kortnr. 4571 XXXX XXXX 8022 Forretning: PUNKTUM DK By........: København S Forr.ref..: 233056295299 Terminal..: 2835126 Notanr....: P2991921 Købsdato..: 2024-08-20 Beløb.....: -280,00 ",,,,,,It-Guide Dr. Jones,,,,,,280.00,DKK,Dankort,,,DKK,20-08-2024,, +84011036773,84011036773,,02-09-2024,DK-NOTA16880 UNOTEL.DK,-79.00,3560.88,,"Kortnr. 4571 XXXX XXXX 8022 Forretning: UNOTEL.DK By........: Tranbjerg J Forr.ref..: 245256182631 Terminal..: 5078598 Notanr....: 1688004 Købsdato..: 2024-09-01 Beløb.....: -79,00 ",,,,,,It-Guide Dr. Jones,,,,,,79.00,DKK,Dankort,,,DKK,02-09-2024,, +84011036773,84011036773,,02-09-2024,DK-NOTAa4855 EWII BREDBÅND,-399.00,3161.88,,"Kortnr. 4571 XXXX XXXX 8022 Forretning: EWII BREDBÅND By........: Kolding Forr.ref..: 246056140339 Terminal..: 6686966 Notanr....: a4855521 Købsdato..: 2024-09-02 Beløb.....: -399,00 ",,,,,,It-Guide Dr. Jones,,,,,,399.00,DKK,Dankort,,,DKK,02-09-2024,, +84011036773,84011036773,,01-10-2024,DK-NOTA16930 UNOTEL.DK,-79.00,3082.88,,"Kortnr. 4571 XXXX XXXX 8022 Forretning: UNOTEL.DK By........: Tranbjerg J Forr.ref..: 275256010439 Terminal..: 5078598 Notanr....: 1693030 Købsdato..: 2024-10-01 Beløb.....: -79,00 ",,,,,,It-Guide Dr. Jones,,,,,,79.00,DKK,Dankort,,,DKK,01-10-2024,, +84011036773,84011036773,,01-10-2024,DK-NOTAa4987 EWII BREDBÅND,-399.00,2683.88,,"Kortnr. 4571 XXXX XXXX 8022 Forretning: EWII BREDBÅND By........: Kolding Forr.ref..: 275056926539 Terminal..: 6686966 Notanr....: a4987381 Købsdato..: 2024-10-01 Beløb.....: -399,00 ",,,,,,It-Guide Dr. Jones,,,,,,399.00,DKK,Dankort,,,DKK,01-10-2024,, +84011036773,84011036773,,01-11-2024,DK-NOTA16985 UNOTEL.DK,-80.11,2603.77,,"Kortnr. 4571 XXXX XXXX 8022 Forretning: UNOTEL.DK By........: Tranbjerg J Forr.ref..: 306256337618 Terminal..: 5078598 Notanr....: 1698567 Købsdato..: 2024-11-01 Beløb.....: -80,11 ",,,,,,It-Guide Dr. Jones,,,,,,80.11,DKK,Dankort,,,DKK,01-11-2024,, +84011036773,84011036773,,04-11-2024,DK-NOTAa5156 EWII BREDBÅND,-399.00,2204.77,,"Kortnr. 4571 XXXX XXXX 8022 Forretning: EWII BREDBÅND By........: Kolding Forr.ref..: 306056433152 Terminal..: 6686966 Notanr....: a5156536 Købsdato..: 2024-11-01 Beløb.....: -399,00 ",,,,,,It-Guide Dr. Jones,,,,,,399.00,DKK,Dankort,,,DKK,04-11-2024,, +84011036773,84011036773,,22-11-2024,DK-NOTASBP33 PUNKTUM DK,-70.00,2134.77,,"Kortnr. 4571 XXXX XXXX 8022 Forretning: PUNKTUM DK By........: København S Forr.ref..: 327056936796 Terminal..: 2835126 Notanr....: SBP3337926 Købsdato..: 2024-11-22 Beløb.....: -70,00 ",,,,,,It-Guide Dr. Jones,,,,,,70.00,DKK,Dankort,,,DKK,22-11-2024,, +84011036773,84011036773,,02-12-2024,DK-NOTA17027 UNOTEL.DK,-79.00,2055.77,,"Kortnr. 4571 XXXX XXXX 8022 Forretning: UNOTEL.DK By........: Tranbjerg J Forr.ref..: 336256613816 Terminal..: 5078598 Notanr....: 1702719 Købsdato..: 2024-12-01 Beløb.....: -79,00 ",,,,,,It-Guide Dr. Jones,,,,,,79.00,DKK,Dankort,,,DKK,02-12-2024,, +84011036773,84011036773,,02-12-2024,DK-NOTAa5288 EWII BREDBÅND,-399.00,1656.77,,"Kortnr. 4571 XXXX XXXX 8022 Forretning: EWII BREDBÅND By........: Kolding Forr.ref..: 337056263698 Terminal..: 6686966 Notanr....: a5288912 Købsdato..: 2024-12-02 Beløb.....: -399,00 ",,,,,,It-Guide Dr. Jones,,,,,,399.00,DKK,Dankort,,,DKK,02-12-2024,, +84011036773,84011036773,,17-12-2024,Forretning: SCW* C-9870,-7.53,1649.24,,"Forretning: SCW* C-9870 Øvrig info: PARIS : REECCHOC Kurstillæg: 0,07 DKK Mark-up mod ECB-kurs: 0,93% VISA-NOTA EUR 1,00 14.12 EUR 1,00 KURS 746,00 4571XXXXXXXX8022 Kortnr: 4571 XXXX XXXX 8022",,,,,,It-Guide Dr. Jones,,,,,,7.53,DKK,Visa,,,DKK,17-12-2024,, +84011036773,84011036773,,17-12-2024,Forretning: SCALEWAY,-34.57,1614.67,,"Forretning: SCALEWAY Øvrig info: PARIS : REECCHOC Kurstillæg: 0,34 DKK Mark-up mod ECB-kurs: 0,96% VISA-NOTA EUR 4,59 14.12 EUR 4,59 KURS 745,75 4571XXXXXXXX8022 Kortnr: 4571 XXXX XXXX 8022",,,,,,It-Guide Dr. Jones,,,,,,34.57,DKK,Visa,,,DKK,17-12-2024,, +84011036773,,84011036773,18-12-2024,Forretning: SCW* C-9870,7.53,1622.20,"Forretning: SCW* C-9870 Øvrig info: PARIS : REECCHOC Kurstillæg: 0,07 DKK Mark-up mod ECB-kurs: 0,93% VISA-NOTA EUR 1,00 16.12 EUR 1,00 KURS 746,00 ","Forretning: SCW* C-9870 Øvrig info: PARIS : REECCHOC Kurstillæg: 0,07 DKK Mark-up mod ECB-kurs: 0,93% VISA-NOTA EUR 1,00 16.12 EUR 1,00 KURS 746,00 4571XXXXXXXX8022 Kortnr: 4571 XXXX XXXX 8022",,,,,,It-Guide Dr. Jones,,,,,,7.53,DKK,Visa,,,DKK,18-12-2024,, +84011036773,84011036773,,23-12-2024,DK-NOTASBP33 PUNKTUM DK,-70.00,1552.20,,"Kortnr. 4571 XXXX XXXX 8022 Forretning: PUNKTUM DK By........: København S Forr.ref..: 355056121962 Terminal..: 2835126 Notanr....: SBP3383900 Købsdato..: 2024-12-20 Beløb.....: -70,00 ",,,,,,It-Guide Dr. Jones,,,,,,70.00,DKK,Dankort,,,DKK,23-12-2024,, diff --git a/data/2024/assets/84011036773_2.csv.local.rules b/data/2024/assets/84011036773_2.csv.local.rules new file mode 100644 index 0000000..4d9e942 --- /dev/null +++ b/data/2024/assets/84011036773_2.csv.local.rules @@ -0,0 +1,7 @@ +if +UNOTEL.DK + account2 assets:advances:jonas + +if +UDBETALING FRA SKATT + account2 assets:advances:jonas diff --git a/data/2024/assets/84011036773_2.csv.rules b/data/2024/assets/84011036773_2.csv.rules new file mode 120000 index 0000000..94d27b8 --- /dev/null +++ b/data/2024/assets/84011036773_2.csv.rules @@ -0,0 +1 @@ +../../merkur2.rules
\ No newline at end of file diff --git a/data/2024/assets/84011036773_2.ledger b/data/2024/assets/84011036773_2.ledger new file mode 100644 index 0000000..3d3c860 --- /dev/null +++ b/data/2024/assets/84011036773_2.ledger @@ -0,0 +1,158 @@ +D 1,000.00 DKK + +2024-02-07=2024-02-07 Forretning: SCALEWAY - Forretning: SCALEWAY Øvrig info: PARIS : REECCHOC Kurstillæg: 0,35 DKK Mark-up mod ECB-kurs: 0,90% VISA-NOTA EUR 4,75 05.02 EUR 4,75 KURS 745,47 4571XXXXXXXX9886 Kortnr: 4571 XXXX XXXX 9886 + assets:bank:dr. jones DKK -35.76 + liabilities:payable:hosting DKK 35.76 + +2024-02-22=2024-02-22 Til Privat - + assets:bank:dr. jones DKK -20000.00 + assets:advances:jonas DKK 20000.00 + +2024-02-29=2024-02-29 DK-NOTA21466 KVIKNET.DK APS - Kortnr. Forretning: KVIKNET.DK APS By........: Odense S Forr.ref..: 060056883097 Terminal..: 5849403 Notanr....: 2146631 Købsdato..: 2024-02-29 Beløb.....: -399,00 + assets:bank:dr. jones DKK -399.00 + liabilities:payable:internet DKK 399.00 + +2024-03-04=2024-03-04 DK-NOTAP2716 PUNKTUM DK - Kortnr. Forretning: PUNKTUM DK By........: København S Forr.ref..: 064056467247 Terminal..: 2835126 Notanr....: P2716878 Købsdato..: 2024-03-04 Beløb.....: -210,00 + assets:bank:dr. jones DKK -210.00 + liabilities:payable:hosting DKK 210.00 + +2024-03-06=2024-03-06 Forretning: SCALEWAY - Forretning: SCALEWAY Øvrig info: PARIS : REECCHOC Kurstillæg: 0,33 DKK Mark-up mod ECB-kurs: 1,05% VISA-NOTA EUR 4,45 04.03 EUR 4,45 KURS 745,84 4571XXXXXXXX9886 Kortnr: 4571 XXXX XXXX 9886 + assets:bank:dr. jones DKK -33.52 + liabilities:payable:hosting DKK 33.52 + +2024-03-27=2024-03-27 DK-NOTA21610 KVIKNET.DK APS - Kortnr. Forretning: KVIKNET.DK APS By........: Odense S Forr.ref..: 087056685770 Terminal..: 5849403 Notanr....: 2161073 Købsdato..: 2024-03-27 Beløb.....: -399,00 + assets:bank:dr. jones DKK -399.00 + liabilities:payable:internet DKK 399.00 + +2024-04-02=2024-04-02 Forretning: NEAT PINE STORE LTD - Forretning: NEAT PINE STORE LTD Øvrig info: TUEN MUN : TJLTGCC8 Kurstillæg: 8,28 DKK VISA-NOTA USD 79,96 26.03 USD 79,96 KURS 690,48 4571XXXXXXXX9886 Kortnr: 4571 XXXX XXXX 9886 + assets:bank:dr. jones DKK -560.39 + liabilities:payable:durables DKK 560.39 + +2024-04-02=2024-04-02 Forretning: NEAT PINE STORE LTD - Forretning: NEAT PINE STORE LTD Øvrig info: TUEN MUN : TJLTGCC8 Kurstillæg: 9,93 DKK VISA-NOTA USD 95,90 26.03 USD 95,90 KURS 690,49 4571XXXXXXXX9886 Kortnr: 4571 XXXX XXXX 9886 + assets:bank:dr. jones DKK -672.11 + liabilities:payable:durables DKK 672.11 + +2024-04-08=2024-04-08 UDBETALING FRA SKATT - Kundenr: 19483495 Rentekorrektion 3 ,02- Rentekorrektion 2,60- Rentekor rektion 0,81- Moms halvårlig 624,00 - Rente 0,07- R + assets:bank:dr. jones DKK 633.58 + expenses:non-vat:bank:fees DKK -633.58 + +2024-04-10=2024-04-10 Forretning: TransferWise - Forretning: TransferWise Øvrig info: Bruxelles VISA-NOTA DKK 1005,70 08.04 4571XXXXXXXX8022 Kortnr: 4571 XXXX XXXX 8022 + assets:bank:dr. jones DKK -1005.70 + assets:advances:unknown DKK 1005.70 + +2024-04-22=2024-04-22 DK-NOTAP2809 PUNKTUM DK - Kortnr. 4571 XXXX XXXX 8022 Forretning: PUNKTUM DK By........: København S Forr.ref..: 112056619860 Terminal..: 2835126 Notanr....: P2809315 Købsdato..: 2024-04-21 Beløb.....: -70,00 + assets:bank:dr. jones DKK -70.00 + liabilities:payable:hosting DKK 70.00 + +2024-04-22=2024-04-22 Til Privat - + assets:bank:dr. jones DKK -5000.00 + assets:advances:jonas DKK 5000.00 + +2024-05-01=2024-05-01 DK-NOTA21788 KVIKNET.DK APS - Kortnr. 4571 XXXX XXXX 8022 Forretning: KVIKNET.DK APS By........: Odense S Forr.ref..: 122056688323 Terminal..: 5849403 Notanr....: 2178841 Købsdato..: 2024-05-01 Beløb.....: -399,00 + assets:bank:dr. jones DKK -399.00 + liabilities:payable:internet DKK 399.00 + +2024-05-02=2024-05-02 DK-NOTA16707 UNOTEL.DK - Kortnr. 4571 XXXX XXXX 8022 Forretning: UNOTEL.DK By........: Tranbjerg J Forr.ref..: 122056573837 Terminal..: 5078598 Notanr....: 1670767 Købsdato..: 2024-05-01 Beløb.....: -69,00 + assets:bank:dr. jones DKK -69.00 + liabilities:payable:phone DKK 69.00 + +2024-05-15=2024-05-15 Til Privat - + assets:bank:dr. jones DKK -5000.00 + assets:advances:jonas DKK 5000.00 + +2024-06-03=2024-06-03 DK-NOTA16751 UNOTEL.DK - Kortnr. 4571 XXXX XXXX 8022 Forretning: UNOTEL.DK By........: Tranbjerg J Forr.ref..: 153056877239 Terminal..: 5078598 Notanr....: 1675159 Købsdato..: 2024-06-01 Beløb.....: -89,00 + assets:bank:dr. jones DKK -89.00 + liabilities:payable:phone DKK 89.00 + +2024-06-06=2024-06-06 OVERFØRSEL - Udbetaling UnoTel + assets:bank:dr. jones DKK 70.97 + assets:advances:unknown DKK -70.97 + +2024-06-06=2024-06-06 OVERFØRSEL - Udbetaling UnoTel + assets:bank:dr. jones DKK 29.20 + assets:advances:unknown DKK -29.20 + +2024-06-10=2024-06-10 DK-NOTAa4458 EWII BREDBÅND - Kortnr. 4571 XXXX XXXX 8022 Forretning: EWII BREDBÅND By........: Kolding Forr.ref..: 162056841194 Terminal..: 6686966 Notanr....: a4458161 Købsdato..: 2024-06-10 Beløb.....: -399,00 + assets:bank:dr. jones DKK -399.00 + liabilities:payable:hosting DKK 399.00 + +2024-06-17=2024-06-17 Til Privat - + assets:bank:dr. jones DKK -5000.00 + assets:advances:jonas DKK 5000.00 + +2024-07-01=2024-07-01 DK-NOTAa4563 EWII BREDBÅND - Kortnr. 4571 XXXX XXXX 8022 Forretning: EWII BREDBÅND By........: Kolding Forr.ref..: 183056768588 Terminal..: 6686966 Notanr....: a4563559 Købsdato..: 2024-07-01 Beløb.....: -399,00 + assets:bank:dr. jones DKK -399.00 + liabilities:payable:hosting DKK 399.00 + +2024-07-02=2024-07-02 DK-NOTA16789 UNOTEL.DK - Kortnr. 4571 XXXX XXXX 8022 Forretning: UNOTEL.DK By........: Tranbjerg J Forr.ref..: 183256500032 Terminal..: 5078598 Notanr....: 1678939 Købsdato..: 2024-07-01 Beløb.....: -79,00 + assets:bank:dr. jones DKK -79.00 + liabilities:payable:phone DKK 79.00 + +2024-07-22=2024-07-22 DK-NOTA16791 LET-ELEKTRONIK.DK - Kortnr. 4571 XXXX XXXX 8022 Forretning: LET-ELEKTRONIK.DK By........: Fredericia Forr.ref..: 197056639695 Terminal..: 6317731 Notanr....: 16791781 Købsdato..: 2024-07-22 Beløb.....: -789,00 + assets:bank:dr. jones DKK -789.00 + assets:advances:unknown DKK 789.00 + +2024-08-01=2024-08-01 DK-NOTAa4736 EWII BREDBÅND - Kortnr. 4571 XXXX XXXX 8022 Forretning: EWII BREDBÅND By........: Kolding Forr.ref..: 214056737851 Terminal..: 6686966 Notanr....: a4736003 Købsdato..: 2024-08-01 Beløb.....: -399,00 + assets:bank:dr. jones DKK -399.00 + liabilities:payable:hosting DKK 399.00 + +2024-08-02=2024-08-02 DK-NOTA16836 UNOTEL.DK - Kortnr. 4571 XXXX XXXX 8022 Forretning: UNOTEL.DK By........: Tranbjerg J Forr.ref..: 214256578190 Terminal..: 5078598 Notanr....: 1683690 Købsdato..: 2024-08-01 Beløb.....: -79,26 + assets:bank:dr. jones DKK -79.26 + liabilities:payable:phone DKK 79.26 + +2024-08-20=2024-08-20 DK-NOTAP2991 PUNKTUM DK - Kortnr. 4571 XXXX XXXX 8022 Forretning: PUNKTUM DK By........: København S Forr.ref..: 233056295299 Terminal..: 2835126 Notanr....: P2991921 Købsdato..: 2024-08-20 Beløb.....: -280,00 + assets:bank:dr. jones DKK -280.00 + liabilities:payable:hosting DKK 280.00 + +2024-09-02=2024-09-02 DK-NOTA16880 UNOTEL.DK - Kortnr. 4571 XXXX XXXX 8022 Forretning: UNOTEL.DK By........: Tranbjerg J Forr.ref..: 245256182631 Terminal..: 5078598 Notanr....: 1688004 Købsdato..: 2024-09-01 Beløb.....: -79,00 + assets:bank:dr. jones DKK -79.00 + liabilities:payable:phone DKK 79.00 + +2024-09-02=2024-09-02 DK-NOTAa4855 EWII BREDBÅND - Kortnr. 4571 XXXX XXXX 8022 Forretning: EWII BREDBÅND By........: Kolding Forr.ref..: 246056140339 Terminal..: 6686966 Notanr....: a4855521 Købsdato..: 2024-09-02 Beløb.....: -399,00 + assets:bank:dr. jones DKK -399.00 + liabilities:payable:hosting DKK 399.00 + +2024-10-01=2024-10-01 DK-NOTA16930 UNOTEL.DK - Kortnr. 4571 XXXX XXXX 8022 Forretning: UNOTEL.DK By........: Tranbjerg J Forr.ref..: 275256010439 Terminal..: 5078598 Notanr....: 1693030 Købsdato..: 2024-10-01 Beløb.....: -79,00 + assets:bank:dr. jones DKK -79.00 + liabilities:payable:phone DKK 79.00 + +2024-10-01=2024-10-01 DK-NOTAa4987 EWII BREDBÅND - Kortnr. 4571 XXXX XXXX 8022 Forretning: EWII BREDBÅND By........: Kolding Forr.ref..: 275056926539 Terminal..: 6686966 Notanr....: a4987381 Købsdato..: 2024-10-01 Beløb.....: -399,00 + assets:bank:dr. jones DKK -399.00 + liabilities:payable:hosting DKK 399.00 + +2024-11-01=2024-11-01 DK-NOTA16985 UNOTEL.DK - Kortnr. 4571 XXXX XXXX 8022 Forretning: UNOTEL.DK By........: Tranbjerg J Forr.ref..: 306256337618 Terminal..: 5078598 Notanr....: 1698567 Købsdato..: 2024-11-01 Beløb.....: -80,11 + assets:bank:dr. jones DKK -80.11 + liabilities:payable:phone DKK 80.11 + +2024-11-04=2024-11-04 DK-NOTAa5156 EWII BREDBÅND - Kortnr. 4571 XXXX XXXX 8022 Forretning: EWII BREDBÅND By........: Kolding Forr.ref..: 306056433152 Terminal..: 6686966 Notanr....: a5156536 Købsdato..: 2024-11-01 Beløb.....: -399,00 + assets:bank:dr. jones DKK -399.00 + liabilities:payable:hosting DKK 399.00 + +2024-11-22=2024-11-22 DK-NOTASBP33 PUNKTUM DK - Kortnr. 4571 XXXX XXXX 8022 Forretning: PUNKTUM DK By........: København S Forr.ref..: 327056936796 Terminal..: 2835126 Notanr....: SBP3337926 Købsdato..: 2024-11-22 Beløb.....: -70,00 + assets:bank:dr. jones DKK -70.00 + liabilities:payable:hosting DKK 70.00 + +2024-12-02=2024-12-02 DK-NOTA17027 UNOTEL.DK - Kortnr. 4571 XXXX XXXX 8022 Forretning: UNOTEL.DK By........: Tranbjerg J Forr.ref..: 336256613816 Terminal..: 5078598 Notanr....: 1702719 Købsdato..: 2024-12-01 Beløb.....: -79,00 + assets:bank:dr. jones DKK -79.00 + liabilities:payable:phone DKK 79.00 + +2024-12-02=2024-12-02 DK-NOTAa5288 EWII BREDBÅND - Kortnr. 4571 XXXX XXXX 8022 Forretning: EWII BREDBÅND By........: Kolding Forr.ref..: 337056263698 Terminal..: 6686966 Notanr....: a5288912 Købsdato..: 2024-12-02 Beløb.....: -399,00 + assets:bank:dr. jones DKK -399.00 + liabilities:payable:hosting DKK 399.00 + +2024-12-17=2024-12-17 Forretning: SCW* C-9870 - Forretning: SCW* C-9870 Øvrig info: PARIS : REECCHOC Kurstillæg: 0,07 DKK Mark-up mod ECB-kurs: 0,93% VISA-NOTA EUR 1,00 14.12 EUR 1,00 KURS 746,00 4571XXXXXXXX8022 Kortnr: 4571 XXXX XXXX 8022 + assets:bank:dr. jones DKK -7.53 + assets:advances:unknown DKK 7.53 + +2024-12-17=2024-12-17 Forretning: SCALEWAY - Forretning: SCALEWAY Øvrig info: PARIS : REECCHOC Kurstillæg: 0,34 DKK Mark-up mod ECB-kurs: 0,96% VISA-NOTA EUR 4,59 14.12 EUR 4,59 KURS 745,75 4571XXXXXXXX8022 Kortnr: 4571 XXXX XXXX 8022 + assets:bank:dr. jones DKK -34.57 + liabilities:payable:hosting DKK 34.57 + +2024-12-18=2024-12-18 Forretning: SCW* C-9870 - Forretning: SCW* C-9870 Øvrig info: PARIS : REECCHOC Kurstillæg: 0,07 DKK Mark-up mod ECB-kurs: 0,93% VISA-NOTA EUR 1,00 16.12 EUR 1,00 KURS 746,00 4571XXXXXXXX8022 Kortnr: 4571 XXXX XXXX 8022 + assets:bank:dr. jones DKK 7.53 + assets:advances:unknown DKK -7.53 + +2024-12-23=2024-12-23 DK-NOTASBP33 PUNKTUM DK - Kortnr. 4571 XXXX XXXX 8022 Forretning: PUNKTUM DK By........: København S Forr.ref..: 355056121962 Terminal..: 2835126 Notanr....: SBP3383900 Købsdato..: 2024-12-20 Beløb.....: -70,00 + assets:bank:dr. jones DKK -70.00 + liabilities:payable:hosting DKK 70.00 + diff --git a/data/2024/assets/84011036773_2.rules b/data/2024/assets/84011036773_2.rules new file mode 100644 index 0000000..c910182 --- /dev/null +++ b/data/2024/assets/84011036773_2.rules @@ -0,0 +1,11 @@ +include banking.rules + +fields ,,,date,description1,amount1,,,description2,,,,,,,,,,,,,,,,,,date2,, + +currency DKK +amount %amount1 +description %description1 - %description2 + +skip 1 + +date-format %d-%m-%Y diff --git a/data/2024/assets/banking.rules b/data/2024/assets/banking.rules new file mode 120000 index 0000000..95d408b --- /dev/null +++ b/data/2024/assets/banking.rules @@ -0,0 +1 @@ +../../banking.rules
\ No newline at end of file diff --git a/data/2024/expenses/ewii.ledger b/data/2024/expenses/ewii.ledger new file mode 100644 index 0000000..947d079 --- /dev/null +++ b/data/2024/expenses/ewii.ledger @@ -0,0 +1,34 @@ +05-22=06-10 ewii 74477401001 + liabilities:payable:internet + expenses:internet 319,20 + liabilities:tax:expenses 79,80 + +06-19=07-01 ewii 74477401002 + liabilities:payable:internet + expenses:internet 319,20 + liabilities:tax:expenses 79,80 + +07-22=08-01 ewii 74477401003 + liabilities:payable:internet + expenses:internet 319,20 + liabilities:tax:expenses 79,80 + +08-21=09-02 ewii 74477401004 + liabilities:payable:internet + expenses:internet 319,20 + liabilities:tax:expenses 79,80 + +09-19=10-01 ewii 74477401005 + liabilities:payable:internet + expenses:internet 319,20 + liabilities:tax:expenses 79,80 + +10-22=11-04 ewii 74477401006 + liabilities:payable:internet + expenses:internet 319,20 + liabilities:tax:expenses 79,80 + +11-20=12-02 ewii 74477401007 + liabilities:payable:internet + expenses:internet 319,20 + liabilities:tax:expenses 79,80 diff --git a/data/2024/expenses/kviknet.ledger b/data/2024/expenses/kviknet.ledger new file mode 100644 index 0000000..90f9c00 --- /dev/null +++ b/data/2024/expenses/kviknet.ledger @@ -0,0 +1,19 @@ +01-24=01-31 kviknet KN1752685 + liabilities:payable:internet + expenses:internet 319,20 + liabilities:tax:expenses 79,80 + +02-22=02-29 kviknet KN1779070 + liabilities:payable:internet + expenses:internet 319,20 + liabilities:tax:expenses 79,80 + +03-20=03-27 kviknet KN1790918 + liabilities:payable:internet + expenses:internet 319,20 + liabilities:tax:expenses 79,80 + +04-23=05-01 kviknet KN1801958 + liabilities:payable:internet + expenses:internet 319,20 + liabilities:tax:expenses 79,80 diff --git a/data/2024/expenses/misc.ledger b/data/2024/expenses/misc.ledger new file mode 100644 index 0000000..aadc63a --- /dev/null +++ b/data/2024/expenses/misc.ledger @@ -0,0 +1,7 @@ +03-27=03-27 pine64 340691 + liabilities:payable:durables + expenses:hardware 79,96 USD @@ 560,39 + +03-27=03-27 pine64 340704 + liabilities:payable:durables + expenses:hardware 95,90 USD @@ 672,11 diff --git a/data/2024/expenses/punktum.ledger b/data/2024/expenses/punktum.ledger new file mode 100644 index 0000000..ee293a3 --- /dev/null +++ b/data/2024/expenses/punktum.ledger @@ -0,0 +1,24 @@ +02-16=03-04 dkhm 2716878 + liabilities:payable:hosting + expenses:internet 168 + liabilities:tax:expenses 42 + +04-17=04-22 dkhm 2809315 + liabilities:payable:hosting + expenses:internet 56 + liabilities:tax:expenses 14 + +08-17=08-20 dkhm 2991921 + liabilities:payable:hosting + expenses:internet 224 + liabilities:tax:expenses 56 + +11-17=11-22 dkhm 3337926 + liabilities:payable:hosting + expenses:internet 56 + liabilities:tax:expenses 14 + +12-18=12-23 dkhm 3383900 + liabilities:payable:hosting + expenses:internet 56 + liabilities:tax:expenses 14 diff --git a/data/2024/expenses/scaleway.ledger b/data/2024/expenses/scaleway.ledger new file mode 100644 index 0000000..e29e102 --- /dev/null +++ b/data/2024/expenses/scaleway.ledger @@ -0,0 +1,47 @@ +01-03=01-05 scaleway 2425579 + liabilities:payable:hosting + expenses:eu-vat:hosting 4,75 EUR @@ 35,77 + +02-05=02-07 scaleway 2455357 + liabilities:payable:hosting + expenses:eu-vat:hosting 4,75 EUR @@ 35,76 + +03-04=03-06 scaleway 2473113 + liabilities:payable:hosting + expenses:eu-vat:hosting 4,45 EUR @@ 33,52 + +04-03=04-04 scaleway 2490385 + liabilities:payable:hosting + expenses:eu-vat:hosting 4,75 EUR + +05-02=05-06 scaleway 2536255 + liabilities:payable:hosting + expenses:eu-vat:hosting 4,59 EUR + +06-04=06-04 scaleway 2570300 + liabilities:payable:hosting + expenses:eu-vat:hosting 4,75 EUR + +07-01=07-02 scaleway 2584252 + liabilities:payable:hosting + expenses:eu-vat:hosting 4,59 EUR + +08-02=08-05 scaleway 2610079 + liabilities:payable:hosting + expenses:eu-vat:hosting 4,75 EUR @@ 35,44 + +09-02=09-02 scaleway 2658112 + liabilities:payable:hosting + expenses:eu-vat:hosting 4,75 EUR @@ 35,43 + +10-03=10-04 scaleway 2692329 + liabilities:payable:hosting + expenses:eu-vat:hosting 4,59 EUR @@ 34,24 + +11-04=11-04 scaleway 2730635 + liabilities:payable:hosting + expenses:eu-vat:hosting 4,75 EUR @@ 35,42 + +12-02=12-17 scaleway 2735536 + liabilities:payable:hosting + expenses:eu-vat:hosting 4,59 EUR @@ 34,57 diff --git a/data/2024/expenses/unotel.ledger b/data/2024/expenses/unotel.ledger new file mode 100644 index 0000000..06aaccd --- /dev/null +++ b/data/2024/expenses/unotel.ledger @@ -0,0 +1,47 @@ +01-01 unot 4887395 + assets:advances:jonas + expenses:non-vat:phone 79 + +02-02 unot 4893690 + assets:advances:jonas + expenses:non-vat:phone 79 + +03-01 unot 4900130 + assets:advances:jonas + expenses:non-vat:phone 79 + +04-01 unot 4907500 + assets:advances:jonas + expenses:non-vat:phone 79 + +05-01=05-02 unot 4913827 + liabilities:payable:phone + expenses:non-vat:phone 69 + +06-01=06-03 unot 4919492 + liabilities:payable:phone + expenses:non-vat:phone 89 + +07-01=07-02 unot 4924139 + liabilities:payable:phone + expenses:non-vat:phone 79 + +08-01=08-02 unot 4930871 + liabilities:payable:phone + expenses:non-vat:phone 79,26 + +09-01=09-02 unot 4936910 + liabilities:payable:phone + expenses:non-vat:phone 79 + +10-01 unot 4942862 + liabilities:payable:phone + expenses:non-vat:phone 79 + +11-01 unot 4949319 + liabilities:payable:phone + expenses:non-vat:phone 80,11 + +12-01=12-02 unot 4954376 + liabilities:payable:phone + expenses:non-vat:phone 79 diff --git a/data/2024/journal.ledger b/data/2024/journal.ledger new file mode 100644 index 0000000..258ff41 --- /dev/null +++ b/data/2024/journal.ledger @@ -0,0 +1,7 @@ +Y2024 +D 1.000,00 DKK +include primo.ledger +include assets/*.ledger +#include income/*.ledger +include expenses/*.ledger +#include ultimo.ledger diff --git a/data/2024/primo.ledger b/data/2024/primo.ledger new file mode 100644 index 0000000..32eeba1 --- /dev/null +++ b/data/2024/primo.ledger @@ -0,0 +1 @@ +Y2024 diff --git a/data/banking.rules b/data/banking.rules new file mode 100644 index 0000000..de5620e --- /dev/null +++ b/data/banking.rules @@ -0,0 +1,271 @@ +account1 assets:bank:dr. jones +account2 assets:advances:unknown + +# transfers +# (list early since word "privat" can appear in other entries too) + +# TODO: verify where to most sensibly place these +if +DAGLIB ORØ +Indskud til madkasse +Kagicom +LENI MØLLSØE TANDL +OEKOVEJEN.DK +privat +Received money from Jonas Smedegaard + account2 assets:advances:jonas + +if +BETALT GIROKORT .*skat +\(OVF.\) 19483495 + account2 assets:advances:jonas + +# expenses + +if +Årsgebyr Visa/Dankort +VISA KONTANTHÆVNINGSGEBYR +Gebyr iflg nota +Gebyr, udl. bet +Gebyr for bevilget overtræk +\bRENTE\b + account2 expenses:non-vat:bank:fees + +if 2525 VENTURES BV + account2 assets:advances:jonas:cryptocoins + +if Henrik H. + account2 liabilities:payable:accounting + +if +UNOTEL A/S +UNOTEL.DK +BETALT GIROKORT tlf +BETALT GIROKORT Unotel fak33015 + account2 liabilities:payable:phone + +if +BYTEMARK +CLICKATELL +CoolSMS +EWII +EXAVAULT +\bFAB-IT\b +\bGANDI\b +HOSTMASTER +LARSEN DATA V/PETE +PUNKTUM DK +RACKSPACE CLOUD +ROUTOMESSAG +SCALEWAY +SLICEHOST +Unotel internet + account2 liabilities:payable:hosting + +if +internet persp +BETALT GIROKORT inet +\bFIBIA\b +BS UNOTEL +KVIKNET.DK APS +Unotel ADSL + account2 liabilities:payable:internet + +if +AV-CABLES.DK +AV-CONNECTION +BATTERIBYEN.DK +B.J. TRADING +BLOCKBUSTER VIDEO +BLUECITY.DK +CARTFT.COM +CINEMAGIC.DK +COMPUTERSALG A/S +COMPUTERSALG.DK +COMPWARE +\bDanbit\b +DATAWORLD APS +DALGAARD KONTOR +DCS APS +DUSTIN GROUP AB +ELEKTRONIK LAVPRIS +ELGIGANTEN +FØNIKS COMPUTER +GETMORE A/S +GLOBALSCALE +IT BUTIKKEN A/S +JYSKTELECOM APS +KOMPLETT DATA +KOMPLETT.DK +KUROKESU +LENOVO +LYDKILDEN +MIDT-DATA +MOBIL-SHOPPING.DK +MY TRENDY PHONE AP +MYTRENDYPHONE +NEAT PINE STORE LTD +NEW IT LTD +nettomusic +NIERLE +OLIMEX +OLLYCOM APS +PINESTORELI +PROSHOP +Redspot ApS +RS COMPONENTS A/S +SALGSBUTIKKEN +\bSAtech\b +\bshg.dk\b +SIKKENEMT.DK +SILVAN +SINDATA +SQUARETECH APS +TELECOMSHOP.DK +TELEPART.DK +TELEWAYDANM +TUXBRAIN +YUBICO +WFAUST +WWW.TELEBAZAR.DK +ZANIKAN PL + account2 liabilities:payable:durables + +if BILLIGTONER.DK + account2 liabilities:payable:goods + +if +BETALT GIROKORT visitkort +prinfo visitkort + account2 liabilities:payable:marketing + +if +CODAN TAXI +DANTAXI +AAR-KOL-HOR.TAXA +FORUM STATION +EUROPARK +Forretning: TAXI +ROSKILDE TAXA +TAXA 4 X 35 +TAXINORD + account2 liabilities:payable:travel:car + +if +STIB/MIVB + account2 liabilities:payable:travel:bus + +if +DB BAHN +\bDSB\b +KORT OG GODT +M VESTAMAGER TVM +\bMTA\b +NJT NWK-INT AIR +\bRATP\b +\bSNCB\b +\bSNCF\b +\bSJ\b +TRAINLINE + account2 liabilities:payable:travel:train + +if +AIRASIA +EASYJET +DEN DANSKE REJSEGR +IBERIA AIRLINES +ICELAND EXPRESS +ICELANDAIR +LION AIR +QATAR AIR +SEAT24 +TRAVELSTART.SE +WOW AIR + account2 liabilities:payable:travel:plane + +if USCUSTOMS + account2 liabilities:payable:customs + +if (HOSTEL|HOTEL|PENSJONAT) +CAB-INN +CITY SLEEP - INN + account2 liabilities:payable:travel:accomodation + +if PAYPAL \*FORENINGENF + account2 liabilities:payable:conference + +# taxes + +if BETALT GIROKORT .*moms + account2 liabilities:tax + +# income + +if Børneuniversitetet + account2 assets:receivable:bu + +if DelebilF +Overførsel Faktura nr. + account2 assets:receivable:db + +if DANSENS HUS + account2 assets:receivable:dans + +if DGI-HUSET + account2 assets:receivable:dgih + +if FREIE SOFTWARE U + account2 assets:receivable:fsub + +if FRIT OPLYSNINGSFORBUND FO I ÅRHUS + account2 assets:receivable:foaa + +if FRONTLØBERNE + account2 assets:receivable:fl + +if Grundejerforeningen Vesterkær + account2 assets:receivable:vesterkaer + +if hello!earth + account2 assets:receivable:hearth + +if IDRÆTSDAGHØJSKOLEN + account2 assets:receivable:ida + +if KAOSPILOTERNE + account2 assets:receivable:kp + +if KASSANDRA PRODUKTION + account2 assets:receivable:kass + +if +NKS ERNST G MORTENSEN STIFTELS +ERNST G MORTENSENS STIFTELSE + account2 assets:receivable:kpno + +if LIVSTEATER + account2 assets:receivable:o2 + +if MAGNATEK APS + account2 assets:receivable:magnatek + +if NILS STÆRK + account2 assets:receivable:nilsstaerk + +if Overførsel bæredygtig it-drift + account2 assets:receivable:nieb + +if +PURISM +CLEAR FINANCE TE + account2 assets:receivable:purism + +if BORA BORA + account2 assets:receivable:bora + +if WALLNER + account2 assets:receivable:wallner + +if +Wise Charges for + account2 expenses:non-vat:bank:fees diff --git a/data/journal.ledger b/data/journal.ledger index 134d0ff..b6df3bb 100644 --- a/data/journal.ledger +++ b/data/journal.ledger @@ -22,3 +22,4 @@ include 2020/journal.ledger include 2021/journal.ledger include 2022/journal.ledger include 2023/journal.ledger +include 2024/journal.ledger diff --git a/data/merkur.rules b/data/merkur.rules index d18f482..16866cd 100644 --- a/data/merkur.rules +++ b/data/merkur.rules @@ -1,5 +1,4 @@ -account1 assets:bank:dr. jones -account2 assets:advances:unknown +include banking.rules fields date2, description1, amount1,, date, code, description2 @@ -10,264 +9,3 @@ description %description1 - %description2 skip 1 date-format %d-%m-%Y - -# transfers -# (list early since word "privat" can appear in other entries too) - -# TODO: verify where to most sensibly place these -if -Indskud til madkasse -LENI MØLLSØE TANDL -OEKOVEJEN.DK -privat - account2 assets:advances:jonas - -if -BETALT GIROKORT .*skat -\(OVF.\) 19483495 - account2 assets:advances:jonas - -# expenses - -if -Årsgebyr Visa/Dankort -VISA KONTANTHÆVNINGSGEBYR -Gebyr iflg nota -Gebyr, udl. bet -Gebyr for bevilget overtræk -\bRENTE\b - account2 expenses:non-vat:bank:fees - -if 2525 VENTURES BV - account2 assets:advances:jonas:cryptocoins - -if Henrik H. - account2 liabilities:payable:accounting - -if -UNOTEL A/S -UNOTEL.DK -BETALT GIROKORT tlf -BETALT GIROKORT Unotel fak33015 - account2 liabilities:payable:phone - -if -BYTEMARK -CLICKATELL -CoolSMS -EXAVAULT -\bFAB-IT\b -\bGANDI\b -HOSTMASTER -LARSEN DATA V/PETE -PUNKTUM DK -RACKSPACE CLOUD -ROUTOMESSAG -SCALEWAY -SLICEHOST -Unotel internet - account2 liabilities:payable:hosting - -if -internet persp -BETALT GIROKORT inet -\bFIBIA\b -BS UNOTEL -KVIKNET.DK APS -Unotel ADSL - account2 liabilities:payable:internet - -if -AV-CABLES.DK -AV-CONNECTION -BATTERIBYEN.DK -B.J. TRADING -BLOCKBUSTER VIDEO -BLUECITY.DK -CARTFT.COM -CINEMAGIC.DK -COMPUTERSALG A/S -COMPUTERSALG.DK -COMPWARE -\bDanbit\b -DATAWORLD APS -DALGAARD KONTOR -DCS APS -DUSTIN GROUP AB -ELEKTRONIK LAVPRIS -ELGIGANTEN -FØNIKS COMPUTER -GETMORE A/S -GLOBALSCALE -IT BUTIKKEN A/S -JYSKTELECOM APS -KOMPLETT DATA -KOMPLETT.DK -KUROKESU -LENOVO -LYDKILDEN -MIDT-DATA -MOBIL-SHOPPING.DK -MY TRENDY PHONE AP -MYTRENDYPHONE -NEAT PINE STORE LTD -NEW IT LTD -nettomusic -NIERLE -OLIMEX -OLLYCOM APS -PINESTORELI -PROSHOP -Redspot ApS -RS COMPONENTS A/S -SALGSBUTIKKEN -\bSAtech\b -\bshg.dk\b -SIKKENEMT.DK -SILVAN -SINDATA -SQUARETECH APS -TELECOMSHOP.DK -TELEPART.DK -TELEWAYDANM -TUXBRAIN -YUBICO -WFAUST -WWW.TELEBAZAR.DK -ZANIKAN PL - account2 liabilities:payable:durables - -if BILLIGTONER.DK - account2 liabilities:payable:goods - -if -BETALT GIROKORT visitkort -prinfo visitkort - account2 liabilities:payable:marketing - -if -CODAN TAXI -DANTAXI -AAR-KOL-HOR.TAXA -FORUM STATION -EUROPARK -Forretning: TAXI -ROSKILDE TAXA -TAXA 4 X 35 -TAXINORD - account2 liabilities:payable:travel:car - -if -STIB/MIVB - account2 liabilities:payable:travel:bus - -if -DB BAHN -\bDSB\b -KORT OG GODT -M VESTAMAGER TVM -\bMTA\b -NJT NWK-INT AIR -\bRATP\b -\bSNCB\b -\bSNCF\b -\bSJ\b -TRAINLINE - account2 liabilities:payable:travel:train - -if -AIRASIA -EASYJET -DEN DANSKE REJSEGR -IBERIA AIRLINES -ICELAND EXPRESS -ICELANDAIR -LION AIR -QATAR AIR -SEAT24 -TRAVELSTART.SE -WOW AIR - account2 liabilities:payable:travel:plane - -if USCUSTOMS - account2 liabilities:payable:customs - -if (HOSTEL|HOTEL|PENSJONAT) -CAB-INN -CITY SLEEP - INN - account2 liabilities:payable:travel:accomodation - -if PAYPAL \*FORENINGENF - account2 liabilities:payable:conference - -# taxes - -if BETALT GIROKORT .*moms - account2 liabilities:tax - -# income - -if Børneuniversitetet - account2 assets:receivable:bu - -if DelebilF -Overførsel Faktura nr. - account2 assets:receivable:db - -if DANSENS HUS - account2 assets:receivable:dans - -if DGI-HUSET - account2 assets:receivable:dgih - -if FREIE SOFTWARE U - account2 assets:receivable:fsub - -if FRIT OPLYSNINGSFORBUND FO I ÅRHUS - account2 assets:receivable:foaa - -if FRONTLØBERNE - account2 assets:receivable:fl - -if Grundejerforeningen Vesterkær - account2 assets:receivable:vesterkaer - -if hello!earth - account2 assets:receivable:hearth - -if IDRÆTSDAGHØJSKOLEN - account2 assets:receivable:ida - -if KAOSPILOTERNE - account2 assets:receivable:kp - -if KASSANDRA PRODUKTION - account2 assets:receivable:kass - -if -NKS ERNST G MORTENSEN STIFTELS -ERNST G MORTENSENS STIFTELSE - account2 assets:receivable:kpno - -if LIVSTEATER - account2 assets:receivable:o2 - -if MAGNATEK APS - account2 assets:receivable:magnatek - -if NILS STÆRK - account2 assets:receivable:nilsstaerk - -if Overførsel bæredygtig it-drift - account2 assets:receivable:nieb - -if -PURISM -CLEAR FINANCE TE - account2 assets:receivable:purism - -if BORA BORA - account2 assets:receivable:bora - -if WALLNER - account2 assets:receivable:wallner diff --git a/data/merkur2.rules b/data/merkur2.rules new file mode 100644 index 0000000..c910182 --- /dev/null +++ b/data/merkur2.rules @@ -0,0 +1,11 @@ +include banking.rules + +fields ,,,date,description1,amount1,,,description2,,,,,,,,,,,,,,,,,,date2,, + +currency DKK +amount %amount1 +description %description1 - %description2 + +skip 1 + +date-format %d-%m-%Y diff --git a/data/wise.rules b/data/wise.rules new file mode 100644 index 0000000..b4f2e50 --- /dev/null +++ b/data/wise.rules @@ -0,0 +1,9 @@ +include banking.rules + +fields ,date2,,amount,currency,description + +date %date2 + +skip 1 + +date-format %d-%m-%Y |