12 type inv_accnts struct {
20 // accounts considered in tax included balance check
22 var iaa []inv_accnts = []inv_accnts{
23 // wareneingang 19% and 7% (note: pids!)
24 { "8e3b7c42e3173ed85f3d4736e82afb4d",19,false,true },
25 { "0cfd2ceb45fff89b9d1b7ce3af66cdf3", 7,false,true },
26 { "e3acc2865dbf931e41cf2b90240de5c2",19,false,true },
27 { "b1d04ad157cac569f4299d4ddf94ed6f",19,false,true },
28 { "4394ed4ffa7266f8f8731080926a7a61",19,false,true },
29 { "4196ee026d1bdb785df2c975fca91ae0",19,false,true },
31 { "cb67d346eac01c2b66e2394df4e8d6e8",19,false,true },
32 // abziehbare vst 19% and 7%
33 { "7c449e13125d6b93043f963628106db2",19,true,true },
34 { "006643c1c0a91f2b40614c75a49c6295", 7,true,true },
37 { "f3e905732b729ba096a50dab60559ce7",19,false,false },
38 { "66c1b04bd897766cb2be538094e1db6a", 7,false,false },
39 { "1d20024badc11a99a8e1cf3a9a64a501",19,false,false },
40 { "9772f4e231f6f5e3100132cc53eb3447",19,false,false },
42 { "e4bd6ff52408be8076f24aeb105893d9",19,true,false },
43 { "38bf40d16529f2a1e611c073c6c1dc9c", 7,true,false },
49 // account exceptions: nineteen to seven
50 var n2s_exc = []string{
52 // account exceptions: nineteen to zero
53 var n2z_exc = []string{
54 "4970 Nebenkosten des",
57 // transaction exceptions: nineteen to seven
58 var n2s_exc_ta = []string{
61 // transaction exceptions: nineteen to zero
62 var n2z_exc_ta = []string{
65 "Gesundheitsbelehrung",
66 "Gewerbezentralregister",
67 "Entgeltabrechnung siehe Anlage",
70 "Unterrichtung Gastst",
74 // transacion exception list --- the rest, required?
75 var trn_exc = []string{
79 // accounts which will be summed up
82 type sum_accnt struct {
89 var summed_accounts = []sum_accnt{
90 {"Bankkonto","02ea930fdcc500cf7d3a21b80a126eb0",0,0},
91 {"Kasse","04e71353130ccb554ebaf4c2438d6b2f",0,0},
96 pid string // parent id
97 num int // account number
99 buy bool // buy or sales
100 tax bool // tax or non-tax(=goods) account
104 type Account struct {
105 XMLName xml.Name `xml:"account"`
106 Name string `xml:"name"`
107 AccountId string `xml:"id"`
108 ParentId string `xml:"parent"`
111 XMLName xml.Name `xml:"split"`
113 Value string `xml:"value"`
114 Quantity string `xml:"quantity"`
115 AccountId string `xml:"account"`
117 type Transaction struct {
118 XMLName xml.Name `xml:"transaction"`
120 Date string `xml:"date-posted>date"`
121 Description string `xml:"description"`
122 Spl []Split `xml:"splits>split"`
124 type ParsedData struct {
125 XMLName xml.Name `xml:"gnc-v2"`
126 DataCnt []string `xml:"count-data"`
127 Accnt []Account `xml:"book>account"`
128 Trn []Transaction `xml:"book>transaction"`
132 type TaxReport struct {
143 var tax_report TaxReport
149 if len(os.Args) > 1 {
150 sel_date = os.Args[1]
154 file, err := os.Open("c13_skr03.gnucash")
156 fmt.Println("Error opening file:", err)
162 xmldata, err := ioutil.ReadAll(file)
164 fmt.Println("Error reading file:", err)
168 // unmarshal xml data
169 err = xml.Unmarshal(xmldata,&data)
171 fmt.Println("Error unmarshaling xml data:", err)
175 // whooha, this is our data!
176 fmt.Println("Parsed accounts:",len(data.Accnt))
177 fmt.Println("Parsed transactions:",len(data.Trn))
180 accnt := make(map[string]amap)
182 for ac := range data.Accnt {
183 aid := data.Accnt[ac].AccountId
184 pid := data.Accnt[ac].ParentId
185 for iac := range iaa {
186 // consider account if pid or aid matches
187 if pid == iaa[iac].id || aid == iaa[iac].id {
188 taxval := iaa[iac].taxval
189 for ec := range n2s_exc {
190 if strings.Contains(data.Accnt[ac].Name,
196 for ec := range n2z_exc {
197 if strings.Contains(data.Accnt[ac].Name,
215 // check transactions ...
216 for tc := range data.Trn {
218 check_balance(&data.Trn[tc],accnt,sel_date)
222 fmt.Println("Umsatzsteuervoranmeldung (19% | 7%):")
223 fmt.Println("------------------------------------")
224 fmt.Println("Aufwendungen:",tax_report.Expenses[0],
225 tax_report.Expenses[1]);
226 fmt.Println("ohne Ausn. :",tax_report.Expenses[0]-
227 tax_report.ExpExc[0],
228 tax_report.Expenses[1]-
229 tax_report.ExpExc[1]);
230 fmt.Println("gesch. Vst. :",int((tax_report.Expenses[0]*19)/100.0),
231 int((tax_report.Expenses[1]*7)/100.0))
232 fmt.Println("ohne Ausn. :",int(((tax_report.Expenses[0]-
233 tax_report.ExpExc[0])*19)/100.0),
234 int(((tax_report.Expenses[1]-
235 tax_report.ExpExc[1])*7)/100.0))
236 fmt.Println("Vorsteuer :",tax_report.InputTax[0],
237 tax_report.InputTax[1],
238 "->",tax_report.InputTax[0]+tax_report.InputTax[1]);
239 fmt.Println("------------------------------------")
240 fmt.Println("Einnahmen :",-tax_report.Receipts[0],
241 -tax_report.Receipts[1]);
242 fmt.Println("gesch. Ust. :",int((-tax_report.Receipts[0]*19)/100.0),
243 int((-tax_report.Receipts[1]*7)/100.0));
244 fmt.Println("Umsatzsteuer:",-tax_report.SalesTax[0],
245 -tax_report.SalesTax[1]);
246 fmt.Println("------------------------------------")
250 fmt.Println("Summen einiger Konten:")
251 fmt.Println("----------------------")
252 for sac := range summed_accounts {
253 saccnt := summed_accounts[sac]
254 fmt.Println(" Konto: ",saccnt.name)
255 fmt.Println(" +: ",saccnt.valplus)
256 fmt.Println(" -: ",saccnt.valminus)
260 func check_balance(ta *Transaction,accnt map[string]amap,sel_date string) bool {
263 tdate := strings.Fields(ta.Date)[0]
264 if !strings.Contains(tdate,sel_date) {
270 for ec := range n2s_exc_ta {
271 if strings.Contains(ta.Description,n2s_exc_ta[ec]) {
276 for ec := range n2z_exc_ta {
277 if strings.Contains(ta.Description,n2z_exc_ta[ec]) {
283 // [taxval: 19=0 7=1][tax: no=0 yes=1][buy: no=0 yes=1]
286 // loop over splits within the transaction
287 for sc := range ta.Spl {
288 aid := ta.Spl[sc].AccountId
290 // loop over all considered accounts (defined earlier as global)
291 for iac := range iaa {
293 // taxval changed by exception
299 // reset taxvalues of involved accounts
300 // (to drop an error)
302 if accnt[aid].taxval==7 {
309 // taxval as defined by account
311 if accnt[aid].taxval == 0 {
313 fmt.Println("FATAL!");
317 if accnt[aid].taxval == 7 {
331 // match! add to sum and break.
334 if tax == 0 && buy == 1 {
335 _, exists := accnt[aid]
338 if accnt[aid].pid == iaa[iac].id {
343 // ... however, always check aids
344 if aid == iaa[iac].id {
348 inc, _ := strconv.Atoi(strings.TrimSuffix(ta.Spl[sc].Value,"/100"))
349 sum[tv][tax][buy] += inc
354 for sac := range summed_accounts {
355 if summed_accounts[sac].aid == aid {
356 inc, _ := strconv.Atoi(strings.TrimSuffix(ta.Spl[sc].Value,"/100"))
358 summed_accounts[sac].valplus += inc
360 summed_accounts[sac].valminus += inc
366 // check for exceptions
368 for ec := range trn_exc {
369 if strings.Contains(ta.Description,trn_exc[ec]) {
374 //for ac := range accountlist {
375 // if strings.Contains(data.Accnt[anum].Name,accountlist[ac]){
381 for tv := 0; tv<2; tv++ {
382 tax_report.Expenses[tv] += sum[tv][0][1]
383 tax_report.InputTax[tv] += sum[tv][1][1]
384 tax_report.Receipts[tv] += sum[tv][0][0]
385 tax_report.SalesTax[tv] += sum[tv][1][0]
387 tax_report.ExpExc[tv] += sum[tv][0][1]
388 tax_report.ITExc[tv] += sum[tv][1][1]
395 for buy := 0; buy < 2; buy++ {
396 expected[0]=int((sum[0][0][buy]*19)/100.0)
397 expected[1]=int((sum[1][0][buy]*7)/100.0)
398 for tv :=0; tv < 2; tv++ {
399 if expected[tv] < sum[tv][1][buy]-1 ||
400 expected[tv] > sum[tv][1][buy]+1 {
413 fmt.Printf("%s %s: ",sb,st);
414 fmt.Printf("Erwarte %d statt %d aus %d! ",
416 sum[tv][1][buy],sum[tv][0][buy]);
420 fmt.Printf("Ausnahme greift!\n");
421 fmt.Printf("(%s)\n\n",ta.Description)
427 fmt.Println("am",ta.Date)
428 fmt.Printf("(%s)\n",ta.Description)
429 fmt.Println("Beteiligte Konten:")
430 for ic := range ta.Spl {
431 found := strings.TrimSuffix(ta.Spl[ic].Value,"/100")
432 aid := ta.Spl[ic].AccountId
433 _, exists := accnt[aid]
435 num := accnt[aid].num
436 fmt.Printf(" %s => %s\n",data.Accnt[num].Name,
439 fmt.Printf(" %s => %s\n",aid,found)
448 func round(v float64) int {