[Kmymoney] Re: QIF import problems

[timothy]

On Tue, 2011-05-24 at 01:28 +0100, aga wrote:
> On Fri, 20 May 2011 09:18:49 +0200
> timothy <timboyle at afrihost.co.za> wrote:
> 
> <snip> 
> > Ar first glance OFX investing appears not to cater for categories and
> > sub-categories and does not appear to be able to transfer the
> > proceeds of Sells or Dividends to another (cheque) account?
> > 
> <snip>
>  
> > Perhaps I should explain that I have organised my account structure
> > with generic top level asset "dummy"accounts such as Banks Accounts;
> > Money Markets; Retirement etc. Each one of these may contain several
> > relevant investment or checking accounts with their corresponding
> > investments.
> > 
> > Any light on this matter would be appreciated.
> > 
> > Timothy 
> 
> I've had a bit of a look at this problem but haven't as yet determined
> the cause.  However, I wonder if this might be of use.
> 
> If you create an investment called, say, stock, and in the wizard,
> specify  to set up a brokerage account, then when you buy/sell, or
> receive a dividend, that account will be used for the monies.
> 
> Now, when setting
>  up those two accounts, edit the brokerage account and
> in the hierarchy, select the top-level asset account you created.  I've
> just tested this, imported investments into 'stock', and the monies go
> into asset:stock (Brokerage).  There is no need for the 'L' record in
> the QIF file.  The inv investment account doesn't need to be in the
> same asset: top-level account, but that too can be homed
> there.  You will get a warning of 'no name' but then get the usual
> account selection wizard, and all goes OK.
> 
> Allan


Hi Allan

That is an interesting manoeuvre, but in real life the money does go to
the cheque account. What I was doing manually was a Sell in the
investment which put the money into the brokerage and then a transfer
from the brokerage to the cheque. This is done on a monthly basis across
several accounts and I need the monies in a central cheque account

Doing it via the L option in the QIF saves the bloat of intermediate
transactions and puts the money directly where it has to be to balance
the books and to pay for living expenses.

Actually it is more complicated than that. As I mentioned earlier, I
create a monthly report for tax purposes based on accounts and
categories. Unfortunately if one uses categories to create the report
one cannot record transfers. So, in fact, I have to  do an extra payment
and deposit in each brokerage to get these taxable transactions shown in
the report. I will create a wish on this issue at some time.

My financial doings are a bit involved and required a lot of manual
input and editing to get the reports for further processing and
analysis. Using the QIF's is my attempt to automate these laborious,
error-prone, manual, repetitive transactions.

Your interest and suggestions are greatly appreciated.

Timothy




> _______________________________________________