On 04-06-2016 16:01:38, Martin Blais wrote: > I just installed skrooge and tried an export. > It looks like single-entry accounting in a CSV file. > Should be straightforward to convert. > Let me know what doesn't work and I'm sure I could help. >
Wow, thanks for the support and sorry I didn't answer in time, I'm currently
suffering from a cold.
So here's some sample data, including the CSV header (see attachement).
Note: as said, I track my money really precisely, so, as you can see from the
sample data, I track every drink I have and so on.
The first four lines are the "open" lines. "Konto4" is my Cash in this case
here.
I tried to script the import several times, grouping by date and account, but I
failed most of the time because of several points.
One I can think of right now is: When doing a transaction from one account to
another, this is done with two transactions in skrooge (you can type the things
one time, but it will create two transactions): You can see this in line 5 and 6
(with comments "Moved"). You can also easily see that lines 7-9 do not balance
properly. I don't know why this is.
Other problems were non-balancing transactions.
I tried to convert like this:
1. Group the transactions from skrooge by
1. Date
2. Account
2. For each transaction
1. generate the account name ( {Income, Expenses}:<category, transformed to
colon-syntax of beancount>)
2. Make accounts unique
3. open the accounts
4. generate the transaction from {Income, Expenses}:<category> to <account>
I ended up with the problems listed above.
--
Mit freundlichen Grüßen,
Kind regards,
Matthias Beyer
Proudly sent with mutt.
Happily signed with gnupg.
--
You received this message because you are subscribed to the Google Groups
"Beancount" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/beancount/20160605145512.GA12724%40lucy.
For more options, visit https://groups.google.com/d/optout.
"date" ; "account" ; "number" ; "mode" ; "payee" ; "comment" ; "quantity" ; "unit" ; "amount" ; "sign" ; "category" ; "status" ; "bookmarked" ; "id" ; "idtransaction" ; "idgroup" "0000-00-00" ; "Konto1" ; "0" ; "" ; "" ; "" ; "914.44" ; "€" ; "914.44" ; "+" ; "" ; "Y" ; "N" ; "322" ; "322" ; "0" "0000-00-00" ; "Konto2" ; "0" ; "" ; "" ; "" ; "71.16" ; "€" ; "71.16" ; "+" ; "" ; "Y" ; "N" ; "339" ; "339" ; "0" "0000-00-00" ; "Konto3" ; "0" ; "" ; "" ; "" ; "0" ; "€" ; "0" ; "" ; "" ; "Y" ; "N" ; "499" ; "487" ; "0" "0000-00-00" ; "Konto4" ; "0" ; "" ; "" ; "" ; "-1231.7" ; "€" ; "-1231.7" ; "-" ; "" ; "Y" ; "N" ; "882" ; "800" ; "0" "2011-05-30" ; "Konto1" ; "0" ; "" ; "" ; "Moved" ; "-50" ; "€" ; "-50" ; "-" ; "MovingMoney" ; "P" ; "N" ; "323" ; "323" ; "1" "2011-05-30" ; "Konto2" ; "0" ; "" ; "" ; "Moved" ; "50" ; "€" ; "50" ; "+" ; "MovingMoney" ; "P" ; "N" ; "324" ; "324" ; "1" "2011-05-30" ; "Konto1" ; "0" ; "" ; "" ; "Moved" ; "-50" ; "€" ; "-50" ; "-" ; "MovingMoney" ; "P" ; "N" ; "325" ; "325" ; "2" "2011-05-30" ; "Konto2" ; "0" ; "" ; "" ; "For worse times" ; "-50" ; "€" ; "-50" ; "-" ; "MovingMoney" ; "P" ; "N" ; "327" ; "327" ; "3" "2011-05-30" ; "Konto1" ; "0" ; "" ; "" ; "For worse times" ; "50" ; "€" ; "50" ; "+" ; "MovingMoney" ; "P" ; "N" ; "328" ; "328" ; "3" "2011-06-15" ; "Konto2" ; "0" ; "" ; "" ; "Employer" ; "44.52" ; "€" ; "44.52" ; "+" ; "Paycheck" ; "P" ; "N" ; "329" ; "329" ; "0" "2011-06-17" ; "Konto2" ; "0" ; "" ; "" ; "Getting cash" ; "-30" ; "€" ; "-30" ; "-" ; "GettingCash" ; "P" ; "N" ; "330" ; "330" ; "15" "2011-06-17" ; "Konto4" ; "0" ; "" ; "" ; "" ; "30" ; "€" ; "30" ; "+" ; "" ; "P" ; "N" ; "452" ; "447" ; "15" "2011-06-30" ; "Konto2" ; "0" ; "" ; "" ; "For Birthday" ; "60" ; "€" ; "60" ; "+" ; "GettingCash" ; "P" ; "N" ; "331" ; "331" ; "0" "2016-05-23" ; "Konto4" ; "0" ; "" ; "Store" ; "" ; "-0.9" ; "€" ; "-0.9" ; "-" ; "Food > Drinks > Energydrinks > Cola" ; "P" ; "N" ; "7354" ; "3249" ; "0" "2016-05-23" ; "Konto4" ; "0" ; "" ; "Store" ; "" ; "-1.14" ; "€" ; "-1.14" ; "-" ; "Food > Drinks > Water" ; "P" ; "N" ; "7355" ; "3249" ; "0" "2016-05-23" ; "Konto4" ; "0" ; "" ; "Store" ; "" ; "-1.58" ; "€" ; "-1.58" ; "-" ; "Food > Drinks > Return" ; "P" ; "N" ; "7356" ; "3249" ; "0" "2016-05-23" ; "Konto4" ; "0" ; "" ; "Store" ; "" ; "3.46" ; "€" ; "3.46" ; "+" ; "Food > Drinks > Return" ; "P" ; "N" ; "7357" ; "3249" ; "0" "2016-05-23" ; "Konto4" ; "0" ; "" ; "Store" ; "" ; "-2.49" ; "€" ; "-2.49" ; "-" ; "Food > Meat" ; "P" ; "N" ; "7359" ; "3250" ; "0" "2016-05-23" ; "Konto4" ; "0" ; "" ; "Store" ; "" ; "-1.49" ; "€" ; "-1.49" ; "-" ; "Food > Fastfood > McD" ; "P" ; "N" ; "7360" ; "3250" ; "0" "2016-05-23" ; "Konto4" ; "0" ; "" ; "Subway" ; "" ; "-4.3" ; "€" ; "-4.3" ; "-" ; "Food > Fastfood > Subway" ; "P" ; "N" ; "7370" ; "3255" ; "0" "2016-05-23" ; "Konto4" ; "0" ; "" ; "Store" ; "" ; "-1.78" ; "€" ; "-1.78" ; "-" ; "Food > Bread" ; "P" ; "N" ; "7371" ; "3256" ; "0" "2016-05-24" ; "Konto4" ; "0" ; "" ; "Store" ; "" ; "-3" ; "€" ; "-3" ; "-" ; "Food > Fastfood > Meat" ; "P" ; "N" ; "7362" ; "3251" ; "0" "2016-05-24" ; "Konto4" ; "0" ; "" ; "Store" ; "" ; "1.75" ; "€" ; "1.75" ; "+" ; "Food > Dinks > Return" ; "P" ; "N" ; "7363" ; "3251" ; "0" "2016-05-24" ; "Konto4" ; "0" ; "" ; "Post" ; "" ; "-0.9" ; "€" ; "-0.9" ; "-" ; "Etc > Stamps" ; "P" ; "N" ; "7368" ; "3253" ; "0"
signature.asc
Description: PGP signature
