2015-06-10 GnuCash IRC logs

00:15:12 *** warlord has quit IRC
00:18:35 *** warlord has joined #gnucash
00:18:36 *** gncbot sets mode: +o warlord
01:09:08 *** MechtiIde has joined #gnucash
01:15:45 *** warlord has quit IRC
01:16:53 *** warlord has joined #gnucash
01:16:54 *** gncbot sets mode: +o warlord
01:30:56 *** O01eg has quit IRC
01:38:03 *** lwells has quit IRC
01:41:06 *** lwells has joined #gnucash
01:46:12 *** ErKa has quit IRC
01:48:30 *** MechtiIde has quit IRC
01:49:44 *** s_p_or_t_o has joined #gnucash
01:52:26 <s_p_or_t_o> i did the imports of qbo files from my bank, but i discovered the deposit and withdraw columns are swapped. any advise on how to correct it?
02:01:29 <s_p_or_t_o> everything is red except the stuff red was in the black :p i see the ubuntu repo has 2.6.1, i'll look into 2.6.6
02:24:55 *** StuM has quit IRC
03:00:54 *** warlord has quit IRC
03:21:54 *** gjanssens has joined #gnucash
03:21:54 *** ChanServ sets mode: +o gjanssens
03:30:55 *** fabior has joined #gnucash
03:35:22 *** Gbarr has quit IRC
04:37:34 *** uXus has quit IRC
04:39:57 *** uXus has joined #gnucash
05:08:34 *** fabior has quit IRC
05:09:58 *** fabior has joined #gnucash
05:33:59 *** aqua___ has joined #gnucash
05:47:02 *** uXus has quit IRC
05:47:21 *** uXus has joined #gnucash
05:59:26 *** pacon has joined #gnucash
06:23:16 *** StuM has joined #gnucash
06:24:42 *** aqua___ has quit IRC
06:26:31 *** StuM has quit IRC
06:26:45 *** himaxx has joined #gnucash
06:28:43 *** himaxx has quit IRC
06:43:44 *** himaxx has joined #gnucash
06:55:14 *** Jimraehl1 has joined #gnucash
06:56:48 *** aqua___ has joined #gnucash
07:00:15 *** storyjesse has joined #gnucash
07:02:16 *** aqua___ has quit IRC
07:12:41 *** fabior has quit IRC
07:15:39 *** StuM has joined #gnucash
07:17:08 *** Gbarr has joined #gnucash
07:25:06 *** himaxx has quit IRC
07:50:42 *** himaxx has joined #gnucash
07:51:03 *** fabior has joined #gnucash
07:51:06 *** himaxx has quit IRC
07:52:56 *** pacon has quit IRC
07:55:52 *** storyjesse has joined #gnucash
08:10:19 *** andy has quit IRC
08:13:59 *** warlord has joined #gnucash
08:14:00 *** gncbot sets mode: +o warlord
08:17:22 *** andy has joined #gnucash
08:17:32 <warlord> s_p_or_t_o: not sure what "qbo" is. Is this QIF or OFX?
08:18:29 <warlord> jralls: Why am I not surprised?
09:00:17 *** mlncn has joined #gnucash
09:24:15 *** rickoehn has joined #gnucash
10:25:34 <s_p_or_t_o> warlord: OFX
10:27:59 <s_p_or_t_o> the file extension is qbo, but it's OFX when I open it with gedit
10:28:32 <warlord> Hmm... If the OFX is coming in backwards then the bank is violating the spec.. Or your "reverse accounts" preference is set wrong.
10:29:15 <warlord> You can check which by manually entering a transaction from e.g. your Bank account to an expense and seeing how it affects the expense..
10:29:36 <s_p_or_t_o> revs. accounts pref? how do I rule that out?
10:30:12 <warlord> The other possibility is that you imported your transactions into the wrong account (imported into the expense instead of the asset)
10:30:36 <warlord> Check Edit -> Preferences
10:31:12 <warlord> Then look on the Accounts page, and check the Reverse Balanced Accounts
10:31:32 <warlord> But if ALL accounts are wrong (both asset and expense) then it's more likely the data was bad.
10:32:19 <s_p_or_t_o> it's set to credit accounts
10:32:31 <warlord> Okay, that's the correct setting.
10:32:38 <warlord> So most likely the data *is* backwards..
10:32:58 <warlord> So either it was imported to the wrong place... or your bank's OFX violates the OFX Spec
10:35:02 <s_p_or_t_o> ok, that's a good place for be to troubleshoot. is there a way to correct the data? like export to a file and flip a column or value?
10:36:14 <warlord> I'd suggest you fix the data before you import it.
10:36:32 <warlord> Fixing it in gnucash...... you're better off reverting to a backup file before the import (or starting over)
10:40:01 *** ErKa has joined #gnucash
10:40:12 <s_p_or_t_o> not fun. it was my initial setup, so no backup file. i completed setting up since Jan 1st before noticing by my income listing as a negative number
10:40:26 <s_p_or_t_o> i'm hoping i just imported wrong
10:41:09 <s_p_or_t_o> i'll take the opportunity to wipe it, update it to 2.6.6 and reimport
10:41:17 <warlord> You might be best off starting over... Often it can take a while to get the imports "correct"
10:41:37 <s_p_or_t_o> yup, that you so much warlord
10:41:42 <s_p_or_t_o> thank ^
10:41:43 <s_p_or_t_o> lol
10:41:48 <warlord> You're welcome
11:05:40 *** s_p_or_t_o has quit IRC
11:15:13 *** josePHPagoda has joined #gnucash
11:20:29 *** MechtiIde has joined #gnucash
11:34:25 *** uXus has quit IRC
11:36:39 *** uXus has joined #gnucash
11:42:20 *** StuM has quit IRC
12:00:48 *** storyjesse has quit IRC
12:28:35 *** O01eg has joined #gnucash
12:32:48 *** himaxx has joined #gnucash
12:39:05 *** himaxx has quit IRC
12:41:46 *** mlncn has quit IRC
12:58:02 *** mlncn has joined #gnucash
12:59:15 *** cigarshark has joined #gnucash
12:59:47 *** cigarshark has quit IRC
13:00:19 *** StuM has joined #gnucash
13:00:32 *** ErKa has quit IRC
13:06:47 <gjanssens> jralls: I haven't had the chance to look into https://bugzilla.gnome.org/show_bug.cgi?id=746792
13:06:57 <gjanssens> I'll see if I can find some time later this week
13:07:13 <gjanssens> Busy times...
13:14:33 *** andy has quit IRC
13:19:08 *** jimvideo has joined #gnucash
13:23:12 *** andy has joined #gnucash
13:34:39 <jralls> gjanssens: I guessed you must be pretty busy lately. It's about time for your family vacation, isn't it?
13:35:28 <gjanssens> jralls: yes, that starts the second week of July
13:36:30 <jralls> gjanssens: Anyway, it looks to me like the invoice code might be pointing the Transfer Dialog at the wrong account.
13:37:34 <jralls> That's based on the description of what's happening in comment #2. Did you see dgtlmoon's workaround yesterday?
13:45:55 *** StuM has quit IRC
13:53:48 *** fabior has quit IRC
14:39:55 *** ErnstNeger has joined #gnucash
14:40:25 *** ErnstNeger has quit IRC
15:01:29 *** fabior has joined #gnucash
15:24:10 *** MechtiIde has quit IRC
15:35:03 *** mlncn has quit IRC
16:08:12 *** jimvideo has quit IRC
16:09:44 *** jimvideo has joined #gnucash
16:12:20 *** jimvideo_again has joined #gnucash
16:13:26 *** jimvideo has quit IRC
16:14:36 *** daum has joined #gnucash
16:14:47 <daum> hey guys - is there a way to look at where a payment for an invoice was processed to?
16:14:56 <daum> i seem to have processed a payment and can't find where it went haha
16:18:00 *** jimvideo_again has quit IRC
16:18:46 <daum> nevermind searched across everything for the description of the company and found them....by mistaked posted it to imbalanced usd ha
16:19:35 *** jimvideo has joined #gnucash
16:28:12 *** warlord has quit IRC
16:43:56 *** StuM has joined #gnucash
16:44:33 *** dgm has quit IRC
16:45:02 *** rubdos has quit IRC
16:58:04 *** StuM has quit IRC
17:20:06 <dgtlmoon> jralls, i should write up some tute's if it helps
17:26:16 <jralls> dgtlmoon: It would be better to fix the bug, but if you haven't already please add your workaround to it. That may help gjanssens figure out the problem.
17:30:27 <dgtlmoon> gjanssens, my work around was to add subaccounts at each 'account' level for every currency i had to deal with
17:30:48 <dgtlmoon> ie A:R:Euro, A:R:Aud etc
17:30:55 <dgtlmoon> and then sales:Euro etc tec
17:34:33 *** mlncn_ has joined #gnucash
17:39:36 *** gjanssens has quit IRC
17:40:17 *** jethrogb has quit IRC
17:45:11 <jralls> dgtlmoon: Do you use trading accounts?
18:01:48 *** fabior has quit IRC
18:19:06 *** rickoehn has quit IRC
18:22:00 *** jimvideo has quit IRC
18:33:15 *** mlncn_ has quit IRC
18:43:56 *** jethrogb has joined #gnucash
18:55:48 *** mlncn_ has joined #gnucash
19:58:28 *** himaxx has joined #gnucash
20:00:44 *** himaxx has quit IRC
20:22:30 *** fell_ has quit IRC
20:22:45 *** fell_ has joined #gnucash
20:55:33 *** StuM has joined #gnucash
20:58:41 *** StuM has quit IRC
20:59:16 *** mlncn_ has quit IRC
22:04:58 *** fell__ has joined #gnucash
22:07:24 *** fell_ has quit IRC
22:29:56 *** storyjesse has joined #gnucash
22:44:19 *** jimvideo has joined #gnucash
22:59:28 *** Coderjoe has quit IRC
23:02:28 *** Coderjoe has joined #gnucash
23:19:22 *** warlord has joined #gnucash
23:19:22 *** gncbot sets mode: +o warlord