Review Request 112847: Display equity accounts when enabled in payees page and unknown payee import dialog

Ralf Habacker ralf.habacker at freenet.de
Fri Sep 30 12:45:50 UTC 2016



> 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
> 
>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.kde.org/pipermail/kmymoney-devel/attachments/20160930/068746ca/attachment.html>


More information about the KMyMoney-devel mailing list