"strconv"
)
-//
-// hardcoded account ids we have to look at
-//
-// --- buy
-// wareneingang 19% and 7%
-const pid_buy_n = string("8e3b7c42e3173ed85f3d4736e82afb4d")
-const pid_buy_s = string("0cfd2ceb45fff89b9d1b7ce3af66cdf3")
-const pid_misc = string("e3acc2865dbf931e41cf2b90240de5c2")
-const pid_rep = string("b1d04ad157cac569f4299d4ddf94ed6f")
-const pid_room = string("4394ed4ffa7266f8f8731080926a7a61")
-const pid_cap = string("4196ee026d1bdb785df2c975fca91ae0")
-const aid_werbe = string("cb67d346eac01c2b66e2394df4e8d6e8")
-// abziehbare vst 19% and 7%
-const aid_vst_n = string("7c449e13125d6b93043f963628106db2")
-const aid_vst_s = string("006643c1c0a91f2b40614c75a49c6295")
-// --- sales
-// receipts
-const aid_rec_n = string("f3e905732b729ba096a50dab60559ce7")
-const aid_rec_s = string("66c1b04bd897766cb2be538094e1db6a")
-const aid_tip = string("1d20024badc11a99a8e1cf3a9a64a501")
-const aid_dep = string("9772f4e231f6f5e3100132cc53eb3447")
-// ust
-const aid_ust_n = string("e4bd6ff52408be8076f24aeb105893d9")
-const aid_ust_s = string("38bf40d16529f2a1e611c073c6c1dc9c")
-
type inv_accnts struct {
id string
taxval int
buy bool
}
-// make these account data the only one, above p/aids redundant!
-// we have all the information in here!
-
+//
+// account data --- add accounts to consider here!
+//
var iaa []inv_accnts = []inv_accnts{
// wareneingang 19% and 7% (note: pids!)
{ "8e3b7c42e3173ed85f3d4736e82afb4d",19,false,true },
{ "38bf40d16529f2a1e611c073c6c1dc9c", 7,true,false },
}
-// transacion exception list
-var trn_exc = []string{
+//
+// account exceptions
+//
+// account exceptions: nineteen to seven
+var n2s_exc = []string{
+}
+// account exceptions: nineteen to zero
+var n2z_exc = []string{
+ "4970 Nebenkosten des",
+ "4910 Porto",
+}
+// transaction exceptions: nineteen to seven
+var n2s_exc_ta = []string{
"GEMA",
+}
+// transaction exceptions: nineteen to zero
+var n2z_exc_ta = []string{
"Deutsche Post",
"gesetz IHK",
"Gesundheitsbelehrung",
"Unterrichtung Gastst",
}
-// account exception list
-var account_exc = []string{
- "4970 Nebenkosten des",
+// transacion exception list --- the rest, required?
+var trn_exc = []string{
}
// account maps
taxval int // 7 or 19
buy bool // buy or sales
tax bool // tax or non-tax(=goods) account
- rid []string // required transaction account(s)
}
// xml
Trn []Transaction `xml:"book>transaction"`
}
+// tax
+type TaxReport struct {
+ Expenses [2]int
+ InputTax [2]int
+ ExpExc [2]int
+ ITExc [2]int
+ Receipts [2]int
+ SalesTax [2]int
+}
+
// 'global' data
var data ParsedData
+var tax_report TaxReport
func main() {
for ac := range data.Accnt {
aid := data.Accnt[ac].AccountId
pid := data.Accnt[ac].ParentId
- // general map
- rid := make ([]string,10,10)
- accnt[aid]=amap{
- pid,ac,0,false,false,rid,
- }
- rid[0]="NONE"
- tmp := accnt[aid]
- switch {
- // ---- buy
- // -- goods
- case pid == pid_buy_n || pid == pid_misc || pid == pid_rep || pid == pid_room || pid == pid_cap || aid == aid_werbe:
- tmp.taxval=19
- tmp.buy=true
- rid[0]=aid_vst_n
- accnt[aid]=tmp
- case pid == pid_buy_s:
- tmp.taxval=7
- tmp.buy=true
- rid[0]=aid_vst_s
- accnt[aid]=tmp
- // -- tax
- case aid == aid_vst_n:
- tmp.taxval=19
- tmp.buy=true
- tmp.tax=true
- rid=[]string{pid_buy_n,pid_misc,pid_rep,pid_room,pid_cap,aid_werbe,}
- accnt[aid]=tmp
- case aid == aid_vst_s:
- tmp.taxval=7
- tmp.buy=true
- tmp.tax=true
- rid[0]=pid_buy_s
- accnt[aid]=tmp
- // ---- sales ----
- // -- receipts
- case aid == aid_rec_n || aid == aid_tip || aid == aid_dep:
- tmp.taxval=19
- rid[0]=aid_ust_n
- accnt[aid]=tmp
- case aid == aid_rec_s:
- tmp.taxval=7
- rid[0]=aid_ust_s
- accnt[aid]=tmp
- // -- tax
- case aid == aid_ust_n:
- tmp.taxval=19
- tmp.tax=true
- rid=[]string{aid_rec_n,aid_tip,aid_dep,}
- accnt[aid]=tmp
- case aid == aid_ust_s:
- tmp.taxval=7
- tmp.tax=true
- rid[0]=aid_rec_s
- accnt[aid]=tmp
+ for iac := range iaa {
+ // consider account if pid or aid matches
+ if pid == iaa[iac].id || aid == iaa[iac].id {
+ taxval := iaa[iac].taxval
+ for ec := range n2s_exc {
+ if strings.Contains(data.Accnt[ac].Name,
+ n2s_exc[ec]) {
+ taxval=7
+ break
+ }
+ }
+ for ec := range n2z_exc {
+ if strings.Contains(data.Accnt[ac].Name,
+ n2z_exc[ec]) {
+ taxval=0
+ break
+ }
+ }
+ accnt[aid]=amap{
+ pid,
+ ac,
+ taxval,
+ iaa[iac].buy,
+ iaa[iac].tax,
+ }
+ break
+ }
}
}
check_balance(&data.Trn[tc],accnt,sel_date)
}
+ // tax report
+ fmt.Println("Umsatzsteuervoranmeldung (19% | 7%):")
+ fmt.Println("------------------------------------")
+ fmt.Println("Aufwendungen:",tax_report.Expenses[0],
+ tax_report.Expenses[1]);
+ fmt.Println("ohne Ausn. :",tax_report.Expenses[0]-
+ tax_report.ExpExc[0],
+ tax_report.Expenses[1]-
+ tax_report.ExpExc[1]);
+ fmt.Println("gesch. Vst. :",int((tax_report.Expenses[0]*19)/100.0),
+ int((tax_report.Expenses[1]*7)/100.0))
+ fmt.Println("ohne Ausn. :",int(((tax_report.Expenses[0]-
+ tax_report.ExpExc[0])*19)/100.0),
+ int(((tax_report.Expenses[1]-
+ tax_report.ExpExc[1])*7)/100.0))
+ fmt.Println("Vorsteuer :",tax_report.InputTax[0],
+ tax_report.InputTax[1],
+ "->",tax_report.InputTax[0]+tax_report.InputTax[1]);
+ fmt.Println("------------------------------------")
+ fmt.Println("Einnahmen :",-tax_report.Receipts[0],
+ -tax_report.Receipts[1]);
+ fmt.Println("gesch. Ust. :",int((-tax_report.Receipts[0]*19)/100.0),
+ int((-tax_report.Receipts[1]*7)/100.0));
+ fmt.Println("Umsatzsteuer:",-tax_report.SalesTax[0],
+ -tax_report.SalesTax[1]);
+ fmt.Println("------------------------------------")
+
}
func check_balance(ta *Transaction,accnt map[string]amap,sel_date string) bool {
tdate := strings.Fields(ta.Date)[0]
if !strings.Contains(tdate,sel_date) {
return true
- } else {
+ }
+
+ // exceptions
+ tv_ow := -1
+ for ec := range n2s_exc_ta {
+ if strings.Contains(ta.Description,n2s_exc_ta[ec]) {
+ tv_ow=7
+ break
+ }
+ }
+ for ec := range n2z_exc_ta {
+ if strings.Contains(ta.Description,n2z_exc_ta[ec]) {
+ tv_ow=0
+ break
+ }
}
// [taxval: 19=0 7=1][tax: no=0 yes=1][buy: no=0 yes=1]
aid := ta.Spl[sc].AccountId
//accnt[aid].tax
for iac := range iaa {
- // taxval
tv := int(0)
- if iaa[iac].taxval == 7 {
- tv = 1
+ // taxval - check accnt instead of iaa!
+ if tv_ow != -1 {
+ if tv_ow == 7 {
+ tv=1
+ }
+ if tv_ow == 0 {
+ continue
+ }
+ } else {
+ if accnt[aid].taxval == 0 {
+ continue
+ }
+ if accnt[aid].taxval == 7 {
+ tv = 1
+ }
}
// tax
tax := int(0)
// check for exceptions
exc := false
for ec := range trn_exc {
- if ta.Description == trn_exc[ec] {
+ if strings.Contains(ta.Description,trn_exc[ec]) {
exc = true
break
}
// }
//}
+ // tax report
+ for tv := 0; tv<2; tv++ {
+ tax_report.Expenses[tv] += sum[tv][0][1]
+ tax_report.InputTax[tv] += sum[tv][1][1]
+ tax_report.Receipts[tv] += sum[tv][0][0]
+ tax_report.SalesTax[tv] += sum[tv][1][0]
+ if exc {
+ tax_report.ExpExc[tv] += sum[tv][0][1]
+ tax_report.ITExc[tv] += sum[tv][1][1]
+ }
+ }
+
// check
var expected [2]int
check := true