Beancount

Source

1  include "eth-prices.bean"
2  
3  2019-08-30 custom "fava-option" "language" "en"
4  
5  2019-08-30 open Assets:Cash:TWD TWD
6  
7  ; 放在 Yuren 的國泰世華帳戶代管
8  2019-08-30 open Assets:Bank:Cathy:TWD TWD
9  
10  ; Taipei Ethereum Meetup Gnosis Wallet
11  ; https://etherscan.io/address/0x91a06469ded8eeb064c7a273ee947e380e1494d8
12  2019-08-30 open Assets:Ethereum:GnosisWallet:ETH ETH "FIFO"
13  2019-08-30 open Assets:Ethereum:GnosisWallet:DAI DAI "FIFO"
14  
15  ; Taipei Ethereum Meetup Gnosis Safe Wallet
16  ; https://app.safe.global/eth:0x3BB6938118bbc1e63e56ABB94dBa66570F4BB0d0/balances
17  2021-08-01 open Assets:Ethereum:GnosisSafe "FIFO"
18  
19  2019-08-30 open Equity:Opening-Balances
20  
21  ; Yuren 代墊的欠款
22  2019-08-30 open Liabilities:Yuren TWD
23  2019-10-04 close Liabilities:Yuren
24  
25  2019-08-30 open Income:Sponsor:ETH
26  2019-08-30 open Income:Sponsor:TWD
27  2019-08-30 open Income:RegisteryFee
28  2019-08-30 open Income:PreviousEventRevenue
29  2019-08-30 open Income:Donation
30  
31  2019-08-30 open Income:Trade:PnL
32  
33  2019-10-04 open Expenses:Supplies
34  2019-10-04 open Expenses:Bank:TransactionFee
35  2019-10-09 open Expenses:Venue
36  2019-10-09 open Expenses:Food
37  2019-10-09 open Expenses:TicketRefund
38  2019-10-09 open Expenses:Wifi
39  2019-10-23 open Expenses:Recording
40  2019-10-23 open Expenses:Insurance
41  2019-10-23 open Expenses:HostFee
42  2019-10-23 open Expenses:Photography
43  2019-10-23 open Expenses:FlightTicketAllowance
44  2019-10-23 open Expenses:InvoiceServiceFee
45  2019-11-30 open Expenses:EthereumTransactionFee
46  2019-10-23 open Expenses:EthereumNameService
47  2019-10-23 open Expenses:Salary
48  2019-10-23 open Expenses:Grant
49  
50  option "operating_currency" "TWD"
51  
52  2019-08-30 * "Yuren" "代墊"
53      Assets:Bank:Cathy:TWD                 100,000.0 TWD
54      Liabilities:Yuren
55  
56  2019-08-30 * "初始金額"
57      Assets:Ethereum:GnosisWallet:ETH            0.866521001981 ETH {5,392.0 TWD}
58      Equity:Opening-Balances
59  
60  2019-09-02 * "GPUMINE & Block2" "贊助金"
61      tx: "0x10b311cd3c53440c5fde6b087a9553c8d081ff515011e7092683a250de14da24"
62      Assets:Ethereum:GnosisWallet:ETH            5.0 ETH {5,382.9 TWD}
63      Income:Sponsor:ETH
64  
65  2019-09-17 * "英屬維京群島商幣託科技有限公司" "贊助金"
66      companyid: "56346103"
67      Assets:Bank:Cathy:TWD                  50,000.0 TWD
68      Income:Sponsor:TWD
69  
70  2019-09-19 * "imToken" "贊助金"
71      tx: "0x54299a3c4b915e96e07bb79fd150276ab85f6154029f16828cd8439531302113"
72      Assets:Ethereum:GnosisWallet:ETH            7.796 ETH {6,461.8 TWD}
73      Income:Sponsor:ETH
74  
75  2019-09-24 * "Aragon" "贊助金"
76      tx: "0x8262c3c6f2998e794110309225be023f067c49144704f4ca1d4709a5a2fe9b8e"
77      Assets:Ethereum:GnosisWallet:ETH            7.71 ETH {6,100.0 TWD}
78      Income:Sponsor:ETH
79  
80  2019-09-27 * "Ehtereum Foundation" "贊助金"
81      tx: "0xe908002b0c6b57b96a82dd0b6e720244016c6c1cd59fbeb442107aefb2a7b937"
82      Assets:Ethereum:GnosisWallet:ETH           23.9908834643 ETH {5,200.0 TWD}
83      Income:Sponsor:ETH
84  
85  2019-10-01 * "現代財富科技有限公司" "贊助金"
86      companyid: "54687323"
87      Assets:Bank:Cathy:TWD                  50,000.0 TWD
88      Income:Sponsor:TWD
89  
90  2019-10-04 * "豐島國際有限公司" "矽膠手環訂金"
91      Expenses:Supplies                        3801.0 TWD
92      Expenses:Bank:TransactionFee               15.0 TWD
93      Assets:Bank:Cathy:TWD
94  
95  2019-10-04 * "Yuren" "代墊取回"
96      Liabilities:Yuren                      100,000.0 TWD
97      Assets:Bank:Cathy:TWD
98  
99  2019-10-09 * "智成" "代墊場地頭期款"
100      Expenses:Venue                         40,000.0 TWD
101      Expenses:Bank:TransactionFee               15.0 TWD
102      Assets:Bank:Cathy:TWD
103  
104  2019-10-16 * "豐島國際有限公司" "矽膠手環尾款"
105      Expenses:Supplies                        3801.0 TWD
106      Expenses:Bank:TransactionFee               15.0 TWD
107      Assets:Bank:Cathy:TWD
108  
109  2019-10-15 * "Monolith" "贊助金"
110      tx: "0xdd962038b3c4d57232a4e817aca3989082291dfe22d3d4995b1de5658b2db7cf"
111      Assets:Ethereum:GnosisWallet:ETH            8.72 ETH {5660.0 TWD}
112      Income:Sponsor:ETH
113  
114  2019-10-16 * "轉換成 DAI 避險"
115      Assets:Ethereum:GnosisWallet:DAI        4,841.125498343072985426 DAI {30.6081846 TWD}
116      Assets:Ethereum:GnosisWallet:ETH          -27.0 ETH {}
117      Income:Trade:PnL
118  
119  2019-10-17 * "把 DAI 換成台幣"
120      Assets:Bank:Cathy:TWD                 145,972.0 TWD
121      Assets:Ethereum:GnosisWallet:DAI        -4841.12 DAI {}
122      Income:Trade:PnL
123  
124  2019-10-19 * "提款"
125      Assets:Cash:TWD                         70000.0 TWD
126      Assets:Bank:Cathy:TWD
127  
128  2019-10-19 * "現場報名"
129      Assets:Cash:TWD                          2400.0 TWD
130      Income:RegisteryFee
131  
132  2019-10-20 * "礦泉水一箱"
133      Expenses:Supplies                         672.0 TWD
134      Assets:Cash:TWD
135  
136  2019-10-20 * "衛生紙"
137      Expenses:Supplies                         119.0 TWD
138      Assets:Cash:TWD
139  
140  2019-10-20 * "講者便當"
141      Expenses:Food                            9450.0 TWD
142      Assets:Cash:TWD
143  
144  2019-10-20 * "額外加點的點心"
145      Expenses:Food                            4650.0 TWD
146      Assets:Cash:TWD
147  
148  2019-10-20 * "退費給 CTF 得獎者的購票折扣"
149      Expenses:TicketRefund                     720.0 TWD
150      Assets:Cash:TWD
151  
152  2019-10-20 * "After party 餐費"
153      Expenses:Food                          34,940.0 TWD
154      Assets:Cash:TWD
155  
156  2019-10-21 * "之前活動盈餘款項"
157      Assets:Bank:Cathy:TWD                  22,303.0 TWD
158      Income:PreviousEventRevenue
159  
160  2019-10-23 * "星衍數位印刷有限公司" "印刷輸出"
161      Expenses:Supplies                       8,620.0 TWD
162      Expenses:Bank:TransactionFee               15.0 TWD
163      Assets:Bank:Cathy:TWD
164  
165  2019-10-23 * "可立可股份有限公司" "Wifi"
166      Expenses:Wifi                          30,000.0 TWD
167      Expenses:Bank:TransactionFee               15.0 TWD
168      Assets:Bank:Cathy:TWD
169  
170  2019-10-23 * "活動錄影紀錄"
171      Expenses:Recording                     24,000.0 TWD
172      Expenses:Bank:TransactionFee               15.0 TWD
173      Assets:Bank:Cathy:TWD
174  
175  2019-10-25 * "第一產物保險股份有限公司" "活動保險"
176      Expenses:Insurance                      2,480.0 TWD
177      Expenses:Bank:TransactionFee               15.0 TWD
178      Assets:Bank:Cathy:TWD
179  
180  2019-10-26 * "主持人費用"
181      Expenses:HostFee                        5,000.0 TWD
182      Expenses:Bank:TransactionFee               15.0 TWD
183      Assets:Bank:Cathy:TWD
184  
185  2019-10-26 * "平面攝影費用"
186      Expenses:Photography                   10,000.0 TWD
187      Expenses:Bank:TransactionFee               15.0 TWD
188      Assets:Bank:Cathy:TWD
189  
190  2019-10-26 * "ETH 換 DAI"
191      Assets:Ethereum:GnosisWallet:DAI          267.826116509551362445 DAI {30.5782344 TWD}
192      Assets:Ethereum:GnosisWallet:ETH           -1.5 ETH {}
193      Income:Trade:PnL
194  
195  2019-10-26 * "ETH 機票補助共四位"
196      Expenses:FlightTicketAllowance              1.149969403 ETH {5493.6 TWD}
197      Expenses:FlightTicketAllowance              1.904703614 ETH {5493.6 TWD}
198      Expenses:FlightTicketAllowance              2.40721926 ETH {5493.6 TWD}
199      Expenses:FlightTicketAllowance              2.644336712 ETH {5493.6 TWD}
200      Assets:Ethereum:GnosisWallet:ETH           -8.106228989 ETH {}
201      Income:Trade:PnL
202  
203  2019-10-26 * "DAI 機票補助共一位"
204      Expenses:FlightTicketAllowance            250.3216 DAI {30.5782344 TWD}
205      Assets:Ethereum:GnosisWallet:DAI         -250.3216 DAI {}
206      Income:Trade:PnL
207  
208  2019-10-27 * "ETH 換 DAI"
209      Assets:Ethereum:GnosisWallet:DAI          218.140783827457422974 DAI {30.5782344 TWD}
210      Assets:Ethereum:GnosisWallet:ETH           -1.22 ETH {}
211      Income:Trade:PnL
212  
213  
214  2019-10-27 * "DAI 機票補助補發金額"
215      Expenses:FlightTicketAllowance            229.6784 DAI {30.5782344 TWD}
216      Assets:Ethereum:GnosisWallet:DAI         -229.6784 DAI {}
217  
218  2019-10-29 * "日觀實業" "參加者便當、會議點心"
219      Expenses:Food                          79,240.0 TWD
220      Expenses:Bank:TransactionFee               15.0 TWD
221      Assets:Bank:Cathy:TWD
222  
223  2019-11-11 * "Accupass" "門票收入"
224      Assets:Bank:Cathy:TWD                 156,538.0 TWD
225      Income:RegisteryFee
226  
227  2019-11-13 * "共識科技" "代開發票服務費"
228      Expenses:InvoiceServiceFee             11,061.0 TWD
229      Expenses:Bank:TransactionFee               15.0 TWD
230      Assets:Bank:Cathy:TWD
231  
232  2019-11-13 * "雜支"
233      Expenses:Supplies                         779.0 TWD ; 乾電池、印刷品等
234      Expenses:Supplies                         788.0 TWD ; 礦泉水
235      Expenses:Food                          15,034.0 TWD ; 慶功宴
236      Assets:Bank:Cathy:TWD
237  
238  2019-11-13 * "給設計師的衣服與運費"
239      Expenses:Supplies                       1,845.0 TWD
240      Expenses:Bank:TransactionFee               15.0 TWD
241      Assets:Bank:Cathy:TWD
242  
243  2019-11-13 * "會場油漆掉落的補油漆費用"
244      Expenses:Supplies                       1,750.0 TWD
245      Expenses:Bank:TransactionFee               15.0 TWD
246      Assets:Bank:Cathy:TWD
247  
248  2019-11-20 * "把台幣全部換成 DAI 2.0"
249      Assets:Bank:Cathy:TWD                -116,419.0 TWD
250      Assets:Cash:TWD                       -21,849.0 TWD
251      Assets:Ethereum:GnosisWallet:DAI        4,486.771749455375278881 DAI {30.450 TWD}
252      Income:Trade:PnL
253  
254  2019-11-30 * "ethtaipei.eth 費用"
255      tx: "https://etherscan.io/address/0x9271267a75abd9fc98a1be1870748fe221816092"
256      note: "我轉帳有轉錯,所以裡面有三筆 tx,請看上面這筆跟他的前兩筆"
257      Expenses:EthereumNameService 0.032826965310591524 ETH {4682 TWD}
258      Expenses:EthereumTransactionFee 0.000231000000020000 ETH {4682 TWD}
259      Assets:Ethereum:GnosisWallet:ETH -0.033057965310611524 ETH {}
260      Income:Trade:PnL
261  
262  2019-12-01 balance Assets:Ethereum:GnosisWallet:ETH 16.224117511970388476 ETH
263  
264  2021-08-01 * "DAI 轉到新的 gnosis safe wallet"
265      tx: "https://etherscan.io/tx/0x7b4600dd6465f1881e418290cc20e8aec23453c0854b494be8aabb337f282119"
266      note: "原本的 multisign 要 deprecated 了,DAI 需要轉移到新 Wallet"
267      Assets:Ethereum:GnosisSafe 5.972398680081770845 DAI {30.5782344 TWD, 2019-10-27}
268      Assets:Ethereum:GnosisSafe 4486.767601319918229155 DAI {30.450 TWD, 2019-11-20}
269      Assets:Ethereum:GnosisWallet:DAI -5.972398680081770845 DAI {30.5782344 TWD, 2019-10-27}
270      Assets:Ethereum:GnosisWallet:DAI -4486.767601319918229155 DAI {30.450 TWD, 2019-11-20}
271  
272  2021-08-01 * "ETH 轉到新的 gnosis safe wallet"
273      tx: "https://etherscan.io/tx/0xdb049f6b453fa5db344b87f3bef964011ef736c3ebe8ba7f851c31bbade7e2f5"
274      note: "原本的 multisign 要 deprecated 了,ETH 需要轉移到新 Wallet"
275      Assets:Ethereum:GnosisSafe 7.504117511970388476 ETH {5200.0 TWD, 2019-09-27}
276      Assets:Ethereum:GnosisSafe 8.705882488029611524 ETH {5660.0 TWD, 2019-10-15}
277      Assets:Ethereum:GnosisWallet:ETH -7.504117511970388476 ETH {5200.0 TWD, 2019-09-27}
278      Assets:Ethereum:GnosisWallet:ETH -8.705882488029611524 ETH {5660.0 TWD, 2019-10-15}
279  
280  2021-08-02 balance Assets:Ethereum:GnosisWallet:ETH 0.014117511970388476 ETH
281  2021-08-02 balance Assets:Ethereum:GnosisWallet:DAI 0.004148135457049726 DAI
282  
283  2023-01-20 * "5 ETH 轉成 DAI 準備付款給 Bing"
284      tx: "https://etherscan.io/tx/0xa66ba9bb9442ec94168ed13eadf51ff2f8d654722667b0a3b00305d143d2595b"
285      note: "約需要支出 10,964.03 DAI,但是只有 4492.74 DAI,所以用 5 ETH 換出 DAI"
286      Assets:Ethereum:GnosisSafe -5 ETH {}
287      Assets:Ethereum:GnosisSafe 7,748.392827068036191747 DAI {30.43 TWD}
288      Income:Trade:PnL
289  
290  2023-01-20 * "轉帳 10,964.03 DAI 給 Bing"
291      tx: "https://etherscan.io/tx/0x7244065245a9e225b2097a1779015b9bcd0346291afd84ced2053484e340f10d"
292      Assets:Ethereum:GnosisSafe -10,964.03 DAI {}
293      Expenses:Salary
294  
295  2023-07-30 * "Nic 捐贈審稿經費"
296      tx: "https://etherscan.io/tx/0x951b513b9ffe1189205b4f38bb3d8a0eb654a248b2b7506c43ee931aa7a176da"
297      Assets:Ethereum:GnosisSafe                 20.0 DAI { 31.34 TWD}
298      Income:Donation
299  
300  2023-09-14 * "Nic 捐贈審稿經費"
301      tx: "https://etherscan.io/tx/0x22b6b5d14a85f119b5a1d7ffdabf371f2a03af23c81486f21184f6f7d05767fb"
302      Assets:Ethereum:GnosisSafe                 60.0 DAI { 31.83 TWD}
303      Income:Donation
304  
305  2023-09-14 * "Nic 捐贈審稿經費 - 2 (同一天)"
306      tx: "https://etherscan.io/tx/0x87170b0969f18f322e0c1c61569621352921e0054c2822741cf7824976e6e5d2"
307      Assets:Ethereum:GnosisSafe                 60.0 DAI { 31.83 TWD}
308      Income:Donation
309  
310  2023-10-05 * "Nic 捐贈審稿經費"
311      tx: "https://etherscan.io/tx/0x99ef4a7ddf6fd4c900b59761f3c2d337e78220540eb10c98e58a831318e8e26d"
312      Assets:Ethereum:GnosisSafe                 40.0 DAI { 32.27 TWD}
313      Income:Donation
314  
315  
316  2024-01-15 * "Nic 捐贈審稿經費"
317      tx: "https://etherscan.io/tx/0x0a4ce1c4d8567f8951040db217165cf13d20a611b2adf31a71c244176e285f77"
318      Assets:Ethereum:GnosisSafe                 40.0 DAI { 30.94 TWD}
319      Income:Donation
320  
321  2024-01-30 * "LunDAO 捐款 5 ETH"
322      tx: "https://etherscan.io/tx/0xeef3467e94b20855399873f273f860269696626adca36deb8fc9a0fd0c5e0964"
323      Assets:Ethereum:GnosisSafe                  5.00 ETH {72215.36 TWD}
324      Income:Donation
325  
326  2024-03-07 * "Bing 申請 400 USD - 04/23 TEM Happy Hour"
327      tx: "https://etherscan.io/tx/0x7b8bf98c8ddd8aa84cbc043f03bf30d2e325853853d0733b891ebce72d59fa1c"
328      url: "https://hackmd.io/@hugebing/BkQN3ZU6a"
329      Assets:Ethereum:GnosisSafe               -400.00 DAI {}
330      Expenses:Venue
331  
332  2024-04-07 price ETH 109,021 TWD
333  2024-04-07 price DAI 32.14 TWD
334  
335  2024-04-08 balance Assets:Ethereum:GnosisSafe 16.21 ETH
336  2024-04-08 balance Assets:Ethereum:GnosisSafe 1,097.102827068036191747 DAI
337  
338  2024-04-22 * "transfer for meetup"
339      url: "https://etherscan.io/tx/0x7404e1e729fec021e7b437556c1c1918b28dfd104ce7f7fa69084915b4115b31"
340      Assets:Ethereum:GnosisSafe               -188.82 DAI {}
341      Expenses:HostFee
342  
343  2024-04-22 * "transfer for zk taipei's luma annual fee"
344      url: "https://etherscan.io/tx/0x7404e1e729fec021e7b437556c1c1918b28dfd104ce7f7fa69084915b4115b31"
345      Assets:Ethereum:GnosisSafe               -0.271358859 ETH {}
346      Expenses:Grant
347  
348  2024-04-23 balance Assets:Ethereum:GnosisSafe 15.938641141 ETH
349  2024-04-23 balance Assets:Ethereum:GnosisSafe 908.282827068036191747 DAI
350  
351  2024-06-09 price ETH 119,463 TWD
352  
353  2024-06-09 * "transfer to Bing for 2023 community coordination"
354      url: "https://etherscan.io/tx/0x49e72b3edc219d8e3946a653910995755f9417f5fe061d905eb0b017a7920a27"
355      github: "https://github.com/EtherTW/accounting/issues/10"
356      Assets:Ethereum:GnosisSafe                 -2.90625 ETH {}
357      Expenses:Salary
358  
359  2024-06-10 balance Assets:Ethereum:GnosisSafe 13.032391141 ETH