From 5d6f64965fd0d771729fa35f749bbea495a4fb1a Mon Sep 17 00:00:00 2001 From: Jonas Smedegaard Date: Wed, 1 Sep 2021 18:37:04 +0200 Subject: update data for 2019 --- data/2019/expenses/bahn.ledger | 40 +++++++++++++ data/2019/expenses/bytemark.ledger | 4 ++ data/2019/expenses/dkhm.ledger | 15 +++-- data/2019/expenses/dsb.ledger | 28 +++++++++ data/2019/expenses/fibia.ledger | 30 +++++++--- data/2019/expenses/misc.ledger | 29 +++++---- data/2019/expenses/scaleway.ledger | 12 ++++ data/2019/expenses/unotel.ledger | 119 +++++++++++++++++++++++++++++++------ data/2019/income/kp.ledger | 12 ++++ data/2019/income/misc.ledger | 20 +++++++ 10 files changed, 266 insertions(+), 43 deletions(-) create mode 100644 data/2019/income/misc.ledger diff --git a/data/2019/expenses/bahn.ledger b/data/2019/expenses/bahn.ledger index 00fdc1f..987c1f1 100644 --- a/data/2019/expenses/bahn.ledger +++ b/data/2019/expenses/bahn.ledger @@ -26,3 +26,43 @@ liabilities:payable:travel:train expenses:non-vat:travel 38,90 EUR @@ 294,70; from:Holbaek to:Gütersloh expenses:non-vat:travel 61,80 EUR @@ 468,19; from:Gütersloh to:Holbaek + +10-22=10-24 bahn E2E86Y + liabilities:payable:travel:train + expenses:non-vat:travel 322,90 EUR @@ 2.449,67; from:Berlin to:Bruxelles; from:Bruxelles to:Berlin travel:together + expenses:non-vat:travel -161,45 EUR @@ 1.224,83 + assets:advances:siri 161,45 EUR @@ 1.224,83 ; Siri + +10-22=10-24 bahn XZH8TM + liabilities:payable:travel:train + expenses:non-vat:travel 129,20 EUR @@ 1.669,78; from:holbæk to:Berlin; from:Berlin to:Holbæk travel:together + expenses:non-vat:travel -64,60 EUR @@ 834,89 + assets:advances:siri 64,60 EUR @@ 834,89 ; Siri + +10-23=10-25 bahn OX4MOG + liabilities:payable:travel:train + expenses:non-vat:travel 39,90 EUR @@ 302,63; BahnCard + +12-12=12-17 bahn XKWRX6 + liabilities:payable:travel:train + expenses:non-vat:travel 53,80 EUR @@ 408,30 ; from:Skjern to:Hamburg travel:together + expenses:non-vat:travel -26,90 EUR @@ 204,15 + assets:advances:siri 26,90 EUR @@ 204,15 ; Siri + +12-12=12-17 bahn DG416H + liabilities:payable:travel:train + expenses:non-vat:travel 127,40 EUR @@ 966,87 ; from:Hamburg to:Paris travel:together + expenses:non-vat:travel -63,70 EUR @@ 483,43 + assets:advances:siri 63,70 EUR @@ 483,43 ; Siri + +12-13=12-17 bahn CXOEBY + liabilities:payable:travel:train + expenses:non-vat:travel 127,70 EUR @@ 969,14 ; from:Paris to:Gütersloh travel:together + expenses:non-vat:travel -63,85 EUR @@ 484,57 + assets:advances:siri 63,85 EUR @@ 484,57 ; Siri + +12-13=12-17 bahn CXOEBY + assets:advances:jonas + expenses:non-vat:travel 77,80 EUR @@ 590.45 ; from:Gütersloh to:Holbæk travel:together + expenses:non-vat:travel -38,90 EUR @@ 295,22 + assets:advances:siri 38,90 EUR @@ 295,22 ; Siri diff --git a/data/2019/expenses/bytemark.ledger b/data/2019/expenses/bytemark.ledger index 3fa7c07..d0c43a3 100644 --- a/data/2019/expenses/bytemark.ledger +++ b/data/2019/expenses/bytemark.ledger @@ -9,3 +9,7 @@ 08-12=08-16 bytemark 1708619 liabilities:payable:hosting expenses:eu-vat:hosting 97,20 GBP @@ 797,39 + +11-11=11-13 bytemark 1754384 + liabilities:payable:hosting + expenses:eu-vat:hosting 97,20 GBP @@ 861,42 diff --git a/data/2019/expenses/dkhm.ledger b/data/2019/expenses/dkhm.ledger index 7293935..d1e9242 100644 --- a/data/2019/expenses/dkhm.ledger +++ b/data/2019/expenses/dkhm.ledger @@ -1,24 +1,29 @@ -01-01=02-08 dkhm 8408829 +01-01=01-03 dkhm 8408829 liabilities:payable:hosting expenses:internet 40 liabilities:tax:expenses 10 -02-26=03-08 dkhm 8515741 +02-26 dkhm 8515741 liabilities:payable:hosting expenses:internet 100 liabilities:tax:expenses 25 -03-01=04-08 dkhm 8539048 +03-01=04-16 dkhm 8539048 liabilities:payable:hosting expenses:internet 120 liabilities:tax:expenses 30 -05-01=06-08 dkhm 8652228 +05-01=05-15 dkhm 8652228 liabilities:payable:hosting expenses:internet 40 liabilities:tax:expenses 10 -09-02=10-08 dkhm 8871844 +09-02=09-06 dkhm 8871844 liabilities:payable:hosting expenses:internet 160 liabilities:tax:expenses 40 + +12-01=12-05 dkhm 14851476 + liabilities:payable:hosting + expenses:internet 40 + liabilities:tax:expenses 10 diff --git a/data/2019/expenses/dsb.ledger b/data/2019/expenses/dsb.ledger index 9d5ec5b..14f4352 100644 --- a/data/2019/expenses/dsb.ledger +++ b/data/2019/expenses/dsb.ledger @@ -1,3 +1,31 @@ +# FIXME: invoice missing +04-05=04-08 dsb + liabilities:payable:travel:train + expenses:non-vat:travel 208 ; from:Holbæk to:København + +# FIXME: invoice missing +04-10=04-11 dsb + liabilities:payable:travel:train + expenses:non-vat:travel 84 ; from:København to:Holbæk + 08-26 dsb 55G1PC2R liabilities:payable:travel:train expenses:non-vat:travel 219 ; from:Holbæk to:Aarhus + +# FIXME: invoice missing +09-02 dsb + liabilities:payable:travel:train + expenses:non-vat:travel 387 ; from:Århus to:Holbæk + +# FIXME: invoice missing +09-23 dsb + liabilities:payable:travel:train + expenses:non-vat:travel 857,50 ; from:Holbæk to:Århus travel:together + expenses:non-vat:travel -428,75 + assets:advances:siri 428,75 + +12-12 dsb 55GEFBKM + liabilities:payable:travel:train + expenses:non-vat:travel 198 ; from:Holbæk to:Skjern travel:together + expenses:non-vat:travel -99 + assets:advances:siri 99 diff --git a/data/2019/expenses/fibia.ledger b/data/2019/expenses/fibia.ledger index 9a6bad7..50a24f6 100644 --- a/data/2019/expenses/fibia.ledger +++ b/data/2019/expenses/fibia.ledger @@ -1,13 +1,27 @@ -03-13 fibia 00917941 +03-13=04-03 fibia 00917941 liabilities:payable:internet - expenses:non-vat:internet 175,20 - expenses:non-vat:internet 175,20 - expenses:non-vat:internet 175,20 + expenses:internet 175,20 + expenses:internet 175,20 + expenses:internet 175,20 liabilities:tax:expenses 131,40 -06-06 fibia 01076880 +06-07=07-02 fibia 01076880 liabilities:payable:internet - expenses:non-vat:internet 175,20 - expenses:non-vat:internet 175,20 - expenses:non-vat:internet 175,20 + expenses:internet 175,20 + expenses:internet 175,20 + expenses:internet 175,20 + liabilities:tax:expenses 131,40 + +09-09=10-01 fibia 01256108 + liabilities:payable:internet + expenses:internet 175,20 + expenses:internet 175,20 + expenses:internet 175,20 + liabilities:tax:expenses 131,40 + +12-06=2020-01-02 fibia 01463016 + liabilities:payable:internet + expenses:internet 175,20 + expenses:internet 175,20 + expenses:internet 175,20 liabilities:tax:expenses 131,40 diff --git a/data/2019/expenses/misc.ledger b/data/2019/expenses/misc.ledger index 56d3c0e..17887bf 100644 --- a/data/2019/expenses/misc.ledger +++ b/data/2019/expenses/misc.ledger @@ -7,12 +7,12 @@ expenses:non-vat:bank:fees -5,12 liabilities:tax:expenses 608,32 -03-10 computersalg 2942352 +03-10=03-11 computersalg 2942352 liabilities:payable:durables expenses:hardware 859,61 liabilities:tax:expenses 214,90 -03-10 computersalg 2942352 +03-10=05-02 computersalg 2942352 liabilities:payable:durables expenses:hardware 252,68 expenses:hardware 114,40 @@ -21,25 +21,28 @@ expenses:hardware 24,89 liabilities:tax:expenses 139,97 +04-05 sj RQW2852Z + liabilities:payable:travel:train + expenses:non-vat:travel:train 500 SEK @@ 364,07 ; from:København to:Göteborg + +04-10=04-11 sj KBB6283O + liabilities:payable:travel:train + expenses:non-vat:travel:train 377 SEK @@ 274,44 ; from:Göteborg to:København + 05-15=04-24 olimex 41725 liabilities:payable:durables expenses:eu-vat:durables 326,17 EUR @@ 2.489,59 06-03 BJTrading 1516402 liabilities:payable:durables - expenses:hardware 216 - expenses:non-vat:delivery 46 + expenses:hardware 209,60 liabilities:tax:expenses 52,40 -# FIXME: Locate invoice -#08-27 olimex 42637 -# liabilities:payable:durables -# expenses:eu-vat:durables 572,84 EUR @@ +08-27 olimex 42637 + assets:advances:jonas ; paid from private account + expenses:eu-vat:durables 572,84 EUR @@ 4489,22 -09-18 compart 2385266 +09-18=09-19 compart 2385266 liabilities:payable:durables - expenses:hardware 63 - expenses:hardware 416 - expenses:hardware 189 - expenses:non-vat:delivery 44 + expenses:hardware 569,60 liabilities:tax:expenses 142,40 diff --git a/data/2019/expenses/scaleway.ledger b/data/2019/expenses/scaleway.ledger index d1430e6..6411d14 100644 --- a/data/2019/expenses/scaleway.ledger +++ b/data/2019/expenses/scaleway.ledger @@ -33,3 +33,15 @@ 09-02=09-05 scaleway 940183 liabilities:payable:hosting expenses:eu-vat:hosting 2,99 EUR @@ 22,63 + +10-01=10-04 scaleway 964801 + liabilities:payable:hosting + expenses:eu-vat:hosting 2,99 EUR @@ 22,66 + +11-01=11-07 scaleway 970128 + liabilities:payable:hosting + expenses:eu-vat:hosting 2,99 EUR @@ 22,69 + +12-02=12-06 scaleway 1024497 + liabilities:payable:hosting + expenses:eu-vat:hosting 2,99 EUR @@ 22,69 diff --git a/data/2019/expenses/unotel.ledger b/data/2019/expenses/unotel.ledger index 107655a..f3e0e49 100644 --- a/data/2019/expenses/unotel.ledger +++ b/data/2019/expenses/unotel.ledger @@ -1,42 +1,127 @@ -01-01 unot 4390466 +01-01=01-02 unot 4390466 liabilities:payable:phone - expenses:non-vat:phone 200 + expenses:non-vat:phone 200 03-01 unot 4411462 liabilities:payable:phone - expenses:non-vat:phone 200 + expenses:non-vat:phone 200 -03-19 unot 4417329 +03-19=04-02 unot 4417329 liabilities:payable:internet - expenses:internet 525,60 - liabilities:tax:expenses 131,40 + expenses:internet 525,60 + liabilities:tax:expenses 131,40 05-01 unot 4430099 liabilities:payable:phone - expenses:non-vat:phone 200 + expenses:non-vat:phone 200 -06-19 unot 4446036 +06-03 unot 4444307 + liabilities:payable:phone + assets:advances:siri 101,94 + +06-19=07-03 unot 4446036 liabilities:payable:internet - expenses:internet 485,57 - liabilities:tax:expenses 121,39 + expenses:internet 485,57 + liabilities:tax:expenses 121,39 07-01 unot 4449582 liabilities:payable:phone - expenses:non-vat:phone 123,72 + expenses:non-vat:phone 123,72 + +07-01 unot 4450645 + liabilities:payable:phone + assets:advances:siri 119 07-04 unot 4454098 liabilities:payable:phone - expenses:non-vat:phone 101,07 + expenses:non-vat:phone 101,07 + +07-01 unot 4459379 + liabilities:payable:phone + assets:advances:siri 119 08-01 unot 4459203 liabilities:payable:phone - expenses:non-vat:phone 119 + expenses:non-vat:phone 119 09-01 unot 4468476 liabilities:payable:phone - expenses:non-vat:phone 119,56 + expenses:non-vat:phone 119,56 + +09-01 unot 4468657 + liabilities:payable:phone + assets:advances:siri 122,35 + +09-19=10-03 unot 4474406 + liabilities:payable:internet + expenses:internet 477,60 + liabilities:tax:expenses 119,40 + +10-01 unot 4478458 + liabilities:payable:phone + expenses:non-vat:phone 119,56 + +10-01 unot 4477688 + liabilities:payable:phone + assets:advances:siri 119 + +11-01 unot 4488013 + liabilities:payable:phone + expenses:non-vat:phone 121,70 + +11-01 unot 4489149 + liabilities:payable:phone + assets:advances:siri 119 + +11-21 unot 4495530 + liabilities:payable:phone + expenses:non-vat:phone 13,50 + +11-21 unot 4495558 + liabilities:payable:phone + assets:advances:siri 21,60 + +11-22 unot 4495619 + liabilities:payable:phone + expenses:non-vat:phone 16,20 + +11-22 unot 4495626 + liabilities:payable:phone + expenses:non-vat:phone 18,90 + +11-22 unot 4495646 + liabilities:payable:phone + assets:advances:siri 32,40 + +11-24 unot 4495715 + liabilities:payable:phone + assets:advances:siri 32,40 + +11-28 unot 4496183 + liabilities:payable:phone + expenses:non-vat:phone 13,50 -09-19 unot 4474406 +11-28 unot 4496185 + liabilities:payable:phone + expenses:non-vat:phone 24,30 + +12-01 unot 4497396 + liabilities:payable:phone + expenses:non-vat:phone 119 + +12-01 unot 4497776 + liabilities:payable:phone + assets:advances:siri 127,10 + +12-02 unot 4501333 + liabilities:payable:phone + assets:advances:siri 10,80 + +12-13=2020-01-02 unot 4502972 liabilities:payable:internet - expenses:internet 477,60 - liabilities:tax:expenses 119,40 + expenses:internet 477,60 + liabilities:tax:expenses 119,40 + +12-16 unot 4504728 + liabilities:payable:phone + expenses:non-vat:phone 11,55 diff --git a/data/2019/income/kp.ledger b/data/2019/income/kp.ledger index 58eff0d..b468370 100644 --- a/data/2019/income/kp.ledger +++ b/data/2019/income/kp.ledger @@ -9,3 +9,15 @@ income:sales:redpill -24000; Redpill, april - juni: 3 mdr. á 10.000,- med 20% rabat income:sales:backup -1500; Fjernbackup, april - juni: 3 mdr. á 500,- liabilities:tax:sales -6375 + +09-23=10-01 019003; Vedr. Redpill - bæredygtig it-drift + assets:receivable:kp + income:sales:redpill -24000; Redpill, juli - september: 3 mdr. á 10.000,- med 20% rabat + income:sales:backup -1500; Fjernbackup, juli - september: 3 mdr. á 500,- + liabilities:tax:sales -6375 + +12-20=12-28 019008; Vedr. Redpill - bæredygtig it-drift + assets:receivable:kp + income:sales:redpill -24000; Redpill, oktober - december: 3 mdr. á 10.000,- med 20% rabat + income:sales:backup -1500; Fjernbackup, oktober - december: 3 mdr. á 500,- + liabilities:tax:sales -6375 diff --git a/data/2019/income/misc.ledger b/data/2019/income/misc.ledger new file mode 100644 index 0000000..008804c --- /dev/null +++ b/data/2019/income/misc.ledger @@ -0,0 +1,20 @@ +09-28=10-06 019004; Regarding FSuB Mitgliederversammlung + assets:receivable:fsub + expenses:non-vat:travel -38,90 EUR @@ 294,70; from:Holbaek to:Gütersloh + expenses:non-vat:travel -61,80 EUR @@ 468,19; from:Gütersloh to:Holbaek + +09-28=10-06 019005; Regarding FSuB hosting + assets:receivable:fsub + income:sales:eu:support -180 EUR; Server administration 2018: 6 months á EUR 30 + +09-28=10-06 019006; Regarding FSuB hosting + assets:receivable:fsub + income:sales:eu:support -360 EUR; Server administration 2019: 12 months á EUR 30 + +09-28=10-06 019007; Regarding Olimex tinker computers + assets:receivable:fsub + income:sales:eu:goods -180 EUR; A20-OLinuXino-LIME2-s16M: 4 boards á EUR 45.- + income:sales:eu:goods -28 EUR; BOX-LIME-SILVER: 4 boxes á EUR 7.- + income:sales:eu:goods -20 EUR; SY0605E: 4 power supplies á EUR 5.- + income:sales:eu:goods -10 EUR; SATA-CABLE-SET: 2 sets of cables á EUR 5.- + income:sales:eu:goods -72 EUR; SanDisk Extreme Pro 32GB: 4 uSD disks á EUR 18.- -- cgit v1.2.3