Double entry accounting with "double entry statement import"

[Anthony Dardis]

Two thoughts:

a) I assume that the statement OFX files can't be connected. That would be  
the best solution.

b) If they can't be connected, then you could either

	b.1) pick the account that has the most information (for example, the  
most complete set of transfer accounts), import that, then go through all  
the transactions by hand and make the other side correct as well;
	b.2) import both, then pick the account that has the least information,  
delete all those transactions, then adjust the rest by hand.






On Tue, 13 Jul 2010 08:22:24 -0400, Paweł Zając <pavzaj at gmail.com> wrote:

>  I am absolutely fresh to accounting, and maybe my English isn't goog  
> enough
> to explain my problem. I'll try to explain what I do:
>
>
>    1. I download statements from my checking and savings accounts  
> (separate
>    OFX files)
>       1. In my checking account statement I have following transactions:
>          1. 2010-06-02 "Money  from Mr. Smith" 500 units
>          2. 2010-06-02 "Money out to saving account" - 500 units (minus)
>       2. In savings account statement  I have:
>          1. 2010-06-02 "Money in to saving account"  500 units  
> (corresponds
>          to transaction 2 in checking account)
>       2. I impotrt these statements to gnucash and I have:
>       1. Checking
>          1. 2010-06-02 "Money  from Mr. Smith" |Transfer:Imbalance
>          |Deposit:500 |Withdrawal:_
>          2. 2010-06-02 "Money out to saving account" |Transfer:Imbalance
>          |Deposit:_ |Withdrawal:500
>       2. Saving
>          1. 2010-06-02 "Money in to saving account" |Transfer:Imbalance
>          |Deposit:500 |Withdrawal:_
>       3. I try to do the accounting register and I set transaction 2 form
>    Checking as a transfer to Saving and so I have:
>       1. Checking
>          1. 2010-06-02 "Money  from Mr. Smith" |Transfer:Imbalance
>          |Deposit:500 |Withdrawal:_
>          2. 2010-06-02 "Money out to saving account" |Transfer:Saving
>          |Deposit:_ |Withdrawal:500
>       2. Saving
>          1. 2010-06-02 "Money in to saving account" |Transfer:Imbalance
>          |Deposit:500 |Withdrawal:_
>          2. 2010-06-02 "Money in to saving account" |Transfer:Checking
>          |Deposit:500 |Withdrawal:_
>
> So I have 500 money units doubled in Savings, account. What should I do  
> to
> make it work? I'd prefer not to type each transaction by hand, but rather
> import them from statements.
>
> Regards
>
> Pawel Zajac
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.