2016-06-16 GnuCash IRC logs

00:39:14 *** minot has quit IRC
00:48:10 *** Mechtilde has joined #gnucash
01:12:34 *** Mechtilde has quit IRC
02:22:10 *** goodvibes has joined #gnucash
02:28:53 *** gjanssens has joined #gnucash
02:28:53 *** ChanServ sets mode: +o gjanssens
02:56:56 *** goodvibes has quit IRC
03:31:05 *** nomeata has joined #gnucash
03:46:45 *** rubdos has quit IRC
03:47:33 *** rubdos has joined #gnucash
04:20:42 *** fabior has joined #gnucash
05:26:09 *** rubdos has quit IRC
07:30:30 *** aqua___ has joined #gnucash
07:33:36 *** aqua___ has quit IRC
07:39:52 *** harski has quit IRC
07:46:55 *** fabior has quit IRC
07:47:24 *** aqua___ has joined #gnucash
08:14:38 *** rubdos has joined #gnucash
08:38:40 *** andy has quit IRC
08:49:28 *** andy has joined #gnucash
09:05:44 *** fabior has joined #gnucash
10:02:27 *** aqua___ has quit IRC
10:10:34 *** nomeata has quit IRC
10:18:24 *** aqua___ has joined #gnucash
10:21:21 *** gjanssens has quit IRC
10:22:54 *** gjanssens has joined #gnucash
10:22:54 *** ChanServ sets mode: +o gjanssens
10:54:58 *** lwells has joined #gnucash
10:56:57 *** andy has quit IRC
10:58:45 *** mlncn has quit IRC
11:11:26 *** exedore6 has joined #gnucash
11:12:04 <exedore6> I’m trying to figure something out. I’ve got gnucash setup to import my accounts from my bank, but when I do it, it gets doubled up. What’s going on?
11:23:17 *** mlncn has joined #gnucash
11:34:48 *** minot has joined #gnucash
11:38:20 *** mlncn has quit IRC
11:38:34 *** GabrieleV has quit IRC
11:38:35 *** mlncn has joined #gnucash
11:42:03 *** GabrieleV has joined #gnucash
11:42:19 <warlord> exedore6: what do you mean "doubled up"?
11:42:31 <exedore6> I think I’ve figured it out.
11:42:47 <exedore6> It’s like I imported it twice (when I only did it once)
11:43:06 <exedore6> I think it’s because I said yes to reconciling the account, before the transactions were imported.
11:43:11 <exedore6> Importing them twice.
11:44:24 <exedore6> No, that’s not it.
11:45:20 <exedore6> This is my first time using aqbanking to get entries in.
11:45:34 <exedore6> I’m trying with an empty account now.
11:45:54 <warlord> exedore6: did you perhaps assign the local account as the expense account during the import? I.e., does each transaction appear in both left and right columns?
11:46:18 <exedore6> Maybe.
11:46:29 <warlord> (perhaps a screenshot on imagebin would help show what you're seeing)
11:46:46 <exedore6> So there’s an account that I set up when I run the wizard. And then it asks again when I actually import.
11:46:56 <exedore6> Should they be different accounts?
11:52:42 <warlord> Maybe. Maybe not. It depends on what account you set up ahead of time. But you still need to assign each transaction to the correct "other" account (i.e., income/expense)
11:53:05 <warlord> This is the core of double-entry accounting... Each transaction touches at least 2 accounts, the credit account and the debit account.
11:53:12 <exedore6> I understand that.
11:53:25 <exedore6> My trouble is, I’m getting both in the same account.
11:53:30 <warlord> When you import transactions you're generally touching the Asset and/or Liability.. But you need to then attach the "other" side.
11:53:48 <exedore6> I’ve been fine doing things manually.
11:54:20 <exedore6> Buying groceries is a debit from my checking account, and a matching credit to my Expenses:Groceries
11:54:28 <warlord> If the "other" side is being attached to the "current" account, then you're doing it wrong; you've ether assigned it in the importer transaction matcher (which is wrong), or after-the-fact you moved it from Imabalance to the Asset/Liability, which is also wrong.
11:54:58 <exedore6> I suspect that the online import process is congising me.
11:54:58 <warlord> No, it's a CREDIT to your checking and DEBIT to Expenses:Groceries... But you're correct that it's touching both accounts.
11:55:17 <warlord> could be.
11:55:28 <warlord> This is OFX import?
11:55:54 <exedore6> It’s a direct connect.
11:56:04 <exedore6> I’ve done the download/import process fine.
11:57:16 <warlord> And right after that are your transactions mis-assigned? Or do they all go from Asset -> Imbalance? Or...???
11:57:35 <exedore6> I do the direct connect.
11:57:37 *** Mechtilde has joined #gnucash
11:57:50 <exedore6> I tell it “Yes, I want to include the balance information'
11:57:58 <exedore6> “No I do not want to reconcile it now”
11:58:12 <exedore6> Then I can look at the generic import tool.
11:58:37 <warlord> Okay. That's fine so far.
11:58:47 <warlord> Then what do you do with the generic import tool?
11:58:47 <exedore6> Say I do nothing, which I would expect to put all of the transactions in the account, and the matching side is in imbalance.
11:59:04 <warlord> Correct, unless you've previously assigned them somewhere.
11:59:15 <exedore6> Right.
11:59:38 <exedore6> But when I’m done, I have a checking account with multiple entries.
11:59:54 <exedore6> As if the data contains two records.
11:59:54 <warlord> and nothing in Imbalance?
12:00:02 <exedore6> The imbalznce also has doubles.
12:00:25 <warlord> Can you please take a screen shot (or two) and post it to imagebin so I can see?
12:00:42 <exedore6> I’m trying to figure out how without showing too much.
12:00:52 <exedore6> I’ve gotta go for a bit. Will be back later.
12:03:13 <warlord> okay
12:06:14 *** rubdos has quit IRC
12:13:56 *** fabior has quit IRC
12:16:38 *** fabior has joined #gnucash
12:38:32 *** Mechtilde has quit IRC
12:41:07 *** mlncn has quit IRC
12:55:43 <exedore6> Looks like imagebin’s down.
12:55:47 <exedore6> Here’s a dropbox link.
12:55:49 <exedore6> https://www.dropbox.com/sh/oftszuto2siq22r/AAA5gkgpyugR1BBuYPi1MPUSa?dl=0
12:57:06 <exedore6> They look like they’re of the same account, but one is from the Bank Account (Type Bank), the other (named gnucash2) is from Imbalance-USD
12:57:55 <exedore6> All of those doubles should be single items.
12:58:28 <exedore6> It’s as if the data dump is pulling two.
12:58:35 <exedore6> Or it’s running it twice (somehow)
12:59:13 <warlord> That really seems to imply there ARE two entries in the OFX file.
13:00:10 *** Mechtilde has joined #gnucash
13:03:33 *** Mechtilde has quit IRC
13:05:10 <exedore6> Okay.
13:05:18 <exedore6> This is the automatically downloaded one.
13:05:48 <exedore6> If I go into the bank and manually download and import it, it imports correctly (but it looks like I’ll have to deal with the overlaps)
13:06:13 <exedore6> So I suspect that it’s the importer, or my remote setup.
13:06:19 <exedore6> As if the parser is being dumb.
13:06:47 *** minot has quit IRC
13:22:01 *** mlncn has joined #gnucash
13:25:51 <warlord> Are you downlloading QIF or OFX?
13:26:48 <warlord> (when you download manually)
13:28:30 *** minot has joined #gnucash
13:30:53 <exedore6> qif
13:32:47 <warlord> Ah, okay. So yeah, QIF is.. different.
13:32:58 <warlord> It doesn't have the same duplicate detection that you have from OFX.
13:33:06 <exedore6> Yes.
13:33:24 <warlord> But it also sounds like the bank is sending you duplicate transactions. You could turn on the OFX logging to get it to save the OFX file ...
13:33:28 <exedore6> So I can’t use it easily, ongoing.
13:34:05 <exedore6> Where’s that setting?
13:39:48 <warlord> I think it's an environment variable you have to set before you start gnucash. I dont recall offhand.
13:40:15 <warlord> You can use QIF ongoing -- but it works better if you can ensure that you dont download overlapping timeframes.
13:53:39 *** fabior has quit IRC
14:16:42 <exedore6> That’s the plan until I figure this issue out.
14:16:45 <exedore6> Thanks anyway.
14:22:27 *** exedore6 has quit IRC
14:28:11 <jralls> lmat: Are you working on changing GncGUID from is-a boost::uuids::uuid to has-a? Not necessarily right now, of course.
14:37:10 *** mlncn has quit IRC
14:37:19 *** mlncn has joined #gnucash
14:40:47 *** mlncn has quit IRC
14:59:34 *** mlncn has joined #gnucash
15:57:11 *** mlncn has quit IRC
15:57:43 *** fabior has joined #gnucash
16:30:10 *** mlncn has joined #gnucash
16:42:07 *** gjanssens has quit IRC
16:47:07 *** minot has quit IRC
16:51:33 *** aqua___ has quit IRC
17:25:14 *** fabior has quit IRC
20:38:12 *** andy has joined #gnucash
21:22:56 *** mlncn has quit IRC
22:12:16 *** andy has quit IRC
22:12:18 *** andy_ has joined #gnucash
22:17:52 *** mlncn has joined #gnucash
23:49:32 *** g5pw has quit IRC
23:54:12 *** g5pw has joined #gnucash