> On Sept. 21, 2013, 4:24 nachm., Alvaro Soliverez wrote:
> > I fail to see why you would want equity accounts displayed for imports. Can 
> > you explain the use case?
> > 
> > Keep in mind that equity accounts are not stock or share accounts of some 
> > kind.
> 
> Ralf Habacker wrote:
>     To be able to import opening balances for example when using german 
> template "all accounts", which have an account "Equity"->"Opening balances". 
> Otherwise I would have to manual enter the opening balances for all related 
> accounts by hand.
> 
> Alvaro Soliverez wrote:
>     These opening balances are exactly that, opening balances, and should not 
> have a payee assigned.
>     
>     That account is to balance the entry when you start using KMyMoney and 
> you enter the opening balances for your asset and liability accounts. As per 
> double-entry accounting, all transactions have to be balanced, and money 
> can't just pop out of the blue. 
>     
>     eg. you start using KMM on Jan 1, but you already had a bank account by 
> that date. You create the account and enter the balance on that date. To 
> balance that transaction, a split is assigned to "Equity/Opening balances". 
> No payees are involved.
>     
>     Sorry for the delay, this went under my radar.
>
> 
> Cristian Oneț wrote:
>     I understand what Alvaro is saying but is there a way to import opening 
> balances of accounts if one has many accounts? If there is not then I would 
> suggest shipping this patch since the visibility of the equity accounts is 
> controlled by the expert mode flag anyway. I really don't like limiting the 
> functionality in valid use cases just for the sake of simplicity.
> 
> Alvaro Soliverez wrote:
>     You can import opening balances, but you can't assign them a payee, 
> because it doesn't make sense. I'm opposing to this because so far I fail to 
> see the grounds to let that happen. Opening balances just don't have a payee.
> 
> Cristian Oneț wrote:
>     OK, I understand now, I mistakingly thought that Ralf's purpose is to 
> import the opening balances and not to assign them to a payee. I also see no 
> reason to assign opening balance transactions to payess, but it seems that 
> this is what the patch does. Ralf, how does the above patch help you import 
> opening balances?

Every year in September I'm creating financial reports with kmymoney for my 
little company. After that time I report any issue I found to the kmymoney 
developers with the hope to get this into kmymoney so that I and others can 
profit from the fixed issues or additional use case. After reporting this issue 
my available time frame was unfortunally over, but after perfoming the reports 
this year I'm coming back to this issue.

My use case is based on the following csv file, with which I want to import a 
whole account into KMymoney. As preparation I created a new file based on 
german skr3 account template, then I added three payees, the first named 
'Opening Balance' connected to the account "9000 Saldovortrag Sachkonten" which 
is the german default for storing opening balances. The other payees are 
connected to related expenses accounts. Then I imported the following csv file 
to the account "1200 Bankkonto".

Datum,Beleg,Ausgaben,Einnahmen,Text
01.01.15,,"","125,8",Opening Balance
19.01.15,1,"45,43",,payee1
30.01.15,2,"6,90",,payee2

I'm doing the same for all the additional accounts required to be imported and 
I do not need to enter the opening balance by hand for all those imports.

Hope that helps.


- Ralf


-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://git.reviewboard.kde.org/r/112847/#review40403
-----------------------------------------------------------


On Sept. 21, 2013, 2:41 nachm., Ralf Habacker wrote:
> 
> -----------------------------------------------------------
> This is an automatically generated e-mail. To reply, visit:
> https://git.reviewboard.kde.org/r/112847/
> -----------------------------------------------------------
> 
> (Updated Sept. 21, 2013, 2:41 nachm.)
> 
> 
> Review request for KMymoney and Cristian Oneț.
> 
> 
> Repository: kmymoney
> 
> 
> Description
> -------
> 
> When enabled display of equity accounts with 'settings->general->filter->show 
> equity accounts' equity accounts are not displayed in the "Default Account" 
> tab of payee page and in the unknown payee import dialog. 
> 
> The related bug could be triggered with: 
> 1. create a new file
> 2. select the german skr03 standard chart of accounts. 
> 
> 
> Diffs
> -----
> 
>   kmymoney/converter/mymoneystatementreader.cpp 5619cc2 
>   kmymoney/views/kgloballedgerview.cpp 2057b47 
>   kmymoney/views/kpayeesview.cpp 69697e6 
> 
> Diff: https://git.reviewboard.kde.org/r/112847/diff/
> 
> 
> Testing
> -------
> 
> git master
> 
> 
> Thanks,
> 
> Ralf Habacker
> 
>

Reply via email to